Create Line Graphs in Excel

Grade Levels
Product Rating
4.0
File Type
Word Document File
Be sure that you have an application to open this file type before downloading and/or purchasing.
2.77 MB   |   10 pages

PRODUCT DESCRIPTION

This instruction guide walks students (and us teachers) through the process of entering data into an Excel spreadsheet and turning it into a line graph. This 10-page guide contains numerous screen shots to help explain each step.

The guide can be used along with laboratory investigations and projects common to physics, chemistry, and biology, as well as courses in mathematics, economics, meteorology, sociology, etc. If your students need to learn how to graph the data they collect, this guide will show them how to do it!

This guide covers the basics as students learn to:
1) Open a new Excel Spreadsheet.
2) Save.
3) Create column headings.
4) Adjust column widths.
5) Enter data.
6) Adjust decimal places.
7) Graph the data.
8) Move and resize the chart.
9) Use chart tools.
10) Enter a chart title.
11) Enter horizontal and vertical axis titles.
12) Create a line of best fit.
13) Tag their work with their names.
14) Save and submit their finished graphs.

This 10-page guide can be printed and used as a handout or saved as a pdf and uploaded to an online course management site such as a moodle site so that students can return to the instructions throughout the year as needed. The guide can be altered to fit the needs of your classes and your students.

The graphs that students produce can either be printed on paper and handed in or submitted by email for easy grading.
Total Pages
10
Answer Key
N/A
Teaching Duration
40 Minutes

Average Ratings

4.0
Overall Quality:
4.0
Accuracy:
4.0
Practicality:
4.0
Thoroughness:
4.0
Creativity:
4.0
Clarity:
4.0
Total:
4 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$2.00
Digital Download
ADD ONE TO CART
User Rating: 3.9/4.0
 (15 Followers)
$2.00
Digital Download
ADD ONE TO CART
Create Line Graphs in Excel
Create Line Graphs in Excel
Create Line Graphs in Excel
Create Line Graphs in Excel
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up