Hacking STEM project overview

Hacking STEM Project Overview

Hacking STEM intends to give you the tools you need to 

Step 1: Build & Learn

Build and learn_c3m_201808194819 Materials List | Instructions

Build scientific instruments with your class using every day materials while bringing science and engineering concepts to life—the lessons will show you how. Every Hacking STEM lesson includes instructions for each stage of the project—from a complete materials list per student to step-by-step instructions for guiding students through the building process. Each lesson contains the following resources:

  • Instructions (PDF): A step-by-step guide for building the project. Includes detailed instructions and a list of things you need.

  • OneNote notebook: Contains lessons, materials, and activities to support teaching this unit. Mapped to the NGSS and ISTE standards.

  • Customized Excel workbook: A customized Excel workbook that visualizes real-time data generated by the project. Requires the Project Córdoba add-in.

  • Materials list: A spreadsheet with links to online resources to help you bring these projects to your classroom.

  • Code for the project (.ino file): Pre-built code for your microcontroller to help you and your students visualize live data.

 After you’ve reviewed these resources, follow these steps:

  1. Use the Materials List spreadsheet, locate the materials needed per student.

  2. Refer to the Instructions PDF and follow each step with your students. Instructions are broken into different sections for building analog and digital devices, as well as for how to connect to the microcontroller, upload microcontroller code, and visualize data in Excel.

Step 2: Connect Your Tools

connect your tools_c3m_20180819517   Instructions | Microcontroller Code

After you’ve completed building the structure of your device, it’s time to digitize your device and connect to a computer. Refer to your Instructions to learn how to breadboard and connect to your microcontroller.  

Once connected, upload the microcontroller code onto your device. This supplies it with the ability to receive data from the right pins. The microcontroller code can be found in Code for the project and will download in the form of an.ino file 

Step 3: Visualize the Data

visualize_c3m_201808195159 Workbook | Project Cordoba*

The final step of the project is to download the customized Excel workbook and begin streaming and visualizing data. Data is constantly being streamed into Excel via Project Córdoba, but you’ll need the customized Excel workbook included with this project to visualize the data. The Excel workbook compiles the incoming data and converts it into easy-to-understand graphs. 

*Project Córdoba requires a computer running Windows 10 and Excel 2016 desktop version 

Additional resources:

Seattle-area middle school educators James Burke and Jason Ewert are Hacking STEM with everyday materials, one 21st-century lesson plan at a time.

Hacking STEM technical requirements:

  • Windows 10: This project requires a PC running Windows 10. Update your version of Windows here.

  • Microsoft Excel 2016 (Desktop): Students and teachers are eligible for free Office 365 for Education, which includes online Word, Excel, PowerPoint, and OneNote.

  • Project Córdoba Add-in: Modernize your existing copy of Microsoft Excel with this free add-in to support real-time data streaming from your projects

  • Arduino IDE: The free Integrated Development Environment enables you to write code that connects your project to an Arduino microcontroller.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.