Assignments‎ > ‎

11- Database

(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.


These foods were found on a database using the filter tool. These foods are all high in saturated fats, sodium and cholesterol, three food ingredients that should be avoided by those who suffer from atherosclerosis.

(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.

Merging-Three Letters- Screen Capture View

Merging- Three Letters- 75% Format View

Merging- School Mailing Labels 

(3) Creating / Enhancing databases for your subject

Watch video Constructing a database from scratch (21 minutes) - make sure to watch full screen!

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).

Excel Worksheet- Gradebook Layout with Filters

(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.

Nutrition Test Results

My diet is very low in sugars (refined and natural). I believe that I am low in some areas, but I do take some calcium supplements for the lack of dairy in my diet. I do not follow the diet religiously, but the Paleo way of life is a very interesting concept that could be carried out by many people who have corrective diseases, ej. diabetes, obesity, etc.

See Attached Items Below For "Lesson Plan"

Sara Gallardo-Candia,
Dec 4, 2012, 10:11 PM
Sara Gallardo-Candia,
Dec 5, 2012, 7:50 AM
Sara Gallardo-Candia,
Dec 4, 2012, 10:12 PM
Sara Gallardo-Candia,
Dec 4, 2012, 6:51 PM
Sara Gallardo-Candia,
Dec 4, 2012, 7:02 PM