- International Fees
International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Course Overview
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.
Domestic fees
$654.52 - $696.56 See individual course offerings below for actual costs.
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:
- Indicates programs accepting international students.
- Indicates programs with a co-op option.
School of Business + Media
- 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
- Fire Executive Management
BCIT/Industry Partnership Certificate Part-time
- International Trade and Transportation Logistics
Certificate Part-time
- Marketing Management
Certificate Part-time
- Payroll Administration
Certificate Part-time
Course Offerings
Fall 2024
Below are two offerings of BSYS 2051 for the Fall 2024 term.
CRN 49514
Dates
Mon Sep 09 - Tue Nov 26
- 12 weeks
- CRN 49514
- Domestic fees $696.56
Status
In Progress
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
Class meeting times
Instructor
Denise Calvert
Course outline
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- This course is asynchronous and does not require you to meet every week at a specific time, however, there will be specific timelines for assignments and exams. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies, or more of it’s a condensed course, starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date. Please note*** Exams are held in person at the Burnaby campus as follows: Midterm exam: Tues Oct 15 at 1800 and Final exam: Tues Nov 26 at 1800
CRN 35638
Dates
Thu Sep 12 - Thu Nov 28
- 12 weeks
- CRN 35638
- Domestic fees $696.56
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.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 12 - Nov 28 | Thu | 18:30 - 21:30 | Burnaby SE12 Rm. 301 |
Instructor
Lenalda Sutherland
Course outline
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Winter 2025
Below are three offerings of BSYS 2051 for the Winter 2025 term.
CRN 77393
Dates
Mon Jan 06 - Tue Mar 25
- 12 weeks
- CRN 77393
- Domestic fees $696.56
Status
Seats Available
This course offering has seats available.
Class meeting times
Instructor
Denise Calvert
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- The course is paced with weekly assignment deadlines and scheduled dates for the midterm and final exams. 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 email address when registering. Please note both the midterm and the final exams only are ON CAMPUS as follows: Midterm Tues, Feb 11th 1800 and Final exam is on Tues, Mar 25th at 1800 Please note that the lecture component for this course is asynchronous, not requiring you to meet each and every week at a specific time, however, there will be specific timelines for assignments and exams. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies, or more of it’s a condensed course, starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date.
CRN 77580
Dates
Wed Jan 08 - Wed Mar 26
- 12 weeks
- CRN 77580
- Domestic fees $682.27
Status
Seats Available
This course offering has seats available.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Jan 08 - Mar 26 | Wed | 17:30 - 20:30 | Downtown DTC Rm. 374 |
Instructor
Kaitlyn Minatozaki
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
CRN 79495
Dates
Tue Mar 04 - Thu Apr 10
- 6 weeks
- CRN 79495
- Domestic fees $654.52
Status
Seats Available
This course offering has seats available.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Mar 04 - Apr 10 | Tue, Thu | 18:30 - 21:30 | Online |
Instructor
Ed Bosman
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- Internet delivery format.
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
- This is a synchronous online course and you will be expected to be available and online on the posted days and times shown on your registration schedule. It is important you have a stable and consistent internet connection to access course content. Course content, type and quality of assignments, and general standards for this online course are the same as classroom courses. To be successful in this online course, plan to spend 7-10 hours per week on your studies or more if it is a condensed course starting Week 1. Important course information will be sent to your myBCIT account prior to your course start date
Programs and courses are subject to change without notice.