Excel Graphing - Demo & Practice Lab Handouts

Excel Graphing - Demo & Practice Lab Handouts
Product Rating
4.0
File Type
Compressed Zip File
Be sure that you have an application to open this file type before downloading and/or purchasing.
How to unzip files.
0.07 MB   |   7 pages

PRODUCT DESCRIPTION

OVERVIEW

These handouts are designed to help students learn how to graph using Microsoft Excel. The Demo handout is designed for the instructor to illustrate the graphing procedure to the students. The Practice Lab is designed for students to practice their Excel graphing skills on four graphs of increasing complexity. Excel answer keys for all graphs are included.

The data sets that are utilized are position versus time and velocity versus time. The following graphing steps are illustrated:

Graph data
Add trend line
Find and show equation
Set the y-intercept
Make variable and unit substitutions in the equation
Find average velocities
Find the R value for the line
Forecast the trend line forward and backwards
Make the graph background white
Make labels for the x and y axis
Add a title
Add major and minor grid lines
Add a legend for graphs with more than one data set

The following handouts are included in Excel or Word format:

ExcelGraphingDemo.doc
ExcelGraphingDemo_AnswerKey.xls
ExcelLab.doc
ExcelLab_AnswerKey_Graph3.xls
ExcelLab_AnswerKey_Graph4.xls
ExcelLab_AnswerKey_Graphs1&2.xls
ExcelGraphingNotes.doc

INSTALLATION

All files are included in a zipped file: ExcelGraphing.zip.

TERMS OF USE

Copyright 2015 Multimedia Science. All rights reserved.
Purchaser may duplicate materials for use with all students in their classes only. Purchaser may modify materials but must retain the original copyright notices. None of these materials, even if modified, can be used for commercial purposes or placed on public networks or on the Internet.

MULTIMEDIA SCIENCE LINKS

Blogs
Science Technology
Educational Technology
Teachers Tools
Pinterest
Educational Science
Educational Physics
Educational Chemistry
Educational Technology
Using Games In Education
Web Site

KEYWORDS

excel, motion, physics, mechanics, graphing, experiment, lab
Total Pages
7
Answer Key
Included
Teaching Duration
N/A

Average Ratings

4.0
Overall Quality:
4.0
Accuracy:
4.0
Practicality:
4.0
Thoroughness:
4.0
Creativity:
4.0
Clarity:
4.0
Total:
2 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$1.00
Digital Download
List Price: $4.00
You Save: $3.00
ADD ONE TO CART
User Rating: 4.0/4.0
 (27 Followers)
$1.00
Digital Download
List Price: $4.00
You Save: $3.00
ADD ONE TO CART
Excel Graphing - Demo & Practice Lab Handouts
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