1.  Download the sheet 03m2psych.xlsx from blackboard.  Read the exercise and do each of the tasks carefully, be sure to save as you go.

Grade Analysis

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 student’s final grades, so you will create a scatter chart.

A) Open e03m2 Psych and save it as e03m2Psych_LastFirst.

B) 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.

C) Customize the pie chart with these specifications:

• Style 7 chart style
• Chart title: PSY 2030 Final Grade Distribution – Fall 2016
• B grade slice exploded
• Legend: none

D) Add centered data labels and customize the labels with these specifications:

• Label captions: Percentage and Category Name; no values
• 28-pt size; Black, Text 1font color, and bold

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

F) Apply these label settings to the scatter chart:

• Legend none
• Chart tittle: Attendance-Final Average Relationship
• Primary horizontal axis tittle: Percentage of Attendance
• Primary vertical axis tittle: Student Final Averages

G) Use help to learn how to apply the following axis settings:

• Vertical axis: 40 minimum bounds, 100 maximum bounds, 10 major units, and a number format with zero decimal places
• Horizontal axis: 40 minimum bounds, automatic maximum bounds, automatic units.

H) Apply 12 pt font size to the vertical axis tittle, vertical axis, horizontal axis tittle, and horizontal axis.

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

J) Insert a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side for the two chart sheets.

K) Save and close the workbook, and submit base on your instructor’s directions.

 

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

• 1495687340-e03m2Psych.xlsx

ComputerScienceExpert

(11)

Status NEW Posted 25 May 2017 04:05 AM My Price 8.00

-----------

Attachments

file 1495687338-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer