( Latest revision: October 21, 2008 )

MAKE A NEW VERSION OF THE GRADE BOOK

Some teachers use a grading scheme in which the lowest score is dropped. Starting with a copy of the grade book you created for the first spreadsheet project, add another column which calculates the final score by "dropping the minimum" score and averaging the remaining scores. Then create a line graph (chart) that graphs the old (raw) averages versus the new (adjusted) averages. (In class, I'll explain how to do these things.)

REQUIREMENTS:
• The formula is required to be "robust." That means it adjusts automatically to changes. if you have to change some of a student's scores, even if the location of the minumum score changes, the formula adjusts and continues to display the correct answer.)

• The line graph has to be of the non-stacked type.

SUGGESTION

Start by making a duplicate of a finalized version of your first spreadsheet. Since version #4 shows formulas, you should use version #3. Make a copy of version #3 under a new name by using the "Save As" option in the File menu. Next modify the copy of version #3 to create the new grade book. This way, you know that if you have to, you will be able to start over, beginning by making another copy of the original of version #3.

FORMAT

For the numerical entries, adhere to the formatting standards described in the first spreadsheet project assignment. Remember that all numbers have to be formatted the same way - with the same number of digits after the decimal point.

• "CS 4000",
• "Min Score Dropped"

WHAT TO TURN IN

Turn in three separate printouts:
• one printout showing the new version of the spreadsheet values,
• one printout showing all the formulas, gridlines, row & column headings, and
• one printout showing both the raw and adjusted averages on one line graph.
Everything must be labelled appropriately, so that there is no mistaking what one is looking at.

THE DUE DATE OF SPREADSHEET ASSIGNMENT #2

Check the class schedule for due dates.

HOW TO TURN IN THE ASSIGNMENT

Turn in the assignment in class on the due date or on any class day before the due date. Put your paper on the podium before class starts.