Data Organization in Spreadsheets for Social Scientists: Instructor Notes

The challenge with this lesson is that the instructor’s version of the spreadsheet software is going to look different than about half the room’s. It makes
it challenging to show where you can find menu options and navigate through. Instead discuss the concepts of quality control, and how things like sorting can help you find outliers in your data. Provide information on setting up your environment for learners to view your
live coding (increasing text size, changing text color, etc), as well as
general recommendations for working with coding tools to best suit the
learning environment. The main challenge with this lesson is that Excel looks very different and how you
do things is even different between Mac and PC, and between different versions of
Excel. So, the presenter’s environment will only be the same as some of the learners. We need better notes and screenshots of how things work on both Mac and PC. But we
likely won’t be able to cover all the different versions of Excel.


Activity log