K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators 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

iWork Numbers Spreadsheet - Temperature Chart

Students Create a Line Chart of Monthly Temperatures

 

Students research a world biome to find its average monthly high and low temperatures for one year and chart the results.

 

This lesson teaches students a variety of skills for spreadsheet creation including data entry and formatting, merging cells for the title (Tundra Biome Temperatures), autofill for the month, and line chart creation.

 

 

 

iWork Numbers Spreadsheet - Create a Line Chart Video Tutorial

This 2 minute video will show you step by step how to create the biome temperature line chart in iWork Numbers.

 

Instructions:

1) Students choose a biome to research for average high and low weather temperatures.

2) Students use iWorks Numbers to create a spreadsheet and chart of their data.

3) Create a title and use "merge cells" to format the title.

4) Enter the month "January" and use autofill to complete the remaining months.

5) Enter the high and low temperature data.

6) Create a line chart with a title and size and position the chart to print on a single page.

 

Line Chart Finished Example:

iWorks Numbers Line Chart

 

Popular for iPads - iWork

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