Bring real-time data in and out of Excel
Modernize your classroom with live data to transform how students model modern scientific and engineering practices.
What is Data Streamer?
Want to measure wind speed from an anemometer? Model the impact of the brain colliding with the skull? Determine the electroconductivity of a solution? Excel’s Data Streamer Add-In supports capturing, visualizing, and analyzing real-time sensor data in Excel spreadsheets.
Data Streamer provides students with a simple way to bring data from the physical world in and out of Excel’s powerful digital canvas. With a sensor connected to a microcontroller that is attached to Excel, begin introducing students to the emerging worlds of data science and the internet of things.
Data Streamer is available for free to all O365 subscribers.
Preparing to stream real-time data
To get data from a sensor into an Excel workbook, connect the sensor to a microcontroller that is connected to a Windows 10 PC. Excel’s Data Streamer Add-in also needs to be enabled and a workbook needs to be opened.
If this sounds intimidating, don’t worry! It is not as hard as it sounds. We have step-by-step instructions to get you started.
The first time is always the hardest, and after you have done it once most of the set-up remains the same.
How to Start Using It
It's just a few steps to connect your sensor to Excel.
Step 1: Open Excel and enable data
The O365 subscription includes Excel and the add-in for FREE.
Step 2: Flash code for the microcontroller
The instructions below and the Hacking STEM lesson plans support working with Arduino or micro:bit.
Step 3: Build a sensor or use one you already have
Some microcontrollers have sensors built-in; those work too!
Step 4: Connect the sensor and microcontroller
If you haven’t done this before, there are some easy to follow diagrams in the instructions.
Step 5: Open an Excel workbook
Use one of the customized workbooks from the library below.
Step 6: Start streaming real-time data
You can record your data to import or play it back later.
Projects using Data Streamer
Wondering where to begin? Check out Hacking STEM’s collection of FREE, standards-aligned lesson plans. From math to physics to chemistry these lessons are classroom ready. Give them a try and see how they inspire you to use sensors in your classroom.
Sensor and workbook library
Need a sensor? Already have one? Here is the start of a collection of classroom-ready sensors, code and workbooks. We’ve also added links to Hacking STEM’s standards-aligned lesson plans to jump start your experience. Keep checking back, as we will be adding to list on a regular basis.
A pressure sensor can be used to measure flexion and extension or applied force.
An electromagnetic sensor can be used to generate an electrical current induced by a magnetic field.
Data Streamer Partners
An amazing group of partners have already started connecting their sensors and content to Data Streamer. Come be the next!
Use physical and digital models in the context of answering 4 big questions which compliment the BBC Earth and OCEANX film, Oceans: Our Blue Planet.
Mattel Hot Wheels Speedometry
Build digital timing gates to measure speed to illustrate forces and motion. Graph the shift from potential to kinetic energy and collision impact.
Connect the sensorized Gameball™ to Data Streamer for a digital twist on the egg toss. Learn Newton’s 2nd Law with this math in sports science experience.