British Columbia Institute of Technologywww.bcit.ca/study/courses/bsys2051

Important Notice: COVID-19 Institute response

BCIT

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

Business Systems Part-time Studies Course

School of Business + Media

BCIT is planning for a substantial return to on-campus activity for the fall 2021 term as informed by BC Public Health Officer guidelines. Refer to each course listing for details.

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)

BSYS 1001

Credits

3.0

Cost

$629.61 - $641.04 See individual course offerings below for actual costs.

Fall 2021

Below are five offerings of this course for the Fall 2021 term.

CRN 47615

Tue Oct 26 - Fri Dec 03 6 Weeks

Class Meeting Times

Dates Days Times Locations
Oct 26 - Dec 03 Tue/Thu 18:00 - 21:00 Online

Instructor

Ed Bosman

Course Outline

Cost

$641.04

Notes

  1. Internet delivery format.
  2. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

1 seat remaining as of Sep 16, 2021 11:42 am (PDT). Availability may change at any time.

CRN 44216

Tue Sep 07 - Tue Nov 23 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 07 - Nov 23 Tue 17:30 - 20:30 DTC DTC Rm. 875

Instructor

Nadia Graham

Course Outline

Cost

$629.61

Notes

  1. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.

In Progress

CRN 35638

Thu Sep 09 - Thu Dec 09 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 09 - Dec 09 Thu 18:30 - 21:30 BBY SE12 Rm. 318

Instructor

Masoud Jalili

Course Outline

Cost

$641.04

Notes

  1. No class on November 11. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
  2. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

This course offering is in progress and full. Please check this page for other currently available offerings or subscribe to receive email updates.

In Progress and Full

CRN 46245

Mon Sep 13 - Mon Dec 06 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 13 - Dec 06 Online
Oct 12 Tue 18:00 - 21:00 Distance SE12 Rm. 322
Nov 30 Tue 18:00 - 21:00 Distance SE12 Rm. 322

Instructor

Denise Calvert

Course Outline

Cost

$640.04

Notes

  1. Internet delivery format.
  2. “The course is paced with weekly assignment deadlines and the exams will be held at the BCIT Burnaby campus scheduled as follows: 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. Midterm Exam Tuesday , October 12th at 1800 Final Exam Tuesday, November 30 at 1800 No class on November 11. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.

In Progress

CRN 46249

Mon Sep 13 - Tue Nov 30 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 13 - Nov 29 Online
Oct 12 Tue 18:30 - 21:30 Distance SE12 Rm. 321
Nov 30 Tue 18:30 - 21:30 Distance SE12 Rm. 321

Instructor

Denise Calvert

Course Outline

Cost

$640.04

Notes

  1. Internet delivery format.
  2. The course is paced with weekly assignment deadlines and 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 e-mail address when registering. This course is offered with the expectation that students have access to a computer with Microsoft Windows Operation System. Midterm Exam Tuesday, October 12 1800 Final Exam Tuesday, November 30 1800 No class on October 11. All BSYS computer courses/classes conducted on campus will be done in a regular classroom and students must bring their own device to class. See details at: https://www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

This course offering is in progress and full. Please check this page for other currently available offerings or subscribe to receive email updates.

In Progress and Full

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

BSYS 2051 is offered as a part of the following programs:

School of Business + Media

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

Subscribe

Interested in being notified about future offerings of BSYS 2051 - Introduction to Business Data Analytics with MS Excel 2019 for Windows? 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 related to 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.

Programs and courses are subject to change without notice.

Find Courses

School of Business + Media Waitlist

Need to waitlist for a School of Business + Media course?

Find out more

English Language Proficiency

BCIT's Part-time Studies English Language Proficiency Standard is English 12 (or equivalency). Students who do not meet this requirement should upgrade their English skills prior to any future registration.

Payment Changes At BCIT

We've changed the way we accept payments.

Find out more

Course Navigation, Related Links & Tools

Registration News

Registration is now open for the Fall 2021 term.

Classroom Locations

Classroom locations are subject to last minute changes. Please check the Part-time Studies Classroom Locations listing at www.bcit.ca/rooms on the first day of any course you are registered for.

Part-time Studies Financial Aid

Will you be studying at BCIT part-time? Do you need assistance funding your studies? Find out if you qualify for Part-time Studies financial aid.

© BCIT