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. Prerequisite:
ADMN 110 or consent of instructor
General Education Competency
[GE Core type]
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
General Education Competency
[GE Core type]
Semester Contact Hours Lecture
15
Semester Contact Hours Lab
45
Grading Method
Letter grade
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. Prerequisite: ADMN 110 or consent of instructor
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