CIT 140 - Spreadsheets for Business Environments
4 Lecture Hours
Prerequisites: Basic skills using a personal computer and operating system and basic experience using the Microsoft Office user interface; MAT 090 or successful placement
This course explores the development of spreadsheets for use in a business environment. Students create and use spreadsheets, charts, tables and database-like functions in the development of solutions for business-oriented problems. Students enhance their creativity and critical thinking skills through project-based learning. Learning outcomes are consistent with many of those required for Microsoft Excel Expert certification.
Upon successful completion of the course, the student will:
- Apply fundamental Excel tools in problem solving.
- Solve problems using statistical analysis tools.
- Determine effective data display involving charts.
- Retrieve data from computation, analysis and reference.
- Organize data for effective analysis.
- Use data tables and scenarios for what-if analysis.
- Create a relational database structure within spreadsheets using tables, primary and foreign keys, queries, forms and dashboard reports.
The following topics are based in on topics appearing in the Microsoft Office Specialist (MOS) for Excel Expert certification.
- Workbooks and worksheets
- Cell formats, ranges and organization
- Formulas, functions, conditional operations and troubleshooting
- Filtering, sorting and distribution
- Chart creation and formatting
- Data analysis using What-If, Goal Seek and Solver
- Nesting lookup and reference functions
- Pivot tables, grouping and reports
- Queries, calculated fields and grouping
- Forms and report controls
- Relational database concepts involving primary and foreign keys
- Tables, fields and records
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: Dr. Quintin B. Bullock Date Approved: 3/16/2022
- Technological Competence
- Critical Thinking & Problem Solving
Course and Section Search
Add to Portfolio (opens a new window)