Introduction
Over the next several classes you will be learning how to work with data through a specific historical source: a visitor logbook from the occupation of Alcatraz Island by Native American activists from 1969-1971. I’ve assigned some background reading for you to understand the historical context for this important source here: Joe D. Horse Capture, “The Alcatraz Logbook: Signs of Red Power” The Autry Museum of the American West Blog (October 12, 2020). Our goal as a class over the next two weeks is to study this historical source as data: understanding its context and creators, constructing a dataset from its pages, analyzing that derived data, and visualizing some of these results to look for patterns.
Getting to know your data
The most important step when approaching a potential source of data is to familiarize with the source itself. I am going to set a timer for 10 minutes, during which you are going to explore the Alcatraz Logbook, which has been digitized and is available here: https://user-x7tacjj.cld.bz/Alcatraz-Log-Book/. Try to get a sense for the source:
- Don’t try to read every word! The goal of this exercise is skim and understand the layout of the document and get a taste for its content.
- Primary sources and manuscripts often contain important contextual information in a few places: the front cover, inside front cover, first several pages, last several pages, inside back cover, and back cover. Look at these first.
- What is the main kind of information that is written in this document?
- How is that information recorded in the logbook? Is the way it’s recorded consistent or does it change from page to page?
- What kind of printed document was this and what is its intended use? How does that compare to how it was used by activists?
- What is the rough chronology of the recorded information in this source? When does it start and when does it end?
- Who are the creators of this source?
Structure your spreadsheet
DRawing on some of the lessons from today’s reading, come up with a plan in your group for how to structure a spreadsheet in order to record information from this source: Group 1 spreadsheet and Group 2 spreadsheet. Aim to have the following completed within 15 minutes:
- What kind of information do you want to capture? What are you NOT going to capture?
- As a group, use Row 1 to type in preliminary column headers (labels) for the different kinds of information you are going to record.
- Each person in the group choose a random page from the logbook that has information in it (not the first page). Look at the information written on that page and then try to input one row in your spreadsheet based on that page (you are not trying to transcribe the entire page, just one “observation” of data).
- Were you able to effectively capture that information on that page in your group’s spreadsheet with your current column headers? Do you see any problems with your headers? Revise or adjust your column headers and then each of your individual rows as needed.
Notify Professor Blevins when you have completed this section and then we will look at the spreadsheets together as a full class.