(
Latest revision:
October 21, 2008
)
SECOND SPREADSHEET PROJECT ASSIGNMENT
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.
Remember to update the title, header, or footer of your spreadsheet. It
should contain:
- Your Name,
- "CS 4000",
- "Second Spread Sheet Project"
- "Min Score Dropped"
NOTE ON GRADING CRITERIA
Your grade book will be graded for accuracy and readability. Think about using
boldface or other formatting 'tricks' to make your spreadsheet more readable.
Be very attentive to checking the correctness of your formulas. This will
count heavily. Just because an answer appears in a cell, does not mean it is
correct.
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.