Martin Fowler coins a useful term: “Illustrative Programming”: languages that “fuse the execution of the program together with its definition”. “Illustrative programming requires information from the actual running of the program.” He uses Excel as an example.
I think MIT’s Scratch provides an example of this as well. I need to pass it along.