Course details
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.
Credits
3.0
Cost
$641.04 - $691.66 See individual course offerings below for actual costs.
Course offerings
Spring/Summer 2022
Below are two offerings of BSYS 2051 for the Spring/Summer 2022 term.
CRN 60435
Duration
Fri Apr 29 - Fri Jul 22 (12 weeks)
- 12 weeks
- CRN 60435
- $641.04
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Apr 29 - Jul 22 | Fri | 14:30 - 17:20 | Burnaby NE01 Rm. 319 |
Instructor
Lenalda Sutherland
Course outline
Cost
$641.04
Important information
-
Please direct any inquiries to the Program Assistant, Sarah Chanway, at schanway@bcit.ca.
Status
In Progress
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
CRN 59674
Duration
Tue Jun 28 - Thu Aug 04 (6 weeks)
- 6 weeks
- CRN 59674
- $641.04
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Jun 28 - Aug 04 | Tue, Thu | 18:30 - 21:30 | Burnaby SE12 Rm. 324 |
Instructor
Dave Lazenby
Course outline
Cost
$641.04
Status
In Progress and Full
This course offering is in progress and full. Please check this page for other currently available offerings or subscribe to receive email updates.
Fall 2022
Below are five offerings of BSYS 2051 for the Fall 2022 term.
CRN 44216
Duration
Tue Sep 06 - Tue Nov 22 (12 weeks)
- 12 weeks
- CRN 44216
- $642.25
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 06 - Nov 22 | Tue | 17:30 - 20:30 | Downtown DTC Rm. 375 |
Instructor
Nadia Graham
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Cost
$642.25
Important information
-
..
Status
CRN 35638
Duration
Thu Sep 15 - Thu Dec 01 (12 weeks)
- 12 weeks
- CRN 35638
- $655.11
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 15 - Dec 01 | Thu | 18:30 - 21:30 | Burnaby SE12 Rm. 318 |
Instructor
Masoud Jalili
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Cost
$655.11
Important information
-
.
Status
CRN 46245
Duration
Mon Sep 05 - Tue Nov 22 (12 weeks)
- 12 weeks
- CRN 46245
- $691.66
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 05 - Nov 22 | N/A | N/A | Online |
Oct 11 | Tue | 18:00 - 20:00 | Burnaby |
Nov 22 | Tue | 18:00 - 20:00 | Burnaby |
Instructor
TBD
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Cost
$691.66
Important information
-
“This asynchronous course is paced with weekly assignment deadlines. Please note that both the midterm and final exams ONLY will be held in person at the BCIT Burnaby campus. Frequent contributions to asynchronous (not real time) online discussions are recommended to derive full benefit from the course. Students are expected to be familiar with business math concepts as covered in OPMT 1110 Business Mathematics, or an equivalent course. Students must submit e-mail address when registering. This course is offered with the expectation that students have access to a computer with Microsoft Windows Operation System.
Status
Cancelled
This course offering has been cancelled. Please check this page for other currently available offerings or subscribe to receive email updates.
CRN 46249
Duration
Mon Sep 05 - Thu Nov 24 (12 weeks)
- 12 weeks
- CRN 46249
- $691.66
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Sep 05 - Nov 24 | N/A | N/A | Online |
Oct 13 | N/A | 18:00 - 20:00 | Burnaby |
Nov 24 | N/A | 18:00 - 20:00 | Burnaby |
Instructor
TBD
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Cost
$691.66
Important information
-
This is an asynchronous course that will be held entirely online except for the midterm and the final exams which are held in person at the BCIT Burnaby campus on both October 13 and Nov 24th. Frequent contributions to asynchronous (not real time) online discussions are recommended to derive full benefit from the course. Students are expected to be familiar with business math concepts as covered in OPMT 1110 Business Mathematics, or an equivalent course. Students must submit e-mail address when registering. This course is offered with the expectation that students have access to a computer with Microsoft Windows Operation System.
Status
Cancelled
This course offering has been cancelled. Please check this page for other currently available offerings or subscribe to receive email updates.
CRN 47615
Duration
Tue Oct 25 - Thu Dec 01 (6 weeks)
- 6 weeks
- CRN 47615
- $653.93
Class meeting times
Dates | Days | Times | Locations |
---|---|---|---|
Oct 25 - Dec 01 | N/A | N/A | Online |
Instructor
TBD
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Cost
$653.93
Important information
- Internet delivery format.
-
***Please note this is a compressed courses so it is FAST paced and not suitable for all students *** Important Information: 1. Internet delivery synchronous course format. This is a synchronous course that will be held entirely online. You will be required to log in to the course each week at a specific time. Please check the registration page for the specific dates and times. 2. Learning formats include: online asynchronous, online synchronous, hybrid/blended, and in-class. Please read the information at this link to understand the differences between learning online versus in a real physical classroom. www.bcit.ca/distance/distance-course-formats/ 3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
Status
Cancelled
This course offering has been cancelled. Please check this page for other currently available offerings or subscribe to receive email updates.
Learning Outcomes
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.
Effective as of Winter 2021
Related Programs
Introduction to Business Data Analytics with MS Excel-MS 365 for Windows (BSYS 2051) is offered as a part of the following programs:
School of Business + Media
- Accounting
Diploma Part-time
- Advanced Business Management
Certificate Part-time
- Advanced Human Resource Management
Certificate Part-time
- Advanced Marketing Management
Certificate Part-time
- Business Administration (General Option)
Diploma Part-time
- Business Administration (Global Studies Option)
Diploma Part-time
- Business Administration (Human Resources Option)
Diploma Part-time
- Business Administration (Management Option)
Diploma Part-time
- Business Administration (Marketing Option)
Diploma Part-time
- Computerized Accounting
Associate Certificate Part-time
- Finance
Diploma Part-time
- Financial Management (Finance Option)
Certificate Part-time
- Financial Management (Professional Accounting Option)
Certificate Part-time
- Financial Planning
Diploma Part-time
- Fire Executive Management
BCIT/Industry Partnership Certificate Part-time/Distance & Online Learning
- International Trade and Transportation Logistics
Certificate Part-time
- Marketing Management
Certificate Part-time
- Operations Management (Facilities Management Option)
Certificate Part-time
- Operations Management (Industrial Engineering Option)
Certificate Part-time
- Operations Management (Management Engineering Option)
Certificate Part-time
- Operations Management (Materials Management Option)
Certificate Part-time
Subscribe
Interested in being notified about future offerings of Introduction to Business Data Analytics with MS Excel-MS 365 for Windows (BSYS 2051)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.
Programs and courses are subject to change without notice.