EDUC 275 February 16, 2006

1
EDUC 275 February 16, 2006

• Getting Started Try the Standards Game at
  http//coe.winthrop.edu/johnsonle/Johnson/activiti
  esS05/reaching_standard.ppt
• (There is a link on my website under Class
  Presentations Reaching the Standard.)
• AGENDA
• Discuss software tools for teaching and
  learning.
• Participate in Excel activity.

2
Integration of Technology in Teaching and Learning

• Word Processing, Spreadsheet, and Database
  Software Tools

3
Word Processing

• Think-Pair-Share
• Use the chart on pg. 124 to answer the following
  questions.
• What are the advantages of word processing?
• What might be some of the disadvantages or issues
  related to its use?
• What are some possible implications of the
  research findings?

4
Spreadsheets

• Definition To organize and manipulate numerical
  data.
• Also referred to as worksheets.
• Information is stored in rows and columns.
• Relative Advantage organize, compare,
  calculate, copy, graph, predict, problem solve,
  time saver, etc.
• Issues ???

5
The Basics
6
MM Spreadsheet Activity
7
Related Standards (Use for Assessment)

• Choral Music Grade 9
• Evaluate a given musical work in terms of its
  aesthetic qualities and explain the musical means
  it uses to evoke feelings and emotions.
• SC Grade 9 Math
• Standard I. Formulate questions that can be
  addressed with data and collect, organize, and
  display relevant data to answer them.
• Expectation A. Understand the differences among
  various kinds of studies and which types of
  inferences can legitimately be drawn from each.
• Distinguish among surveys, observational studies,
  and controlled experiments and evaluate the
  quality of each
• NET-S
• Technology Resource Tools
• Students use technology tools to process data and
  report results.

8
Using Spreadsheets

• Look at your bag. Make predictions based on the
  data collection sheet (before computer activity).
• Open the Bag, sort and count the MMs (before
  computer activity).
• Open Microsoft Excel and create a spreadsheet to
  graph the data (during computer activity). Be
  sure your name is one your graph somewhere. Use
  these instructions to guide your work
  http//coe.winthrop.edu/educ275/handouts/excel_act
  ivity.htm
• Print your chart and graph and place it in your
  folder.

9
Using Spreadsheets
After Computer

• Find a SC Standard in your content area for which
  students could create a graph. Include the math
  standard and NET-S as well.
• Write an activity (short paragraph) that students
  would do related to organizing and graphing.
• Create an example of the graph.
• Include the activity description, your name, and
  the standards somewhere on the graph or
  worksheet.
• Save the graph in the tshare. Print your
  activity and place it in your folder.