Skip Navigation

###### BUS:Skittles Candy Count (Excel)
 Life Skills:Employability Time Frame:3 class periods that run 45 minutes each.Group Size:Individual Summary:The Skittles Candy Count is an introductory lesson on how to work in Excel. Students will learn how to use formulas, edit the spreadsheet, and create and edit charts. Main Curriculum Tie: Career and Technical Education IntroductionStandard 4 Objective 1Students will demonstrate basic knowledge and application of hardware, software, and Internet use.Materials:Excel software program. A package of Skittles per student (the small packages work great). Instructions (attached). The Candy Count sheet (attached).Attachments Candy_Count_Sheet.doc Candy Count Sheet Candy_Count_Sheet.xls Candy Count Template Spreadsheets.doc Skittles Candy Count instructions. Background For Teachers:This is an on-you-own assignment. This works great for classes that are working in rotations. The students will need the instruction book, a package of Skittles, and the Candy Count Sheet. The students will count the number of each color of Skittles. Then they will record it onto their Candy Count sheet. Then they will talk with the rest of their group and record their answers. Next, they will input this information into the computer. After they add the data, they will format the Spreadsheet, and create and format a chart.Student Prior Knowledge:No prior knowledge in this software is needed.Intended Learning Outcomes:Students will be able to add data to a Spreadsheet, format it, add a chart and format it.Instructional Procedures:The students will count the number of each color of Skittles. Then they will record it onto their Candy Count sheet. Then they will talk with the rest of their group and record their answers. Next, they will input this information into the computer. After they add the data, they will format the Spreadsheet, and create and format a chart. Strategies For Diverse Learners:This is a great activity to pair students together to work together. If a student is more advanced, pair them with a struggling student.Assessment Plan:Attachments Chart.xls Key Bibliography:This is a modified version of the Smarties Candy Count that used a software other than Excel.Author:KATIE SCHOLER Created Date :May 25 2005 16:39 PM
 7641
© Utah Education Network in partnership with the Utah State Office of Education and Higher Ed Utah.
UEN does not endorse and is not responsible for content on external websites linked to from this page.