Aurora College

PROJECT MANAGEMENT FUNDAMENTALS - Multi-Day
2024-11-13 09:00 - 2024-11-15 16:00 (America/Inuvik)
This workshop will examine project management from conceptualization through to completion. You will learn: setting up an effective plan, applying project-planning steps, developing the project plan and implementing it, managing work in progress, monitoring controls, and reporting status.

Date:November 13-15, 2024

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

Cost:$750.00

Instructor:Janet Dean

Online Winter Registration opens
2024-11-18 00:00 - 23:59

Formulas & Functions CMPT 0013 - Online
2024-11-19 09:00 - 12:00
In this 3-hour session, learn how to set up formulas and functions to get the Excel program to do the math for you. Topics include:

Creating and editing formulas

Mathematical operators

Common functions

Conditional functions

Absolute & relative cell references

Protecting your workbook

Date:November 19, 2024

Time:9:00 a.m. – Noon

Cost:$175.00

Instructor:Heather Lyon

Applied Topics in Northern Adult Education (pre-requisite – Elements of Instruction) - Online / Multi-Day
2024-11-20 09:30 - 10:00, 2024-11-27 09:30 - 10:00, 2024-12-04 09:30 - 10:00
This course focuses on current topics in education including, but not limited to, EDI (equity, diversity, and inclusion), UDL (universal design for learning), decolonization, and Indigenization.

Participants will examine how the concepts can be applied in the context of their own teaching practice and identify strategies to be responsive to the needs of their learners.

Delivery:Virtual Delivery(You will need a computer with high-speed internet)

Dates:7:00 p.m. – 10:00 p.m. on October 9, 16, 23, 30, November 6, 20, 27 and December 4

Textbooks:TBD

Tuition:$475.00

Instructor:Xiaoyi Yan

MANAGING CULTURAL DIVERSITY IN PROJECTS
2024-12-02 09:00 - 16:00
Improve the way your project team accomplishes tasks, and enhance their interpersonal and problem-solving skills. Identify operating stereotypes and other obstacles to communication. Learn different cultures’ approaches to work, relationships, time, and exchange of information and how this affects attitudes and performance on the job.Topics include:

creating and maintaining an environment that enables all participants to naturally reach their fullpotential in pursuit of organizational objectives.

clarifying roles and communication procedures for tolerance and flexibility

building on shared values, goals and similarities.

developing shared visions and agreeing on processes to accomplish it in an atmosphere of respect andtrust.

Date:December 2, 2024

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

Cost:$350.00

Instructor:Janet Dean

Formatting the Worksheet CMPT 0014 - Online
2024-12-03 09:00 - 12:00
Make your Excel workbooks look professional and readable by learning how to properly format all the aspects of your spreadsheet. In this 3-hour session, you will learn how to work with:

Formatting dates & numbers

Cell alignment

Fonts & sizes

Borders

Colours and patterns

Format painter

Themes & Styles

Conditional formatting

Date:December 3, 2024

Time:9:00 a.m. – Noon

Cost:$175.00

Instructor:Heather Lyon

STAKEHOLDER MANAGEMENT AND PROJECT COMMUNICATION
2024-12-03 09:00 - 16:00
Stakeholder Management is one of the most critical factors of project success. This course provides the project manager with an understanding of stakeholder management processes using proven tools and techniques for managing the stakeholders during the various phases of a project.

In this course, you will learn to:

Learn the obstacles to project communication

Identify and Assess project stakeholders using proven tools and techniques;

Develop communications strategies for achieving buy-in and cooperation from stakeholders

Explore different types of communication methods

Prepare a communications plan and put it into action

Date:December 3, 2024

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

Cost:$350.00

Instructor:Janet Dean

ALIGNING AND DEVELOPING YOUR PROJECT TEAM
2024-12-04 09:00 - 16:00
In this course, you will learn to:

Build high-performance project teams through effective leadership and team communication

Use power, politics and influence to motivate your team

Resolve conflicts using proven techniques

Implement effective and creative problem-solving and brainstorming processes

Select the right team members and balance resources between projects

Learn proven negotiation techniques

Explore the stages of team development

Work effectively with people with different personalities

Date:December 4, 2024

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

Cost:$350.00

Instructor:Janet Dean

MANAGING MULTIPLE PROJECTS
2024-12-05 09:00 - 16:00
Balance the conflicting resource and priority demands of multiple cross-functional projects, while maintaining the strategic values of your organizationIn this course, you will learn to:

Manage resources through project prioritization

Evaluate and select projects based on strategic importance to the organization

Learn to apply a filter mechanism to assess all projects prior to making a “go-no go” decision

Define success criteria for each project

Date:December 5, 2024

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

Cost:$350.00

Instructor:Janet Dean

Charts & Tables CMPT 0015 - Online
2024-12-10 09:00 - 12:00
In the Excel program, you can convert your data from a spreadsheet into a table and/or chart. Learn how you can turn dry financial and statistical information into a vibrant visual display 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 10, 2024

Time:9:00 a.m. – Noon

Cost:$175.00

Instructor:Heather Lyon

Robert’s Rules of Order - Online
2024-12-12 09:00 - 16:00
Robert’s Rules of Order

Have you ever played a team sport where only a few of the players knew the rules? The same types of challenges can occur in your meetings if your group does not understand how to properly “play the game”. In this one-day online session, you will learn the basics of Robert’s Rules of Order, the foremost manual on parliamentary procedures that is used by most organizations with boards of directors. By following these rules and other tips included in this session, you can ensure your meetings will be fair, efficient, democratic and orderly.

What are Roberts Rules of Order?

History of the book

What are the principles behind these rules?

Motions

What is a motion?

Types of motions and their purposes

Presenting a motion

Seconding a motion

Debating a motion

Amending a motion

Withdrawing a motion

Voting on a motion

Requesting Points of Something

What is a ‘Point’?

Types of points and their purposes

Tips for chairpersons of a meeting

Know and teach your group the rules of order

Set meeting times and dates that work

Notify and confirm attendance

Prepare and distribute an agenda in advance

Request reports in advance

Start & finish on time

Stick to the agenda

Assign time limits for reports/debates

Ensure action items are clear and assigned

Do an Action Item Review each meeting

Dealing with “hot topics”

Make every decision unanimous

Date:December 12, 2024

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

Cost:$350.00

Instructor:Heather Lyon

Excel Extras CMPT 0016 - Online
2024-12-17 09:00 - 12:00
You know the basics of the Excel program. Now learn about what else you can do to make working with 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 17, 2024

Time:9:00 a.m. – Noon

Cost:$175.00

Instructor:Heather Lyon

Fall term ends
2024-12-18 00:00 - 23:59

Winter term begins
2025-01-06 00:00 - 23:59

Course Planning and Assessment ADED 0135 (prerequisite – Elements of Instruction) - Online / Multi-Day
2025-01-15 19:00 - 22:00, 2025-01-22 19:00 - 22:00, 2025-01-29 19:00 - 22:00
Course Planning and Assessment is a course about how to plan courses and assess learning outcomes, particularly for adults. It is concerned with designing learning systematically by considering learners, content, intended learning outcomes, learning tasks, pacing, appropriate expectations, instructional strategies, and assessment.

Course Planning and Assessment will be useful for people who want to plan workshops as well as for those who want to plan a formal educational course, whether it be a new course or a course that has an existing course outline. It will cover the theory behind planning and present a number of models for course design.

As part of this course, learners will develop a learning assessment plan that includes a variety of strategies and tools. Learners will plan an actual course, thereby immediately applying the theory to a useful and practical project.

Delivery:Virtual Delivery via Microsoft Teams(You will need a computer with high-speed internet)

Dates: 7 p.m. – 10 p.m. on January 15, 22, 29, February 5, 12, 19, 26, and March 5, 2025

Textbooks:Creating Courses for Adults: Design for Learning – available on Amazon*Participants are responsible for ordering the textbook

Tuition: $475.00

Instructor:Mike MacPherson

Intro to Excel CMPT 0012 - Online
2025-01-16 09:00 - 12:00
This three-hour session will introduce you to the capabilities of the MS Excel program. Learn the basics of what you can do with the powerful electronic spreadsheet program including:

Purpose of spreadsheets

Moving around the screen

Using the ‘Ribbon’

Entering data

Creating basic formulas

Selecting cells

Working with workbooks

Viewing & printing

Date:January 16, 2025

Time:9:00 a.m. – Noon

InstructorHeather Lyon

Add/drop course deadline
2025-01-17 00:00 - 23:59

Winter Registration closes
2025-01-17 00:00 - 23:59

PROJECT MONITORING AND CONTROL
2025-01-20 09:00 - 16:00
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:January 20, 2025

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

Cost:$350.00

Instructor:Janet Dean

MANAGING AND ADMINISTERING CONTRACTS, JOINTS VENTURES AND PARTNERSHIPS
2025-01-21 09:00 - 16:00
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:January 21, 2025

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

Cost:$350.00

Instructor:Janet Dean

QUALITY METRICS FOR PROJECTS
2025-01-22 09:00 - 16:00
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

Date:January 22, 2025

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

Cost:$350.00

Instructor:Janet Dean

EFFECTIVE PREPARATION AND START-UP OF PROJECTS
2025-01-23 09:00 - 16:00
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:January 23, 2025

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

Cost:$350.00

Instructor:Janet Dean

PMP CERTIFICATION PREPARATION
2025-01-24 09:00 - 16:00
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 a personal strategy for passing the exam.

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

Date:January 24, 2025

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

Cost:$350.00

Instructor:Janet Dean

PowerPoint - Online
2025-01-28 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 28, 2025

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

Cost:$350.00

Instructor:Heather Lyon

Formulas & Functions CMPT 0013 - Online
2025-01-30 09:00 - 12:00
In this three-hour session, learn how to set up formulas and functions to get the Excel program to do the math for you. Topics include:

Creating and editing formulas

Mathematical operators

Common functions

Conditional functions

Absolute & relative cell references

Protecting your workbook

Date:January 30, 2025

Time:9:00 a.m. – Noon

Cost:$175.00

Instructor:Heather Lyon

Medical Terminology – In Person in Yellowknife
2025-02-04 18:00 - 21:00
Medical Terminology – In Person in Yellowknife

This course is a comprehensive introduction to medical terminology. The course will have an emphasis on medial 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.

This course will be delivered face to face at Yellowknife Campus.

For information/registration please contact Karen Horn at khorn@auroracollege.nt.ca

Date: Tuesday Evenings, February 4 – May 13, 2025Time: 6-9 pmInstructor: Lesia Lucan

Tuition: $545.00

Text: Medical Terminology A Living Language – Cost $110 plus GST
