TPT
Total:
$0.00

Make 2 Line Charts in Excel Spreadsheet Resource 9A

;
Grade Levels
6th - 12th, Adult Education, Homeschool
Resource Type
Formats Included
  • Zip
Pages
8 pages
$3.00
$3.00
Share this resource
Report this resource to TPT
Also included in
  1. There are other Excel Bundles you can buy on TPT, but none like this! It's differentiated so you can use it with EVERY student in your class: mainstream, Special Ed, beginner English Language Learners, and low readers. I used to search the Internet to find spreadsheet lessons that I could use with
    Price $29.95Original Price $41.25Save $11.30

Description

Many students create spreadsheets charts and never try to read the charts. In this activity, students create two line charts about smart phone ownership and read the charts to answer 3 questions.

Included in this resource are:

· Written step-by-step student directions with screenshots for visual help

· Step-by-step video to support all students, including beginner ELLs, low readers, and some SPED

· Final examples of the spreadsheet and charts

· Editable rubric and teacher spreadsheet examples with answer key

· How to Use this Resource help for the teacher

Skills students will use in this resource:

  • Use cell ranges (B3:E10)
  • Format Cells (Number)
  • Merge & Center
  • Bold and Center
  • Write formulas
  • Use the Fill Handle
  • Add chart labels, including the legend
  • Decrease the width of multiple columns
  • Outline and move the chart
  • Add gridlines, use Print Preview to make sure data and chart are on one page.
  • Read the charts

Your students should have some experience with Excel before attempting this activity. The step-by-step video can walk students through the assignment, but it will be more challenging if students don’t have much experience with Excel.

There are two Excel Resource 9s in this store and you can use both with a class. Use the more basic Make 2 Line Charts first, followed by Make a Line Chart and Format Time & Minutes in Excel, or use the more complex resource just for your early finishers and/or more advanced students.

This resource is included in the Differentiated Intro to Excel Bundle.

Other Excel resources found in my store (more to come!):

Mystery Images Spreadsheets

Learn to Write Formulas & Use AutoSum Functions

4 Spreadsheets & 2 Charts

Class Birthdays Spreadsheet

Dinner Out Spreadsheet

School Lunches

Differentiated Spreadsheet Vocabulary

Working with Data Types & Cell Formats in Excel

Make a Line Chart and Format Time & Minutes in Excel

Class Test Scores – Data Sorting in Excel

Working with Data Types & Cell Formats in Excel

Holiday Candy Sales Final Excel Assessment

Other popular resources:

Publisher Travel Brochure

Essential Me PowerPoint

Celebrity Invitation Letter

Be sure to Follow Me to receive notifications for new resources!

Don't forget to leave feedback to earn points towards FREE TPT products and help improve my resources.

If you have any questions, please contact me. Thank you!

Total Pages
8 pages
Answer Key
Included with rubric
Teaching Duration
N/A
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT’s content guidelines.

Reviews

Questions & Answers