Mar 28, 2024  
2019-2020 Catalog 
    
2019-2020 Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

CIT 604 - Electronic Spreadsheets: Excel


Credits: 1
1 Lecture Hours

Prerequisites: Basic skills using a personal computer and operating system and some basic exposure to Microsoft Office.

 
Description
This course is an introduction to solving business and technical problems using Microsoft Excel.  Topics include basic spreadsheet concepts involving design, formulas, functions and charts.  This course is graded on a pass/fail basis.


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

  1. Identify the names and functions of the spreadsheet interface.
  2. Describe the theory and concepts of electronic spreadsheets and their role in decision making.
  3. Demonstrate the ability to design a worksheet, select cells, enter text and numbers and navigate using spreadsheet application.
  4. Format a worksheet by adjusting column widths, inserting rows and columns, aligning text and adding borders/colors/shading.
  5. Create formulas using relative and absolute references and functions.
  6. Design charts from spreadsheet data.
  7. Modify attributes of charts.
Listed Topics
  1. Spreadsheet creation with text/numbers
  2. Formulas, functions and relative vs absolute cell references
  3. Spreadsheet formats
  4. Visual presentation of data through charts
  5. Role of spreadsheets in decision making
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
Approved By: Bullock, Quintin Date Approved: 03/15/2019


Course and Section Search




Add to Portfolio (opens a new window)