CIS 156 - Microsoft Excel

Description
This course provides students with the opportunity to learn and use Microsoft Excel in a hands-on environment. Students learn to manipulate spreadsheet data using a variety of formulas, functions, macros and database commands. Topics include using wizards, creating charts and graphics, using multiple worksheets, and lookup tables. Practical examples are shown for work, home, and education.

Credit Hours: 3
Contact Hours: 3

School: School of STEM
Department: Computer Information Systems
Discipline: CIS

Last Revision Date Effective: 2017-03-03 20:29:23
Course Review & Revision Year: 2024-2025

Course Type:
Computer Information Systems
Course Format:
Lecture - 1:1

General Education Requirement: None
General Education Learner Outcomes (GELO):
NA

Course Learning Outcomes:

Explain how to format workbook text and data.
Calculate data with formulas and functions.
Analyze and chart financial data.
Compare Excel Tables, Pivot Tables and Pivot Charts.
Design multiple worksheets and workbooks.
Develop an Excel application and work with advanced functions.
Critique text functions and create custom formats.
Utilize advanced filters, database functions and summary IFS functions.
Use VLOOKUP function to find an exact match.
Demonstrate conditional formatting to evaluate data.
Use COUNTIF, SUMIF, AVERAGEIF and other mathematical function to do quick calculations.
Use visual representations such as graphs, charts, or graphics to enhance the meaning of the message that is being communicated.
Create and/or organize data and information into meaningful patterns in order to interpret and draw inferences from it.

Approved for Online Delivery?: Yes

Course Outline:
I. Creating basic worksheets

II. Formatting workbook text and data

III. Calculating data with formulas and functions

IV. Analyzing and charting financial data

V. Working with Excel Tables, Pivot Tables and Pivot Charts

VI. Managing multiple worksheets and workbooks

VII. Developing an Excel application

VIII. Working with advanced functions

IX. Working with text functions and creating custom formats

X. Advanced filters, database functions and summary IFS functions

Mandatory CLO Competency Assessment Measures:
None

Name of Industry Recognize Credentials: None

Instructional Strategies:
Lecture: 30-60%

Facilitated discussion: 0-20%

Group work: 0-10%

Lab work: 10-40%

Mandatory Course Components:
1.Twenty to twenty-five Excel activities

2. On-line quizzes

3. Final Excel project

Academic Program Prerequisite: None
Prerequisites/Other Requirements: None
English Prerequisite(s): None
Math Prerequisite(s): None
Course Corerequisite(s): None
Course-Specific Placement Test: None
Consent to Enroll in Course: No Department Consent Required

Total Lecture Hours Per Week: 3
Faculty Credential Requirements:
Master’s Degree (GRCC general requirement), Professionally qualified through work experience in field (Perkins Act or Other) (list below)
Faculty Credential Requirement Details: The instructor must possess knowledge of the Office environment, 4000 hours of Office experience and be able to clearly explain all topics covered in the course so that the student will be able to understand the concepts taught.

Maximum Course Enrollment: 24
Equivalent Courses: None
Dual Enrollment Allowed?: Yes
Number of Times Course can be taken for credit:
Programs Where This Courses is a Requirement:
Computer Support Specialist, A.A.A.S., Data Science, Certificate, Pre-Accounting, A.B. (3+1, Davenport University), Pre-Biological Laboratory Science, A.A. (3+1, Davenport University), Pre-Business, A.B. (3+1, Davenport University), Pre-Marketing, A.B. (3+1, Davenport University), Pre-Management, A.B. (3+1, Davenport University),
People Soft Course ID Number: 104608
Course CIP Code: 11.9999

High School Articulation Agreements exist?: Yes
If yes, with which high schools?: Forest Hills Central High School, Forest Hills Eastern High School, Forest Hills Northern High School, Godwin Heights High School, Hudsonville High School, Jenison High School, Kent Career Technical Center, M-TEC Lakeshore Campus, Newaygo Career Tech Center, Northview High School
Essential Abilities/Technical Standards:
None