K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Excel - What is Your Favorite Subject?

Create a Chart Illustrating Classmates' Favorite Subjects

Teachers poll students with a show of hands of their favorite subjects.


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 bar or column chart illustrating the results of their classmates' favorite subjects.

Grades 2+


Download: what-is-your-favorite-subject-tally-sheet.pdf


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


Download: excel-what-is-your-favorite-subject-chart.xlsx



Favorite Subject Chart - Finished Example

Students use the tally total results to create a simple bar or column 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.


What is Your Favorite Subject Excel  Chart


What is Your Favorite Subject 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 Subject Tally Sheet


Excel Spreadsheet Rubric for Grading Assignments:

Spreadsheet Rubric

More Ideas
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
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
  • Copy and Paste Practice
  • M & M
    Excel Chart
  • Excel Pie Chart
  • Newspaper
  • Newspaper Template