CISA 115 Introduction to Spreadsheets
This course will provide hands-on training in practical applications using spreadsheet software. Students will create, save, and print spreadsheets using simple formulas and formatting commands. This course meets the spreadsheet portion of the Computer Literacy Graduation requirement if passed with a C or better.
CISA 115Introduction to Spreadsheets
Please note: This is not a course syllabus. A course syllabus is unique to a particular section of a course by instructor. This curriculum guide provides general information about a course.
I. General Information
Department
Information Technology
II. Course Specification
Course Type
Program Requirement
Credit Hours Narrative
1 Credit
Grading Method
Letter grade
III. Catalog Course Description
This course will provide hands-on training in practical applications using spreadsheet software. Students will create, save, and print spreadsheets using simple formulas and formatting commands. This course meets the spreadsheet portion of the Computer Literacy Graduation requirement if passed with a C or better.
IV. Student Learning Outcomes
Upon completion of this course, a student will be able to:
- Use spreadsheet software to create, format and manage workbooks.
- Create formulas and use functions to solve mathematical problems.
- Use Excel tools to chart and analyze data.
V. Topical Outline (Course Content)
Create, Save and Navigate and Excel Workbook
Construct and Copy Formulas
Use the Sum, Max, Min, Median, Average and Now Function
Chart Data and Insert Sparklines Values
Format Worksheets
Create an Excel Table
Use Logical functions such as IF, CountIf and Iferror.
Work with Multiple Worksheets by Grouping
Construct Formulas for Mathematical Operations
Construct Formulas that Refer to Cells in another Worksheet
Use Absolute and Relative Cell References
Use Excel Web App
Format Data Series
Use Chart Format tools
Use Goal Seek
Use order of operation when construction formulas
VI. Delivery Methodologies