Version: 3/20/2019 2
Additional Course Information
Topical Outline: Each offering of this course must include the following topics (be sure to include information regarding lab,
practicum, and clinical or other non-lecture instruction).
Navigate a workbook.
Open, edit, manage and print a workbook.
Create a workbook, change fonts, enter basic formulas.
Use and edit formatting tools.
Use series and Autofill.
Work with cells, columns, rows, and sheets.
Use templates.
Work with math, trig, statistical, and date and time functions.
Use logical and financial functions.
Build charts.
Use auto shapes, WordArt, and comments.
Use image, diagrams, and research.
Work with multiple worksheets.
Work with lists.
Use worksheet templates.
Work with ranges.
Work with lookup and reference functions.
Create worksheet and workbook templates.
Work with macros.
Course Learning Outcomes:
Learning Outcomes – Upon successful completion of this course, students will:
Identify spreadsheet terminology and concepts; calculate data using formulas and functions; create and modify
workbooks; insert graphics; generate charts and reports; and create and use special functions.
Methods of Assessment:
Hands-on Application Tests
Written Theory Tests
Daily Exercises
Required text(s), optional text(s) and/or materials to be supplied by the student:
The latest version of GO! with Microsoft Excel 2016 Comprehensive by Gaskin with Mylab.
Suggested Course Maximum:
20
List any specific or physical requirements beyond a typical classroom required to teach the
course.
At least 20 computers with USB ports in the front, Laser printer, at least one color printer, desks for the computers and
printers, internet access, and the latest version of Microsoft Excel.
Course Requirements/Grading System: Describe any course specific requirements such as research papers or
reading assignments and the generalized grading format for the course.
70% Hands-on Application Test average
