EduCampus Elite: a 30-sheet Excel school dashboard and 30-page planner for attendance, grades, fees, staff and timetables, with early alerts for at-risk students.
EduCampus Elite: The School Dashboard That Spots Struggling Students Before Report Card Day
EduCampus Elite is a 30-sheet Excel school management dashboard with a 30-page printable and tablet planner. It connects school administration (students, admissions, attendance, fees, staff), student performance (gradebook, analytics, at-risk alerts, report cards) and academic management (timetable, syllabus, lesson plans, exams, calendar). You enter data once and every sheet, chart and alert updates automatically, in any country and currency.
- One workbook replaces separate attendance registers, mark sheets, fee ledgers, leave records and timetable files.
- The At-Risk Student Index turns attendance, grades and homework into one 0–100 score with a green, amber or red flag.
- A live Dashboard shows 8 KPIs and 9 action alerts, so a principal knows what to fix in under 10 minutes.
- Settings let any school set its own currency, grading scale, classes, subjects and targets.
- A 30-page undated planner covers the same jobs on paper or on a tablet.
What Is EduCampus Elite? A School Management System in One Excel File
EduCampus Elite is a school management dashboard template. Every sheet is linked: you type a student into the register once, and that student appears on the attendance grid, gradebook, assignment tracker, fee status sheet and At-Risk Index without retyping.
It sits between two familiar tools. A Student Information System (SIS) stores records for the whole school; a Learning Management System (LMS) such as Google Classroom or Moodle delivers lessons. EduCampus Elite turns the data you already collect into decisions: which class needs intervention, which fees are overdue and which teacher is overloaded. The EduCampus Elite Excel and PDF bundle works in Microsoft Excel on Windows, Mac, iPad and Android, and in Google Sheets.
What’s Inside the EduCampus Elite Bundle
Overview (4 sheets)
Cover with tap buttons, Start Here guide with a linked index, Settings, and the live Dashboard with KPIs, alerts and charts.
Students (8 sheets)
Student register, admissions funnel, daily attendance, attendance summary, At-Risk Index, parent communication log and behaviour & wellbeing log.
Academics (9 sheets)
Gradebook, performance analytics, exam analysis, assignment tracker, exam schedule, report card, timetable, syllabus coverage and lesson planner.
Finance (4 sheets)
Fee structure, fee payments log, fee status with unpaid list, and budget vs expenses with net position.
Staff (3 sheets)
Staff directory, leave tracker with automatic balances, and teacher workload with overload flags.
Operations (3 sheets)
Self-building 12-month academic calendar, events & activities, and inventory with reorder alerts.
Plus a 30-page planner PDF: undated A4 landscape pages (Letter-friendly) with tap-to-jump side tabs for GoodNotes, Notability or Xodo. It includes an attendance register, gradebook, At-Risk worksheet, support plan, parent meeting notes, report card, fee registers, timetable, lesson plan, event planner and a certificate of achievement.
Who Should Use It — and Who Shouldn’t
Great fit
Private and independent schools, tutoring and coaching centres, and homeschool co-ops with up to about 300 students.
Good fit
Heads of department, counsellors and teachers who need a personal tracker alongside a district system.
Pick a full SIS
Multi-campus groups, or schools needing parent portals, online fee payment or state reporting integrations.
How the Three Modules Work
1. School Administration Dashboard
- Daily attendance grid: type P, A, L or H; weekends shade automatically and every student gets an attendance % and a chronic-absence flag.
- Fee management: due-to-date per student, payments pulled from the receipt log, Paid / Partial / Unpaid status and collection rate by class.
- Staff overview: leave balances against your entitlement and a load % for every teacher.
- Admissions: enquiry-to-enrolment funnel with a conversion rate.
2. Student Performance Dashboard
- Gradebook: marks for six subjects with automatic average, letter grade, Pass / Support / Fail result and class rank.
- Performance analytics: subject averages by class, pass rates, top performer per class and grade distribution.
- Report card: pick a Student ID and a printable one-page report fills itself, including attendance and risk status.
3. Academic Management Dashboard
- Timetable: dropdown grid with a check that compares scheduled vs required periods per subject.
- Syllabus coverage: planned vs completed chapters with Behind / On track / Ahead status.
- Academic calendar: 12 months build from your year start date; holidays, exams and events colour themselves.
The At-Risk Student Index: Our Original Early-Warning Formula
Most mark sheets only show a student is failing after the exam. The Digital Idea Tool Team built a weighted index from three signals teachers already record, so a struggling learner surfaces while there is still time to help.
How the score is calculated
Each signal is measured as a gap below target, expressed as a percentage of that target, then weighted:
- Attendance (target 90%) — weight 40%
- Average grade (target 60%) — weight 35%
- Assignment completion (target 85%) — weight 25%
With attendance in B2, average grade in C2 and assignment completion in D2 (all as whole-number percentages), the formula is:
=ROUND(0.4*MAX(0,90-B2)/90*100 + 0.35*MAX(0,60-C2)/60*100 + 0.25*MAX(0,85-D2)/85*100, 1)
And the status flag in F2:
=IF(E2>=25,"Red",IF(E2>=10,"Amber","Green"))
These are starting points. In EduCampus Elite you change every target, weight and threshold in Settings.
Worked example: five students, one class
| Student | Attendance | Avg grade | Assignments | Risk index | Status |
|---|---|---|---|---|---|
| Student A | 96% | 78% | 95% | 0.0 | Green |
| Student B | 84% | 62% | 80% | 4.1 | Green |
| Student E | 91% | 55% | 88% | 2.9 | Green |
| Student C | 72% | 51% | 60% | 20.6 | Amber |
| Student D | 61% | 38% | 42% | 38.4 | Red |
What this reveals: Student E’s 55% average looks worrying on a plain mark sheet, but strong attendance and homework keep the risk low — a tutoring nudge is enough. Student C lands in amber because missing assignments are the earliest warning sign. Student D needs a parent meeting this week, not after the term exam.
You don’t have to build this yourself: download the ready-made At-Risk Index workbook, which also suggests an action and lets you assign an owner and follow-up date for each student.
5 KPIs Every Principal Should Read Every Monday
| KPI | Formula | Suggested healthy range |
|---|---|---|
| Average daily attendance | Present student-days ÷ (present + absent) student-days | 93% or higher |
| Chronic absence rate | Students missing 10%+ of days ÷ total students | Under 10% |
| Red-flag students | Count of students with risk index 25+ | Under 5% of class |
| Fee collection rate | Fees collected ÷ net fees due to date | 90% or higher by month-end |
| Syllabus coverage | Chapters completed ÷ chapters planned to date | Within 10% of plan |
Example: a school that billed 1,250,000 in term fees and collected 1,087,500 has a collection rate of 87.0%, so the unpaid list becomes the first job of the week. The 10%-of-days threshold for chronic absence follows the definition widely used by U.S. education agencies. All five KPIs appear as tiles on the EduCampus Elite Dashboard.
How to Set Up EduCampus Elite in 60 Minutes
- Settings (10 min): school name, academic year and start date, currency, classes, subjects, grading scale and early-warning targets.
- Students (15 min): paste your register. Every student sheet fills itself from this list.
- Staff (10 min): add staff, roles and maximum periods per week.
- Fee Structure (10 min): enter fees per class and term, then set “terms billed” on Fee Status.
- Timetable & Syllabus (15 min): fill the weekly grid and list chapters per subject.
- Weekly routine (10 min every Monday): update attendance, marks and assignments, then read the Dashboard alerts.
Sample data for 60 students and 18 staff is included, so you can see every chart working before you add your own. Grab the 30-sheet EduCampus Elite template and follow the Start Here sheet step by step.
EduCampus Elite vs Paid School ERP Software
| Factor | EduCampus Elite | Cloud school ERP / SIS |
|---|---|---|
| Cost model | One-time purchase | Usually a recurring per-student or per-school fee |
| Setup time | About an hour | Days to weeks, often with onboarding |
| Customisation | Edit any target, list or chart | Limited to vendor settings |
| Data location | Your device or your own cloud drive | Vendor’s servers |
| Paper and tablet planner | 30-page PDF included | Rarely included |
| Parent portal & online payments | Not included | Typically included |
| Best for | Small–mid schools, departments, tutoring centres | Large schools and multi-campus groups |
Student Data Privacy: FERPA, GDPR and India’s DPDP Act
A school dashboard holds personal information about children, so privacy rules apply wherever you operate. In the United States, the Family Educational Rights and Privacy Act (FERPA) guidance from the U.S. Department of Education governs education records. In the UK and EU, the European Commission’s GDPR data protection rules treat children’s data as needing extra care. In India, the Digital Personal Data Protection Act, 2023 requires verifiable parental consent for processing children’s data.
Practical habits: password-protect the workbook, store it on a school-managed drive rather than personal email, share reports using student IDs, and delete records you no longer need.
Ready to run your school from one screen?
30 connected Excel sheets plus a 30-page printable and tablet planner, set up for any country in about an hour.
Get EduCampus Elite on Gumroad See all Digital Idea Tool dashboardsFrequently Asked Questions
Does EduCampus Elite work in Google Sheets?
Yes. It uses standard formulas such as COUNTIFS, SUMIF, INDEX and MATCH, which work in Excel and Google Sheets. Some chart styling can look slightly different after import.
How many students and staff does it hold?
The workbook is ready for 300 students and 150 staff, with room for hundreds of payments, expenses and log entries. Larger schools can extend the rows or use one file per section.
Can I use it outside the USA?
Yes. You set your own currency, grading scale, classes, subjects and targets in Settings, and dates display as 01-Aug-2026 to avoid day/month confusion.
Can teachers use it without spreadsheet skills?
Yes. Teachers type only into the light-yellow cells or pick from dropdowns; formulas and charts are already built. One staff member should own Settings.
What is a good attendance rate for a school?
Many schools aim for an average daily attendance of 93–95%. Any student missing 10% or more of school days is commonly treated as chronically absent.
Can I change the At-Risk Index weights?
Yes. The 40/35/25 weights, the 90/60/85 targets and the red and amber thresholds are all editable in Settings.
Quick Quiz: Test Your School Dashboard Know-How
Tap each question to reveal the answer.
1. What three areas does EduCampus Elite combine?
School administration, student performance and academic management.
2. How many sheets are in the Excel workbook?
30 connected sheets, plus a 30-page planner PDF.
3. Which signal carries the highest weight in the At-Risk Index?
Attendance, at 40%.
4. What risk score triggers a red flag?
25 or higher.
5. A school bills 1,250,000 and collects 1,087,500. What is the collection rate?
87.0%.
6. What attendance threshold commonly defines chronic absence?
Missing 10% or more of school days.
7. What is the difference between an SIS and an LMS?
An SIS stores student records; an LMS delivers lessons and assignments.
8. Where do you set your currency and grading scale?
On the Settings sheet; every other sheet reads from it.
9. Which U.S. law governs student education records?
FERPA, the Family Educational Rights and Privacy Act.
10. When should a school choose a full SIS instead?
For multi-campus groups or when parent portals, online payments or state reporting integrations are required.
This article is for general information and does not constitute legal, financial or educational-compliance advice. Benchmarks, targets and the At-Risk Student Index are suggested starting points; adapt them to your school’s policies. Worked examples use illustrative sample data, not real students.
EduCampus Elite is created and sold by Digital Idea Tool. Schools remain responsible for complying with FERPA, GDPR, the DPDP Act and other local data protection laws when storing student information.
Last reviewed: November 1, 2026. We update this guide when benchmarks, laws or product features change.
📝 Key Takeaways & Action Notes
Jot down insights, next steps, or thoughts from this post. Your notes save automatically in your browser.
- What is the #1 breakthrough insight you took away today?
- What is one concrete action you will take in the next 24 hours?
- What questions or ideas do you want to research further?
Stay ahead with exclusive updates
Join our community. Get curated industry trends, actionable guides, and fresh resources delivered straight to your inbox.