Building a knowledge schema using higraphs – introduction to spreadsheet formulae

An online acquaintance posted the this a while back:

AS A early adopter of GH’s HGs, intimidated by it, and with limited time for exploratory learning

I WANT a screen recording video with voice over working me through an example from starting HG, to say, modelling learning for…IDK, spreadsheets? Or something simple enough to be done in sensible time, but complex enough to showcase the possibility

SO THAT I’m helped to the scary phase of having to learn the tool AND the skill.

So, ever responsive, I made one. This is based on the ECDL Module 3 Spreadsheet syllabus. Higraphs are only worth the effort for moderately complex topics, so I chose spreadsheet formulae. These require a good understanding of a number of spreadsheet and data handling concepts, which are then integrated. In terms of Cognitive Load Theory, formulae would be considered “highly interacting elements”.

As I was modelling, I realised that I was sometimes drawing processes, and sometimes dependencies. These are closely related, but it is going to take some thought and research to split them apart. In some cases, it doesn’t really matter, since the key thing is that the model serves the desired purpose – in this case, to be able to more effectively teach people how to use formulae in a spreadsheet.

As an introduction, I created a meta-schema – the schema of the knowledge required to create a schema:

A meta-schema for building knowledge schemas.

Using this as a basis, the video shows how I build out a possible schema for teaching spreadsheets. I strongly suspect that there are multiple equally good dependency paths to a good schema. But not all paths are viable – the good ones are a strict subset of the powerset of possible paths.

A knowledge schema for teaching and learning spreadsheet formulae.

The video of the process is here. (For some reason WP is not able to fetch it from YouTube!)