Whoops! Something went wrong.

Click here to refresh the page

Excel Graphing - Demo & Practice Lab Handouts

Excel Graphing - Demo & Practice Lab Handouts
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 pages
Answer Key
Included
Teaching Duration
N/A
Report this Resource
  • Comments & Ratings
  • Product Q & A
Loading...
$1.00
Digital Download
List Price:
$4.00
You Save:
$3.00
Add one to cart

Advertisement

Advertisement

$1.00
Digital Download
List Price:
$4.00
You Save:
$3.00
Add one to cart
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