Catalog Course Search Details

 Department:    OBT

 Course #:    134

 Credits:    5

 Variable:     No

 IUs:    5

 CIP:    520204

 EPC:    547

 REV:    2024

 Course Description  

Use Microsoft Excel for PCs to create, edit, and format spreadsheets; write formulas and use functions to find numerical solutions; create charts and add graphics to create visual interest; and manage worksheet data. Use Microsoft Access for PCs to create, edit, and manage database tables; establish table relationships; filter, query, and sort data; and create forms and reports.

 Prerequisite  

Prerequisite: Basic computer skills and the ability to type by touch are strongly recommended. (For PCs only).

Contact Hours (based on 11 week quarter)

Lecture: 55

Lab: 0

Other: 0

Systems: 0

Clinical: 0

Intent: Distribution Requirement(s) Status:  

Vocational Preparatory Required for ATA degree, Required for certificate  

Equivalencies At Other Institutions

Learning Outcomes

After completing this course, the student will be able to:

1. Create, enter, and edit data in spreadsheets.
2. Format worksheets in a uniform, attractive style.
3. Write formulas using mathematical operators and absolute and mixed cell references.
4. Find numerical solutions using common mathematical, statistical, financial, date and time, and logical functions.
5. Create, modify, and format charts.
6. Create diagrams and use other graphical devices to add visual interest to worksheets.
7. Manage multiple Excel worksheets.
8. Create and modify database tables to organize business or personal records.
9. Modify and manage database tables to ensure that data is accurate and up to date.
10. Create relationships between Access tables.
11. Design queries to extract data needed for reporting or decision making.
12. Design forms and reports to meet communication needs.
13. Manage the electronic storage of files.
14. Analyze workplace scenarios requiring number-based solutions or the analysis and reporting of data and apply appropriate strategies to arrive at solutions using Excel and Access.

General Education Learning Values & Outcomes

Revised August 2008 and affects outlines for 2008 year 1 and later.

Course Contents

1. Microsoft Excel: Worksheet creation and editing.
2. Microsoft Excel: Formatting techniques.
3. Microsoft Excel: Formula-writing concepts.
4. Microsoft Excel: Common Excel functions.
5. Microsoft Excel: Chart creation and modification.
6. Microsoft Excel: Graphic enhancements.
7. Microsoft Excel: Basic workbook management techniques.
8. Microsoft Access: Relational database concepts.
9. Microsoft Access: Table design and creation.
10. Microsoft Access: Table relationships.
11. Microsoft Access: Data filtering and sorting.
12. Microsoft Access: Query design.
13. Microsoft Access: Basic form design.
14. Microsoft Access: Basic report design.