Nstojan1 Week 14&15

Progress Report

Milestone 3 Complete

• In class, the data from yeastmine was obtained. Dean and I weren’t sure what columns we needed because there were so many so we spoke to Dr. Dalhquist to see what was needed and she made some suggestions.

Milestone 4

• In class, the database was created. After Dean and Andrew worked on it, after I looked at it I noticed that some of the tables only had 0’s and 1’s which is not what excel had. I told this to Dean and Andrew, and we fixed it by importing the text file instead of just copy pasting it. After the relationships were made. I went through it to make sure that we had all of the necessary fields and that each row and column had appropriate headings.

Milestone 5

• Hailey and I both checked the Access database one more time to ensure that everything was indeed correct and that I didn’t miss anything. It was correct and ready to use.

Milestone 6

• The data analyst picked profile 41 to analyze because it had the most genes, there were 23 genes that we needed to get data for. Dean, Andrew and I didn’t know how to do this because there were so many genes and it would have taken forever to do manually. Dr. Dahlquisrt showed us in class how to write the queries. After Dean ran the queries, Hailey and I checked them to make sure we got the same results. During this, we were in communication with Dean to see what was done. The GRNmap was produced and uploaded so that Dr. Dahlquist could run it.

Presentation

• We did the presentation as a team and everyone focused on doing the work that they completed. Meaning coders/designers did the slides on what they did during the project and the data analyst and quality assurance did the same. The only problem we had was we didn’t know what other members of the team did. For example, because I worked with Andrew and Dean. I was often confused about what Katie, Charlotte and Hailey were doing. When we were doing the presentation, we talked about the feedback Dr. Dahlquist gave us and we tried to incorporate that into our slides.

Team Journal Assignment

1. We completed the rest of the project and all of the milestones, we began doing the presentation and talking about what we wanted to do for the paper.
2. My reflection on team progress:
   • For the most part everything went well when I checked the database, there were some issues like the ones discussed above but they were a quick fix. At first when Andrew ran the queries, we noticed it was the wrong file and there were a couple of things he did wrong, which Dean was able to fix after. Creating the presentation was smooth and we didn’t have any issues there.
   • Things that didn’t work well was the communication and organization of the files. After the data analyst gave us the file with the genes, there were some duplicates which were fixed. However, there was a misunderstanding about which file should have been used which led to Andrew running queries on the wrong file
   • Dean was able to fix this and do the queries on the right files, in the future, the files need more descriptive names and need to be organized so that it is easier to find.

Acknowledgments

All of my groupmates contributed to the project during the last 2 weeks. Except for what is noted above, this individual journal entry was completed by me and not copied from another source. Nstojan1-new (talk) 09:21, 3 May 2024 (PDT)