Tech Integration Class: Spreadsheet Magic
Additional Help Learning How to Use Spreadsheets:
Now that you have attended an introduction to spreadsheets workshop, a good next step is to use AtomicLearning Home Page to review or learn concepts you will need to complete a project with students. At AtomicLearning click From any SPPS location you will not need a username and password to use AtomicLearning. From outside the SPPS network you will and you should contact your coach for this information.
AppleWorks: http://www.atomiclearning.com/appleworks_6_spreadsheet
Excel: http://www.atomiclearning.com/excel_2003_intro
Workshop Files Download:
This file download is the collection that
were used at the Spreadsheet Magic workshop. If your computer does not
have a unzip utility (just give a try and see what happens), please
contact joel.swanson@spps.org and he will mail you a CD.
Spreadsheet_Files_Converted.zip
Click to download (Mac). Right click and select download (PC)
Spreadsheet-Related Web Resources
Elementary Activities
Math:
Science:
Social Studies:
- Group
Graphing The instant creation of graphs and charts from and
lets us get right to the exercise of selecting, interpreting and
querying data. spreadsheets in various styles reduces the tedium of
drawing and coloring
- Using
Spreadsheets in Thinking Science -Spinning Coins Activity:
Each group of pupils spins a coin 50 times and they record their
results in a table. This is the raw data that they will use for further
analysis.
- Spreadsheets:
A Variety of Activities
- Lemonade
Business - Use the information generated playing the Lemonade
Stand to create an income statement using Excel to use in the Power
Point presentation.
- Santa's
Elf Spreadsheet
- To learn how to estimate prices of items
- To use catalogs and/or advertisements to research
costs of items
- To use problem solving strategies
and a spreadsheet template to
determine what can be bought within a budget
- Understanding
Weather
- To use instruments to record and predict the weather
- To graph and compare weekly, monthly, and seasonal
weather observations
- How
Much Would I Weigh on Mars? After you find the relative
surface gravity data, type it into a table in a spreadsheet. Don't
forget to label your data. Design the spreadsheet so that you can enter
your weight or that of a friend into one cell and let the spreadsheet
compute how much you or your friend would weigh on the other planets.
- Cloudy
with a Chance of........
This lesson helps students
understand the various types of weather and learn safety tips for each
type of severe weather. The students will identify factors associated
with each weather type, make weather instruments, collect weather data
and predict the weather. - Temperature
Students build water thermometers out of straws and film canisters and
use spreadsheet to analyze data.
- Measuring
Wind Speed Using a ping pong and protractor, students measure
wind speed over the course of a week and graph the results.
- Elem
Lessons K-8 Lesson Plans on the Web
- Distances
in Space Using reference materials available in the classroom
or library, look up the diameters of the sun and the planets. Look up
the distances from the sun to each planet. Record this data in a
spreadsheet and compute the sizes and distances you would need to use
to make a scale model of the solar system.
- Allowance
Use the spreadsheet to create a graph of the data. What graph will best
display the data so she can see what fraction or percent of her
allowance she has spent in each category? What percent of her allowance
did she spend on each category?
Secondary Activities
Math:
Science:
Social Studies:
Zoho Online Spreadsheet (example)
Spreadsheet_Files_Converted.zip
|
