Excel Project 3-Evaluate Your Data
Class Demo: Payroll Review
Sort, criteria, filter, hide, chart, freeze panes, absolute and relative formulas
Exercises: (use payroll review for all)
3-1 Sort Data
3-2 Filter Data
3-3 Charts
Guided Practice Together: (skip)
Assign:
_____Independent Practice:
Update your grade spreadsheet by adding new graded assignments.
Create a chart on the same page as your spreadsheet that includes your score, and points possible. Format the chart attractively with data labels or a legend. Put a title on the chart.
Print Regular and hand in with cover sheet. (25 pts)
_____Begin Practice Packets.
Save each file in H with the name: Problem #
Show me each printout, and I will check formulas from your screen
Hand in work with cover sheet at end of each class!
