Tag: DASH Lab

Data Visualization for Everyone

Workshop Prezi:

Video of Workshop:

Poster for Workshop

Data Vis.dig.sign

Files for Workshop


Mohonk Preserve Weather

  1. Freeze header row
  2. Make font condensed
  3. Observe data types
  4. Apply conditional formatting: categorical and diverging


Highest Grossing Films

  1. How does Titanic stack up?
  2. Freeze header row
  3. Make font condensed
  4. Observe data types
  5. Apply conditional formatting: categorical and diverging (optional)
  6. Data > Filter > genre > Drama
  7. Data > Sort > Worldwide gross
  8. Make pivot table: genre for rows; budget for values
  9. Copy and paste in new worksheet > paste values only
  10. Make a chart of this data


Titanic passengers

  1. Who was most likely to survive the Titanic? Who was least likely to survive the Titanic?
  2. Freeze header row
  3. Make font condensed
  4. Observe data types
  5. Apply conditional formatting: categorical and diverging (optional)
  6. Data > Filter > column attribute > ?
  7. Data > Sort > column attribute > ?
  8. Make pivot table: 1, 2, and 3 class for rows (count); survived (sum) for values; filter by demographic category
  9. Duplicate worksheet and make a new pivot table
  10. Copy into new worksheet and paste values only. Sort and clean data. Transform into percents if need be (normalize data
  11. Make a chart of this data



Mapping Knowledge: A Narrative Mapping Workshop

 Set up for Google Maps:

  1. Log into Google (with a non-Hawkmail account)
  2. Navigate to http://maps.google.com
  3. Click on the icon with three horizontal bars in the left-hand side of the search bar.
  4. Click on “My Maps.”
  5. Click on “Create Map” and give your map a title and a description by clicking on the words “Untitled Map” in the upper-left hand side of the screen and completing the empty fields.
  6. To add locations to your map, type a location in the search box, (e.g. 221B Baker Street, London), click on the resulting point, and then click “Add to Map”

 Editing Google Maps Data

  1. First, let’s add text
    1. Click on the location, then click on the icon of a pencil
    2. Type a title and description for the location
    3. Click “Save”
  2. Next, let’s add an image to a location
    1. Click on the icon of a camera.
    2. Do a Google image search for your location, choose a picture of the area, click on the image you want, and click “Select”
    3. Click “Save” to save your picture.
  3. Next, let’s color-coordinate the locations
    1. Each location is listed in the box on the left; hover over your location in the box on the left and click on the icon of a paint-bucket that appears on the right.
    2. Select a color and shape from the drop down menu to determine the appearance of the location pins.
  4. Finally, let’s add lines to connect the locations
    1. Figure out the order you’d like the locations to have
    2. Click the icon that looks like several dots connected with lines and select “Add line or Shape” (or “Add Walking Route” if the characters walk between the points).
    3. Click on each location in order and hit enter when you’re done.
    4. Give the line a name and a description.
    5. To change the line’s appearance or color, hover over the name of the line in the left-hand box alongside the locations and click the paint-bucket icon that appears.
    6. Select the desired color and line width.
  5. Let’s share the map
    1. In the upper-left part of the screen, click the word “Share”
    2. To let others see your map, click on the word “Change” in blue
    3. Select “Anyone with link” to let anyone with the map link see your map
  6. To let other people collaborate on your map, type their email addresses into the box labeled “Invite people”

Using Mapbox:

Mapbox (https://www.mapbox.com/editor) is another great mapping program that lets you customize things a little more and makes more elegant maps. However, it doesn’t let multiple people edit the same map simultaneously, so collaboration is harder.

 Importing Data:

  1. Make a Mapbox account (https://www.mapbox.com/editor) and log in.
  2. Click the button labeled “New Mapbox Editor Project.”
  3. Click “Style,” then click on the map style you want from the resulting list.
  4. Click on “Project,” -> “Settings” and give your project a title and a description.
  5. Click the “Save” button.

Adding and Editing Data:

  1. Click on the icon of a magnifying glass, type in your address, and hit enter.
  2. Click on the point that appears on the map to add it to your map.
  3. A window will pop up on the left. Add the title and description in the text fields
  4. Click the word “Style”at the bottom of the new window to select the color and size of the location icon.
  5. Click the word “Symbol” next to the word “Style” to add your favorite icon symbol to the location.
  6. To find an image for a location:
    1. Do a Google image search (https://images.google.com/) for your location to find the perfect image.
    2. Once you’ve found it, Click it, then click “View image” in the next window, and copy the new URL to get the image URL (NOTE: it should end with .jpg, .png, or .tif).
  7. Go back to your Mapbox project, and click “Text” again.
    1. Click at the end of your description in the “Add a description” field
    2. Type <img src=”URL”> (replacing URL with the URL you copied in step 6.2)
    3. For example, if I wanted this picture of Baker Street associated with Baker street, I would type <img src= “https://shipscooksstuff.files.wordpress.com/2012/02/baker3.jpg“>
    4. Click the “Save” button.
  8. Remember the order for your locations, and get ready to draw lines.
    1. Click the “Line” button, then click on the correct points in order.
    2. Double-click on the final location.
    3. Give the line a name (e.g. “Order of events in “A Scandal in Bohemia”) and a color.
    4. Click the “Save” button.
  9. To see what your map looks like, click “Project” -> “Info,” and copy and paste the URL listed under “Share” into a browser.

Sample Student Maps:

The Picture of Dorian Gray Map: http://tinyurl.com/doriangraymap

The Romance of a Shop Map: http://tinyurl.com/romanceofashop

The Walking Dead Map: http://walkingdeadgis.weebly.com/

Nirvana Map: Obscurity to Domination: http://nirvanatour.tumblr.com/

Map of Holmes story “The Twisted Lip”: http://tinyurl.com/twistedlipmap

Map of Holmes story “A Scandal in Bohemia”: http://tinyurl.com/scandalbohemiamap

For more info, check out https://annieswafford.wordpress.com/

Recording Research: Video Essay Workshop

Want students’ work to combine creativity, concise writing, and technology? Then come to a workshop on digital video essays!

In this workshop, you will learn how to use WeVideo, a free, user-friendly web tool for creating and editing short videos.

The workshop will demo sample student videos and online assignments to make it easy for you to bring this technique into your classroom.  You can even use this flexible tool to create mini video lessons or video blogs!

No audiovisual editing experience needed.

Led by Melissa Y. Rock (Geography, Asian Studies)
March 1st, 11:00-12:30pm

© 2020 DASH Lab

Theme by Anders NorenUp ↑

Skip to toolbar