Student & Course Registry template
Courses with capacity, fee and taught hours; students with a SEPA mandate for the fee; and the enrolment joining them, carrying attendance and the assessment mark — with grade and pass/fail computed from that mark rather than typed beside it. Fill rate and average mark roll up per course.
Tables
Courses
Course code, Course, Department, Level, Delivery, Tutor, Capacity, Fee, Taught hours, Starts, Ends, Enrolments, Enrolled, Average mark and 4 more
Students
Student number, Name, Date of birth, Email, Phone, Funding, Fee mandate IBAN, Enrolments, Courses taken, Average mark, Average attendance %, Notes
Enrolments
Enrolment, Student, Student record, Funding, Course, Course record, Course fee, State, Enrolled on, Attendance %, Mark, Grade, Outcome, Notes
Views
- Enrolment board (kanban)
- All enrolments (grid)
- Marks by course (chart)
- Attendance concerns (grid)
- Course catalogue (grid)
- Course calendar (calendar)
- Academic year (timeline)
- By department (kanban)
- Student cards (gallery)
Forms
- Apply for a course
Automations
- Notify the registry on a new application
- Email the tutor when a mark is entered
- Daily viability check
- “Enrolments” reached “Deferred”
- Daily sweep — still open in “Enrolments”
- Large value in “Attendance %”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.