Skip to main content

Course Outlines

BSYS 2051

Introduction to Business Data Analytics with MS Excel 2019 for Windows

School School of Business + Media
Course Credits 3
Minimum Passing Grade 50%
Start Date October 26, 2021
End Date December 03, 2021
Total Hours 36
Total Weeks 6
Hours/Weeks 6
Delivery Type Other
Pre-requisites BSYS 1001
CRN 47615

Acknowledgement of Territories

The British Columbia Institute of Technology acknowledges that our campuses are located on the unceded traditional territories of the Coast Salish Nations of Sḵwx̱wú7mesh (Squamish), səl̓ilwətaɁɬ (Tsleil-Waututh), and xwməθkwəy̓əm (Musqueam).

Instructor Details

Name Ed Bosman
E-mail Instructor to provide
Location
Office Hours Instructor to provide

Course Description

​The main focus of this course is to develop data analytic skills and demonstrate the ability to manage and present complex data to effectively support business decisions. Students will develop a sound methodology to build "what if" spreadsheet models to assess various business cases. Throughout the course, students will work on business cases in which the design of the spreadsheet is of paramount importance. This course covers advanced Excel formulas, concepts, and applications using larger and more professional worksheets and focusses on the data modeling approach using MS Excel. Topics include built-in functions, charts, transferring data across applications, and using the built-in tools including Pivot Tables, Sparklines, Slicers, and Power Pivots.

Course Learning Outcomes/Competencies

Upon successful completion of this course, the student will be able to:

  • Use correct data modeling terminology.
  • Apply Relative, Absolute and Mixed cell references.
  • Solve financial/business problems using appropriate functions such as PMT, FV, NPER, IRR, NPV and RATE in assessing business cases.
  • Develop effective "what if" statements in a spreadsheet to support business decisions.
  • Implement advanced spreadsheet functions such as Goal Seek and Scenario Manager to support business decisions.
  • Develop a multi-sheet worksheet model capable of sensitivity analyses.
  • Prepare, create and apply Templates and Styles in Charts and Tables.
  • Organize data lists using filters and PivotTables.
  • Summarize data using statistical functions.
  • Apply data validation options.
  • Analyze data using the Scenario Manager, Data Tables and Goal Seek.
  • Use imported and exported data to build models.
  • Demonstrate finding and fixing formula errors and 3D formulas.
  • Apply basic Macros.

Learning Resources

Required:

Carey - New Perspectives Microsoft® Office 365® & Excel 2019 Comprehensive

ISBN 9780357025765,

Price - $113.95 list

Carey - eBook: New Perspectives Microsoft® Office 365 & Excel 2019 Comprehensive

ISBN 0357392647,

Price - $68.95 list

BCIT Bookstore link: https://www.campusebookstore.com/integration/AccessCodes/default.aspx?bookseller_id=238&Course=BSYS+2051&frame=YES&t=permalink

Required Software

You will need access to a computer containing a licensed copy of Microsoft ® Excel ® 2019 for Windows or the Office 365 version. Other versions of Excel (such as 2007, 2010, and 2013) and all Mac versions are NOT acceptable. The menu interface and even some of the functionality of Mac versions of Excel are different from Excel for Windows making it inadequate for this course.

Note: BCIT students may access a copy of Microsoft ® Excel ® 2019 for Windows for their use by following the instructions here.

Computer labs equipped with the required software are available for student use at BCIT campuses. Lab locations and hours of operation are posted at: http://www.bcit.ca/its/labs/bycampus/

A virtual BCIT computer lab desktop is available online for student use at https://workspace.bcit.ca/vpn/index.html

Course Goals

Upon successful completion of the course, the student will be able to:

· Use correct data modeling terminology

· Describe the components of functional spreadsheet applications

· Create simple financial models

· Solve financial/business problems using appropriate functions

· Organize data lists using filters and PivotTables and PowerPivot

· Summarize data using statistical functions

· Employ built-in tools in Excel 2019

· Analyze business data for decision making using analytics

Evaluation Criteria

Assignments

20     

%

Comments:

  1. Compliance with the “Course Notes (Policies and Procedures)” sections (see page 3 of the outline).     

Mid Term

40

%

Final Exam

40

%

TOTAL

100

%

Attendance Requirements

Attendance: Regular attendance in lectures and labs is seen as integral to student success, therefore, attendance in class is monitored. Unexcused absences in excess of 10% of the time prescribed for this course may result in the assignment of a failing grade. Attendance may be taken at any time during class. A student not present for attendance will be marked absent. A student who leaves class for a period of time deemed excessive by the instructor may be considered absent regardless of whether they are present when attendance is taken. In case of illness or other unavoidable absence, students must communicate with the instructor, or the appropriate Program Head, as soon as possible (preferably in advance) indicating the reason for the absence. Students who are seeking accommodation for a medical absence must have a BCIT-approved medical certificate (https://www.bcit.ca/files/healthservices/pdf/studentmedicalcertificate.pdf). For other absences, students must be prepared to provide appropriate supporting documentation. A student who has unexcused absences in excess of 10% of the time prescribed for the course by the Withdrawal Deadline is considered to have ‘Vanished’ and will be assigned a grade of ‘V’. In these cases, no further work will be graded. These requirements are set out in accordance with BCIT Policy 5101 Student Regulations: https://www.bcit.ca/files/pdf/policies/5101.pdf. More information regarding withdrawals from PTS courses is available here: https://www.bcit.ca/pts/pts_withdrawals.shtml.

Course Schedule and Assignments

Week

Outcome/Material Covered

Assignment

Due

Date1

1

3 hours Tuesday

3 hours Thursday

Modules 1 and 2: Getting Started With Excel and Formatting Workbook Text and Data

Review Assignment Module 1 and 2 Assignment 1

Oct 28

Module 3 and 4: Performing Calculations with Formulas and Functions, Analyzing and Charting Financial Information

Review Assignment Module 3 and 4 Assignment 2

Nov 2

2

3 hours Tuesday

3 hours Thursday

Module 5: Generating Reports from Multiple Worksheets and Workbooks

Review Assignment and Case 1 Assignment 3

Nov 4

Module 6: Managing Data with Data Tools

Review Assignment and Case 1 Assignment 4

Nov 9

3

3 hours Tuesday

3 hours Thursday

Module 7: Summarizing Data with PivotTsbles

Review Assignment and Case 1 Assignment 5

Nov 11

Mid Term (Module 1 to 6)

Nov 16

4

3 hours Tuesday

3 hours Thursday

Module 8: Performing What-if Analysis.

Review Assignment and Case 1 Assignment 6

Nov 18

Module 9: Exploring Financial Tools and Functions

Review Assignment and Case 1 Assignment 7

Nov 23

5

3 hours Tuesday

3 hours Thursday

Module10: Analyzing Data with Business Intelligence Tools

Review Assignment and Case 1 Assignment 8

Nov 25

Module11: Exploring PivotTable Design

Review Assignment and Case 1 Assignment 9

Nov 30

6

3 hours Tuesday

3 hours Thursday

Module12: Developing an excel application.

Review Assignment and Case 1 Assignment 10

Dec 3

Final Examination (All Material)

BCIT Policy

Any student who needs special assistance in the event of a medical emergency or building evacuation (either because of a disability or for any other reason) should promptly inform their course instructor(s) and Accessibility Services of their personal circumstances.

Human Rights, Harassment and Discrimination:
The BCIT community is made up of individuals from every ability, background, experience and identity, each contributing uniquely to the richness and diversity of the BCIT community as a whole. In recognition of this, and the intrinsic value of our diversity, BCIT seeks to foster a climate of collaboration, understanding and mutual respect between all members of the community and ensure an inclusive accessible working and learning environment where everyone can succeed.

Respect, Diversity, and Inclusion is a supportive resource for both students and employees of BCIT, to foster a respectful learning and working environment. Any student who feels that they are experiencing discrimination or harassment (personal or human rights-related) can confidentially access this resource for advice and support. Please see Policy 7507 – Harassment and Discrimination and accompanying procedure.

Students should make themselves aware of additional Education, Administration, Safety and other BCIT policies listed at https://www.bcit.ca/about/administration/policies.shtml

Guidelines for School of Business + Media

Attempts:
Students must successfully complete a course within a maximum of three (3) attempts at the course. Students with two attempts in a single course will be allowed to repeat the course only upon special written permission from the Associate Dean. Students who have not successfully completed a course within three attempts may not be eligible to graduate from their respective program.

Attendance:
Regular attendance in lectures and labs is seen as integral to student success, therefore, attendance in class is monitored. Unexcused absences in excess of 10% of the time prescribed for this course may result in the assignment of a failing grade. Attendance may be taken at any time during class. A student not present for attendance will be marked absent. A student who leaves class for a period of time deemed excessive by the instructor may be considered absent regardless of whether they are present when attendance is taken.

In case of illness or other unavoidable absence, students must communicate with the instructor, or the appropriate Program Head, as soon as possible (preferably in advance) indicating the reason for the absence. Students who are seeking accommodation for a medical absence must have a BCIT-approved medical certificate ). For other absences, students must be prepared to provide appropriate supporting documentation.

A student who has unexcused absences in excess of 10% of the time prescribed for the course by the Withdrawal Deadline is considered to have ‘Vanished’ and will be assigned a grade of ‘V’. In these cases, no further work will be graded.

These requirements are set out in accordance with BCIT Policy 5101 Student Regulations. More information regarding withdrawals from PTS courses is available at https://www.bcit.ca/pts/pts_withdrawals.shtml.

Approved

I verify that the content of this course outline is current.
Ed Bosman, Instructor
July 06, 2021

I verify that this course outline has been reviewed.
Juan Azmitia, Program Head
July 16, 2021

I verify that this course outline has been reviewed and complies with BCIT policy.
Phil Ramer, Associate Dean
July 16, 2021

Note: Should changes be required to the content of this course outline, students will be given reasonable notice.