| Student Use | Teacher Use |
In
a classroom students can use spreadsheets to make calculations, record and
analyze data, observe changes in data, and compare statistics.
When students first begin using spreadsheets, teachers may want to
create templates so that students just have to fill in the data.
Once they become familiar with how spreadsheets work, students can
learn to make their own spreadsheets.
Each of the following suggestions is taken out of a larger context; none is meant to be a stand-alone or singular activity, but rather a natural extension of a larger project or thematic unit.
As
part of a unit on responsible pet ownership, students calculate the expense
of keeping a pet.
In
social studies, students can calculate the similar/different characteristics
of cities in Ohio, the United States, or the World such as average
temperature, population, precipitation
Have
students compare the costs of several food items from different stores
record
election results – local or national
record
sports statistics, physical fitness statistics
Have
students compare the nutritional value of various foods – have them bring
in labels from products as a source of information
Sort
and classify items, then share the results using a spreadsheet and charts
enter
data from a book fair
track
school store sales
record
data from a science experiment
record
fund-raiser information
Convert
Fahrenheit temperatures to Celsius
Create
their own math tables – multiplication tables, subtraction aid (they might
share this while working with younger students)
Create
a “magic square”
Keep
a personal grade book so they can calculate their grades for a grading
period
| Lesson Plans | Bingo form |
| Schedules | Wordwall |
| Class lists | Flashcards |
| Check lists | Graphs |
| Grade book | Seating charts |
Tables
of Information for study sheets
Setting
up rubrics and goal forms
Design
“what-if” situations for student use
Create
word boards, game boards, or cards that students can use for any drill and skill
work. This
can be used for phonics games, math games - whatever skill you are teaching.
Prepare
a nutrition sheet for students to examine and
compare food labels
Prepare a budget sheet for students to plan a picnic using different grocery ads for cost comparison
| Student Use | Teacher Use |
Return to Teacher Help Pages or Student Resource Pages
Last updated June 23, 2011
~
Mrs. K. Bradley
kbradley@otsegoknights.org