Workshop: Importing your Data into PSLC DataShop - June 2011

When: Tuesday, June 14, 2011, 9:30am-1:30pm (lunch will be provided)

Where: CMU, Gates-Hillman Center (GHC) 6115

During this interactive half-day event, you'll have the opportunity to learn how you to get your data into DataShop. You'll also hear a case study from CMU Systems Scientist Phil Pavlik on his experience of importing tutor data into DataShop.

Be sure to bring a laptop so that you can participate in the hands-on portion. Also feel free to bring your own tutor data (in Excel or a tab delimited format) to get started or we will supply example data for the hands-on portion.

Files and Hand-outs

import_file1.zip

Hands On.pptx

DataShop Cheat Sheet (pdf)

Demo/screencast from Phil Pavlik

In these short videos, CMU Systems Scientist Phil Pavlik shows how he exports data from his MySQL database, verifies the tab-delimited files with the DataShop import verify tool, and uses DataShop web services to programmaticaly retrieve data from DataShop.

Schedule

09:30am - 10:00am DataShop Overview
10:00am - 10:30am The Data Model
10:30am - 10:45am Break
10:45am - 11:45am Importing Data (hands on)
11:45am - 12:00pm Exporting Data
12:00pm - 12:30pm Case Study - Phil Pavlik
12:30pm - 1:30pm Lunch and Discussion (optional)

Survey

Workshop survey