BIF713 Lab 8

Purpose

The Purpose of this lab is to expose BIF students to common open-source applications to help develop a report proposal for their major project. Although the major project is due by the end of the second semester, a priliminary report for this project should be available to your Bioinformatics professor by the end of the first semester.

This lab is divided into 2 sections:

Section A: Using OpenOffice Calc (a spreadsheet application) and using OpenOffice Writer (a wordprocessing application).

Section B: Archive created files and email to instructor.

Lab Instructions

Note: You must perform all the sections from within a Linux graphical environment. You can use either the Seneca computer lab (logged into Graphical Matrix), or you can use your own computer with Ubuntu (provided that your computer system connects to the Internet).

Section A

Required Tasks (Please perform this tasks on your computer system):

  1. Open the OpenOffice spreadsheet application (also called Calc). If you do not see OpenOffice, look for an application called “StarOffice”. StarOffice is the older version of OpenOffice.

  2. In the first 4 rows (on the left-most side), enter the following information:

    - Your full name
    - Your student number
    - Course: BIF713 – Section AA
    - Current Date

  3. Go to the BIF713 week 9 course notes link to “Common Windows Operations”, and click on the link at the bottom of the wiki labelled “Links to Keyboard Shortcuts”.

  1. Manually enter the shortcut keys (General and Gnome Desktop only) and their description into your spreadsheet (with the keyboard combinations in the left column, and the description of the keyboard shortcut in the next column to the right).

  1. Save your spreadsheet as shortcut

    Note: by default, the file will be saved as the OpenOffice native file format with the file extension “odf”

  2. Use the file menu, and select save-as, and save another copy of the file called shortcut with the file type: Microsoft Excel 97 / 2000 / XP. This will add the extention “xls” to the end of the filename, therefore it will be recognized as a different file from the one you created in step #5...

  3. Add a row above the shortcut keys to label the columns “Keys” and “Purpose” respectively.

  4. Make the font size larger (eg. size 14) for all the cells in the table you created.

  1. Adjust the width of the cells to make the text fit in the cells on the first line.

  2. Add a border around each cell so it looks like a table.

  3. Save your work as shortcut, but do it for both the file formats “odf” and “.xls”.

  1. Switch back to your “odf” version of the file called shortcut.

  2. Using your mouse, highlite just the table (including column labels, keyboard shorcuts, and descriptions). Copy your selection to the clipboard. Keep this spreadsheet document open.

  1. Launch the OpenOffice Writer application.

  1. Enter at the top of the document the following information:

    - Your full name
    - Your student number
    - Course: BIF713 – Section AA
    - Current Date

  1. Enter two empty lines. Then click on the Edit menu and select “Paste Special”, and select from the list “Calc”, or “Calc” followed by a number.

  2. Save your wordprocessing document as report.

    Note: by default, the file will be saved as the OpenOffice native file format with the file extension “odt”.

  3. Make certain that your wordprocessing document are spreadsheet document are not maximized.

  4. Take a screen capture of your desktop, and save with filename capture.png

  5. Force a page break in your wordprocessing document. Insert the image from the file capture.png into your document.

  6. Save your work as shortcut, but do it for both the file formats “odf” and “.xls”.

  7. Close all application windows and proceed to “Section B”

Section B

Required Tasks (Please perform this tasks to submit this lab to your instructor):

  1. Create a “zipped tarball” called group.tar.gz that contains the following files:

    shortcut.odf
    shortcut.xls
    report.odt

  2. Send your BIF713 instructor an email message with the “zipped tarbal” called group.tar.gz as an attachment.

    E-mail Information:

    To: murray.saul@senecac.on.ca

    Subject: BIF713 – Lab 8



** END OF LAB8 **