Description
NOTE: Check out Microsoft Excel Functions Workbook, Volume 1!
This is an Excel 97-2003 workbook collection of 15 project-based, problem solving spreadsheet exercises (with complete keys - SEE PREVIEW) that help students learn to use the following powerful Microsoft Excel functions:
SUM
AVERAGE
IF
COUNTIF
COUNTBLANK
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!
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Microsoft Excel Functions Workbook, Volume 2 (BUSINESS MATH)
Highlights
Description
NOTE: Check out Microsoft Excel Functions Workbook, Volume 1!
This is an Excel 97-2003 workbook collection of 15 project-based, problem solving spreadsheet exercises (with complete keys - SEE PREVIEW) that help students learn to use the following powerful Microsoft Excel functions:
SUM
AVERAGE
IF
COUNTIF
COUNTBLANK
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!
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
