K5 Computer Lab Lesson Plans

Halloween Excel Chart

Create an Excel Halloween Costume Donations Chart

Students at your school have convinced a major Halloween costume company.to donate a variety of costumes for needy children in their community.

 

Each student can choose 7 or more types of costumes from the Halloween Costume List to donate to the children.

 

Students add their costume choices and the quantities into an Excel spreadsheet.

Students use their information to create a bar or column chart. Grades 2 +

 

 

Students may personalize their chart with different color bars or columns.

Student may insert related clipart or pictures to decorate and illustrate their chart data.

Download: excel-halloween-costume-donations-chart.xlsx

 

Download: excel-halloween-costumes-list.pdf

 

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

 

 

This Excel Lesson Teaches the Following Basic Skills:

1) Entering data in columns and rows.

2) Using Merge and Center to merge cells while centering the title.

3) Using different colors for chart bars to improve visual presentation.

3) Creating, sizing, and positioning the chart to fit on a single page with the data.

4) Searching, inserting, sizing, and positioning clipart or pictures.

5) Using print preview and print.

 

Halloween Excel Chart - Finished Example:

Download this make it available for students to view as an example of a finished chart.

Excel Halloween Chart

 

Excel Halloween Costume List:

Download and make this available for students to use when creating their spreadsheet and chart.

Excel Halloween Costume List

 

Excel Spreadsheet Rubric for Grading Assignments:

Download and use this rubric to assess the completed spreadsheets and charts.

Spreadsheet Rubric

 

 

Common Core Standards

CCSS.Math.Content.2.MD.D.10 Draw a picture graph and a bar graph (with single-unit scale) to represent a data set with up to four categories. Solve simple put-together, take-apart, and compare problems1 using information presented in a bar graph.

CCSS.Math.Content.3.MD.B.3 Draw a scaled picture graph and a scaled bar graph to represent a data set with several categories.

CCSS.Math.Content.4.MD.A.2 Represent measurement quantities using diagrams such as number line diagrams that feature a measurement scale.

 

 

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

Ideas
for iPads / Mac / iWork

  • iPad
    Biography

    iPad Biography Summary
  • Character
    Analysis

    iPad Character Analysis
  • First, Next,
    Then, Finally

    First, Next, Then, Last Template
  • Main Idea
    and Details

    Main Ideas And Details Template
  • Newspaper
    Template

    iPad Newspaper Template
  • Spelling Words
    Comic

    iPad Spelling Words Comic
  • Frog Lifecycle
    Mini Poster

    Frog Lifecycle Mini Poster
  • Labeling
    Bones of the Body

    iPad Labeling Bones
  • iWork Numbers
    Shopping Chart

    iWork Expense Chart
  • iWork Numbers
    My First Chart

    iWork - First Chart
  • iWork Numbers
    M & M Chart

    iWork M&M Chart
  • iWork Numbers
    Budget Chart

    iWork Budget Chart