EDUC 275 February 22, 2005

1
EDUC 275 February 22, 2005

• AGENDA
• Discuss software tools for teaching and learning.
• Participate in Excel activity.
• Ms. Harris will be back Thursday to discuss Ch.
  2, your tests and DV Activity Write-ups.

2
Integration of Technology in Teaching and Learning

• Word Processing, Spreadsheet, and Database
  Software Tools

3
Word Processing

• What are the advantages of word processing?
• What might be some of the disadvantages or issues
  related to use?
• Discuss the chart on page 91. What are some
  possible implications of the research findings?

4
Spreadsheets

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

5
The Basics
6
MM Spreadsheet Activity
7
Using Spreadsheets

• Part One
• Look at your bag. Make predictions based on the
  data collection sheet (Pre-computer activity, pg.
  229).
• Open the Bag, sort and count the MMs
  (pre-computer activity).
• Open Microsoft Excel and create a spreadsheet to
  graph the data (pg. 225-228).
• Have graph approved by instructor, print and
  hand-in. Move to Part Two.

8
Excel Activity

• Part Two
• Find a SC standard that you could create a graph
  for
• Write an activity that students would do related
  to graphing.
• Create an example of the graph.
• Put this information in a PowerPoint presentation
  that includes at least four slides a title
  slide, standards slide, activity slide and graph
  slide (you can copy and paste your graph into
  PowerPoint).
• Save it to the t-share in the Harris folder as
  your_last_name excel.
• If you dont finish, complete this activity for
  homework. We will NOT work on this in class on
  Thursday.

9
A type of learning

• How many of you made the spreadsheet and graphed
  the data?
• How many of you are experts at Excel?
• Why were you able to do this?
• Tutorials are a form of directed instruction that
  help in constructivist learning
• See Useful Links and Handouts for more
  information on Excel in the classroom.