MSymond1 Week 8 - Revision history

Msymond1: added references

2024-03-14T06:39:49Z

added references

Msymond1: /* Acknowledgments */ signature

2024-03-14T02:55:06Z

‎Acknowledgments: signature

Msymond1: /* Acknowledgments */ added punctuation

2024-03-13T22:41:48Z

‎Acknowledgments: added punctuation

Msymond1: /* Acknowledgments */ added statement

2024-03-13T22:41:30Z

‎Acknowledgments: added statement

Msymond1: /* Data and Files */ added second file

2024-03-13T22:33:05Z

‎Data and Files: added second file

Msymond1: /* Data and Files */ Added file

2024-03-13T22:31:59Z

‎Data and Files: Added file

Msymond1: /* Results */ added section

2024-03-13T22:30:54Z

‎Results: added section

Msymond1: /* Results */ added rest of files

2024-03-13T22:27:08Z

‎Results: added rest of files

Msymond1: /* Results */ added file

2024-03-13T22:25:54Z

‎Results: added file

Msymond1: /* Results */ added first file

2024-03-13T22:23:24Z

‎Results: added first file

@@ Line 21: / Line 21: @@
 ==Acknowledgments==
 My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm FDA Website]. Except for what is noted above, this individual journal entry was completed by me and not copied from another source. [[User:Msymond1|Msymond1]] ([[User talk:Msymond1|talk]]) 19:55, 13 March 2024 (PDT)
 {{Template:MSymond1}}

@@ Line 20: / Line 20: @@
 The main findings from this assignment are that using databases made by certain programs such as Microsoft Access are very helpful in obtaining information that would not be possible otherwise. It does, however, come with many difficulties. It was noted that data in the real world is not often "clean" and it is not possible to put it directly into a database and expect it to work perfectly. There were many problems with this data set being very old in this assignment as well. Two of the questions could not even be answered anymore because of columns that no longer exist. There were also many issues in assigning primary keys to the data set. For the keys that the FDA listed on the website would often have several duplicates in the dataset, meaning it is unable to be a primary key. For all of these imperfections, using these databases did prove to be very helpful in the field.
 ==Acknowledgments==
-My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm FDA Website]. Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
+My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm FDA Website]. Except for what is noted above, this individual journal entry was completed by me and not copied from another source. [[User:Msymond1|Msymond1]] ([[User talk:Msymond1|talk]]) 19:55, 13 March 2024 (PDT)
 {{Template:MSymond1}}

@@ Line 20: / Line 20: @@
 The main findings from this assignment are that using databases made by certain programs such as Microsoft Access are very helpful in obtaining information that would not be possible otherwise. It does, however, come with many difficulties. It was noted that data in the real world is not often "clean" and it is not possible to put it directly into a database and expect it to work perfectly. There were many problems with this data set being very old in this assignment as well. Two of the questions could not even be answered anymore because of columns that no longer exist. There were also many issues in assigning primary keys to the data set. For the keys that the FDA listed on the website would often have several duplicates in the dataset, meaning it is unable to be a primary key. For all of these imperfections, using these databases did prove to be very helpful in the field.
 ==Acknowledgments==
-My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm FDA Website] Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
+My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm FDA Website]. Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
 {{Template:MSymond1}}

@@ Line 20: / Line 20: @@
 The main findings from this assignment are that using databases made by certain programs such as Microsoft Access are very helpful in obtaining information that would not be possible otherwise. It does, however, come with many difficulties. It was noted that data in the real world is not often "clean" and it is not possible to put it directly into a database and expect it to work perfectly. There were many problems with this data set being very old in this assignment as well. Two of the questions could not even be answered anymore because of columns that no longer exist. There were also many issues in assigning primary keys to the data set. For the keys that the FDA listed on the website would often have several duplicates in the dataset, meaning it is unable to be a primary key. For all of these imperfections, using these databases did prove to be very helpful in the field.
 ==Acknowledgments==
-My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm FDA Website]
+My homework partner this week was Natalija, we did not communicate or utilize each other about the assignment this week. I did utilize the help of a few of my classmates during class on Tuesday, March 12. I also utilized my professor Dr. Dahlquist in class on Tuesday via zoom, we also had Dr. Dionisio lecture us in class on March 5th and 7th. I retrieved the data files from the [http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm FDA Website] Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
 {{Template:MSymond1}}

@@ Line 15: / Line 15: @@
 ===Data and Files===
 *Master Database[[File:Symonds_MS_Access_Drug_Database.accdb.zip]]
+*FDA files [[File:Symonds_FDA_Files.zip]]
 ==Conclusion==

@@ Line 13: / Line 13: @@
 #These are the sponsor applicants that have LABS in their names and have products with both active ingredients CAFFEINE and ASPIRIN. [[File:Symonds_Week8_Question_8.xlsx]]
 #I do not believe I would be able to complete these questions if I did not have Microsoft Access and had to completely rely on the FDA website. For example, the search engine does not even allow to search by sponsor name. It also does not allow to search two active ingredients at once. Therefore, it would not be possible to do many of the queries that were required to obtain the information for these questions.
 ==Conclusion==

@@ Line 6: / Line 6: @@
 #These are the names of the drugs that are administered in the forms INJECTABLE,INTRAVENOUS, and SUBCUTANEOUS. [[File:Symonds_Week8_Question_1.xlsx]]
 #These are the names of the drugs whose active ingredient is ATROPINE. [[File:Symonds_Week8_Question_2.xlsx]]
-#These are the forms and dosages that the drug BENADRYL can be administered.
+#These are the forms and dosages that the drug BENADRYL can be administered. [[File:Symonds_Week8_Question_3.xlsx]]
-#These are the names of the drugs that have names that end in ESTROL.
+#These are the names of the drugs that have names that end in ESTROL. [[File:Symonds_Week8_Question_4.xlsx]]
 #This question could not be completed because the column does not exist anymore.
 #This question also could not be completed because this column also does not exist anymore.
-#These are the names of the drugs that are sponsored by MERCK.
+#These are the names of the drugs that are sponsored by MERCK. [[File:Symonds_Week8_Question_7.xlsx]]
-#These are the sponsor applicants that have LABS in their names and have products with both active ingredients CAFFEINE and ASPIRIN.
+#These are the sponsor applicants that have LABS in their names and have products with both active ingredients CAFFEINE and ASPIRIN. [[File:Symonds_Week8_Question_8.xlsx]]
 #I do not believe I would be able to complete these questions if I did not have Microsoft Access and had to completely rely on the FDA website. For example, the search engine does not even allow to search by sponsor name. It also does not allow to search two active ingredients at once. Therefore, it would not be possible to do many of the queries that were required to obtain the information for these questions.