## Instructional Videos

**All DARE videos are located here.**

#### (1) Making Bivariate Tables Using Spreadsheets

This video is approximately 15 minutes and it provides an overview of how to make a table using Google sheets. It reviews several basic skills in navigating Google sheets and is a good introductory video for making tables in Google sheets.

- 0 to 1:15: Selecting the data for analysis in Google Sheets
- 1:16 to 3:10: Making a bivariate table in Google Sheets
- 3:11 to 4:00: Interpreting the frequencies in a bivariate table
- 4:01 to 5:10: Converting the frequencies to percentages
- 5:11 to end: Working with Google sheets to make the table more readable

** **

(2) Making and Interpreting Bivariate Tables Using Google Sheets

This video is approximately 14 minutes long. It goes over how to make a pivot table in Google sheets (using an example with survey data) and explains how to interpret the raw frequencies from that table. It also reviews how to convert the data into percentages and how that can be used to make meaningful comparison.

- 0 to 3:24: Making a bivariate table in Google sheets using raw frequencies
- 3:25 to 4:47: Explaining how to make sense of the frequencies in the bivariate table
- 4:48 to 5:33: Converting the frequencies to percentages (column percentages)
- 5:34 to 8:00: Explaining how percentages are calculated, with examples from frequencies
- 8:01 to 9:15: Explaining how to interpret percentages in a bivariate table
- 9:16 to 10:24: Interpreting the percentages in terms of the columns and making comparisons among groups
- 10:25 to end: Explaining how the results change by switching to row percentages and how to interpret tables with percentages

(3) Interpreting Bivariate Tables (Row vs. Column Percentages)

This video is approximately 11 minutes long and it focuses on how to interpret bivariate tables with a special emphasis on the importance of the distinction between row vs. column percentages.

- 0 to 7:52: Interpreting the percentages in a table to make comparisons (correctly selecting the right percentages; interpreting the table based on column percentages)
- 7:53 to 10:40: Interpreting the table based on row percentages
- 10:41 to end: The importance of the distinction between row vs. column percentages

(4) Calculating and Interpreting Ratios

This video is approximately 6 minutes and is an introduction to ratios, including how to reduce them and express them per 1 individual of either the larger or smaller group.

- 0 to 1:00: A summary of ratios
- 1:01 to 2:29. How to reduce a ratio, including how to reduce a ratio to express the larger group relative to one individual in the smaller group
- 2:30 to 4:41: Using a hypothetical sample of a bird population to illustrate ratios and another demonstration of how to reduce ratios to express the number of individuals in the larger group relative to one individual in the smaller group
- 4:24 to end: Using a hypothetical sample of a bird population, an illustration of how you can reduce ratios to express the number in the smaller group relative to one individual in the larger group

(5) Preparing and Interpreting Graphs Using Google Sheets

This video is approximately 8 minutes and is an introduction to preparing and interpreting graphs (bar charts, line graphs, and pie charts) using Google sheets.

- 0 to 1:23. Overview of bar charts, line graphs, and pie charts
- 1:24 to end: Demonstration of using data from the US Census on poverty to prepare graphs (a pie chart, a bar chart, a line graph with raw numbers, a line graph with percentages)

(6) Preparing and Interpreting Stacked Bar Charts Using Google Sheets

This video is approximately 10 minutes and it provides an overview of preparing, interpreting, and editing stacked bar charts using Google sheets.

- 0 to 2:30. Demonstration of how to make a stacked bar chart in Google sheets
- 2:31 to 5:25: How to format charts properly
- 5:26 to 6:15: interpreting a stacked bar chart
- 6:16 to 6:45: Rationale for making a stacked bar chart
- 6:46 to 7:25: The order of the categories in the stacked bar chart
- 7:25 to 8:00: The importance of having the bars representing comparison categories in bar charts
- 8:00 to end: Tips for editing a stacked bar chart (or any chart in Google sheets)

(7) Calculating and Interpreting Measures of Central Tendency Using Google sheets

This video is approximately 5 minutes and it provides an overview of how to calculate and interpret measures of central tendency (mean, median, and mode) using Google sheets.

- 0 to .40: Overview of mean, median, and mode
- 41 to 4:00: Demonstration of how to calculate mean, median, and mode using a quantitative variable
- 4:01 to end: Interpreting measures of central tendency

(8) Preparing Surveys Using Google Forms

This video is approximately 15 minutes and serves as an overview of how to create a survey using Google forms. It is primarily geared towards instructors but also helpful for students.

- 0 to 1:00: Overview of how to create a Google form
- 1:00 to 8:08: How to create questions in Google forms with demonstrations of different types of questions
- 8:09 to 10:05: How to edit Google forms or add features
- 10:05 to 10:40: How to share the Google form/survey
- 10:41 to 12:00: Overview of a survey used in a class
- 12:01 to 12:45: How to view responses from a survey in Google forms
- 12:46 to end: How to view and share the data (results) from a Google survey

(9) Data Analysis with NYC Health and Environment Data

This video is approximately 34 minutes and serves as an overview of how to access data from the NYC environment and health data portal. It reviews how to access and download those data to make and interpret a bivariate table and a graph (a stacked bar chart).

- 0 to 5:15: How to access data from the NYC Environment and Health Portal
- 5:15 to 10:00 Ways to change continuous variables to discrete data
- 10:10 to 12:15: How to upload data (an Excel file) to Google Sheets
- 12:16 to 24:50: How to make a bivariate table using discrete categories
- 24:51 to 27:30: How to interpret bivariate tables
- 27:31 to end: How to prepare and interpret bivariate charts

(10) Analyzing Florence Nightingale’s Data on the Crimean War

This video is approximately 25 minutes. It provides guidance on how to prepare a table (and convert the data from raw numbers to percentages in the table), make graphs (including a line chart and a bar chart), and interpret the results

- 0 to 1:15: How to make a copy of the dataset onto your own Google drive
- 1:16 to 3:35: Making sense of Florence Nightingale’s data
- 3:36 to 9:00: Making a table with raw mortality counts
- 9:01 to 17:55: Making a table with percentages with the mortality data
- 17:56 to 12:14: Making a line chart with the data
- 12:15 to 22:50: Making a stacked bar chart with the data
- 22:51 to end: Telling a story and interpreting the data

#### (11) Basis Analysis with CODAP

- 0 to 20: Overview of CODAP
- 21 to 1:25: Importing a census file (the American Community Survey) into CODAP
- 1:26 to 3:10: Making a bivariate area chart comparing earnings of males vs. females
- 3:11 to 3:40: Getting the counts and percentages for each of the areas (males and females)
- 3:41 to 4:55: Creating a scatterplot comparing age to wages
- 4:56 to 5:35: Graphing the “least squares line” and plotting the correlation
- 5:36 to 6:19: How to export an image in CODAP

#### (12) Common Google Glitches

- 0 to 4:15: Fixing a bivariate chart when the columns and rows get automatically reversed
- 4:16 to 9:29: How to fix a bivariate chart in Google sheets by selecting data out of range to trick Google into making the correct graph