Senior Member
Join Date: Jun 2004
Location: Columbus, Georgia
|
Thank you in advance for any advice or help. I am a teacher. I am teaching virtually this semester. All of the assignments and grading are done in one platform and the grades for each assignment have to be entered into another platform. I can export the grades for each assignment into excel, but need help automating the pasting. I am looking for a little script or utility or something that will let me copy the grades from a spreadsheet, put my cursor in the first box of my grade book and press go and have it put in the first grade from the list "press enter" then put the next grade in and so on until the end of the list.
I have no idea where to start. HELP! What Adobe Updater‽ What‽ What‽ WHAT‽ |
quote |
Selfish Heathen
Join Date: May 2004
Location: Zone of Pain
|
Is your grade book a dedicated app (desktop? mobile?) or just some kind of online app in a web browser? I presume there's no import feature anywhere, is there? If you could find any way to import grades, it might be better to find a way to transform the shape of the other exported spreadsheet into some other format the grade book will import.
Unfortunately, all of my other ideas would require a fair bit of technical programming skill, and they would both assume your grade book tool is in a web app. For automating web stuff, Selenium WebDriver is a popular tool for programmers and SDET/QA engineers. You write code that teaches it what to look for in a web page and how to interact with it (click, type, etc). At the lower level, most languages like Python have libraries for communicating directly over HTTP, parsing web pages, and posting form contents; requests and Beautiful Soup come to mind. If you're not already a web developer, though, both of these answers are probably way out of scope for you. Outside of web apps, the tooling for automating clicks and types gets real shaky. With macOS, technically it's possible to use AppleScript to automate UI interactions, but it's a real nightmare finding the appropriate objects and the APIs are super obtuse and nigh-impossible to find good documentation. I know this because I have written two AppleScripts that change a bunch of system settings at night and in the morning, and it was agonizing getting them to work as I wanted. I've also seen/touched a program that did UI automation for Windows apps many years ago, so I know that's possible too, but I can't remember the name and wouldn't be able to give any good recommendations. The quality of this board depends on the quality of the posts. The only way to guarantee thoughtful, informative discussion is to write thoughtful, informative posts. AppleNova is not a real-time chat forum. You have time to compose messages and edit them before and after posting. |
quote |
Senior Member
Join Date: Feb 2015
Location: UK's most densely packed city. It's not London...
|
It sounds like it would be easier to write the developer of the grade submission application to incorporate an excel import function. It's a handful of lines of code on their side...
|
quote |
Senior Member
Join Date: Jun 2004
Location: Columbus, Georgia
|
My grade book is web based and the grades would be coming from a column in excel that is the exact number of rows as my grade book. I am just looking to do a row at a time, not a full grade book import.
I took some c+ courses 20 years ago in undergrad, but have not used it since. I did find what I was looking for that runs on Windows. I suppose I will just do my grade importing at my windows computer at work. Grade Paster for Windows I have feature requested this with the company many times. It makes no sense not to enable pasting. What Adobe Updater‽ What‽ What‽ WHAT‽ |
quote |
Posting Rules | Navigation |
|
Thread Tools | |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy and Paste issue with Numbers | Frank777 | Genius Bar | 1 | 2016-09-20 01:40 |
MC: Copy and Paste | Bryson | GamingNova | 49 | 2014-02-23 20:22 |
Copy & Paste, actually important? | Kraetos | General Discussion | 32 | 2008-07-18 10:32 |
10.4.3 F'ed up copy and paste | NeverFade | Genius Bar | 4 | 2005-11-08 09:18 |
Copy-Paste without formatting? | atomicbartbeans | Genius Bar | 2 | 2005-05-21 10:15 |