Data Organization in Spreadsheets for the Health Sciences: Setup

Data

Download this data file to your computer: https://github.com/UW-Madison-DataScience/dc-health-data/blob/master/processed_data/spreadsheets/ADNI_spreadsheet.xlsx

About the data

The data for this lesson is a part of the Health Sciences Data Carpentry workshop. It is a teaching version of the Alzheimer’s Disease Neuroimaging Initiative (ADNI) data. The data in this lesson is a subset of the teaching version that has been intentionally ‘messed up’ for this lesson.

The data for this lesson and the workshop are in the Health Sciences Data Carpentry data GitHub repository available on GitHub, with a CC-BY license available for reuse.

The original datasets can be found here and used with approval ADNI Access Data and Samples

Software

To interact with spreadsheets, we can use LibreOffice, Microsoft Excel, Gnumeric, OpenOffice.org, or other programs. Commands may differ a bit between programs, but the general ideas for thinking about spreadsheets are the same.

For this lesson, if you don’t have a spreadsheet program already, you can use LibreOffice. It’s a free, open source spreadsheet program.

Windows

Mac OS X

Linux