Description

No Prep! These lessons are great as a first Excel Chart lesson or for students already a little familiar with creating charts. Students love the data for these charts because the data is centered around things they love – their cell phones! In Lesson 1, students will create 5 different charts from step-by-step directions which include Chart Titles, Chart Styles, Axis Titles, Data Labels, and Moving Chart to its own Sheet.

In Lesson 2, students will create 5 charts from provided data as well as charts in which they supply a portion of their own real-life data. Students will also learn how the charts are embedded and make changes to the data.

Also included in these lessons is a handout - Excel Chart Directions – just laminate and you have a yearlong handy cheat sheet for students when they create charts. Answer keys for both lessons included.

Charts Created:

Column Chart
Pie Chart
Scatter Chart
Bar Chart
Line Chart

Included in Download:

Charts – Lesson 1
Charts – Lesson 1 Answer Key
Charts Lesson 2
Charts – Lesson 2 Answer Key
Excel Chart Directions Handout

Your students might love this activity also:

Bake Sale Activity

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.

Excel Lessons - Creating Charts

Name: Excel Lessons - Creating Charts
Brand: Proven Computer Lessons
SKU: 3771160
Price: 3.00 USD
Availability: InStock
Rating: 4.38 (8 reviews)

Proven Computer Lessons

2k Followers

$3.00

Highlights

Digital downloads

Microsoft Excel

Grades

5th - 12th

Subjects

Computer Science - Technology, Graphing, Instructional Technology

Description

Charts Created:

Column Chart
Pie Chart
Scatter Chart
Bar Chart
Line Chart

Included in Download:

Charts – Lesson 1
Charts – Lesson 1 Answer Key
Charts Lesson 2
Charts – Lesson 2 Answer Key
Excel Chart Directions Handout

Your students might love this activity also:

Bake Sale Activity

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.

4.4

Rated 4.38 out of 5, based on 8 reviews

8
ratings

Grades used with

Reviews

6th

7th

8th

9th

10th

11th

12th

All verified TPT purchases

Rated 2 out of 5

March 13, 2024

Not a very good product, students didn't love it and didn't think the material was very long.

Brandon E.

9 reviews

Grades taught: 10th, 11th, 12th

Response from

Proven Computer Lessons

(TPT Seller)

Mar 13, 2024

Brandon, So sorry to hear your students did not enjoy creating 5 types of charts using data most students love. Based on other teacher reviews, most students enjoyed it. This resource was designed to teach students how to create 5 different chart types in a fun way and sorry your students did not find it interesting.

Rated 5 out of 5

November 28, 2023

This is a detailed step-by-step Excel chart activity that I have used in class when introducing charts. It has also been a great resource to leave for a sub when I'm gone because students can easily work through it without any help. Great resource!

Tia D.

80 reviews

Grades taught: 9th, 10th, 11th, 12th

Rated 5 out of 5

July 31, 2023

This assignment was a lifesaver! I knew I wanted students to learn about excel but just didn't have time to create extensive assignments like this. Gave students a basic overview of all the different chart and graph tools that excel has. Topic of social media was interesting and a few students shared their surprise with some of the facts they were learning about as they completed the assignment. Overall, I would recommend!

Business Class with Mrs Sage

(TPT Seller)

8 reviews

Grades taught: 9th, 10th, 11th, 12th

Response from

Proven Computer Lessons

(TPT Seller)

Jul 31, 2023

Thank you so much! I am so happy to hear your students enjoyed the Excel chart activities!

Rated 5 out of 5

October 24, 2022

Great resource, thank you

Tina Howie

(TPT Seller)

340 reviews

Grades taught: 6th

Response from

Proven Computer Lessons

(TPT Seller)

Oct 25, 2022

Thank you Tina!

Rated 3 out of 5

April 17, 2022

Good resource

ChemWise - Secondary Chemistry

(TPT Seller)

446 reviews

Grades taught: 10th

Rated 5 out of 5

September 22, 2021

I used this resource to supplement my students data analysis project. This resource helped familiarize them with how to create visual representations of data that they will create with their own data for their project. I really loved this resource!!

Kristin Niksarian

(TPT Seller)

589 reviews

Grades taught: 12th

Student populations: Autism, Emerging bilinguals, Learning difficulties, Mild to severe disabilities

Response from

Proven Computer Lessons

(TPT Seller)

Sep 23, 2021

Thank you so much Kristin! I appreciate hearing how much this resource helped your students.

Rated 5 out of 5

June 5, 2019

The projects will keep my students engaged.

Amy H.

63 reviews

Response from

Proven Computer Lessons

(TPT Seller)

Jun 5, 2019

Thanks! I hope your students enjoy!

Rated 5 out of 5

October 30, 2018

Clear step-by-step instructions and great screenshots. Professional quality handouts. Thank you!

Amy N.

728 reviews

Response from

Proven Computer Lessons

(TPT Seller)

Oct 30, 2018

Amy, Thank you so much! I am so happy you were happy with the lessons :)