AITP Enrolment CrossChecker

Upload your Admin & Teaching Staff Enrolment List and Teaching Staff List to analyse data matches and unique records.

File 1: Enrolment List

Admin and Teaching Staff Enrolment List
(.xlsx, .xls)

Upload File 1

File 2: Teaching Staff List

Teaching and Instructing Staff List
(.xlsx, .xls)

Upload File 2

File 3: Department Data

Department Records List
(.xlsx, .xls)

Upload File 3

Comparison Results

Data Analysis

File 1 Null Values

In "m1_select_session" column

File 2 Null Values

In "email" column

File 2 Duplicates

Duplicate emails

Filtered Comparison Results

Comparing File 1 (CNA) with File 2 (Email) after removing null values

Unique to File 1 (CNA)

Common Records

Unique to File 2 (Email)

Non-Filtered Comparison Results

Comparing File 1 (CNA) with File 2 (Email) including all records

Unique to File 1 (CNA)

Common Records

Unique to File 2 (Email)

File 3 Analysis Results

M1 Status Summary

Completed

Records with "completed" status

Enrolled

Records with "enrolled" status

Not Enrolled

Records with "not enrolled" status

Records Removed

THEI department records

Completed Records Comparison (File 3 vs File 2)

Comparing "Completed" records from File 3 (CNA) with File 2 (EMAIL)

Unique to File 3 (CNA)

Common Records

Unique to File 2 (Email)

First Module Date Monthly Breakdown (Common Records)

Counting "First Module Date" by month for common records (Completed)

No data available yet

M5 Status Summary

M5 = "Y" Records

Records with M5 value "Y"

M5 ≠ "Y" Records

Records without M5 value "Y"

M5 (Y) Records Comparison (File 3 vs File 2)

Comparing "M5 = Y" records from File 3 (CNA) with File 2 (EMAIL)

Unique to File 3 (CNA)

Common Records

Unique to File 2 (Email)

M5 ≠ "Y" in Common Records (Completed)

Checking common records from Completed comparison where M5 is not equal to "Y"

M5 ≠ "Y" Records

Common records with M5 not equal to Y

M5 = "Y" Records

Common records with M5 equal to Y

Completion Date Monthly Breakdown (Common Records)

Counting "Completion Date" by month for common records (M5 = Y)

No data available yet