|
|
| A SPECIAL INVITATION FOR TEACHERS... |
 |
 |
LessonPlansPage.com would like to take a moment to let you
know about Concordia University's new Master’s Degrees in Education that you can complete online in just one year!
Available Master's Degrees in Education include:
- Curriculum & Instruction: Reading
- Curriculum & Instruction: Methods & Curriculum
- Curriculum & Instruction: English to Speakers
of Other Languages
- Educational Leadership
These programs can help you:
- Open the door to a variety of school leadership career opportunities like higher education teaching, department chair, ELL consultant, literacy coach, or curriculum coordinator
- Complete your degree in one year, on your schedule,
from the comfort of your home
- A Master's Degree could mean an automatic salary increase in your school district!
A national university system with 10 campuses throughout the United States, Concordia was founded more than 100 years ago and is accredited by the Northwest Commission on Colleges and Universities.
 Printable Version for your convenience!
Title - What Color Are Your Skittles?
By - Ellyn Bewes
Primary Subject - Computers / Internet
Secondary Subjects - Math
Grade Level - 5-6
What Color Are Your Skittles?
Discipline/ Focus: Computer Applications
State/Local Standard - Florida:
Create and manipulate spreadsheets and graphs
Overview/Summary: In this lesson the child will learn how to create spreadsheets, to chart the different colors in a package of Skittles. They will collect data, create appropriate charts and use percentages to describe quantities.
Lesson Time: 4 class periods
Guiding Question: Do all packages of Skittles have the same number and color combinations?
Learning Objectives: The student will learn how to create a spreadsheet to chart the different colors in a package of Skittles. They will collect data, create appropriate charts and use percentages to describe quantities.
Materials: 1 package of Skittles
Microsoft EXCEL
Internet Resources: www.skittles.com
Procedure
Open the package of Skittles and tally the amounts of the different colors of Skittles found in your packages (write the colors and numbers on the back of this sheet).
1. Open the program called Microsoft Excel. The first time we use this program we need to click on "Start" to begin.
2. Click the mouse in cell B1 and type "My Skittle Colors" in the entry bar.
3. Highlight "My Skittle Colors" in the entry bar and change the font size to 14 and BOLD.
4. Press the enter key to move the information from the entry bar to the active cell.
5. Click the mouse in cell B3 and type in "Green". Highlight the word Green and change the font to size 12 and make it BOLD.
6. Highlight cells B4 through B7, change font to size 12 and BOLD.
7. Enter the names of the different colors of the Skittles into cells, B4, B5, B6 and B7. Place your mouse in cell B4 and type in the next color. Continue until all the colors are entered.
8. After you have labeled all of your candy colors, you will need to enter the data recorded for each color. Click the mouse in cell C3 and enter the number of green Skittles found in your package. Repeat for all the colors, entering the data down column C.
9. Once the data is entered, click on cell B3 and drag the mouse to the end of where you entered information in Column C. From the Insert Menu on the Task Bar select Chart. Select Pie Chart. Click next and next again. In the Title Selection space type _____'s Skittles. (Put your name on the blank line.) Click on the Data Option tab and select percentages, and then Finish
10. Move the Pie chart off the spreadsheet table by clicking on the pie chart and dragging to the side. To increase the size of the pie chart, drag down on the bottom and side of the chart area, and the chart will grow in size.
11. Change the color of each piece of pie on the chart by double clicking on the color square in the legend, and selecting the appropriate color from the Pattern tab color chart. The legend and the piece of pie will change to this new color after you click OK.
12. When you have completed your pie chart, click on Print Preview to make sure that the chart and the spreadsheet will be printed. Save your work on your disk - call it Skittle Colors - and print 2 copies.
Outcome/Assessment Children complete their spreadsheet and pie chart graphs. They compare their results to answer opening question and check the web site to see if their pie charts and percentages are the same as those advertised on the web.
Extensions This activity can also be done with M&M's, or any other material with multi-colors (colors in fruit loops, etc.)
Ellyn Bewes
Opa-locka Elementary School
Opa-locka, Florida 33054
E-Mail Ellyn Bewes!
|
|
|
Math
Language Arts
Science
Social Studies
Art
Computers & Internet
Music
P.E. & Health
Other
Multi-Disciplinary
