College admissions and academic records: from entrance test to student file
A worked admission round, from written rules and entrance tests to the merit list and the waitlist, and what a student record should hold afterwards.
College management
Where a college office loses time between departments, what to decide before you set up software, and how programs and groups map onto SkoolBro.
Ask a college registrar where a student's details live, and the honest answer is often "in several places". The admissions office has the application file. Accounts keeps a fee ledger. Each department has its own marks spreadsheet, and the library has a register of who borrowed what. When a student switches groups in the third week of a semester, some of those places hear about it and some do not. By exam time, staff spend days matching lists that should have matched all along.
College management software gives every office the same record to work from. It only helps if the college settles a few things first, and the place to start is the hand-offs between offices, because that is where most of the time goes.
Most of the delay in college administration happens at the moment one office passes work to another. A few examples will sound familiar:
None of these is a big job on its own. Added up across a semester, they take weeks of staff time. They also make the figures in reports to the governing board hard to trust, because nobody is sure which list is current.
Before you compare products, write down who keeps which record and what each office waits for from the rest. In a typical college it looks something like this.
| Office | Keeps | Waits for |
|---|---|---|
| Registrar or admissions | Applications, student records, documents, program and group placement | Final marks from departments |
| Accounts | Fee structures, invoices, payments, scholarships, expenses | A current list of enrolled students by program and year |
| Department heads | Faculty, course allocation, timetables, results checks | Attendance and marks for their groups, without asking the registrar |
| Faculty | Attendance and marks for the courses they teach | Correct class lists and their own timetable |
| Students | Nothing official, though they ask about everything | One place to check attendance, results and fees |
The last column is the case for one system. Each office enters its own part once, and everyone else reads it there instead of asking for a copy.
Software follows the shape you give it. A college that skips this step ends up with three spellings of the same program and groups that nobody can find.
List every program, how many years it runs, and how students are split into groups within each year. Pick one naming pattern and use it everywhere, for example "BBA Year 1, Group A". Drop the nicknames that grow up in staff rooms. If two campuses run the same program, decide whether their groups share names or carry the campus in the name.
Write down the dates of each semester and the exam windows inside them. Fees, attendance reports and results all depend on these dates, so agree them before the first invoice goes out.
Departments usually hold faculty, and each program belongs to a department on your organization chart. Agree who owns each kind of record. A common split gives the registrar the student records, accounts the fees and scholarships, and department heads the course allocation and the checking of results.
Decide who may change a mark once a paper is final, who approves a scholarship and who can mark a student as having left. If these rules are written down before you go live, nobody has to argue about them in the middle of exams.
Larkfield College is fictional. It has, for example, two campuses, five departments, eleven programs and about 2,400 students. Before the change, each department kept its own student list, and at the start of every semester the registrar's list and the accounts list disagreed by dozens of names. Most were late admissions and students who had left without telling anyone.
The registrar's office started by importing the student list it already kept in a spreadsheet, then placed each student in a program year and group. Accounts set up one fee structure per program year. Each department added its faculty and the courses they teach. Timetables went in last, once groups and rooms were settled.
The biggest change in the first semester was small and daily. When a student moved from Group A to Group C, one person made one change, and the Group C lecturer saw the student on the register the next morning. Accounts stopped waiting for forwarded lists, because invoices came from the same enrollment the registrar kept. At exam time, the exam office read the marks faculty had entered and locked, so nobody retyped a spreadsheet.
There were costs. Faculty needed a short session on taking attendance on their phones, and two departments argued about group names until the registrar settled it. Neither problem came back in the second semester.
SkoolBro was built to run any kind of education institution, colleges included, from one account. Its screens use school words today, so a college maps its own terms onto them once, at setup.
| In your college | In SkoolBro |
|---|---|
| The college, or a group of colleges | The organization |
| A faculty or college that runs on its own | A school |
| Each site | A campus |
| A program, or one year of a program | A grade |
| A group within that year | A section |
| A course | A subject, marked core or elective |
| A semester | A term inside the academic year |
| Faculty members | Staff, with departments and designations such as lecturer or professor |
With that in place, the registrar runs admissions with tests and interviews and keeps one record per student, with documents, ID numbers stored encrypted and medical notes restricted. The admission round itself is covered in our guide to college admissions and academic records. Faculty take attendance for their groups each day, and the app saves a register taken on a weak connection and sends it later. They enter marks for their own courses, and the exam office locks papers, publishes results and prints report cards, as described in college examination and result management.
Accounts sets semester or yearly fees, approves concessions, records payments and issues receipts. Timetables hold periods and rooms. Staff leave, payroll, the library and inventory sit in the same account, and reports cover each campus with CSV downloads. Students sign in themselves to see their own attendance, timetable, results and fees, and guardians are optional. Access follows each person's role and campus, and lecturers who only teach see the students in the groups they teach. The features overview lists every module, and how SkoolBro keeps each institution's data safe explains the access rules.
A few limits are worth knowing now. Attendance is one register per group per day, so a college that counts attendance lecture by lecture cannot do that in SkoolBro yet. Each student sits in one group per academic year, so a program where every student picks a different mix of electives works more smoothly with a group for each common combination. There are no online exams, students cannot pay fees online through SkoolBro yet, and messages go by email and in the app while SMS and WhatsApp are on the way.
Yes. Each student can have their own login and sees only their own attendance, timetable, exam dates, results and fees.
Not on the student record, where guardians are optional. An admission application asks for at least one contact person, who can be a parent, a sponsor or an emergency contact.
Access is set by role and by school or campus. Lecturers who only teach see the students in the groups they teach. A faculty that runs as its own unit can be set up as a separate school, with its staff limited to it.
A program, or one year of a program, is set up as a grade, and its groups are sections. Semesters are terms inside the academic year.