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.

Credits

1 Credit

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

Repeatable

N

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