1 - INTRODUCTION



[pic]

|(1) Introduction to Databases: A database is a collection of information organized so that a computer program can quickly retrieve |

|desired pieces of data. A field is a single piece of information; a record is one complete set of fields; and a table is a |

|collection of records. |

| |

|Sample Problem It is believed that sodium, cholesterol, and saturated fat increase the risk of cardiovascular disease. Use the |

|filter tool in Excel to determine which foods should be avoided because they contain high concentrations of all of these |

|substances. Include a printout of your report in your portfolio. Download and open nutrition.xls (an Excel file) . Use File/Open to|

|open the nutrition.xls file if it does not open by double-clicking. Turn on AutoFilter (Data/Filter/AutoFilter). When it is on, |

|small arrows appear in the field(column) headings. To sort the database, place the cursor in the first cell within a category (e.g.|

|vit. C (mg), not in the category coordinate (e.g. A,B,C etc.). To perform record selection, use Data/Sort/SortBy and select the |

|appropriate criteria to answer the question. |

|Food |Cholesterol [mg] |Saturate Fat [g] |Sodium [mg] |Food type |

|Beef - Liver |410 |2.5 |90 |MEAT |

|Butter - Stick |247 |57.3 |933 |FATS AND OILS |

|Chicken - Roasted whole |125 |2.9 |120 |POULTRY |

|Chicken breast fried w/batter |119 |4.9 |385 |POULTRY |

|Cream sour cultured |102 |30 |123 |DAIRY |

|Custard baked |278 |6.8 |209 |DAIRY |

|Duck meat only roasted |198 |9.2 |143 |POULTRY |

|Egg Nog commercial |149 |11.3 |138 |DAIRY |

|Oysters - raw Pacific |120 |1.8 |185 |FISH/SHELLFISH |

|Oysters Eastern raw |120 |1.4 |175 |FISH AND SHELLFISH |

|Raw whole without shell |274 |1.7 |69 |EGGS |

|Raw Yolk |272 |1.7 |8 |EGGS |

|Scrambled with milk and butter |282 |3 |176 |EGGS |

|Veal cutlet braised or broiled |109 |4.1 |56 |MEAT |

|  | | | | |

|(2) Managing School Data: Schools and colleges are dependent upon databases to maintain student records, finances, registration, |

|teacher information, schedules, and many other things. Teachers input data into such systems through grade book programs and other |

|teacher/administrator software. Teachers should also be able to use programs like Microsoft Excel to organize data and merge files.|

| |

| |

|Download the schools database file. Create mailing labels and form letters (3 suffices) using the mail merge feature in Word. This |

|will serve as a data file (also known as secondary file) when merging with a primary document to make form letters, mailing |

|letters, or catalog entries. Include only representative samples from your merges. |

Principal

««School»»

««Street»»

««City»», ««State»» ««Zip Code»»

Dear Principal of««School»»:

Next week the students of Van Nuys High School will be at ««School»» to give you their latest school directory and leave you a CD of their latest school events for your library.

Gloria Aispuro

Principal

Adams (John) Middle

151 W. 30Th St.

Los Angeles, CA 90007-3316

Dear Principal of Adams (John) Middle:

Next week the students of Van Nuys High School will be at Adams (John) Middle to give you their latest school directory and leave you a CD of their latest school events for your library.

Gloria Aispuro

| | | | | |

|Adams (John) Middle | |Adams (John) Middle | |Adams Middle |

|151 W. 30Th St. | |2425 16Th St. | |2600 Ripley Ave. |

|Los Angeles, CA 90007-3316151 W. 30Th St. | |Santa Monica, CA 90405-26212425 16Th St. | |Redondo Beach, CA 90278-2600 Ripley Ave. |

|90007-3316 | |90405-2621 | |90278- |

|"\u | |"\u | |"\u |

| | | | | |

| | | | | |

|Adams Middle | |AGBU Marie Manogian; Demirdijian HS | |Aggeler (William Tell) Opportunity High |

|2600 Ripley Ave. | |6844 Oakdale Ave | |21050 Plummer St |

|Redondo Beach, CA 90278-45552600 Ripley Ave. | |Canoga Park, CA 91306-39136844 Oakdale Ave | |Chatsworth, CA 91311-490321050 Plummer St |

|90278-4555 | |91306-3913 | |91311-4903 |

|"\u | |"\u | |"\u |

| | | | | |

| | | | | |

|Agoura High | |Airport Junior High | |Alemany HS |

|28545 W. Dr.r Ave. | |9000 Airport Blvd. | |15241 Rinaldi |

|Agoura, CA 91301-333528545 W. Dr.r Ave. | |Los Angeles, CA 90045-9000 Airport Blvd. | |Mission Hills, CA 9134515241 Rinaldi |

|91301-3335 | |90045- | |91345 |

|"\u | |"\u | |"\u |

| | | | | |

| | | | | |

|Alhambra Adult High | |Alhambra High | |Almondale Middle |

|15 W Alhambra Rd | |101 S. Second St. | |9330 E. Avenue U |

|Alhambra, CA 91801-243515 W Alhambra Rd | |Alhambra, CA 91801-3716101 S. Second St. | |Littlerock, CA 93543-31079330 E. Avenue U |

|91801-2435 | |91801-3716 | |93543-3107 |

|"\u | |"\u | |"\u |

| | | | | |

| | | | | |

|Alternative Junior High | |Amargosa Creek Middle | |Anacapa Middle |

|2802 Fourth St. | |44333 27th Street West | |100 S. Mills Road |

|Santa Monica, CA 90405-2802 Fourth St. | |Lancaster, CA 93536-44333 27th Street West | |Ventura, CA 93003-3434100 S. Mills Road |

|90405- | |93536- | |93003-3434 |

|"\u | |"\u | |"\u |

| | | | | |

| | | | | |

|Animo Inglewood Charter High | |Animo Leadership High | |Antelope Valley High |

|304 East Spruce Street | |1155 Arbor Vitae St. | |44900 N Division St |

|Venice, CA 90291-304 East Spruce Street | |Inglewood, CA 90301-1155 Arbor Vitae St. | |Lancaster, CA 93534-44900 N Division St |

|90291- | |90301- | |93534- |

|"\u | |"\u | |"\u |

| | | | | |

| | | | | |

|Arcadia High | |Archer School for Girls HS | |Arroyo High |

|180 Campus Dr. | |11725 W. Sunset Blvd | |4921 N. Cedar Ave. |

|Arcadia, CA 91007-6958180 Campus Dr. | |Los Angeles, CA 90049-291811725 W. Sunset Blvd | |El Monte, CA 91732-10994921 N. Cedar Ave. |

|91007-6958 | |90049-2918 | |91732-1099 |

|"\u | |"\u | |"\u |

| | | | | |

| | | | | |

|Arroyo Seco Junior High | |Artesia High | |Audubon Middle |

|27171 Vista Delgado Dr. | |12108 E. del Amo Blvd. | |4120 11Th Ave. |

|Valencia, CA 91354-224427171 Vista Delgado Dr. | |Lakewood, CA 90715-151612108 E. del Amo Blvd. | |Los Angeles, CA 90008-37124120 11Th Ave. |

|91354-2244 | |90715-1516 | |90008-3712 |

|"\u | |"\u | |"\u |

| | | | | |

| | | | | |

|Aviation High | |Azusa High | |Balboa Middle |

|2025 Manhattan Beach Blvd. | |240 N. Cerritos Ave. | |247 Hill Road |

|Redondo Beach, CA 90278-2025 Manhattan Beach Blvd. | |Azusa, CA 91702-3733240 N. Cerritos Ave. | |Ventura, CA 93003-4401247 Hill Road |

|90278- | |91702-3733 | |93003-4401 |

|"\u | |"\u | |"\u |

| | | | | |

| | | | | |

|Baldwin Park High | |Bancroft (Hubert Howe) Middle | |Bancroft Junior High Magnet |

|3900 N. Puente Ave. | |6750 Romaine St. | |6750 Romaine St. |

|Baldwin Park, CA 91706-44283900 N. Puente Ave. | |Los Angeles, CA 90038-24216750 Romaine St. | |Los Angeles, CA 90038-6750 Romaine St. |

|91706-4428 | |90038-2421 | |90038- |

|"\u | |"\u | |"\u |

| | | | | |

|(3) Creating / Enhancing databases for your subject: Teachers use programs like Excel to manage and organize large sets of data. |

| |

|Create a new spreadsheet or a new worksheet in an existing database file. 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. The material should be related to the subject you |

|teach. Include a printout of your new database in your portfolio, and post the Excel file (.xls) in your electronic portfolio (if |

|required by professor). |

[pic]

|(4) Using web-based databases: A growing number of educational databases are available on the Internet. Teachers can use these |

|databases without having to teach the mechanics of a program like Excel. |

| |

|Use Nutritional Analysis Tool to develop a file that reflects your "normal" daily diet. Analyze your diet with respect to the |

|United States Department of Agriculture's recommended daily allowances. Write a brief analysis of your diet, including histograms |

|or tables. Write an assignment for a secondary school class (math, home economics, health etc.) which requires use of the database |

|features of the Nutritional Analysis Tool, or Fast Food Facts. You may also wish to refer to the USDA Nutrient Data Laboratory |

| |

| |

|Write a lesson plan which requires students to analyze data using a database related to your subject: Social Studies: nations , |

|exchange rates , distance, census |

| |

|Business: stocks & business |

|Science: genetics, proteins, plants, earthquakes, air pollution, hurricanes, chemicals |

|Health: health, nutrition |

|Music: classical, iTunes |

|Foreign language: foreign words, foreign dictionaries |

|Mathematics: stocks |

|Physical Education: sports |

|Art: art |

|English: public domain texts |

[pic]

[pic]

Lesson Plan for Special Ed Students:

Topic: How much sugar is in the foods you eat?

Class: Life Skills- Nutrition

Grade Level: 9th

Major Concepts: to introduce students to resource information and use of databases related to foods. Students are to navigate through the database and find information.

Materials and Equipment: Computer, printer, writing tools

Independent practice: Students are to use the student computers in the learning lab. Students are to navigate through nutrition related websites as follows.

National Analysis Tool

USDA Nutrient Data Laboratory

Students are to browse through the database and prepare a personal analysis of their favorite foods. Students will summarize their findings and share their reflections with the class.

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

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

Google Online Preview   Download