This Data Carpentry lesson is intended to illustrate principles of responsible spreadsheet usage. It was developed by Peter Smythe of the University of Manchester.
| Setup | Download files required for the lesson | |
| 09:00 | 1. Creating data tables in a spreadsheet | How should I design and format my spreadsheet? |
| 09:15 | 2. Re-formatting a spreadsheet report | How can I re-format a spreadsheet report to remove header lines? |
| 09:40 | 3. Formatting problems | What are some common challenges with formatting data in spreadsheets and how can we avoid them? |
| 10:05 | 4. Dates and date formatting | What are good approaches for handling dates in spreadsheets? |
| 10:20 | 5. Quality control |
How can we carry out basic quality control and quality assurance in spreadsheets?
What spreadsheet aids are available to assist me when inputting data? |
| 10:35 | 6. Exporting data | How can we export data from spreadsheets in a way that is useful for downstream applications? |
| 10:55 | Finish |
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.