×
Home Gr. Level Lesson Plans Page Generators Student Award Generators Opinion Paragraph Generators Narrative Paragraph Generators Informative Generators FlipBooks Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple / Mac Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

Excel Spreadsheet and Chart
What is Your Favorite Subject?

Assignment: Students create a simple spreadsheet and chart illustrating their classmates' favorite subjects. Teachers poll students with a show of hands of their favorite subjects choosing from Math, Reading, Science, Art, or Other. Students then use the tally results with a spreadsheet program to create a chart illustrating the results of their favorite subjects.

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

What is Your Favorite Subject?
Finished Spreadsheet & Chart Example:

Students use the tally total results to create a simple chart. Skills to Master: 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 or images and use "Print Preview" to ensure that everything will fit on a single page before printing.

What is Your Favorite Subject?  Finished Chart Example:

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

What is Your Favorite Subject? Tally Sheet:

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

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

Excel Spreadsheet Rubric for Grading Assignments

Excel Spreadsheet Rubric for Grading Assignments

Excel Spreadsheets and Charts

  • Simple
    Bar Chart

    Excel Simple Bar Chart
  • Thanksgiving
    Dinner Shopping

    Thanksgiving Dinner Shopping Comparison Spreadsheet
  • Clothes
    Shopping Budget

    Excel Clothes Shopping Budget
  • Learn Excel
    in Minutes

    Learn Excel in Minutes
  • Excel Back
    to School

    Excel Back to School
  • Excel Pet
    Adoption

    Excel Pet Adoption
  • Excel
    Sports Budget

    Excel Sports Budget
  • Excel
    M & M Chart

    Excel M & M Chart
  • Excel
    Lemonade Stand

    Excel Lemonade Stand Spreadsheet and Chart