1 / 10

Excel is your Frenemy

Excel is your Frenemy. Deanna M. Church Staff Scientist, NCBI. Short Course in Medical Genetics 2013. @ deannachurch. Typical response from your local bioinformatician. “I just emailed my data as an Excel workbook…”. Typical response from your local bioinformatician.

peony
Download Presentation

Excel is your Frenemy

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel is your Frenemy Deanna M. Church Staff Scientist, NCBI Short Course in Medical Genetics 2013 @deannachurch

  2. Typical response from your local bioinformatician “I just emailed my data as anExcel workbook…”

  3. Typical response from your local bioinformatician http://dontuseexcel.wordpress.com/

  4. It is a poor workman, Malcolm, that blames his tools New Yorker Cartoon (May 14, 1955), Robert J. Day

  5. Application’s default settings Excel will try to guess what type of data you have and format it accordingly

  6. Application’s default settings Oct4 4-Oct Note: The official HGNC name for this gene is POU5F1, but Oct4 is a commonly used alias

  7. Change default settings as needed For every column

  8. Change default settings as needed http://www.ncbi.nlm.nih.gov/blast

  9. Change default settings as needed Only some of the available BLAST parameters Default BLAST page parameters tuned for highly related sequences

  10. Take home messages • Understand how your tools work • Understand default parameters • Adjust your parameters to address your question • Do the exercises to see this in action!

More Related