Tracking Sources in a Spreadsheet

Creative Commons licensed image posted at Flickr by Daniel Dudek-Corrigan

Creative Commons licensed image posted at Flickr by Daniel Dudek-Corrigan

Once you find more than four or five sources, you can start to lose track of what you have.

Activity

  1. Create a table in a Word, Excel, or Google Doc or Spreadsheet. Include at least five rows and five columns. Use this table as an example (you may also COPY this table to your own document).
  2. At the top of the document, write your focused research topic, question, or thesis.
  3. In the far left column, list last name of the author and the year of publication of each source.
  4. In the columns to the right of each source provide the following information:
    • full bibliographic citation
    • summary of the source
    • brief analysis of how/why the source is useful to answering your research question
    • brief analysis of how/why the source is authoritative and credible
  5. Share-out: In the comments thread below, upload a document with your notes or provide a link to where you have posted your notes elsewhere (make sure they are posted publicly).