EDT 321Final Grading Criteria
Grading Sheet
WORD
POINTSTASK / POSSIBLE / EARNED
1 / Title Page – centered text on separate page (any font, any size, any style) / 1
2 / Footer with page number on right side of each page / 1
3 / Header with student name on left side of each page except Title page / 1
4 / All margins 1.25” on all pages / 1
5 / All body text is serif font, size 12 / 0.5
6 / Bullet style is changed (any style except 4 dots in a diamond shape), all bullets are the same / 0.5
7 / 3 heading styles are used / 1
8 / Table of Contents on separate page after title page / 1
9 / Entries at each of 3 levels in the TOC – no more than 3 level 1 entries, 8 level 2 entries, and 26 level 3 entries in TOC / 1
10 / TOC formatted as the rest of the document / 1
11 / Bold or underlining used consistently somewhere in the body of the document / 0.5
12 / Spelling errors corrected / 0.5
TOTAL / 10
EXCEL
POINTSTASK / POSSIBLE / EARNED
1 / Formula used for total sales for each region, totals correct / 1
2 / Formula used for quarter averages for each region, averages correct / 1
3 / Formula used for quarter totals, totals are correct / 1
4 / Formula used for quarter averages, averages are correct / 1
5 / Table is readable and understandable. Table is formatted with lines and font changes that set off labels and totals (this is a personal decision – no required format) / 2
6 / Line graph showing all regions by quarters, labels present (legend, chart labels and labeling of axis required) / 2
7 / Pie chart showing percentage of total sales by region (both legend and chart labels required) / 2
TOTAL / 10
POWERPOINT
POINTSTASK / POSSIBLE / EARNED
1 / 8 slides (or more) in final file with common template / 1
2 / Title slide (should say ABC Incorporation or ABC Incorporated somewhere) and use word art for the Title / 1
3 / Data present (either numbers or chart) on each regional slide – from Excel file / 1.5
4 / Data present (either numbers or chart) on Quarterly Results/ Annual Results/ Conclusions/Recommendations slide – from Excel File / 1.5
5 / Clip art present on at least on two slides / 1
6 / Animate the two cliparts that you have inserted / 1
7 / Insert a logo on the master slide & Use drawing tool to create the logo. Use at least two objects from the drawing toolbar and make sure to group them. / 1
8 / Footer present with student name in lower left corner of each slide / 0.5
9 / Page numbers present on each slide in upper right corner of each slide / 0.5
10 / Slide transition present (all slides have same transition) / 1
TOTAL / 10
Word Total (10 possible)______
Excel Total (10 possible)______
PowerPoint Total (10 possible)______
FINAL TOTAL (30 possible)______