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

Credits

1

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]

Credit Hours Narrative

1

Grading Method

Letter grade

Repeatable

N

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