Seb1780

Thank you far your responses, there is a lot to consider and it concerns me that so many people I deal with have no idea, or have not given any consideration to, data protection. In no way was I trying to wriggle out of our responsibilities, I accept that we play a major role in all this. My thinking (and I'm happy to be proven wrong) is that they are generating and processing data; they are recording spend and processing the collection of money and they are reporting to parents about how the child is spending that money. I accept that any agreement with parents and pupils may come from the school, but it will have to name the other companies involved. And I want to make sure any data we provide is managed in an approriate manner; a blase "not my problem, pal" attitude won't cut it. We've made some progress, and we now have a flow chart showing the data processes (ish) - I've attached it for those that are interested. FasTrak Insatlltion Flow.pdf

We're trying to sort out what data obligation each party has in a proposed Cashless Catering system. Our setup is a little unusual because our catering in provided by a third party (ex-LA spin off) and it's not the school who are implementing this. The catering company has identified BioStore / Fastrack as their preferred supplier. During initial discussions we've raised the question of Data Protection and are trying to establish what the data flow is and who is the data controller at each stage. Neither the catering company nor Biostore have responded satisfactorily, in my opinion. The catering company have said "there are no data protection issues because it's all on site" and BioStore have said "it's all in your MIS so it's your responsibility". The catering company had not heard of GDPR. Has anyone else set up a similar system? If so, what are your arrangements for DP? As I see it, we will provide access to our MIS to enable Biostore to collect names, photos and other information to use in their system. That system, based on a server located in the school but not owned by us, will provide data to the POS equipment and collect data from it. It will also link in to an existing, school funded online payment system. I would imagine, at the least, that Biostore have some DP obligations regarding their system and the links to the MIS and payment system just like any other third party do. I would also expect the catering company to have DP obligations regarding access to the POS eqipment and controlling cards etc. I expect both these parties to have DP obligations to the parents wrt the collection of monies and feedback on what the children have eaten. I also expect both parties to have a DP obligation to the children wrt telling their parents what they've had for lunch, and that this obligation would include getting explicit permission from all those 13 and over when the new legislation based on GDPR come into force. That's a lot of expectation; am I expecting too much?

Added a couple, most of ours are already there.

Some from my holiday

I'd use "Paste as Values" to copy from the database or from an export from it.

I get them from Key 2 Success in early July - just need the UPN from the application file.

Do this whenever you like, it links the timetable to the calendar and allows anything that needs a given date to work, the timeline for instance. I don't know of an issue with applying this "too early"; I do mine as soon as the timetabler has sent across the first version.

Have you applied the timetable (Tools / Academic Management / Apply Timetable)?

Reports / Student Lists / Class Lists Change the "Effective Date" to some time next year - the press "Search" Bingo

I've knocked this together to get us started, based on @DavePa and @TechMonkey suggestions. Data Audit Log.xlsx

Their Attainment will count, but in the absence of any KS2 data there will be no Progress; we have a handful of these every year - they are a mixed blessing :-)

One of our SLT has recieved this from Groupcall, neither I (Data Manager) nor our Network Manager have. Has anyone else seen this? Is this really happening that people are calling saying they are Groupcall?

You can identifiy the teachers involved using the "Staffs Involved" options, but beware that these reflect who recorded the behaviour points issued, not necessarily the teacher issuing them - a real problem in our school.

"The weather looks good for our camping trip this weekend"

Pivot tables with filters applied will do this.

No downloads though, so you can't play about with the data offline.

I can't see it yet; when is it supposed to be live?

LOL Maybe I'm just an old git, the first single I bought (from Woolies) was Anarchy in the UK - so it's no surprise that I can't appreciate a good singing voice

Who cares?

INDEX / MATCH is your friend here There's a good instruction here https://www.deskbright.com/excel/using-index-match/

Oy cheeky! I was just making the point that changes in the world do not necessarilly get reflected in new coinage.

Probably not, in my youth pennies with Queen Victoria on them were still legal tender!

Cards on the table - in my previous existance I ran my own business installing kitchens & bathrooms. I did electrical work and was qualified to undertake that work. My qualification is lapsed, as I'm no longer working in that arena, but I believe the advice below is still viable. To an extent it is correct that if the wiring was compliant at the time of installation and no additional work has been carried out then there is no need to change things just for the sake of bringing it "up to date". Provided the cabling is secure and not degraded, the protective devices still work and the whole installation is safe being old is not a case for renewal. In fact for most domestic premises there is not even a requirement in the Wiring Regulations that they are inspected, although the NICEIC recommends every 10 years for owner-occupied and every 5 years for rented properties. Any work required as a result of an inspection should be based on the safety of the installation, not its age. However, with a few exceptions, once any work is done on a circuit, or any additional circuits are installed, then the whole of that circuit has to be compliant with current regs. The "whole of the circuit" means from the feed from the meter to the point of use and includes things like consumer units (fuseboards), safety devices (fuses, RCD, RCBO), cabling, switches etc etc etc. The magnitude of the additional work required has been escalating in the past decade due to things like new wiring colours, the requirement (in most cases) to use RCDs rather than fuses and, most recently, the need for all consumer units to be fireproof. Thus, a simple decision to move a socket may trigger a complete rewire of the house because the circuit will have to be extended because new sockets have to be at a certain height, and placed on an RCD, and that RCD housed in a fireproof consumer unit, which must now be placed in an "accessible location", with meter tails that have sufficient capacity, and a new earthing circuit to match the new load, and on and on and on. Any decent sparky will explain all the work and why it's needed. If you think you are being ripped off get a second or third quote, or seek the input of one of the trade bodies (NICIEC was my trade body). It is expensive to gain and maintain the skills and qualifications needed to do this work and given the potential for harm if things go wrong I believe the prices they charge are reasonable. But, if you are competant and capable of using the testing equipment (and being able to afford the £1000 it costs to buy it), you can do the work yourself then get the local council to certify it. But would you take that risk? Finally, there is a big difference between Wiring Regulations and Part-P. The requirements for electrical wiring are laid out in BS 7671 Requirements for Electrical Installations 17th edition Amendment 3. These requirements apply to all fixed electrical wiring installations anywhere; schools, homes, offices, factories etc. Part-P of the building regulations requires that any new or modified installation meets the requirements of BS7671 and sets out what modification will trigger notification and certification requirements. But even if you do not have to notifiy and certifiy, all work must meet the requirements of BS7671.

Deputy ICT Manager » Northgate High School This is the school I work in, if you want to know about the place please feel free to PM me. I'm not involved in the recruitment or line managing as I am an 'umble Data Manager