Difference between revisions of "Week 6"

From LMU BioDB 2024
Jump to navigation Jump to search
(LinkedIn Learning Tutorial for Microsoft Access: start editing the preliminary instructions settings)
(Individual Journal Assignment: take out references to FDA database)
Line 89: Line 89:
 
-->
 
-->
  
<!--
 
=== The FDA Drug Database ===
 
  
The United States Food and Drug Administration (FDA) provides, as a matter of public record, the full data set for its approved drugs at this website: http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm
 
 
The site includes both a link to the downloadable files (compressed in .zip format) and the schema (“entity relationship diagram”) for those files.
 
 
Using these files, what you have learned in the LinkedIn Learning tutorial, and additional information found in this wiki and on the aforementioned FDA website, do the following:
 
 
# Download and decompress the files.
 
# Import the data files into a Microsoft Access database you will create.
 
# Configure the fields in your tables to match the schema provided by the FDA (keys, datatypes).
 
# Set the relationships between your tables to match the schema provided by the FDA.
 
# Answer the questions below.
 
-->
 
 
<!--
 
 
=== Electronic Lab Notebook and Questions to Answer ===
 
 
Complete your electronic notebook  on your individual journal page. Your notebook entry should contain:
 
* The '''purpose''':  what was the purpose of your investigations?
 
* Your '''methods''': what did you actually do?  Give a step by step account for Tasks 1-4 listed above.
 
** There should be enough detail provided so that you or another person could re-do it based solely on your notebook.
 
** You may copy protocol instructions on your page and modify them as to what '''''you''''' actually did, as long as you provide appropriate attribution.
 
** Take advantage of the electronic nature of the notebook by providing screenshots, links to web pages, links to data, etc.
 
* Your '''results''': the answers to the questions below, plus any other results you gathered.
 
** Usually it makes sense to embed your answers to the questions/results in the "methods" in the order in which you obtained them.
 
* A '''scientific conclusion''':  what was your main finding for today's project?  Did you fulfill the purpose?  Why or why not?
 
 
'''[https://support.office.com/en-us/article/access-sql-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671 Access SQL: basic concepts, vocabulary, and syntax]'''
 
 
For your electronic lab notebook this week, do the following:
 
# Upload your zipped Microsoft Access FDA database to the wiki and link to it on your individual journal page.
 
# Write up the methods you used to create the database, load the tables, and write your first query.
 
 
We will work with this database for a future assignment in the class.
 
-->
 
 
<!--
 
''For the questions below, supply (a) the answer to the question and (b) the query that you used to answer the question.''
 
# What are the names of the drug products that are administered in the ''form'' <code>INJECTABLE;INTRAVENOUS, SUBCUTANEOUS</code>?
 
# What are the names of the drug products whose active ingredient (''activeingred'') is <code>ATROPINE</code>?
 
# In what ''form''s and ''dosage''s can the drug product named <code>BENADRYL</code> be administered?
 
# Which drug products have a name ''ending'' in <code>ESTROL</code>?
 
# Produce a table listing all of the known values for the ''therapeutic_potential'' column in the ''application'' table and how many ''application'' records there are of each. (''Side note:'' The ''therapeutic_potential'' codes are explained in the ''ReviewClass_Lookup.txt'' file, in case you’re interested.)
 
# Produce a table listing all of the known values for the ''chemical_type'' column in the ''application'' table and how many ''application'' records there are of each. (''Side note:'' The ''chemical_type'' codes are explained in the ''ChemTypeLookup.txt'' file, in case you’re interested.)
 
# What are the names of the drug products that are sponsored (''sponsor applicant'' column) by <code>MERCK</code>?
 
# Which ''sponsor applicant'' companies have the text <code>LABS</code> in their names and have products whose active ingredients (''activeingred'') include ''both'' <code>ASPIRIN</code> and <code>CAFFEINE</code>?
 
# Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database ([https://www.accessdata.fda.gov/scripts/cder/daf/index.cfm Drugs@FDA?])
 
-->
 
 
<!--
 
==== Data and Files ====
 
 
* References to data and files should be made within the methods and results section of your notebook.
 
* In addition to these inline links, create a "Data and Files" section of your notebook to make a list of the files generated in this exercise.  In particular, you will need to zip and upload a compressed version of your MS Access FDA drug database.  Make sure that your filename contains your last name or username to distinguish it from databases created by other students in the class.
 
-->
 
  
 
<!--
 
<!--

Revision as of 12:53, 15 February 2024

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 Microsoft Access

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

  • To access the LinkedIn Learning tutorial, do the following:
    • Go to LinkedIn Learning portal.
    • Enter your LMU lion email address, and click continue
    • You will be prompted to enter your LMU username and password on an LMU Authentication page.
  • Complete the course called Learning Access for Office 365 by Adam Wilbert. It is 1 hour and 7 minutes long. Be sure that you are selecting the right course because there are several for Microsoft Access. It is best if you follow along doing the exercises. The files needed are downloadable from the tutorial.
    • We will have time in class on Tuesday, February 20 to work on this, but you are welcome to get started before that.
      • Please bring headphones/ear buds to class on Tuesday, if possible so that you can listen to the tutorial video at your own pace.
    • Microsoft Access is not available on computers running MacOS. It is available on the Windows computers in Seaver 120. There are also 22 computers running Windows in the Hannon Libray Information Commons that have Microsoft Access installed.
  • 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 6 of you uploading similar files.
    • Also, be sure to use the syntax [[Media:filename | visible label]] to create the link, not [[File:filename]].





Shared Journal Assignment

  • Store your journal entry in the shared Class Journal Week 6 page. If this page does not exist yet, go ahead and create it (congratulations on getting in first :) )
  • Link to the Class Journal page from your user page (should be part of your template).
  • Link back from the Class Journal page to your user page.
  • Sign your portion of the journal with the standard wiki signature shortcut (~~~~).
  • Add the "Journal Entry" and "Shared" categories to the end of the wiki page (if someone has not already done so).

Read

5.1 What is the Relationship Between Code and Data?
5.2 Where Does Data Live?
5.3 The Language of White Collars

Reflect

  1. What are the advantages of using a database, like Microsoft Access, instead of a spreadsheet program, like Microsoft Excel, when managing your data?
  2. Which part of the tutorial made the most sense to you?
  3. Which part of the tutorial do you feel least confident about? What would you like to know more about?
  4. The blog post mentions a "fraught relationship about data, privacy, and how private companies operate in public spaces."
    • What is this fraught relationship?
    • How do you feel about it? I.e., where do you stand on the trade-off between the "ease of use" you receive as a user and giving up your private data to companies who will use it to turn a profit?
    • What are the social justice issues involved?