Skip to main content

Advanced Computer Applications 2 FMGT 4710

Financial Management Course

Course details

In the first half of the course we extend on the work done in FMGT 3720. We cover the major business processes using Dynamics GP. In the second half Excel is used to analyze data and to build a Financial Model.

Prerequisite(s)

Credits

5.5

Cost

$852.41 - $891.16 See individual course offerings below for actual costs.

Course offerings

Spring/Summer 2023

Below are two offerings of FMGT 4710 for the Spring/Summer 2023 term.

CRN 62383

Duration

Tue Apr 18 - Tue Jul 11 (13 weeks)

  • 13 weeks
  • CRN 62383
  • $852.41
Class meeting times
Dates Days Times Locations
Apr 18 - Jul 11 Tue 18:00 - 22:00 Online
Instructor

Bernadette Edwards

Course outline

View

Credits

5.5

Cost

$852.41

Important information
  1. Internet delivery format.
  2. 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.
Status

In Progress and Full

This course offering is in progress and full. Please check back next term or subscribe to receive email updates.

CRN 55250

Duration

Mon Jun 05 - Mon Jun 26 (4 weeks)

  • 4 weeks
  • CRN 55250
  • $891.16
Class meeting times
Dates Days Times Locations
Jun 05 Mon 09:00 - 13:00 Burnaby SE12 Rm. 310
Jun 06 Tue 09:00 - 13:00 Online
Jun 07 Wed 09:00 - 13:00 Burnaby SE12 Rm. 310
Jun 08 Thu 09:00 - 13:00 Online
Jun 12 Mon 09:00 - 13:00 Burnaby SE12 Rm. 310
Jun 13 Tue 09:00 - 13:00 Online
Jun 14 Wed 09:00 - 13:00 Burnaby SE12 Rm. 310
Jun 15 Thu 09:00 - 13:00 Online
Jun 19 Mon 09:00 - 13:00 Burnaby SE12 Rm. 310
Jun 20 Tue 09:00 - 13:00 Online
Jun 21 Wed 09:00 - 13:00 Burnaby SE12 Rm. 310
Jun 22 Thu 09:00 - 13:00 Online
Jun 26 Mon 09:00 - 13:00 Burnaby SE12 Rm. 310
Instructor

Bernadette Edwards

Course outline

View

Credits

5.5

Cost

$891.16

Important information
  1. 1. This is a Hybrid course consisting of both In-Person and Virtual Online Synchronous classes. 2. In-Person Class Days, held at the Burnaby campus, are: June 5, 7, 12, 14, 19, 21, and 26. 3. Virtual Online Synchronous Class Days are: June 6, 8, 13, 15, 20, and 22. 4. For the Virtual Online Synchronous Class Days, students are expected to be available and online. It is important you have a stable and consistent internet connection to access course content.
Status

In Progress

This course offering is in progress. Please check back next term or subscribe to receive email updates.

Learning Outcomes

Upon successful completion, the student will be able to:

  • Navigate the principal features in Dynamics GP.
  • Enter transactions for the major business processes in Dynamics GP.
  • Understand the difference between Posting Individual transactions and saving Transactions to a batch.
  • Understand how to Post Batches.
  • Understand how to Modify transactions before posting the Batch.
  • Set Batch Posting Options to ensure accuracy and require approval.
  • Understand the differences between Posting individual transactions and posting batches.
  • Perform Revenue Cycle activities including Master Record setup, recording transactions and running reports.
  • Perform Revenue Cycle activities for Inventory items using Sales Order Processing.
  • Perform Expenditure Cycle activities including Master Record setup, purchase order creation, recording transactions and running reports.
  • Perform Expenditure Cycle activities for Inventory items using Purchase Order Processing.
  • Perform Expenditure Cycle activities involving the purchase of non-inventory items and services.
  • Assign Vendors and Customers to a Class and use Class to load and change default information.
  • Set up Inventory Master Records and inventory classes.
  • Maintain Inventory records, including physical count adjustments.
  • Create a pricing method which will link the Sales Price of an Item to the Purchase Price of the same item.
  • Run Inventory reports.
  • Use Smartlist to extract information from Dynamics GP.
  • Export reports to tab delimited files and then to Excel.
  • Open and close fiscal periods in Dynamics GP to control financial information.
  • Create a Pivot table to analyse Payroll information.
  • Modify and Build Financial Statements in Dynamics GP using Advanced Financial Analysis (subject to time available).
  • Create, import and export Budgets and explore the budget functionality in Dynamics GP (subject to time available).
  • Limit user access to the Dynamics GP System (subject to time available).
  • Create Monthly and Annual Budget Income Statement, Balance Sheet and Cash Flow reports using an Excel model.
  • Link sales projections, purchase projections and prices to the budget in this 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.
  • Learn how to update this model to deal with changes to the underlying assumptions.

Effective as of Winter 2014

Related Programs

Advanced Computer Applications 2 (FMGT 4710) is offered as a part of the following programs:

School of Business + Media

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