K5 Computer Lab Lesson Plans

Excel Chart - What is Your Favorite Ice Cream Flavor?

Create an Excel Chart Illustrating Favorite Ice Cream Flavors

The instructions are for Microsoft Excel, but the data and chart can be recreated using any suitable spreadsheet application.

Teachers poll students with a show of hands of their favorite ice cream flavor.

 

Teacher takes a tally using the tally sheet provided and projects it for students to view, or writes the tallies and results on the whiteboard.

 

Students use the tally results with a spreadsheet program to create a column chart illustrating the results of their classmates' favorite ice cream flavors. Grades 2+

 

Download: what-is-your-favorite-ice-cream-flavor-tally-sheet.pdf

 

Download: rubric-for-spreadsheet-with-chart.pdf

 

Download: excel-what-is-your-favorite-ice-cream-flavor-chart.xlsx

 

 

Excel Chart - Favorite Ice Cream Flavor - Finished Example

Students use the tally total results to create a column chart.

Students should format the chart title with a font color, style and larger size.

Students should use "merge and center" to spread the title across several columns.

Students should use additional formatting to change the colors of each column on the chart.

Students should add clipart and use "Print Preview" to ensure that everything will fit on a single page before printing.

 

 

What is Your Favorite Ice Cream Flavor Chart

 

What is Your Favorite Ice Cream Flavor Tally Sheet Example:

Teachers can poll the class and take the tallies, or print sheets for the students to take the tallies and practice their data collection accuracy skills.

What is Your Favorite Ice Cream Flavor Tally Sheet

 

Excel Spreadsheet Rubric for Grading Assignments:

 

Spreadsheet Rubric

 

Popular:
For PC's and Microsoft Office

  • Excel
    Bar Chart

    Excel Bar Chart
  • Thanksgiving
    Copy and Paste

    Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing

    Green Screen Photo Editing
  • Computer Lab
    Rules

    Computer Lab Rules Essentials
  • California Regions
    Brochure

    California Regions Brochure
  • Amazing Animals
    PowerPoint

    Amazing Animals
  • I Am
    Poem Generator

    I Am Poem Generator
  • "Floater"
    Animation

    I Can Float Animation
  • Copy and Paste
    Practice

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper
    Template

    Newspaper Template