# data[].attributes.headline
Chart of political parties based on private or public high school

# data[].attributes.subject
Chart of political parties based on private or public high school

# data[].attributes.body
Google sheets link: https://docs.google.com/spreadsheets/d/10GTDq-4D-XaJBzhH269xlj0N1XUmWU2EyO77an54GOI/edit?usp=sharing

# data[].attributes.body
I used excel and google maps to create a map of the locations where all students that were not born in Georgia were born.

# data[].attributes.attachment_link.title
Where Students Where Born Outside of GA - Google My Maps

# data[].attributes.attachment_link.description
All the different locations of students' birthplaces that are not in GA, using excel.

# data[].attributes.body
In Google Sheets you should have a menu item: add-ons.

In Excel you'll find it in Tools --> Excel add-ins.

# data[].attributes.body
Also in our class Google Drive: https://docs.google.com/spreadsheets/d/1nytqt5MgJdp8cpNllTm2OPE1n3LRekcZ8QIxG0TlCBQ/edit#gid=0

Download this spreadsheet. Make a copy that you can rename and use to work with the data. Choose data that you'd like to work with and "clean it up" = make sure everything is in the same format, spelled the same way (0 = zero = none = None = Nooone. Decide which you'll use and rename them. So all zero, none, None etc entries are now 0).

# data[].attributes.body
Download this Excel file and open it in Excel. Select the columns and all of the data. Go to Insert --> recommended charts --> stacked.

# data[].attributes.body
Download this Excel file

# data[].attributes.body
Highlight, copy, and paste star wars character height and move into a new column

2. Remove NAs from the new column.

3. Create a new column called bins and input the values according to whatever increments you would prefer, I’ll be using the values in

increments of 30: 60, 90, 120, 150, 180, 210

4. Highlight the values in these columns, go to data -> data analysis and select Histogram. Make sure that chart output is selected. You will have to input the values from the cells either with drag and drop or type in the values. (If data analysis is not showing up go to Data -> Excel Add-ins -> Select Analysis Toolpack)

5. Edit colors and axis labels the same way as with bar charts!

# data[].attributes.body
Download the Star Wars Characters file and open it in Excel

Create two new columns in your excel spreadsheet: one called gender, the other called count

List out the possible options in the new gender column (ie male, female, hermaphrodite)

Under the column labeled count, input the following formula: =COUNTIF(nameoforiginalgendercolumn:endofoggendercolumn, newone) –e.g. =COUNTIF(H2:H88,O2) This means: count all instances of the gender in Column O, row 2 that are present in column H from row 2 to row 88).

4. repeat this by either dragging or manually inputting the same formula so that each different gender is counted

5. highlight these two columns and go to the menu Insert -> Chart -> Column

6. To adjust by ascending or descending order, click home on far left menu.

7. Then select, sort & filter -> custom sort.

8. This will open a new window. Select count or frequency as the column to sort by, and order smallest to largest (or largest to smallest)!

# data[].attributes.body
Create a new Excel file

Enter a location in each row. Your first row should be a header like "location".

Save the file (give it a name)

Go to maps.google.com

Top left: menu (the four lines) – select “my places”

At bottom of page: create a new map

Import --- the map you saved as xlsx

# data[].attributes.body
Go to your original Excel file (map) and in file: save as… csv

Open Datawrapper.de --- New Map --- Symbol map

Choose map (e.g. United States or World – depends on your data)

Add your data (import the csv file) – Match as addresses

Add column (for example: number of people who live in each of these places)

You can manually add places … Size by (new column) Make adjustments

This will give you a bubble map with bubble sizes adjusted to # of people