Teacher FAQ

Short answers for workbook connection, roster sync, practice data wipe, and the Unsynced Sheet Writes queue. Need more help? Contact admin@ctsosupport.org or visit ctsosupport.org.

How do I change the email on my account to my school email?

If you originally registered for CTSO WorkReady with a personal email and would like to switch to your school email, please contact BCA support before changing how you sign in.

Your approved email address is used to identify your CTSO WorkReady account and connect you with the correct program setup. BCA can update your approved email and, when necessary, make sure your existing account settings stay associated with the new address.

Once the change is complete, sign out of CTSO WorkReady and sign back in using your school Google or Microsoft account.

Do not create a second beta request just to change your email address. Contact BCA support and we can update the existing account instead.

How do I connect my teacher workbook securely?

1. Open Settings → Database Backend and save your Google Apps Script web app URL.
2. Copy the Webhook secret shown in Settings (after the URL is saved or after Test Connection).
3. In your teacher copy of the spreadsheet, open the Apps Script menu Set WorkReady Webhook Secret and paste that same secret.
4. You should see: “Authenticated WorkReady POSTs are now required.”
5. Redeploy is not required for Script Properties changes (the secret). Redeploy only when you update the Apps Script code.

Never put the secret on the master template — only on each teacher’s own spreadsheet copy.

What is the difference between Pull and Push roster sync?

• Pull roster into WorkReady — workbook → WorkReady (sheet is the source).
• Push roster to teacher workbook — WorkReady → workbook (for a new or replacement connection).

Push may queue students when Apps Script is slow. Queued rows appear under Unsynced Sheet Writes on the teacher dashboard until they deliver.

Do I have to click “Retry pending syncs”?

Usually no. WorkReady retries pending workbook writes automatically in the background (a small batch at a time so the site stays responsive). The Retry pending syncs button is a backup when you want to push a batch right away or after fixing the webhook URL / secret.

Check the Last error column if rows stay pending:

• Queued for teacher workbook sync. — waiting for the next automatic (or manual) attempt.
• Teacher database request timed out… — Apps Script was slow (often a cold start). Wait a moment or retry; use Test Connection if it keeps happening.
• Auth / secret errors — confirm the webhook secret in Settings matches the Script Property on the teacher spreadsheet.

What should I do if syncs keep failing?

1. Settings → Database Backend → Test Connection.
2. Confirm the web app URL is the current deployment (/macros/s/…/exec).
3. Confirm the webhook secret matches Apps Script → Set WorkReady Webhook Secret.
4. Open the dashboard Unsynced section and use Retry pending syncs once after fixing connection issues.

How do I use “Clear All Student Program Data”?

This beta tool clears students from WorkReady and tries to clear matching rows in your connected teacher spreadsheet. The spreadsheet wipe is intentionally locked down so a live four-year workbook cannot be erased by accident.

Important: allow_remote_program_reset is not on the WorkReady Settings page (/dpospz/settings). It lives on the Settings tab inside your Google Sheets teacher workbook.

1. Open your teacher spreadsheet copy (the one whose Web App URL is connected in WorkReady).
2. Open the sheet tab named Settings (bottom of the spreadsheet).
3. Find the row allow_remote_program_reset. If it is missing, run CTSO WorkReady → 1. Initialize or Repair Template, then look again.
4. Set the Value cell to yes (default is no).
5. In WorkReady → Settings → Developer / Test Utilities, click Clear All Student Program Data and confirm.
6. When finished, set allow_remote_program_reset back to no.

Prefer safer cleanup when you only need sample shifts: spreadsheet menu CTSO WorkReady → 2. Clear Sample/Test Shift Rows. Your spreadsheet must be on Apps Script 1.2.2+ for the remote wipe gates to work. If WorkReady says remote reset is disabled, the spreadsheet setting is still no (or the script is older than 1.2.2).