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.
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
II. Course Specification
Course Type
Program Requirement|{D7A8FC71-978F-4003-9933-512C476323B2}
Credit Hours Narrative
1 Credit
Semester Contact Hours Lecture
15
Semester Contact Hours Lab
0
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.
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