Course Number: CAS 140
Transcript Title: Beginning Databases
Created: September 1, 2012
Updated: July 10, 2015
Total Credits: 4
Lecture Hours: 10
Lecture / Lab Hours: 60
Lab Hours: 0
Satisfies Cultural Literacy requirement: No
Satisfies General Education requirement: No
Grading options: A-F (default), P-NP, audit
Repeats available for credit: 0
Covers database fundamentals, basic skills for designing and manipulating a database and beginning database management concepts including tables, forms, reports, and queries. Stresses a working knowledge of database management vocabulary. Introduces the basic features of database application software. Recommended: Placement into RD 115 and WR 115 or higher. Audit available.
Upon successful completion of this course, students will be able to:
- Use a database application to create personal and/or business databases following current professional and/or industry standards.
- Use database applications to efficiently retrieve data.
- Apply database design principles to a new or existing database.
- Communicate in a business setting using database management vocabulary.
Outcome Assessment Strategies
Assessment may include: Projects with original work, reflection journals, group discussions, open ended assessment, objective tests on basic document functions.
Course Activities and Design
Activities may include: readings and videos, class discussions, reflection writings, open ended assignments.
Course Content (Themes, Concepts, Issues and Skills)
Themes, Concepts, Issues
- Communicate effectively using appropriate database management vocabulary.
- Use critical thinking and problem solving skills in designing databases for various business and personal projects.
- Proofread for accuracy in the entry of data and creation of database objects such as, tables, reports, forms and queries.
- Assess the databases for accuracy, readability, and appearance.
- Develop efficiency with specific sets of skills through repetitive reinforcement.
Students will develop proficiency through reinforcement and assessment on the following skills:
- Creating tables by defining fields composed of various data types and entering text and numeric records.
- Creating and modifying forms including sub-forms.
- Creating, modifying and customizing basic, grouped and summary reports.
- Use queries to update and delete records, sort information and create reports.
- Designing and creating queries using wildcard characters, multiple criteria, joined tables, and calculated fields.
- Create and modify basic switchboard interfaces using simple macros.
- Establish relationships between two tables to ensure integrity and accuracy.
- Design and create a database management system from scratch using original information.
Students will be familiar with the following skills:
- Using help features.
- Establishing relationships between more than two tables.
- Printing mailing labels.
- Documenting and compacting databases.
- Using additional functions such as combo boxes.
- Using additional field data types such as memo, OLE, and hyperlink fields.
- Students may be exposed to additional database management skills/concepts as time allows.