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