Data Streamer

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.

ENABLE ADD-IN

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

Let’s begin!

What You Need To Get Started

Sensor

You can build one or use one you already have. See the library below to get started building your own.

Microcontroller

A small computing device that is programmed via a process called flashing. It enables data to be exchanged between the sensor and Excel.

Data Streamer Add-in

Add-ins are software components that enable Excel to be customized beyond its basic functionality. This Add-in sends data in and out of Excel.

Excel Workbook

An Excel workbook is a collection of spreadsheets. The Hacking STEM lesson plans include customized workbooks to match the curriculum.

How to Start Using It

It's just a few steps to connect your sensor to Excel.

Select a school transformation story from one of the following tab items below. Use the arrow keys to navigate between tabs, and the tab key to access the content for the selected tab.

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.

LESSON LIBRARY

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.

Flex/Pressure Sensor

A pressure sensor can be used to measure flexion and extension or applied force.

STREAM SENSOR DATA

Electromagnetic Sensor

An electromagnetic sensor can be used to generate an electrical current induced by a magnetic field.

STREAM SENSOR DATA

Electrical Conductivity Sensor

An electrical conductivity sensor can be used to detect the flow of charge within a liquid.

STREAM SENSOR DATA

Electrical Switch

An electrical switch is used to turn ON and OFF the flow of electricity in a circuit.

STREAM SENSOR DATA

Data Streamer Partners

NASA

A curated collection of lesson plans and labs focusing on the daily challenges astronaut’s face while working on the International Space Station.

VIEW COLLECTION

Vernier Graphical Analysis™ 4

Graphical Analysis™ 4 is a tool for science students to collect, graph, and analyze data from Vernier sensors.

VIEW INSTRUCTIONS

Play Impossible

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.

TRY OUT THE EXPERIENCE

BBC Learning

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.

SEE THE LESSON PLANS

Need help? Have questions?

VISIT THE SUPPORT PAGE EMAIL US



Follow this page
Share this page