Create an excel spreadsheet with basic charts
Objective: Create an Excel Spreadsheet with basic charts
Create the following spreadsheet and charts:
1. Create the worksheet above
a. Name it CSCIN207.
b. Save your spreadsheet as CSCIN207Grades15-16.xlsx
2. Create a single pie chart
a. Use the total for all three semesters (you will need to add another column to your worksheet to hold the total.
b. Make the chart 3-D.
c. Title it CSCI N207 Grades 2015-2016
d. Place the chart on the same worksheet.
3. Create single 3-D bar chart
a. Display the above data (there should be 3 bars for each grade).
b. Move the chart to a separate worksheet and name the sheet 3DBarChart
c. Make the title CSCI N207 Grades By Semester
Below is grade data for a previous semester of this class:
Midterm Exam
Final Exam
73
62
60
87
78
84
100
93
76
62
73
89
54
69
94
100
69
82
61
86
79
100
85
78
49
77
100
97
88
93
79
75
94
90
67
69
74
83
61
29
85
66
79
97
86
71
100
100
97
98
64
73
67
100
60
9
53
41
73
85
88
79
70
55
74
41
93
92
74
75
97
100
94
97
39
23
71
46
86
82
89
72
94
77
60
88
68
40
34
23
85
65
91
93
97
61
53
54
73
52
91
78
Create the following spreadsheet and charts:
1. Create the worksheet above
a. Name it Spring2016Grades.
b. Save your spreadsheet as CSCIN207Spring2016.xlsx
2. Create a scatter plot (show the linear trend line)
a. Title the scatter plot Spring 2016 Grades
b. Save the plot to a separate sheet named ScatterPlot
3. On the Spring2016worksheet do the following analysis, make sure to format appropriately:
a. What is the minimum, maximum, mean and median score for the Midterm.
b. What is the minimum, maximum, mean and median score for the Final Exam
c. What is the standard deviation of the midterm exam?
d. What is the standard deviation of the final exam?
e. What is the correlation between the midterm exam and the final exam?
To turn in class:Printouts for the spreadsheets. Please make sure you have all assignments labeled, include in the sequence shown below and stapled together and please include a cover page.
1. Worksheet CSCIN207 printout that includes the data and Pie chart. Label it #1
2. Bar chart printout. Label it #2
3. Worksheet Spring 2016 Grades only include the data (use a selection to print). Label it #3
4. Printout of analysis of data: standard deviation, correlation(use a selection to print). Label it #4
5. Scatter plot printout. Label it #5