|
Title:
| Technology: Excel |
|
Description:
| These sites offer numerous ideas for doing classroom projects that include the use of Microsoft Excel. There are many examples of using timelines, graphs, and probability charts for a variety of fun activities. Many sites offer step-by-step instructions or allow you to download a pre-formatted spreadsheet and change it to fit your needs. Also includes Excel tutorials. |
|
Grade Level:
| 3, 4, 5, 6 |
|
Resource Links:
| Start Here
This is a basic tutorial for Excel. It explains what a spreadsheet is, the types of data that can be entered, and the formulas you can use.
Spreadsheet: A Variety of Activities
There are several online activities to help you learn how to use Excel with your students. "Simple Graphing" will show you how to make a simple graph with Excel. Also includes instructions for timelines and a probability experiment.
A Class Spreadsheet
Students can solve a story problem using a spreadsheet. This lesson plan is targeted for Grade 2.
ThinkQuest: School Spreadsheet Safari
Learn all about spreadsheets, including their history and vocabulary. Click on "Class Activities" and then choose a subject area. The data in these spreadsheets can be manipulated so you can see how the graphs change. Try the crossword puzzle and the quiz.
Group Graphing
This has suggestions for having elementary students graph information and then analyze the data.
Math Forum
This site has instructions on how to make graphs, pie charts, and histograms.
On-Line Technology Practice Modules
This site is full of helpful information about Excel. Scroll down to the sample spreadsheets. Click on these and enter new data (remember to hit return) to see how the answers change. Also, don't miss the ideas for "Fostering Literacy with Excel."
Excel Examples
At the very bottom of the page, click on the tabs to view examples of different information being included in Excel. This offers lots of ideas on how you can use the program in lessons and how you can format your own spreadsheets.
Backyard Birds: Who's Who Out There
This site offers a lesson in using a spreadsheet to chart types of birds. A link to the chart is included. This is an example of incorporating Excel into student activities.
Shopping Spree with Spreadsheets
Students can shop at Wal-Mart and eToys and try to stay within a budget.
Excel Tech Resources
This site has a list of many lesson plans for elementary school students using Excel.
Microsoft: Create a Timeline in MS Excel
Students can use a spreadsheet to create a timeline.
Microsoft: Clues to Climate Change
This science lesson plan is for grades 5-8. Students will use Word, Excel, and PowerPoint.
Franklin Institute: Mungry Math
Students can use information from a poem, "Hungry Mungry" by Shel Silverstein to build a spreadsheet. NOTE: The site includes ads.
Spreadsheet Tools for Schools
Learn techniques of using Excel software through this site.
Microsoft: Create a Pictograph
Students can create a pictograph using Excel.
Fast Food Fun
This site allows students to investigate fast food restaurants and plan a healthy meal.
Videos on Excel
This site has 12 videos on how to use Excel. A handout is also available in MS Word.
Tutorial: MS Office Excel 2003
This 11-page PDF file is a tutorial on MS Excel 2003.
Excel Tutorial
This copyrighted tutorial is provided by the University of Rhode Island.
MS Excel for Teachers
This tutorial emphasizes the creation of charts and graphs.
Introduction to Excel 2003
Teachers and students can learn about Excel.
MS Excel Tips and Tutorials
This site has video tutorials on everything from "Concatenating Cells" to "Print Gridlines." NOTE: The site includes ads. NOTE: The site has a link to a forum.
eThemes Resource: Math: Bar, Line, and Picture Graphs
These sites include examples of different types of graphs such as bar, line, and pictographs. Many of the sites are interactive and demonstrate how graphing works. Also includes several hands-on activities.
|
|
Education Standards:
|
MO Standards:
1.1, 1.2, 1.3, 1.4, 1.6, 1.8, 3, 6
If you are an eMINTS teacher and standards have not been defined for your
state, click the button below to request that they be assigned to this resource.
|
