CISA 115 Introduction to Spreadsheets
This course explores the Microsoft Office application Excel with an emphasis on constructing formulas and using simple functions. Students will format worksheets, create and modify charts and use other Excel tools to solve common problems Required Student Learning Outcomes
General Education Competency
[GE Core type]
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
General Education Competency
[GE Core type]
Grading Method
Letter grade
III. Catalog Course Description
This course explores the Microsoft Office application Excel with an emphasis on constructing formulas and using simple functions. Students will format worksheets, create and modify charts and use other Excel tools to solve common problems Required Student Learning Outcomes
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