Difference between revisions of "Talk:Week 6"
Jump to navigation
Jump to search
Kdahlquist (talk | contribs) (add link for later reference) |
Kdahlquist (talk | contribs) (comment out) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
https://its.lmu.edu/brightspace/linkedinlearningintegration/ | https://its.lmu.edu/brightspace/linkedinlearningintegration/ | ||
| + | |||
| + | <!-- | ||
| + | === 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 === | ||
| + | |||
| + | 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. | ||
| + | --> | ||
| + | |||
| + | <!-- | ||
| + | ==== Compressing and Decompressing Files with 7-Zip ==== | ||
| + | |||
| + | * The 7-Zip file compression software has been installed on the computers in Seaver 120. (If you want to install this software on your own computer, go to the [http://www.7-zip.org/ 7-zip Download page].) To compress a single file or a group of files, do the following: | ||
| + | *# Select all of the files you want to zip together by clicking and dragging or control-clicking on the filenames. | ||
| + | *# Right-click on your selection. In the context menu that appears, select the menu option: 7-Zip > Add to archive | ||
| + | *# Make sure there is a meaningful filename in the field under the word "Archive:". If not, change it to something that is. Typically you will want to include your name or initials, a short descriptor of what the file contains, and the date in year-month-day format (yyyy-mm-dd). | ||
| + | *# Select "zip" as the Archive format. | ||
| + | *# You do not need to change any of the other defaults. Click OK. The zip file will appear in the same folder as the files you compressed. | ||
| + | * To decompress files with 7-zip, right click on the file icon. From the context menu that appears, select 7-zip > Extract Here. | ||
| + | ** Note that Windows Explorer will allow you to view the contents of a zipped archive without actually decompressing them. It may even seem like you can open them or otherwise manipulate them. However, issues will arise from doing this, most commonly, not being able to save your changes. Always make sure that you decompress (unzip) the files before using them. | ||
| + | --> | ||
