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

Important Notice: Transit operators' strike - BCIT resources and impact

BCIT

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

Business Systems Part-time Studies Course

School of Business

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

$594.34 - $625.57 See individual course offerings below for actual costs.

Fall 2019

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

CRN 36383

Mon Sep 09 - Sat Nov 30 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 09 - Nov 30 Online
Oct 17 Thu 18:00 - 21:00 Online SE06 Rm. 107
Nov 28 Thu 18:00 - 21:00 Online SE06 Rm. 103

Instructor

Denise Calvert

Course Outline

Cost

$602.91

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: Midterm exam October 17th 1800-2100 Room TBA Final exam November 28th 1800-2100 Room TBA 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.

This course offering is in progress and full. Please check back next term or subscribe to receive email updates.

In Progress and Full

CRN 46245

Mon Sep 09 - Sat Nov 30 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 09 - Nov 30 Online
Oct 18 Fri 18:00 - 21:00 Online SE06 Rm. 105
Nov 29 Fri 18:00 - 21:00 Online SE06 Rm. 230

Instructor

Denise Calvert

Course Outline

Cost

$602.91

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: Midterm exam October 18th 1800-2100 Room TBA Final exam November 29th 1800-2100 Room TBA 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.

This course offering is in progress. Please check back next term or subscribe to receive email updates.

In Progress

CRN 46249

Mon Sep 09 - Fri Nov 29 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 09 - Nov 29 Online
Oct 18 Fri 18:00 - 21:00 Online SE06 Rm. 106
Nov 29 Fri 18:00 - 21:00 Online SE06 Rm. 102

Instructor

Denise Calvert

Course Outline

Cost

$602.91

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: Midterm exam October 18th 1800-2100 Room TBA Final exam November 29th 1800-2100 Room TBA 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.

This course offering is in progress. Please check back next term or subscribe to receive email updates.

In Progress

CRN 44216

Tue Sep 10 - Tue Nov 26 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 10 - Nov 26 Tue 17:30 - 20:30 DTC Rm. 475

Instructor

Nadia Graham

Course Outline

Cost

$594.34

This course offering is in progress and full. Please check back next term or subscribe to receive email updates.

In Progress and Full

CRN 35638

Thu Sep 12 - Thu Nov 28 12 Weeks

Class Meeting Times

Dates Days Times Locations
Sep 12 - Nov 28 Thu 18:30 - 21:30 BBY SW03 Rm. 3655

Instructor

Masoud Jalili

Course Outline

Cost

$602.91

This course offering is in progress and full. Please check back next term or subscribe to receive email updates.

In Progress and Full

CRN 35446

Mon Dec 09 - Fri Dec 13 5 Days

Class Meeting Times

Dates Days Times Locations
Dec 09 - Dec 13 Mon - Fri 09:00 - 17:00 BBY SE06 Rm. 106

Instructor

Ed Bosman

Course Outline

Cost

$602.91

This course offering is full. Please check back next term or subscribe to receive email updates.

Full

Winter 2020

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

CRN 86661

Sat Jan 04 - Thu Mar 26 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 04 - Mar 26 Online
Feb 10 Mon 18:00 - 21:00 Online SE12 Rm. 318
Mar 24 Tue 18:00 - 21:00 Online SE12 Rm. 318

Instructor

Denise Calvert

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$625.57

Notes

  1. Internet delivery format.
  2. The course is paced with weekly assignment deadlines and scheduled dates for the midterm and final exams. Midterm and final exams are written 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 OPMT1110 Business Mathematics, or an equivalent course. Students must submit e-mail address when registering. Exam dates: Midterm exam is Monday, Feb 10 1800 - 2100 and Final exam is Tuesday, March 24 1800-2100.

This course offering is full. Please check back next term or subscribe to receive email updates.

Full

CRN 77393

Mon Jan 06 - Sat Mar 28 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 06 - Mar 28 Online
Feb 12 Wed 18:00 - 21:00 Online SE12 Rm. 322
Mar 25 Wed 18:00 - 21:00 Online SE12 Rm. 322

Instructor

Denise Calvert

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$625.57

Notes

  1. The course is paced with weekly assignment deadlines and scheduled dates for the midterm and final exams. Midterm and final exams are written 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 email address when registering. Exam dates: Midterm Wed, Feb 12 1800-2100, Final Exam Wed, Mar 25 1800-2100

This course offering is full. Please check back next term or subscribe to receive email updates.

Full

CRN 77580

Wed Jan 08 - Wed Mar 25 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 08 - Mar 25 Wed 17:30 - 20:30 DTC Rm. 360

Instructor

Reza Bafandeh

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$617.00

This course offering is full. Please check back next term or subscribe to receive email updates.

Full

CRN 77581

Thu Jan 09 - Thu Mar 26 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 09 - Mar 26 Thu 18:30 - 21:30 BBY SE06 Rm. 230

Instructor

Ben Whitney

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$625.57

This course offering is full. Please check back next term or subscribe to receive email updates.

Full

CRN 78412

Fri Jan 10 - Fri Mar 27 12 Weeks

Class Meeting Times

Dates Days Times Locations
Jan 10 - Mar 27 Fri 18:30 - 21:30 BBY SE06 Rm. 104

Instructor

Ben Whitney

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$625.57

Notes

  1. .

This course offering is full. Please check back next term or subscribe to receive email updates.

Full

CRN 79495

Mon Mar 09 - Fri Mar 13 5 Days

Class Meeting Times

Dates Days Times Locations
Mar 09 - Mar 13 Mon - Fri 09:00 - 17:00 BBY SE06 Rm. 102

Instructor

Ed Bosman

Course Outline

TBD – see Learning Outcomes in the interim

Cost

$625.57

Notes

  1. This is a one week long fast-paced course and it is not suitable for all students

This course offering is full. Please check back next term or subscribe to receive email updates.

Full

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

Programs and courses are subject to change without notice.

Find Courses

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 Winter 2020 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