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
Prerequisites/Other Requirements: None
English Prerequisite(s): None
Math Prerequisite(s): None
Course Corequisite(s): None
Academic Program Prerequisite: None
Consent to Enroll in Course: No Department Consent Required
Dual Enrollment Allowed?: Yes
Number of Times Course can be taken for credit:
Programs Where This Course is a Requirement:
Computer Support Specialist, A.A.A.S., Data Science, Certificate, Data Science, A.A.A.S., Pre-Accounting, A.B. (3+1, Davenport University), Pre-Biological Laboratory Science, A.A. (3+1, Davenport University), Pre-Business, A.A. (General Transfer), Pre-Business, A.B. (3+1, Davenport University), Pre-Marketing, A.B. (3+1, Davenport University), Pre-Management, A.B. (3+1, Davenport University),

Other Courses Where This Course is a Prerequisite: None
Other Courses Where this Course is a Corequisite: None
Other Courses Where This course is included in within the Description: None

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

Format, organize, and manage data to enhance clarity, readability, and meaning in spreadsheets.
Apply formulas, functions, and analytical tools to calculate, interpret, and summarize data.
Create visual representations—such as charts, graphs, and tables—to communicate insights effectively.
Design and integrate multiple worksheets and workbooks to develop structured, multi-sheet Excel applications.
Utilize advanced Excel features such as lookup functions, PivotTables, filters, and custom formats to solve complex data problems.

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

Approved for Online and Hybrid Delivery?:
Yes
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
Equivalent Courses:
None

Accepted GRCC Advanced Placement (AP) Exam Credit: None
Name of Industry Recognize Credentials: None

Course prepares students to seek the following external certification:
No
Course-Specific Placement Test: None
Course Aligned with ARW/IRW Pairing: N/A

Mandatory Department Assessment Measures:
None

GRCC Course Type:
Program Requirement: Meets the learning needs of students in a specific GRCC program.
Course Format:
Lecture - 1:1
Total Lecture Hours Per Week: 3
People Soft Course ID Number: 104608
Course CIP Code: 11.9999
Maximum Course Enrollment: 24
Course Software Utilized: Microsoft Excel

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
School: School of STEM
Department: Computer Information Systems
Discipline: CIS
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.

Major Course Revisions: N/A
Last Revision Date Effective: 20260220T14:28:32
Course Review & Revision Year: 2030-2031

Essential Abilities/Technical Standards:
None