A spreadsheet program like Microsoft Excel or Google Sheets can be used to perform calculations and prepare pupils' progressive reports. These programs allow users to input data, perform calculations, and create visual representations of the data in the form of charts and graphs. Additionally, they provide tools for organizing and formatting data to create professional-looking reports.