Skip to main content

Advanced Computer Applications 2 FMGT 4710

Financial Management Course

International Fees

International fees are typically 3.12 times the domestic tuition. 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)

Credits

5.5

Domestic fees

$923.13 - $942.15 See individual course offerings below for actual costs.

Course offerings

Spring/Summer 2024

Below is one offering 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.13
    International fees are typically 3.12 times the domestic tuition.
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

View

Credits

5.5

Domestic fees

$923.13

Important information
  1. International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
  2. 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

In Progress

This course offering is in progress. Please check this page for other currently available offerings or subscribe to receive email updates.

Fall 2024

Below is one offering of FMGT 4710 for the Fall 2024 term.

CRN 42264

Duration

Wed Sep 11 - Wed Dec 04 (13 weeks)

  • 13 weeks
  • CRN 42264
  • Domestic fees $942.15
    International fees are typically 3.12 times the domestic tuition.
Class meeting times
Dates Days Times Locations
Sep 11 - Dec 04 Wed 18:00 - 22:00 Burnaby SE06 Rm. 230
Instructor

Yasmin Alami

Course outline

Course outline TBD — see Learning Outcomes in the interim.

Credits

5.5

Domestic fees

$942.15

Important information
  1. International fees are typically 3.12 times the domestic tuition. Exact cost will be calculated upon completion of registration.
  2. This is a Bring Your Own Device (BYOD) course. Students are required to use their own laptop during class time. The laptop should be able to be used without the use of a charger, for a minimum of four (4) hours. 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.
Status

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

  1. Accounting
    Diploma Full-time
  2. Accounting
    Diploma Part-time
  3. Computerized Accounting
    Associate Certificate Part-time
  4. Finance
    Diploma Part-time
  5. Financial Management (Finance Option)
    Certificate Part-time
  6. Financial Management (Professional Accounting Option)
    Certificate Part-time
  7. 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.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: privacy@bcit.ca.