Excel Project EXP ECH03 H3 ­ Grade Analysis 2.2

Helpfulness: 0
Set Details Share
created 2 years ago by Gimineaytron
47 views
Excel Project EXP ECH03 H3 ­ Grade Analysis 2.2
show moreless
Page to share:
Embed this setcancel
COPY
code changes based on your size selection
Size:
X
Show:
1

Excel Project EXP ECH03 H3 ­ Grade Analysis 2.2

Buy here:/>

2

Excel Project EXP ECH03 H3 ­ Grade Analysis 2.2

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

Start Excel. Download and open the file namede03_grader_h3.xlsx.

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

11

Make sure the scatter chart is selected. Apply 12 point font size to the vertical axis title, the vertical axis, the horizontal axis title, and the horizontal axis.

8.000

12

Make sure the scatter chart is selected. Add the Parchment texture fill to the plot area and insert a linear trendline.

6.000

13

Display the Grades worksheet. Select the range B8:D33, create a line sparkline, and type H8:H33 in the location Range box.

9.000

14

Select the Sparkline Style Colorful #1.

5.000

15

Show the High Point and the Low Point for the sparklines. Keep Red as the Low Point marker color. Change the High Point marker color to Purple.

5.000

16

Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side on all of the worksheets.

5.000

17

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Grades Pie, Scatter Chart, Grades. Save the workbook. Close the workbook, and then exit Excel. Submit the workbook as directed.

0.000

Total Points

100.000


Related pages


inborn responsedefine lytic virushow many valence electrons does n havethe final electron acceptor of aerobic respiration is ______epicranialgastrulation is the process that directly forms the _____tactile pathwayfunctional classification of neuronswhat does the midbrain consist offunctions of lymphatic vesselsida early comes over the mountainrespiratory system chapter 22ground tissue in plantsa sentence for consternationshoulder muscles namesfour types of neuroglia in the cnsalveoli anatomythe election of 1876 quizletcreme de menthe drink recipesone unique anatomical feature of cardiac muscle ispubic symphysis structural classificationlocation of epithelial tissue in the human bodywhat is the consequence of obstruction of the lymphaticsmicrobiology note cardsriordan manufacturing virtual organizationwhich of the following statements about rna is truedefine logistic growth biologyfunction of epithalamuse ring estrogenis 118 a good iq scorelabel cranial nervesmandible bone markingsglycolysis with structuresquadratus lumborum origin and insertiondeciduous forest annual precipitationsmall intestine surface areawhat are the chemical messengers of the endocrine systemcodons for amino acidsdefine extant speciestrp operon diagramalkaline urine utidiversification marketing definitiongastrointestinal tract diagramcellular respiration in the presence of oxygen1879 wilhelm wundtvocal cord attachmenthesi a2 quizletwhat type of cartilage supports the external earmartian dnasuture sizes smallest to largestheart chambers and valves diagrammuscular system handoutfungi fertilizationdemographic segmentation variablesreactant biologycytokinesis in plantssynthesizes hormonesare vestigial structures acted on by natural selectioncopper ii sulfate sodium carbonatedo animal cells have cytoskeletonaldosterone increases blood pressuredifference between medical and surgical asepsisresearch methods for the behavioral sciences 4th edition pdfdefine tunicsarteries and veins in the bodythe great and middle cardiac veins drain blood into themain groups of bones that form the axial skeletonwhat are the steps of the dna ladder made ofgentiles taxonomycarbon cycle and oxygen cycleolfactory canalshx medical abbreviationexcretion in earthworm