Classes I'd like to teach to high schoolers:

CHAOS MITIGATION: Stay organized, fight digital & physical entropy (replaces home-ec 101)

THE BOX YOU LIVE IN: Wire outlets, unclog drains, fixit stuff (replaces woodshop)

SPREADSHEETS: Before code learn this (replaces any intro class teaching Java)

@ethanschoonover #3 must include a section on How Do I Know This Is Right?, techniques for explaining and verifying spreadsheet results. This is the same expectation we have for both manual calculations and traditional computer languages and it absolutely must be extended to spreadsheets.

The biggest problem I see is not with spreadsheets in general but with Excel in particular. Excel makes error detection, documentation, and verification virtually impossible while adding in the risks of unintentional type conversion and silent precision loss. I could probably spend a month on all the ways Excel is impossible to trust for anything you consider important.

When cooking for others, you have a responsibility to use clean cookware and keep food at a safe temperature. You have similar responsibilities when calculating for others regardless of the tools you use.

@ethanschoonover Backstory: my current job is qualifying nuclear safety analysis software for use. Excel is an attractive hazard in this environment but there is nothing, absolutely nothing you can do to stop degreed engineers who should know better from using Excel for things they shouldn't.

I can show multiple instances where badly-coded Excel has indirectly killed people. All I can do to mitigate this risk is to help people recognize the risks and show them ways to use the tool safely and responsibly. At least give them some way to realize when Excel in particular poses an unacceptable risk.

Excel is easily the most popular functional language in current use, possibly the most popular computer language in general. MS won't fix its dangerous flaws without coercion so the best we can do is help people not hurt themselves or others with it.

@ethanschoonover @arclight i’m just going to tuck these into the folder. i’m slowly (more than i like) putting together a spreadsheets-as-actionable-programming class for manufacturing engineering undergrads.