Case study / Client project · Education
labbkpi.
From paper-based practice to a connected assessment workflow.
A platform for a counselling laboratory at UIN Banten, supporting computer and phone participation, immediate results, and an Excel input route.
- My role
- Independent delivery
- Technology
- Next.js · Laravel · MySQL · VPS · CI/CD
- Project context
- Client project · Education
Opens the live platform’s login page. Access requires an authorised account.
01 / labbkpi
The starting point
The counselling laboratory at UIN Banten wanted to digitise tools used in student practice. Participants needed to complete assessments on computers and phones, with results available after processing.
Moving the questions onto a screen was only part of the work. The application also needed to connect participants, classes, sessions, answers, and results across several instruments.
An Excel route was needed for data collected or entered outside the application. Both routes had to fit the laboratory’s procedures.
02 / labbkpi
My contribution
Analysis & documentation
Understood the client’s workflow, analysed requirements, and documented the system to be built.
Architecture & development
Designed the frontend/backend architecture, MySQL relationships, and instrument-specific application flows, then implemented them.
Testing & infrastructure
Performed QA, prepared the VPS operating system and dependencies, and set up deployment with CI/CD.
Implementation & support
Worked directly with the client to resolve bugs, initial-data issues, and questions after release.
The client supplied the BK expertise behind calculation and interpretation rules. I translated those requirements into data structures and application behaviour; I did not define or validate the psychological instruments.
03 / The workflow
A shared session. Different assessment needs.
- 01
Organise the session
Connect the academic period, classes, and participants.
- 02
Collect the responses
Participants use the web interface, or administrators import Excel data.
- 03
Process by instrument
Apply the calculation requirements supplied by the client.
- 04
Review the results
Present completion status, instrument-specific fields, and individual detail.
04 / labbkpi
Architecture around the assessment procedure
Share administration across instruments
Schools, classes, participants, academic periods, and test sessions provide a common administrative foundation. Reusing those relationships keeps the overall procedure connected without creating a separate participant system for every instrument.
Give each instrument the structure it needs
Questions, responses, and results differ across instruments. I used shared relationships where the workflow overlapped and separate models where an instrument needed its own structure. Sociometry, for example, records choices between participants and presents them as relationships.
Keep direct participation and Excel input connected
The web test flow supports participants on computers and phones. Class templates and Excel import accommodate data entered or collected separately, alongside the laboratory’s digital workflow.
Include the operating environment in delivery
I prepared the VPS, installed the operating system and dependencies, and configured CI/CD. Direct client communication continued through implementation so bugs and initial-data issues could be resolved.
05 / Inside the application
From session setup to individual responses.
Session administration brings the academic period and participating classes together, with participant counts visible in the class list.
The RIASEC workflow supports a class-level result table and an individual detail view. Result fields follow the requirements supplied by the client.
Administrators can use an Excel route for assessment data that needs to be entered or processed separately.
A different instrument needs a different relationship model. Sociometry presents participant choices through a matrix and its associated visualisation tools.
Participants can complete a test through a phone interface, keeping the digital workflow accessible beyond a desktop computer.
Original labbkpi frontend with fictional participants, schools, sessions, questions, and result values. Scores and labels are illustrative UI data, not calculated or validated assessment outcomes. No production records are shown.
06 / labbkpi
Outcome & scope
The platform is in use, supporting the laboratory’s move from paper-based practice to computer and phone access, immediate result processing, and Excel-based input. My involvement continued after release through direct client support.
This case study demonstrates software engineering and delivery. Calculation and interpretation requirements come from the client’s BK expertise; no psychometric validation, usage totals, or measured time savings are claimed.
A conversation starts here
Have an idea or a collaboration in mind?
Let’s talk it through.