Explore BrainMass
Share

Excel help with Grade Chart

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Using your cursor, highlight the course names and the data that is next to them.
Click on Insert > Charts, and select "Column Chart."
Click on the chart, and select "Cut."
Go to the bottom of your spreadsheet, and select Sheet 2. Click on a cell within that sheet.
On Sheet 2, paste the chart you just copied.
On the tabs at the bottom, label Sheet 1, as "Data" and Sheet 2 as "Grade Chart."
Add a title to the Grade Chart.
Revise the chart as needed to make it look more presentable.

© BrainMass Inc. brainmass.com October 25, 2018, 9:37 am ad1c9bdddf
https://brainmass.com/computer-science/files/excel-help-with-grade-chart-580456

Attachments

Solution Summary

Using your cursor, highlight the course names and the data that is next to them.
Click on Insert > Charts, and select "Column Chart."
Click on the chart, and select "Cut."
Go to the bottom of your spreadsheet, and select Sheet 2. Click on a cell within that sheet.
On Sheet 2, paste the chart you just copied.
On the tabs at the bottom, label Sheet 1, as "Data" and Sheet 2 as "Grade Chart."
Add a title to the Grade Chart.
Revise the chart as needed to make it look more presentable.

$2.19
See Also This Related BrainMass Solution

Statistics: Practice Problems For an Excel Chart
a. Determine the types of measurement scales for each variable (Nominal, Ordinal, Interval, Ratio) ...
b. Determine the number of boys and girls in the class and create a bar graph or pie chart to display the information.
c. Determine the correlations between pairs of all interval variables (i.e., Absences with PE, PE with math, math with writing, etc.)
d. How much of the math grade can be explained by the PE grade? How much of the writing grade can be explained by the reading grade?

Practice Problems For an Excel Chart

a. Determine the types of measurement scales for each variable (Nominal, Ordinal, Interval, Ratio):
1) Name
2) Gender
3) Absences
4) Physical Education (PE)
5) Math
6) Writing
7) Reading
b. Determine the number of boys and girls in the class and create a bar graph or pie chart to display the information.
c. Determine the correlations between pairs of all interval variables (i.e., Absences with PE, PE with math, math with writing, etc.)
d. How much of the math grade can be explained by the PE grade? How much of the writing grade can be explained by the reading grade?

View Full Posting Details