Seb1780

I'm sensing a change in the expectations here - for years we kept a list of who was at Alt Provision, marked them as a D and occasionally made contact to check on their progress and attendance. Now we are talking about a sub-register, daily contact with the Alt Provision and weekly reports from their MIS to show attendance.

The current code of practice clearly states the attendance should only be recorded at the school the child is expected to attend, but schools should communicate to ensure unexplained absences are investigated. School_attendance_July_2019.pdf

OK - attached is a worked example Col A is just labels showing five dummy stages of a project Col B is start date and Col C is end date of each stage - the conditional format refers to these columns Row 1 just has dates in sequence, just like your fancy scrolling calendar In the range E2..BM6 there are 5 conditional formatting statements, one for each stage. I've seperated them out into rows to help you get the idea of what is going on, but this could easily be all in one row (for me, a Gantt chart is one row per project stage as I've set it out.) HTH For Featured_Spectre.xlsx

Not IF statements - you just need conditional formatting - seven different rules to colour according to the dates. If I get chance I'll look again later, but I cannot promise.

Yes, so long as the cells in row 8 & 9 do not scroll and just the date scrolls at the top, then the conditional formatting would update as the dates moved and the cells would change colour.

You could conditionally format the rows - something along the lines of If the date associated with a cell >= start date of stage AND If the date associated with a cell <= end date of a stage THEN Fill cell in with appropriate colour

Manual entry, I'm afraid. You could bulk update everyone to present, then change the marks for the absentees to cut down on the work, but there's still a lot of work to do. #askmehowiknow

Hi, Yes, it is just a double check for you to ensure they are on resit courses. When you upload to COLLECT it will not show as a query. It is worth checking and re-checking as any student who should be on a resit course should be or you will lose funding.

Confirmed, our one BTEC course was not present in the results. Still, the P8 score was good

I think the latest fileset (1304) fixes this.

Yep, I just changed the one on the mapped drive. Maybe you have a different problem?

I changed the one on the server.

Hi, try the suggestion in this thread http://www.edugeek.net/forums/mis-systems/201014-sims-reports-excel-2016-a.html

@bobsmith - have you seen this topic on the Capita forum? https://myaccount.capita-cs.co.uk/forums/thread/SIMS-technicalkk-last/428c35c8-4daa-e911-80fc-000d3a264101

I still see nothing that is personal data. Yes, you can (by inference) identify four people but the e-mail contains nothing that is personal about those people. Knowing that Mr X is a teacher at School Y is *not* personal data - this is information that is in the public domain (often on our websites!). Knowing that Steve, Mike, Dave and Pete are having a meeting is *not* personal data - people in work situation have meetings - fact. If, on the other hand, the e-mail had discussed the fact that Mike was bringing some samples of work to demonstrate why he should not be disciplined for poor performance, then that *would* be personal data. Context is everything, and in the context you have presented there is no personal data that is not already in the public domain.

What personal data does it contain?

They didn't specify the year 8/6/2020 is a Monday!

+1 for the Craig Tolley link Also, the Impact Summaries straight out of SIMS are used to good effect here.

Ressurecting the dead! Has anyone implemented this and is willing to do a show & tell? Preferably in the East Anglia region. Thanks

FTFY

Yep, it's got to be good data in SIMS first. The formula will only find the first space, you could cascade it to split all components of the name but you would not know which was part of the surname and which was part of the forename. For us the number of double barrelled surnames is small, and the number without hyphens are smaller still. A year group of 250+ kids might need manual intervention for two or three pupils. I can live with this

If column A contains SURNAME Forename I use the FIND() function to locate the space and then:- In column B =PROPER(LEFT(A2,FIND(" ",A2)-1)) In column C =RIGHT(A2,LEN(A2)-FIND(" ",A2))

Hosted by Danny Baker?

I'd like to see that too; there's a lot of "you must" statements in this thread with no backup or justification. What one person has been told to do in one establishment is not necessarily the law!

This is a job for a lookup table - define your table with grade boundaries (0=U, 9=E, 16=D etc) then use vlookup(cell with value,grade table range,2,true)