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 Lesson Plan- Line Chart

Students Create an Excel Line Chart to Identify Trends and Patterns.

Students create an Excel line chart displaying the monthly temperature patterns for a major world city.

This lesson uses skills developed in previous lessons utilizing merge and center for the title, data entry, text formatting, chart creation, layout selection and formatting, and landscape printing.

The additional skill used here is internet research to locate the annual weather temperature pattern for a selected country. Students use the monthly weather temperature data to create the line chart.

Grades 3+




Excel Line Chart Example:

Excel Line Chart



Class Handout

Students will use this handout to find the monthly average high and low temperatures for a major world city. Students will create an Excel line chart showing the annual temperature pattern.

In order to create the excel line chart students will follow these three steps:

  1. Go to Yahoo Weather and enter the city to search for.

  2. Find and click the Records and Averages link.

  3. Use the monthly average high and low temperatures to create the excel chart.

You can download the handout here. Modify to suit your needs.


Excel Lesson Plan handout for line chart showing patterns.

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