Aurora College

Excel Extras CMPT 0016 - Online
2024-12-17 09:00 - 12:00 (America/Inuvik)
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, 2025-02-05 19:00 - 22:00, 2025-02-12 19:00 - 22:00, 2025-02-19 19:00 - 22:00, 2025-02-26 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, 2025-02-11 18:00 - 21:00, 2025-02-18 18:00 - 21:00, 2025-02-25 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

Course Withdrawal (50% refund, no academic penalty)
2025-02-07 00:00 - 23:59

Board of Governors meeting - Thursday, February 20, 2025
2025-02-20 09:00 - 14: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 12:00 PM (noon) on Monday, February 17. The question or presentation must be submitted either electronically or in hard copy by that date and time as well. Delegations are limited to 15 minutes with a maximum of four delegations per meeting. The Board will not make decisions about an issue brought forward by a delegation at the same meeting at which it is presented. Questions about the Board of Governors meeting may also be addressed to the contact email.

Delegation contact, or:

To receive meeting link and agenda:

Heather Meacock

Executive Assistant to the President

Email: hmeacock@auroracollege.ca

Location: Virtual Meeting

Date: Thursday, February 20, 2025

Time: 9:00 AM – 2:00 PM (Delegations – 9:15-10:15 AM, if required)

Microsoft Teams meeting

Join on your computer, mobile app or room device

Click here to join the meeting

Meeting ID: 255 657 449 017Passcode: [REDACTED]

Download Teams | Join on the web

Or call in (audio only)

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

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

Phone Conference ID: 979 482 928#

Réunion du Conseil des gouverneurs

Toute personne ou tout groupe souhaitant s’adresser, poser une question ou présenter un exposé au Conseil des gouverneurs doit en faire la demande par écrit aux coordonnées ci-dessous au plus tard le lundi 17 février, à midi. 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 quatre délégations et chacune aura un temps de présentation limité à 15 minutes. Le Conseil ne prendra pas de décisions concernant une question soulevée par une délégation à la réunion à laquelle elle a été soulevée. Les questions relatives à la réunion du Conseil peuvent être envoyées par courriel à l’adresse fournie.

Coordonnées pour les délégations ou Pour obtenir un lien pour assister à la réunion, écrivez à :

Heather Meacock

Courriel : hmeacock@auroracollege.ca

Lieu : Réunion virtuelle

Date : Jeudi, 20 fevrier 2025

Heure : 9 h 00 – 14 h 00 (Délégations – 9 h 15 – 10 h 15)

Writing Effective Proposals – MGMT 0011 – Online
2025-02-24 09:00 - 2025-02-25 16:00
This two-day course is designed to teach students how to write an effective proposal, whether to obtain work for a business or funding for an organization. The steps involved are covered from obtaining the needed information to prepare the proposal right to the layout of the final document. Through a combination of lecture and hands-on work, students will work through the development and preparation of an actual proposal.

Date: February 24 & 25, 2025Time: 9am to 4pmCost: $600Instructor: Heather Lyon

Course Withdrawal (no refund, no academic penalty)
2025-02-25 00:00 - 23:59

DS Course Withdrawal (50% refund, no academic penalty)
2025-02-27 00:00 - 23:59

Formatting the Worksheet CMPT 0014 - Online
2025-02-27 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 three-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:February 27, 2025

Time:9:00 a.m. – Noon

Cost:$175.00

Instructor:Heather Lyon
