Week 4 - Revision history

Kdahlquist: fix due dates

2019-10-08T19:19:09Z

fix due dates

Kdahlquist: removed under construction flag

2019-09-24T23:21:40Z

removed under construction flag

Kdahlquist: /* Electronic Lab Notebook and Questions to Answer */ commented out questions, added what needs to be done

2019-09-24T23:21:13Z

‎Electronic Lab Notebook and Questions to Answer: commented out questions, added what needs to be done

Kdahlquist: /* Electronic Lab Notebook and Questions to Answer */ add link to Access sql help

2019-09-24T19:37:00Z

‎Electronic Lab Notebook and Questions to Answer: add link to Access sql help

Kdahlquist: /* Reflect */ added another question

2019-09-19T21:07:26Z

‎Reflect: added another question

Kdahlquist: /* Electronic Lab Notebook and Questions to Answer */ add step-by-step

2019-09-19T20:51:41Z

‎Electronic Lab Notebook and Questions to Answer: add step-by-step

Kdahlquist: add another question

2019-09-19T20:50:30Z

add another question

Kdahlquist: /* Data and Files */ what file to upload

2019-09-19T20:45:07Z

‎Data and Files: what file to upload

Kdahlquist: /* Electronic Lab Notebook and Questions to Answer */ add electronic lab notebook

2019-09-19T20:42:52Z

‎Electronic Lab Notebook and Questions to Answer: add electronic lab notebook

Kdahlquist: start modifying questions

2019-09-19T20:41:50Z

start modifying questions

@@ Line 1: / Line 1: @@
-'''This journal entry is due on Thursday, September 19, at 12:01am Pacific time.'''
+'''This journal entry is due on Thursday, September 26, at 12:01am Pacific time.'''
-'''''Note that there is an <u>interim</u> deadline of Tuesday, September 17, at 2:00pm Pacific time to complete the [[Week_4#LinkedIn_Learning_Tutorial_for_MS_Access | LinkedIn Learning tutorial]] and upload your completion certificate to your individual journal page.'''''
+'''''Note that there is an <u>interim</u> deadline of Tuesday, September 24, at 2:00pm Pacific time to complete the [[Week_4#LinkedIn_Learning_Tutorial_for_MS_Access | LinkedIn Learning tutorial]] and upload your completion certificate to your individual journal page.'''''
 == Overview ==

← Older revision		Revision as of 23:21, 24 September 2019
Line 1:		Line 1:
−	~~{{Under Construction}}~~
−
	'''This journal entry is due on Thursday, September 19, at 12:01am Pacific time.'''		'''This journal entry is due on Thursday, September 19, at 12:01am Pacific time.'''

@@ Line 108: / Line 108: @@
 '''[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 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>?
@@ Line 118: / Line 125: @@
 # 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 ====

@@ Line 105: / Line 105: @@
 ** 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?
 ''For the questions below, supply (a) the answer to the question and (b) the query that you used to answer the question.''

@@ Line 168: / Line 168: @@
 === Reflect ===
 # The blog post mentions a "fraught relationship about data, privacy, and how private companies operate in public spaces."
-#* What is this fraught relationship and how do you feel about it?
+#* What is this fraught relationship?
-#* 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?
+#* 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?
 # 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 98: / Line 98: @@
 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.
+* 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.

@@ Line 96: / Line 96: @@
 === Electronic Lab Notebook and Questions to Answer ===
-# Provide the DDL (<code>create table</code>) statements that you used for your ''application'' and ''product'' tables.
+Complete your electronic notebook  on your individual journal page. Your notebook entry should contain:
-# Provide the <code>sed</code> command sequences that you used to convert the raw text files into sequences of SQL <code>insert</code> statements.
+* The '''purpose''':  what was the purpose of your investigations?
-# Using the command line, how can you determine the number of records in each file? Provide the command.
+* Your '''methods''': what did you actually do?  Give a step by step account.
-# Using SQL, how can you determine the number of records in the table corresponding to the file? Provide the SQL <code>select</code> statement.
+** There should be enough detail provided so that you or another person could re-do it based solely on your notebook.
-# In your database, are these numbers the same or different? Explain why you think so.
+** You may copy protocol instructions on your page and modify them as to what '''''you''''' actually did, as long as you provide appropriate attribution.
-#: ''For the remaining questions, supply (a) the answer to the question and (b) the SQL statement that you used to answer the question.''
+** Take advantage of the electronic nature of the notebook by providing screenshots, links to web pages, links to data, etc.
 # 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>?
@@ Line 110: / Line 115: @@
 # 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 ====

@@ Line 127: / Line 127: @@
 ==== Data and Files ====
-* Files left on the Desktop or My Documents or Downloads folders on the Seaver 120 computers will be deleted upon restart of the computers.  Files stored on the <code>T:</code> drive will be saved.  However, it is not a good idea to trust that they will be there when you next use the computer.
+* References to data and files should be made within the methods and results section of your notebook.
-* Thus, it is a critical skill for data and computer literacy to back-up your data and files in at least '''two''' ways:
+* 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.
 ==== Acknowledgments ====

@@ Line 41: / Line 41: @@
 * 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.
-=== The FDA Drug Database ===
+=== Preliminary Tasks ===
-==== Preliminary Tasks ====
+==== Turning on File Extensions in Windows 10 ====
 * The Windows 10 operating systems defaults to hiding file extensions.  To turn them back on, do the following: [[Image:FolderOptions.jpg|right|Folder Options window]]
@@ Line 64: / Line 52: @@
 * The computers in Seaver 120 are are set to erase all custom user settings and restore the defaults once they have been restarted, so if you have done this previously, you might have to do it again.
-===== Setting the Download Options for FireFox and Chrome =====
+==== Setting the Download Options for FireFox and Chrome ====
 * For Mozilla FireFox (40.0.2 or higher)
@@ Line 81: / Line 69: @@
 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.)
-===== Compressing and Decompressing Files with 7-Zip =====
+==== 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:
@@ Line 92: / Line 80: @@
 ** 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.
-==== Supplementary Information ====
+=== The FDA Drug Database ===
-=== Questions to Answer ===
+=== Electronic Lab Notebook and Questions to Answer ===
 # Provide the DDL (<code>create table</code>) statements that you used for your ''application'' and ''product'' tables.