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, 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),

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.

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

Name of Industry Recognize Credentials: None

Course prepares students to seek the following external certification:
No
Course-Specific Placement Test: None
Mandatory Department Assessment Measures:
None

Course Type:
Program Requirement- Offering designed to meet 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
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.

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

Essential Abilities/Technical Standards:
None