Using Scroll Bars to Create Interactive Spreadsheets

1 / 7

Using Scroll Bars to Create Interactive Spreadsheets - PowerPoint PPT Presentation

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

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

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

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

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
• Worksheet to go with kinematics graphs spreadsheet
How to use scroll bars
• Click on View menu,Toolbars ,Forms
• Formatting the Scroll Bar
• zero minimum
• integer incremental change
• page change
• Creating a simple position vs. time graph
• 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
• Kinematics Graphs
• d vs. t (constant velocity)
• v vs. t (constant acceleration)
• d vs. t (constant acceleration)
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
• http://www.niles-hs.k12.il.us/west/science/marlie/ExcelActivities.zip
• Kinematics Graphs Worksheet(.doc and .pdf)