Jan 27, 2023
CIT 140 - Office Productivity Applications
4 Lecture Hours
Prerequisites: Basic skills using a personal computer, eligibility for MAT 090 .
This course provides students with knowledge and skills involved with common office productivity applications. Student learn the features and functions of the Excel spreadsheet application as well as the Access database application. Students learn to effectively use and integrate data from spreadsheets with a database in the development of solutions for business-oriented problems. Critical thinking and quantitative reasoning through project-based activities is emphasized.
Upon successful completion of the course, the student will:
- Manage spreadsheet worksheets and workbooks.
- Demonstrate effective spreadsheet workbook management techniques.
- Manage data cells, ranges and tables within a spreadsheet.
- Apply custom data formats and layouts within a spreadsheet.
- Perform spreadsheet operations with formulas and functions.
- Create advanced formulas, charts and tables within a spreadsheet.
- Manage a simple relational database.
- Create tables, queries, forms and reports within a relational database.
- Devise business-oriented solutions involving simple relational database design and its integration with a spreadsheet for data analysis purposes.
The following topics are based in part on those items specified by Microsoft Office Specialist (MOS) for Excel, Excel Expert and Access certification.
- Excel workbook and worksheet creation, formatting, options, navigation and distribution
- Excel cell formats, ranges and organization
- Excel formulas, functions, data analysis, conditional operations and troubleshooting
- Excel table creation, styles, filtering, sorting and distribution
- Excel chart creation and formatting
- Access exported tables, table creation, fields and records
- Access query controls, calculated fields and grouping
- Access form controls and formats
- Access report controls and formats
Textbooks/materials, current and appropriate software, multimedia for lecture and demonstration as required by instructor; access to the Internet.
Students who successfully complete this course acquire general knowledge, skills and abilities that align with CCAC’s definition of an educated person. Specifically, this course fulfills these General Education Goals:
Approved By: Bullock, Quintin Date Approved: 03/15/2019
- Technological Competence
- Critical Thinking and Problem Solving
- Quantitative and Scientific Reasoning
Course and Section Search
Add to Portfolio (opens a new window)