How to Access and Import Data into CODAP Using Google Sheets data file
Rebecca Owen
35 steps
2 minutes
Concord
Owenmathclass
Google Drive
Google
1
Navigate to [https://www.owenmathclass.com/](https://www.owenmathclass.com/)
2
Click "CTE Math Files"
3
Click the second "Other Job Data" link under Chromebook files
4
Click here to download the sheets information to your computer.
5
Navigate back to [www.owenmathclass.com](http://www.owenmathclass.com)
6
Click "[https://codap.concord.org/app/static/dg/en/cert/index.html](https://codap.concord.org/app/static/dg/en/cert/index.html)"
7
Click "CREATE NEW DOCUMENT"
8
Click the three lines icon in the upper left corner.
9
Click "Import..."
10
Click this file field.
11
Choose the other jobs data from your download folder.
12
Click and drag this corner to resize the table.
13
Click on the "Graph" icon.
14
Click and drag "income" to the horizontal axis.
15
Click and drag this corner to resize the graph.
16
Choose the ruler icon.
17
Select "Mean"
18
Select "Median"
19
Click the arrow next to "Measures of Spread"
20
Select "Standard Deviation"
21
Click the arrow next to "Box Plot and Normal Curve"
22
Select "Box Plot"
23
Select "Show Outliers"
24
Hovering over the red line will display the median value.
25
Hovering over the middle blue line will display the mean value.
26
Hovering over the outer blue lines will display the standard deviation.
27
Hovering over the right side of the box in the box plot will display the Q3 value.
28
Hovering over the left side of the box in the box plot will display the Q1 value.
29
Subtract Q3-Q1 to determine the Interquartile range.
30
Click "income"
31
Click "Sort Ascending (A→Z, 0→9)"
32
Scroll to the top of the table.
33
The minimum value will be the first row in the table.
34
Scroll to the bottom of the table,
35
The maximum value will be in the last row of the table.
How to Access and Import Data into CODAP Using Google Sheets data file
Rebecca Owen
35 steps
2 minutes
Concord
Owenmathclass
Google Drive
Google
1
Navigate to [https://www.owenmathclass.com/](https://www.owenmathclass.com/)
2
Click "CTE Math Files"
3
Click the second "Other Job Data" link under Chromebook files
4
Click here to download the sheets information to your computer.
5
Navigate back to [www.owenmathclass.com](http://www.owenmathclass.com)
6
Click "[https://codap.concord.org/app/static/dg/en/cert/index.html](https://codap.concord.org/app/static/dg/en/cert/index.html)"
7
Click "CREATE NEW DOCUMENT"
8
Click the three lines icon in the upper left corner.
9
Click "Import..."
10
Click this file field.
11
Choose the other jobs data from your download folder.
12
Click and drag this corner to resize the table.
13
Click on the "Graph" icon.
14
Click and drag "income" to the horizontal axis.
15
Click and drag this corner to resize the graph.
16
Choose the ruler icon.
17
Select "Mean"
18
Select "Median"
19
Click the arrow next to "Measures of Spread"
20
Select "Standard Deviation"
21
Click the arrow next to "Box Plot and Normal Curve"
22
Select "Box Plot"
23
Select "Show Outliers"
24
Hovering over the red line will display the median value.
25
Hovering over the middle blue line will display the mean value.
26
Hovering over the outer blue lines will display the standard deviation.
27
Hovering over the right side of the box in the box plot will display the Q3 value.
28
Hovering over the left side of the box in the box plot will display the Q1 value.
29
Subtract Q3-Q1 to determine the Interquartile range.
30
Click "income"
31
Click "Sort Ascending (A→Z, 0→9)"
32
Scroll to the top of the table.
33
The minimum value will be the first row in the table.
34
Scroll to the bottom of the table,
35
The maximum value will be in the last row of the table.
