Mrs. Hendrich’s Classroom

Just trying to keep up. . .

Archive for the ‘Comp Apps Class’ Category

Nov 4-5-6: Spreadsheets–Evaluate Your Data

Posted by Patricia Hendrich on November 5, 2009

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!


Posted in Comp Apps Class | Leave a Comment »