Msaeedi23 Week 12

From LMU BioDB 2015
Jump to: navigation, search

Week 12

  • This week there were no specific tasks that were required to be completed; we kept working on the team projects and what each specific role should be doing.
  • After analyzing the microarray paper last week, Lena and I were then started analyzing the data.

GenMAPP User

Locating the Sample Data

  • The first step in the data retrieval was to locate the sample files that needed to be downloaded from the microarray paper site, found at: [1].
    • Dr. Dahlquist assisted us in choosing which files to download as well as how to prepare them for Excel.
    • All of the six sample files were downloaded and saved to the computer.
  • Each of the files were unzipped once, and then unzipped again in order to access them in a suitable manner for the assignment, to be opened in Exel.
    • Once all six of the files were unzipped, I opened each of them in Excel in order to get the data in the column spreadsheet form.

Working in Excel

  • I created a new workbook that would contain the final compressed data that is to be eventually exported as one file.
    • After opening each of the sample files in Excel, I copied the list of Gene IDs from one of the samples and pasted it into the new workbook I started.
    • Now that the Gene ID column was formed, I was then started pasting the desired data columns in from each of the different samples.
    • From each of the six samples, I copied and pasted the "Log Ratio" column into my new workbook and titled each of the columns so that they represented the appropriate samples in an orderly fashion.
  • Our next task is to perform the correct data manipulations and corrections in order to make the data file ready to be exported for testing and analysis.
    • Lena and I completed these construction steps side-by-side and we plan on continuing the Excel work together in order to check our work.
  • The current Excel data worksheet we have constructed: File:Bpertussis CompiledRawData MS2015.xlsx

Change of Duties

As of now I am no longer a GenMAPP user and will take over the roll of Quality Assurance and work directly with Brandon. I will still be assisting Lena with data configuration as she needs help.

Mahrad Saeedi

Class Whoopers Team Page
Assignment Links
Individual Journals
Shared Journals