MIS 370 ss2 Grade Sheet

Fall 2006

40 points

Functionality points:

• (4 points) Allows the user to easily change the cut-off for grade assignment (DOES NOT USE CONSTANTS IN FORMULAS)
• (4 points) Allows the user to easily change the weights for various assignment types (DOES NOT USE CONSTANTS IN FORMULAS)
• (4 points) Calculates descriptive statistics: high score, low score, average (mean), standard deviation, and the count of the number of students
• (4 points) Counts the number of students with a particular LETTER grade
• (4 points) Grades visualized using a graph that is saved as a SEPARATE WORKSHEET
• (4 points) Uses specified set of student scores for testing purposes

Correctness points:

• (2 points) Blanks changed to zeros
• (2 points) Correct DB calculation
• (2 points) Correct Exam calculation (both ways)
• (2 points) Correct SS calculation
• (2 points) Correct Web calculation
• (2 points) Correct Quiz/Participation calculation (drops lowest)
• (2 points) Correct final grade calculation (applies weights)
• (2 points) Correct letter grade assignment