K5 Computer Lab Lesson Plans

Excel Pie Chart - My Zoo Animals

Students Create a Pie Chart about Zoo Animals

Students imagine they have a mini-zoo with several types of animals. Students use their worksheet to count how many mammals, birds, fish, reptiles, or amphibians they have.

Students use their data to create a spreadsheet and pie chart illustrating the number of each type of animals in their zoo. Grades 2+

 

Download: excel-zoo-animals-finished-example.xlsx

 

 

 

Download: zoo-animals-handout-for-charting-01.docx

 

Download: zoo-animals-handout-for-charting-02.docx

 

Download: zoo-animals-handout-for-charting-03.docx

 

Download: zoo-animals-handout-for-charting-04.docx

 

 

Instructions:

Make the zoo animals handout available to students. Students count how many mammals, fish, reptiles, and birds they have on their handout and write in their answers. Students open a spreadsheet program and add a title with their name in it (Sydney's Zoo Animals).

Students enter their animal name types (Mammals, Fish, Reptiles, Birds) in column A, and the numbers they have of each type in column B.

 

Students use the information to create a simple pie chart. Students may add related clipart to illustrate. Students save and / or print their finished work.

 

Excel Zoo Animals Chart Finished Example

Excel Zoo Animal Chart

Excel Zoo Animals Chart - Student Handouts

Pass these handouts to the students. Students count the types of animals and enter the info on the handout. Students use the numbers to create their pie chart on a spreadsheet. (Excel, Google Spreadsheets, iWork Numbers, etc.) Each handout differs slightly from the others so there will be a variety of student chart results.

 

Zoo Animals Handout - 01

Excel Zoo Animals Student Handout -01

Zoo Animals Handout - 02

Excel Zoo Animals Student Handout -02

 

Zoo Animals Handout - 03

Excel Zoo Animals Student Handout -03

 

Zoo Animals Handout for Charting - 04

Excel Zoo Animals Student Handout -04

 

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