CS 221 Fall 2011 - Grading Sheet for Problem Set 1

Due: 23:59:59 Wednesday, September 21

The purpose of this assignment is to reinforce the concepts you have been taught in lecture and lab.

This assignment has two parts; you will submit a single "zip" archive containing your answers to all three parts.

Late Submission Penalties

Late submissions will be penalized 20% per day or fraction of day. Thus if you submit at 8:00 a.m. Thursday, the maximum score you can get will be 80. If you submit at 1:00 a.m. Friday, your max score will be 60.

General Policies

Because we have around 180 submissions to grade, it is important that you follow the instructions about what to submit and how to format it. (Note: 15 minutes grading time for each of 180 submissions = 45 hours.)

Part 1 answers not in a text or PDF file: 15% penalty.
Failure to include directory in zip file: 10% penalty.
Missing files for some parts: no points for that part.

Part 1: CS Concepts

10 points for each problem.

Problem 1: 2.5 points for each correct answer. Partial credit may be given for answers that are sensible but wrong.
Problem 2: 2 points for each correct answer. Partial credit may be given on part c for justifiable-but-wrong answers.
Problem 3: 3 points per parts a and b, 4 points for c. Maximum credit 1 point if no work is shown.
Problem 4: 5 points per part, max credit 1 point if no work is shown.

Part 2: Excel Problems

Problem 5, Bicycle Gear Ratios, 20 points total. Deductions for:
- Not formatted according to the specification, 2-5 points off.
- Not sorting rows according to gear ratio, 4 points off.
- Incorrect formulas in cells, 2-10 points off.
- Part (e), for full credit, show that you have thought about the problem and looked through the Excel help. (You don't have to provide a complete solution - yet.)
Problem 6, Student Grade Calculations, 40 points total. Deductions for:
- Use "RANDBETWEEN()" correctly to fill in values (10 points).
  1. Values out of range, deduct 3 points
  2. Non-use of RANDBETWEEN(), deduct up to 10 points
  3. Formulas incorrect or more complicated than necessary, deduct 2-5 points
- Calculate "Total" correctly (10 points)
  1. Incorrect formula for weighted sum, deduct 2-10 points
  2. Formula does not accomodate adding/removing components, deduct 2-4 points
- Assign grade correctly (10 points)
  1. Correct use of nested IF (should be five "levels" of nesting), 2 points each
  2. IF expression otherwise mangled, deduct 2-5 points
- Correctly use "paste special" function to "freeze" values.
  1. Some values still change, deduct 2-10 points, depending on how many.