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

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 - $612.04 See individual course offerings below for actual costs.

Spring/Summer 2019

Below are three offerings of this course for the Spring/Summer 2019 term.

CRN 60435

Fri May 03 - Fri Jul 19 12 Weeks

Class Meeting Times

Dates Days Times Locations
May 03 - Jul 19 Fri 13:30 - 16:20 BBY SE12 Rm. 318

Instructor

Dave Lazenby

Course Outline

Cost

$612.04

Notes

  1. Departmental approval needed
  2. This section of the course requires DEPARTMENTAL APPROVAL to enter, because it is run concurrently with the Business Fundamentals (BFUN) Program. Priority is given to students who have joined the program: https://www.bcit.ca/study/programs/7985acert, but we anticipate some seats will be released for general enrolment If the program is not showing “full”, then there are seats available for general registration. If you wish to enter this course, please email the Program Assistant, Sarah Chanway at schanway@bcit.ca with your name, student ID number and the CRN of the course that you would like to register in. Registration will not be permitted without proof of a minimum English level of IELTS 6.0 (or equivalent). For details on English requirements, please see https://www.bcit.ca/admission/english.shtml. The prerequisite course, MKTG 2203, must also be complete prior to registration.

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

In Progress and Full

CRN 59674

Tue Jul 02 - Thu Aug 08 6 Weeks

Class Meeting Times

Dates Days Times Locations
Jul 02 - Aug 08 Tue/Thu 18:30 - 21:30 BBY SE06 Rm. 103

Instructor

Dave Lazenby

Course Outline

Cost

$612.04

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

In Progress

CRN 59673

Mon Aug 12 - Fri Aug 16 5 Days

Class Meeting Times

Dates Days Times Locations
Aug 12 - Aug 16 Mon - Fri 09:00 - 16:30 BBY SE06 Rm. 102

Instructor

Ed Bosman

Course Outline

Cost

$612.04

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

Full

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 full. Please check back next term or subscribe to receive email updates.

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 full. Please check back next term or subscribe to receive email updates.

Full

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 full. Please check back next term or subscribe to receive email updates.

Full

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

TBD – see Learning Outcomes in the interim

Cost

$594.34

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

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 full. Please check back next term or subscribe to receive email updates.

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

TBD – see Learning Outcomes in the interim

Cost

$602.91

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

Related Programs

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

School of Business

  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. Business Management
    Part-time   Certificate
  11. Computerized Accounting
    Part-time   Associate Certificate
  12. Finance
    Part-time   Diploma
  13. Financial Management (Finance Option)
    Part-time   Certificate
  14. Financial Management (Professional Accounting Option)
    Part-time   Certificate
  15. Financial Planning
    Part-time   Diploma
  16. Fire Executive Management
    Part-time/Distance & Online Learning   BCIT/Industry Partnership Certificate
  17. International Trade and Transportation Logistics
    Part-time   Certificate
  18. Marketing Management
    Part-time   Certificate
  19. Marketing Management (Tourism Management Option)
    Part-time   Certificate
  20. Operations Management (Facilities Management Option)
    Part-time   Certificate
  21. Operations Management (Industrial Engineering Option)
    Part-time   Certificate
  22. Operations Management (Management Engineering Option)
    Part-time   Certificate
  23. 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.

Spring/Summer 2019

Books for Spring/Summer 2019 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.

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: Myitlab W Pearson Etext-Exploring Ms Office 2016
Author Poatsy
Publisher Ph
Binding Digital Version
ISBN 978-0-13445-587-7
Price $98.00
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.

Np Ms Office 365 & Excel 2016: Comp, 1St Edition
Author Parsons
Copyright 2017
Binding Paperback
ISBN 978-1-30588-040-5
Price $104.95
Required

Fall 2019

No information on books is currently available for Fall 2019 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

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 2019 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