School operations
Post Sec Ed Posting Compiler
Compile post-secondary posting files into one workbook with yearly snapshots and trends.
Why it’s here
Compiles the post-secondary posting files (JAE JC, JAE Poly, JIE, ITEEAE, PFP and DPP) into one workbook with selected-year snapshots and multi-year trends, replacing manual reconciliation across several file formats each posting cycle.
- Made by
- Koo Tiannuo, Kranji Secondary School
- For
- school-leaders, educators
- Topics
- dataiskoo, palantir-mini, excel
- Country
- Singapore
What this does
Compiles the various post-secondary education (PSE) posting files — JAE (JC), JAE (Poly), PFP, DPP, ITEEAE, JIE — into a single workbook with selected-year snapshots and multi-year trends.
Where to get the raw posting files
The CSV posting files come from the old School Cockpit. Inside the cockpit, search for "posting files" — you'll find the JAE (JC), JAE (Poly), JIE, ITEEAE, and the various PFP / DPP rounds available for download.
How to use
1. Click Open product above (sign in with MOE iCON)
2. Drive zips the folder and you'll get one .zip with the workbook + companion files
3. Extract, open the main file in Excel
4. Drop the CSV posting files (downloaded from the old School Cockpit, see above) into the input folder
5. Click Refresh in Excel
Audience
School Leaders, Year Head Team, ECGC.
Before you download
Download: the link requires MOE iCON sign-in. You will be signed in with your @moe.edu.sg iCON account automatically, or asked to switch if you are on a different account.
Platform: Excel.
Raw files needed: Posting files (CSV).
Latest version: v1.1, 7 May 2026.
First-time Excel / Power BI setup: Excel and Power BI files may hit a Privacy Levels or Macros-disabled error the first time on a fresh SSOE laptop. The One Time Set-up guide is linked from the DataisKoo Tools gallery.
Not on MOE iCON, found a bug, or need a different version? Contact the maker through the form on the DataisKoo Tools gallery.