using scroll bars to create interactive spreadsheets
Download
Skip this Video
Download Presentation
Using Scroll Bars to Create Interactive Spreadsheets

Loading in 2 Seconds...

play fullscreen
1 / 7

Using Scroll Bars to Create Interactive Spreadsheets - PowerPoint PPT Presentation


  • 89 Views
  • Uploaded on

Using Scroll Bars to Create Interactive Spreadsheets. Martha Lietz AAPT National Meeting Boise, ID August 6, 2002. [email protected] Overview. How to create scroll bars in Excel Examples of scroll bars RL circuits standing waves kinematics

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Using Scroll Bars to Create Interactive Spreadsheets' - fleta


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
using scroll bars to create interactive spreadsheets

Using Scroll Bars to Create Interactive Spreadsheets

Martha Lietz

AAPT National Meeting

Boise, ID

August 6, 2002

[email protected]

overview
Overview
  • How to create scroll bars in Excel
  • Examples of scroll bars
    • RL circuits
    • standing waves
    • kinematics
  • Worksheet to go with kinematics graphs spreadsheet
how to use scroll bars
How to use scroll bars
  • Click on View menu,Toolbars ,Forms
  • Formatting the Scroll Bar
    • cell link
    • zero minimum
    • integer incremental change
    • page change
  • Creating a simple position vs. time graph
specific scrollbar spreadsheets
Specific Scrollbar Spreadsheets
  • Standing Waves
    • two identical waves passing each other and their sum
  • RL Circuits
    • resistor and inductor in a series circuit
    • total current
    • total voltage, voltage across inductor and voltage across resistor
specific scrollbar spreadsheets1
Specific Scrollbar Spreadsheets
  • Kinematics Graphs
    • d vs. t (constant velocity)
    • v vs. t (constant acceleration)
    • d vs. t (constant acceleration)
worksheet activity
Worksheet Activity
  • Used in Regular Physics, but accessible to higher levels as well
  • Explores relationships between graphs and kinematics equations
  • Took 35-40 minutes with each student on a computer.
  • Initial velocity on d vs. t (a  0) is the most difficult
how to get activities
How to get Activities
  • http://www.niles-hs.k12.il.us/west/science/marlie/ExcelActivities.zip
    • Kinematics Graphs Worksheet(.doc and .pdf)
    • Kinematics Graphs Spreadsheet
    • Standing Wave Sum Spreadsheet
ad