EDUC 275 February 21, 2006

1
EDUC 275 February 21, 2006

• Getting Started Make sure your spreadsheet is
  in your folder. In your nametag, respond to the
  following question How are databases different
  from spreadsheets?
• AGENDA
• Questions and concerns.
• Participate in database activity.

2
Database Software

• Think-Pair-Share
• What is the purpose in using a database?
• How are databases different from spreadsheets?
• Thinking about education, in what subject areas
  might there be a need to organize a great deal of
  information?

3
Database Software

• Definition Store, organize, and manipulate text
  and numerical data (usually large amounts).
• Metaphors file cabinet, Rolodex, others?
• Information is organized by fields and records.
• Common Uses develop higher order thinking
  skills (compare/contrast), store and retrieve
  information sets, save time and energy
• Issues Privacy (password protected), lack of
  teacher knowledge, data overload

4
Database Software (pg. 143)
File
Field
Record
5
Cereal Database Activity
6
Related Standards (Use for Assessment)

• SC Grade 10 Standard USHC-7 The student will
  demonstrate an understanding of the economic
  boom-and-bust in America in the 1920s and 1930s,
  its resultant political instability, and the
  subsequent worldwide response.
• USHC-7.4 Explain the causes and effects of the
  stock market crash of 1929 and the Great
  Depression, including the disparity in incomes,
  limited government regulation, stock market
  speculation, and the collapse of the farm
  economy wealth distribution, investment, and
  taxes government policies and the Federal
  Reserve System and the effects of the Depression
  on human beings and the environment. (H, E, G, P)
  
• NET-S
• Technology problem-solving and decision-making
  tools
• Students use technology resources for solving
  problems and making informed decisions.

7
Using Databases

• Download the answer sheet.(http//coe.winthrop.ed
  u/educ275/handouts/database_activity_sheet.htm ).
  
• Open a blank database on Microsoft Access. Save
  the database as your last name in our folder on
  tshare.
• Create your table in design view entering and
  describing at least seven fields (use or change
  the choices on your answer sheet).
• Save your table (when you exit the table it will
  automatically ask if you want to save as Table
  1 this if fine.)
• Enter data from as many cereals as possible until
  I call time.http//www.elook.org/nutrition/cereal
  s/http//www.kellogg.com.au/NutritionInfo/ListNut
  ritionInfo.asp?pagecopyid15875sectionid1
• Using your sort features, answer the questions on
  your sheet.
• Print your database sorted for at least one
  field.
• If you finish early, try and filter your data.
• For extra assistance http//coe.winthrop.edu/edu
  c275/handouts/database_activity.htm

8
Using Databases
SORT Order fields in ascending or descending
order.1. Select field for sorting.2. Go to
Records menu.3. Choose Sort then ascending
or descending. FILTER Separate entries based
upon specified criteria.1. Select focus
entry.2. Go to Records menu.3. Choose
Filter then filter by selection.
9
A type of learning

• How can databases promote higher order thinking?
  (Use the cereal database as a talking point.)
• When planning for instruction, how can the use of
  databases support both direct and constructivist
  learning theories?