Skip to main content

Introduction to Business Data Analytics with MS Excel-MS 365 for Windows BSYS 2051

Business Systems Course

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.

Prerequisite(s)

Credits

3.0

Cost

$629.50 - $670.36 See individual course offerings below for actual costs.

Course offerings

Spring/Summer 2023

Below are five offerings of BSYS 2051 for the Spring/Summer 2023 term.

CRN 59674

Duration

Tue Jul 11 - Thu Aug 17 (6 weeks)

  • 6 weeks
  • CRN 59674
  • $655.11
Class meeting times
Dates Days Times Locations
Jul 11 - Aug 17 Tue, Thu 18:30 - 21:30 Burnaby SE12 Rm. 324
Instructor

Fernando Garrido Ruiz-tagle

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$655.11

Status

Seats Available

5 seats remaining as of Thu June 1, 2023 at 1:02 pm (PDT). Availability may change at any time.

CRN 58573

Duration

Mon Apr 03 - Tue Jun 20 (12 weeks)

  • 12 weeks
  • CRN 58573
  • $655.11
Class meeting times
Dates Days Times Locations
Apr 03 - Jun 20 N/A N/A Online
May 09 Tue 18:30 - 21:30 Burnaby SE12 Rm. 321
May 11 Thu 18:30 - 21:30 Burnaby SE12 Rm. 321
Jun 20 Tue 18:30 - 20:30 Burnaby SE12 Rm. 321
Instructor

Denise Calvert

Course outline

View

Cost

$655.11

Important information
  1. The course is paced with weekly assignment deadlines and scheduled dates for the midterm and final exams. Please note that the exams are written in person on campus. Midterm exam is Tuesday, May 9th 1830-2030 and Final exam is Tuesday June 20 1830-2030 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.
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 66183

Duration

Mon Apr 03 - Thu Jun 22 (12 weeks)

  • 12 weeks
  • CRN 66183
  • $655.11
Class meeting times
Dates Days Times Locations
Apr 03 - Jun 22 N/A N/A Online
May 11 Thu 18:30 - 20:30 Burnaby
Jun 22 Thu 18:30 - 20:30 Burnaby
Instructor

TBD

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$655.11

Important information
  1. The course is paced with weekly assignment deadlines and scheduled dates for the midterm and final exams. Please note that the exams are written in person on campus, Thurs May 11 1830-203 and Thurs Jun 22 1830-2030 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.
Status

Cancelled

This course offering has been cancelled. Please check this page for other currently available offerings or subscribe to receive email updates.

CRN 57661

Duration

Wed Apr 05 - Wed Jun 21 (12 weeks)

  • 12 weeks
  • CRN 57661
  • $642.25
Class meeting times
Dates Days Times Locations
Apr 05 - Jun 21 Wed 17:30 - 20:30 Downtown DTC Rm. 374
Instructor

Carlos Diaz Teran Salvador

Course outline

View

Cost

$642.25

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 60435

Duration

Fri Apr 28 - Fri Jul 14 (12 weeks)

  • 12 weeks
  • CRN 60435
  • $655.11
Class meeting times
Dates Days Times Locations
Apr 28 - Jul 14 Fri 14:30 - 17:20 Burnaby SE12 Rm. 301
Instructor

Carlos Diaz Teran Salvador

Course outline

View

Cost

$655.11

Important information
  1. Please send any inquiries regarding this section to bfun@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.

Fall 2023

Below are four offerings of BSYS 2051 for the Fall 2023 term.

CRN 49514

Duration

Mon Sep 11 - Tue Nov 28 (12 weeks)

  • 12 weeks
  • CRN 49514
  • $670.36
Class meeting times
Dates Days Times Locations
Sep 11 - Nov 28 N/A N/A Online
Oct 17 Tue 18:00 - 20:00 Burnaby
Nov 28 Tue 18:00 - 20:00 Burnaby
Instructor

Denise Calvert

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$670.36

Important information
  1. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  2. 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 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

CRN 44216

Duration

Tue Sep 12 - Tue Nov 28 (12 weeks)

  • 12 weeks
  • CRN 44216
  • $656.61
Class meeting times
Dates Days Times Locations
Sep 12 - Nov 28 Tue 17:30 - 20:30 Downtown DTC Rm. 375
Instructor

Carlos Diaz Teran Salvador

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$656.61

Status

CRN 35638

Duration

Thu Sep 14 - Thu Nov 30 (12 weeks)

  • 12 weeks
  • CRN 35638
  • $670.36
Class meeting times
Dates Days Times Locations
Sep 14 - Nov 30 Thu 18:30 - 21:30 Burnaby
Instructor

Masoud Jalili

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$670.36

Important information
  1. .
Status

CRN 49517

Duration

Tue Oct 24 - Tue Nov 28 (6 weeks)

  • 6 weeks
  • CRN 49517
  • $629.50
Class meeting times
Dates Days Times Locations
Oct 24 - Nov 28 N/A N/A Online
Instructor

Ed Bosman

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$629.50

Important information
  1. Internet delivery format.
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
  3. ***Please note this is a compressed course so it is FAST paced and not suitable for all students*** This course is asynchronous, and does not require 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.
Status

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

  1. Accounting
    Diploma Part-time
  2. Advanced Business Management
    Certificate Part-time
  3. Advanced Human Resource Management
    Certificate Part-time
  4. Advanced Marketing Management
    Certificate Part-time
  5. Business Administration (General Option)
    Diploma Part-time
  6. Business Administration (Global Studies Option)
    Diploma Part-time
  7. Business Administration (Human Resources Option)
    Diploma Part-time
  8. Business Administration (Management Option)
    Diploma Part-time
  9. Business Administration (Marketing Option)
    Diploma Part-time
  10. Computerized Accounting
    Associate Certificate Part-time
  11. Finance
    Diploma Part-time
  12. Financial Management (Finance Option)
    Certificate Part-time
  13. Financial Management (Professional Accounting Option)
    Certificate Part-time
  14. Financial Planning
    Diploma Part-time
  15. Fire Executive Management
    BCIT/Industry Partnership Certificate Part-time
  16. International Trade and Transportation Logistics
    Certificate Part-time
  17. Marketing Management
    Certificate Part-time
  18. Operations Management (Facilities Management Option)
    Certificate Part-time
  19. Operations Management (Industrial Engineering Option)
    Certificate Part-time
  20. Operations Management (Management Engineering Option)
    Certificate Part-time
  21. 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.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.