Closed anenadic closed 4 years ago
Hi @anenadic the answer is "yes", you are exactly correct. In the exercise, the data was copied in 2015, and so is converted to the year 2015. It says: "You can see that even though you wanted the year to be 2014, your spreadsheet program automatically interpreted it as 2015, the year you entered the data.".
Do you have a suggestion for making this more clear?
It is not clear who 'you' is in this case - the data has been collected in 2013/2014 by 2 different researchers and not the participants of the workshop. So, I'll try and do a pull request to suggest changes I'd make for the maintainers to review.
To be honest, I'd also get rid of the 'dates' tab from the data as it is potentially confusing and does not resemble the 'dataset' (which is data in tabs 2013 and 2014). For the lesson on dates, instructor can refer to the '2014' tab to point out the problem with dates and then copy the problematic 'plot 3' table into a separate 'dates' tab if necessary for them to play with/work with dates (and ask the participants to do so too).
This is a separate issue of course, and I can create a new issue for discussion around this unless you guys think it is best to resolve all of this as part of this current issue.
Fixed with merge #293
I assume that the person who entered data in 2014 copied in some of the 2014 data they forgot initially to include and this copying occurred in 2015 but they did not include the year in the dates so they were saved by Excel as dates in 2015.
But is this assumption true? This is what I tell students.
Lesson affected is 03-dates-as-data and also I try to explain what the data contains in lesson 01-format-data early on.