Activity 3.1.5 Student Resource Sheet Microsoft Excel 2013 Instructions Open a new file in Microsoft Excel. Copy and paste Table One from the Activity 3.1.5 handout into the top left corner of the spreadsheet. Make sure the Mike Smith box is located in column A, row 2, as shown below. Highlight the table by holding the mouse and dragging an arrow to form a box around your data. From the Menu heading at the top of the page, click on the tab and “Insert” select the the chart subtype you wish to use. For our “Scatter” type Chart. Select graph, select the Lines and scatter graph with “Straight Markers”. To correctly orient the data, click the button in the Chart Tools menu labeled Row/Column”. the series at the right side of the “Switch This will ensure that chart will be labeled and “Gene 1”, “Gene 2” “Gene 3”. Give your graph a title. In the Chart Tools menu, click on the then “Design” tab, Chart Element” and next select the Chart”. “Add option “Above Type the title you have selected in the Title” “Chart box. Note that you will need to label both the X-axis and the Y-axis. Again, click on the Add Chart Element icon in the Design Tab, you will need to Titles” choose “Axis and Horizontal Axis Title”. “Primary Follow the same procedure from Step 8 to label the Y-axis, but choose “Primary Vertical Axis Title.” Type in a title for the Y-axis. When choosing a title, think about the information you plotted on the Y-axis. Move the graph so that it is next to the data table. Set-up a new data table with the same headings as your original data table (Type in Patients 1-3 in the A column and genes 1-3 across the top) in your spreadsheet. Use the formula: =LOG(gene expression ratio, 2) to convert each gene expression ratio into a base 2 logarithm. Do this by clicking on the box for Mike Smith/Gene 1 in the new data table and type in “=LOG(B2,2).” Press enter. You should see the number 0.48542683 in the box. This is the base 2 logarithm of 1.4.
Activity 3.1.5 Student Resource Sheet Microsoft Excel 2013 Instructions Open a new file in Microsoft Excel. Copy and paste Table One from the Activity 3.1.5 handout into the top left corner of the spreadsheet. Make sure the Mike Smith box is located in column A, row 2, as shown below. Highlight the table by holding the mouse and dragging an arrow to form a box around your data. From the Menu heading at the top of the page, click on the “Insert” tab and select the “Scatter” type Chart. Select the chart subtype you wish to use. For our graph, select the scatter graph with “Straight Lines and Markers”. To correctly orient the data, click the button in the Chart Tools menu labeled “Switch Row/Column”. This will ensure that the series at the right side of the chart will be labeled “Gene 1”, “Gene 2” and “Gene 3”. Give your graph a title. In the Chart Tools menu, click on the “Design” tab, then “Add Chart Element” and next select the option “Above Chart”. Type the title you have selected in the “Chart Title” box. Note that you will need to label both the X-axis and the Y-axis. Again, click on the Add Chart Element icon in the Design Tab, you will need to choose “Axis Titles” and “Primary Horizontal Axis Title”. Follow the same procedure from Step 8 to label the Y-axis, but choose “Primary Vertical Axis Title.” Type in a title for the Y-axis. When choosing a title, think about the information you plotted on the Y-axis. Move the graph so that it is next to the data table. Set-up a new data table with the same headings as your original data table (Type in Patients 1-3 in the A column and genes 1-3 across the top) in your spreadsheet. Use the formula: =LOG(gene expression ratio, 2) to convert each gene expression ratio into a base 2 logarithm. Do this by clicking on the box for Mike Smith/Gene 1 in the new data table and type in “=LOG(B2,2).” Press enter. You should see the number 0.48542683 in the box. This is the base 2 logarithm of 1.4.
3_1_5_A%20StudentResourceSheetExcel2013.docx