514-9 Databases



Assignments 9&10

Databases and spreadsheets

(1) Grading Programs, Progress Reports: Use (A) a gradebook program AND (B) a spreadsheet program to develop a gradebook for a hypothetical class of ten or more students who are assessed on five or more assignments. Take screen shots of each gradebook. Use the gradebook program to produce a report and print it for your portfolio.

(2) General database programs: Use a database program to analyze:

(A) Nutrition. database: (filter) It is believed that sodium, cholesterol, and saturated fat increase the risk of cardiovascular disease. Use sort or the filter tool to determine which foods should be avoided because they contain high concentrations of all of these substances.

(B) Creating databases in your field: Create a new worksheet in an existing database file (see examples). For example, if you are a social studies teacher, you may wish to add a worksheet to one of the databases designed for social studies teachers. Your worksheet should include a minimum of 10 records and 5 fields and should include an autofilter for easy record selection. Include a printout of your new database in your portfolio.

(C) Create a graph (chart) from a spreadsheet file related to your discipline. Make sure the graph is meaningful and is fully and correctly labeled. Include a screen-shot of the graph in your portfolio and explain its significance.

(3) Dedicated database programs: Geographic Database: Assume that you are on the board of directors of a large humanitarian relief organization such as UNICEF or World Vision. Use dedicated database programs to address the following problems in the table below.

(1) Use the MacGlobe or PCGlobe database program to determine three countries you believe are most deserving of humanitarian aid. Give an explanation of your decision, and defend the criteria you selected.

(2) Include histograms that illustrate disparities between these countries and the United States.

(3) Assume that you received a donation of $1,000,000. Determine how much money this would represent in the national currencies of all three countries.

(4) Determine the distance to, and time differential between, your city and the capital city of each of these three countries.

|(A) Geographic Database |Country 1 |Country 2 |Country 3 |

| | | | |

|(1) Explanation for choosing | | | |

|this country | | | |

| | | | |

|(2) Historgram comparing country| | | |

|to USA | | | |

|(3) Equivelent of $1M in | | | |

|national currency | | | |

|(4) Distance from Los Angeles to| | | |

|capital city | | | |

(5) Include a world map that highlights the United States and each of the three countries you selected.

(6) Describe a lesson for a secondary school class (math, social studies, etc.) which requires use of the data base features of MacGlobe.

(3) Electronic Spreadsheets in Teaching: Describe three uses for electronic spreadsheets in secondary school teaching.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download