Saturday, 20 February 2016

Teaching Basics of Neural Networks with Spreadsheets

The basis of this idea was inspired by some work that can be found in the paper Varley et al (2005).

In these videos examples of using spreadsheets to play with the concepts of neurones  are shown. These approaches were developed for the teaching of these approaches and the videos were recorded in a class whilst teaching the concept.

Video 1
Using a spreadsheet to replicate the neurone. Video shows the building of the model and it's use. 





Video 2
This video extends the ideas from video 1 and expands them into training a neurone. 

Using a spreadsheet to show the delta rule (change in the weight [x] = learning coefficient * input [x] * (what output we wanted - actual output from the neuron) being used to training the weights for a neurone.





VARLEY, M; PEAK, M; HEYS, J; COLLINS, G; KONSTANTARAS A,  VALLIANATOS, F; PICTON P (2005) Spreadsheet Software as a Teaching Tool for Concepts in Electronic Engineering, [Online] http://www.wseas.us/e-library/conferences/2005athens/ee/papers/507-162.pdf accessed on: 20/2/2016


All views and opinions are the author's and do not necessarily reflected those of any organisation they are associated with