Data Plotting Software for HS Students

  • #1
brainpushups
437
186
I'm designing a course for 9th grade students that focuses on experimental methods in science. One topic that will come at the beginning of the course will be how to display experimental data graphically, including estimates of experimental error.

I'm looking for some advice about what software to train students on (probably a spreadsheet program, but it doesn't need to be). I'd like to train them in 9th grade on software that they would use throughout high school and beyond. Google sheets is so close to being adequate, but it does not easily allow for independent uncertainties to be displayed. There are a few workarounds, but they are clunky and I'd like to keep the instructions as simple as possible for 9th grade students. Also, horizontal error bars are not possible.

One issue is that many students use Chromebooks and so a significant number of students would need to access software in the cloud. Also, we don't have school computers any more so installing software at school is not an option.

I thought I had figured out a solution because Microsoft offers Office365 for free on Chromebooks that are under a certain size so the students who get their computers through the school would be able to access this for free. I just tried it myself and I was disappointed to see that there is NO error bar option in the online version of Excel. Apple's Numbers also doesn't have error bars as an option when accessed on the icloud drive. C'mon!

Of course, students can print and draw error by hand but that seems ridiculous with the ready access to technology that you'd think would be able to do what is usually so simple! This also makes online submission more difficult, but maybe I'll just have to settle for that.

So, if anybody has any suggestions I'd love to read 'em! I have exactly $0 to spend.

PS
One final thought that just came to me is to write some scripts in Python or R that students could change and use, but I'm not sure I like that idea yet. In terms of 'simple' this probably ranks below the google sheets workarounds though it would generate some slick looking student work.
 

Answers and Replies

  • #2
hutchphd
Science Advisor
Homework Helper
5,139
4,316
Your dollars will buy you the OpenOffice suite (freeware). I have not used it much but the spreadsheet seems equivalent to older EXCEL. I believe the clunkiness with error handling is similar but you can always add the error values as separate data columns. Also more automatic error handling is a two-edged sword...
 
  • Informative
  • Like
Likes berkeman and brainpushups
  • #3
brainpushups
437
186
Thanks. I had forgotten about OpenOffice, but I used it years ago. I'll check with our IT guy to see if it is possible to run on our Chromebooks and play with it in the meantime.
 
  • #4
hutchphd
Science Advisor
Homework Helper
5,139
4,316
Yeah I use on windows
 
  • #5
kith
Science Advisor
1,414
501
Spreadsheet-based programs are probably better suited for your needs, but if you are really considering python have a look at colab from google . It's an online version of jupyter which fits nicely with the chromebook philosophy.
 
  • Like
Likes brainpushups, atyy and jim mcnamara
  • #6
brainpushups
437
186
Spreadsheet-based programs are probably better suited for your needs, but if you are really considering python have a look at colab from google . It's an online version of jupyter which fits nicely with the chromebook philosophy.

Cool. Thanks for that. Something worth considering for upper level students or those who are already into programming.

After some more investigating I'm inclined to suggest LibreOffice (still waiting to hear if it will work on the school-provided chromebooks) since OpenOffice doesn't feature horizontal error bars.

I appreciate the input!
 
  • Like
Likes hutchphd and berkeman
  • #7
gleem
Science Advisor
Education Advisor
2,045
1,463
I just noticed that LibreOffice has a chart style for stock prices which includes the ability to display daily price ranges in a manner suitable for indicating uncertainties of data points.
 
  • #8
gleem
Science Advisor
Education Advisor
2,045
1,463
This is the example of a LibreOffice stock style chart

Libre chart 1.png


The bottom of the vertical data symbol is the low price for the day, the upper limit is the high price and the horizontal line is the closing price so it is easy to configure them represent a mean and uncertainty
 
  • #9
brainpushups
437
186
I just noticed that LibreOffice has a chart style for stock prices which includes the ability to display daily price ranges in a manner suitable for indicating uncertainties of data points.

But if you right click the data series (for a scatter plot and bar/column charts, at least) the options to add x and y error bars are right in the pop up menu.
 
  • #10
gleem
Science Advisor
Education Advisor
2,045
1,463
Thanks, I didn't know that.>
 
  • #11
gmax137
Science Advisor
2,208
1,815
Graph paper is by comparison completely egalitarian. Plus the kids might develop a feel for numbers.

Crap, how did I end up being the old guy?
 
  • Like
Likes PhDeezNutz, rsk, symbolipoint and 1 other person
  • #12
brainpushups
437
186
Graph paper is by comparison completely egalitarian. Plus the kids might develop a feel for numbers.

For years now I have specifically not taught how to use technology for that very reason (except in my Physics II course for the purposes of numerical integration). The pendulum is swinging the other way I guess, but tech use is just one small piece of a major undertaking that I'm trying to spearhead to improve many aspects of our science sequence. I still will, of course, accept work that is graphed by hand.

Trust me, the emphasis I place on students understanding of 'the numbers' is paramount, but I'm not convinced that making a bar graph or scatter plot by hand has a great impact on it. I am convinced that learning basic spreadsheet use is something that every student will benefit from, and I suspect that many 9th grade students will appreciate the time they'll save and may find it more engaging than doing it by hand.
 
  • Sad
Likes symbolipoint
  • #14
brainpushups
437
186
@sysprog - Thanks, I had found that site but thought it required subscription. I see now that there are free options.
 
  • #16
brainpushups
437
186
You might also look at GeoGebra either online or locally

Lol. I have it (though I don't use it much). I overlooked that it has a spreadsheet build in every time I've opened it.
 
  • #18
Dr Transport
Science Advisor
Insights Author
Gold Member
2,570
722
Crap, how did I end up being the old guy?


It happens, I just recycled aboput 20 packages of various graph paper left over from when I was an undergrad and the first foray into grad school in the '80's. I'm hiring kids who are my kids age right now. Crap, we are old.
 
  • Like
Likes PhDeezNutz, sysprog and symbolipoint
  • #19
hutchphd
Science Advisor
Homework Helper
5,139
4,316
Consider the alternative.
Also I thank the the universe with each successive morning that I was born into this time and place. How could I have been so fortunate?
Then I check for body parts that may have fallen off...
 
  • Like
Likes sysprog, gmax137 and Dr Transport
  • #20
Leo Liu
343
145
You can use https://www.wolframcloud.com. It is free as long as you don't run out the credits, and it supports the succinct wolfram language. In other words-- it is an online mathemtica.
1596486701606.png
 
  • #21
fluidistic
Gold Member
3,880
219
I am not sure why people suggested Open Office instead of Libre Office. Open Office isn't maintained since almost a decade now. Libre Office is still maintained and should be used instead.
 
  • #22
FactChecker
Science Advisor
Gold Member
7,437
3,218
For something to run on Chromebooks, consider R. It is designed for statistics and can be used from Chromebooks (in the cloud?). It is free, very popular among statisticians, and will certainly allow them to use it all the way to a professional career.
 
  • Like
Likes Leo Liu and sysprog
  • #23
mabraden
5
2
desmos-graph (1).png

Here's a Desmos solution, if you're still looking. Your students might come in familiar with Desmos from math classes. For IB physics, students are supposed to play around with maximum and minimum slope lines to get uncertainties which is how I started playing with it. Here it is with those sliders.
 

Suggested for: Data Plotting Software for HS Students

Replies
6
Views
910
Replies
0
Views
974
Replies
12
Views
3K
Replies
8
Views
1K
Replies
10
Views
778
Replies
19
Views
3K
  • Last Post
Replies
14
Views
2K
Top