Difference between revisions of "Nstojan1 Week 10"
Jump to navigation
Jump to search
Nstojan1-new (talk | contribs) (added file) |
Nstojan1-new (talk | contribs) (added purpose and procedure) |
||
| Line 2: | Line 2: | ||
[[Media:Screenshots.pptx]] | [[Media:Screenshots.pptx]] | ||
[[Media:Natalija_Stojanovic_File_New.xlsx]] | [[Media:Natalija_Stojanovic_File_New.xlsx]] | ||
| + | |||
| + | Rows: 4727 filter greater than 0.05 | ||
| + | [[Media:Screenshots.pptx]] | ||
| + | [[Media:Natalija_Stojanovic_File_New.xlsx]] | ||
| + | |||
| + | *Purpose: The purpose of this assignment is to analyze a DNA microarray dataset that involves clustering and analysis of gene regulation networks using the GRNsight software. | ||
| + | |||
| + | *Procedure: | ||
| + | #*Preparing the microarray data file for loading into STEM: | ||
| + | #**Insert a new worksheet into Excel workbook, and make it dCIN5_stem | ||
| + | #**Select all the data from "dCIN5_ANOVA" worksheet and Paste Special > paste the values into "dCIN5_stem" worksheet. | ||
| + | #**The leftmost column should have a column header "Master Index". Rename it to "Spot". Rename Column B ("ID") to "Gene Symbol" and delete the column named "Standard_Name". | ||
| + | #**Filter the data on the B-H corrected value to be > 0.05 | ||
| + | #**Once it has been filtered, select all of the rows (not header row) and delete the row by right clicking and choosing "Delete Row" from the context menu. Undo the filter, this will cluster only the genes with "significant" change in expression and not the noise. | ||
Revision as of 08:38, 5 April 2024
Rows: 4727 filter greater than 0.05 Media:Screenshots.pptx Media:Natalija_Stojanovic_File_New.xlsx
Rows: 4727 filter greater than 0.05 Media:Screenshots.pptx Media:Natalija_Stojanovic_File_New.xlsx
- Purpose: The purpose of this assignment is to analyze a DNA microarray dataset that involves clustering and analysis of gene regulation networks using the GRNsight software.
- Procedure:
- Preparing the microarray data file for loading into STEM:
- Insert a new worksheet into Excel workbook, and make it dCIN5_stem
- Select all the data from "dCIN5_ANOVA" worksheet and Paste Special > paste the values into "dCIN5_stem" worksheet.
- The leftmost column should have a column header "Master Index". Rename it to "Spot". Rename Column B ("ID") to "Gene Symbol" and delete the column named "Standard_Name".
- Filter the data on the B-H corrected value to be > 0.05
- Once it has been filtered, select all of the rows (not header row) and delete the row by right clicking and choosing "Delete Row" from the context menu. Undo the filter, this will cluster only the genes with "significant" change in expression and not the noise.
- Preparing the microarray data file for loading into STEM:
