Data 2017

Lab photos


I have closed off Monday's datasheet to editing (except by me) as of Nov 2nd.
I have closed off Tuesday's datasheet as of Nov 3rd.
I have made some fixes where data was misinterpreted by various groups.


  • Please use all data from your lab day, aka, Monday will use all of Monday's data (total of 72 recombinants were screened).
  • I found it easiest to download this as an Excel file before messing with it.
  • The two most important columns are the cloning strategy (S or T) and the identification of the recombinant.
  • Use Excel Countif or Countifs (better) to easily add up the number of recombinants observed for each type.
    • If you use Countif you will first need to sort the data. Because the identification has merged rows, you can't easily auto sort, it works better to duplicate the sheets, and on one sheet delete the Ts and on the other delete the Ss.
    • To use Countifs you don't need to sort the data because you can select data for counting using 2 columns. I made a video for using Countifs for 205. For this lab, just set it up with T or S for the first criteria, and the 7 different recombinant IDs for the second criteria (you can copy and paste these from the last sheet "recomb-choices").
  • By my count, on Monday we determined the identity of 56 shotgun recombinants and 11 targeted recombinants (I did not include "can't tell" in these counts or any pUC18R).
  • One of our goals was to analyze and compare the two approaches to subcloning. Part of this analysis should include how many different recombinants were produced by each method and how common they were as this might be important for future applications. For example, for the shotgun method, we predicted there could be up to six different 2 piece recombinants that would produce white colonies. If some of the predicted recombinants were not observed, then this must be considered when evaluating the method. Along the same lines, we did not expect to see any 4 piece recombinants, but we identified several in the shotgun recombinants (might make an interesting discussion topic).
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License