This is an Excel 97-2003 workbook collection of 9 project-based, problem solving spreadsheet exercises (with complete keys - SEE PREVIEW) that help students learn to use the following powerful Microsoft Excel functions:
IF
CEILING
CHOOSE
CONCATENATE
COUNTBLANK
RANK
SUM
Each exercise generally takes between 1 and 2 full class periods to complete. I take 10-15 minutes to explain the problem, the deliverable, and the tools, and then let the students work independently or in small groups.
I created these for the Microsoft Excel portion of my 9th-grade Computer Applications class, but also integrated them into my Geomtery, Algebra 2, and Pre-Engineering classes as projects in later years.
Developing a Microsoft Excel skill set is just that important for college-bound students and teachers!
No comments:
Post a Comment