Created while I was teaching logistics and technical subjects, these workbooks automate recurring classroom tasks and turn abstract concepts into interactive exercises.
Each one starts from a specific need and converts it into a reusable workflow based on structured inputs and repeatable outputs.
ExamGenerator.xlsmStarting from a shared question bank, it creates multiple test versions by selecting questions and shuffling the answer order.
It then produces printable PDF files and a complete answer key, allowing the same material to be used for assessment or independent practice.
Test Rating Calculator.xlsxThree templates calculate grades for different assessment formats: true/false or multiple-choice questions, open-answer or exercise-based tests, and averages across several tests.
They can be used with material produced by the generator or with independently prepared assessments.
Oral assessment rating calculator.xlsxIndividual answers can be scored and weighted as the assessment takes place, producing a final grade from the recorded evidence rather than relying on memory alone.
Random number generator.xlsmIt draws numbers from a defined range without repetition and can exclude selected values.
In class, I used it to select students from the register for oral assessments.
Esercizio 6 -Finanza personale - Parzialmente svolto.xlsxStudents can vary assumptions for savings, returns, expenses and inflation, then observe how those choices affect long-term results.
The workbook combines spreadsheet practice with an accessible introduction to personal financial planning.
Esercizio 2 - Calcolo probabilità - Svolto.xlsxRepeated random trials make it possible to compare expected probabilities with observed outcomes over different sample sizes.
The exercise uses gambling scenarios to introduce statistical variation and the central limit theorem while developing spreadsheet skills.