I teach Web Design/Dev at the community college and each semester I get a list of students in my Web Development classes in CSV format that includes their firstname, lastname, username:
Steve, Jobs, jobs
Steve, Wozniak, woz
I need to append a URL which is the same for each student to each username. I then generate an HTML doc so I get a list of the Student Names and the URL for each account so I can quickly access their information for grading, troubleshooting, etc.
I’ve done this using Google Sheets or Excel and then export HTML, but why not automate it?
Where should I begin on the Mac? I know enough scripting and programming to get myself in trouble (and sometimes out of it)
Thanks for any guidance