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

• How to create scroll bars in Excel

• Examples of scroll bars

• RL circuits

• standing waves

• kinematics

• Worksheet to go with kinematics graphs spreadsheet

• 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)

• 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

• http://www.niles-hs.k12.il.us/west/science/marlie/ExcelActivities.zip

• Kinematics Graphs Worksheet(.doc and .pdf)