Expert answer:Excel Bar ChartsvGraphs
Solved by verified expert:I’ve attached both necessary documents to correctly complete this assignment. Please contact me with any questions pertaining to this assignment.
grades_int.docx
e03m2psych.xlsx
Unformatted Attachment Preview
You are 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. You created a section call Final Grade Distribution that contains calculations to identify the
number of students who earned an A, B, C, D, or F. Dr. Unice wants you to create a chart that shows the
percentage of students who earn each letter grade. Therefore, you decide to create and format a pie
chart. You will also create a bar chart to show a sample of the students’ test scores. Furthermore, Dr.
Unice wants to see if a correlation exists between attendance and student’ final grades; therefore, you
will create a scatter chart depicting each student’s percentage of attendance with his or her respective
final grade average.
A. Open e03m2Psych and save it as e03m2Psych_LastFirst.
B. Create a pie chart from the Final Grade Distribution data located below the student data in the
range F38:G42 and move the pie chart to its own sheet names Grades Pie.
C. Customize the pie chart with these specification:
• Apply the style 7 chart style
• Type PSY 2030 Final Grade Distribution-Fall 2018 for the chart title
• Explode the B grade slide by 10%
• Remove the legend
D. Add centered data labels and customize the labels with these specifications:
• Display these data labels: Percentage and Category Name. Remove other data labels.
• Change the font size to 20, and apply Black, Text1, font color.
E. Create a clustered bar chart using the range A7:D12 and move the bar chart to its own sheet
named Students Bar Chart.
F. Customize the bar chart with these specifications:
• Apply the Style 5 chart style.
• Type Sample Student Test Scores for the chart title.
• Position the legend on the right side.
• Add data labels in the Outside End position for the Final Exam data series.
• Arrange the categories in reverse order so that Atkin is listed at the top and Ethington is
listed at the bottom of the bar chart.
ASSIGNMENT INSTRUCTIONS!!!:
Step F: Add your name, MEID, and course section number in the footer.
Tara Carroll
TAR2033064
CIS105-# 13622
Save your file as “Grades_TAR2033064.xlsx.
Grade Book
Course:
Section:
Professor:
Passing Score
Name
Atkin
Bailey
Basquez
Chapman
Ethington
Isham
Leung
McAllister
Mellor
Myers
Noakes
Nuvek
O’Hair
Peugh
Pulley
Quinn
Rodarte
Sager
Smith
Stanworth
Stuberg
Takahashi
Thomas
Uribe
Walton
Warburon
PSY 2030 General Psychology
102
Dr. Monica Unice
70
Unit Test 1
90
91
78
88
60
82
84
70
74
86
74
82
56
78
76
92
82
50
54
68
98
86
78
96
72
64
Grading Scale
Breakpoint
Letter
0
F
59.5
D
69.5
C
79.5
B
89.5
A
Unit Test 2 Final Exam
84
88
88
90
70
68
88
78
64
58
74
82
90
80
66
62
76
80
90
84
78
84
78
74
52
60
85
88
84
74
90
92
76
86
64
68
50
48
62
74
96
100
88
94
74
74
100
100
76
74
55
58
Attendance
Final
Record Average
95
87.3
85
89.7
85
72.0
80
84.7
60
60.7
90
79.3
80
84.7
55
66.0
80
76.7
70
86.7
85
78.7
100
78.0
50
56.0
90
83.7
90
78.0
85
91.3
80
81.3
75
60.7
75
50.7
80
68.0
95
98.0
100
89.3
90
75.3
95
98.7
70
74.0
55
59.0
Letter Grade
B
A
C
B
D
C
B
D
C
B
C
C
F
B
C
A
B
D
F
D
A
B
C
A
C
F
Final Grade Distribution
Grade # Students
A
4
B
7
C
8
D
4
F
3
Trend
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades