|
Excel Final Exam Rubric (Assessment Checklist for Exam Performance) |
The graded tasks below describe the skills you need to study for the production portion of the final exam.
|
Step/Result |
Point Value |
Comments |
|
12 |
25 |
Function changed to SUM in all worksheets. Worksheet tab colors set. |
|
3 |
10 |
Patterned fill changed. Footer added. |
|
45 |
20 |
WordArt object created and positioned, then copied to each sheet. |
|
6 |
25 |
Consolidated sheet completed with SUM. Requires two consolidation commands. |
|
7 |
5 |
Formula sheet prepared for consolidated sheet. |
|
89 |
10 |
Comment inserted and formatted. Should be displayed. |
|
10 |
5 |
File named, saved, and submitted. |
Grading Scale
90 - 100% A
80 - 89% B
70 - 79% C
60 - 69% D
59% & below F
 |
 |
 |