Sulfiknights Deliverables

Sulfiknight Links
BIOL Databases Main Page	Sulfiknights: Project Overview Page	Final Project Deliverables Requirements	Sulfiknights: Final Project Deliverables	Members	Project Manager & Quality Assurance: Naomi Tesfaiohannes	Quality Assurance: Joey Nimmers-Minor	Data Analysis: Ivy-Quynh Macaraeg & Marcus Avila	Designer: DeLisa Madere
				Assignment Pages	Week 11	Week 12/13	Week 15

Template:Sulfiknights

Checklist:

1. Organized Team deliverables wiki page (or other media (CD or flash drive) with table of contents) INCOMPLETE
2. Group Report (.doc, .docx or .pdf file) INCOMPLETE
3. Individual statements of work, assessments, reflections (wiki page, .doc, .docx, .pdf, or e-mailed to Dr. Dahlquist)INCOMPLETE
4. Group PowerPoint presentation (given on Tuesday, December 10, .ppt, .pptx or .pdf file) INCOMPLETE
5. Excel spreadsheet with ANOVA results/stem formatting (.xlsx) COMPLETE
6. PowerPoint of ANOVA table, screenshots of stem results (.pptx), screenshot of black and white GRNsight input network and colored GRNsight output networks COMPLETE
7. Gene List and GO List files from each significant profile (.txt compressed together in a .zip file) COMPLETE
8. YEASTRACT "rank by TF" results (.xlsx) COMPLETE
9. GRNmap input workbook (with network adjacency matrix, .xlsx) COMPLETE
10. GRNmap output workbook (.xlsx) and output plots (.jpg) zipped together COMPLETE
11. MS Access database, unified by the three teams with expression tables and metadata table(s) created (.accdb) COMPLETE
12. ReadMe for the database that describes the design of the database, references the sources of the data, and has a database schema diagram (.doc, .docx, .pdf) INCOMPLETE
13. Query design for populating a GRNmap input workbook from the database (screenshot of MS Access, or SQL code, .txt) COMPLETE
14. Electronic notebook corresponding to these the microarray results files (Week 12/13 and Week 15) to support reproducible research so that all manipulations of the data and files are documented so that someone else could begin with your starting file, follow the protocol, and obtain your results. INCOMPLETE

Excel Spreadsheet with ANOVA Results/STEM Formatting

Thorsen Data (Updated 12/2/19)

PowerPoint of ANOVA Table...

PowerPoint of ANOVA table and Screenshots of STEM Profile Results

Profiles 9 and 23 input network (Excel)

Profile 40 and 48 input network (Excel)

Gene List and GO List files

Zipped Gene Lists for Significant Profiles

Zipped GOLists for Significant Profiles

YEASTRACT "Rank by TF" Results

Profiles 9 and 23

Profiles 40 and 48

GRNmap input workbook

GRNmap Input Worksheet: Profiles 9 and 23

GRNmap Input Worksheet: Profiles 40 and 48

GRNmap output workbook and output plots

GRNmap Output Files: Profiles 9 and 23

GRNmap Output Files: Profiles 40 and 48

MS Access database

MS Access Database of Thorsen & Dahlquist data

Query design for populating a GRNmap input workbook from the database

Profiles 9 and 23:

Profiles 40 and 48:

Electronic notebook corresponding to the microarray results files

Electronic notebook for Data Analysts:

Sulfiknights DA Week 12/13

Sulfiknights DA Week 14

Electronic notebook for Quality Assurance

Electronic notebook for Designer

Merge completed databases into a single database

BIOL_478_-_Sulfiknights_BioDB_CombinedDatabase.zip ‎

Access_Database_Schema_Screenshot.PNG

Final Reflection

Marcus Avila's Final Reflection

Individual Assessment and Reflection

Statement of Work

• Describe exactly what you did on the project.
  • For the project I worked with Ivy to decide how to organize the Thorsen data to run an ANOVA. After running the ANOVA we went on to
• Provide references or links to artifacts of your work, such as:
  • Wiki pages
  • Other files or documents
  • Code or scripts

Assessment of Project

• Give an objective assessment of the success of your project workflow and teamwork.
• What worked and what didn't work?
• What would you do differently if you could do it all over again?
• Evaluate your team’s portion of the Final Project and Group Report in the following areas:
  1. Content: What is the quality of the work?
  2. Organization: Comment on the organization of the project and of your group's wiki pages.
  3. Completeness: Did your team achieve all of the project objectives? Why or why not?

Reflection on the Process

• What did you learn?
  • With your head (biological or computer science principles)
  • With your heart (personal qualities and teamwork qualities that make things work or not work)?
  • With your hands (technical skills)?
• What lesson will you take away from this project that you will still use a year from now?