|
Excel Midterm Exam Rubric (Assessment Checklist for Exam Performance) |
|
Graded Task |
Point Value |
|
Creation of new workbook from template. |
5 points |
|
Accurate entry of labels/values. |
10 points |
|
DB formula and quarterly calculation; results entered on IncomeStatement sheet. |
10 points |
|
SUM or addition formula in column F. Subtraction formula in row 9. |
10 points |
|
IF formula to show Profit or Loss in row 10. |
15 points |
|
MIN, MAX, and AVERAGE functions; 5 points for each one. |
15 points |
|
Equity document theme applied. |
5 points |
|
Footer on both sheets. |
5 points |
| New sheet with labels and dates; formatting. |
10 points |
|
Years of service formula. |
10 points |
|
File named, saved, and submitted. |
5 points |
|
|
100 points |
Grading Scale
90 - 100% A
80 - 89% B
70 - 79% C
60 - 69% D
59% & below F
 |
 |
 |