How I Organize Sources and Citations for Papers and Research Projects with Google Sheets. In this video, I'll tell you how I use Google Sheets to organize my citations and sources for papers and research projects.
Please subscribe and leave comments below!
**** A truncated transcript follows. A full transcript can be found at www.marblejar.net. ****
Sample Google Spreadsheet: https://docs.google.com/spreadsheets/d/1PaQbDLrTFptlZAlarTkdj_syYBxs1zUaqqXulF1e11A/edit?usp=sharing
Hi, everyone! This is Lara Hammock from the Marble Jar channel and in today's video, I'll tell you how I use Google Sheets to organize my citations and sources for papers and research projects.
I'm in my first year of graduate school and we do a lot of writing. References and citations are very important, as they are for any discipline. I supposed if I was writing a dissertation with a hundred citations, I would feel the need to pay for and learn a whole complicated citation software, but since I'm not, I prefer to use tools that I already use and know well. AND despite the fact I'm not writing a dissertation, I have written some papers that have had over 25 sources, so I do need SOME kind of system to organize and manage my citations.
I started out, as most people do, with kind of a hodge-podge system of just cutting and pasting URLs from the Internet and sticking them at the bottom of the Word document of the paper. Or, if I'm doing research, I'd just copy and paste URLs with maybe some quotes from the study or article. The problem was, if I had multiple quotes, I couldn't organize them by topic for fear of losing the reference link, or I'd have to duplicate the URL multiple times. Plus, scrolling down to check these references was annoying. I needed a better, less messy system.
Here's what I do now. For each research project or paper, I create a new Google Sheets spreadsheet for references. You could easily do this in any spreadsheet program. I name it something like Class name - Project name - Citations and Quotes. Let's use a research project that I just did for my Policy class as an example. My spreadsheet name is "Policy - Ex-Felon Voting Rights Citations and Quotes." Then -- I make 2 tabs. The first tab is called Quotes, the second is Sources. I'm going to put a sample of this Citation Spreadsheet up on my Google Drive to share with you. To use it, just follow the link that I will provide in the notes section, make a copy into your own Drive, and then use it or modify it as you see fit. Back to the spreadsheet -- so, now as I'm doing my research and reading a bunch of different articles -- in this case, mostly news articles and opinion pieces -- I starting finding quotes or statistics that help me to understand the issue or that I might want to use in my paper. So, I copy the quote and paste it into this first column. Okay -- the second column is a reference number. I'm going to want to remember where I got this quote from -- so go to the article and copy the URL or website address. I note some basics about the source and what the article is about -- in this case it's an Editorial from The Washington Post Editorial Board. Now I go into the Sources tab paste the URL under website address, note some basics about the article -- more for my own recall ability than anything else, and I number it -- #1. Now, I'm going to have a bunch of other articles to put in here, so I might as well go ahead and fill in these numbers, 1 to 10. Okay, back to the Quotes tab, I'm going to indicate that this quote came from article #1. Now, I can paste several quotes from the same article, I just need to indicate where they came from. So, here is my completed spreadsheet for this research project. I have 13 sources and 38 quotes. I obviously did not use all of those in my paper, but they helped to shape my understanding of the topic and served as a repository for the quotes and statistics that I DID end up using. . .
**** A full transcript can be found at www.marblejar.net. ****
Tags: How I Organize Sources and Citations for Papers and Research Projects with Google Sheets, Marble Jar, Marble Jar channel, Lara Hammock, Grad School, Organizing for School, Organize, Google Sheets, Citations, Resources, Sources, Papers, Research Projects