ITMG 320 Assignment Two and Three


Due Thursday  28 January 2021 Assignment 2 and Tuesday 2 February 2021


System Design/Development Library Project


Part One Data Collection and Conversion (A2)


This assignment is meant to illustrate how ‘real’ hard copy information is obtained and transposed by computers into a form that is easy to use, access, query, and analyze. The first part of the assignment is to collect data and enter it into an Excel table. The second part of the assignment will be the conversion of this Excel data into an Access Database (which will be done in class). The data you will need to collect is the listing of articles within a journal (s) of your choice; each article title, with all relevant authors, list the journal name, the month (if applicable), the year, the volume #, the issue #, the pages that the article resides on, and any applicable article keywords. You will want to collect between 25 and 30 journal articles (this will amount to about 5-7 different journals). This information can be obtained from the library both physically and electronically.

Your Excel table set up should exactly look like the picture below. This assignment is due in the beginning of class on Wednesday—you will turn it it via email and bring it to class on a USB drive (or you can send it to yourself and download it from your email in class). You should name your file specifically as “YOUR_LAST_NAME_A2.xls). You will also need to make a copy of your table of contents for each journal issue that you have entered in your excel sheet (mainly for reference in case of data entry mistakes).

Note that auth is shortened for author 3, author 4, etc. proc stands for proceedings.



Marco 5 De Los Santos
Samuel 3 Diercks
Aidan 3 Filipovic
Eduardo 3 Garza
Gavin 4 Georgitsis
Thomas 1 Hollerbach
Matthew 1 Holmes
Darvyn 3 Jean-Baptiste
Daniel 5 Johnson
Margaret 1 Kahn
Maeve 4 Kearney
Nicole 4 Morrison
Guilherme 2 Osorio
Tiara 5 Sirois
Sara 2 Skoglund
Bennett 3 Williams