Assignment: Grade Analysis

As Dr. Dae Jeong's teaching assistant, you maintain the gradebook for the ACC 200 Financial Accounting class. Dr. Jeong wants you to create a pie chart that shows the percentage of

students who earn each letter grade. You will also create a bar chart to show a sample of the students' test scores. Furthermore, Dr. Jeong wants to see if a correlation exists between

attendance and students' final grades; therefore, you will create a scatter chart depicting each student's percentage of attendance with their respective final grade average.

1. Open 603m2Grades and save it as e03m2Grades_LastFirst.

2. Use the Insert tab to create a pie chart from the Final Grade Distribution data located below the student data in the range F35-G39 and move the pie chart to its own sheet

named Distribution.

3. Customize the pie chart with these specifications:

Apply the Style 12 chart style

• Type ACC 200 Final Grades: Fall 2024 for the chart title.

• Explode the A grade slice by 7%.

Change the F grade slice to Dark Red

• Remove the legend.

Add the Alt Text The pie chart shows the percentage of the class that earned each letter grade. Most students earned B and C grades (including the period)

4. Add data labels and customize the labels with these specifications:

Display these data labels: Percentage and Category Name in the Inside End position. Remove other data labels.

Change the font size to 18 and apply Black, Text 1 font color

5. Create a clustered bar chart using the ranges AS:DS and A18:D23 in the Grades worksheet and move the bar chart to its own sheet named Sample Scores

6. Customize the bar chart with these specifications:

Apply the Style 5 chart style./nfmu.blackboard.com

GY

4. Add data labels and customize the labels with these specifications:

• Display these data labels: Percentage and Category Name in the Inside End position. Remove other data labels.

- Change the font size to 18 and apply Black, Text 1 font color.

a

8-Fall

8. Add the Alt Text The scatter chart shows the relationship of each student's final gratie and their attendance record. (including the period).

9. Apply these label settings to the scatter chart:

• Type Final Average-Attendance Relationship for the chart title and bold the title.

• Add the following primary horizontal axis title: Percentage of Attendance.

• Add the following primary vertical axis tite: Student Final Averages.

a

5. Create a clustered bar chart using the ranges AS:DS and A18:023 in the Grades worksheet and move the bar chart to its own sheet named Sample Scores.

6. Customize the bar chart with these specifications:

Apply the Style 5 chart style.

Type Sample Student Test Scores for the chart title.

Format the plot area with the Light Gradient-Accent 2 fill color.

• Position the legend on the right side and change the font size to 11.

Format the Final Exam data series with Blue-Gray, Text 2 fill color.

Add data labels in the Outside End position.

• Select the category axis and display the categories in reverse order in the Axis Options category in the Format Axis task pane so that O'Hair is listed at the top and Sager is

listed at the bottom of the bar chart.

10. Select the vertical axis. Change the Minimum Bound to 40, the Maximum Bound to 100, and select Number format with zero decimal places.

11. Select the horizontal axis. Change the Minimum Bound to 40 and the Maximum Bound to 100.

12. Apply the Parchment texture fill to the plot area.

Q

• Select the category axis and change the font size to 12.

• Add the Alt Text The bar chart shows test scores for six students in the middle of the list. Quinn earned the highest scores on all tests. (including the period).

7. Create a scatter chart using the range ES:F31 in the Grades worksheet, the attendance record and final averages from the Grades worksheet. Cut the chart and paste it in cell A42

Adjust the width to 5.5" and the height to 5.96".

13. Add a linear trendline chart element.

14. Insert Column sparklines in the range H6:H31 using the range B6:D31 as the data source. Display the low points. Format the sparklines axis by using the same minimum value for

all sparklines and the same maximum value for all sparklines Change the row height to 22 for rows 6 through 31.

15. Save and close the file. Exit Excel. Based on your instructor's directions, submit: e03m2Grades LastFirst in this location.

+

69

G