School operations
CCA Cert Splitter
Windows Excel prototype for splitting School Cockpit CCA certificates by student
Get it with String ID
Checking your String ID sign-in…
Free for String ID members. Sign in or join to download it here.
Sign in or join String IDThe download needs a confirmed email on your String ID account. Add one, then come back here.
Add an email on String IDSigned in as
Downloads are recorded against your String ID account and visible to String admins.
About the product
Prepare individual student CCA records for review and soft-copy distribution, instead of printing entire class or level batches.
- Made by
- Irantaffy (HOD MA @ Jurongville Sec)
- For
- educators
- Topics
- cca, school-cockpit, certificates, excel, outlook
- Country
- Singapore
What this does
Takes a CCA certificate PDF exported from School Cockpit and separates it into individual student files, using each student's name and class as the file label.
Version 8 can also prepare Outlook/CES drafts with individual attachments and extract CCA record information into a spreadsheet-style table for follow-up tracking or analysis.
Availability
Free for String ID members. Sign in or join on this page, then download the encrypted Windows Excel prototype ZIP here.
The unzip password appears when your download starts. You can also have the full instructions and the password emailed to the address confirmed on your String ID account.
How it works today
The current release is an Excel macro workbook for Windows. It uses bundled PDF tools to read the PDF text, identify student page ranges, split or render pages, and organise files by class.
Users should keep the workbook, template, PDF utilities, and source CCA certificate PDF in the same folder before testing.
Before you use it
Use dummy or sample CCA certificate PDFs first. The package handles student-level records and should not be tested on live student data until your school's data handling requirements are clear.
Detailed instructions
CCA Certificate Splitter v8 · September 2026
Before you start
- Download the CCA Certificate PDF from School Cockpit and save it in the same folder as the Excel workbook and bundled tools.
- Copy student email addresses to the Email sheet.
Steps
- Select the certificate PDF
Click Select CCA Cert PDF and select the PDF you downloaded.
- Review student names
Review the Names in column C and update them if necessary.
- Split the certificates
For PDF files, click Split PDF. Files are saved in class subfolders, and the folder opens automatically.
For email/CES, click Split to EMail. Word files are saved in class subfolders, and the folder opens automatically.
- Prepare email drafts
Write the message and title in the Message tab, then click Draft Email. Emails are created as drafts in CES. Adjust cell A5 as required.
- Review and send drafts
Check recipients, messages and attachments before sending. Click Send all Draft Emails only when ready: it sends all emails in your Draft folder, not just the CCA drafts.
- Extract student data
Click Extract Data to extract all student data to the Student Tab.
Important
- Do not change any tabs or remove other data in the workbook.
- Existing output files are overwritten. Keep a backup before running the splitter again.