Week 8 - Revision history

Hivanson: /* Electronic Lab Notebook and Questions to Answer */ updated column names to reflect updated FDA database

2024-03-13T22:51:01Z

‎Electronic Lab Notebook and Questions to Answer: updated column names to reflect updated FDA database

Hivanson: /* Electronic Lab Notebook and Questions to Answer */ change dose to strenght

2024-03-12T21:22:25Z

‎Electronic Lab Notebook and Questions to Answer: change dose to strenght

Kdahlquist: remove under construction flag

2024-03-04T23:51:55Z

remove under construction flag

Kdahlquist: /* Reflect */ add more reflection questions

2024-03-04T18:30:52Z

‎Reflect: add more reflection questions

Kdahlquist: /* Shared Journal Assignment */ uncomment reading/reflection

2024-03-04T18:29:52Z

‎Shared Journal Assignment: uncomment reading/reflection

Kdahlquist: /* Electronic Lab Notebook and Questions to Answer */ remove empty line

2024-03-03T22:55:31Z

‎Electronic Lab Notebook and Questions to Answer: remove empty line

Kdahlquist: /* Electronic Lab Notebook and Questions to Answer */ clarify attribution

2024-03-03T22:54:21Z

‎Electronic Lab Notebook and Questions to Answer: clarify attribution

Kdahlquist: bring over questions

2024-03-03T22:53:24Z

bring over questions

Kdahlquist: add FDA database section

2024-03-03T22:51:49Z

add FDA database section

Kdahlquist: /* Homework Partners */ added homework partners (same as week 2)

2024-03-03T22:40:10Z

‎Homework Partners: added homework partners (same as week 2)

@@ Line 92: / Line 92: @@
 ''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>?
+# What are the names of the drug products whose active ingredient (''activeingredient'') is <code>ATROPINE</code>?
 # In what ''form''s and ''strength''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>?
+# What are the names of the drug products that are sponsored (''sponsorname'' 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>?
+# Which ''sponsorname'' 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?])

@@ Line 93: / Line 93: @@
 # 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?
+# In what ''form''s and ''strength''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.)

← Older revision		Revision as of 23:51, 4 March 2024
Line 1:		Line 1:
−	~~{{Under Construction}}~~
−
	'''This journal entry is due on Thursday, March 14, at 12:01am Pacific time.'''		'''This journal entry is due on Thursday, March 14, at 12:01am Pacific time.'''

← Older revision		Revision as of 18:30, 4 March 2024
Line 126:		Line 126:

	# Based on what you have seen of the FDA database, do you feel that you have a better understanding of how the data mentioned in section 5.1 of ''What is Code?''—Spotify music, Fitbit exercise tracking, Twitter tweets, IRS tax returns, etc.—might look when stored on a computer?		# Based on what you have seen of the FDA database, do you feel that you have a better understanding of how the data mentioned in section 5.1 of ''What is Code?''—Spotify music, Fitbit exercise tracking, Twitter tweets, IRS tax returns, etc.—might look when stored on a computer?
		+	# Which part of this assignment made the most sense to you?
		+	# Which part of this assignment do you feel least confident about?
		+	# What would you like to know more about?

	[[Category:Assignment]]		[[Category:Assignment]]

@@ Line 118: / Line 118: @@
 === Read ===
 * Return to [http://www.bloomberg.com/graphics/2015-paul-ford-what-is-code/ “What is Code?”], now looking at these sections within Section 5, “The Time You Attended the E-mail Address Validation Meeting:”
 :5.1 What is the Relationship Between Code and Data?
 :5.2 Where Does Data Live?
 :5.3 The Language of White Collars
 === Reflect ===
 # Based on what you have seen of the FDA database, do you feel that you have a better understanding of how the data mentioned in section 5.1 of ''What is Code?''—Spotify music, Fitbit exercise tracking, Twitter tweets, IRS tax returns, etc.—might look when stored on a computer?
 [[Category:Assignment]]

@@ Line 80: / Line 80: @@
 * 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.
+** You may copy protocol instructions on your page and modify them as to what '''''you''''' actually did, as long as you provide appropriate attribution in your acknowledgments section.
 ** 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.

@@ Line 74: / Line 74: @@
 # Answer the questions below.
-=== Electronic Lab Notebook ===
+=== Electronic Lab Notebook and Questions to Answer ===
-Because of the nature of the assignment this week, you will have four sections of the electronic notebook:
+Complete your electronic notebook  on your individual journal page. Your notebook entry should contain:
-# The '''purpose''':  what is the purpose of this assignment?
+'''[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]'''
-# A ''brief'' '''methods/results''' section that summarizes what you did for the tutorial.  Upload your completion certificate here.
-# A '''conclusion''' section that mirrors your purpose.
+For your electronic lab notebook this week, do the following:
-# The '''Acknowledgments''' section.
+# Upload your zipped Microsoft Access FDA database to the wiki and link to it on your individual journal page.
-#* 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:
+# Write up the methods you used to create the database, load the tables, and write your first query.
-#** 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.
-#* Acknowledge anyone else you worked with who was not your assigned partner.  This could be Dr. Dahlquist, other students in the class, or even other students or faculty outside of the class.
+''For the questions below, supply (a) the answer to the question and (b) the query that you used to answer the question.''
-#* If you copied <code>wiki syntax</code> 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.
+# What are the names of the drug products that are administered in the ''form'' <code>INJECTABLE;INTRAVENOUS, SUBCUTANEOUS</code>?
-#* If you need to reference '''''content''''', include the formal citation in your References section (see below).
+# What are the names of the drug products whose active ingredient (''activeingred'') is <code>ATROPINE</code>?
-#* You '''must''' also include this statement:
+# In what ''form''s and ''dosage''s can the drug product named <code>BENADRYL</code> be administered?
-#** '''''"Except for what is noted above, this individual journal entry was completed by me and not copied from another source."'''''
+# Which drug products have a name ''ending'' in <code>ESTROL</code>?
-#* Sign your Acknowledgments section with your wiki signature.
+# 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.)
-# The '''References''' section. In this section, you need to provide properly formatted citations to any '''''content''''' that was not entirely of your own devising.
+# 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.)
-#* Do not include citations/references to sources that you did not use.
+# What are the names of the drug products that are sponsored (''sponsor applicant'' column) by <code>MERCK</code>?
-#* You should include a reference to this week's assignment page.
+# 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>?
-#* The references should be formatted according to the [https://owl.purdue.edu/owl/research_and_citation/using_research/documents/20180719CitationChart.pdf APA guidelines].
+# 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?])
-#* For more detailed guidelines, please see the document [[Media:BIOL367_Spring2024_GuidelinesforLiteratureCitations.pdf | 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 2024. (2024). Week 1. Retrieved August 27, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/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.
+==== Data and Files ====
 == Shared Journal Assignment ==

@@ Line 59: / Line 59: @@
 ** Select "Extract all".
 ** Click the "Extract" button.
 === Electronic Lab Notebook ===

@@ Line 24: / Line 24: @@
 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 & Andrew
+* Katie & Charlotte
+* Natalija & Dean
 === Preliminary Tasks ===