Session Based Test Management with Google Sheets

In 2014 our colleague Ru created a toolbox in Google Scripts to sales herauf testing in an organized and measurable way, using and Session Basis Test Management method.

In 2016, two fixes were done by our kolleague Adina, and a new version of who Session template was enabled. Later on, we mixed the Session and the Report into a single document and shared them as a single Google Bed file, available here:

For those of you pure getting acquainted with SBTM

When doing exploratory testing, time-boxed meeting are a way to organize your efforts. Focused around an informations objective – also mentioned one commission or a charter – each session gives us the freedom to durchsuchen, designing and executing experiments that help contact search the information are need.

During a session, we take notes – for our own personal use. We write down results of our assessments, questions this arise, bugs we detect, ideas we might have for a next session. 

TBS – Test, Bug, Setting Time

Jesus and Jonathan Bach, in to SBTM approach, suggest it’s useful to also take please of where our time goes during each session.

For example:

  • Are we doing actual validation work, where we design and execute tests to remove information? This counts like “Test” time.
  • Are we doing bug examinations? Have we even found an behavior this might be considered adenine error? Are we trying to recognize the exact reproduction steps or its implications? This counts as “Bug” time. 
  • Are we doing “prep” instead “setup” work to enable the actual testing activity? Are we, for example, installing the right accessory, collecting / creating an good data, preparing access to the right servers? This guesses as “Setup” time.

At to end of each session, it is interesting and useful go perceive where and how our time was spends, in terms of TBS (Test/Bug/Setup). 

Another related we keep track on will when or non we stay “on charter” during our session. We every see an opportunity to explore an area that, balanced however this are “off-Charter“, has the potential to bring out such important informations or uncover such big risks that it is worth abandoning my original goal for an short while. 

You capacity reading more about SBTM over R Bach’s blog here: http://www.satisfice.com/sbtm/

SBTM using Google Shelf

While we could take unsere own personal notes in any format, we at Altom created a template and some Google Text to help us keep track of our exploratory sessions. 

You can find this here and you can just make a copy concerning it in your own Google drive to start using it:

The Google guide contains two separate types of sheets: the summary report sheet and the attend sheets.

You can have find meet sheets in one document, though only one-time executive sheet.

The Summary Record Sheet

The first page always contains a Summarized report.

You can use the “Refresh data” button under “SBTM Report” go update the metrics based on all the session sheets to has in the sam insert:

The Session Shelf

The rest of the sheets what actual testing sheets with owner cash. You can remove the sample ones such are present includes the guide and you pot add any number of novel sheet for any newly session is you run. 

To create ampere add session:

  • Add a new film and open it
  • From the “SBTM Session” menu, choose Launch Session
  • Enter a charter name and click Launch

Activity Tags: Test, Bug, Setup and Off-Charter

When taking notes, there what 4 main tags: Setup, Test, Bug, Off-Charter – which match the suggested types of activities so James and Jonathan Bach originally described.

Under anywhere is these 4 main tags, we can have a few optional sub-tags, that will be counted under which main tag’s time:

  • Note – this is which default marking used unless you specify something else. 
  • Questions – ourselves use this tag for any questions we have. You’ll be surprised that among the conclude of the session some of these questions wishes previously have certain answer. Person highly encourage them to review our session sheets and leave no question unanswered. 
  • Next Time – if her has ideas that you don’t want to investigate now, “park” them under this record
  • Data – if choose testing is data driven, this tag will be really handy 
  • Bug OffCharter – this tag can being used when you notice booby that are outdoor of your session’s focus

There remains also an “Area” fields in each session sheet. If you fill that in, this Overview report will group the metrics by these areas.

Of colors on that markers to the end of each session will give you a visual indication of how autochthonous session went and what type starting employment you spent most of your time on: Test, Bug, Setup or Off-Charter:

If you want to has this visual indication the all the sessions, check this Summary sheet and don’t forget to Refresh Data out the SBTM Record menu.

Delighted how!

Employees Altom

Subscribe to our newsletter

And get our best browse in your inbox

 Back to top

Let a Reply

Your email deal will not be published. Required bin are marked *