Feb 21, 2024  
2022-2023 Catalog 
    
2022-2023 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CIT 140 - Spreadsheets for Business Environments


Credits: 4
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

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


Learning Outcomes
Upon successful completion of the course, the student will:

  1. Apply fundamental Excel tools in problem solving.
  2. Solve problems using statistical analysis tools.
  3. Determine effective data display involving charts.
  4. Retrieve data from computation, analysis and reference.
  5. Organize data for effective analysis.
  6. Use data tables and scenarios for what-if analysis.
  7. Create a relational database structure within spreadsheets using tables, primary and foreign keys, queries, forms and dashboard reports.
Listed Topics
The following topics are based in on topics appearing in the Microsoft Office Specialist (MOS) for Excel Expert certification.

  1. Workbooks and worksheets
  2. Cell formats, ranges and organization
  3. Formulas, functions, conditional operations and troubleshooting
  4. Filtering, sorting and distribution
  5. Chart creation and formatting
  6. Data analysis using What-If, Goal Seek and Solver
  7. Nesting lookup and reference functions
  8. Pivot tables, grouping and reports
  9. Queries, calculated fields and grouping
  10. Forms and report controls
  11. Relational database concepts involving primary and foreign keys
  12. Tables, fields and records
Reference Materials
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:
  • Technological Competence
  • Critical Thinking & Problem Solving
Approved By: Dr. Quintin B. Bullock Date Approved: 3/16/2022


Course and Section Search




Add to Portfolio (opens a new window)