CS 107 Introduction to Data ProcessingSpring 2006MS ExcelGrading and Class Statistics Assignment |
UNH Home Page | Computer Science Department Home Page | Contact Instructor |
SyllabusAssignmentsLecturesSoftware Exercises |
Making the GradeYou're the teacher at the end of another semester and it's time to turn in your final grades. You decided at the beginning of the semester that the final grades would based on the following:
In each of the categories, assignments, exercises and tests have been assigned, each with a total number of possible points which a student can earn. The total number of points is shown below.
Assume that a student who has earned all of the possible points will receive a numerical score of 100. And student who has earned half of the total points will receive a numerical score of 50, and so on. In this assignment, you are to create a spreadsheet which will take the number of points a student has earned in each category and calculate a numerical grade for the student. The data will be spread over several worksheets. All the exams will be on one sheet, all the software assignments on another, all other work on a third. On a forth worksheet, you will be determining a letter grade for each student using the data listed below. Also on the last sheet, you should show the mean, median, mode, variance, standard deviation, skew, and frequency for the overall class's data. Finally on the last sheet, show a scatter graph of the class's data. Are you students falling within a normal bell shaped curve? Note: grades are always rounded upwards. Note: the tabs on each page of your worksheet should be labeled as to the content of the page.
Final Letter Grade CriteriaYour students' raw data can be found at the bottom of this page. What to turn inTwo copies of your spreadsheet; one with values and one listing the formulas you have used. The printouts should have your name and the name of this project in the header. Put a copy of the screen capture of your workbook, showing the tab labels, on one of you printed worksheets. Use what ever formatting you wish to enhance your work. |
Student Name | Weekly Articles 13 |
Other Assignments 85 |
Term Project 100 |
Midterm Exam 100 |
Final Exam 100 |
A & A 34 |
Tom Jones | 6 | 75 | 90 | 73 | 82 | 31 |
Sally Star | 13 | 85 | 98 | 99 | 95 | 33 |
Sam Sloow | 1 | 45 | 72 | 68 | 72 | 25 |
Janet Jackson | 10 | 70 | 85 | 85 | 78 | 34 |
Jeremy Johnson | 10 | 70 | 85 | 85 | 78 | 34 |
Tim Hunt | 0 | 70 | 93 | 87 | 96 | 33 |
Lisa Perkins | 13 | 85 | 60 | 78 | 81 | 34 |
Anthony Soprano | 3 | 65 | 0 | 54 | 68 | 20 |
Curtis Howe | 13 | 82 | 72 | 78 | 86 | 34 |
Dawn Dimm | 2 | 60 | 70 | 52 | 58 | 25 |
Ralph Reotten | 5 | 42 | 84 | 77 | 72 | 22 |
John James | 13 | 84 | 100 | 89 | 81 | 34 |
Alfie Guest | 3 | 43 | 60 | 72 | 45 | 30 |
Dimm Whitt | 1 | 23 | 0 | 68 | 72 | 19 |
Nora Lofts | 13 | 85 | 85 | 75 | 79 | 34 |
Tammy McNeil | 8 | 75 | 90 | 73 | 82 | 29 |
Ron Shea | 13 | 85 | 98 | 93 | 95 | 33 |
Anita Burns | 0 | 45 | 72 | 68 | 72 | 25 |
Eric Adams | 10 | 85 | 85 | 85 | 78 | 34 |
Jeffery Langer | 13 | 70 | 85 | 81 | 78 | 34 |
Frank Holms | 0 | 100 | 93 | 87 | 96 | 33 |
Leislie Knight | 13 | 85 | 60 | 88 | 81 | 34 |
Don Hanson | 13 | 65 | 70 | 54 | 68 | 20 |
Cindy Eggert | 13 | 82 | 85 | 78 | 86 | 34 |
William Nye | 13 | 60 | 70 | 52 | 58 | 25 |
Helen Thomas | 9 | 42 | 84 | 77 | 72 | 22 |
Peter Thomas | 13 | 84 | 100 | 89 | 81 | 34 |
Alien Spawn | 7 | 43 | 60 | 72 | 45 | 30 |
Kenny McCormick | 1 | 23 | 45 | 68 | 72 | 19 |
Stan Marsh | 13 | 85 | 78 | 75 | 79 | 34 |
Last Updated: 3/29/06 |