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.
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
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Status
This course offering is in progress and full. Please check this page for other currently available offerings or subscribe to receive email updates.
“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
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Status
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
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
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Status
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:
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.
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.