Here’s a brief, kinda awkward tutorial on how to use Filter and Summary Statistics in Google Sheets.
Answer the questions (below), and keep track of your answers somewhere (a notepad?). You will input your answers into Canvas. Figure out the answers BEFORE opening Canvas, otherwise you’ll run out of time.
You’re going to work with a random sample from the Uppsala Conflict Data Program at The Department of Peace and Conflict Research, Uppsala University in Oslo, Norway. The dataset is called the Geo-referenced Event Dataset (GED) which, as the title hints, provides detailed geo-referenced information on violent events around the world.
- Download this: UCDP GED Dataset
|id||Unique event identifer|
|year||Year event began|
|month||Month event began|
|day||Day event began|
|country||Country of event|
|type_of_violence||UCDP violence type (1 = state vs. rebel 2 = rebel vs. rebel 3 = violence against civilians)|
|conflict_name||Name of conflict|
|source_article||Article event came from|
|low_death_estimate||Low estimate of number of deaths|
|high_death_estimate||High estimate of number of deaths|
|best_death_estimate||Best estimate (sum of all)|
Using the dataset, answer the following questions:
How many violent events took place in Israel in 2004?
How many more violent events took place in Afghanistan during the Summer (June, July, August) than in the Winter (December, January, February)?
How many people died (according to “best estimate”) in the worst event of state-based violence?
In what country was the most (according to “best estimate”) violent event of non-state violence perpetrated?
Find a violent event that took place on your birthday (if there are none, try adding/subtracting a day, or month, until you find one). Look up the long/lat coordinates of that event on Google Maps. Using either street view or, if street view is not available, whatever images you can find near the location of the event:
- take a screencap and save the image (you will upload to Canvas).
- Where did the event take place? What was the conflict about? Be VERY brief.
- VERY briefly describe what the location of the event looks like: nothing structured, just your reactions to what you’re seeing in the area. What do you see? What does it look like?