Lesson Schedule
| 1. Introduction | What are the basic principles for using spreadsheets for good data organisation? |
| 2. Organising data in spreadsheets | How do we organise and format data in spreadsheets for effective data use? |
| 3. Common spreadsheet errors | What are some common challenges with formatting data in spreadsheets and how can we avoid them? |
| 4. Dates as data | What are good approaches for handling dates in spreadsheets? |
| 5. Quality assurance and control | How can we carry out basic quality control and quality assurance in spreadsheets? |
| 6. Exporting data | How can we export data from spreadsheets in a way that is useful for downstream applications? |
| 7. Survey | |
| Finish |
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.