In the previous post Import Student Marks from Excel, I explored how the Teacher Assistant App imports, validates and saves marks from Excel. Now, it’s your turn to try a little challenge!
Imagine a spreadsheet ready for import. Everything looks fine, but not every entry is valid.
Will a few problematic entries stop the entire import? 👀
QUICK CHALLENGE
10 marks go in. What makes it through?
An Excel sheet contains marks for 10 students. Seven are valid, while the other three are either missing or invalid.
What happens when you import the sheet?
The verdict: Only the 7 valid marks are saved.
What happened to the other three?
- 1 mark was missing.
- 1 mark was above the maximum allowed (100).
- 1 entry contained text instead of a number.
The application identifies these issues instead of saving incorrect marks along with the valid ones.
Try the Excel Marks Demo →Note: The mini-challenge and interactive Excel demo are browser-based previews built with HTML, CSS and JavaScript. The actual Teacher Assistant App is a desktop application developed using Rust and egui, with SQLite for the Personal Edition and PostgreSQL for the Organization Edition.
A Small WebAssembly Experiment
I also explored WebAssembly using Trunk to bring the workflow to the browser. During the installation attempt, my laptop unexpectedly crashed. Since the cause wasn’t clear, I decided to pause the WebAssembly experiment and continue with a lightweight browser version instead.
Next on Techn0tz
We’ve explored Rust, built an app, and experimented with Excel imports.
Now, it’s time to explore something completely different.
A new series. A new direction. A new adventure.
Any guesses? 😉 Stay tuned!