OAT 160 - Records Management

Credits: 3

Covers principles and practices of effective records management for manual and electronic records systems using alphabetic, numeric, and subject methods. Introduces and applies database concepts needed for understanding electronic records storage and retrieval methods including creating, modifying, sorting, searching, and printing. Explores database queries to produce tables and reports. Credit may be earned in OAT 160 or OAT 157 but not in both.

Prerequisite(s): READING LEVEL 2 and WRITING LEVEL 3, and OAT 170 with a minimum grade of “B” (3.0).
Corequisite(s): None
Lecture Hours: 45 Lab Hours: 0
Meets MTA Requirement: None
Pass/NoCredit: Yes

Outcomes and Objectives

Manage paper and electronic records using alphabetic, numeric, and subject filing methods.
1. Use the alphabetic, numeric, and subject methods to incorporate the steps of the filing process–inspecting, indexing, coding, sorting, and storing.
2. Prepare cross-references as needed.
3. Retrieve information through requisition and charge-out procedures.
4. Demonstrate mastery of filing concepts and records management terminology.
5. Locate designated files and record requested information.
Develop and understanding of a database management system.
1. Create a database structure using various field types.
2. Create queries and reports that will extract records that meet specific criteria.
3. Demonstrate knowledge of a computer database through creating, modifying, sorting, searching, and printing records.
4. Enter data into multiple tables within a database.
5. Modify table field properties to reduce data entry errors.
Demonstrate professionalism appropriate for the workplace.
1. Participate in class.
2. Follow written and oral directions.
3. Complete and submit assignments on time.
4. Participate constructively in activities.
5. Display civility toward other class members and the instructor.
6. Demonstrate academic integrity.