Click on one of the lesson titles below. 
Scroll past the table below to view the lesson.

Raleigh Bound!! A Virtual Tour

 Rikki-Tikki Research

Publishing a Narrative.... Our Trip to Raleigh 

Famous North Carolinian Research

 Research NC Symbols
Symbols Scrapbook

Hyped up Over North Carolina Symbols

Approximate Time Required
      At least 40 minutes in the computer lab

Curriculum Areas NC Standard Course of Study:

Computer/Technology Skills
    Goal 2:  The learner will demonstrate knowledge and skills in using computer technology.
        Objective 2.7 Practice proper keyboarding techniques for upper and lower case letters.
        Objective 2.8  Recognizing word processing terms and functions

    Goal 3:  The learner will use a variety of technologies to access, analyze, interpret, synthesize, apply and
                  communicate information.
        Objective 3.3 Create a table/graph from spreadsheet data.

Teacher's Lesson Goals/Objectives

• Students will understand the basics of a spreadsheet
• Students will become familiar with spreadsheet terms
• Students will be able to use the data gathered to make a pie graph
• Students will use clip art to decorated their graph.
• Students will print the final product.

Materials

• Mini bag of Skittles (one per child)
• Paper and pencil
• Computer
• ClarisWorks spreadsheet program and clip art
• Printer

    Students have prior knowledge of creating spreadsheets and graphs on the computer.
Students have prior knowledge of inserting clip art in to documents.

Activities

1. Students open their pack of Skittles
2. Each student will tally how many of each color of Skittles they have.
3. Students will open the ClairsWorks application and click on Spreadsheet.
4. Each student will insert a header into their spreadsheet then type in the name.
5. Type in the title "What Flavor Are Your Skittles" in cell A1
6. Starting in cell A2 each student will insert the data the collected into the cells of the spreadsheet.  Starting with the flavors in column A and how many of each in column B.
7. Next highlight cells A1 through B6 that have their information.
8. Go to Options (located on the menu bar) and choose Make Chart.
9. Choose Pie Chart and click on OK
10. Double click on the pie graph to return to the Chart Options.
11. Click on Series and then click on Label Data and choose % in slice. (The graph will then appear showing the flavors and their %).
12. Students may then put some appropriate clip art around their graph.
13. Students should move the graph so both their spreadsheet data and the graph will show when it is printed.
14. Students print their graphs.

Each student's graph will be graded on:

1. Successfully completion of the graph without assistance
2. Directions were followed exactly and both spreadsheet and completed pie graph with % are shown.
3. Spreadsheet information is accurate
4. Clip art used and is appropriate for the pie chart

Return to Top