> I still think excel is the leader in this category.
Yes, definitely. The "reactive functional" programming paradigm of the spreadsheet is radically more understandable for end users than the imperative, as it doesn't require keeping a mental model of state changes in memory.
Fortunately, React has popularized this reactive functional paradigm and it is no longer confined to spreadsheets.
> I’m thinking the same elements presented in an environment perhaps more like Scratch could work
An approach of visual building blocks could help for learning, though Scratch is imperative so it has all the trappings that make a language hard to learn for non-programmers, plus all the inconveniences of editing a visual language (much more cumbersome than editing text).
I'd rather have a "structure editor"[1] for editing a textual language (like the spreadsheet, but with a tree representation instead of a grid one), which added enhanced visual representations over the base tree. You know, like the IDEs developers use, but with a functional reactive language that mixed code and data, like the spreadsheet does.
[1] https://www.youtube.com/watch?v=CnbVCNIh1NA