Python Code to Know

This is the copy of the Jupyter Notebook I was working on Google Co Lab to show the Year 10/11s for the basics of Python programming. But alas Google Colab is blocked in school. However there is a way of publishing the notebook as a GitHub Gist. And the link below should show the gist (which is linked to the Colab notebook. Confused? I know I am!)

Learning about AI with Google’s Teachable Machine

https://teachablemachine.withgoogle.com/

I’m teaching a module on Artificial Intelligence to my Year 9 students, and they are really enjoying it. Today’s lesson was about “How do we get a machine to learn” and led on to training the following machine to recognise the difference between two students.
Unfortunately, the model was taking too long to train at the end of the lesson (hint – always leave plenty of time to do this activity!) but I didn’t want to lose the value training it had done so at the end I downloaded the model and set up a page that has a webcam that will (hopefully) detect which student is standing in front of the camera. The beauty of this is that no images of the students are stored anywhere. The model has already learned all it needs and discarded the original images.

https://geekcandy.co.uk/teachablemachine/

Excel formula to count words in a cell

It’s reports time again – specifically UCAS references time. And I need to write up to 140 words on each of my students.

I like using Excel for such things but was surprised there was no easy way of counting the words in each cell. I knew you could count characters using LEN() but not how to count the words…. till I found this post and this useful snippet:

=LEN(TRIM(text)) - LEN(SUBSTITUTE(text, " ", "")) + 1