Open DamienIrving opened 9 years ago
Great idea @DamienIrving @dfflanders - would be easy enough to build something off other too-large spreadsheet problems. Given that the current lesson is the "easy" and the resbaz info management will be the hard, potentially the resbaz info management would be an interesting spreadsheet problem?
Ok, I've added commit https://github.com/datakid/django-tutorial/commit/37578eb9e76d0e87f48cfe71a4f4c42bcc51fb8f which adds in 5 spreadsheets, all taken from the original data set that this easy tute is based on.
The spreadsheets are ordered from "almost a direct replica of the database" (not even any vlookups) through to vlookup applied, data copied and paste-specialed into a "poor data modelling". Note that there are no data quality issues in these spreadsheets. It's 100% complexity of modelling and "what do I do next", when there is lots of data.
Data quality is another issue entirely.
If there are no complaints, I'll close this issue?
@datakid I was chatting with @dfflanders the other day and he suggested that this Django lesson could be preceded by a spreadsheets lesson. In other words, you'd do some spreadsheet basics and lead them to a point (via a research data example) where using a spreadsheet gets a little cumbersome/awkward. This would ensure that everyone really gets why using a database via django can be so useful.
Data Carpentry already has a spreadsheets lesson and I'm thinking this django lesson could potentially belong in the Data Carpentry repo one day, so we certainly don't need to be developing a spreadsheet lesson of our own at this stage.