I am currently a teaching assistant for both master and PhD students. Part of my work included helping and supervising them during several lab experiments (physics). One task of the lab experiments is to write a program to numerically calculate values and simulate them afterwards. The students are allowed to use any programming language they want to use (except stuff like Brainfuck and Whitespace, of course), as long as they provide the source code with the result.
While the master students are not having any problems with the problem, I got was asked by the PhD students if I can help them do the programming in Excel, as that is the only thing they can use and know for "programming".
How far should I now go and help them? I know that doing the task they are assigned to is impossible to do in Excel, but they never used any other language or programmed themselves. I am able to teach them how to achieve the programming goal, but based on their current knowledge that will take a lot of time, which I also need for my own lab tasks. Should I thus simply tell them to drop the course, or should I try to help them, and if yes, in which extent?
I'd state my competences (where I can help without having to study a week to come up to speed) beforehand, and tell them I can't be of much help outside that range.
That said, being able to use Python (perhaps as part of sagemath), or perhaps some language like Mathlab will be very valuable for them later on. Yes, spreadsheets are Turing complete, but that doesn't mean anything. It is much more important that the program is clearly written, and can be fixed/extended by somebody else (even yourself after not looking at it for a couple of weeks).