The Export Subject Choices feature generates a comprehensive Excel-based diagnostic tool containing learner and educator subject data. This export utilizes pivot tables to provide high-level summaries while allowing users to drill down into granular details for academic planning and verification.
My School > Curriculum > Learner Subjects: Export Subject Choices
This export is primarily used for:
Administrative Planning: Managing exam invigilation and venue requirements based on learner volumes.
Timetable Verification: Cross-referencing subject allocations with the yearly timetable.
Data Auditing: Verifying that subject setups are correct before generating termly reports.
Statutory Compliance: Reviewing subject enrollment figures for departmental submissions (e.g., SA-SAMS).
Select the Year and Term for which the data is required.
Learner Type: Choose to export data for Current Learners only or All Learners (which includes learners who have left the school during the selected period).
Click Export.
Download and open the generated Excel workbook.
Enable Editing: Click the yellow "Enable Editing" bar at the top of the Excel sheet to unlock the interactive features.
Navigation: On the Index sheet, click the "Go" link next to the specific report you wish to view.
Summary View: The system displays a pivot table summary of the selected data.
Detail Drill-Down: To view the specific learners or educators making up a total, double-click any numerical value in the pivot table. This action opens a new sheet containing the detailed records for that specific item.
Data Source: Advanced users can access the raw data under the Worksheet tab to create custom formulas or external reports.
Return to Menu: Click the Index tab at the bottom of the workbook to return to the main report list.
Real-Time Snapshot: Every export creates a new, static workbook reflecting the system's state at the exact moment of export. It does not auto-update if changes are made in the d6 system later.
Interactive Architecture: The export uses Excel's native pivot table functionality, allowing for rapid filtering and data grouping without affecting the original dataset in the "Worksheet" tab.
Automated Sheet Generation: When double-clicking summary numbers, Excel automatically generates a new temporary sheet for the detailed list, keeping the main pivot table intact.
User Permissions: This function is only visible to users with Excel Export rights.
Reason: These exports contain sensitive personal and academic data. Access must be strictly controlled and assigned by the school's Superuser.
Data Liability: Enabling this feature amends the Agreement between d6 Education and the school.
Reason: Once data is exported to a local device, d6 Education no longer has control over its security. The school assumes full responsibility for the protection and safe-keeping of the information under POPIA/GDPR regulations.
Static Nature of Exports: The workbook is a "snapshot."
Reason: To ensure data integrity during specific planning phases (like exam scheduling), the file remains unchanged even if learner subject choices are updated in d6 after the file was generated.