Database
Management
Competency I - The teacher candidate will use his/her electronic portfolio to create and manage an information database.
Gateway Requirement: Gateway 3 — Completion of Student Teaching (STT Gateway)
See the Competency Homepage for courses associated with this competency.
Authentic Performance Task: The teacher candidate will design, manipulate, and retrieve database information for an educational purpose. The teacher candidate will write a rationale for the database designed, explaining how the reported information would be used in an educational setting. The database will be designed to have multiple records and fields. At least 2 different field types from the following list must be included: numeric, alpha, date/time, and currency. A report will be developed using a query that supports the stated educational purpose. The nature of the query will be described. A reflection will be written explaining how the report supports the educational purpose and how he/she will use the information reported.
Definition: A database is a collection of information organized in such a way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system. Traditional databases are organized by fields, records, and files. A field is a single piece of information; a record is one complete set of fields; and a file is a collection of records. For example, a telephone book is analogous to a file. It contains a list of records, each of which consists of three fields: name, address, and telephone number. The following is a list of how databases might be used for educational purposes:
- Maintaining student information to track meeting standards
- Keeping addresses for mailings to parents, etc.
- Maintaining classroom library records
- Keeping track of student readings
- Creating files of lesson plans linked to standards, topics, and units of study
- Having students keep learning journals
- Organizing collections of questions and answers
- Keeping information on items of study, such as information on the 50 states, information of inappropriate student behaviors, etc.
Training Resources: To access information from a database, you need a database management system (DBMS), such as Microsoft Access, Filemake Pro, or a free web-based database (e.g., DBApp). Check the resources link for information.
Scoring Rubric: A scoring rubric provides definitive criteria for assessing this competency. See the Evaluation web page for required elements.
Assessment Process: The course instructor will determine the timing, location, and general procedures for this assessment process.
Submission Format: The written rationale for the database, a database table (or snapshot of a large table), a report generated from that database, and a reflection must be submitted to the student’s electronic portfolio using a required format specified by major department.
Passing Criterion: 100% level of performance.
competencies | resources | evaluation | faculty | contact us | home
