pubgrub277

Ive been working on student and class profiles for a number of years now. I use command reporter to run reports from sims to gather all the data (as xml outputs), (student basic info, sen,fsm, attendance, behavior and assessment). Then use excel templates to create a set of profile sheets for staff. Staff have been very receptive to them and find them useful, rather than looking solely at lists of information in assessment manager for example. I'm confident that any information can be added into these templates to suit the needs of other schools. Im thinking of creating a standard template and set of reports for sims, would anyone be interested in trialing it on another site?

We were once upon a time partnered with Time computers........

I'm wanting a report to show me details of documents linked to students in the DMS. I cant for the life of me find the right fields. If it can be done i would like: Document name, Date added. Anyone have any ideas?

also, i think duration is calculated after the creation of an item using start and end, so i don't think you can declare "duration" in the way you'd want to.

Hi A10, Welcome to the forum. This was an initial proof of concept to run a basic report in Sims and transfer it to outlook. It is total customizable and doesn't have to rely on the timetable view specified. thinking about this a little more an easier way would be to use a report like this.Report:Room-Lessons.zip sample output: Example of room report.xlsx If you have your timetable and rooms set-up like ours you can get the room, start and end time of each lesson. This output could then be used to generate you outlook appointments much easier as their would be no blanks to skip. A two week timetable would need a little more complexity in how you define the dates for an appointment but should be do-able.

This website has a wonderful tool to do cover analysis using reports from sims. Absence & Cover Analysis « Weird & Wonderful IT

not as far as i'm aware. i have asked the question before but didn't get anywhere.

The Farce is strong with this one....

sorry, just seen the sticky at the top. Can one of the mods delete this thread please. sorry about that

Anyone run the update yet? Never want to be the first. :-)

i created my new year this morning, before reading any of this. We are a "normal"* school, normal week etc and seems fine if that helps anyone. * what is normal?

i've created this as a proof of concept.Create Outlook Timetable.zip just to see if i could do it really. Paste a staff timetable (or room i suppose) from the standard Sims timetable reports into the sheet (a1:f19). Run the "Makeweek" Macro and hey presto, from the 06/02/2012 the timetable appears in the outlook calender as appointments for one week (this could easily be looped for half term/term/year). The code doesn't have any notation yet but i'm adding that shortly. This will only work for my timetable cycle and not everyone's but you could amend the blue table to suit your times of day. The key really is the coding for creating the outlook items: With CreateObject("Outlook.Application").createitem(1) .Subject = .Location = .Start = .End = .Save Making each of the parameters dynamic for dates/periods is the problem, and depending on how you produce the timetable or report is key. I'm trying to create a report in sims now that will give me something easier to work with.

Yeah, that's a change that would dramatically improve the use of the log. I have to insist that staff ensure they link it to the student (rather than just a parent for that very reason) so that we can always find the correct records.

My attendance office are saying that the predefined report in sims (Reports> Lesson Monitor> Whole Group Reports > Persistent Absence Report) is wrong. Currently it shows in term two that students with 27+ absences should be PA. They claim it should be 20. I don't usually have anything to do with this side of attendance so don't know what the correct details should be. Can anyone shed any light on this for me please. Attached is the column heading in question.

We use it. Find it quite helpful to follow up actions and get a complete idea of what events have happened with students. Ideally staff log a BMR, action a followup, inform parents, complete the log. Then we can track it all.

if you enter the behaviour report through Focus> Behaviour management > Maintain Behaviour Incidents and then create New (using the button at the top). This means you can write the report, assign the type/number of points etc. then add any number of students you want to the report, Box 3 i think. Much easier than creating several separate ones for individual students.

we use a text message system for first day absence calls. Got a reply on friday that made me smile followed quickly by if only every parent was so supportive.

Stuart i do something similar with .Xml. All my reports now produce xml be default and these in turn are interpreted by excel templates to produce the output/visual view i want. The big advantage then is being able to use command line reporter to automate when the reports run.

thanks for the suggestion. makes a lot of sense, i just want one number consistent throughout. I don't care what it is and as i cant change the defined reports (which sometimes are quicker to run than creating a new user defined one). How many unique ID's do we have for students now? Person ID, UPn, ULN, Admission number, cashless number, username..... in the mean time till i change my reports over at least i can do a look up for all the numbers now.

Thanks David, You were spot on. that will make life a little easier now.

When i run some predefined reports (attendance in this case), and export the data as XML the students are identified with a field "PersonIDAttribute". This appears to be a unique reference for each student (im assuming that its referenced in the SQL tables somewhere) I want to match up this field to admission number (this is the reference for all my other data exports from assessment and user defined reports.) Does anyone know where i can match the fields up? i cant find it as a field in reporting anywhere.

Excel Help Forum is a useful link for asking excel related questions.

We've recently started using the report cards in sims, linking together all our behaviour systems into sims (some data records were still being done in various paper forms.) We've been using them for students who are on report in all lessons but does anyone know if you can just put a student on a department report card ie. the report card is only visible for English lessons? Haven't seen an option for it on the set-up or generate parts.

My big worry is along the lines of The systems provides no functionality to comply with legislation.

its not so much identifying them @vikpaw. its deleting them. Legaly im not 100% sure where we stand. Some of the data, particularly held about staff, we dont have any right till still have as far as im aware.