Assignments‎ > ‎

(12) Databases

Wiki Notes

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


(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 databases to organize data and merge files. 


(3) Creating / Enhancing databases for your subject

VIDEO Constructing a database from scratch (21 minutes) 

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


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


Subpages (1): Online Databases