search

datacarpentry / spreadsheets-socialsci

Data Organization in Spreadsheets for Social Scientists
http://datacarpentry.github.io/spreadsheets-socialsci/
Other
21 stars 68 forks source link

PC/Mac issues #7

Closed karenword closed 5 years ago

karenword commented 6 years ago

Running through this lesson on a Mac running Excel v 15.40 (2017), I've encountered several problems. Some minor, some major. Will continue to list these here as I find them. So far: 1) "paste values" is instead "paste special -> values and numbers" on a mac 2) dates on a mac default to January 1 1904 as the date for value 1. This is an additional problem with date formatting compatibility. 3) Major problem: importing a csv file free of date formatting cannot be done using the Open function on my version. It must instead be accomplished by using File -> Import, followed by selecting csv -> delimited -> comma -> data format. In the final selection there is no option to avoid classifying type so "text" must be selected. (Oddly, selecting "general" does not prevent Excel from applying date formatting.)

chris-prener commented 6 years ago

thanks @karenword - I'm going to look into this!

ErinBecker commented 6 years ago

Thanks @karenword for raising these issues. I've worked through the lesson now on my Mac (Excel v15.30) and was able to complete the lesson without incident. There are a few (I think minor) differences in menu item names among different versions of Excel, but this isn't something that we'll be able to standardize with so many different versions of Excel out there. Given that the lessons can be worked through as is, the plan is to move forward with release and get feedback from instructors about whether these difference in menu option wording are a problem. I'll change the label on this issue to "discussion" for now and see what feedback comes in once the lessons are being taught.

ErinBecker commented 6 years ago

See also https://github.com/datacarpentry/spreadsheets-socialsci/issues/63 for Mac specific issue.

chris-prener commented 5 years ago

Any feedback @ErinBecker from the recent training here?

ErinBecker commented 5 years ago

I didn't run into any issues during the training that @karenword and I were involved with that we haven't already listed in other issues in this repo. I would personally be comfortable closing this issue, but would like confirmation from @karenword or other Instructors who have taught this curriculum.

chris-prener commented 5 years ago

OK sounds good @ErinBecker - is there a way to get feedback from them (I assume a mailing list)?

ErinBecker commented 5 years ago

Not a mailing list, unfortunately. Right now, I'm emailing individual Instructors who are running pilots and asking them to submit feedback to the issue here: https://github.com/datacarpentry/socialsci-workshop/issues/25. there haven't been many pilots so far, but I am talking with some Instructors who are teaching in January and will be giving feedback after that.

On Thu, Nov 8, 2018 at 4:21 AM Christopher Prener notifications@github.com wrote:

OK sounds good @ErinBecker https://github.com/ErinBecker - is there a way to get feedback from them (I assume a mailing list)?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/datacarpentry/spreadsheets-socialsci/issues/7#issuecomment-436976114, or mute the thread https://github.com/notifications/unsubscribe-auth/ASSbf6R7952-L94hTF7Uf2853GCrJT1Jks5utCHJgaJpZM4Q71pa .

-- Associate Director, The Carpentries Pronouns: she/her/hers

chris-prener commented 5 years ago

ok sounds awesome @ErinBecker thanks!

chris-prener commented 5 years ago

@ErinBecker - haven't seen any more feedback on this - should we close?