MASTER SYLLABUS

2020-2021

Academic Division: Business, Industry, and Technology

Discipline: Computer Information Systems

Course Number and Title: CISS1290 Microsoft Office Business Intelligence

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.

Credit Hours: 2

Lecture: 1 hour

Laboratory: 2 hours

Prerequisites: CISS1280 c

Syllabus Effective Date: FAll 2020

Textbook(s) Title:

Microsoft Excel 2019 Data Analysis and Business Modeling

Author: Winston

Year: 2019

Edition: 6th

ISBN: 9781509305889

Workbook(s) and/or Lab Manual: None

Course Description: This course introduces the concepts and application of data analytics in business. A hands-on approach of Microsoft Excel and Power BI (Business Intelligence tools) is used for data analysis, data visualization, modeling, creating dashboards with direct connectivity to data sources.

College-Wide Learning Outcomes

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

Course Outcomes and Assessment Methods:

Upon successful completion of this course, the student will:

Outcomes	Assessments – How it is met & When it is met
Apply analysis tools in Excel	Hands-on application projects Weeks 1-2
Create Excel data models	Hands-on application projects Weeks 3-4
Import data from a .CSV file, SQL Server database, report	Hands-on application projects Weeks 5-6
Explore DAX (Data analysis expressions) functions	Hands-on application projects Weeks 7-8
Create data visualizations	Hands-on application projects Weeks 9-12

Topical Timeline (Subject to Change):

Data Analysis in Excel	Weeks 1-2

Data Analysis with Excel

Excel Pivot Tables

Build Classic Excel Dashboard

Format Data

Build a Pivot Table

Add pivot charts and a slicer

Excel Data Model	Weeks 3-4

Using an Excel Data Model

Create Calculated Columns

Format Data Model Data

Create Measures

Analyze the Data

Importing Data from Files	Weeks 5-6

Import Data into Excel

Preview, Shape and Transform Data

Import and Transform Data from a CSV File

Import Data from SQL Server

Create a Data Table

Import Data from Excel Reports

Transform Excel report Data

Load Data into an Excel Data Model

Creating and Formatting Measures	Weeks 7-8

DAX

Calculated columns

Measures

Functions

Visualizing Data in Excel	Weeks 9-12

Pivot Charts

Cube Functions

Charts for Cube Functions

Create a Tabular Report

Create a Pivot Chart

Add Slicers to Charts

Using Excel with Power BI	Weeks 13-16

Power BI

Upload Excel Data to Power BI

Power BI Mobile App

Create Power BI Dashboard

Use Power BI desktop

Course Assignments:

Hands-on application projects

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

Grading and Testing Guidelines:

Click here to enter text.

Examination Policy:

Click here to enter text.

Class Attendance and Homework Make-Up Policy:

Click here to enter text.

Classroom Expectations:

Click here to enter text.

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