Well, no, it’s not, because in context we’re talking about high school. Certainly I think spreadsheets are useful enough to be taught by college, for certain majors or possibly as a GE, but it doesn’t have to be something everyone needs to graduate high school with.
Not because I think it’s useless, mind you, just because I think the curriculum space is limited and there are MORE important topics that could be included.
I don’t think it matters. The tooling changes every few years. I think the math classes are often taught now with some online graphical calculator apps (Desmos?), and you can do the basics there well enough. Or on pen and paper. If it happens to use spreadsheets, ok, fine, why not? But it’s the difference between talking about checking and savings and CDs and investment risk and such, maybe including a few barebones spreadsheets… vs a whole semester dedicated to vlookups and pivot tables and correlations and such.
I’ll use an example from my place of work, a medium-sized manufacturer in NE Ohio.
People who use spreadsheets every day to do their job:
Everyone in Sales
Everyone in Engineering & Drafting
Everyone in Finance
Everyone in HR
Everyone in IT
Everyone in Shipping / Receiving
Everyone in Maintenance
Supervisors and Team Leaders in Production
People who don’t use spreadsheets to do their job:
I don’t think anyone is even suggesting dedicating a whole semester to vlookups and pivot tables, etc. I explicitly said that basic spreadsheet usage should be taught and can be taught in classes that they already take.
Yes… and? Isn’t that my point? We shouldn’t be wasting time teaching spreadsheets to everyone if the blue collar workforce might never need it, while some of the other examples could make big differences in their lives and health.
My point is that the number of ppl in the company who use spreadsheets daily outnumber the people who’s job is just to stand at the line and insert tab A into slot B. And the Maint, S&R, and Prod Supervisors/Leads are all still blue collar - they didn’t go to university to learn their jobs. I’m just saying it’s a useful tool for a lot more than a “few niche white collar jobs”.
Understood, and that makes sense. Again, I apologize for misunderstanding your initial stance (my own fault for having missed that part of your post).
I don’t think there’s any harm (and in fact plenty of good) to teaching the very basics, alongside basic word processing and such. It wouldn’t have to take more than a few hours to do that.
What I was against was something you were never even arguing for (that it should be a significant item in the curriculum). I’m sorry for misunderstanding.
Matrix math was something taught to us high schoolers in Algebra 1/Algebra 2. It is a rectangular grid of numbers organized into rows and columns, used to represent data and linear transformations via addition, multiplication, etc.
I, in my high school-aged certainty, thought that this was some bullshit that I would never use in my life. Surprise - it’s the effective foundation of Visicalc/Excel, and while I never used manual matrix math after that class, I definitely used the concepts of it throughout my career.
Now whether or not our teacher would have better served us by taking the three weeks spent on matrix math and taught us Visicalc/Lotus 1-2-3 is another issue, but to me the surprise was that the one thing I was absolutely convinced was an utter waste of my time turned out to be one of the foundations of my working life.
Doctors. Dentists. Veterinarians. Nurses. Attorneys. Judges. Creative content producers of any sort. Therapists. Many academics (some do). Scientists (manage data yes but not with these sorts of spreadsheets.) And yes most of the trades.
Maybe some of them run their business and use some basic business software but they are not creating much in it.
No question that as someone who does not create in spreadsheets I likely underestimated how many people do. But you definitely underestimate how many highly paid and satisfying jobs do not.
We understand data. We understand asking the right questions and filtering out the noise. We even value clear data communication. And there are lots of us.
Where is the ball going? What skills will be least likely obsolete in ten or so years?
I introduced my poll knowing we are an old crowd. And a crowd that is overwhelmingly skeptical of AI. I am both older and skeptical of AI. I am nevertheless very confident that within a very years most creation of spreadsheets will be by stating what your dataset consists of and what questions you want to be able to answer in real time, and then asking them. I am also very sure that those in college today would answer these survey questions with greater confidence that creating spreadsheets will be looked upon like using a slide rule within the decade. Likely within five years.
It would astonish me if spreadsheets are not in near-universal use among research scientists. I suspect that plenty of nurses use spreadsheets as part of inventory management systems. Attorneys are likely to have use of them to manage caseloads. I’m pretty sure I’ve seen spreadsheets pop up on the screen at my dental office as they’re looking at things like patient history.
For context: I work at a large bank. Excel spreadsheets are ubiquitously used as tools even for important tasks because there are a lot of calculations in banking that only require simple arithmetic (for instance, converting Canadian dollars to U.S. dollars or summing up the values of different products). Tasks that are truly critical will get written using a proper software language (like Java or C), but that means making any changes is much less flexible because it has to go as an official request to the software development team (which has limited resources) rather than having the user simply change one formula in a spreadsheet
At my previous banking job, there was a push to eliminate any Excel spreadsheet reporting and move it to a Python-based system. That resulted in a lot of very knowledgeable employees being required to become novice-level Python programmers (with very little training or support from managers), which felt like a waste of human resources to me.
There is also a ton of lip service being paid to figuring out how to use AI for reporting purposes (i.e., to reduce employee headcount), but I haven’t seen any real traction yet.
I certainly would not claim that none of those ever look at spreadsheets. And a few in these jobs may even create them. I get business and coding information presented to me in them. I will even use it to search by specific codes used by different providers. That is very different than creating them or manipulating them to answer questions about the data. The latter is what we are talking about.
None of the links I provided were to people who simply “look at spreadsheets.” Is there any possibility that you’re underestimating how common their use is in all those fields that you said “don’t use spreadsheets to do their job”?
As for AI, I’ve lived my whole life in the middle of a tech revolution. When I was a kid we had a manual typewriter, but my atrocious handwriting meant that I got an EP Brother typewriter real early on, with a screen that previewed 16 characters before they were typed on the page. I graduated to a Vic 20, an Apple Plus at school, then an Apple 2C at home where we got the first printer, revolutionizing how we typed. I learned to touch-type on an electric typewriter and transferred those skills to Microsoft Word in high school, and worked my way through college as a typist for doctors and attorneys. Afterwards I wrote for a living for awhile, and worked as a secretary for awhile, typing documents for my bosses, until I became a teacher, where I started by using Word and transitioned to Google Docs.
The tech has changed drastically–but the typing skills I learned in junior high have remained useful more than a third of a century later. If I’d failed to learn to use that electric typewriter because of some vague notion that PCs were going to render it obsolete, I would’ve really missed out.
AI might be a much bigger change than computers. Or it might be a giant bubble made of 10% meat and 90% hype. I’m inclined to the latter belief. But even if it’s a huge change, knowing the fundamentals of how something works remains useful.
We spend many weeks teaching students how to perform long division, then send them out into the world with a calculator in every pocket. Even if AI completely removes the need for adults to write effective formulae, teaching the principles and practices of writing them is at least as useful as teaching long division.
Much less than the possibility that you vastly overestimate how many people do.
And here is where we vastly diverge. The coding language of spreadsheets is NOT fundamental to intellectual process of data analysis.
I get that you think AI is mostly hype. This particular use case seems to me to be the low hanging fruit. Which part of the following is outside of current AI capabilities if the systems are built around them?
Take written and verbal information and identify the data that is desired within it (demographics, dates, product codes, whatever …)
Enter that information into a database.
Answer questions about information and patterns within the database, including what-if scenarios.
Identify subsets within that database that meet certain criteria.