CIT 604 - Electronic Spreadsheets: Excel
1 Lecture Hours
Prerequisites: Basic skills using a personal computer and operating system and some basic exposure to Microsoft Office.
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.
Upon successful completion of the course, the student will:
- Identify the names and functions of the spreadsheet interface.
- Describe the theory and concepts of electronic spreadsheets and their role in decision making.
- Demonstrate the ability to design a worksheet, select cells, enter text and numbers and navigate using spreadsheet application.
- Format a worksheet by adjusting column widths, inserting rows and columns, aligning text and adding borders/colors/shading.
- Create formulas using relative and absolute references and functions.
- Design charts from spreadsheet data.
- Modify attributes of charts.
- Spreadsheet creation with text/numbers
- Formulas, functions and relative vs absolute cell references
- Spreadsheet formats
- Visual presentation of data through charts
- Role of spreadsheets in decision making
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
Course and Section Search
Add to Portfolio (opens a new window)