Week 6

This page is under construction.

This journal entry is due on Thursday, February 22, at 12:01am Pacific time.

Overview

The purpose of this assignment is:

• To become familiar with a relational database using the Microsoft Access software

Individual Journal Assignment

• Store this journal entry as "username Week 6" (i.e., this is the text to place between the square brackets when you link to this page).
• Invoke your personal template that you created for the Week 1 Assignment on your individual journal entry page. Your template should provide the following set of navigation links:
  • Link to your user page.
  • Links to the weekly Assignment pages.
  • Links to your weekly Individual Journal entry pages.
  • Links to the weekly Class Journal pages.
  • The category "Journal Entry".

Homework Partners

You will work in groups of two for this week's assignment. Please sit next to your partner in class. You will be expected to consult with your partner, in order to complete the assignment. However, unless otherwise stated, each partner must submit his or her own work as the individual journal entry (direct copies of each other's work is not allowed). Homework partners for this week are:

• Hailey & Charlotte
• Katie & Natalija
• Dean & Andrew

LinkedIn Learning Tutorial for MS Access

LMU provides free accounts to LinkedIn Learning (formerly Lynda.com). You will take advantage of this resource by using the tutorial for learning Microsoft Access, the database software we will use in this class.

• This page explains how to access LinkedIn Learning using your LMU credentials.
• Complete the tutorial called "Learning Access 2016" by Adam Wilbert (Released on May 4, 2016). It is 1 hour and 6 minutes long. Be sure that you are selecting the right tutorial because there are several for MS Access.
• When you are finished, download the certificate of completion, upload it to this wiki and link to it on your individual journal page. Be sure to change the filename so that it is specific to you (e.g., add your last name or username to the filename) because there will be 14 of you uploading similar files.

• For Google Chrome (Version 44.0.2403.157 m or higher)
  • Options set to default downloads to Desktop and to ask each time a file is downloaded
    • Go to Settings page, click on link to "Show advanced settings"
    • First, under the "Downloads" section, click the "Change..." button, select the T: drive, and click the OK button.
    • Second, check the box next to "Ask where to save each file before downloading"

Note that for the computers in Seaver 120, anything saved to the Desktop, My Documents, Downloads, or any other folder will be deleted when the computers are restarted. To make sure that your work will still be available to you, save your files to the T: drive. ("T" stands for the "thawspace" of the Deep Freeze software that manages the deletions.)

Acknowledgments

In this section, you need to acknowledge anyone who assisted you with your assignment, either in person, electronically, or even anonymously without their knowledge.

1. You must acknowledge your homework partner or team members with whom you worked, giving details of the nature of the collaboration. You should include when and how you met and what content you worked on together. An appropriate statement could be (but is not limited to) the following:
   • I worked with my homework partner (give name and link name to their user page) in class. We met face-to-face one time outside of class. We texted/e-mailed/chatted online three times. We worked on the <details> portion of the assignment together.
2. Acknowledge anyone else you worked with who was not your assigned partner. This could be Dr. Dahlquist (for example, via office hours), the TA, other students in the class, or even other students or faculty outside of the class.
3. If you copied wiki syntax or a particular style from another wiki page, acknowledge that here. Provide the user name of the original page, if possible, and provide a link to the page from which you copied the syntax or style.
4. If you need to reference content (such as the methods of a protocol), that belongs in the References section where you will give a include a formal APA-formatted citation (see below).
5. You must also include this statement unless otherwise noted:
   • "Except for what is noted above, this individual journal entry was completed by me and not copied from another source."
6. Sign your Acknowledgments section with your wiki signature.

References

• In this section, you need to provide properly formatted citations to any content that was not entirely of your own devising. This includes, but is not limited to:
  • methods
  • data
  • facts
  • images
  • documents, including the scientific literature
• Do not include extraneous references that you do not cite or use on your page.
• The references in this section should be accompanied by in text citations on your page that refer to these references.
• The references should be formatted according to the APA guidelines.
• For more detailed guidelines, please see the document Guidelines for Literature Citations in a Scientific Paper that you were given on the first day of class.
• Cite the appropriate weekly Assignment page. For example, the citation for the Week 1 Assignment page is: LMU BioDB 2019. (2019). Week 1. Retrieved August 27, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_1
• Even if you have nothing else to cite, the References section must be present and include the citation to the appropriate weekly assignment page.