Newbie trying to get data out of SIMS
Hi, folks. Thanks for reading - please be patient with the gallons of ignorance that drench this post: I've no knowledge of SIMS except that it uses a SQL server back end and we use it at our secondary school.
I'm a governor and I'm working with the DHT on a project to get homework and detention data (initially) entered into SIMS and be able to report on it - ideally by individual email. From my limited understanding of the product, we'd need to have the "Learning Gateway" module installed, which we simply can't afford, hence this little project.
Is it possible to record homework data for a class on the core product (I found detentions, not homework, on the website), and then extract it per student using a self-developed app or by stripping the data from a report? I gather that Capita are secretive about their data structure, so trying to find the data by looking in the tables is going to be difficult. Add to that their habit of moving things around, it's likely the report option is the only option - but if the fields aren't available I'll need to think of another method.
Thanks again for any insight you might be able to offer.