Electricity

While week twelve's electrical laboratory remains high on my list of laboratories in need of a refresh, I have not yet stumbled upon a laboratory that well keeps with the spirit of using only locally available inputs. Even as configured the inputs are not available on island.

Elisa tests her ring for conductivity

Elymore explores Ohm's law

Myreen and Trevalouva investigate Ohm's law

Elymore works on getting an electric motor than uses magnets to run

Elymore tries to get the electromagnet variation running, successfully

The Ohm's law data was very linear

Melsina and her child

Austin and Justice working out the voltage

Amy-lang tests materials for conductivity

Comments

Post a Comment

Popular posts from this blog

Box and whisker plots in Google Sheets

Image
And then everything changed. For the first time since the loss of Gnumeric a spreadsheet was displaying a box and whisker plot. To back up to the beginning, MS 150 Statistics was built around spreadsheets. Students in the course were not statistics majors and the overwhelming majority were not in a scientific field. Most would wind up working on office desktops for which they would not be an administrator. Downloading R would not be an option and R would be steep learning curve for some for whom computers are an unfamiliar technology.

Spreadsheet based statistics, for all the faults and potential for error, would be at the center of the course. The use of Ubuntu in the classroom meant using LibreOffice.org or Gnumeric. Gnumeric provided the capability of including box and whisker plots. A change in computer laboratory technology to Microsoft Windows five years later saw the use of Gnumeric on Windows - until Gnumeric stopped supporting Windows. A further change of my work top to OSX f…
Read more

Setting up a boxplot chart in Google Sheets with multiple boxplots on a single chart

Image
The Google Statistics add-on for Google Sheets can display multiple boxplots in a single chart. The key is the layout of the data. One column should be the variable by which the data is to be grouped, the other column should be the data to be box plotted.


Set up the Statistics add-on with the data to be plotted as the variable, and the grouping column as the "by" variable. In this image I had deselected all but the boxplot option, the result was the appearance of the Moment, Standard errors, and Confidence intervals options. The default is apparently a 95% confidence interval for the mean.


The result is multiple boxplots on a single chart with a common scale. The new tab that is created also quotes 95% confidence intervals for the mean. Note that as of 2018 the Google Statistics add-on cannot be found by search in the add-ons. In addition, as of May 2018 the add-on no longer verifies, possibly due to the add-on not having been updated since August 2017. One may have to essen…
Read more

Creating histograms with Google Sheets

Image
My approach to creating histograms for the past sixteen years has been to have the students determine the minimum, the maximum, calculate the range, divide the range by the number of intended classes to find the width, and calculate the class upper limits. The class upper limits then permit the use of the FREQUENCY function in spreadsheets such as Excel, LibreOffice.org, OpenOffice.org, Google Sheets and Gnumeric. While in Excel and LibreOffice.org the existence of a gap width or spacing setting allows the columns to touch, Google Docs did not provide this option, hence the chart seen below.


The data is from an exercise in which the students weighed packs of MMs.

This past week, however, a student noted that Google Docs now has a Histogram chart type as a chart type. One pre-selects the raw data and chooses the Histogram chart type. The sheet used in the illustrations below can be seen on line.


Note that by default Google Sheets chooses the minimum, the maximum, and the number of clas…
Read more