Difference between revisions of "Ksherbina Week 8"
From LMU BioDB 2013
(→Lab Journal: Statistical Analysis of Vibrio cholerae Microarray Data: Included step 2 as part of step 1.) |
(→Lab Journal: Statistical Analysis of Vibrio cholerae Microarray Data: Modified steps 3 and 4.) |
||
| Line 6: | Line 6: | ||
#*Save the file with the following format for the filename: Merrell_Compiled_Raw_Data_Vibrio_<Initials>_<Date>.xls | #*Save the file with the following format for the filename: Merrell_Compiled_Raw_Data_Vibrio_<Initials>_<Date>.xls | ||
#Open the file. Insert a new worksheet and name it "scaled_centered". | #Open the file. Insert a new worksheet and name it "scaled_centered". | ||
| − | #Go back to the "compiled_raw_data" worksheet | + | #Go back to the "compiled_raw_data" worksheet. Select All and Copy. Go to your new "scaled_centered" worksheet, click on the upper, left-hand cell (cell A1) and Paste. |
| − | #Insert two rows in between the top row of headers and the first | + | #Insert two rows in between the top row of the column headers and the first row of data. |
#In cell A2, type "Average" and in cell A3, type "StdDev". | #In cell A2, type "Average" and in cell A3, type "StdDev". | ||
Revision as of 04:21, 17 October 2013
| Assignment Description | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 15 |
| Class Journal | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | |||||
| Individual Journal | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 |
| Other | Week 5: Database Wiki |
| Final Project | Team H(oo)KD Project Page | Journal Club Presentation | Project Individual Journal |
Lab Journal: Statistical Analysis of Vibrio cholerae Microarray Data
- Download the file Merrell_Compiled_Raw_Data_Vibrio.xls from the Sample Microarray Analysis for Vibrio cholerae page.
- Save the file with the following format for the filename: Merrell_Compiled_Raw_Data_Vibrio_<Initials>_<Date>.xls
- Open the file. Insert a new worksheet and name it "scaled_centered".
- Go back to the "compiled_raw_data" worksheet. Select All and Copy. Go to your new "scaled_centered" worksheet, click on the upper, left-hand cell (cell A1) and Paste.
- Insert two rows in between the top row of the column headers and the first row of data.
- In cell A2, type "Average" and in cell A3, type "StdDev".
The resulting Excel file can be downloaded here. The text file to be used for GenMapp can be downloaded here.
Lab Journal: MAPPFinder Analysis of Vibrio cholerae Microarray Data
- Installed GenMAPP Classic from this [page] onto my computer.
- Downloaded the following data files: Vc-Std_External_20090622.gdb and Vc-Std_External_20101022.gdb.
