2.3-Student Multiple Scores Assignment (1)

docx

School

Hocking Technical College *

*We aren’t endorsed by this school

Course

1100

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by vickigrace1

PM 6900 – Basic Fundamentals of Excel Assignment This assignment consists of 5 Excel worksheets. Each worksheet has student scores from a course. Clean each worksheet. Remove any blank rows and if a grade is blank place a zero in the cell. For each course compute the letter grades as per below. After computing the letter grades for each course combine all the letter grades. Create a Pareto and column chart indicating the total distribution of the letter grades for the 5 courses combined. Examples of these charts are shown as the end of this assignment. Open the dataset “ 2.4 Student Scores Dataset.xlsx ” in Excel for this assignment. 1. Using the VLOOPUP function assign a grade to each student according to the Grading Scale below. 1

2. From the Weighted Avg scores create the following table using the COUNTIF formula. 2

Report Data 3. Create the following Pareto chart from the table from step 3 above. The values in your chart will be different. 4. Create the following Column Chart from the table from step 3 above. The values in your chart will be different. 5. Perform a save as and save the file as 5.2 Student Scores Dataset Complete.xlsx ” 3

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

2.3-Student Multiple Scores Assignment (1)

Related Documents