As a Teacher. I have no Time to learn Programming - Streamline Assignment Marking with Python
summary
A set of Python scripts that populates per‑student Excel mark sheets from a CSV, validates scores, batch‑adjusts marks, collects results into a single CSV/Excel and converts to PDF for submission. Implementation details name openpyxl for fast cell edits and xlwings to trigger Excel recalculation, plus simple checks that reject out‑of‑range marks. Source code lives on GitHub. Argument: keep logic in code (versionable) and avoid VBA macros for maintainability and reduced cyber‑risk.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 1:34Automate marking with Python
- 3:44Manual to Excel automation
- 6:38Filling student details
- 8:27Adjusting marks across files
- 10:19Collecting marks from files
- 11:46Excel to PDF conversion
- 13:14Python vs Excel macros
- 15:03Macro cybersecurity risks
- 17:31Conclusion and future automation plans
- 19:17Q&A
related talks
32mAutomating teaching about automation in Python
45mEdit Excel and Google Spreadsheets with Python: An Introduction
29mAutomagically marking Python course work and assessments in seconds!
14mHow Python can handle and help you with repetitive tasks!
31mUsing Python in a Traditional Office
01h 25mAdvanced Excel Analytics: Python Integration Workshop
48mSmart Spreadsheets
54mLook smarter: deliver your work in Excel