Illinois Masters Exam Change
- Robert Adach
Driver | Approver | Contributors | Stakeholder |
|---|---|---|---|
Change to IL master exam usage | @Felicia Dennison | @Robert Adach | Exam Services |
Objective | Notify Candidates who have or will register for the Masters exam before 1/1/2022 |
Due date | Sep 15, 2021 |
Key outcomes | Notify all applicable IL Candidates who have registered for their exam Notify all IL candidates potentially registering for the masters exam |
Status | IN PROGRESS |
Problem Statement
ASWB wishes to notify Candidates who have approved to take the Masters exam by the IL board that they may not need to take the exam
ASWB wishes to notify IL Candidates who have registered for, but not taken their Masters exam of their eligibility for a refund of the exam costs.
Scope
Must have:
On-going messaging on the current exam registration (http://datapath.com ) site of the change in IL law.
On-going messaging on the new exam registration site of the change in IL law.
Email message to be sent to registered candidates.
Milestones and deadlines
Milestone | Owner | Deadline | Status |
|---|---|---|---|
Create SQL view for identifying IL records to be notified via email | @Robert Adach | Sep 8, 2021 | DONE |
Create SQL script to update IL records with a note that Candidate was emailed | @Robert Adach | Sep 10, 2021 | Done |
Test SQL view and script for accuracy and deploy view to production. | @Robert Adach | Sep 10, 2021 | Done |
Sample email to be sent to Exam Services for review | @Robert Adach | Sep 8, 2021 | DONE |
Exam Services to review sample list of registered IL Masters candidates (See List of Registered IL Masters Candidates - 2021-09-07_1517.xlsx in Reference Material section below) | @Felicia Dennison | Sep 10, 2021 | DONE |
Notification popup to be launched on the Test registration site | @Robert Adach | Sep 7, 2021 | DONE |
Exam services to provide final email content to IT | @Felicia Dennison | Sep 10, 2021 | done |
Exam Services to review and provide feedback on the popup notification content | @Felicia Dennison | Sep 10, 2021 | DONE |
Notification popup to be launched on the production registration site | @Robert Adach | Sep 13, 2021 | DONE 09/13/2021 at 6:33AM |
Email to be sent to all IL Masters candidates without an exam score who are registered through 9/10/2021 15:32 | @Robert Adach | Sep 13, 2021 | DONE |
Update approval records with a note that email was sent | @Robert Adach | Sep 13, 2021 | DONE |
Email to be sent to all IL Masters candidates without an exam score who registered between 9/10/2021 15:32 and the time when the popup notification was launched | @Robert Adach | Sep 14, 2021 | DONE |
Update approval records with a note that email was sent | @Robert Adach | Sep 13, 2021 | DONE |
Produce final list of Candidates emailed, timesheets, etc. | @Robert Adach | Sep 17, 2021 | not started |
Provide update on number of times popup has been viewed | @Robert Adach | Sep 16, 2021 Sep 23, 2021 Sep 30, 2021 Oct 28, 2021 Nov 18, 2021 Dec 30, 2021 | not started |
Popup Data
Date / Time | Number of views (popups) | Number of Emails received (exampc@aswb.org) (To date) |
|---|---|---|
9/16/2021 | 253 | 125 (with tag) - 114 (with Illinois in subject line) |
9/23/2021 | 666 | 180 (with tag) - 160 (with Illinois in subject line) |
9/30/2021 | 982 | 193 (with tag) - 178 (with Illinois in subject line) |
10/07/2021 (5:30AM) (7 on 107) | 1236 | 228 (with tag) - 205 (with Illinois in subject line) |
10/28/2021 |
|
|
11/18/2021 |
|
|
12/30/2021 |
|
|
Reference materials
Attachments
Scripts
This script will add notes to the account to indicate that we have send the individual an email and should be run AFTER each batch of IL emails.
DECLARE @msg VARCHAR(MAX) = FORMATMESSAGE('%s Sent IL Masters exam change email - RADACH',FORMAT(GETDATE(),'MM/dd/yyyy'))
UPDATE e
SET
[Notes] = CASE
WHEN [Notes] IS NULL THEN @msg
ELSE [Notes] + '; ' + @msg
END
FROM
tblExam e
INNER JOIN dev_ILNotification i ON i.ACTNo = e.ACTNo