Displaying your data

Oct 19, 2020 at 7:02 PM by Annette Warren

Hi everyone!

I'm so happy to be participating in these coding workshops with you all virtually! While I can't make Tuesday nights, I view the recorded sessions and use micro:bits from wherever I can get them to try out these ideas before attempting them with my fifth graders. We're studying weather, so these wind monitoring stations are the perfect project for us at the moment! I'm thinking that United Nations Day on October 24th might be the perfect day to get started introducing the Sustainable Development Goals.

I'm wondering if any of you have attempted the serial data writing to any software yet, or figured out how to do it. I've reproduced the code, but I understand that the micro:bit has nowhere to store the information, and don't yet know how to have it write to a spreadsheet. Our students all have access Google Sheets, so that would be ideal. Any help or links to tutorials that can explain how this is done would be greatly appreciated! In the meantime, I'll play with it!

Looking forward to the next session,

Annette

Newfoundland and Labrador

3 Replies

Christopher

Oct 19, 2020 at 10:08 PM

Hi Annette,

I am learning the simulator graph and table that are built into Make code. It was only recently that the work computer would pair with the micro:bit. Viewing data with a paired microbit https://makecode.microbit.org/...

The WEB USB feature lets us now send information to the microbit (flash) and read in data to the Make Code Console and later download a CSV file for Excel or Sheets. - Might be best option as you mentioned Google sheets is available to your students.

Make Code Console https://support.microbit.org/s...

For Jr. level, the students did the paper and pencil method of recording data and will just start using the Makecode simulator.

Microsoft Excel Data Streamer

A direct method for having live data from the microbit sensors appear in Excel can be done through Excel Data Streamer. Students can customize the line and bar graphs.

Link to files with an example of the light and temperature unit --> https://drive.google.com/file/... There are links on the last slide, but they do not seem to appear on preview file - reposted below.

•Enable Data Streamer in Excel desktop https://docs.microsoft.com/en-ca/microsoft-365/education/data-streamer/enable-in-excel

•Visualize Values Over Time for Sensors https://docs.microsoft.com/en-ca/microsoft-365/education/data-streamer/visualize-streaming-data-in-excel

•Video to insert line graph https://www.microsoft.com/en-ca/videoplayer/embed/RE4aykM?autoCaptions=en-ca

•Using Micro: bit and Make Code with Data Streamer in Excel https://docs.microsoft.com/en-ca/microsoft-365/education/data-streamer/using-microbit-and-makecode

Viewing data with a paired microbit https://makecode.microbit.org/...

Micro:bit data analysis https://makecode.microbit.org/...

Make Code App for Windows 10 https://www.microsoft.com/en-g...

Chris

Barb Seaton

Oct 20, 2020 at 4:03 PM

Thanks for tackling this Chris - Annette - if you need more - pls reach out!

Barb

Andrew McDonald

Oct 21, 2020 at 8:53 AM

Hi Annette,

Here is a tutorial to get started with some of the questions you had.

In the last 30 secs I touch on the exporting of the data for use in Excel or Google sheets.

In terms of that data - you can import into Google Sheets as a CSV file - Comma separated value.

Report this post

Annette Warren

Oct 24, 2020 at 9:07 AM

Wow, Chris! Thanks so much for putting in your valuable time to help me! This is awesome, and enough to keep me busy learning for the next few months, I expect!

Much appreciated!

Annette

Report this post