CS 107 Introduction to Data Processing

Spring 2006

MS Excel

Grading and Class Statistics Assignment

UNH Home Page Computer Science Department Home Page Contact Instructor

Syllabus

Assignments

Lectures

Software Exercises

Making the Grade

You'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:

  • 40% - Assignments and hands-on course work broken down as follows:
    • 10% - Weekly Articles
    • 30% - In class assignments, groups projects, written homework, and software assignments
  • 20% - Term Project - Power Point Presentation
  • 15% - Midterm Exam
  • 15% - Final Exam
  • 10% - Attendance and Attitude - A & A

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.

  • Weekly Articles - 13
  • Other Assignments - 85
  • Term Project - 100
  • Midterm Exam - 100
  • Final Exam - 100
  • A & A - 34

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 Criteria

  • A+ - 97 or greater
  • A - 93-96
  • A- - 90-92
  • B+ - 87-89
  • B - 83-86
  • B- - 80-82
  • C+ - 77-79
  • C - 73-76
  • C- - 70-72
  • D+ - 67-69
  • D - 63-66
  • D- - 60-62
  • F - 50 or less
Your students' raw data can be found at the bottom of this page.

What to turn in

Two 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 Data

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