K5 Computer Lab Lesson Plans

Excel - How do You Get to School ?

Create a Chart Illustrating How Classmates Get to School

Teachers poll students with a show of hands on how they get to school; by bus, car, walking, or other method.

The 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 then use the tally results with a spreadsheet program to create a bar chart illustrating the results of how their classmates get to school.

Grades 2+



Get To School 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.


Download: how-do-you-usually-get-to-school-tally-sheet.pdf



How Do You Usually Get to School Tally Sheet



Download: how-do-you-usually-get-to-school.xlsx


How Do You Usually Get to School Chart - Finished Example

Students use the tally total results to create a simple bar chart. Students should format the 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 bar on the chart. Students should add clipart and use "Print Preview" to ensure that everything will fit on a single page before printing.

How Do You Get to School Chart



Excel Spreadsheet Rubric for Grading Assignments:

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


Spreadsheet Rubric


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

    Computer Lab Rules Essentials
  • California Regions

    California Regions Brochure
  • Amazing Animals

    Amazing Animals
  • I Am
    Poem Generator

    I Am Poem Generator
  • "Floater"

    I Can Float Animation
  • Copy and Paste

    Copy and Paste Practice
  • Learn PowerPoint
    in One Minute

    Learn PowerPoint in One Minute
  • M & M
    Excel Chart

    Excel Pie Chart
  • Newspaper

    Newspaper Template