Content (2 marks)
|
| |
- Contact information is provided on the cover page (Caution: if you
have insufficient contact information then your marker may not even be
able to provide you with a grade!): 2 marks
|
|
|
Functions to be used from MS-Excel (22
marks)
|
|
|
- Changing the font of cell A1: 1 mark
|
|
|
- Changing the titles along Row 3: 1 mark
|
|
|
- Change the background color to white: 1 mark
|
|
|
- Uses the SUM function for Column M, 2 decimal digits shown: 2 marks
|
|
|
- Calculates the percentage score in Column N, 2 decimal digits shown: 2
marks
|
|
|
- Uses the VLOOKUP function in Column O: 3 marks
|
|
|
- Uses the COUNTIF function in Column U: 2 marks
|
|
|
- Calculates the raw average score in Row 71, shows 2 decimal digits: 2
marks
|
|
|
- Calculates the average percentage for each question in Row 72, shows 2
decimal digits: 2 marks
|
|
|
- Calculates the high score using the MAX function in Row 73: 1 mark
|
|
|
- Produces the bar graph as described in the assignment: 3 marks
|
|
|
- Version 2 of the spreadsheet includes the information above plus the
alternate percentage ranges: 2 marks
|
MAXIMUM NUMBER OF MARKS: 24
|