On-Line Technology Practice Modules

Links for K-12 Teachers | Assessment Assistance | On-Line Practice Modules | Daily Dose of the Web

Microsoft Excel Modules

Interactive: Excel 2003 to Excel 2007 command reference guide
Excel 2007 Modules by Internet4Classrooms | 2008 Modules [Macintosh]

If you have a question about using Word in your classroom please send email to Internet4Classrooms.

See a list of non-mathematical uses of Excel Green links indicate Excel workbooks to download (.xls format)

Excel Worksheet Basics Basic terminology Entering and Editing Data Using automatic features Using Functions Using Equations Calculating Percent and Using Absolute Cell Reference		Excel Worksheet Basics Excel X for Macintosh Basic terminology Entering and Editing Data Using automatic features Using Functions Using Equations Calculating Percent and Using Absolute Cell Reference
Standard Toolbar Formatting Toolbar Drawing Toolbar Customizing Toolbars Using menu items part 1 (File, Edit, and View menus) PC Using menu items part 1 (File, Edit, and View menus) Macintosh Using menu items part 2 ( Insert, Format, and Tools menus ) PC Using menu items part 2 ( Insert, Format, and Tools menus ) Macintosh Using Keyboard Shortcuts in Microsoft Excel PC/Windows version Using Keyboard Shortcuts in Microsoft Excel Macintosh version		Creating and Designing Single Use Spreadsheets Calculating sales tax on a purchase Calculating the cost of a trip by car temperature converter calculate the price of pizza per square inch
		Internet4Classrooms forms and templates in .xls format Graph paper - Excel files with small, medium and large grids. Pre-Reading Clock - establishing vocabulary readiness Quadrille paper - Excel files with small, medium and large grids, every fifth line is darker Venn Diagram - two circle, three circle, and instructions to make your own
Using Microsoft Excel to perform classroom tasks		Analyzing Classroom Data - a simple survey
Advanced Topics
Using Excel to Create a Chart or Graph Using Excel as a grade book Using Mail Merge Using Mail Merge - Office 2003 Fostering Literacy with Excel Recording a simple macro Create a chart using pictures for the bars or columns Create an interactive crossword puzzle Create a concept map using Excel Use an Excel worksheet to create a matching activity Make a Scatter Plot with Excel		Using PowerPoint to animate an Excel Chart: Office 2003, Office 2000, or Macintosh X Using a Radar chart to analyze data Make a Custom List Use Excel to Import Data from the Internet Using Conditional Formatting Use Excel to Write a Branching Story Writing Mad-Libs with Excel Make a Review Quiz using Drop-down menus and Conditional Formatting Modifying Excel Charts
Office 2007
Using Excel to Create a Chart or Graph Create an interactive crossword puzzle Using Mail Merge - Office 2007 Using a Radar chart to analyze data Make a Custom List		Use Excel to Import Data from the Internet Using Conditional Formatting Make a Venn diagram Animate an Excel chart in PowerPoint Using Compatibility Mode
Office 2008
Using Excel to Create a Chart or Graph
Using Excel to Make Graphic Organizers
Make a Number Line Make Time Line	Make a Venn Diagram Make a Web	Make a Coordinate Plane Make a Hundreds chart	Make a Ten Frame
Sample Graphic Organizers
Number Line Time Line	Coordinate plane - 4 Quadrants Template for making Webs	Ten Frame Hundreds Chart	Moon Phase Worksheet Moon Phases - Drag to Position Record the Daily Weather

Sample Workbooks to Download
Fahrenheit to Celsius temperature converter M & M Spreadsheet Pizza Calculator - calculate the price per square inch Trip Calculator - How much will a car trip cost? Fostering Literacy Using Excel What would I weigh on...? Twenty Four Hours of Temperature Data	Protecting Cell Contents Using a Macro to Clear Student Responses in a Quiz Mad-Libs with Excel Jeopardy Template See a web page about this template. Earthquake Project (8.4 mB) Drop Down	Sign In Sheet Physics Crossword Puzzle Nursery Rhyme Crossword Puzzle Four Square Puzzle puzzle as a template. Sample concept maps How do I spend my time?
Workbooks designed by others, shared with permission
Review Bingo - This workbook was written by Robert Griffith, an Oak Ridge, TN teacher. Teachers enter short answers in 30 blocks and print 32 bingo cards (4 to a sheet on 8 sheets). Distribute the bingo cards to your class and begin the review. Thanks Robert! Caution: Because of the way that Excel handles dates, you must enclose any dates used in the bingo game in quotation marks! posted on 3/13/06

The links below are not i4c modules, but they are great sources of information
External Links verified 4/9/08

Almost Everything You Need for Using Spreadsheets in the Classroom - Excel Basic quizzes online along with illustrations of various uses of a spreadsheet for the classroom. Great links to find other Excel information on the Internet.
Better Excel Solutions - This web site contains everything you need to know about Microsoft Excel. Their stated hope is that their web site helps you to get the most from your Microsoft Office applications.
Classrooms that Excel Resources - Guides, Tutorials, Applications and Lesson Plans
DataPig Technologies Excel Training - Flash movies that guide you through many lessons on specific Excel how to topics
Excel In the Classroom: What's the hype? - a tutorial from Teach-Nology
Excel Internet Library - quite a few how-to modules, from basics to advanced
Excel Used in Classroom Activities - Numerous activities listed with examples on usage of Excel in the classroom.
Excel-lent Middle School Math Lessons! Can a computer program motivate math students weary of "drill and kill"? Teachers all over the country use Microsoft Excel in ways that excite students about the power of math in everyday life. (a good article from Education World)
The Excelets Page - Excelets are Applets made with Excel instead of Java
To Excel in the Classroom is Elementary - an excellent resource produced by Kathy Adkins, Instructional Technology Specialist for Forsyth County Schools, GA
Graphing Ideas for the Classroom - topics to use collecting information to make a graph
Import Data with Excel - several suggested sources
1. Comparing average monthly temperature maximums - use two or three locations to create a radar chart.
2. The most common chemical elements in the earth’s crust - this would make a nice pie chart
3. Population Density - persons per square kilometer - suggestion: make a bar chart or column chart
4. Weather Underground - Weather Underground has an avalanche of raw data. Go to any city and scroll down to the History and Almanac section. In the Detailed History and Climate section select a date. Very complete data is available as far back as 1996.
5. World Population Clock - projection by the U.S. Bureau of the Census
Integrating Spreadsheets in the Classroom - ideas and lists of links
Interactive Excel - from the Interactive Excel Project at Northwestern University's Collaboratory [many files to download]
Jeopardy - Another example of using Excel to make a Jeopardy review game - (author unknown)
Keyboard shortcuts to use with MS Excel - posted by Pearson Software Consulting Services
Microsoft Excel: Tips and Tutorials using spreadsheets - Don't let the name fool you. There is nothing stupid about these Excel tutorials from MIStupid.com
Microsoft Excel Video Tutorials - "The video will guide you through your chosen subject step by step, with clear and simple annotated instructions.
After watching the video you can download the worksheet used in it, for immediate self-practice." No audio; written directions to read. on 4/8/08
North Canton City Schools Excel Activities - Collection of activities to download and use in your classroom.
Office 2007 Tutorials
1. Introduction to the Excel Spreadsheet - preparing a gradebook
2. More on the Use of a Spreadsheet - making changes to existing spreadsheets
Office Tips for Teachers from Microsoft
1. Create a Timeline in Microsoft Excel
2. Download a sample Timeline and Crossword puzzle clues by Nancy Slonneger, Technology Integration Specialist
Spreadsheet Resources - standards, lessons, and resources
Technology Tutorials: Excel - posted by the Kent Washington School District
Using Spreadsheets as an integrated part of a Literature lesson. - Here is an example of how spreadsheets enter into everyday literature lessons. This lesson uses Shel Silverstein's poem Hungry Mungry.

Enter text in the search box
Search the Internet4Classrooms site

Visitors since November 2000
Memphis, TN

Internet4Classrooms is a collaborative project developed by Susan Brooks and Bill Byles