Reference no: EM131304599
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
|
Identify role of activism in changing political landscape
: Identify the role of activism in changing the political landscape. (Reflect on the past few presidential elections). How can you be an activist to support positive change in government at all levels?s
|
|
What document you research to determine costs can be allowed
: What document will you research to determine whether costs can be allowed? Write a short memo to document your opinion about whether these costs would be allowable indirect costs to be recovered in part by federal grants.
|
|
What about as the result of a natural disaster
: What are the probable consequences that are associated with this sector or asset as a result of a terrorist attack? What about as the result of a natural disaster? Explain which type of disaster might be the worst, and why.
|
|
What aspects of aviation security should be addressed
: What aspects of aviation security should be addressed in terms of strengthening them? Where do you see weaknesses? What messages would you develop to gain the public's cooperation while undergoing screening measures?
|
|
Create an excel spreadsheet with basic charts
: Create an Excel Spreadsheet with basic charts. Use the total for all three semesters (you will need to add another column to your worksheet to hold the total. Make the chart 3-D. Title it CSCI N207 Grades 2015-2016 Place the chart on the same workshe..
|
|
How could the risks and vulnerabilities be mitigated
: How could the risks and vulnerabilities be mitigated? What are the probable consequences that are associated with this sector or asset as a result of a terrorist attack?
|
|
What were they and how does each empower the terrorist
: According to the "The Evolving Terrorist Threat:" article by Joshua Sinai, several examples of the types of warfare terrorists generally employ to achieve their objectives were listed. What were they and how does each empower the terrorist?
|
|
Write a paper about workplace of the criminal justice system
: Write a paper about workplace of the criminal justice system. This issue can be problems within the organization that needs to be brought to the fore front, or a policy/procedure that needs.
|
|
Explain why communicating strategy is best
: Explain why communicating strategy is best accomplished through conversations - Ideas universally progress and relate to each other. The project includes motivating questions and advanced organizers. The project gives the audience a clear sense of..
|