Reference no: EM131223654
You have been offered an internship in the School of Management and the Dean has asked you to fix problems with inconsistent data and grading criteria among the different sections of a GMU class over a period of several years. You need to validate, format, and calculate each student's data using the same criteria for Letter Grade and Pass/Fail. The maximum number of points in the course is 695 and the following table explains letter grades by number on points: Total Points Letter Grade Total Points Letter Grade
|
Total Points
|
Letter Grade
|
Total Points
|
Letter Grade
|
|
660
|
A+
|
500
|
C+
|
|
630
|
A
|
450
|
C
|
|
600
|
A-
|
420
|
C-
|
|
570
|
B+
|
390
|
D
|
|
545
|
B
|
0
|
F
|
|
520
|
B-
|
|
|
Your tasks are as follows - be sure to follow them explicitly:
1) Using data in the file Data.txt, create a file named: 'HW3' in either .xls or .xlsx format.
2) Copy and paste the raw data from the text file into the first worksheet and label it 'Student Scores'
3) Complete the following validation, formatting, and calculation steps:
a. Make sure totals are correct and column values are reasonable. Identify any usual values in accordance with our discussion and rubric. Format all point value cells to one decimal point.
b. Add a column labeled "Calculated Points" which sums all of the exams, projects and quizes. Format the calculated total to one decimal point.
c. Add an additional column that compares the calculated total value with the given total value. Identify if they match or not.
d. Add a column labeled 'Total %' that calculates a percentage score for each student and format it to display out to one decimal point.
e. Add a column labeled 'Letter Grade' and use VLOOKUP to automatically assign final letter grades based on the total calculated points column in the table above. Be sure to put your grade lookup data beginning at Cell A1 on a separate worksheet labeled, 'Lookup Data' (1 pt). If in step 3a you found any invalid values, manually replace the VLOOKUP grade value for that row with 'Invalid' to denote the data do not support calculating a grade value.
e. Add a column labeled 'Pass/Fail' and use the IF function to populate either 'Pass' or 'Fail' (Passing = C- or higher) (1 pt), then use Conditional Formatting to highlight all cells with 'Fail' with red fill (.5 pt) . Manually replace Pass/Fail values for rows that whose Letter Grade = 'Invalid' with 'N/A'.
Attachment:- Assignment.rar
|
How does the article relate to the issues covered in class
: What is the main point of the article? How does the article relate to the issues covered in class? You will find the article that i want to Write about it on the attachment called (Architecture in the united states )
|
|
What are the distinctive themes for each organization
: What are common themes found among each of the professional organizations represented in the websites - what are the distinctive themes for each organization?
|
|
Briefly describe the original art work you selected
: Briefly describe the original art work you selected. What media was used, and when was it created? What artistic/aesthetic period (such as Middle Ages or Impressionism) does it represent? Who was the artist? What message do you think he or..
|
|
Explain the psychology and physiology of addiction
: Identify specific drug substances covering the following categories: stimulants, depressants, narcotics, hallucinogens, and cannabis. Discuss the addiction potential of various abused substances, what effects they have, and withdrawal symptoms.
|
|
Calculate a percentage score for each student
: MIS301 - Fall 2016 - You have been offered an internship in the School of Management and the Dean has asked you to fix problems with inconsistent data and grading criteria among the different sections of a GMU class over a period of several years.
|
|
Evaluate the impact of legal and regulatory requirements
: Evaluate the impact of legal and regulatory requirements on the development of organizational health care policies related to facility design for your selected facility.
|
|
Find an eigenvector for each eigenvalue
: a} Enter the eigenvalues of Ain increasing order,separated by commas? b) Find an eigenvector for each eigenvalue. Enter these eigenvectors as a list, e.g. [0,1],[1,0]? c) For each eigenvalue λ ,find an orthonormal basis for the eigenspace Eλ.
|
|
Difference between official and unofficial information
: What is the difference between personal and interpretive information? In the context of the Riverbend City scenario, explain how these two terms relate to the accuracy of information.
|
|
How the model could be revised to address those problems
: Analyze the importance of accuracy and clarity in workflow modeling, and describe at least one strategy you plan to use to ensure that the workflow models you create are accurate and clear.
|