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
|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.