NCSI Talks

   

DNA Sequence Analysis Background


Shodor > NCSI Talks > Excel > DNA Sequence Analysis Background

DNA Sequencing Analysis

What is this model?

This is an excel worksheet that can be used to analyze strands of DNA based on their relative quantities of base pairs. Given a string of DNA, the worksheet will iterate over each value in the string and record the number of each base pair. Parameters in this model - Target and Target2 - determine which base pairs are being counted. The user can also set the inputs in the form of sequences of DNA base pairs to be analyzed. Multiple strings can be analyzed at once, allowing for easy comparison.

What can this Model be used to teach?

  • Modify the excel spreadsheet to search for strings of any length, rather than just single letters
  • Understand how to calculate the probability of different types of sequences occurring in a string of a fixed length
  • Related Models

    Pseudo Random Numbers (Excel)

    Problematic Patterns in Random Noise (Excel)