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
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.
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.
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 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 24 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.
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.
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.
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.
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.
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.
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.
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 full. Please check this page for other currently available offerings or subscribe to receive email updates.
Full
Spring/Summer 2021
Below are six offerings of this course for the Spring/Summer 2021 term.
1. Internet delivery format 2. The course is paced with weekly assignment deadlines and scheduled dates for the midterm and final exams. 3. Midterm exam is on Thursday,May 20th at 1800. Final exam is on Thursday June 24th at 1800. 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. No class on May 24
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Status
A portion of seats are temporarily held for domestic students.
International students: this may impact your ability to register.
Learn why.
}
Status
2 seats remaining as of Feb 25, 2021 11:37 pm (PST). Availability may change at any time.
1. Internet delivery format 2. The course is paced with weekly assignment deadlines and scheduled dates for the midterm and final exams. 3. Midterm exam is on Thursday,May 20th at 1800. Final exam is on Thursday June 24th at 1800. 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. No class on May 24
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Status
A portion of seats are temporarily held for domestic students.
International students: this may impact your ability to register.
Learn why.
}
Status
18 seats available as of Feb 25, 2021 11:37 pm (PST). Of these 18, 13 are currently reserved for domestic students only. Availability may change at any time.
Please direct any inquiries to the Program Assistant, Sarah Chanway, at schanway@bcit.ca.
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Status
A portion of seats are temporarily held for domestic students.
International students: this may impact your ability to register.
Learn why.
}
Status
7 seats available as of Feb 25, 2021 11:37 pm (PST). These seats are currently reserved for domestic students only. Availability may change at any time.
Important course information will be sent to you prior to your course start
date. Check your myBCIT email account to
access this information.
Status
A portion of seats are temporarily held for domestic students.
International students: this may impact your ability to register.
Learn why.
}
Status
5 seats available as of Feb 25, 2021 11:37 pm (PST). Of these 5, 2 are currently reserved for domestic students only. Availability may change at any time.
1. Due to the condensed nature of this course, students must attend the first day of class. Failure to do so may result in failure of the course. 2.Students must bring their own laptop for this course. Course is being put on by the Whistler Learning Centre. Please contact sonia_dhaliwal116@bcit.ca with questions. 3. Pre-reading will be assigned 1 week prior to start date
Status
This course offering has been cancelled. Please check this page for other currently available offerings or subscribe to receive email updates.
Cancelled
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:
Books for Winter 2021 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
Spring/Summer 2021
No information on books is currently available for Spring/Summer 2021 offerings of this course.
Subscribe
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.
Registration is now open for the Spring/Summer 2021 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.