ADMN 116 Spreadsheet Applications*

This course will continue exploration of the commands and applications of Excel electronic spreadsheets, including graphs, database functions, simple macros and more.

Credits

3 Credits

Semester Contact Hours Lecture

15

Semester Contact Hours Lab

45

Prerequisite

ADMN 110 or BUSA 215

ADMN 116Spreadsheet Applications*

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

3 Credits

Semester Contact Hours Lecture

15

Semester Contact Hours Lab

45

Prerequisite Narrative

ADMN 110 or BUSA 215

Grading Method

Letter grade

Repeatable

N

III. Catalog Course Description

This course will continue exploration of the commands and applications of Excel electronic spreadsheets, including graphs, database functions, simple macros and more.

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 Work with functions Develop multi-sheet workbooks Create Custom formats, AutoFormat, Styles, Templates Work with Charts Sort, Filter, & Edit Lists Work with formulas Work with worksheet protection Guide Cell Entry with Data Validation Analyze PivotTable and Pivot Chart Reports Create Consolidated Data, Outlines, Views and Reports Automate Tasks with Macros Use Data tables

VI. Delivery Methodologies