Coder/Designer - Revision history

Kdahlquist: /* Milestone 4: Design a Database to Store Time-course Microarray Data from four sources */ add GEO id

2019-11-26T23:32:41Z

‎Milestone 4: Design a Database to Store Time-course Microarray Data from four sources: add GEO id

Kdahlquist: /* Milestone 7: Merge completed databases into a single database for the class */ note with QA's

2019-11-20T18:22:12Z

‎Milestone 7: Merge completed databases into a single database for the class: note with QA's

Kdahlquist: /* Milestone 7: Merge completed databases into a single database for the class */ add database schema diagram

2019-11-20T18:18:45Z

‎Milestone 7: Merge completed databases into a single database for the class: add database schema diagram

Kdahlquist: /* Milestone 4: Design a Database to Store Time-course Microarray Data from four sources */ clarify tasks

2019-11-19T22:28:34Z

‎Milestone 4: Design a Database to Store Time-course Microarray Data from four sources: clarify tasks

Kdahlquist: removed reference to github

2019-11-19T22:26:31Z

removed reference to github

Kdahlquist: /* Milestone 4: Creating a MS Access Database to Store Time-course Microarray Data */ broke out the milestones

2019-11-19T19:01:36Z

‎Milestone 4: Creating a MS Access Database to Store Time-course Microarray Data: broke out the milestones

Kdahlquist: /* Milestone 3: Working Environment Setup */ change version control to Box

2019-11-19T18:29:52Z

‎Milestone 3: Working Environment Setup: change version control to Box

Kdahlquist: /* Guild Members */ add in team names and guild members

2019-11-18T22:41:32Z

‎Guild Members: add in team names and guild members

Kdahlquist: /* Milestone 4: Creating a MS Access Database to Store Time-course Microarray Data */ fix header level

2019-11-12T22:17:07Z

‎Milestone 4: Creating a MS Access Database to Store Time-course Microarray Data: fix header level

Kdahlquist: /* Milestones */ update tech

2019-11-07T23:56:05Z

‎Milestones: update tech

@@ Line 41: / Line 41: @@
 *** 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 ===

@@ Line 57: / Line 57: @@
 * As a guild, the Coder/Designers will merge their separate databases into a final product.
-* 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]
+* 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]
 {{Final Project Links}}
 [[Category:Group Projects]]

@@ Line 57: / Line 57: @@
 * As a guild, the Coder/Designers will merge their separate databases into a final product.
 {{Final Project Links}}
 [[Category:Group Projects]]

@@ Line 40: / Line 40: @@
 ** 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 5: Build an individual database for your team ===

@@ Line 1: / Line 1: @@
 {{Final Project Links}}
-The Coder/Designer is responsible for creating the Microsoft Access database that will be used by the Data Analyst to prepare an input workbook for GRNmap for the microarray dataset they are analyzing.  The Coder/Designer is also the resident expert on the technology being used—assorted software, file management, version control, and troubleshooting. He or she coordinates with Dr. Dahlquist and fellow Coders/Designers in developing the Access database and storing it in the GitHub code repository.
+The Coder/Designer is responsible for creating the Microsoft Access database that will be used by the Data Analyst to prepare an input workbook for GRNmap for the microarray dataset they are analyzing.  The Coder/Designer is also the resident expert on the technology being used—assorted software, file management, version control, and troubleshooting. He or she coordinates with Dr. Dahlquist and fellow Coders/Designers in developing the Access database and storing it on Box.
 == Guild Members ==

@@ Line 30: / Line 30: @@
 ** This folder will serve as as the version control mechanism for the Coder/Designer guild.
-=== Milestone 4: Creating a MS Access Database to Store Time-course Microarray Data ===
+=== Milestone 4: Design a Database to Store Time-course Microarray Data from four sources ===
 * 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 QA will peform quality assurance to make sure that the database is correct and accurate.
+* 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.
 * As a guild, the Coder/Designers will merge their separate databases into a final product.

@@ Line 23: / Line 23: @@
 === Milestone 3: Working Environment Setup ===
-Coder/Designer work will require the following software. 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.
+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
-* GitHub account
+* Box account (provided by LMU)
-** '''git''' version control software (optional) or use of GitHub web interface
+** 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.
-Make sure that this software is installed and operational before beginning. If any Coder/Designer needs help with any of these requirements, please consult your fellow guild members or ask Dr. Dahlquist.
+** This folder will serve as as the version control mechanism for the Coder/Designer guild.
 === Milestone 4: Creating a MS Access Database to Store Time-course Microarray Data ===

@@ Line 5: / Line 5: @@
 == Guild Members ==
-* DeLisa Madere
+* [[Sulfiknights]]: DeLisa Madere
-* TBA
+* [[FunGals]]: Mike Armas
-* TBA
+* [[Skinny Genes]]: Mihir
 == Milestones ==

@@ Line 14: / Line 14: @@
 The milestones do not necessarily correspond to particular weeks; instead they are sets of tasks grouped together. However, Milestone 3 is a hard prerequisite for proceeding to Milestone 4, so ideally the Coder/Coder guild should finish these milestones (they require some coordination; see below) as soon as possible.
-=== Milestone 1: Journal Club Presentation ===
+=== Milestone 1: Annotated Bibliography ===
-* The Designer/Coder will work with their teams to develop an annotated bibliography of papers that reporting yeast timecourse DNA microarray data.
+* 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
+=== Milestone 2: Journal Club Presentation ===
-* The Designer/Coder will work with their teams to create and deliver a Journal Club presentation about a particular paper reporting yeast timecourse DNA microarray data.
+* 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/Coder work will require the following software. 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.
+Coder/Designer work will require the following software. 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
 * GitHub account
-* '''git''' version control software or use of GitHub web interface
+** '''git''' version control software (optional) or use of GitHub web interface
 Make sure that this software is installed and operational before beginning. If any Coder/Designer needs help with any of these requirements, please consult your fellow guild members or ask Dr. Dahlquist.
@@ Line 41: / Line 40: @@
 #* All other teams will create branches named after their team names
 The teams will then do their work on their respective branches.
 == Milestone 4: Creating a MS Access Database to Store Time-course Microarray Data ==