PJMT1103 Summary of

Course Schedule Assessments

Week # Week of Topics Asynchronous Activities Assessments Platform Due Date Grade Category Weight Grade Items
Experience Survey Link DC Connect 17-Sep-23 6 Mylab Grader Projects (20%)
1 4-Sep-23 Introduction, Overview & Installations
Intro to Windows #10 MyIT Lab Excel Assignments 40% 4 Gmetrix Tests (10%)
Excel Simulation (10AB) Simulation MyIT Lab 17-Sep-23 6 Simulation Exercises (10%)
2 11-Sep-23 Excel Basics - Workbook Management
Excel Navigation Assignment MyIT Lab 17-Sep-23 Excel Midterm 20% 1 Midterm
Excel Simulation (1AB) Simulation MyIT Lab 24-Sep-23 Project & Visio 6 Project/Visio Assignments
3 18-Sep-23 Excel Basics - Data Management 20%
Excel Data Entry Assignment MyIT Lab 24-Sep-23 Assignments 2 LinkedIN Learning Certificates
Excel Simulation (6AB) Simulation MyIT Lab 01-Oct-23 Project & Visio Final 20% 1 Final Test
4 25-Sep-23 Analyzing Data & Charting Excel Charting Assignment Assignment MyIT Lab 01-Oct-23
GMETRIX Excel #1 GMETRIX 01 Excel Test GMETRIX 01-Oct-23
Excel Simulation (5AB) Simulation MyIT Lab 08-Oct-23
5 2-Oct-23 Functions, Tables & Pivot Tables Excel Tables Assignment Assignment MyIT Lab 08-Oct-23
GMETRIX Excel #2 GMETRIX 02 Excel Test GMETRIX 08-Oct-23
Excel Simulation (7AB) Simulation MyIT Lab 15-Oct-23
6 9-Oct-23 Advance Formulas Excel Formulas Assignment Assignment MyIT Lab 15-Oct-23
GMETRIX Excel #3 GMETRIX 03 Excel Test GMETRIX 15-Oct-23
Excel Simulation (4AB) Simulation MyIT Lab 22-Oct-23
7 16-Oct-23 Financial Formulas Functions & Test Review Excel Functions Assignment Assignment MyIT Lab 22-Oct-23
GMETRIX Excel #4 GMETRIX 04 Excel Test GMETRIX 22-Oct-23
READING WEEK

8 30-Oct-23 Review / MOS TEST GMETRIX Practice Exam Midterm Certiport IN CLASS

Visio #1 Assignment DC Connect 12-Nov-23

9 6-Nov-23 VISIO / MS PROJECT Project #1 Assignment DC Connect 12-Nov-23
Start - LinkedIn Project & Visio LinkedIn
Project #2 Assignment DC Connect 19-Nov-23
10 13-Nov-23 Basics & Scheduling Cont. - LinkedIn Project Cert. LinkedIn
Cont. - LinkedIn Visio Cert. LinkedIn
Project #3 Project #3 DC Connect 26-Nov-23
11 20-Nov-23 Resources & Costs Cont. - LinkedIn Project Cert. LinkedIn
Cont. - LinkedIn Visio Cert. LinkedIn
Project #4 Project #4 DC Connect 03-Dec-23
12 27-Nov-23 Tracking Cont. - LinkedIn Project Cert. LinkedIn
Cont. - LinkedIn Visio Cert. LinkedIn
Project #5 Project #5 DC Connect 10-Dec-23
13 4-Dec-23 Reporting & Review Submit - LinkedIn Project Cert. Submit - LinkedIn Project Cert. DC Connect 15-Dec-23
Submit - LinkedIn Visio Cert. Submit - LinkedIn Visio Cert. DC Connect 15-Dec-23
14 11-Dec-23 Final Test TBC Project/Visio Final TBC IN CLASS