Reading and Understanding Financial Statements - Instructor-led Online
2023-11-30 09:00 - 2023-12-01 16:00 (America/Inuvik)
You pay all kinds of money to your accountant to prepare annual financial statements for your business, but do you really know how to read them? This workshop goes through the sections of basic financial statements including balance sheets, income statements and supporting documents to give you a thorough understanding of the information they contain. You will learn how to use common ratios used by lenders and investors to determine the health of your business, as well as ways to thoroughly analyze the information contained in the statements.

Course Objectives:

To learn how the double entry accounting system works

To develop an understanding of the principles of accounting used in financial statements

To learn what information is included in a balance sheet

To learn what information is included in an income statement

To learn how to analyze the information in financial statements

To learn how to prepare a statement of cash flowsCourse

Date: November 30 & December 1, 2023Time: 9:00 a.m. – 4:00 p.m.Cost: $600.00

PROJECT MONITORING AND CONTROL (PROJECT MANAGEMENT SERIES)
2023-12-04 09:00 - 16:00 | Yellowknife North Slave Campus, 5004 54 St, Yellowknife, NT, X1A2R6, Canada
In this course, you will learn to:• Establish a baseline from which to measure results• Develop contingencies for “unknowns” which may affect your project• Control the project scope and take measures to avoid “scope creep”• Implement a simple change management process• Apply techniques for shortening project duration• Track cost, schedule and quality data• Report project progress and status• Apply strategies for getting back on track when a project goes “off the rails”

Date: Monday, December 4, 2023

Time: 9:00 AM to 4:00 PM

Cost: $300.00

Instructor: Janet Dean, TangleTree Enterprises Ltd.

C.O.R.E De-Escalation - Instructor-Led Online
2023-12-04 09:00 - 16:00, 2023-12-05 09:00 - 16:00 | Yellowknife North Slave Campus, 5004 54 St, Yellowknife, NT, X1A2R6, Canada
Creating Opportunities with Respect & Empathy

Introduction

Introduction Sequence

Traditional lecture vs. skill based learning

De-escalation Overview

Goals of the course

Part I: Realizing Expectations

Being a professional brings expectations from:– The organization, the public, the media and the courts

Natural reactions in the face of conflict – Fight, Flight or Freeze– Exceptions are those who benefited from: great parents, great mentors, the Anvil of Experience (making mistakes) or effective training Experience Alone is No Guarantee of Success – Ericsson’s 10,000 hr. principle

Intergenerational Communication– For the first time, we are seeing Grandparents working on teams that contain persons their grandchildren’s age. Dr. Mary Donahoe

The Impact of Technology on Interpersonal Communication– Video Technology has created a new reality, the power of social media

Part II: It’s Not Personal!

Rationalizing the Irrational– People under the influence of negative emotions can appear irrational– Their attacks can be very personal and offensive

People Don’t Mean What They Say …– Words and meanings can be (and usually are), completely different– We need to ignore the words and search for the correct meanings

Don’t Take the Bait – 80% of Complaints Stem from Our Reaction

EGO Is the EnemyUltimately, that voice in our head that makes us do and say things that we never planned on doing or saying!

Compliance vs. Cooperation – Separating attitude from behavior

The Unanswered Question – the appropriate response to verbal resistance

Part III: The Learned Response Confidence In Conflict – Confidence comes from skill acquisition and skill development Aristotle – ‘Audiences Are Made, Not Found’ and the 3 Appeals Emotional Intelligence:Knowing who we are and what our role is (moral compass) Recognizing our emotions (and only perform the positive ones) Recognizing the emotions of others (empathy) Using this awareness to start building a relationship THE 93% RULE – It’s not what you say, it’s how you say it!

Breath! – Control your heart rate and prevent your emotions from ‘high jacking’ you

C.O.R.E. Philosophy– By recognizing and controlling our negative emotions, we can now perform only positive emotions. This mindset allows us to see opportunity in conflict as we endeavor to maintain the high ground by showing respect and diffusing the other with empathy

PROFESSIONAL RESPECT– Performed respect forms the basis of a healthy relationship

PROFESSIONAL EMPATHY– Essential for diffusing a difficult encounter – empathy absorbs tension

Part IV: Communication Essentials

Breath! – Control your heart rate and prevent your emotions from ‘high jacking’ you

C.O.R.E. Philosophy– By recognizing and controlling our negative emotions, we can now perform only positive emotions. This mindset allows us to see opportunity in conflict as we endeavor to maintain the high ground by showing respect and diffusing the other with empathy

PROFESSIONAL RESPECT– Performed respect forms the basis of a healthy relationship

PROFESSIONAL EMPATHY– Essential for diffusing a difficult encounter – empathy absorbs tension

Part IV: Communication Essentials

Active Listening Revisited – Finding the meanings behind the words

The Power of Paraphrasing – the ultimate communication tool

Digging Deeper – asking the appropriate questions at the appropriate time

Providing Real Options – The essence of persuasion

Part V: Practical Application

Personal Security Awareness– Imminent Jeopardy– Proxemics

De-escalation Phrases – demonstrate that you are listening – refocus the contact

C.O.R.E. PROCESS– Introduction Sequence– Clarify – ask the $1,000,000 question– Establish Context– tactfully minimize resistance, build upon credibility– Proceed OR Persuade – VerifyConclude

Case Study – application of C.O.R.E. techniques to actual events

Scenario Development – Practical application– Skill building – Introduction Sequence with De-escalation phrases– Skill building – Clarifying Sequence– Skill building – Putting it all together, no resistance– Skill building – Minimal Resistance – persuasion– Skill building – Medium Resistance – persuasion – Verify

The Ethical Protector Creed and Closing Remarks

Part V: Practical Application

Personal Security Awareness– Imminent Jeopardy– Proxemics

De-escalation Phrases – demonstrate that you are listening – refocus the contact

C.O.R.E. PROCESS– Introduction Sequence– Clarify – ask the $1,000,000 question– Establish Context– tactfully minimize resistance, build upon credibility– Proceed OR Persuade – VerifyConclude

Case Study – application of C.O.R.E. techniques to actual events

Scenario Development – Practical application– Skill building – Introduction Sequence with De-escalation phrases– Skill building – Clarifying Sequence– Skill building – Putting it all together, no resistance– Skill building – Minimal Resistance – persuasion– Skill building – Medium Resistance – persuasion – Verify

The Ethical Protector Creed and Closing Remarks

Date: December 4 & 5, 2023Time: 9:00 a.m. – 4:00 p.m.Cost: $750.00Instructor: Darcy Pennock

Charts & Tables - Instructor-led Online Series - Excel Training
2023-12-05 09:00 - 12:00
In the Excel program, you can convert your data from a spreadsheet into a table and/orchart. Learn how you can turn dry financial and statistical information into a vibrant visualdisplay that will have a powerful impact on your audience!

Charts vs. Tables

Creating a chart

Changing chart types

Changing chart layout and location

Using sparklines

Creating a table

Creating a Pivot Table

Date: December 5, 2023Time: 9:00 a.m. – 12:00 p.m.Cost: $150.00Instructor: Heather Lyon

MANAGING AND ADMINISTERING CONTRACTS, JOINT VENTURES, AND PARTNERSHIPS (PROJECT MANAGEMENT SERIES)
2023-12-05 09:00 - 16:00 | Yellowknife North Slave Campus, 5004 54 St, Yellowknife, NT, X1A2R6, Canada
Running a successful project is more than just aligning your project team to project goals. It also requires a clear and conscious focus on aligning corollary team participants, contractors and subcontractors through contract management and administration.

In this course, you will learn:• Drafting RFP’s and bid documents• Analyzing and evaluating responses• Fundamentals of contracting• Identifying key deliverables and objectives• Establishing quality and delivery criteria• Monitoring budgets and delivery• Managing without micromanaging or “giving away the store”• Closing out agreements• Dismissing contracts

Date: Tuesday, December 5, 2023

Time: 9:00 AM to 4:00 PM

Cost: $300.00

Instructor: Janet Dean, TangleTree Enterprises Ltd.

Tables & Illustrations - Instructor-led Online Series - Word Training
2023-12-05 13:00 - 16:00
In the Word program, you can insert a variety of items to enhance the information and make it morevisually appealing to your audience. Learn how to use the following items:

Working with Tables

Inserting a Picture

Working with Shapes

SmartArt Graphics

Inserting Screenshots

Working with Charts

Date: December 5, 2023Time: 1:00 – 4:00 p.m.Cost: $150.00Instructor: Heather Lyon

Medical Terminology – In Person in Yellowknife
2023-12-05 18:00 - 21:00, 2023-12-12 18:00 - 21:00, 2023-12-19 18:00 - 21:00 | Yellowknife North Slave Campus, 5004 54 St, Yellowknife, NT, X1A2R6, Canada
This course is a comprehensive introduction to medical terminology. The course will have an emphasis on medical word building, medical word parts and the use of medical terminology. The course will take a body systems approach to help the learner understand medical terms related to human anatomy and physiology, diagnostic procedures, disease processes, as well as various medical and surgical treatment modes.

Date: Tuesday Evenings, September 12 – December 19, 2023

Time: 6:00 – 9:00 p.m.

Tuition: $545.00

Text: Medical Terminology A Living Language – Cost TBD

Instructor: Lesia Lucan

This course will be delivered face to face at Yellowknife Campus. Contact Karen Horn at (867) 920-8802 or email khorn@auroracollege.nt.ca for more information and to register.

QUALITY METRICS FOR PROJECTS (PROJECT MANAGEMENT SERIES)
2023-12-06 09:00 - 16:00 | Yellowknife North Slave Campus, 5004 54 St, Yellowknife, NT, X1A2R6, Canada
Meeting cost and time constraints within a project often compromises quality. This course explores how to maintain your quality standards through a balanced approach to quality time and cost. The focus is on developing and applying a quality framework that works for your own projects.

In this course, you will learn:• Defining quality• The quality approach• Prioritizing key quality metrics• The quality management plan – establishing metrics• Applying practical tools and techniques• Applying industry-standard techniques• Applying quality control tools and techniques• Compiling and documenting lessons learned• Sharing best practices

Dates: Wednesday, December 6, 2023Cost: $300.00

EFFECTIVE PREPARATION AND START-UP OF PROJECTS (PROJECT MANAGEMENT SERIES)
2023-12-07 09:00 - 16:00 | Yellowknife North Slave Campus, 5004 54 St, Yellowknife, NT, X1A2R6, Canada
Effective initiation processes are key to launching effective projects. This course explores specific tips and strategies you can implement during the preparation and start up phases.

In this course, you will learn;• an overview of approaches, methods, and instruments for the initiation.• selecting methods and instruments that fit your project• actively involving others in the analysis and planning of the project• the role of a project facilitator• the effect of different leadership styles and training tools and tricks.• Creating, editing and updating a project handbook.• how projects should be launched, by applying adjusted versions of workshops, facilitation, handbooks, and other guidelines used by others (best practices)• implementing the course ideas into your own organization/project

Date: Thursday, December 7, 2023

Time: 9:00 AM to 4:00 PM

Cost: $300.00

Instructor: Janet Dean, TangleTree Enterprises Ltd.

Word Extras - Instructor-led Online Series
2023-12-07 13:00 - 16:00
You know the basics of the Word program. Now learn about what else you can do to make workingwith this program even easier and more effective in this 3-hour session. Topics include:

Working with Tabs

Envelopes & Labels

Mail Merge

Tracking Changes

Using comments

Proofing Tools

Headers & Footers

Page Numbering

Date: December 7, 2023Time: 1:00 – 4:00 p.m.Cost: $150.00Instructor: Heather Lyon

PMP CERTIFICATION PREPARATION (PROJECT MANAGEMENT SERIES)
2023-12-08 09:00 - 16:00 | Yellowknife North Slave Campus, 5004 54 St, Yellowknife, NT, X1A2R6, Canada
Individuals may be certified by the Project Management Institute (an internationally recognized body of project management professionals), a comprehensive program that certifies individuals knowledge in the field of project management. If you would like to find out more information, please visit www.pmi.org.

This course provides an intensive review of the subject matter tested on the Project Management Institute’s Project Management Professional (PMP) Certification Exam. You will improve your test-taking skills by completing Sample Exam questions and by discussing the rationale behind both correct and incorrect answers. This course will help you identify personal strengths and weaknesses in each of the PMBOK knowledge areas and develop apersonal strategy for passing the exam.

Unfortunately, at this time, Aurora College, Yellowknife Campus does not offer the PMP exam.

Date: Friday, December 8, 2023

Time: 9:00 AM to 4:00 PM

Cost: $300.00

Instructor: Janet Dean, TangleTree Enterprises Ltd.

Reading Break Fall 2023 Term
2023-12-18 00:00 - 2024-01-05 23:59

Excel Extras - Instructor-led Online Series
2023-12-19 09:00 - 12:00
You know the basics of the Excel program. Now learn about what else you can do to make workingwith this program even easier and more effective in this 3-hour session. Topics include:

Working with graphics

Inserting a screenshot

Sorting & Filtering

Using hyperlinks

Using comments

Drop-down lists

Grouping & Subtotals

Quick Analysis

Date: December 19, 2023Time: 9:00 a.m. – 12:00 p.m.Cost: $150.00Instructor: Heather Lyon

Board of Governors meeting - Tuesday, January 23
2024-01-23 11:00 - 17:00
Agenda

Any person or group wishing to address, ask a question of, or make a presentation to the Board of Governors must make the request in writing to the contact below no later than 5:00 PM on Friday, January 19. The question or presentation must be submitted either electronically or in hard copy by that date and time as well. Delegations are limited to two minutes with a maximum of six delegations per meeting. Questions about the Board of Governors meeting may also be addressed to the contact email.

Delegation contact:

Heather Meacock

Executive Assistant to the President

Email: hmeacock@auroracollege.nt.ca

To receive meeting link and agenda:

Contessa Stead

Governance Coordinator

Email: cstead@auroracollege.nt.ca

Location: Virtual Meeting

Date: Tuesday, January 23, 2024

Time: 11:00 AM (Delegations – 3:00 PM)

Microsoft Teams meeting

Join on your computer, mobile app or room device

Click here to join the meeting

Meeting ID: 259 539 704 680Passcode: [REDACTED]

Download Teams | Join on the web

Or call in (audio only)

+1 647-794-6122,,110886830# Canada, Toronto

(855) 749-4910,,110886830# Canada (Toll-free)

Phone Conference ID: 110 886 830#

Réunion du Conseil des gouverneurs

Toute personne ou tout groupe souhaitant s’adresser, poser une question ou faire une présentation au Conseil des gouverneurs doit en faire la demande par écrit aux coordonnées ci-dessous au plus tard le vendredi 19 janvier, à 17 h. Les questions ou les présentations doivent également être soumises par courriel ou en format papier avant cette date. La réunion pourra accueillir un maximum de six délégations et chacune aura un temps de présentation limité à deux minutes. Les questions relatives à la réunion du Conseil peuvent être envoyées par courriel à la personne-ressource.

Coordonnées pour les délégations :

Heather Meacock

Courriel : hmeacock@auroracollege.nt.ca

Pour obtenir un lien pour assister à la réunion, écrivez à

Contessa Stead

Coordonnateur de la gouvernance

Courriel :cstead@auroracollege.nt.ca

Lieu : Réunion virtuelle

Date : Mardi 23 janvier 2024

Heure : 11 h 00 (Délégations – 15 h)

PowerPoint - Instructor-led Online
2024-01-30 09:00 - 16:00
If you are new to working with this presentation software, this 1-day online session is for you! You will be introduced to the capabilities of the program and learn some basic techniques for creating and delivering a simple slide show. You will learn some of the tips and tricks for working with the software, but the session includes even more, such as the five rules for creating great PowerPoints, how to ensure that your audience gets your message, and that they remember it long after you finish!

Date: January 30, 2024Time: 9:00 a.m. – 4:00 p.m.Cost: $350.00Instructor: Heather LyonFor information/registration please contact Karen Horn at (867) 920-8802 or emailkhorn@auroracollege.nt.ca

Speak Up, Speak Out - Instructor-led Online
2024-02-06 09:00 - 16:00
Surveys indicate that many people list public speaking as their greatest fear – while fear of death is listed farther down the list! If you are someone who would rather die than speak up in public, this one-day course is for you. In addition to learning what it takes to be effective in any public speaking situation – whether making a formal presentation or just offering an opinion in a meeting, you will gain valuable experience in facing your fear and moving through it.

Date: February 6, 2024Time: 9:00 a.m. – 4:00 p.m.Location: Virtual

Cost: $350.00Instructor: Heather Lyon

Add/Drop Deadline Winter 2024 Term
2024-02-09 00:00 - 23:59
Last day to add or drop course for the Winter 2024 term.

*Also the last day for tuition to be paid or for a student to be setup with a payment plan through Finance Division.

Course Withdrawal 1/3 of Course Winter 2024 Term
2024-02-26 00:00 - 23:59
50% refund to student & no academic penalty.

Reading Week Winter 2024 Term
2024-03-11 00:00 - 2024-03-15 23:59

Course Withdrawal 50% of Course - Winter Term 2024
2024-03-19 00:00 - 23:59
No refund for dropped course, but no academic penalty.

Excel Advanced – Instructor-led Online Series
2024-03-19 09:00 - 16:00, 2024-03-26 09:00 - 16:00
This two day workshop is for experienced users of the Excel program. In this session, we learn some of the more advanced features of Excel, including advanced functions such as lookup, date & time, and financial functions; how to nest functions; Data analysis using Pivot Tables and Pivot Charts; and how to perform What-if Analyses. We also learn how to create forms in Excel. Students should have a good understanding of the basics of the program before taking this course.

Functions & Formulas:

Named Ranges

Lookup Functions

Date & Time Functions

Checking for Formula Errors

Data Verification

Financial Functions

Nesting Functions

Pivot Tables & Pivot Charts:

Customizing Pivot Tables

Filters

Data Slicers

Grouping Data

Creating a Pivot Chart

Changing Pivot Chart Options

Drilling Down

Creating Forms in Excel:

Adding Command Buttons

Spin Buttons and Scroll Bars

Check Boxes and Option Buttons

List Boxes and Combo Boxes

Group Box

Text Boxes

Performing What-if Analysis:

Using the Goal Seek Tool

Working with Scenarios

Using Cell Watch

Date: March 19 & 26, 2024

Time: 9:00 a.m. – 4:00 p.m.

Cost: $700.00

Location: Online

Instructor: Heather Lyon

Teaching and Learning at a Distance - Online / Multi-day
2024-03-19 19:00 - 22:00, 2024-03-26 19:00 - 22:00, 2024-04-02 19:00 - 22:00
This course is a practical exploration of techniques, systems, challenges, and benefits associated with distance education for adult educators in the North. It focuses on preparing teachers to facilitate distance learning based on their prior knowledge of adult learning, communication theory, and technology. Students will explore the use of relevant technology and appropriate instructional design in distance education. In addition, participants will investigate ways to establish a community of learning in an online course. Students will make use of Aurora College software platforms to learn how to create and deliver a distance learning course, in the context of the contemporary environment. Specifically, consideration will be given to how we can enhance connectivity and better simulate in-person learning using technology in a social distancing environment. The course uses Moodle, Teams, Zoom, and may include other platforms.

PrerequisiteElements of Instruction

DatesMarch 19th, 26th, April 2nd, 9th, 16th, 23rd, 30th, and May 7th

Time7:00 p.m. – 10:00 p.m.

LocationOnline via TEAMS/Moodle

TextbooksTBD

InstructorHannah Vedamani

Writing & Editing Skills - Making the Message Clear - Instructor-led Online
2024-03-21 09:00 - 2024-03-22 16:00
Good business writing leads to good business decisions, which leads to good business. This course emphasizes business writing (letters, memos, emails, documents, web material) with the reader and readability in mind. In two days you will focus on new formats, writing style, tone, clarity, conciseness and results while exploring new skills and time saving approaches.

Spend less time writing and more time communicating

Motivate and persuade readers to take action

Develop an active, objective and powerful writing style

Write sensitive or negative messages in a positive way

Understand the importance of word choice

Learn the implications of FOIP in written documentation

Prepare written information with objectivity and a results perspective

Develop time saving approaches to minute taking

Outline:

Why is writing so difficult to do?

Preparing to Write

Purpose

Audience

Tone

Choosing a Format

Emails/Memos

Business Letters

Reports

Advertising Material

Instructional Documents

Historical Records

Putting it All Together

Start with an Outline

Greetings & Introductions

Main body of the message

Wrapping things up

Proof-reading & Editing

Effective and Efficient

Clear & Simple

Vocabulary

Sentence length & structure

Paragraph length

Readability

Headings

Lists/Tables

Page Numbering

Underlining & Italics

Font size and weight

Graphics & Pictures

Mechanics of Writing

Correct word choice

Correct spelling

Comma usage

Capitalization

Numbers

Abbreviations

Latin expressions

Subjects & Verbs

Colons & Semi-colons

Best Practices & Practical Application

Emails/Memos

Business Letters

Reports

Advertising Material

Instructional Documents

Historical Records

Date: March 21 & 22, 2024

Time: 9:00 a.m. – 4:00 p.m.

Location: Online

Cost: $600.00

Instructor: Heather Lyon

PowerPointOnline Delivery - Online
2024-04-04 09:00 - 16:00
If you are new to working with this presentation software, this 1-day online session is for you! You will be introduced to the capabilities of the program and learn some basic techniques for creating and delivering a simple slide show. You will learn some of the tips and tricks for working with the software, but the session includes even more, such as the five rules for creating great PowerPoints, how to ensure that your audience gets your message, and that they remember it long after you finish!

InstructorHeather Lyon

For information/registration please contact Karen Horn at (867) 920-8802 or email khorn@auroracollege.nt.ca
