Thanks for supporting local! Our online shop is open & shipping orders. 

Search

Get Professional Support

BBC Micro:bit

Robotics

On sale items!

Announcement


Check out our latest news to find out more about events, opportunities and partnerships.

Esmes' Electronics


Esmes' Electronics is a simple introduction to using the micro:bit written by a year 5 student.

Troys' tutorials


Learn with Troy by asking for support and, he will post a tutorial here to benefit all of our visitors. Free advice!

Feature teacher


Be inspired by some of our favorite teachers using our products.

Get professional support


Contact us now to request your own tutorial or learning resource.

This section doesn’t currently include any content. Add content to this section using the sidebar.

Image caption appears here

Add your deal, information or promotional text

Micro:bit Soil Monitor with live Microsoft Excel Data Streamer

This is just a quick tutorial to help out a super teacher that wants to integrate Technology into their Science lessons.  There is also a bit of Math and of course some Digital as well.  If you are interested in getting some personalised help just get in touch!

For this project we used:

We are interested in making sure our plant doesn't get thirsty in the office. To monitor this, we use a Soil Moisture Sensor.  The one we are using is specially designed to work with crocodile or alligator clips.  Hence the name GATOR:BIT

microbit

To wire it up just connect the 3V, GND and Signal.  I have used Red, Black and Yellow for this.  

In my example, I connect the Signal to Pin 3.

gator:bit

For the code, we want to monitor the change in voltage on our ADC channel.  I have chosen to output the value to an excel spreadsheet, but you could display the number on the micro:bit or an LCD if you like.  To output to Excel, you need to enable the Microsoft Data Streamer. Learn how to do that here.

 

 

The final part is setting up your Excel Data Streamer to the match the data you are sending.

Data Streamer settings

and you should get some results similar to this.

Resulsts from gator:bit

 

Now all the real fun begins!  Get Scientific and work out the optimal value for plant happiness.  Engineer an enclosure to make it weatherproof.  Delve into the Digital Technology and use the Bluetooth to wirelessly stream the data! of course, there is data so perhaps plot a graph using your Math skills.

This is what STEM is :)

Happy making.

Troy.

Leave a comment (all fields required)

Comments will be approved before showing up.

Search