asteer

Has the person had a formal assessment. If so I would have expected them to have had a written report giving them tips/guidance on strategies or tools to implement. I had my assessment 17 years ago, but I got a report that can be used, if i need to, to help support my specific needs. Though in all fareness I would have thought any occupational help/HR provider would be able to do this kind of thing

Thanks for that, just tried that and it does work as you have mentioned. This might help to make the pronoun visable when viewing the student record. I still think reprots will be a nightmare,, but we will just have to do them on a case by case basis

If its got wooden floorboards its likely then got spacers underneather and airbricks on the outside of the house for ventilation. The fact you said that the plaster when you took off the boards was powder, makes me think it was affected by damp. The bricks do look a darker colour than you would expect for a 'dry' wall. https://www.ecologicalbuildingsystems.com/post/best-practice-approach-insulating-suspended-timber-floors I would go with wooden spacers and not filling in the gap, as there must have been a reason why the plaster had turned to powder

Is this a ground floor? and what is the floor under the wood laminate? It may be best to leave the gap and put any new skirting board over it. You do not want to plaster all the way to the floor as this could bridge your damp proof (if its a ground floor) and cause issues further down the line (moisture in a floor would "jump" the bridged gap and cause damp issues on the wall). We had a damp issue in our front room (caused by debris behind a fireplace and bridging plaster) that due to covid and material shortages has taken over 3 years to get sorted.

If you/partner/someone you know works for a blue light service (plus some other random services), you can get a memebership for the company shop. You can also go with a member and be their +1. Though whenever Ive gone ive just bought kilo bags of sweets, which probably isnt good. https://www.companyshopgroup.co.uk/profile/freemembership

We have been asked if we can record the pronouns for our LGBTQ+ students in our SIMS system. I know we can create a UDF filed to allow thsi to be recorded, but on the studetn records its right at the bottom, and im not sure of the viability of adding it to reports/registers and marksheets (mainly having to go through every single one and adding it) Does anyone else record pronouns of students in their SIMS systems and also display it on registers, reports and marksheets?

Ive been making "packlunch" for work for several years now, Im also on slimming world so the meals are also healthy as well as being cost effective as we make 10 lunchs a week, bacth cooking on a Sunday. Some stuff Ive made is Tuna Pasta - Tuna, Sweetcorn, Leeks, Pasta with Greek Fat free yogurt and Quark as the "sauce" with Aromat for flavouring Veggie Pasta - Pasta, Peppers, Green Beans, Aubergine, Courgette, Passata, herbs and spices Orzo Pork - Orzo Pasta , Pork loin steak (fat removed), Cherry tomatoes, cucumber, beetroot with a bit of whitewine vinegar and mint for flavour Tikka Turkey and Rice - Turkey marinated in (Curry Powder, Ginger, Garlic, Lemon Juice), wild rice, cherry tomatoes, cucumber with mint and lemon juice to loosen it up (also meant to be served with a mint tzatziki, but dont do that for work) The Tikka Turkey and Rice is this weeks meals, though the prices of Turkey has gone up quite a bit as it used to be a "cheaper" meat. Most of the meat elements could be replaced with a meat substitute with no detrement really

Not a drone person myself, but the drone in image 4 and 5 looks like a DJI Flame Wheel F550 - a basic kit seems to retail about £230, depending on the extras it looks like they sell (new) for a bit more - https://www.buildyourowndrone.co.uk/dji-f550-flame-wheel-e305-artf-v2[h=1][/h]

https://www.dudley.gov.uk/news/dark-fibre-sees-the-light-of-day-in-dudley/ Dudley council are doing it for their own network. They are renting the line from Virgin, but it seems in your case that there will be a dedicated fibre line between yourself and the LA. The LA would decide the speeds that you get but in theory the max could be whatever a fibre line can take (in theory 2/3 the speed of light). Leasing for 25 years locks you in for a long time. I suppose in that time everyone else could improve their speeds, so its really if you want to take the risk

Dark fibre is pretty much a point to point dedicated fibre line. Its not "managed" by anyone so you have to have your own company/equipment to "light" the fibre, no one else would use it other than yourself

Finally, able to find proof that my house wasn’t bombed flat in WW2 from this (Rumour on the street is that a block of houses, including mine were bomb damaged (they were bombed and people next door died) and had to be demolished), an aerial picture from 1950 shows the house intact (though houses at the end of the street are gone. So dont think they will have re built the house exactly as it was in 5 years

It looks like I will need to go into one of the Secondary schools in our MAT and help support them with their SIMS system. This is due to staff loss/ability/knowledge of current staff. Im trying to come up with a bulletpoint list of things to check as a starter and Im just looking for any suggestions on the top things to check.

Cheers for that, I've been through the Scholarpack attendance reports and while they work fine internally for a school, I cannot find anything that easily gives me a flat file format for any period over 30 days that will allow me to extract the information for further analysis. Scholarpack do offer a MAT version of the system, but it will have a cost so I want to see what I can engineer first (I'm a big fan of the KISS principle (Keep it Simple, Stupid)) Back to the origional post @Leia, what is the format of the Bromcom spreadsheets that you need to use. Ive been sucessfull* in taking a report from Scholarpack and then converting it into a format that is semi-reasonable for further data translation The extract comes out of Scholarpack like the below. [TABLE=class: grid, width: 500] [TR] [TD]First Name[/TD] [TD]Surname[/TD] [TD]Year[/TD] [TD]01/02/2022[/TD] [TD]02/02/2022[/TD] [TD]03/02/2022[/TD] [/TR] [TR] [TD]Test[/TD] [TD]Student[/TD] [TD]3[/TD] [TD]/\[/TD] [TD]/\[/TD] [TD]/\[/TD] [/TR] [TR] [TD]Bob[/TD] [TD]Smith[/TD] [TD]3[/TD] [TD]/\[/TD] [TD]L\[/TD] [TD]M\[/TD] [/TR] [/TABLE] I then use an ArrayFormula with Flatten and Split functions in Google Sheets to format the above data as the below [TABLE=class: grid, width: 500] [TR] [TD]Name[/TD] [TD]Date[/TD] [TD]Period[/TD] [TD]Mark[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]01/02/2022[/TD] [TD]AM[/TD] [TD]/[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]01/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]02/02/2022[/TD] [TD]AM[/TD] [TD]/[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]02/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]03/02/2022[/TD] [TD]AM[/TD] [TD]/[/TD] [/TR] [TR] [TD]Test Student[/TD] [TD]03/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]01/02/2022[/TD] [TD]AM[/TD] [TD]/[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]01/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]02/02/2022[/TD] [TD]AM[/TD] [TD]L[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]02/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]03/02/2022[/TD] [TD]AM[/TD] [TD]M[/TD] [/TR] [TR] [TD]Bob Smith[/TD] [TD]03/02/2022[/TD] [TD]PM[/TD] [TD]\[/TD] [/TR] [/TABLE] A couple of caveats on this: I can only find a report that runs for a 30 day period, so if you want a couple of years worth of data, you have to re-run this report for multiple 30 day periods in the bigger timescale You need to have a another extract of student information to allow you to create the concatenated student name (the actual data im using will use either the UPN or the primary id within Scholarpack to do the matching) The code has been bashed together by me from a couple of sources, with additional support from some "random" person on Stackoverflow so may have some unintended consequences. Ive desinged this in Google Sheets as I have plans further down the line to use the data, in could be done in Excel, but the code would need reverse enginerring If you need any help with this, let me know *I got about 99% of the way there and then someone of Stackoverflow helped me the rest of the way - https://stackoverflow.com/q/71323530/9606612

As an aside, the elements of number:number works for values that arent even valid times i.e. 56:15 will return a automatic value of 02/01/1900 08:15:00 The number value for a date/time is based on a sequential element from 01/01/1900 which has a number of 1, while 02/01/1900 has a number of 2. Today (02/03/2022) has a number of 44622, so is forty four thousand sixhundred and twenty two days after 01/01/1900, but there is an error with this if you try and calculate dates back. There is an known bug in the calculation that dates after 28th Feb 1900 are one day out, this is because the Microsoft date format was designed to be compatable with Lotus 1-2-3, and the Lotus 1-2-3 programmers through that 1900 was a leap year, which it wasent, so 29/02/1900 is number value of 60. So while today (02/03/2022) is shown in excel as 44622, it should actually be 44621 When you do a date calucation in excel, all it does is convert the dates to numbers and then calculates it that way and then formats the number as a date i.e. today plus 5 days is 44622+5 = 44627 formatted as a date

Its not the colon itsself that causes the issue, but how excel is interpreting the entire element that your wanting to use the substitute on. Using your substitute formula on test:test to get test.test would work perfectly fine. The issue is excel thinks that any element that is a two digit number, a colon, then a two digit number is a time. While we as humans can say it looks like a time, but it isnt a time, excel can only say it looks like a time, so it is a time.

The format of the orgional data is probably being taken by excel to be a time format (excel probably thinks that the 15:08 is actual 8 minutes past 3pm). All times are actually stored as a decimal number within excel so when you are doing the substitute its converting it back to a decimal number You can change the format of column C to be text (but this will bugger the format up), so you will need a formula like the below =CONCATENATE(LEFT(TEXT(C3,"hh:mm"),2),".",RIGHT(TEXT(C3,"hh:mm"),2)) This converts the cell value to text then concatenates the two elements up with a full stop in the middle

It’s probably blowing my own trumpet, but I’ve been an SQL report developer for 15 years (using raw SQL as well as proprietary reporting solutions), so I personally feel confident I can get the data I need (I'm a data person, not an IT person (I’ve got the quals, just went down the database route, not the cable bashing/hardware route) - do I need to hand my edugeek card in for not being an "IT" techie I’ve seen some really bad scheme in my time (UNIT 4 QLS at HE was a nightmare), but as I spend every day looking at the data I can normally understand the scheme after a while. I feel that statutory education (Primary and Secondary) software providers really don't like you looking at the DB, but having worked at FE and HE I can tell you the opposite is true there, most suppliers loved us doing this, and sometimes even supported us/expected us to do it. I can see why the statutory sector wouldn't want it done, with schools traditionally only having the "tech support" onsite for that school, no-one would want the office admin who has no idea of data integrity and security to be accessing the DB directly. But with the move to MAT’s and more centralisation I think this view is very old fashioned, if a central team has the ability to do this kind of work, it should be empowered to do it. With cloud based systems that are not properly designed, if I cannot even get a flat file CSV/API integration into common tools (i.e. not tools that run on a cloud based subscription model), I don’t think it’s really worth it. You have to look at a system as a whole, it could have all the bells and whistles at the front end, but if I cannot analyse the data whats the point. If an organisation, such as a MAT, functions very much like a mini local authority/Further Education College/University (who would all have access/tools and people to do this), it should act like one. Also if the DB is on prem, I will do what I want with it, as long as I take regular backups and add views and tables to a linked server and not to the production DB I see no problem with it.

While Im not looking at a transfer of data from Scholarpack to another MIS, I am looking at getting attendance out of our 7 Scholarpack schools for some central MAT analysis, and I can say that the inbuilt reporting in the system is a dogs dinner. Ive only looked at the reports so far and not the data extracts (CTF, B2B ect) but I cannot find an easy way to get a flat file of a students attendance. The best I can do is using the Official register report to extract a file that only allows a 30 day time period and im currently looking at transforming this into a format that will be useable for further analysis. It might be something the school needs to go to scholarpack about to see if they can do it straight from the DB. This is one of the reasons I hate cloud based systems, while from a "core IT" persepctive, it gives gains on security, backup, access ect. From a data point of view ive never come across a good system. They make access to the data hard to get to, and give you reporting solutions that are subpar compared to what else is out there. I know cloud is the way forward, but give me an on-prem DB server anyday

This site is probably best for guidance -https://www.pettyson.co.uk/about-us/our-blog/775-which-fence-am-i-responsible-for Boundary ownership can have a lot of old wife tales and unwitten rules said about them which confuses the matter (some fo these have been mentioned in this topic)

The email (of the 25th) came from the DFE and went to anyone signed up to the Covid-19 government reponse email, whihc you have to signup to via the following form https://forms.office.com/Pages/ResponsePage.aspx?id=yXfS-grGoU2187O4s0qC-QqN_lFznWdElvOZAsgLa61UMlVaSEZWQVA3RDE1VU05SlVOQVFDNVlINy4u

Has the LA recently had an LA children services ofsted inspection? My Local LA (were I used to work and manage the B2B system from the LAside), got slammed in an ofsted inspection, where it was raised they didnt know the details of all the children in the la (as they left B2B to rot once I left and didnt maintain it) Our schools have had a couple fo emails recently from the LA saying - give us your data and lets restart B2B, its all a bit ham fisted and some of the emails dont make much sense, i need to do a bit more of a concedered reply back to the LA to ask them what the actual impact will be (at the moment it all reads give us your info and there wont be any issues for you, having run b2b for 7 years I know thats not the case) but until I do that im just letting them stew

I dont wish to assume anyones gender but the CMA website currently says that the senior director Anti-Trust is called Ann Pope who I would have to assume may identify as female, but you said you spoke to "him" https://www.gov.uk/government/publications/cma-structure/cma-structure-chart-as-at-march-2019

Policy has always been predicated on Hospital admissions/capacity and deaths. In early spikes there was a link between infections and deaths, with infection rates impacting deaths around two weeks later. With the recent spikes, while there has been an increase in deaths it is nowhere as large as that from the first wave, and dosent really track as clear. COVID is a disease that we will have for us with the rest of our natural lives, we won't eradicate it (we have only eradicated one disease in history (smallpox) and even a disease such as measles which has a high R rate and can be very serious, had its vaccine approved in 1963 and we havent eradicated it). The main figures to look at are the number of deaths above the normal 5 year average, its also worthwhile looking at the deaths of people WITH COVID against the number of people who die FROM covid. These are two seperate figures. If for example you had covid and recovered, but then die in a car crash 27 days later you go into the covid stats. At somepoint we will need to stop the daily reporting of covid deaths as it starts to not mean anything. We had 1,223 people die of flu in 2019, and we experiance a large number of flu deaths per year, but other than the ONS stats we dont normally report this wider unless it is excessive (https://www.ons.gov.uk/aboutus/transparencyandgovernance/freedomofinformationfoi/influenzadeathsin20182019and2020)

You can do either of these, but official guidance is: On Wednesday 15 December the coronavirus (COVID-19) rules on attending certain venues and events in England are changing. From this date, to enter those venues and events, people aged 18 or above must either: be fully vaccinated with 2 doses of an approved vaccine (or one of the single-dose Janssen vaccine) have completed a negative PCR test or negative rapid lateral flow test within the past 48 hours, or be exempt https://www.gov.uk/guidance/prove-your-coronavirus-covid-19-status-to-work-at-venues-or-events-operating-covid-19-status-checks

I have been reporting negative LFT's as I have needed them for medical appoitments to prove that I dont have covid. A negative LFT can count as your covid passport if you need to go to an event etc