- International Fees
International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
Course details
This course is divided into two parts: One part builds on the learning from FMGT 3720 and continues to develop Data and Analytics skills using various tools including Excel, Power BI and Tableau. In the other part, Excel is used to analyze data and to build a Financial Model.
Prerequisite(s)
- 50% in FMGT 3720
Credits
5.5
Domestic fees
$923.13
Course offerings
Spring/Summer 2024
Below are two offerings of FMGT 4710 for the Spring/Summer 2024 term.
CRN 52600
Duration
Thu May 16 - Thu Jul 04 (7 weeks)
- 7 weeks
- CRN 52600
- Domestic fees $923.13International fees are typically three times the amount of domestic fees.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| May 16 - May 30 | Thu | 18:00 - 22:00 | Burnaby SE12 Rm. 310 |
| May 27 - Jun 24 | Mon | 18:00 - 22:00 | Online |
| Jun 06 - Jul 04 | Thu | 18:00 - 22:00 | Burnaby SE12 Rm. 310 |
Instructor
Yasmin Alami
Course outline
Credits
5.5
Domestic fees
$923.13
Important information
- International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
-
Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information This is a hybrid course offering. Class WILL NOT be held on Monday, May 20th (Victoria Day), and Monday, July 1st (Canada Day). The following dates will be HELD IN-CLASS at the Burnaby Campus: Thursday, May 16th (18:00 – 22:00), Thursday, May 23rd (18:00 – 22:00), Thursday, May 30th (18:00 – 22:00), Thursday, June 6th (18:00 – 22:00), Thursday, June 13th (18:00 – 22:00), Thursday, June 20th (18:00 – 22:00), Thursday, June 27th (18:00 – 22:00), and Thursday, July 4th (18:00 – 22:00). The following dates will be held ONLINE: Monday, May 27th (18:00 – 22:00), Monday, June 3rd (18:00 – 22:00), Monday, June 10th (18:00 – 22:00), Monday June 17th (18:00 – 22:00), and Monday, June 24th (18:00 – 22:00).
Status
Seats Available
5 seats remaining as of Sat April 27, 2024 at 1:57 am (PDT). Availability may change at any time.
CRN 62383
Duration
Tue Apr 09 - Tue May 21 (7 weeks)
- 7 weeks
- CRN 62383
- Domestic fees $923.13International fees are typically three times the amount of domestic fees.
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Apr 09 | Tue | 18:00 - 22:00 | Online |
| Apr 13 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 333 |
| Apr 13 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 334 |
| Apr 16 | Tue | 18:00 - 22:00 | Online |
| Apr 20 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 333 |
| Apr 20 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 334 |
| Apr 23 | Tue | 18:00 - 22:00 | Online |
| Apr 27 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 334 |
| Apr 27 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 333 |
| Apr 30 | Tue | 18:00 - 22:00 | Online |
| May 04 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 333 |
| May 04 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 334 |
| May 07 | Tue | 18:00 - 22:00 | Online |
| May 11 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 333 |
| May 11 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 334 |
| May 14 | Tue | 18:00 - 22:00 | Online |
| May 18 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 333 |
| May 18 | Sat | 09:00 - 13:00 | Burnaby NE01 Rm. 334 |
| May 21 | Tue | 18:00 - 21:00 | Burnaby NE01 Rm. 333 |
| May 21 | Tue | 18:00 - 21:00 | Burnaby NE01 Rm. 334 |
Instructor
Bernadette Edwards
Course outline
Credits
5.5
Domestic fees
$923.13
Important information
- Important course information will be sent to you prior to your course start date. Check your myBCIT email account to access this information.
- International fees are typically three times the amount of domestic fees. Exact cost will be calculated upon completion of registration.
-
The following dates will be HELD IN-CLASS at the Burnaby Campus: Saturday, April 13th (09:00 - 13:00), Saturday, April 20th (09:00 - 13:00), Saturday, April 27th (09:00 - 13:00), Saturday, May 4th (09:00 - 13:00), Saturday, May 11th (09:00 - 13:00), and Saturday, May 18th (09:00 - 13:00). The following dates will be ONLINE: Tuesday, April 9th (18:00 - 22:00), Tuesday, April 16th (18:00 - 22:00), Tuesday, April 23rd (18:00 - 22:00), Tuesday, April 30th (18:00 - 22:00), Tuesday, May 7th (18:00 - 22:00), Tuesday, May 14th (18:00 - 22:00), and Tuesday, May 21st (18:00 - 22:00). This is a Bring Your Own Device (BYOD) course. Please be advised that you will NEED TO BRING YOUR OWN DEVICE to each in-person class. Please ensure that your device has at least four (4) hours of battery life. Computing requirements for the School of Business and Media can be found here: www.bcit.ca/files/business/pdf/bcit-sobm-byod.pdf. Information about student discounts on technology products can be found here: www.bcit.ca/it-services/student-discounts/. A desktop computer is not suitable for this course. Students are advised to purchase the textbook, Data Analytics in Accounting, by Dzuranin, Geerts and Lenk, and Wiley Plus Access, available through the BCIT Bookstore, before the start of the course. This is not a self-paced course. You will be expected to be available and online on the posted Tuesday evenings (18:00 - 22:00) 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 if 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
In Progress and Full
This course offering is in progress and full. Please check this page for other currently available offerings or subscribe to receive email updates.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- Perform processes to extract, transform and load data for analysis
- Apply critical thinking principles to decision-making
- Use various tools including Excel, Power BI and Tableau for visual presentation of analysis results
- Create a Pivot table in Excel to analyze Payroll information.
- Create Monthly and Annual Budget Income Statement, Balance Sheet and Cash Flow reports using an Excel model.
- Change the projection data and have the budget reports update to reflect these changes in this model.
- Use appropriate excel functions to link the data in the model.
- Update this model to deal with changes to the underlying assumptions.
Effective as of Winter 2024
Related Programs
Advanced Computer Applications 2 (FMGT 4710) is offered as a part of the following programs:
- Indicates programs accepting international students.
- Indicates programs with a co-op option.
School of Business + Media
- Accounting
Diploma Full-time
- Accounting
Diploma Part-time
- Computerized Accounting
Associate Certificate Part-time
- Finance
Diploma Part-time
- Financial Management (Finance Option)
Certificate Part-time
- Financial Management (Professional Accounting Option)
Certificate Part-time
- Financial Planning
Diploma Part-time
Subscribe
Interested in being notified about future offerings of Advanced Computer Applications 2 (FMGT 4710)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.
Programs and courses are subject to change without notice.