I worked on each of the tasks on the Info Literacy Test over the period of about a week. Some tasks took just a couple of minutes, for example the VPN/FTP task, while others took a couple of hours, for example the database task. I found a couple of the tasks unexpectedly challenging. The word processing task was no problem, although I found myself triple checking that I hadn’t overlooked any details. The Spreadsheet task was a bit frustrating because I wasn’t able to change the date format in Excel. I think a system preset was overriding my changes. Anyway, I moved the file to Google Sheets and completed the task there. I still need to go back and check my settings in Excel to see if I can find the issue with the date formatting. That caused some frustration because it seemed like it should be the easiest part of the task.

I used PHPMyAdmin to create an SQL database to run the two queries in task four. I saved the query results for step 2 and 3 as two separate tables shown below and saved my database as a .sql file. After doing this I smacked myself in the head and installed Access on my husband’s PC. Since I have already completed the task, I’m sharing my results here. I’ll go back and see if I can get the same result in Access.

Query 2 results:

Blanchett Cate E. The Lord of the Rings: The Fellowship of the Ring A meek hobbit of the Shire and eight companions set out on a journey to Mount Doom to destroy the One Ring and the dark lord Sau 2001
Blanchett Cate E. The Lord of the Rings: The Two Towers While Frodo and Sam edge closer to Mordor with the help of the shifty Gollum, the divided fellowship makes a stand against Sauro 2002
Blanchett Cate E. The Lord of the Rings: The Return of the King Gandalf and Aragorn lead the World of Men against Sauron's army to draw his gaze from Frodo and Sam as they approach Mount Doom 2003
Blanchett Cate E. Elizabeth A film of the early years of the reign of Elizabeth I of England and her difficult task of learning what is necessary to be a mo 1998
Blanchett Cate E. Elizabeth: The Golden Age A mature Queen Elizabeth endures multiple crises late in her reign including court intrigues, an assassination plot, the Spanish 2007
Blanchett Cate E. The Curious Case of Benjamin Button Tells the story of Benjamin Button, a man who starts aging backwards with bizarre consequences 2008

Query 3 results

100002 Brando Marlon Jr. AGT45677 The Godfather 1972 175 R
100003 Keaton Diane AGT45677 The Godfather 1972 175 R
702365 Pacino Alfredo J. AGT45677 The Godfather 1972 175 R
100003 Keaton Diane AGT45678 Something's Gotta Give 2003 128 PG-13
702366 Nicholson Jack AGT45678 Something's Gotta Give 2003 128 PG-13

Task five, six and seven are in my comfort zone. I already use an FTP program on a regular basis and had installed the UBC VPN several weeks ago. I’m always fiddling with HTML and CSS but I just had a revelation about the difference between "font-family" and "font-style", so there’s always something new to learn. Right now my cats own my Tumblr account so I’ll have to wrestle it away from them to complete the final task.

  1. Word Processing Task
  2. Spreadsheet Task
  3. Presentation Task
  4. Database Task SQL, Database Task ACCDB