EXCEL LESSONS

Below are examples of Excel activities prepared by students in my Methods of Teaching Secondary Mathematics class over the past few semesters. Most of these actvities are self-guided and self-paced worksheets that teach students how to accomplish certain tasks in Excel. Many of these activities also require a prepared Excel spreadsheet file, which you will have to download as well.
All of the activities below are PDF files. In order to view and print them, you need to have Adobe Acrobat Reader installed on your computer. If you do not already have it, click on the icon to the right to get your free copy.

Average Daily Tree Sales (PDF file)
by Tracey Rickert

Class Averages (PDF file)
Sample Class Info (Excel file)
by Matt Farr

Compound Interest (PDF file)
by Kerry Snyder

Constructing a Graph (PDF file)
by LeeAnn Watts

Creating a Pictograph (PDF file)
by Justin Vallone

Creating a Pie Chart on a Picture (PDF file)
by Edie Franks

Creating Charts (PDF file)
by Shaunna Knepp

Double Bar Graph Activity (PDF file)
Olympics Spreadsheet (Excel file)
by Annette Busack

Excel-lent Report Card Activity (PDF file)
Report Card Spreadsheet (Excel file)
by David Finnerty

Grade Sheet Activity (PDF file)
by Jeremy Smoyer

Keeping a Checkbook (PDF file)
by Caitlin Sublette

Making a Basic Pie Chart (PDF file)
by Bob Biese

Making a Chart (PDF file)
by Karen Guellich

Making a Chart (PDF file)
by Lindsey Swavely

Mean, Median, & Mode (PDF file)
by Brenton Beichey

Not Real Estate Activity (PDF file)
Not Real Estate Spreadsheet (Excel file)
by Rob Schwindt

Other Ways to Interpret Data (PDF file)
by Rachael Kanusky

Recording the Weights of Wrestlers (PDF file)
by Rob Shields

Stock Market Activity (PDF file)
Dr. Moneymaker (Excel file)
by Jeff Kerchner

Tracking the Stock Market (PDF file)
by Missy Ebling

The Catcher Who ‘Excel’-ed Activity (PDF file)
Baseball Spreadsheet (Excel file)
by Chris Kavcak

The King’s Coffers Activity (PDF file)
King’ Coffers Spreadsheet (Excel file)
by Mike Tanczos

Triangle Activity (PDF file)
by Julia Marusiak