Writing a program in COBOL.

Write the following program using COBOL programming language:

Grade Report

This is a program designed to hit you where you live! This program will compute your current average in a class, the minimum average that you could earn from this point forward, and the maximum average that you can earn. In addition to this, it prints the relative weights of each assignment category.

This program assumes that grades are computed out a fixed pool of points. For example, the course in which you currently find yourself has 1000 points. Your total average is computed by the formula:

grade = (points_earned * 100) / points_possible

So at any given point in the semester, you could compute your current average by totaling the points you have earned and dividing by the possible points on your assignments so far.

The minimum grade is what you would earn if you stopped handing in work. That is, you would forfeit all remaining possible points in the semester (not a good idea, usually!)

The maximum grade is what you would earn if you earned all remaining possible points in the semester.

This program will take as its input the name of a file. The file is a flat-format file of the following form:

The total number of points for the entire semester on a line by itself.

Zero or more assignment records, with each field being a fixed width. The format of these records are as follows:

Assignment Name (20 characters)

Category (20 characters)

Possible Points (14 characters)

Earned Points (14 characters)

Consider the file generated by a student whom we will call “Bill”. Bill has recorded his first few as shown:

1000

MS 1 – Join Grps    Group Project       5             5             

Four Programs       Programming         15            9             

Quiz 1              Quizzes             10            7             

FORTRAN             Programming         25            18            

Quiz 2              Quizzes             10            9             

HW 1 – Looplang     Homework            20            15            

Note that there is no separator between these fields! If they use the full width of the field, they run right up to the next one:

HW 3 – Struct & VarsHomework            20            20            

When Bill runs the program, it generates the following output:

File: Bill

Group Project        (5%)

==================================

MS 1 – Join Grps        5/5   100%

==================================

                        5/5   100%

Homework             (23%)

==================================

HW 1 – Looplang       15/20    75%

==================================

                      15/20    75%

Programming          (47%)

==================================

Four Programs          9/15    60%

FORTRAN               18/25    72%

==================================

                      27/40    67%

Quizzes              (23%)

==================================

Quiz 1                 7/10    70%

Quiz 2                 9/10    90%

==================================

                      16/20    80%

Current Grade: 74%

Minimum Total Grade: 6%

Maximum Total Grade: 97%

Here, neatness counts! Make the output line up in nice neat tables. Also note that category weights are the weight of how much the category counts toward the current average. At the end of the course, these would match the weights in the syllabus. Also, note that while Bill is earning a C, if he buckles down he can still get that A. Perhaps you could use this program to help you in your courses!

The contents of sample data files are given below:

File bill:

1000

MS 1 – Join Grps Group Project 5 5   

Four Programs Programming 15 9   

Quiz 1 Quizzes 10 7   

FORTRAN Programming 25 18

Quiz 2 Quizzes 10 9   

HW 1 – Looplang Homework 20 15

File cs-390 assignments:

1000

MS 1 – Join Grps Group Project 5 0   

Four Programs Programming 15 0   

Quiz 1 Quizzes 10 0   

FORTRAN Programming 25 0   

Quiz 2 Quizzes 10 0   

HW 1 – Looplang Homework 20 0   

COBOL Programming 25 0   

Quiz 3 Quizzes 10 0   

Mid Mid 200 0   

HW 2 – LL Enhanced Homework 20 0   

ALGOL 68 Programming 25 0   

MS 2 – Descr. Lang. Group Project 50 0   

HW 3 – Struct & VarsHomework 20 0   

Lua Programming 25 0   

Quiz 4 Quizzes 10 0   

HW 4 – Variable Typ.Homework 20 0   

MS 3 – Example ProgsGroup Project 45 0   

JavaScript Programming 25 0   

Quiz 5 Quizzes 10 0   

HW 5 – Smalltalk Homework 20 0   

MS 4 – Interpreter Group Project 100 0   

Ms 5 – Presentation Group Project 50 0   

Scheme Programming 25 0   

Quiz 6 Quizzes 10 0   

Prolog Programming 25 0   

Final Final test 200 0

edit excel attachment…. due today…….

this assignment is due today…… 6 hours to do…… 

You are only editing the excel attachment

__________________________________________________________________________

Edit the excel attachment by doing the following steps: 

  1. Open the start file EX2019-SkillReview-1-1. The file will be renamed automatically to include your name. Change the file name if directed to do so by your instructor, and save it.
  2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.
  3. Explore the workbook. If you accidentally make changes while exploring, press Ctrl + Z to undo the change.
    1. Click the worksheet tab labeled Stevens Hours.
    2. If necessary, use the vertical scroll bar to scroll down so you can see both weeks of billable hours. (If necessary, use the vertical scroll bar again to return to the top of the worksheet.)
    3. Click cell B2 (the cell displaying the staff member’s last name, Stevens). This is the cell at the intersection of column B and row 2.
      1. Note that the column B and row 2 selector boxes highlight.
      2. Note that the status bar displays Ready, indicating that you are in Ready mode.
      3. On the Home tab, in the Number group, look at the Number Format box at the top of the group. Note that the format for this cell is General.
      4. Double-click cell B2 to switch to Edit mode. Note that the status bar now displays Edit, and the blinking cursor appears within the cell. If you needed to, you could edit the text directly in the cell.
    4. Press Esc to exit Edit mode and return to Ready mode.
    5. Press Enter twice to move to cell B4 (the cell displaying the staff member’s billable rate). This cell is formatted with the Accounting Number Format number format.
      1. Look in the Number Format box and note that the format for this cell is Accounting.
      2. On the Home tab, in the Styles group, look in the Cell Styles gallery, and note that the cell style Currency is highlighted. (If the Cell Styles gallery is collapsed on your Ribbon, click the Cell Styles button to display it.)
    6. Click cell B8 (the cell displaying the number of hours for Monday, August 5). This cell is formatted with the Comma cell style.
      1. Look in the Number Format box and note that the format for this cell is also Accounting.
      2. On the Home tab, in the Styles group, look in the Cell Styles gallery, and note that the cell style Comma is highlighted for this cell. (If the Cell Styles gallery is collapsed on your Ribbon, click the Cell Styles button to display it.)
      3. Note the style differences between cell B4 (Accounting Number Format, Currency style) and cell B8 (Accounting Number Format, Comma style).
    7. Click cell B7 (the cell displaying the date 8/5/2019). This cell is formatted using the Short Date format. Note that the Number Format box displays Date.
    8. Double-click cell B14.
      1. Note that the status bar now displays Edit, indicating that you are in Edit mode.
      2. This cell contains a formula to calculate the daily bill for Monday, August 5: =B12*$B$4
      3. Note that cells B12 and B4 are highlighted with colors matching the cell references in the formula.
      4. Note that the reference to cell B4 is an absolute reference ($B$4).
    9. Press Esc to exit Edit mode.
    10. Double-click cell B12.
      1. Note that once again the status bar displays Edit, indicating that you are in Edit mode.
      2. This cell contains a formula using the SUM function to calculate the total billable hours for Monday, August 5: =SUM(B8:B11)
      3. In this case, the SUM function uses a single argument B8:B11 to indicate the range of cells to total.
      4. Note that the cell range B8:B11 is highlighted with the color matching the argument in the SUM function formula.
      5. Note that the reference to the cell range B8:B11 uses relative references.
    11. Press Esc to exit Edit mode.
    12. Press Tab to move to cell C12. Look in the formula bar and note that this cell contains a similar formula to the one in cell B12: =SUM(C8:C11)
    13. Press → to move through cells D12 through H12. Note the formula in the formula bar for each cell.
    14. Did you notice that the cell references in the formulas in cells C12 through H12 all use relative references?
  4. The Stevens Hours worksheet contains a stacked column chart. Review the chart so you can recreate it on the Swinson Hours worksheet.
    1. The stacked column chart to the right of the hours for the week of August 5 represents the hours worked for each client each day.
    2. The column height for each day represents the total hours worked. Each column is divided into segments representing the hours worked for each client.
    3. The number of hours worked is represented on the y axis. The dates are represented along the x axis.
    4. The chart title has been changed to: Week of 8/5/19
  5. Now you are ready to complete the worksheet for David Swinson. Navigate to the Swinson Hours worksheet by clicking the Swinson Hours worksheet tab.
  6. The staff member’s last name is spelled incorrectly. Navigate to cell B2 and edit the text so the last name is spelled correctly (Swinson – with an i instead of an a). Use Edit mode.
    1. Double-click cell B2.
    2. Edit the text to: Swinson
    3. Press Enter to accept your changes.
  7. The billable rate amount is missing. Navigate to cell B4 and enter the rate. Use Ready mode.
    1. Click cell B4.
    2. Type: 180
    3. Press Enter.
  8. Modify the billable rate to use the Accounting Number Format.
    1. Press the ↑ to return to cell B4.
    2. On the Home tab, in the Number group, click the Accounting Number Format button.
  9. The dates are missing from the timesheet. Enter the first date, August 5, 2019.
    1. Click cell B7.
    2. Type: 8/5/2019
    3. Press Enter.
  10. Use Autofill to complete the dates in the timesheet.
    1. Click cell B7.
    2. Click the Fill Handle, and drag to cell H7. Release the mouse button.
  11. Change the date format to the 8/5/2019 format.
    1. The cell range B7:H7 should still be selected. If not, click cell B7, press and hold Shift, click cell H7, and then release the Shift key.
    2. On the Home tab, in the Number group, expand the Number Format list, and click Short Date.
  12. Use the Quick Analysis tool to enter total hours for each day.
    1. Select cells B8:H11. Click cell B8, hold down the left mouse button, and drag the mouse to cell H11. Release the mouse button. The cell range B8 through H11 should now appear selected.
    2. The Quick Analysis tool button should appear near the lower right corner of the selected cell range. (If the Quick Analysis tool button is not visible, move your mouse cursor over the selected cell range again, without clicking. This action should make the button appear.)
    3. Click the Quick Analysis tool button, and then click Totals.
    4. Click Sum (the first option).
  13. Format the hours billed section to use the Comma Style number format. Be sure to include the total row.
    1. Select cells B8:H12. Try another method: Click cell B8, press and hold Shift, click cell H12, and release the Shift key.
    2. On the Home tab, in the Number group, click the Comma Style button.
  14. Enter a formula in cell B14 to calculate the daily bill for Monday, August 5. The formula should calculate the total billable hours for the day (cell B12) times the billable rate (B4).
    1. Click cell B14.
    2. Type: =
    3. Click cell B12.
    4. Type: *
    5. Click cell B4.
    6. Press F4 to change the cell reference B4 to an absolute reference ($B$4).
    7. Press Enter.
    8. The formula should look like this: =B12*$B$4
  15. Use AutoFill to copy the formula to the remaining days in the timesheet.
    1. Click cell B14 again.
    2. Click the AutoFill handle. Hold down the left mouse button and drag to cell H14. Release the mouse button.
    3. The formulas in cells B14 through H14 should look like this.
      Table displays the relative and absolute references for the remaining days in the timesheet.BCDEFGH14=B12*$B$4=C12*$B$4=D12*$B$4=E12*$B$4=F12*$B$4=G12*$B$4=H12*$B$4Notice that when the AutoFill copied the formula, it updated the relative reference (B12) to reflect the new column position, but it did not change the absolute reference ($B$4).

  16. Now you can calculate the bill total for the week by summing the daily bill amounts. Enter a formula using the SUM function with the cell range B14:H14 as the argument.
    1. Click cell B15.
    2. Type: =SUM(B14:H14)
    3. Press Enter.
  17. Use the Recommended Charts feature to insert a stacked column chart representing hours worked for each day for the week of August 5.
    1. Select cells A7:H11. Click cell A7, hold down the left mouse button, and drag the mouse to cell H11. Release the mouse button. The cell range A7 through H11 should now appear selected.
    2. The Quick Analysis tool button should appear near the lower right corner of the selected cell range. (If the Quick Analysis tool button is not visible, move your mouse cursor over the selected cell range again, without clicking. This action should make the button appear.)
    3. Click the Quick Analysis tool button, and then click Charts.
    4. Click Stacked Column to insert a stacked column chart.
  18. Change the chart title.
    1. Click the Chart Title placeholder once to select it.
    2. Type: Week of 8/5/2019
    3. Press Enter.
  19. Preview how the worksheet will look when printed.
    1. Click cell A1 to deselect the chart.
    2. Click the File tab to open Backstage view.
    3. Click Print to display the print preview.
    4. Click the left arrow to close the Backstage view.
  20. Save and close the workbook.

Response Required Discussion cloud DBA

Please read the below two discussion posts and provide the response for each discussion in 75 to 100 words.

 Post#1

Nowadays, there are numerous advancements in technology. As a result, the traditional workplace has gradually transformed with home offices and virtual workplaces where employees can hold meetings using video teleconferencing tools and communicate through email and other applications such as Slack (Montrief, et al., 2020). This makes the cloud more busy which brings up the need for improved cloud security.

            Generally, in a public cloud, there exists a shared responsibility between the user and the Cloud Service Provider (CSP). Due to the rise of cyber-related crimes over the years, security for things like data classification, network controls and physical security need clear owners. The division of such responsibilities is called shared responsibility model for cloud security. “According to Amazon Web Services (AWS), security responsibility is shared by both CSP and CSC and they called it as Shared Security Responsible Model” (Kumar, Raj, & Jelciana, 2018). “While client and endpoint protection, identity and access management and application level controls are a shared responsibility the responsibility resides largely with the client organization” (Lane, Shrestha, & Ali, 2017). However, the responsibilities may vary depending on the cloud service provider and the cloud environment the user is using to operate. Nevertheless, despite the cloud services used, the burden of protecting data lays upon the user.

            Normally, security is broken down into two broad categories: security of the cloud and security in the cloud. Security of the cloud is a section of the shared responsibility model handled by the cloud service provider. It comprises of hardware, host operating systems and physical security of the infrastructure. Most of these logistical challenges are offloaded when an organization moves its operations to the cloud. In contrast, security in the cloud is the security responsibility handled by the user. “The cloud service customer is responsible for securing and managing the applications that run in the cloud, the operating systems, data-at-rest, data-in-transit, policies and other responsibilities” (Bennett & Robertson, 2019). Since access to customer data remains the most critical component in cloud computing, it also determined the level of security in the cloud to be implemented by the customer.

            The customer is responsible for the following components. First, the customer is responsible for data security. While the provider is responsible for automatically encrypting data in transit and in storage, the customer is expected to configure file system encryption and protection of network traffic. Secondly, the customer is responsible for physical security of computers and other devices used to access the cloud. Thirdly, the customer is responsible for application security. Security of managed applications may be handles by cloud provider services, but the customer is responsible for configuring those services accurately and correctly. Fourthly, the customer is responsible for security hinges on identity and access management in on-premises computing. The cloud provider can implement authentication services but it’s the work of the customer to configure them. Finally, the customer is responsible for network security on-premises.

            The cloud has various advantages such as scalability, elasticity and flexible prices. However, security is remains a critical business concern for many organizations (Xue & Xin, 2016). Regardless of which cloud service provider used, the customer will always be responsible for managing the customer data, analyzing workload, traffic and performance. When implementing cloud projects, customers need to identify and understand the risks associated with digitalization, public networks and outsourcing of infrastructure components. Shared responsibility in cloud computing depends on the agreement that the customer has with the cloud service provider. This is because there are specific tasks that can be logically handled by the customer while other duties are handles by the service provider such as ensuring physical access to the data center is restricted to authorized personnel’s only.

Post#2

 

Cloud offers variety of services and virtual machine to an organization at cost effective and is thus considered as one of the most innovative advances in technology. The ability to scale as well as stored and manage data increases by using cloud. Regulatory compliance states the modification and the steps that the organization should actively take to reach its goals. Good regulatory compliances needs to be maintained while moving to cloud so that any necessary precaution and post cloud changes can be made to the organization thus moving it closure to the goal and target. “There are straight-forward ways of modeling future ownership and the progression of value creation using a combination of capitalization table analysis and the venture capital method of valuation” (Sammut, 2020).

Protecting the crucial and sensitive data while moving to cloud is the major concern of the organization and database administrator is an intrinsic component of the authorization and control process towards regulatory compliance. DBA don’t necessarily need to know who can access the system but are necessary for database security and checking security breaches and attacks. DBA most importantly needs to know about the architecture of the cloud and the various components being actively used by the organization while moving to cloud. An understanding about the difference between on premises and cloud services including the computing stack is also a requirement for DBA. Along with that, the dba should also know how to utilize all the components of the cloud both from the point of view of administrator and developer. “While current Passive optical network (PON) standards can provide data transmission capacity of tens of Gbps, in the near future, the use of more wavelengths with rates higher than 10 Gb/s could see the overall capacity increase towards hundreds of Gbps” (Afraz, 2018).

DBA also plays the crucial role in managing the budget for the cloud database and thus should have the related information as well as knowledge about application design and impact of cloud database followed by the cost of impact. Studies suggest that it is not recommended to move all the data at once to cloud, at least not initially. The DBA thus needs to work for few days in the hybrid setting of cloud and on-premises arrangement. DBA should know the traditional skills to manage on premises activities and also the advanced skill to deal with the cloud activities and database. The initial movement of database to cloud should only include the crucial and the important effective data and thus DBA should use his understanding to decide what data should be moved to cloud followed by planning for the remaining data and deciding their time to move to cloud. Dba needs to be aware about each component of cloud, the organization services and the cloud services to maintain good regulatory compliance when moving to the cloud. “Since data in the cloud is going to be placed online, it is important that these data in the clouds are well secured” (Krishna, 2018).

Operational Excellence

6 pages

APA format

Strictly plagiarism free

Assignment 1 (Discussion – 1 page)

Discussion: This week we focus on globalization concepts.  Please explain the concept of globalization and the role information technology has in the global market.

Assignment 2 (Exercise – 1 page)

Chapter 11 – Exercise 1 (Information Systems for Business and Beyond)
Chapter 12 – Exercise 1 (Information Systems for Business and Beyond)

Assignment 3 (Essay – 2 pages, 1 page per chapter)

Chapter 9 – Review the section on Establishing a Security Culture. Review the methods to reduce the chances of a cyber threat noted in the textbook. Research other peer-reviewed source and note additional methods to reduce cyber-attacks within an organization. (Information Technology and Organizational Learning)

Chapter 10 – Review the section on the IT leader in the digital transformation era. Note how IT professionals and especially leaders must transform their thinking to adapt to the constantly changing organizational climate. What are some methods or resources leaders can utilize to enhance their change attitude? (Information Technology and Organizational Learning)

Assignment 4 (Portfolio project – 3 pages)

Portfolio Project:

This week select an organization that has a Global platform (they operate in more than one country), that has demonstrated operational excellence. In this paper, perform the following activities:

Name the organization and briefly describe what good or service they sell and where they operate.
Note how they are a differentiator in the market.
Note the resources used to ensure success in their industry (remember resources are comprised of more than just people).
Explain what actions the company took to achieve operational excellence.

The above submission should be three pages in length. Remember the total length does not include the APA approved cover page or the references. There should be at least three APA approved references to support your work.

webstore

Pine Valley Furniture’s board of directors is ready to review how to implement and maintain the new webstore system.

Write a 6- to 8-page implementation and maintenance plan for the new webstore. Include the following:

Recommend an installation strategy for PVF’s student furniture webstore. The installation strategies are direct installation, single-location, parallel installation, and phased installation. Justify your recommendation by stating the advantages and disadvantages as compared to the other three installation strategies.

Outline the documentation that you would suggest being created to document the system, train, and support users.

Outline the testing plan for the system. Include brief descriptions of the activities for each element of your testing plan.

Summarize the maintenance needs of the PVF webstore, including alternative organizational structures, quality measurement, processes for handling change requests, and configuration management.

Cite any references according to APA guidelines. For maximum points, include 3 academically acceptable references.

data structure and algorithm

You are requested to implement a simple IoT device management system. IoT devices

can be categorized into three main groups: consumer, enterprise, and industrial.

“Consumer connected devices include smart TVs, smart speakers, toys, wearables and

smart appliances. Smart meters, commercial security systems and smart city technologies

— such as those used to monitor traffic and weather conditions — are examples of industrial

and enterprise IoT devices. Other technologies, including smart air conditioning, smart

thermostats, smart lighting and smart security, span home, enterprise and industrial

uses.”1 An IoT device can be identified by many fields including category, Identifier, …

1- (2.5 mark) Describe the IoT data type, IoTdevice, using Java classes. Make sure

to use Java inheritance, an interface, and an abstract class.

2- (5 marks: 1mark/method) We want to implement a simple application that

manages the IoT devices. You are asked to develop a Java application that uses

an array to store all information regarding the IoT devices installed in a building and

using the newly created data type IoTdevice defined in 1). You should provide a

menu with the following options:

———————————————————————-

IoT Device Management System (CSC301, Fall2020)

———————————————————————-

1- Add a new IoT device

2- Delete all existing IoT devices given a category

3- List all existing IoT devices from one category

4- Check if an IoT devices exists based on its ID

5- Sort all IoT devices based on two criteria of your choice

0- Quit

———————————————————————-

Your choice? __

———————————————————————-

Please use the partial Java code provided with this assignment which prints the

menu. You MUST do this lab in groups of maximum two students. This Lab

counts for 7.5 marks. You should upload your work via the course website on time

before September 29th, 23:59. Any late submission will be penalized (-0.25 / day).

Evaluation: You will be evaluated based on a demo during which you will be asked

individually various questions.

Discussion 1

As stated in the text, “people and organizations are responsible for the results, good or bad, of the use of IT” (p. 576). For this discussion you will analyze the role of ethics in IT and business.  In your initial post, using an example of your choice, explain the differences between law and ethics.

Analyze the impact of ethical issues on IT, and provide an example of an ethical issue that has impacted an organization as well as an ethical issue that might impact you personally.  Explain the potential legal and ethical challenges associated with advancing technology, using at least one example from your research. Explain whether or not you believe the laws have caught up with technology. Support your position with examples from credible sources. 

Your initial post must be a minimum of 300 words.