Intro to Excel CMPT 0012 - Online
2024-04-23 09:00 - 12:00 (America/Inuvik)
This 3-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

InstructorHeather Lyon

Teaching and Learning at a Distance - Online / Multi-day
2024-04-23 19:00 - 22:00, 2024-04-30 19:00 - 22:00, 2024-05-07 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

Robert’s Rules of Order - Online
2024-04-25 09:00 - 16:00
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

InstructorHeather Lyon

Formulas & Functions CMPT 0013 - Online
2024-05-07 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

InstructorHeather Lyon

Business Administration Math Entry Course (MATH 0023) - Online / Mutli-Day
2024-05-07 18:00 - 19:30, 2024-05-09 18:00 - 19:30, 2024-05-14 18:00 - 19:30, 2024-05-16 18:00 - 19:30, 2024-05-21 18:00 - 19:30, 2024-05-23 18:00 - 19:30, 2024-05-28 18:00 - 19:30
Are you interested in attending the Business Administration Program but are missing the Math prerequisite or need to refresh your math skills?

This course will introduce students to the mathematical principles needed to be successful in the Business Administration Program. It will act as a pathway to admittance for students who may not currently meet the admission requirements or wish to refresh their skills before starting the program. The course will cover the concepts underlying math theories, principles, and usage. These fundamental skills are necessary to be successful in the BA Program for the development of numerical literacy.

PrerequisitesEnglish 150 or English 30-2, Math 145 or Math 20-2 or 20-1

DatesMay 7, 2024 – June 20, 2024

TimeTuesday and Thursday Evenings from 6:00 p.m. – 7:30 p.m.

LocationOnline via TEAMS/Moodle

TextbookFoundations of Mathematics with Geometry, Trigonometry, and Statistics, Third Edition, by Kugathasan & Kox (Publisher: Vretta).

InstructorJoanna Hartley

BUSI 0255 Small and Medium Sized Enterprises for Local Economic Development in the Extractive Sector - Multi-Day / Online
2024-05-07 18:00 - 21:00, 2024-05-09 18:00 - 21:00, 2024-05-11 09:00 - 12:00, 2024-05-14 18:00 - 21:00, 2024-05-16 18:00 - 21:00, 2024-05-21 18:00 - 21:00, 2024-05-23 18:00 - 21:00, 2024-05-25 09:00 - 12:00 and 1 more date
Are you interested in starting your own business in the extractive sector? This is your opportunity to get started developing your own business plan with real-world examples and mentoring! Industry experts share their knowledge, expertise and advice as guest speakers throughout the course.

Small and Medium Sized Enterprises (SMEs) for Local Economic Development in the Extractive Sector, aims to provide practical business/entrepreneurial skills for those looking to enter or expand their presence in the mining and petroleum supply chains. The focus is on understanding the context of business, finance, marketing and operations for these SMEs, with an emphasis on the local community. Learn to integrate SMEs into the supply chain at any phase of the mine life cycle including exploration, development, production, and reclamation. Guest Speakers include:

Sandy Sanderson – Owner Askiy Matts – Fort McMurray – Oil Sector

Tom Hoefer – Special Advisor to NWT & Nunuvut Chamber of Mines, professional Geologist,

Ben Nind – Executive Director – Giant Mine Oversight Board

Garett Cochrane et al. – Parsons Inc. – contractors of the remediation at Giant Mine

Paul Gruner – CEO, Tlicho Investment Group

Jason Snaggs – Superintendent, Logistics, Warehouse & Airport, Gahcho Kué Mine

Mark Lewis – CEO, Det’on Cho Management LP

Loren Coutts – Aurora College

Paul McLean – CanNor

DATESMay 7, 2024 – June 4, 2024

TIMESTuesdays from 6 PM – 9 PM (May 7, 14, 21, 28 and June 4)Thursday from 6 PM – 9 PM (May 9, 16, 23, 30)Saturdays from 9 AM – Noon (May 11, 25, & June 1)

INSTRUCTORDr. Kim Lemky

TEXTBOOKBalderson, D.W., & Mombourquette, P. (2020). Canadian Entrepreneurship and Small Business Management. 11th Edition. McGraw – Hill.Or online e-book (student can order these online)

LOCATIONOnline via Teams

CAEd - Integration of Concepts in Adult Education/Capstone ADED 0138 Course - Online / Multi-Day
2024-05-08 19:00 - 22:00, 2024-05-15 19:00 - 22:00, 2024-05-22 19:00 - 22:00, 2024-05-29 19:00 - 22:00
This course is intended for individuals that have completed all other components of the CAEd program.

This is the capstone course of the CAEd program. Your project will focus on the integration of educational philosophies, theories, and practices explored throughout the program, highlighting your development as an adult educator.

You have the option to complete a practicum, an e-portfolio documenting your teaching practice development, a scholarship of teaching and learning research project, a capstone paper, or other assignment as determined with the instructor.

Dates: May 8, 15, 22, 29, June 5, 12, 19, 26

Location: Virtual classroom held on Teams

Add/Drop Deadline Spring 2024 Term
2024-05-17 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.

Formatting the Worksheet CMPT 0014 - Online
2024-05-21 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

InstructorHeather Lyon

BOOKKEEPER & FINANCIAL OFFICER TRAINING PART ONE – INTRO TO ACCOUNTING - Online / Multi-Day
2024-05-27 09:00 - 2024-05-29 16:00
This 3-day course looks at the theory and the steps involved in preparing books for a business or organization in the NWT. Using an accounting simulation consisting of actual source documents from a fictitious business, students will enter one month of financial transactions for a small company using the five-journal system. This course will show students who use a computerized software program what is actually happening behind the entry screens on their computer and will give them a better overall understanding of the accounting process. Please note: This class includes intensive, hands-on work that will require your full attention. It is strongly suggested that if you are participating in these on-line sessions, you take the class in an environment where you can focus solely on the class. You will need a calculator or adding machine for this session.

Course objectivesAfter completing this course, you will be able to:

Better understand the accounting process used in the 5 Journal manual accounting system

Be familiar with the steps involved in the annual accounting cycle

Understand the five account categories used in accounting

Understand Debits & Credits

DatesMay 27 – 29, 2024

Time9:00 a.m. – 4:00 p.m.

LocationOnline

InstructorHeather Lyon

Course Withdrawal 1/3 of Course Spring 2024 Term
2024-05-28 00:00 - 23:59
50% refund to student & no academic penalty.
