CLIENT WORK · UNIVERSITY LECTURER · SEPTEMBER 2026
Fieldwork Systems
Two tools that turn student forms into organised rosters and ready-to-use health documents.
Group registration
Health paperwork
Built around the lecturer’s existing Microsoft Forms and Excel workflow.
01 · MICROSOFT FORMS + EXCEL
Group registration
One group submission becomes an organised class roster.
INPUT
A group signs up
One student submits the group’s details in Microsoft Forms.
- Group size
- 2 members
- Student 1
- Sam Example
- Student 2
- Alex Other
PROCESS
Excel builds the roster
Workbook formulas organise the responses into groups, keeping empty form branches out of the roster.
- Find each group’s members
- Keep IDs as text
- Check against the class list
OUTPUT
A ready-to-use roster
Names, coordinators and group numbers, ready for the lecturer. Student IDs stay out of this final view.
| Name | Coordinator | Group |
|---|---|---|
| Sam Example | Yes | G1 |
| Alex Other | G1 |
Illustrated workflow with fictional students. Forms collection and the response workbook are separate steps.
Skipped form questions once made a two-person group count as six. I corrected the workbook logic so only submitted members are counted.
The actual registration tool
Fictional settings. Select a screenshot to enlarge it.
Set up the two cohorts
The kit prepares form links, deadlines and announcements.
Share the QR posters
Generated posters direct students to their cohort’s form. These sample links do not collect responses.
02 · OFFLINE BROWSER TOOL
Health paperwork
Exported answers become individual questionnaires and a participant list.
INPUT
Export the answers
Choose the Excel file from Microsoft Forms. Add a class list to find missing submissions.
PROCESS
The tool checks the list
The offline tool matches student IDs and highlights responses that need a person’s attention.
- 2 responses retained
- 1 medical Yes flagged
- 1 student has not submitted
OUTPUT
A ready-to-use file pack
Individual questionnaires, a student overview and a participant list for the applicable cohort.
Illustrated DCIV example. All records shown are fictional.
Download sample participant CSVThe tool reads the exported files locally. Health data is not uploaded to an application server. Downloaded files still need appropriate storage and handling.
From the workspace to the finished document
Real application and output. Fictional test records.
Review responses and missing students
Two responses, one medical Yes and one missing submission, visible in one workspace.
Open an individual questionnaire
An actual generated PDF, filled from the submitted answers.
MY CONTRIBUTION
From the brief to the handover
I designed the workflows, directed the AI-assisted implementation, verified the outputs and prepared the tools for handover.
- The client needed
- Tools to organise student groups and prepare health paperwork within an existing field-course workflow.
- I delivered
- A registration kit, formula-driven Excel workbooks and a standalone health-document processor.
- The handover included
- Setup guidance, portable settings, workbook repair instructions and the self-contained HTML tool.
Recorded verification
Specific test results, with scope below.
- 1,142
- cell assertions
- 50
- Excel web checks
- 21
- health importer tests
- 0
- health-tool network calls
14 registration integration fixtures, recalculated in LibreOffice.
27 CIV and 23 DCIV checks using two actual Forms test submissions.
Includes ID matching, repeated responses, missing columns and 1,000 rows.
Recorded in the isolated browser QA run. Dependencies are bundled locally.
Engineering decisions & test scope
Registration reliability
The workbook preserves IDs as text and excludes empty form branches. Tests cover repeated headings, leading zeros, gaps, class-list matching and group limits. The templates support 40 groups per cohort, with up to six or five members.
The 1,142 assertions came from 14 LibreOffice fixtures. The 50 Excel web checks used two actual Forms test submissions.
Health-document reliability
Repeated responses stay separate, with unique output paths. Missing values are shown rather than guessed. Long answers continue onto another page. A failed PDF gets a printable HTML fallback.
The tool flags medical Yes answers for human follow-up. It does not decide fitness or infer consent. Libraries and fonts are bundled, and processing stays in memory.
Registration evidence was recorded on 9 September 2026. The health checks cover version 4.0, packaged on 13 September 2026, in Chrome on macOS.
Inspect an original response
The response drawer keeps the submitted answers visible beside an individual download.
Known limits & next steps
- The registration workbooks support 40 groups per cohort and up to six or five members. Moving raw responses can require reconciliation of manual attendance and room entries.
- Forms collection and the Excel download remain separate. Automatic university Forms-to-Excel sync was not verified.
- The health tool was tested in Chrome on macOS. Windows and the university tenant were not verified. Its outputs support administration and follow-up, not clinical decisions.
- Downloaded health files are sensitive and unencrypted. The source tool flags formula-like CSV text, which should be imported as Text in spreadsheet software.
Next steps: verify the university tenant and Windows environment, protect manual roster notes when source rows move, and automate release checks across both packages.