Chemistry picture of the week: Organising information


This is a picture of my real experimental books and the folder I file my spectra in. I have blurred out the text for privacy’s sake — all of my work is unpublished so far, and plastering it all over the internet seems to be a terribly bad idea.

The experimental notebook is a researcher’s most important tool. This is the book we use to record all the facts about our research. In chemistry, that usually involves identities and quantities of chemicals used, time the reaction was heated or stirred and similar sort of details that are crucial to reproducing a result. Reproducibility is, after all, one of the main requirements of science.

Arguably, the experimental book is also the most difficult resource to keep organised, as I’ve talked about before. One method to keep on top of one’s results is to transcribe important features of experiments  into an Excel spreadsheet. For my project, which is currently centered around one material only, a useful organisation method is a “conditions attempted” spreadsheet where I outline the variables changed for each reaction.  Although very thorough, this method has the disadvantage of being time-consuming. Writing the same thing down twice can feel like a colossal waste of time. I can only hope that when it comes to writing my first year confirmation report (yikes!) or even my thesis, having a neat document that displays the “bigger picture” of my work will be useful.

For systems that I have found to work time and time again, I build a separate spreadsheet that keeps track of all the analyses I have performed on that particular system. For publication and one’s thesis, a number of different analyses are important, as I’ve mentioned before. A spreadsheet like this is a straight-forward way to show what data I have and what is missing. Linking the spreadsheet entry to the corresponding data is also a neat way of keeping your files organised.

These spreadsheets are wonderful for having an eagle’s eye view of your research — taking a step back from the messy world of your experimental book. Still, making these spreadsheets requires an easy way to find information in your lab book itself. A universally accepted method of keeping your experimental book organised is to have a consistent reaction numbering system.  In my Honours year, I used a method wherein each reaction was numbered. Toward the end of that year, however, I found that the reaction numbers might occasionally become jumbled in my book and finding the information for a particular one could be annoying, if not difficult. This year, I have elected instead to use the page number method: each reaction is labeled by my initials, followed by the book number, then page number, then a letter if there are multiple reactions on one page. This makes particular reactions extremely easy to find — simply find the correct book and turn to the page indicated.

For further information about particular reactions, I use highlighters. I write fairly comprehensive notes, and often have to go back to old reaction notes to write new observations (crystal growth or lack thereof, new analyses — that sort of thing). The result of these two things is that my pages can get very cramped. Small, but perhaps important notes can then be missed at a glance. Hence, the highlighters. I use yellow as an indicator for a type of analysis (or postsynthetic modification — further reactions on a material) conducted on the product of a reaction. Green is for reactions which were suitable for crystallography. Orange is for overarching observations — often something I have seen systematically through several reactions and have come to conclude about that system in general. This colour coding is very helpful when it comes to looking at past reactions and thoughts I may have had about them that I might otherwise have forgotten or missed.

There you have it: two ways to keep your data organised, and two ways of keeping your experimental book organised. If you would like to share how you organise your data, you can find me in the comments, on Twitter as @Lady_Beaker or by e-mail at

One thought on “Chemistry picture of the week: Organising information

  1. Pingback: Chemistry picture of the week: Filtering | Chemistry Intersection

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s