Home | Lab These lessons are aligned to the Nevada State curriculum Technology Standards for Elementary School.
How to SAVE Templates Learning Microsoft Excel Tutorials for Teachers
Essential Technology Skills Grade K Grade 1 Grade 2 Grade 3 Grade 4 Grade 5 Many of the documents on this website require Adobe Acrobat Reader. CLICK HERE to download this FREE reader.
Using Spreadsheets with:xxxxK-1 xxxxxx 2-3 xxxxxxx4-5
Lessons A-Z with Microsoft Excel - 26 great lessons to choose from! K-5
The ABC List of Things to Graph - Use Excel in the computer lab or just grab some ideas for classroom graphing activities. K-5
Eye Color Graph - Reinforce tally skills and develop basic understanding of a spreadsheet. Students will enter data and create a pie graph. Tally Chart (right-click on link > Save Target As > Save as a JPEG image to a location of your choice. Use Paint program (Start/All Programs/Accessories) or Kidpix to edit with group using LCD projector). Grade 2-3 Sample
Nutritional Food Lables - Introductory spreadsheet activity. Students analyze food lables enter data on spreadsheet, and calculate totals. Grades 4-5 Resources: Food Lable Slides
Student Survey - Students survey classmates or schoolmates on such things as favorite tv show, favorite movie, favorite kind of music, etc. Data is entered into spreadsheet. Grades 3-5
Graphing M&M's - Students count and graph the different colors of M&M's in a bag. Grades 3-5
Create a Pictograph - Use your imagination to graph everything from animals to lost teeth! Grades 2-3
Jelly Bean Jackpot - Estimate and graph the actual amount of jellybeans in a bag. Grades 3-5
Graphing Weekly Weather - Use a spreadsheet or the provided worksheet to graph a 5 day forcast. Grades 3-5
Coin Toss and Probability Graph -Use the Interactive Coin-Flipping Page and Coin Toss Data Table Template (or create your own template with these Directions). to track each toss. Create a graph of the data. Grades 4-5
Shopping spree - You have just received a check for $1,000! Go on an online shopping spree at your favorite toy store. Use the online interactive spreadsheet worksheet to keep track of your money. Grade 5
Spreadsheet Suggestions for grades K-1 - Ideas for setting the foundation for using spreadsheets.
Why do I Need a Spreadsheet Anyway ? - Ideas for using spreadsheets for K-5
What percentage of your classroom is right or left handed? Decision of the Day - In this activity second and third grade students utilize the computer to help formulate the decision of the day. This is a great activity to use several weeks prior to an election. Use this basic chart in Excel to gather information on a simple yes-no question that students formulate. Students can see how easy it is to create a simple graph with one of the function keys. Excel Chart Grades 2-3
Create a Wordsearch - Students find words to go along with a particular unit of study (i.e. the Revolutionary War) and create a wordsearch using MS Excel. Sample Grades 4-5
Last Updated on April 27, 2007 Nancy Housman, Educational Computer Specialist Contact Us