12-Databases

(1) Researching with databases

• • • Video - Nutrition - Reducing the threat of osteoporosis  [9:28]

    • Assignment - Many physicians recommend their patients substitute polyunsaturated for saturated fats (increase unsaturated:saturated ratio), reduce sodium intake, and minimize cholesterol. Use the  nutrition database to determine foods that should be minimized or eliminated to reduce the risk of cardiovascular disease.  Summarize your findings and include a screen shot to support your claim. 

(2) Create a database

• • • Video - Database basics [13:42]

    • Assignment - Create a database of information relevant to your teaching.  Your database should contain a minimum of 10 records (rows)  and 5 fields (columns) and illustrate the features discussed in the video.  

(3) Mapping Data

• • • Video -MyMaps - Mapping data [earthquakes & volcanoes] [6:56]

    • Video -Importing MyMaps data to Google Earth [earthquakes & volcanoes] [8:37]

    • Video -My Maps - Mapping data [schools] [8:46]

    • Video -Importing KML files to -Google Earth [6:34]

    • Assignment - Create a multi-layered MyMaps map of geographic data using data such as the schools data  or volcanoes & earthquakes data shown in the video, OR a Google Earth map using kml/kmz files.  Provide photo and text annotations on your map.

(4) Teaching with Databases

• • • Video - Gapminder - [11:07]   investigate trends in world data

    • Video - Wolfram Alpha - [4:08]  Compare and contrast data using  a computational knowledge engine

    • Video - pTable [8:48] Dynamic periodic table database

    • Assignment -

      • Select one or more online databases  of your choice, or database apps such as  GapMinder (world statistics, country comparisons ), Wolframalpha (computational knowledge engine), or pTable (periodic table of the elements). 

      • Write ten (10) engaging questions which require students to analyze data and create models or explanations.   

      • Provide sample answers to your questions.