For one off, simple jobs, used sparingly…those FOSS alternatives are fine.
If I need to spend more than 10 minutes of time using them…I’m frustrated beyond measure at their UX issues.
Learn a spreadsheet, pick up any spreadsheet easily for the rest of your life.
Seems to me the only reason to push FOSS in that case is for activism purposes over any real value to the student.
Not to mention any so-called deficiencies could be remedied in two years by directing 1% of the budget from private jets to FLOSS.
Not sure there are too many school districts with private jets, but if you are referring to the corporate software publishers, i am pretty sure there would be much better things to spend 1% on other than supporting FOSS to benefit and support society.
I don't think that either Photoshop or GIMP meet this for the vast majority of students and classes. I definitely could see some advanced students and high school courses making use it, though.
I think LibreOffice and Notepad++ are just fine and could be used as a drop-in replacement.
In terms of the specific pieces of software, I don't think Photoshop is so much easier to learn than GIMP and GIMP has the added benefit of being libre/free and gratis. There's also Krita [0].
Yes, really. You may as well be comparing calc.exe to Excel, same comparison.
Gimp is really not adequate for everyday usage compared with Photoshop? Really?
LibreOffice/OpenOffice doesn't provide adequate alternatives to spreadsheet/doc/csv? Really?
Notepad++ is not good enough of a text editor? Really?
One semi valid criticism is that there isn't a support infrastructure to help organizations with their open source needs. While I don't believe it on it's face, regardless, this is an opportunity to push for that infrastructure and to help every single FOSS project with funding to support the community needs.
Public infrastructure should not be captured by vendor lock-in.