Category: Events (page 1 of 3)

Lightning Talks

Follow the links below to see what faculty and staff shared during their lightning talks!

Chantal Larose (Statistics):

 

Annie Swafford (English): http://www.augmentednotes.com/

 

Lydia Willoughby (Library): http://newpaltz.libguides.com/ghosts

 

Rachel Rigolino (English):

Tool:

Example:

 

Josh Korenblat (Graphic Design): http://hawksites.newpaltz.edu/dashlab/2017/04/13/poems/

 

Kate Bohan (TLC): https://www.lynda.com/  Sign-up to be a Lynda.com Admin: https://newpaltz.wufoo.com/forms/sxxgxbm15deyfb/

 

Kiersten Greene (Education): https://docs.google.com/presentation/d/1rAWxjRN9JasKp-uWLEJwU-Rp5uWmfDR-uSPXdBNIRpI/edit?usp=sharing

 

 

 

Visualizing Curricular Places with Digital Mapping

Google Maps:

Requirements: Google Account

Set up:

  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 “Your Places,” then “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 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. Click the paint bucket icon
    2. Select a color and shape from the drop down menu to determine the appearance of the location pins.
    3. Click “more icons” to see even more options
  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”

StoryMap JS:

Requirements: Google Account; Chrome is recommend

Instructions:

  1. Go to https://storymap.knightlab.com
  2. Click “Create”
  3. Select “Login with your Google Account”
  4. Click the green button labeled “New”
  5. Give your map a title and click “Create”
  6. Type the name of your map under “HEADLINE”: this is the title of your map
  7. Enter a description of your map in the text field under “HEADLINE”
  8. Upload an image for your homepage (click on “Upload an image”) or paste a URL of an image or video into the field labeled “URL to your media.” Add credit and caption if desired
  9. Click “Add Slide” to add a new slide
  10. Repeat steps 6-8 for each location where you’ve lived
  11. Type the location you’d like to mark on the map into the box labeled “Search.” Feel free to use the + and – buttons to zoom in.
  12. Click the “Save” button occasionally to save data
  13. When you’ve added all your locations, click the “Options” button.
    1. You can change the map’s appearance with “Map type”
    2. If you want to preserve the level of zoom and want the map to resemble a slideshow that focuses on individual points, switch from “Cartography” to “Image” under “Treat As”
    3. If you’re interested in the relationship between the points and care less about the level of zoom, leave it on “Cartography.”
  14. To share the map, click on the “Share” button. Copy and paste the link under “link” to send in an email. To embed the map in a website, scroll down and save the “embed” code to paste in your website’s HTML editor.
  15. You’re done!

Sample Student Maps:

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/

Feedback?

Click here to take our questionnaire!

Victorian & Modernist Poems

Joshua Korenblat Lightning Talk

Example of a Victorian poem from the collection

Example of a Modernist poem from the collection

 



Sources:

Oxford Book of English Verse, Project Gutenberg

Some Imagist Poets, Project Gutenberg

 


 

Read more about the Python library we used.

A write-up by Amardeep Singh, Associate Professor at Lehigh University, about this project.

 

Digitizing the Archive

Digitizing the Archive                                          February 15, 1-2:30pm, TLC

Do you have historical photographs you want to display? Rare texts you want to digitize? Want your students to create digital exhibits?

Come learn how to use Omeka, a free, open-source tool for making digital archives and museum exhibits!

No programming or web design experience necessary!

Please fill out this short survey to let us know how we’re doing!

Click here for workshop instructions!!

iNZight into Baseball

iNZight into Baseball Nov. 10th, 1:00-2:00pm, TLC
Joshua Korenblat
Assistant Professor of Graphic Design

Want to celebrate the World Series? Interested in learning how to make graphs and charts?

Come learn how to use iNZight lite and Google Sheets to analyze baseball statistics, including batting and pitching data, from 1871-2015.


 

 

What we’ll learn today

  • Today we’ll  learn how to survey, sift, summarize, sort, filter,  and visualize your data.
  •  We’ll learn what things to look out for during the visual analysis process of histograms, boxplots and scatterplots/ bubbleplots: two visualization types that rely upon position in space to help us compare distributions and variables with greater nuance and clarity.
  • We’ll learn how to leverage the power of free tools: Google Sheets and iNZight.
  • We’ll learn how to export your visualizations into art and design applications, such as Adobe Illustrator, for further crafting, creating a delightfully informative read.

Why Baseball?

Recently, I ran across a news article listing the world’s largest recorded human gatherings.

A pilgrimage in Northern India summoned ~30 million people, and Mecca is always a destination.

screen-shot-2016-11-07-at-8-12-13-pm

Looking around, I noticed a few surprise entries, notably a Rod Stewart Concert in Rio (~4 million people)
and the 2016 World Series Celebration for the Chicago Cubs.

screen-shot-2016-11-07-at-12-01-04-am

Here are the breakdowns. Each person = 1 million people.

screen-shot-2016-11-07-at-10-06-23-pm

Why was the Chicago Cubs World Series such a big deal? Well, this was the last Cubs World Series Championship team:

1908-chicago-cubs-wikimedia-george-r-lawrence-2

The Cubs hadn’t won a World Series in 108 years. To quote some stage direction from Shakespeare, “Exit, pursued by bear…”

Baseball thrives on statistics. 108 years parallels the 108 stitches in a baseball. There’s a poem in that idea.

Although we’re using baseball data here, this simply serves as an analogy for your data: any collection of information with many observations, and many variables (categories) within those observations.

Let’s take a look at data from baseball history, find out more about that 1908 season, and create some visualizations using Google Sheets and iNZight, a free package developed at the University of Auckland that runs through R, the world’s most popular open source stats application. No worries: no coding required!


 

Resources for this workshop

iNZight

iNZight Lite

Lanham Baseball Database

Baseball Reference 

Retrosheet


To follow along with the data, use Google Chrome for your browser. Go here and make sure to log into Google Sheets —>
iNZight into Baseball

 

Go to File —> Make A Copy to bring this into your own Google Drive.


TeamsFranchises: First, let’s explore the first worksheet. Check out the Explore button in the lower right corner. We can find a lot of information about our data simply by clicking in a cell on a worksheet.

To get more specific data, let’s write a COUNTIF formula in some empty cells.

Teams: Let’s make a Pivot Table. Click on the corner between A & 1. Then go to Data —> Pivot Table

screen-shot-2016-11-07-at-10-47-06-pm

 

 

 

 

 

For Rows,  select name. For values, select  W and L. Filter the year to 1908.

screen-shot-2016-11-07-at-10-59-17-pm

Now, select the data frame this creates. Copy. Create a new worksheet. Go to Paste —> Paste Special —> Paste Values Only.

Let’s make a chart from this data. Highlight the data you want to chart. Then go to Insert Chart.

screen-shot-2016-11-07-at-11-05-06-pm

Now, here’s a trick to download your chart for further customization in Adobe Illustrator or Inkscape.

Make sure you are using Google Chrome for your browser. Go here: http://nytimes.github.io/svg-crowbar/

Once SVG Crowbar is installed. You can download your chart to your favorite art and design application.

baseball-teams

screen-shot-2016-11-07-at-11-10-44-pm

Feel free to experiment with the other 1908 tabs. See if you can explore them and create meaningful charts.


Hall of Fame Batters

Go to File —> Make a Copy

Download the worksheet as a CSV file.

Go to Inzight Litehttp://lite.docker.stat.auckland.ac.nz/

Go to File —> Import Dataset

*Histogram: See distribution of a single variable: Count of players per era.
*Compare distributions of Home Runs per Era: this changes to a dotplot, with a boxplot underneath

scannable-document-on-aug-5-2015-4_45_11-pm

 

screen-shot-2016-11-07-at-11-24-44-pm

*Code more variables (colors and style)
*Advanced —> Explore: Let iNZight give you a tour!


What can’t iNZight Lite do? It’s just not quite as robust as running it as package through R. I use R Studio, an  IDE for the R language.

First, download iNZight to your desktop: https://www.stat.auckland.ac.nz/~wild/iNZight/getinzight.php

Follow the installation instructions.

Next, open up R Studio. Create a new script. Copy-and-paste this text into the script editor:


 

install.packages(c(“vit”, “iNZightMR”, “iNZightTS”, “iNZightModules”, “iNZightRegression”, “iNZightPlots”, “iNZight”, “iNZightTools”),
                 repos = c(“http://r.docker.stat.auckland.ac.nz/R”,
                           “http://cran.stat.auckland.ac.nz”))    # or your preferred CRAN Mirror
library(vit)
iNZightVIT()


screen-shot-2016-11-07-at-11-32-36-pm
screen-shot-2016-11-07-at-11-32-13-pm

Today we learned how to survey, sift, summarize, sort, filter,  and visualize your data.

We learned what things to look out for during the visual analysis process of boxplots and scatterplots/ bubbleplots.

We learned how to leverage the power of free tools: Google Sheets and iNZight.

We learned how to export your visualizations into art and design applications, such as Adobe Illustrator, for further crafting, creating a delightfully informative read.

Thank you!


Questions?

Mapping Knowledge

Google Maps:

Requirements: Google Account

Set up:

  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 “Your Places,” then “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 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. Click the paint bucket icon
    2. Select a color and shape from the drop down menu to determine the appearance of the location pins.
    3. Click “more icons” to see even more options
  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”

StoryMap JS:

Requirements: Google Account; Chrome is recommend

Instructions:

  1. Go to https://storymap.knightlab.com
  2. Click “Create”
  3. Select “Login with your Google Account”
  4. Click the green button labeled “New”
  5. Give your map a title and click “Create”
  6. Type the name of your map under “HEADLINE”: this is the title of your map
  7. Enter a description of your map in the text field under “HEADLINE”
  8. Upload an image for your homepage (click on “Upload an image”) or paste a URL of an image or video into the field labeled “URL to your media.” Add credit and caption if desired
  9. Click “Add Slide” to add a new slide
  10. Repeat steps 6-8 for each location where you’ve lived
  11. Type the location you’d like to mark on the map into the box labeled “Search.” Feel free to use the + and – buttons to zoom in.
  12. Click the “Save” button occasionally to save data
  13. When you’ve added all your locations, click the “Options” button.
    1. You can change the map’s appearance with “Map type”
    2. If you want to preserve the level of zoom and want the map to resemble a slideshow that focuses on individual points, switch from “Cartography” to “Image” under “Treat As”
    3. If you’re interested in the relationship between the points and care less about the level of zoom, leave it on “Cartography.”
  14. To share the map, click on the “Share” button. Copy and paste the link under “link” to send in an email. To embed the map in a website, scroll down and save the “embed” code to paste in your website’s HTML editor.
  15. You’re done!

Sample Student Maps:

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/

 

Feedback?

Click here to take our questionnaire!

 

Data Visualization for the Curious Ones

Please note these steps below are not always completely rote instructions. Instead, they should offer you the broad contours to acclimate to new terrain.

Spreadsheet One: Danish Bicycles

  1. Go to Google Sheets and File > Make a Copy (make sure you have a google account and are signed in)
  2. Go to File > Download spreadsheet file as a CSV.
  3. Go to Overpass Turbo: https://overpass-turbo.eu/
  4. Search for Copenhagen, Denmark
  5. Go to Wizard. Search for cafe. Run. Export as a kml file.
  6. Go to Wizard. Search for park. Run. Export as a kml file.
  7. Go to carto.db (create an account).
  8. Go to Datasets > Connect to Dataset > Import the CSV you downloaded
  9. In Map Wizard, change marker type to IMG > Maki icons > choose bicycle icon
  10. Add layer, connect to dataset, and choose cafe kml export. In Map Wizard, change marker type to IMG > Maki icons > choose coffee cup
  11. Add layer, connect to dataset, and choose park kml export. This is a polygon instead of a point. Make the polygons light green to show how green Copenhagen is!
  12. Other possible overpass searches: trees, flower shops, & other springtime favorites.

Spreadsheet Two: Birds of New York, April 2016

  1. Go to Google Sheets and File > Make a Copy (make sure you have a google account and are signed in)
  2. Select  Row 1. Go to View > Freeze 1 row.
  3. Try out some conditional formatting. Select a column with variables in it. Go to Format > Conditional Formatting > Format Cells If.. > for text or conditional matches or Color Scale for sequential or diverging numerical highlighting.

Spreadsheet Three:  Summer Olympics Medals Winners

  1. Go to Google Sheets and File > Make a Copy (make sure you have a google account and are signed in)
  2. Select  the space between Column A and Row 1 to select the entire spreadsheet.
  3. Go to Data > Filter. Filters now appear along each column in your header row. Click on the the downward blue arrow indicating Filter. Clear the selection and choose some an item to filter, such as on sport or gender.
  4. Once you have your filter applied, go back to the space between Column A and Row 1, click on it to select your entire spreadsheet, and go back to Data > Sort Range > Click on “Data has header row” > and choose a column that has numerical values in it. Sort Z to A for descending order

Spreadsheet Four: Cherry Blossoms in Japan

1. go to drive.google.com
2. Go to the red NEW button
3. Click on it, go down to More > Connect to Apps
4. Search for “Fusion Tables
5. Then follow the same steps, but this time you will see Fusion Tables added to your list of apps.
6. You can search public datasets here and export them to Google Sheets.
7. Search for “Cherry blossoms Japan”
8. The first table The Bloom of Cherry Blossoms 2016 that comes up looks good. These tables are often Wikipedia, so of course, you’ll need to verify what you scrape is okay to use for academic work.
9. Export this table to Google Sheets.
10. To do this, go to the row number and right-click on it, and select Hide row.
11. Next, control-click on row 2 and insert 1 row above it. This will be the header row.
12. Label your headers: City; First bloom; Full bloom
13. Next, we need to Split our City column, which also has in it the Prefecture for Japan.
14. Control-click on Column A  and Insert three Columns to the right of it.
15. In cell C3, type in “=split(A2,“(“, TRUE)”
16.Select this cell. Grab the blue handle in the lower corner. Double click on it or drag down to copy and apply the formula conditionally.
17. Next, go to Edit > Find and Replace and find all of the )’s. Replace with nothing.
18. Copy-and-paste Cols. B through C into Col. I and Paste Special > Paste Values Only. Delete Col. A.
19. Select the pasted elements and move them into B through C.
20. Now we need to add a Column that tells us the time span for the peak bloom, and another one that gives us the day of the first bloom, from 1 to 365, so we can measure that against latitude (the question is, do flowers first bloom later in northern climates)?
21. Hide rows that don’t have values in them for our key variables. You can always fill these in later with more research.
20. Select the City Col. Go to Add-Ons > Get Add Ons > Search for Awesome Geocode. Use this Add-on to get Latitude and Longtitude data. Select the City Col. and run the Awesome Geocode.

These steps are getting pretty detailed. Fortunately, you can find the formulas pre-written for you on the spreadsheet. You can try writing your own formula and copying it on adjacent empty columns. Follow along with me for the rest as make a chart, merge it with more data about the Japanese prefectures in Fusion Tables, and then bring this into Tableau to do things we can’t do in Google Sheets.

 

Link to cherry blossom image (Search for My Tableau Repository/ Shapes/ ..): cherry-blossom

Tableau workbook: http://tabsoft.co/1VX51rG

 

Spreadsheet Five: Baby Names

Tableau workbook: http://tabsoft.co/1SOgBSo

 

For your reference

Data-Visualization-Resources

New Paltz as Classroom: Using an augmented reality game (ARG) for site-based learning

Click here to access Dr. Maynard’s Powerpoint Presentation

Hawksites 201: Building Blogs at SUNY New Paltz

Click here to access Dr. Greene’s Google Slides Presentation

Click here to access the worksheet from the presentation: Worksheet

Manage Your Citations Like a Pro!

Manage Your Citations: Presentation

Citations Comparison Chart Handout

Google and the Mobile Researcher
by Lydia Willoughby
Paperpile
MetaPDF

Zotero
by Madeline Veitch
Zotero
Zotero Quick Start Guide

Mendeley
by Heather Shimon
Mendeley
Mendeley Guides & Tutorials

Older posts

© 2017 DASH Lab

Theme by Anders NorenUp ↑

Skip to toolbar