| Lecture notes for the Introduction to computers by James Tam | Return to the course web page |
Functional requirements |
|||||
Feature of Excel to be included |
|
Max max |
Mark received |
||
Average percentage for each course component |
|
5 |
|||
Average for the term percentage and average letter grade |
|
2 |
|||
Minimum percentage for each course component |
|
5 |
|||
Maximum percentage for each course component |
|
5 |
|||
Minimum term percentage |
|
1 |
|||
Maximum term percentage |
|
1 |
|||
|
|
Maps the percentages to letter grades for each student |
|
8 |
||
Count for the number of students who received the various letter grades |
|
12 |
|||
|
|
Graph showing the occurrences of letter grades received |
|
6 |
||
|
|
Shows the average percentage for each faculty with a pivot table |
|
6 |
||
|
|
Contact information |
|
4 |
||
|
|
Display result of alternate grade cutoffs |
|
8 |
|
|
| TOTAL FUNCTIONAL MARKS | 63 | ||||
Layout and representation |
||||
|
|
4 marks: Appropriate type and amount of variation used |
0 marks: Far too many fonts and/or effects distract from the data, or no variation was used. |
||
|
|
Fonts and font effects |
|
|
|
|
|
|
|
|
|
|
|
|
2 marks: |
|
0 marks: Too much whitespace (wasted areas), too little whitespace (groups aren't seperated) |
|
|
Whitespace and separation |
|
|
|
|
|
|
|
|
|
|
|
|
1 mark: yes |
|
0 marks: no |
|
|
Consistent alignment |
|
|
|
|
|
|
|
|
|
|
|
|
2 marks: |
|
0 marks: |
|
|
Alignment (appropriate) |
|
|
|
|
|
|
|
|
|
|
|
|
4 marks: |
|
0 marks: |
|
|
Are data and calculations explicit |
|
|
|
| 4 marks: | 0 marks: | |||
| Graph (appropriate type used, is information clearly represented) | ||||
| TOTAL MARKS | 17 | |||
OVERALL RAW SCORE (MAX 80) |
|
LETTER GRADE: |
| A | 77 - 80 | C | 45 - 50 | |
| A- | 73 - 76 | C- | 39 - 44 | |
| B+ | 68 - 72 | D+ | 33 - 38 | |
| B | 63 - 67 | D | 27- 32 | |
| B- | 57 - 62 | F | < 27 | |
| C+ | 51 - 56 |