|
|
| (13 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | ==Electronic Lab Notebook== | + | ==Week 12/13 Milestones== |
| | | | |
| | ===Project Manager=== | | ===Project Manager=== |
| | | | |
| − | === Milestone 1: Project “Scaffolding” ===
| + | # This week, my role as project manager was to oversee the progress of the team's work. I also worked with communicating with the other project managers to have a consistent meta spreadsheet of all our information. My role will continue by working with all members of the team with check ins and forming the schedule needed to complete all the tasks. |
| − | | |
| − | This milestone pertains to setting up an initial schedule and any resources that your team will use for the duration of the project. It will be useful to get an overview of every team member’s own milestones so that you have an accurate big picture view. | |
| − | | |
| − | # In consultation with your team, work backward from the final deadline to set intermediate deadlines for each deliverable. In particular you need to set deadlines for what you will accomplish by the journal deadline for [[Week 11]], [[Week 12/13]], and [[Week 15]].
| |
| − | # Organize management tools for your team:
| |
| − | #* Communication tools
| |
| − | #* Workflow narratives
| |
| − | #* Action items
| |
| − | #* Testing results/reports
| |
| − | #** Bugs/feature requests
| |
| − | #** Question/answer sequences
| |
| − | | |
| − | === Milestone 2: Periodic Updates ===
| |
| − | | |
| − | Not as much a milestone as an on-going task, once the project is up and running the Project Manager is responsible for keeping track of everyone’s progress.
| |
| − | | |
| − | # Get periodic updates on progress; in particular, the project’s “place” in the overall flow should be known at all times (transparency). Team members will be giving a status reports in class for the rest of the semester. However, the instructor will expect you to know and be able to report on the status of each member of your team at any time.
| |
| − | # Familiarize yourselves with the specific milestones of [[Quality Assurance|each]] [[Coder/Designer|team]] [[Data Analysis|member]] so that you know how to monitor the team’s overall progress.
| |
| − | # Monitor the status of the report-in-progress and other related documentation.
| |
| − | # Coordinate team decisions and action items addressing any unforeseen delays or roadblocks.
| |
| | | | |
| | ===Quality Assurance=== | | ===Quality Assurance=== |
| | | | |
| − | === Milestone 1: Annotated Bibliography ===
| + | # This week, my role as a quality assurance guild was to work alongside the data analysts in going through the excel spreadsheet. While doing this, I worked with the designer on contributing to the class meta spreadsheet so that our information was consistent with the two groups. |
| | | | |
| − | * The QA's will work with their teams to develop an annotated bibliography of papers relating to their team's assigned paper.
| + | ==Purpose== |
| | | | |
| − | === Milestone 2: Journal Club Presentation ===
| + | The purpose of this week's assignment is to continue building on the team's wiki page and to progress through the milestones for each of the categories. |
| | | | |
| − | * The QA's will work with their teams to create and deliver a Journal Club presentation about to their team's assigned paper.
| + | ==Methods== |
| | | | |
| − | === Milestone 3: Working with Data Analysts to understand microarray dataset ===
| + | * Downloaded the information from the article link |
| | | | |
| − | As an overview, the QA team member is the link between the Coder/Designer and the Data Analyst. He or she needs to know the details of the microarray dataset being analyzed so that the database being designed and populated by the Coder/Designer is correct and useful for the Data Analyst. The QA will independently check that all of the data retrieved from SGD is present and accurately represented in the MS Access database. The QA will also provide assistance to the Data Analyst, making sure that the data analysis steps are being performed correctly and are being correctly documented.
| + | * Put the information into one excel worksheet |
| | | | |
| − | Initially, the QA's will need to do the following:
| + | * Ran an ANOVA |
| − | * Along with the Data Analysts, download the microarray data associated with your group's article. | |
| − | ** [https://sgd-prod-upload.s3.amazonaws.com/S000204227/Barreto_2012_PMID_23039231.zip Barreto et al. (2012)]
| |
| − | ** [https://sgd-prod-upload.s3.amazonaws.com/S000204415/Kitagawa_2002_PMID_12269742.zip Kitagawa et al. (2002)]
| |
| − | ** [https://sgd-prod-upload.s3.amazonaws.com/S000204367/Thorsen_2007_PMID_17327492.zip Thorsen et al. (2007)]
| |
| − | ** Along with the Data Analysts, make a "sample-data relationship table" that lists all of the samples (microarray chips), noting the treatment, time point, and replicate number.
| |
| − | ** Are all the samples described in the paper in the dataset?
| |
| − | ** Are all the samples in the dataset described in the paper?
| |
| − | * Come up with consistent column headers that summarize this information
| |
| − | ** For example, the Dahlquist Lab microarray data used strain_LogFC_timepoint-replicate number, as in wt_LogFC_t15-1.
| |
| − | * Organize the data in a worksheet in an Excel workbook so that:
| |
| − | * ID is in the first column
| |
| − | * Data columns are to the right, in increasing chronological order, using the column header pattern you created
| |
| − | * Replicates are grouped together
| |
| | | | |
| − | === Milestone 4: Making sure expression data has both Sytematic Name and Standard Name ID's === | + | ==Conclusion== |
| | | | |
| − | * The design of the expression tables in the final database will need both an ID field (yeast systematic name) and Standard Name fields.
| + | This week's assignment led to more work being done to complete the milestones. By running the ANOVA we are now ready to go onto STEM. |
| − | * You will need to check the IDs in the expression data and potentially populate one or both of these fields.
| |
| − | * One way to do this is use the [http://www.yeastract.com/formorftogene.php "ORF List <-> Gene List"] tool at YEASTRACT.
| |
| − | * The [http://llama.mshri.on.ca/synergizer/translate/ Synergizer] website may also be helpful.
| |
| − | * Here is a [https://rdrr.io/bioc/ClusterJudge/man/convert_Yeast_SGDId_2_systematic.html Bioconductor package] for it, too.
| |
| | | | |
| − | === Milestone 5: Work with Coder/Designers to Design a Database to Store Time-course Microarray Data from four sources === | + | ==Acknowledgments== |
| | | | |
| − | * Databases created by the teams will be kept in a [https://lmu.box.com/s/gutpb5qm0a6b2pvjn1j6moqb6y47e903 "BIOL367_Fall2019 > Final Project Database" Box folder].
| + | My homework partners this week were User:Jnimmers (Quality Assurance), User:Imacarae (Data Analysis), User:Mavila9 (Data Analysis), and User:Dmadere (Designer). We continued working on our Team page and the milestones following the downloading of the excel spreadsheet values. |
| − | * Coder/Designer guild members have rights as editor to this folder; all others in the class can only view/download.
| |
| − | * This folder will serve as as the version control mechanism for the Coder/Designer guild.
| |
| − | * Designer/Coders will work with the QA's to create a MS Access Database to store the yeast time-course microarray data for the dataset being analyzed by the Data Analysts.
| |
| − | * The starting point will be the database already used for the [[Week 10]] assignment, which can be found [https://lmu.box.com/s/kn8l6r639af683ioojqoce5w1g3z7kd2 here] on Box.
| |
| − | ** This database is already populated with tables for the Dahlquist Lab microarray data, degradation rates from Neymotin et al. (2014), and initial guesses for production rates.
| |
| − | *** You may need to change the table names of these existing tables so that they make sense with the overall database design.
| |
| − | ** You will need to add one or more expression tables for the expression data from your team's article.
| |
| − | *** Work with your team's QA and Data Analysts to determine appropriate column headings for the expression table.
| |
| − | ** You will also need to create one or more tables with metadata about the other tables because now the database will contain data from multiple sources, not just one.
| |
| − | *** A major part of the design work will be to figure out what information needs to be in the metadata table so that queries can be easily and uniquely performed on the data.
| |
| | | | |
| − | === Milestone 6: Validation and Quality Assurance on Database ===
| + | LMU BioDB 2019. (2019). Week 12/13. Retrieved November 25, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_12/13 |
| | | | |
| − | * After the Access database is built by the Coder/Designer, the QA will perform quality assurance to make sure that the database is correct and accurate.
| + | '''"Except for what is noted above, this individual journal entry was completed by me and not copied from another source."''' [[User:Ntesfaio|Ntesfaio]] ([[User talk:Ntesfaio|talk]]) 10:53, 25 November 2019 (PST) |
| − | ** In particular, the QA needs to make sure that all of the rows of data were imported into the database for the expression table(s).
| |
| − | ** The QA will make sure that both the ID (SGD systematic name) and Standard Names are included in each expression table and are correct.
| |
| − | * QA's will communicate to the Coder/Designers any changes needed to the database.
| |
| | | | |
| − | === Milestone 7: Final Documentation === | + | ==References== |
| − | | |
| − | * With the Coder/Designer, finalize the [https://www.quackit.com/microsoft_access/microsoft_access_2016/howto/how_to_create_a_database_diagram_in_access_2016.cfm database schema diagram]
| |
| − | | |
| − | ===Data Analysis===
| |
| − | | |
| − | === Milestone 1: Annotated Bibliography ===
| |
| − | | |
| − | * The Data Analysts will work with their teams to develop an annotated bibliography of papers relating to their team's assigned paper.
| |
| − | | |
| − | === Milestone 2: Journal Club Presentation ===
| |
| − | | |
| − | * The Data Analysts will work with their teams to create and deliver a Journal Club presentation about to their team's assigned paper.
| |
| − | | |
| − | === Milestone 3: Getting the data ready for analysis ===
| |
| − | | |
| − | # Download and examine the microarray dataset, comparing it to the samples and experiment described in your journal club article.
| |
| − | #* [https://sgd-prod-upload.s3.amazonaws.com/S000204227/Barreto_2012_PMID_23039231.zip Barreto et al. (2012)]
| |
| − | #* [https://sgd-prod-upload.s3.amazonaws.com/S000204415/Kitagawa_2002_PMID_12269742.zip Kitagawa et al. (2002)]
| |
| − | #* [https://sgd-prod-upload.s3.amazonaws.com/S000204367/Thorsen_2007_PMID_17327492.zip Thorsen et al. (2007)]
| |
| − | # Along with the QA's, make a "sample-data relationship table" that lists all of the samples (microarray chips), noting the treatment, time point, and replicate number.
| |
| − | #* Come up with consistent column headers that summarize this information
| |
| − | #** For example, the Dahlquist Lab microarray data used strain_LogFC_timepoint-replicate number, as in wt_LogFC_t15-1.
| |
| − | # Organize the data in a worksheet in an Excel workbook so that:
| |
| − | #* ID is in the first column
| |
| − | #* Data columns are to the right, in increasing chronological order, using the column header pattern you created
| |
| − | #* Replicates are grouped together
| |
| − | | |
| − | === Milestone 4: ANOVA analysis ===
| |
| − | | |
| − | # Perform an ANOVA analysis of the data, as you did on [[Week 8]] for the Dahlquist lab data.
| |
| − | #* Note that you will need to adjust your formulas to take into account the different number of timepoints and replicates in your article's dataset.
| |
| − | | |
| − | === Milestone 5: Clustering with stem and YEASTRACT ===
| |
| − | | |
| − | # Cluster the data with stem, as you did on [[Week 9]].
| |
| − | #* Note that we will make some adjustments to the GO term analysis because stem was not providing GO term names.
| |
| − | # Use YEASTRACT to generate a candidate gene regulatory network as you did on [[Week 9]].
| |
| − | | |
| − | === Milestone 6: Create an input workbook for GRNmap using MS Access database ===
| |
| − | | |
| − | # Create an input workbook for GRNmap based on a Microsoft Access database that the Coder/Designer and QA's make, following protocol in [[Week 10]]
| |
| − | # Run GRNmap and interpret data.
| |
| − | # As the end-user of the Access database, the Data Analysts will provide feedback to the QAs and Coder/Designer about the usability of database.
| |
| − | | |
| − | ===Coder/Designer===
| |
| − | | |
| − | === Milestone 1: Annotated Bibliography ===
| |
| − | | |
| − | * The Coder/Designer will work with their teams to develop an annotated bibliography of papers relating to their team's assigned paper.
| |
| − | | |
| − | === Milestone 2: Journal Club Presentation ===
| |
| − | | |
| − | * The Coder/Designer will work with their teams to create and deliver a Journal Club presentation about to their team's assigned paper.
| |
| − | | |
| − | === Milestone 3: Working Environment Setup ===
| |
| − | | |
| − | Coder/Designer work will require the following software/accounts. The Seaver 120 lab computers are already set up for this; this list is provided for Coders/Designers who need to work on a different computer or outside of the lab.
| |
| − | * Microsoft Access
| |
| − | * Box account (provided by LMU)
| |
| − | ** Databases created by the teams will be kept in a [https://lmu.box.com/s/gutpb5qm0a6b2pvjn1j6moqb6y47e903 "BIOL367_Fall2019 > Final Project Database" Box folder].
| |
| − | ** Coder/Designer guild members have rights as editor to this folder; all others in the class can only view/download.
| |
| − | ** This folder will serve as as the version control mechanism for the Coder/Designer guild.
| |
| | | | |
| − | === Milestone 4: Design a Database to Store Time-course Microarray Data from four sources ===
| + | Thorsen, M., Lagniel, G., Kristiansson, E., Junot, C., Nerman, O., Labarre, J., & Tamás, M. J. (2007). Quantitative transcriptome, proteome, and sulfur metabolite profiling of the Saccharomyces cerevisiae response to arsenite. Physiological genomics, 30(1), 35-43. DOI: https://doi.org/10.1152/physiolgenomics.00236.2006 |
| | | | |
| − | * Designer/Coders will work with the QA's to create a MS Access Database to store the yeast time-course microarray data for the dataset being analyzed by the Data Analysts.
| + | https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_12/13 |
| − | * The starting point will be the database already used for the [[Week 10]] assignment, which can be found [https://lmu.box.com/s/kn8l6r639af683ioojqoce5w1g3z7kd2 here] on Box.
| |
| − | ** This database is already populated with tables for the Dahlquist Lab microarray data, degradation rates from Neymotin et al. (2014), and initial guesses for production rates.
| |
| − | *** You may need to change the table names of these existing tables so that they make sense with the overall database design.
| |
| − | ** You will need to add one or more expression tables for the expression data from your team's article.
| |
| − | *** Work with your team's QA and Data Analysts to determine appropriate column headings for the expression table.
| |
| − | ** You will also need to create one or more tables with metadata about the other tables because now the database will contain data from multiple sources, not just one.
| |
| − | *** A major part of the design work will be to figure out what information needs to be in the metadata table so that queries can be easily and uniquely performed on the data.
| |
| − | *** Think about what information would someone need to know to be able to understand how the dataset works. Consult with the QA and Data Analysts to figure out the sample-data relationships and how that should be encoded.
| |
| | | | |
| − | === Milestone 5: Build an individual database for your team ===
| + | https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Sulfiknights |
| | | | |
| − | * Once the design work has been completed, you need to actually import the data into the database.
| + | File:NtesfaioThorsen 2007 PMID 17327492 (1).zip |
| − | * Initially, each team will have their own database so that the QA and Data analysts can validate and use the database.
| |
| − | | |
| − | === Milestone 6: Validation and Quality Assurance on Database ===
| |
| − | | |
| − | * The QA will perform quality assurance to make sure that the database is correct and accurate.
| |
| − | ** In particular, the QA needs to make sure that all of the rows of data were imported into the database for the expression table(s).
| |
| − | ** The QA will make sure that both the ID (SGD systematic name) and Standard Names are included in each expression table and are correct.
| |
| − | * QA's will communicate to the Coder/Designers any changes needed to the database.
| |
| − | | |
| − | === Milestone 7: Merge completed databases into a single database for the class ===
| |
| − | | |
| − | * As a guild, the Coder/Designers will merge their separate databases into a final product.
| |
| − | * With the QA's finalize the [https://www.quackit.com/microsoft_access/microsoft_access_2016/howto/how_to_create_a_database_diagram_in_access_2016.cfm database schema diagram]
| |
| | | | |
| | + | [[User:Ntesfaio|Ntesfaio]] ([[User talk:Ntesfaio|talk]]) 18:39, 23 November 2019 (PST) |
| | | | |
| | {{Template:Ntesfaio}} | | {{Template:Ntesfaio}} |
| − |
| |
| − | ==Acknowledgments==
| |
| − |
| |
| − | ==References==
| |
