Jump over the site's left-side navigation bar.
Teacher Education Requirements
ITPS I: Database Management
The teacher candidate will use his/her electronic portfolio to create and manage an information database.
When should ITPS I be completed?
For specific details related to when this competency should be fulfilled, download the teacher education requirements implementation grid (pdf).
Instructional Technology Passport System (ITPS)
ITPS I. Database Management
You will design, manipulate, and retrieve database information for an educational purpose. You 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 two 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.
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.
To access information from a database, you need a database management system (DBMS), such as Microsoft Access, Filemaker Pro (tutorial pdf), or a free web-based database.
The course instructor will determine the timing, location, and general procedures for this assessment, but students are responsible for learning the required skills using available resources. The Database Development workshop is available to help you gain the skills you need. University computer labs provide hardware, software, and access to online resources.
Assessment
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 your electronic portfolio using a required format specified by major department.