This lesson encourages students to tally a number of different colored m&ms from 4 different packs (displayed on a PowerPoint to aid visual learners). Students then use this data to create a spreadsheet and go on to create 4 different graphs. Students are then expected to answer graphs related questions in order for them to think in detail as well as solve problems.

This lesson can be extended further to meet the needs of fast learners/Gifted & Talented students. The resources for this lesson will teach students how to use Microsoft Excel in a fun and engaging manner. It has been trailed and tested in the classroom and is a proven success.

This resource includes:

• Worksheets
• Suggested lesson plans
• PowerPoint Slides
• Answer Keys

Thank you to Krista Wallden for all illustrations.

Other Microsoft Excel Products Available:

• Microsoft Excel Bundle 1: Click Here

• Microsoft Excel Bundle 2: Click Here

• Grades 1- 4: Microsoft Excel The Bundle: Click Here

• Excel Spreadsheets - Lesson Book & 7 Different Spreadsheets: Click Here

• Introduction to Excel Spreadsheets & Formulae Lesson Plan: Click Here

• Google Sheets & Excel Spreadsheets - Task Cards/Help Cards (Formula Practise): Click Here

• Pocket Money - Activity Spreadsheet: Click Here

• Spreadsheet and Graph Skills - McDonalds Scenario: Click Here

• Million Dollars - Activity Spreadsheet: Click Here

• Christmas Mystery Pictures Fill Color - Computer Lab: Click Here

• Valentine’s Day Mystery Pictures Fill Color - Computer Lab: Click Here

• St. Patricks Day Mystery Pictures Fill Color - Computer Lab: Click Here

• Christmas Mystery Pictures Fill Color 2 - Computer Lab:Click Here

• Seasonal Mystery Pictures Fill Color Bundle - Computer Lab Click Here

• Presidents Day Mystery Pictures Fill Color - Computer Lab: Click Here

• Easter Mystery Pictures Fill Color - Computer Lab: Click Here

• Halloween Mystery Pictures Fill Color - Computer Lab: Click Here

• Excel - Spreadsheets Toolbar: Click Here

• Introduction to Formulae in Excel Lesson Plan: Click Here

• Creating Graphs in Excel: Click Here

• Excel Spreadsheets Word Wall: Click Here

• Excel - Spreadsheets Reminder:Click Here

• Excel - Spreadsheet Test: Click Here

• Supermarket Comparison - Activity Spreadsheet: Click Here

• Excel Spreadsheets - Different Cursor Meanings: Click Here

• Chart Analysis in Excel Spreadsheets: Click Here

• Analyzing Excel Spreadsheets: Click Here

• Mystery Pictures - Excel Spreadsheets Cell References: Click Here

• Excel - Spreadsheets Formulae: Click Here

• Harry's Excel Spreadsheets: Click Here

• Absolute Cell Referencing Worksheet: Click Here

• Bal's Tanning Salon - Activity Spreadsheet: Click Here

• Excel - Introduction to Spreadsheets & Calculations: Click Here

• Mystery Pictures - Excel Spreadsheets Conditional Formatting: Click Here

• Microsoft Excel Spreadsheet and Graph Skills - M&M's Scenario: Click Here

• Microsoft Excel Spreadsheets Paper Test: Click Here

• Microsoft Excel Spreadsheet Features & Chart Task Cards Help Cards: Click Here

• Excel 2010 Toolbar - All Tabs Activity: Click Here