Page 3 |
Grading:
All four tables and graphs must be completed for full credit.
(1 table & graph will be 1/4 points, 2 tables & graphs will be 1/2 points, 3 tables & graphs will be 3/4 points)
Table:
A: Colors need to be approximately the same
B: the total column needs to be done with a sum function =sum(C2:D2)
C: the average needs to be done with an average function =average(E2:E13)
D: Freeze the first row so it is always on top even if you scroll down
E: The boxes need to be outlined
F: The year needs to have colored boxes
Graph
G: The year is main title at top
H: The 3 lines need to be labeled at top
I: The x-axis will be labeled month
J: Ticks marks on x-axis and y-axis
K: Major lines in black, while minor lines a different color
L: Background color matches year color
12 points total, (1 point for each item)
All four tables and graphs must be completed for full credit.
(1 table & graph will be 1/4 points, 2 tables & graphs will be 1/2 points, 3 tables & graphs will be 3/4 points)
Table:
A: Colors need to be approximately the same
B: the total column needs to be done with a sum function =sum(C2:D2)
C: the average needs to be done with an average function =average(E2:E13)
D: Freeze the first row so it is always on top even if you scroll down
E: The boxes need to be outlined
F: The year needs to have colored boxes
Graph
G: The year is main title at top
H: The 3 lines need to be labeled at top
I: The x-axis will be labeled month
J: Ticks marks on x-axis and y-axis
K: Major lines in black, while minor lines a different color
L: Background color matches year color
12 points total, (1 point for each item)