EXCELent Ideas

Microsoft Excel in the Classroom

Links to Help You Learn How to Use Excel

Ideas for the Classroom
Excel Tutorial Using Spreadsheets to Teach Mathematics - lots of ideas!
eMints Guide to Using Excel for Teachers-easy to understand Spreadsheets:  A Variety of Activities-this site concentrates on Grades 3-5, but adaptations could be made for other ages easily.  STEP by STEP instructions for some activities.
Introduction to Excel -starts with how to open the program Create a Self-Checking Review or Quiz a tutorial
Customizing Toolbars The process of customizing a toolbar is explained using the Standard Toolbar found in Microsoft Word as an example.  Word and Excel toolbars are similar and the process is the same for all Office programs. How to Create a Multiplication Self Checking Activity
Using menu items part 1  Using menu items part 2 How to Create Timelines
Using Excel to Create a Chart or Graph

Almost Everything You Need for Using Spreadsheets in the Classroom

 

TEMPLATES

These are templates from Internet4classrooms that you might find useful.  Download to your computer and then open in Excel.  (click on the link, choose FILE/SAVE AS and then put it on your disk or in My Documents.  Make sure the file type says "excel workbook".)
Fahrenheit to Celsius temperature converter - Enter either temperature and instantly see the other temperature Pizza Calculator - calculate the price per square inch - Enter the diameter of the pizza and the price, find out how much the pizza costs per square inch. Trip Calculator - How much will a car trip cost? - Enter the distance between two locations, the current cost of gasoline and the number of miles per gallon which a car uses. Find out the fuel cost of the trip
M & M Spreadsheet - A workbook composed of several sheets, each showing progressively more information regarding an M&M spreadsheet project. The spreadsheet is actually a tutorial. Start with the first worksheet (the first tab on the left at the bottom of the workbook) and progress through the tabs, trying the things you read. What would I weigh on...? - An interactive workbook which uses hyperlinks and protected cells. Calculate your weight on another planet. Mad-Libs with Excel - This worksheet is password protected so students can only type in the response boxes. A macro, which allows the responses to be cleared for the next person, is part of this worksheet. When you open the workbook, select "enable macros."
Fostering Literacy Using Excel - Several examples of language arts skills which could be reinforced using Excel's drag and drop capability.

Back to Teacher Resources Page  /  Back to Richwoods Home