Instructions:

A. Create a pie chart from the Final Grade Distribution data located below the student data and move the pie chart to its own sheet Named Grades Pie.

B. Customize the Pie chart

*Style 7 chart style

*Chart title: PSY 2030 Final Grade Distribution - Fall 2016

*B grade slice exploded

*Legend: none

C. Add centered data labels and customize the labels with these specifications:

*Label captions: Percentage and Category Name; no values

*28-pt size; Black, Text 1 font color, and bold

D. Create a scatter with only Markers chart using the attendance record and final averages from Grades worksheet. Move the scatter chart to its own sheet named Scatter Chart.

E. Apply these label settings to the scatter chart:

*legend none

*Chart title:Attendance- Final Average Relationship

*Primary horizontal axis title:Percentage of Attendance

*Primary vertical axis title:Student Final Averages

F. Use Help to apply to learn how to apply the following axis settings:

*Vertical axis: 40 minimum bonds, 100 maximum bonds, 10 major units, and a number format with zero decimal places.

*Horizontal axis: 40 40 minimum bonds, automatic maximum bonds, automatic units

G. Apply 12 pt font size to the vertical axis title, vertical axis, horizontal axis title, and horizontal axis.

H. Add the Parchment texture fill to the plot area to the plot area and insert a linear trendline. 

 

Grade BookCourse:PSY 2030 General PsychologySecton:102Professor:Dr. Monica UnicePassing Score70NameUniT ±esT 1UniT ±esT 2 Final ExamLe²er GradeAtkin9084889587.3BBailey9188908589.7ABasquez7870688572.0CChapman8888788084.7BEthington6064586060.7DIsham8274829079.3CLeung8490808084.7BMcAllister7066625566.0DMellor7476808076.7CMyers8690847086.7BNoakes7478848578.7CNuvek82787410078.0CO'Hair5652605056.0FPeugh7885889083.7BPulley7684749078.0CQuinn9290928589.8ARodarte8276868081.3BSager5064687560.7DSmith5450487550.7FStanworth6862748068.0DStuberg98961009598.0ATakahashi86889410089.3BThomas7874749075.3CUribe961001009598.7AWalton7276747073.0CWarburon6455585559.0FGrading ScaleFinal Grade DisTributonBreakpoinTLe²erGrade# STudenTs0FA459.5DB769.5CC879.5BD489.5AF3A²endanceRecordFinalAverage

Attachments:

• 1495785213-e03m2Psych1.xlsx