CIS 109 - Spreadsheet Software
Credit Hours: 3
Billable Contact Hours: 3
Prerequisites: RDG 090 and ENGL 090 or qualifying scores on accepted placement tests
Session Cycle: FWSU
This course familiarizes students with electronic spreadsheets, spreadsheet graphics and data management systems. The various applications to business and general management systems will be discussed. Hands-on experience will be provided utilizing a popular spreadsheet software package such as Excel for Windows.
Notes:
Business Division
Theory Hours: 45
Learning Outcomes:
1. Identify and Recognize:
- components of the spreadsheet window and spreadsheet design concepts.
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- text, data, formulas, and how to write a formula
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- the various categories of functions
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- the major types of charts
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- definitions from a list of glossary terms relative to spreadsheets
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- cell references to other work sheets
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- editing and web tools
- validation rules
2. Demonstrate and Practice:
- enter data into a worksheet cell, edit the contents of a worksheet cell, write formulas using operators and functions
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- insert and delete rows and columns, insert borders around cells, format a worksheet, change column widths and row heights
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- spell check a worksheet, audit formulas
Applies To Computer Information Systems: Accounting/CIS, A.A.S. Program Outcome E
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- print all or a portion of a worksheet, define and print a chart, create and printa worksheet group
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- work with lists, compute statistics on selected records, freeze column or row labels
Applies To Computer Information Systems: Accounting/CIS, A.A.S. Program Outcome E
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
- record and edit macros
- perform what-if analysis, use advanced spreadsheet tools
- use data tables, and create 30 cell references
Applies To Computer Information Systems: Office Professional, A.A.S. Program Outcome D
|
