Difference between revisions of "HDelgadi Week 8"
From LMU BioDB 2013
(more data input) |
(updating electronic notebook) |
||
| Line 8: | Line 8: | ||
#Follow steps 1 through 3 with columns R and S and select 4 decimal places rather than 2. | #Follow steps 1 through 3 with columns R and S and select 4 decimal places rather than 2. | ||
#Select columns N through S from the very first cells, not just the values, and right click to press the 'Cut' button. | #Select columns N through S from the very first cells, not just the values, and right click to press the 'Cut' button. | ||
| − | #Select column B by right clicking on B and select "Insert Cut Cell" | + | #Select column B by right clicking on B and select "Insert Cut Cell" (the cells should shift 6 columns to the right). |
| + | #Right click on the B header and click on 'Insert'. | ||
| + | #The previous B column should shift one column to the right. | ||
| + | #Under the new B header, type 'System Code' into the top cell of this column. | ||
| + | #Below 'System Code' write the letter 'N'. | ||
| + | #Left click on the letter 'N' and press Ctrl C to copy the letter and proceed to the last cell on the column and hold down the shift button along with left clicking this last cell (the entire column should be highlighted). | ||
| + | #Press Ctrl V to paste the letter 'N' to all of the cells of the column. | ||
| + | #Select File then Save As and under 'Save as type' select 'Text(Tab-delimited)(*.txt)'. Proceed to clicking OK when the signs of warnings begin to pop-up. The *.txt file is necessary to proceed. | ||
| + | #Rename the last tab next to statistics, 'forGenMAPP' since it should have changed to the name of the file when saved as the text file. | ||
Revision as of 00:02, 14 October 2013
Digital Lab Notebook
Continuation of classwork on Thursday October 10th [Microarray Analysis Vibrio cholerae]:
- Columns B through Q were selected by highlighting the very first row of these 16 columns. Then scroll down to the last row of these columns. Hold down the 'Shift' button and highlight the entire columns. Click on the format button which is directly below the 'Delete' button under the 'Home' tab.
- Click on 'Format Cells' and 'Number' under the 'Number' sub-category.
- Select two decimal places and click 'OK'.
- Follow steps 1 through 3 with columns R and S and select 4 decimal places rather than 2.
- Select columns N through S from the very first cells, not just the values, and right click to press the 'Cut' button.
- Select column B by right clicking on B and select "Insert Cut Cell" (the cells should shift 6 columns to the right).
- Right click on the B header and click on 'Insert'.
- The previous B column should shift one column to the right.
- Under the new B header, type 'System Code' into the top cell of this column.
- Below 'System Code' write the letter 'N'.
- Left click on the letter 'N' and press Ctrl C to copy the letter and proceed to the last cell on the column and hold down the shift button along with left clicking this last cell (the entire column should be highlighted).
- Press Ctrl V to paste the letter 'N' to all of the cells of the column.
- Select File then Save As and under 'Save as type' select 'Text(Tab-delimited)(*.txt)'. Proceed to clicking OK when the signs of warnings begin to pop-up. The *.txt file is necessary to proceed.
- Rename the last tab next to statistics, 'forGenMAPP' since it should have changed to the name of the file when saved as the text file.
