BSYS 2051 - Introduction to Business Data Analytics with MS Excel 2016 for Windows
Business Systems Part-time Studies Course
School of Business + Media
To support you and your education, BCIT is adapting applied learning in formats appropriate to the unfolding global situation. Spring and Summer PTS classes are being delivered in an online format unless you are notified otherwise.
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
$617.60 - $627.60 See individual course offerings below for actual costs.
Spring/Summer 2020
Below are three offerings of this course for the Spring/Summer 2020 term.
CRN 60435
Duration
Fri May 01 - Fri Jul 17 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| May 01 - Jul 17 | Fri | 13:30 - 16:20 | BBY Online Delivery |
Instructor
Peter Goel
Course Outline
Cost
$625.57
Notes
- Departmental approval needed
- Please join the waitlist to be considered for approval. This section requires department approval. For approval, please contact the Program Assistant, Sarah Chanway at schanway@bcit.ca. Please include your BCIT student ID number and a brief explanation of why you wish to register.
Status
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
Duration
Tue Jun 30 - Thu Aug 06 6 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Jun 30 - Aug 06 | Tue/Thu | 18:30 - 21:30 | BBY Online Delivery |
Instructor
Dave Lazenby
Course Outline
Cost
$625.57
Status
This course offering is in progress and full. Please check back next term or subscribe to receive email updates.
In Progress and Full
CRN 59673
Duration
Mon Aug 10 - Fri Aug 14 5 Days
Class Meeting Times
| Dates | Days | Times | Locations |
| Aug 10 - Aug 14 | Mon - Fri | 09:00 - 16:30 | BBY Online Delivery |
Instructor
Ed Bosman
Course Outline
Cost
$625.57
Status
This course offering is full. Please check back next term or subscribe to receive email updates.
Full
Fall 2020
Below are five offerings of this course for the Fall 2020 term.
CRN 44216
Duration
Tue Sep 08 - Tue Nov 24 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Sep 08 - Nov 24 | Tue | 17:30 - 20:30 | DTC Online Delivery |
Instructor
Nadia Graham
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$617.60
Status
This course offering is full. Please check back next term or subscribe to receive email updates.
Full
CRN 35638
Duration
Thu Sep 10 - Thu Nov 26 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Sep 10 - Nov 26 | Thu | 18:30 - 21:30 | BBY Online Delivery |
Instructor
Masoud Jalili
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$627.60
Status
This course offering is full. Please check back next term or subscribe to receive email updates.
Full
CRN 46245
Duration
Mon Sep 14 - Mon Dec 07 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Sep 14 - Dec 07 | Online |
Instructor
Denise Calvert
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$627.60
Notes
- Internet delivery format.
- “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. No class on Monday, October 12
Status
This course offering is full. Please check back next term or subscribe to receive email updates.
Full
CRN 46249
Duration
Mon Sep 14 - Mon Dec 07 12 Weeks
Class Meeting Times
| Dates | Days | Times | Locations |
| Sep 14 - Dec 07 | Online |
Instructor
Denise Calvert
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$627.60
Notes
- Internet delivery format.
- 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. No class on Monday, October 12th
Status
This course offering is full. Please check back next term or subscribe to receive email updates.
Full
CRN 35446
Duration
Mon Dec 07 - Fri Dec 11 5 Days
Class Meeting Times
| Dates | Days | Times | Locations |
| Dec 07 - Dec 11 | Mon - Fri | 09:00 - 17:00 | BBY |
Instructor
TBD
Course Outline
TBD – see Learning Outcomes in the interim
Cost
$627.60
Status
This course offering has been cancelled. Please check back next term or subscribe to receive email updates.
Cancelled
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 + Media
- 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
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.
Spring/Summer 2020
Books for Spring/Summer 2020 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.95 |
| Required | |
Fall 2020
Books for Fall 2020 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.
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 | |
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.