Back to Bioinformatics Home Page

During this first lab you'll learn common software and skills necessary to quickly and efficiently complete a lab report.  

Lab report or any scientific paper will contain:
    Title Page which will contain name of the course name of the lab, date, and name of the student and should not be paginated.

    Material and Methods
    Results and Discussion

Create a folder on your desktop, you will use this folder to store all your files during this course.

Microsoft Office Excel

Entering Data

  1. Launch Microsoft Excel either from Start menu or shortcut on your desktop.
  2. Click the cell where you want to enter data.
  3. Type the data and press ENTER to enter data in column or TAB to enter data in a row.
    • To enter the same data into multiple cells
    1. Select multiple cells (Hold down SHIFT key if you want to select adjacent cells or CTRL if the cells are not adjacent)
    2. Enter the date and press CTRL + ENTER
    • To enter a series of numbers, dates, etc
    1. Enter the first entry
    2. Enter the second entry to make a series
    3. Drag the fill handle to fill out the series across multiple cells.

Entering Formula

  1. Select the cell where you want to enter formula. Type the equal sign "=". Enter the formula using cell references such as A1+B1. To see all the available functions select Function from Insert menu.
  2. Try calculating sum, average, max, min, exp, ln, log10, sqrt,   etc. (you can use data from this file data.xls)
  3. Calculate standard deviation using the function STDEV(). Compare your results by calculating the standard deviation manually using formula. (reminder: )

Creating XY scatter plot

  1. Select the range of data that you want to plot. Hold CTRL+SHIFT keys and press UP or DOWN arrow to select the data range.
  2. Click Chart on the Insert menu to start the Chart Wizard.
  3. In the Chart type box, select XY (Scatter).
  4. Complete the wizard.
  5. Using functions calculate the Slope, Intercept with Y and X axes and R-square value.
  6. Use the chart options to add a linear Trendline and display the equation and the R-square value.
  7. Double click the data points on the chart to access the option Format Data Series window. Display 5% error bars to show the experimental error.


Microsoft Office Word

Creating an outline for your document (Formatting)

  1. Launch Microsoft Word either from Start menu or shortcut on your desktop.
  2. Switch to the outline view from View menu.
  3. Use the Outlining toolbar to Promote or Demote the headings to create your Title Page and Headings (Abstract, Introduction, Methods etc.)
  4. Select Insert->Break->Page Break to make every heading appear on a new page.
  5. Switch to Print layout and insert some  text.

 Entering Formula or chemical reaction equilibrium

  1. From Insert menu select Object, and then Create New tab.
  2. In the Object type box, select Microsoft Equation 3.0.

Labeling Gel Picture

  1. Save the gel picture on your desktop
  2. Select Insert->Picture->New Drawing. While the new drawing is selected insert the picture using Insert->Picture->From File
  3. Label the gel picture by inserting Text boxes and shapes for arrows.
  4. With the chart picture selected choose Insert -> Reference-> Caption. Choose the options you want and type the caption text for Figure 1.



Working with Graphics and Inserting Captions to Word Document

  1. In Excel select the chart and select Copy from the Edit menu
  2. Select Paste Special in Word from the Edit menu. Paste the chart as a Picture.
  3. With the chart picture selected choose Insert -> Reference-> Caption. Choose the options you want and type the caption text for Figure 1.

Creating cross-references, table of content

  1. In your text type "For details see" then select Insert->Reference->Cross-reference. Select Reference type -> Figure and select the Figure 1 caption. Click OK.
  2. To insert Table of Contents select Insert->Reference->Index and Tables. Choose the Tables of Contents tab choose the correct number of levels to show. Click OK.



Some useful windows shortcuts

    Save the document
    Open a new document
    Undo the last action
    <Ctrl>-Z or <Alt>-<Backspace.
    Undo the last undo
    Select the entire document
    Cut the selection to the clipboard
    Copy the selection to the clipboards
    Paste the clipboard's contents
    Convert embedded objects into graphics CTRL+SHIFT+F9

Where to find help on using office applications