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 2016 for Windows

Business Systems Part-time Studies Course

School of Business + Media

To support you and your education, BCIT is adapting applied learning in formats appropriate to the unfolding global situation. All PTS classes are being delivered in an online format unless you are notified otherwise.

Course Details

Every enterprise requires business analytics and decision support systems (DSS) in order to develop a competitive advantage. This is an introductory course using MS Excel for Windows, the foundational data analysis tool, to build on the skills and concepts covered in basic computer application courses. This course covers advanced Excel formulas, concepts, and applications using larger and more professional worksheets and focusses on the data modeling approach using Excel vs. the calculator approach. Topics include if-then modeling, built-in functions, charts, transferring data across applications, and using the built-in tools such as PivotTables, Sparklines, Slicers, and PowerPivots.

Prerequisite(s)

BSYS 1001

Credits

3.0

Cost

$617.60 - $627.60 See individual course offerings below for actual costs.

Fall 2020

Below are six offerings of this course for the Fall 2020 term.

CRN 44216

Tue Sep 08 - Tue Nov 24 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 08 - Nov 24 Tue 17:30 - 20:30 DTC Online Delivery

Instructor

Nadia Graham

Course Outline

Cost

$617.60

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 35638

Thu Sep 10 - Thu Nov 26 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 10 - Nov 26 Thu 18:30 - 21:30 BBY Online Delivery

Instructor

Masoud Jalili

Course Outline

Cost

$627.60

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 14 - Mon Nov 30 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 14 - Nov 30 Online Online Delivery

Instructor

Denise Calvert

Course Outline

Cost

$627.60

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 : Wednesday, October 21 at 1800 Final exam : Wednesday, Dec 2 at 1800

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 14 - Mon Nov 30 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 14 - Nov 30 Online Online Delivery

Instructor

Denise Calvert

Course Outline

Cost

$627.60

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 : Wednesday, October 21 at 1800 Final exam : Wednesday, Dec 2 at 1800

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 47615

Tue Oct 27 - Fri Dec 04 6 Weeks

Class Meeting Times

Dates Days Times Locations
Oct 27 - Dec 04 Tue/Fri 18:00 - 21:00 BBY Online Delivery

Instructor

Ed Bosman

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$627.60

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

Full

CRN 35446

Mon Dec 07 - Fri Dec 11 5 Days

Class Meeting Times

Dates Days Times Locations
Dec 07 - Dec 11 Mon - Fri 09:00 - 17:00 BBY Online Delivery

Instructor

TBD

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$627.60

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

Cancelled

Winter 2021

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

CRN 86661

Sat Jan 02 - Thu Mar 25 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 02 - Mar 25 Online Delivery
See Notes below
Feb 10 Wed 18:00 - 21:00 Online Delivery
See Notes below
Mar 24 Wed 18:00 - 21:00 Online Delivery
See Notes below

Instructor

Denise Calvert

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$625.77

Notes

  1. Internet delivery format.
  2. 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 OPMT1110 Business Mathematics, or an equivalent course. Students must submit e-mail address when registering. Exam dates: Midterm exam is Wednesday February 10 at 1800 and final exam is on Wednesday, March 22 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.
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

This section is only available for registration starting Wed, Oct 28 at 9:00 am (PDT)

Sneak Preview

CRN 77393

Mon Jan 04 - Sat Mar 27 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 04 - Mar 27 Online Delivery
See Notes below
Feb 10 Wed 18:00 - 21:00 Online Delivery
See Notes below
Mar 24 Wed 18:00 - 21:00 Online Delivery
See Notes below

Instructor

Denise Calvert

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$625.77

Notes

  1. Internet delivery format.
  2. 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. Exam dates: Midterm Wed, Feb 10 at 1800 and the Final exam is on Wednesday March 22 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.
  3. Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

This section is only available for registration starting Wed, Oct 28 at 9:00 am (PDT)

Sneak Preview

CRN 77580

Wed Jan 06 - Wed Mar 24 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 06 - Mar 24 Wed 17:30 - 20:30 Online Delivery
See Notes below

Instructor

TBD

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$617.60

Notes

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

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

This section is only available for registration starting Wed, Oct 28 at 9:00 am (PDT)

Sneak Preview

CRN 77581

Thu Jan 07 - Thu Mar 25 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 07 - Mar 25 Thu 18:30 - 21:30 Online Delivery
See Notes below

Instructor

Ben Whitney

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$627.60

Notes

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

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

This section is only available for registration starting Wed, Oct 28 at 9:00 am (PDT)

Sneak Preview

CRN 79495

Tue Mar 02 - Thu Apr 08 6 Weeks

Class Meeting Times

Dates Days Times Locations
Mar 02 - Apr 08 Tue/Thu 18:00 - 21:00 Online Delivery
See Notes below

Instructor

Ed Bosman

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$627.60

Notes

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

A portion of seats are temporarily held for domestic students. International students: this may impact your ability to register. Learn why.

}

This section is only available for registration starting Wed, Oct 28 at 9:00 am (PDT)

Sneak Preview

Learning Outcomes

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.
  • Summarize data using statistical functions.
  • Employ built-in tools in Excel 2016.
  • Analyze business data using analytics.

Effective as of Fall 2016

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

Books & Supplies

The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.

Fall 2020

Books for Fall 2020 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.

BCIT Downtown Campus Bookstore

If you are taking this course at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Downtown Campus Bookstore.

Image not available
Cei Digital: Np On Ms Office 365 & Excel 2019, Comprehensive
Author Carey
Copyright 2020
Binding Digital Version
ISBN 978-0-35739-264-5
Price $72.50
Choose One

Image not available
New Perspectives On Microsoft 365 & Excel 2019 Comprehensive
Author Carey
Publisher Cengage
Copyright 2020
Binding Paperback
ISBN 978-0-35702-576-5
Price $104.95
Choose One

BCIT Distance & Online Learning Bookstore

If you are taking this course through either Distance Education or Online Learning, please purchase books for this course at the BCIT Distance & Online Learning Bookstore.

Image not available
Cei Digital: Mylab It W Etext For Exploring Ms Office 2019
Author Poatsy
Publisher Ph
Copyright 2019
Binding Digital Version
ISBN 978-0-13540-246-7
Price $103.50
Required

BCIT Burnaby Bookstore

If you are taking this course, but are not taking it through either Distance Education or Online Learning, nor at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Burnaby Bookstore.

Image not available
Cei Digital: Np On Ms Office 365 & Excel 2019, Comprehensive
Author Carey
Copyright 2020
Binding Digital Version
ISBN 978-0-35739-264-5
Price $72.50
Choose One

Image not available
New Perspectives On Microsoft 365 & Excel 2019 Comprehensive
Author Carey
Publisher Cengage
Copyright 2020
Binding Paperback
ISBN 978-0-35702-576-5
Price $104.95
Choose One

Winter 2021

No information on books is currently available for Winter 2021 offerings of this course.

Subscribe

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

Contact Information

Suggest course days and times

If you are interested in taking this course on-campus (classroom delivery only) and would like to see it offered on specific days and/or at specific times, please indicate your preferences below. Day and time suggestions are not applicable to online courses.

The personal information on this form is collected under the authority of the College and Institute Act (RSBC 1996, Ch.52). BCIT will use this information to communicate with you regarding relevant BCIT programs, courses and services. This information is only used by authorized BCIT staff. Email communication sent to and from BCIT is routed through the United States of America. If you have any questions about BCIT's collection and use of this information, please contact BCIT’s manager of Information Access and Privacy.

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 currently open for the Fall 2020 term.

A sneak preview of Winter 2021 term courses is also now available here.

Students may register for Winter 2021 term courses online or by phone starting Wed, Oct 28 at 9:00 am (PDT).

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