I heard its good for databases...

My high school IT teacher said this outright. He was a FOSS guy, but he said employers will expect MS Office, so we're going to be learning that.

Funnily enough proprietary software is frowned upon in my professional domain. Im not mad though, the excel commands and whatnot still work in libre office spreadsheets.

Unrelatedly, doing statistics in a spreadsheet program sounds like absolute hell.

The point is that learning institutions should not prefer one commercial companies solutions vs another.

In fact, they should not use or be dependent on commercial companies at all.

Learning stuff and implementing what you learned should be available for all. Not just people with the money.

Companies know this so they give away their stuff for free to these schools knowing they will contain these people for life.

We need to break out of that extreme vendor lock-in.

I have coded VBA-based shadow-IT back in the day, but I seriously think this is something that needs to disappear in most firms that still have it. It is typically unmaintable automation of tasks at the department level that is super dependent on who is around and is still often in use after the programmers are long gone. I have seen a few old VBA tools in use that should be done with standard python/R or god forbid even JS Code in a decent documented repo.

"Sometimes Excel is what's available."

I worked for a Big Company that was cutting back and dropped their Oracle contracts, forcing all the DBAs to work in Access. Then they fired all the DBAs, forcing everyone to either try to figure out Access or switch to Excel. Guess which way they went.

In my last job at that company, my department had built an Excel spreadsheet (database) so large and full of calculations they had to request money to update our machines to 64-bit Windows and 16GB RAM just to run it.

we aren't in college to learn a specific skill so much as we are there to learn how to be taught.

I really like this idea, but prefer one small change: I think it's best to learn how to learn.

Learning how to be taught is part of that, and a large part. Understanding when to absorb information, rely on experts, and apply yourself until you improve is fundamental. You won't get any arguments from me there.

But being taught is only one facet of learning. Sometimes experts aren't really experts, or don't have the learner's best interests at heart, or omit things to protect their own interests or ideology.

Learning how to learn involves fostering fundamental curiosity, not being afraid to fail, asking all the questions even dumb ones or those with seemingly obvious answers. Finding out "why" something works instead of just "how". Fundamentally curious people who learn as a habit tend to also develop a scientific method-like approach to evaluating incoming information: "Ok, this is the information I'm presented with, let's assume the opposite, can I prove the null hypothesis?" This acts as a pretty good bullshit detector, or at the very least trains learners to be skeptical, to trust but verify, which is enormously important in the age of misinformation.

Being taught generally tapers off as someone gets older, or becomes an expert. Learning never needs to taper off, so long as your brain still works.

For most of us, we aren’t in college to learn a specific skill so much as we are there to learn how to be taught. To prove we are capable of taking instructions and producing results as requested.

This is true to the extent that you won't be solving Organic Chemistry 1 or Linear Algebra exercises at your workplace, but I think it's misleading. If anything, from my experience, people focus too much on producing the results and not enough on learning the skills. A lot of people stay on the mindset of "I only need the degree / where am I going to need that / the industry has moved on from this" and don't build strong foundations

It is extremely common for classes to require students to learn to use proprietary software. It's a tool of the trade. If they graduate you without teaching you how to use it, they'd be fucking you over and ruining their own reputation. Like, imagine an accounting student graduating not knowing excel, because they did all their assignments using MatLab because they liked it better. It would be absolutely unthinkable for any potential employer to hire such a student. Excel is the software they use in that field. If a student wants to learn a different option in their free time, that's fine and dandy.

I can never say this enough: the best tool is the tool that gets the job done

Hmm. What about CAD? The professor going to teach FreeCAD, OpenSCAD, F360, OnShape, etc?

I think requiring one tool is OK. You're there to learn the process in a way that you can migrate to what you want later. Teachers aren't paid enough as it is, so it should be made as easy as possible for them to manage the flow of work.

Hell, R was being used in colleges in 2000. Unfortunately, whether it was SPSS for the soft sciences or forcing stats work in Matlab for the engineers, professors always seemed bad at promoting the right tool for the job.

R is great. Your boss will give you excel.

Have you got recommendations for learning how to use tex, R, or Python for those that haven't learnt how to programme?

Haha, Microsoft absolutely changes shit all the time. Millions of organisations around the world have an octogenarian computer standing somewhere in a corner because they need it running the old software.

the world of number crunching

Weird, I've never heard of excel being used on HPC systems

Not just within your organisation, but imagine trying to share something other than Excel outside of it!

Not sure if the post is about GUI vs non-GUI. I read it as use R or pandas instead if SPSS.