Spreadsheets: Data Analysis

Software you could use: Excel, Google Sheets, Numbers

Description:

Badge earners will analyze at least 100 rows of data in a spreadsheet software. 

Badge Criteria:

1. Create or download a data set with at least 100 rows, several columns and including both quantitative and qualitative data. 
2. For the quantitative data, use formulas to turn ordinal data into numbers and  calculate the:
   1. Average/median
   2. Sum
   3. Percentage
   4. Standard deviation
3. For the qualitative data/open-ended classify each answer into a category and calculate how many times each category is represented in the data. 
4. Create two different charts or graphs representing the data. 

What to Submit:

Create a shared folder in Google Drive or Box with the following items:

• Final .xlsx file
• Screenshots of workspace during creation (at least 2). 
• Written reflection describing the process, skills, and tools used to create this project.