# Using Scroll Bars to Create Interactive Spreadsheets - PowerPoint PPT Presentation

1 / 7

Using Scroll Bars to Create Interactive Spreadsheets. Martha Lietz AAPT National Meeting Boise, ID August 6, 2002. marlie@niles-hs.k12.il.us. 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.

Using Scroll Bars to Create Interactive Spreadsheets

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

## Using Scroll Bars to Create Interactive Spreadsheets

Martha Lietz

AAPT National Meeting

Boise, ID

August 6, 2002

marlie@niles-hs.k12.il.us

### 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

### 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 Spreadsheets

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

• Kinematics Graphs Spreadsheet

• Standing Wave Sum Spreadsheet