About Course
Many times we need to export to a .xlsx or .csv file or to the online think Speak, the measurements from the sensors that we have integrated into our applications.
This application, before being recorded in a .xlsx or .csv file, displays on the screen (in real time) up to 8 measurements simultaneously (which are sent to the PC’s serial port separated by “,” or “:”) and automatically creates a diagrammatic representation. The .xlsx or .csv file that is created after the recording is finished opens in EXCEL-like applications for further processing. Optionally, these values are sent simultaneously and automatically to the online Think Speak…
In the attachments ([Resources] option) there are versions of the application for each Operating System.
__________
Steps for running the application:
A. After registering on this material, a [Resources] option appears from where we “download” the version of the application depending on the Operating System we have.
B. We unzip the .zip file (it may not be necessary. It is usually decompressed automatically during the “download”)
C. In Mind+, we use the appropriate command to write data from the sensors to the serial port. The sending to the serial port must have the format: measurement1, measurement2, measurement3, … measurement8. The following STEM Extensions commands do this automatically…
Example from micro:bit, Esp32-E and Arduino Uno, to Mind+ with the STEM Extension, where we pass two (2) or one (1) measurements, out of the eight (8) that we have at our disposal…
D. We run our program in Mind+ or in any other programming environment (which reads sensor values and sends them to the serial port in the format: measurement1, measurement2, measurement3, … measurement8. )
E. We start the recording application (by double-clicking on it). We can start it just before the program that reads the sensor values (which we download to the microprocessors) starts running, and running at the same time:
Displays the values on the screen in real time.
Displays a plot of the values.
Optionally, it can also send the values (up to 8) to ThinkSpeak
At the end, it creates a .xlsx or .csv file, with as many columns as the measurements and as many lines as the values received from the serial recording.
F. We stop the recording application and the .xlsx or .csv file is automatically created. which we can then open with the EXCEL like program, for further processing.
With several new functions.
For this projection to work (linear) one to eight values are needed.
For this view (Radar) to work, two values are needed: distance (from sonar sensor) and direction from compass (built-in sensor in micro:bit)
Consult the instructions in the application itself…
Student Ratings & Reviews
