Our goal is to let the computer do the work so we can spend more time sailing. Design a spreadsheet that will calculate the grades for five people taking CSC105-06. All you want to do is enter the student's name, final exam, midterm, and five lab grades. The output should include an average for the five labs counting the greater of the data base or C-programming assignments for a total of four lab grades, the average of which is recorded in a column adjacent to the final exam and midterm grades. In the columns adjacent to their name a running letter grade and overall numerical average should be posted so the student's current grade is known at all times.

This project will utilize some of the following commands:

• IF(logical_test, value_if_true, value_if_false)
• SUM(number1, number2, …)
• COUNT(value1, value2, …) · Arguments that are numbers, dates, or text representations of numbers are counted; arguments that are error values or text that cannot be translated into numbers are ignored.
• HLOOKUP(lookup_value, table_array,row_index_num, range_lookup)
• Relative reference
• Absolute reference
• Sample Spreadsheet
• Step by step instructions

Format: Turn in hard copy with fictitious names and grades completed, 3.5" floppy (with your name on the outside).

Go to where you came from!