openmasu
solutions · education
Courses, students and sessions in one base your whole staff shares.
Keep courses, cohorts, enrolments and grant projects as linked tables. Enquiries arrive through a public form, sessions sit on a calendar, and roles decide who can edit student data, hosted in the EU.
- Public enrolment form that creates records live
- Calendar and timeline views for sessions and terms
- Viewer and commenter roles for read-only staff
| Student | Cohort | Received | Fee | Status | |
|---|---|---|---|---|---|
| Laura Benton | [email protected] | Data basics · Jan | Oct 14 | $480 | New enquiry |
| Omar Haddad | [email protected] | UX design · Feb | Oct 15 | $620 | Placement test |
| Sofia Marin | [email protected] | Data basics · Jan | Oct 16 | $480 | Offer sent |
| Daniel Okafor | [email protected] | Spanish B1 · Nov | Oct 17 | $350 | Enrolled |
| Mia Lindqvist | [email protected] | UX design · Feb | Oct 18 | $620 | Waiting list |
Everyday workflows
Enquiries and enrolments from one public form
Share a public form on your website. Each submission lands in «Enrolments» as a new record with name, email and the course picked from a single select. Admissions works a kanban by «Status», dragging cards from New enquiry to Enrolled, and links each student to their cohort.
Cohorts linked to courses, seats counted at a glance
«Courses» holds the syllabus and price; «Cohorts» links to a course and has «Start», «End» and «Capacity». Group the enrolments grid by cohort and the summary bar counts students per group, so you see which cohorts are full before you send another offer.
Session schedule on a shared calendar
A «Sessions» table with a date and time, room and teacher (a single select of names) feeds a week calendar. Drag a class to another day when a room changes and every colleague with the base open sees it instantly. A timeline of cohorts shows how terms overlap.
Grants and projects with deadlines that flag themselves
Track each grant with «Funder», «Amount», «Spent» and «Report due». A formula {Amount} - {Spent} shows what is left, and IF(IS_BEFORE({Report due}, TODAY()), "Overdue", "") marks late reports. A view filtered «Status is not Closed» sorted by due date is your weekly check.
Careful with student data
Give teachers the commenter role so they can read records and leave notes with @mentions without editing them; give office staff editor. Every record keeps a field-by-field change history, and the data lives on servers in Germany, in the EU.
Views & structure
Key views
- Enrolment form Public link for enquiries; each answer becomes a record in «Enrolments».
- Admissions Move each applicant from enquiry to enrolled by dragging the card.
- Sessions this week See classes by day and time, and reschedule by dragging.
- Cohorts by term Spot overlapping cohorts and gaps between terms.
- Grants due Open grants sorted by report date, with remaining budget totaled.
Recommended fields
- Cohort (Link to another record) Ties each enrolment to a cohort, and each cohort to its course.
- Status (Single select) Admissions stages with colors that drive the kanban.
- Email (Email) Contact address collected straight from the form.
- Session start (Date with time) Places each class on the calendar at the right hour.
- Fee (Currency) Course price per student, totaled in the summary bar.
- Remaining (Formula) {Amount} - {Spent} for each grant, always current.
- Enrolment no. (Autonumber) A unique reference to quote in emails to students.
Your agent over MCP
Connect your own agent (Claude, ChatGPT, Codex or Cursor) over MCP. It can build the base, tidy enrolments and answer questions about cohorts, acting with your token's permissions; its edits appear live and are marked in history.
create_base create_table create_view aggregate_records query_records
Set up your next term in an afternoon
Start with courses and a form, add cohorts and grants when you need them.