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

$616.36 - $655.11 See individual course offerings below for actual costs.

Course offerings

Winter 2023

Below are five offerings of BSYS 2051 for the Winter 2023 term.

CRN 77393

Duration

Mon Jan 09 - Tue Mar 28 (12 weeks)

  • 12 weeks
  • CRN 77393
  • $655.11
Class meeting times
Dates Days Times Locations
Jan 09 - Mar 28 N/A N/A Online
Feb 14 Tue 18:00 - 20:00 Burnaby
Mar 28 Tue 18:00 - 20:00 Burnaby
Instructor

Denise Calvert

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. 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. Please note both the midterm and the final exams only are ON CAMPUS as follows: Midterm Tues, Feb 14th1800 and Final exam is on Tuesday, 28 March 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.
Status

CRN 86661

Duration

Mon Jan 09 - Thu Mar 30 (12 weeks)

  • 12 weeks
  • CRN 86661
  • $655.11
Class meeting times
Dates Days Times Locations
Jan 09 - Mar 30 N/A N/A Online
Feb 16 Thu 18:00 - 20:00 Burnaby
Mar 30 Thu 18:00 - 20:00 Burnaby
Instructor

Denise Calvert

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$655.11

Important information
  1. 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. Both the midterm and the final exams ONLY are on campus as follows: Midterm: Thurs February 16 at 1800-2000 and Final exam, Thurs March 30 1800-2000 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.
Status

CRN 77580

Duration

Wed Jan 11 - Wed Mar 29 (12 weeks)

  • 12 weeks
  • CRN 77580
  • $642.25
Class meeting times
Dates Days Times Locations
Jan 11 - Mar 29 Wed 17:30 - 20:30 Downtown DTC Rm. 875
Instructor

Carlos Diaz Teran Salvador

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$642.25

Important information
  1. Important course information will be sent to your myBCIT account prior to your course start date.
Status

CRN 77581

Duration

Thu Jan 12 - Thu Mar 30 (12 weeks)

  • 12 weeks
  • CRN 77581
  • $655.11
Class meeting times
Dates Days Times Locations
Jan 12 - Mar 30 Thu 18:30 - 21:30 Burnaby SE06 Rm. 107
Instructor

Ben Whitney

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$655.11

Status

CRN 79495

Duration

Tue Mar 07 - Thu Apr 13 (6 weeks)

  • 6 weeks
  • CRN 79495
  • $616.36
Class meeting times
Dates Days Times Locations
Mar 07 - Apr 13 Tue, Thu 18:30 - 21:30 Online
Instructor

Ed Bosman

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Cost

$616.36

Important information
  1. Internet delivery format.
  2. You have registered for a course that will be held entirely online, however this is a synchronous course which requires you to be online on the posted days and times shown on your myBCIT schedule. In this course, you will be using an online teaching tool called the Learning Hub, also known as D2L or Brightspace. The Learning Hub is where your instructor will share information, resources, assignments, deadlines and this is where you will submit your work, and communicate with both your instructor and classmates. Ensure that you are able to log in before your course starts.
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.