CIT 140 - Office Productivity Applications

 
Description
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.

1. Manage spreadsheet worksheets and workbooks.
2. Demonstrate effective spreadsheet workbook management techniques.
3. Manage data cells, ranges and tables within a spreadsheet.
4. Apply custom data formats and layouts within a spreadsheet.
5. Perform spreadsheet operations with formulas and functions.
6. Create advanced formulas, charts and tables within a spreadsheet.
7. Manage a simple relational database.
8. Create tables, queries, forms and reports within a relational database.
9. Devise business-oriented solutions involving simple relational database design and its integration with a spreadsheet for data analysis purposes.

1. Excel workbook and worksheet creation, formatting, options, navigation and distribution
2. Excel cell formats, ranges and organization
3. Excel formulas, functions, data analysis, conditional operations and troubleshooting
4. Excel table creation, styles, filtering, sorting and distribution
5. Excel chart creation and formatting
6. Access exported tables, table creation, fields and records
7. Access query controls, calculated fields and grouping
8. Access form controls and formats
9. Access report controls and formats

• Technological Competence
• Critical Thinking and Problem Solving
• Quantitative and Scientific Reasoning

Course and Section Search