Student Intervention Data Spreadsheet
Budget: $250 – $750 USD
I need an Excel workbook that lets me collect and organise everything related to student interventions in one place. The file should give me easy-to-use entry screens (simple tables or a basic form) for:
• Attendance records
• Behaviour reports
• Academic performance
• The actual interventions applied, so that I can later pull these details into individual “student snapshots”.
A clean dashboard or pivot-style summary that filters by student name and instantly shows the above points together will save me hours, so please build that in. I would like the workbook laid out logically, with protected formulas and clear instructions embedded in a hidden or separate tab so colleagues can’t accidentally break anything.
If you know how to automate the snapshot with slicers, pivot tables, or a bit of VBA, let me know—that would be a bonus. Once delivered, I’ll test it with real data; the job is finished when I can enter a new student’s records and generate an accurate one-page summary without manual copy-and-paste.
• Attendance records
• Behaviour reports
• Academic performance
• The actual interventions applied, so that I can later pull these details into individual “student snapshots”.
A clean dashboard or pivot-style summary that filters by student name and instantly shows the above points together will save me hours, so please build that in. I would like the workbook laid out logically, with protected formulas and clear instructions embedded in a hidden or separate tab so colleagues can’t accidentally break anything.
If you know how to automate the snapshot with slicers, pivot tables, or a bit of VBA, let me know—that would be a bonus. Once delivered, I’ll test it with real data; the job is finished when I can enter a new student’s records and generate an accurate one-page summary without manual copy-and-paste.