Gemini to convert table image to comma separated values

Tabular data in Desmos is not directly exportable in any form, nor is there a way to copy and paste the data in a Desmos table. 


A screenshot of the table was uploaded into Google Gemini with the direction to convert table image to a spreadsheet format.


Gemini returned a comma separated list. That list was copied and was pasted into a text editor. The text editor was used to save the file as a comma separated list (.csv) and then imported into a spreadsheet for analysis of frequency versus the speed of sound. 

Comments

Post a Comment

Popular posts from this blog

Moodle bulk grading of manually marked quiz and test questions

Image
Manual marking of an essay type question on a quiz or test in Moodle can be done student by student but that process involves a lot of clicking and scrolling as one has to open each student's submission. There is a bulk marking screen available. In the test or quiz click on Results. At the upper left side is a stealth drop down list menu under the word "Grades" that includes the option "Manual grading." Choose manual grading. On the far right click on the blue "grade all" hyperlink. That will open up a all of the submissions for question one on a single page. One can now mark all of the question one submissions manually for all students in the course. 
Read more

Experimenting with the PlantNet and iNaturalist apps

Image
The application of image recognition technologies as the back end to botany apps is providing increasingly relevant search results. Over the recent winter break I began looking at whether the apps now available might be useful to the ethnobotany class here on Pohnpei. Some apps had a more regional focus in the past and were better at north american or european plants. Pohnpei has a both unique indigenous plants and many introduced plants from around the world -  a challenging environment for any image recognition system. A student working with a plant identification app for the first time My criterion was that the app had to be appropriate for use in my classroom. The app could not contain advertising and the app had to be free, my students typically do not have the ability to pay for an app. The app would also have to be fairly small as my students often use phones with limited memory and processing power. I settled on PlantNet and was impressed with the ability of the a...
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 ha...
Read more