MASTER SYLLABUS

2020-2021

A.	Academic Division: Business, Industry, and Technology

B.	Discipline: Computer Information Systems

C.	Course Number and Title: CISS1280 Microsoft Excel Advanced

D.	Course Coordinator: Carmen Morrison

Assistant Dean: Toni Johnson, PhD

Instructor Information:

Name:	Click here to enter text.

Office Location:	Click here to enter text.

Office Hours:	Click here to enter text.

Phone Number:	Click here to enter text.

E-Mail Address	Click here to enter text.

E.	Credit Hours: 2

Lecture: 1 hour

Laboratory: 2 hours

F.	Prerequisites: CISS1220

G.	Syllabus Effective Date: Fall 2020

H.	Textbook(s) Title:

Go! With Microsoft Excel 2016 Comprehensive

Author: Gaskin, Vargas

Year: 2017

Edition: 1st

ISBN: 9780134572086

Workbook(s) and/or Lab Manual: None

J.	Course Description: This second level course covers expert Excel features, including formatting with advanced techniques, working with templates and workbooks, working with lists, using analysis tools, managing and auditing worksheets, collaborating with workgroups, and using advanced format functions.

K.	College-Wide Learning Outcomes

College-Wide Learning Outcomes	Assessments - - How it is met & When it is met
Communication – Written
Communication – Speech
Intercultural Knowledge and Competence
Critical Thinking
Information Literacy
Quantitative Literacy

L.	Course Outcomes and Assessment Methods:

Upon successful completion of this course, the student shall:

Outcomes	Assessments – How it is met & When it is met
Analyze large amounts of data using filters, PivotTables, PivotCharts, and Excel’s Business Analysis Tools: Data Model, PowerPivot and PowerView	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 1-4
Evaluate business solutions using Moving Average, Break-Even Point, Solver, Scenarios, and Complex formulas.	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 4-6
Automate complex and repetitive tasks using Macros	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 6-8
Manage external data using import, queries and database functions	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 9-11
Collaborate with Others using Shared Workbooks and Cloud Storage	Skill exam – hands-on practice to master skills Problem-based project – appropriate application of skills to solve a problem Weeks 12-15

M.	Topical Timeline (Subject to Change):

Create a PivotTable Report	Weeks 1-4

Use Slicers and Search Filters	Weeks 1-4

Modify a PivotTable Report	Weeks 1-4

Create a PivotChart Report	Weeks 1-4

Create a Data Model using PowerPivot	Weeks 1-4

Create a PivotTable using PowerPivot	Weeks 1-4

Create a Dashboard using PowerView	Weeks 1-4

Calculate a Moving Average	Weeks 4-6

Project Income and Expenses	Weeks 4-6

Determine a Break-Even Point	Weeks 4-6

Use Solver	Weeks 4-6

Create Scenarios	Weeks 4-6

Use Logical Functions	Weeks 4-6

Create Complex Formulas	Weeks 4-6

Record a Macro	Weeks 6-8

Assign a Macro to a Button on the Quick Access Toolbar	Weeks 6-8

Modify a Macro	Weeks 6-8

Restore Initial Settings	Weeks 6-8

Get External Data into Excel	Weeks 9-11

Create a Query and Use the Query Wizard to Sort and Filter	Weeks 9-11

Use Database Functions	Weeks 9-11

Insert a Second Table into a Worksheet	Weeks 9-11

Apply Conditional Formatting to Side-by-Side Tables	Weeks 9-11

Insert a Screenshot	Weeks 9-11

Create Custom Headers and Footers	Weeks 9-11

Create a Shared Workbook	Weeks 12-15

Track Changes Made to a Workbook	Weeks 12-15

Merge Workbooks and Accept Changes	Weeks 12-15

Prepare a Final Workbook for Distribution	Weeks 12-15

Upload a Workbook to OneDrive	Weeks 12-15

N.	Course Assignments:

Practice labs to develop mastery of skills

Exams

Problem-based Projects to apply skills to solve problems

O.	Recommended Grading Scale:

NUMERIC	GRADE	POINTS	DEFINITION
93–100	A	4.00	Superior
90–92	A-	3.67	Superior
87–89	B+	3.33	Above Average
83–86	B	3.00	Above Average
80–82	B-	2.67	Above Average
77–79	C+	2.33	Average
73–76	C	2.00	Average
70-72	C-	1.67	Below Average
67–69	D+	1.33	Below Average
63-66	D	1.00	Below Average
60-62	D-	0.67	Poor
00-59	F	0.00	Failure

P.	Grading and Testing Guidelines:

Click here to enter text.

Q.	Examination Policy:

Click here to enter text.

R.	Class Attendance and Homework Make-Up Policy:

Click here to enter text.

S.	Classroom Expectations:

Click here to enter text.

T.	College Procedures/Policies:

Important information regarding College Procedures and Policies can be found on the syllabus supplement located at

http://catalog.ncstatecollege.edu/mime/download.pdf?catoid=5&ftype=2&foid=3