### Free Educational Resources

• > Excel Project EXP ECH03 H3 ­ Grade Analysis 2.2
+

# Excel Project EXP ECH03 H3 ­ Grade Analysis 2.2

##### Rating:
(0)
Author: matthew stock
##### Description:

EXP ECH03 H3 - Grade Analysis 2.2

Project Description:
You are a teaching assistant for Dr. Monica Unice’s introductory psychology class. You have maintained her grade book all semester, entering three test scores for each student and calculating the final average. Dr. Unice wants to see a chart that shows the percentage of students who earn each letter grade. You decide to create a pie chart. She wants to see if a correlation exists between attendance and students’ final grades, so you will create a scatter chart.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

0.000

2

Select the range F38:G42 and create a pie chart for the Final Grade Distribution data. Move the pie chart to its own sheet named Grades Pie.

6.000

3

Customize the pie chart with these specifications: Style 7 chart style, 4% explosion for the B grade slice, no legend.

6.000

4

Type PSY 2030 Final Grade Distribution - Fall 2016 as the chart title.

6.000

5

Add centered data labels. Select data label options to display Percentage and Category Name. Remove the Values data labels.

10.000

6

Apply 28-pt size and apply Black, Text 1 font color to the data labels.

6.000

7

Display the Grades worksheet. Select the range E7:F33 and create a Scatter chart. Move the scatter chart to its own sheet named Scatter Chart.

10.000

8

Make sure the scatter chart is selected. Type Attendance-Final Average Relationship as the chart title, typePercentage of Attendance as the primary horizontal axis title, and type Student's Final Average as the primary vertical axis title.

6.000

9

Make sure the scatter chart is selected. Apply these settings to the vertical axis of the scatter chart: 40 minimum bounds,100 maximum bounds, 10 major units, and a number format with zero decimal places.

6.000

10

Make sure the scatter chart is selected. Apply these settings to the horizontal axis: 40 minimum bounds, automatic maximum bounds, automatic units.

6.000

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

25 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial