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)
Credits
3.0
Cost
$604.90 - $612.04 See individual course offerings below for actual costs.
Winter 2019
Below are seven offerings of this course for the Winter 2019 term.
CRN 86661
Duration
Sat Jan 05 - Sat Mar 23 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jan 05 - Mar 23 | Online | ||
| Feb 09 | Sat | 10:00 - 13:00 | Online SE12 Rm. 318 |
| Mar 23 | Sat | 10:00 - 13:00 | Online SE12 Rm. 318 |
Instructor
Denise Calvert
Course Outline
Cost
$612.04
Notes
- Internet delivery format.
- 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 Saturday, February 9th at 10:00 am and FINAL exam is Saturday, March 23rd at 10:00 am.
Status
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
In Progress
CRN 77393
Duration
Mon Jan 07 - Sat Mar 30 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jan 07 - Mar 30 | Online |
Instructor
Denise Calvert
Course Outline
Cost
$612.04
Notes
- 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 exam is Monday, February 11 at 1800 FINAL exam is Monday, March 25th at 1800
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
CRN 73979
Duration
Tue Jan 08 - Tue Mar 26 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jan 08 | Tue | 18:30 - 21:30 | BBY |
| Jan 08 - Mar 26 | Online | ||
| Jan 22 | Tue | 18:30 - 21:30 | BBY |
| Feb 12 | Tue | 18:30 - 21:30 | BBY |
| Mar 05 | Tue | 18:30 - 21:30 | BBY |
| Mar 19 | Tue | 18:30 - 21:30 | BBY |
| Mar 26 | Tue | 18:30 - 21:30 | BBY |
Instructor
TBD
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$612.04
Notes
- This is a hybrid version of BSYS 2051. Delivery is online and six in class meetings at the Burnaby campus. Please note: January 16th, January 30th, February 6th, February 20th, February 27th and March 13th classes are taught online. Further information will be supplied in person on the first day of class.
Status
This course offering has been cancelled. Please check this page for other currently available offerings or subscribe to receive email updates.
Cancelled
CRN 77580
Duration
Wed Jan 09 - Wed Mar 27 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jan 09 - Mar 27 | Wed | 17:30 - 20:30 | DTC Rm. 310 |
Instructor
Reza Bafandeh
Course Outline
Cost
$604.90
Status
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
In Progress
CRN 77581
Duration
Thu Jan 10 - Thu Mar 28 12 Weeks
Instructor
Ben Whitney
Course Outline
Cost
$612.04
Status
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
In Progress
CRN 78412
Duration
Fri Jan 11 - Fri Mar 29 12 Weeks
Instructor
Ben Whitney
Course Outline
Cost
$612.04
Notes
- .
Status
This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.
In Progress
CRN 79495
Duration
Mon Mar 11 - Fri Mar 15 5 Days
Class Meeting Times
| Dates | Days | Times | Locations |
| Mar 11 - Mar 15 | Mon - Fri | 09:00 - 17:00 | BBY SE06 Rm. 102 |
Instructor
Ed Bosman
Course Outline
Cost
$612.04
Notes
- This is a one week long fast-paced course and it is not suitable for all students
Status
This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.
Full
Spring/Summer 2019
Below are five offerings of this course for the Spring/Summer 2019 term.
CRN 58573
Duration
Mon Apr 08 - Sat Jun 29 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Apr 08 - Jun 29 | Online |
Instructor
Denise Calvert
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$612.04
Notes
- Internet delivery format.
- 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 OPMT 1110 Business Mathematics, or an equivalent course. Students must submit e-mail address when registering. Start date Monday, April 8, 1800 – 2130 SE12 Room 318 Midterm Thursday, May 16, 1800 – 2130 SE6 Room 104 Final Thursday, June 27, 1800 – 2130 SE12 Room 318
Status
CRN 57988
Duration
Mon Jun 10 - Fri Jun 21 2 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jun 10 - Jun 21 | Mon/Wed/Fri | 08:30 - 14:30 | BBY SE06 Rm. 104 |
Instructor
Ben Whitney
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$612.04
Status
Three seats remaining as of Feb 22, 2019 10:30 am PST. Seats remaining may change at any time prior to registration and payment.
CRN 59673
Duration
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
TBD – see Learning Outcomes in the interim
Cost
$612.04
Status
CRN 57661
Duration
Wed Apr 10 - Wed Jun 26 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Apr 10 - Jun 26 | Wed | 18:30 - 21:30 | BBY |
Instructor
Nadia Graham
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$612.04
Status
This course offering is full. Please check this page for other currently available offerings or subscribe to receive email updates.
Full
CRN 59674
Duration
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
TBD – see Learning Outcomes in the interim
Cost
$612.04
Status
This course offering is full. Please check this page for other currently available offerings 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
- Accounting
Part-time Diploma - Advanced Business Management
Part-time/Distance & Online Learning Certificate - Advanced Human Resource Management
Part-time Certificate - Advanced Marketing Management
Part-time Certificate - Business Administration (General Option)
Part-time Diploma - Business Administration (Global Studies Option)
Part-time Diploma - Business Administration (Human Resources Option)
Part-time Diploma - Business Administration (Management Option)
Part-time Diploma - Business Administration (Marketing Option)
Part-time Diploma - Business Management
Part-time Certificate - Computerized Accounting
Part-time Associate Certificate - Finance
Part-time Diploma - Financial Management (Finance Option)
Part-time Certificate - Financial Management (Professional Accounting Option)
Part-time Certificate - Financial Planning
Part-time Diploma - Fire Executive Management
Part-time/Distance & Online Learning BCIT/Industry Partnership Certificate - International Trade and Transportation Logistics
Part-time Certificate - Marketing Management (Tourism Management Option)
Part-time Certificate - Marketing Management
Part-time Certificate - Marketing Management (Professional Sales Option)
Part-time Certificate - Operations Management (Facilities Management Option)
Part-time Certificate - Operations Management (Industrial Engineering Option)
Part-time Certificate - Operations Management (Management Engineering Option)
Part-time Certificate - 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.
Winter 2019
Books for Winter 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 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
| 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 | |
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 | |
Spring/Summer 2019
No information on books is currently available for Spring/Summer 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.