CarterUSM

Hi A colleague of mine is trying to delete some students who are currently on roll, from pre-admission groups in which they were erroneously input. She logged a ticket with the Bromcom helpdesk and received the following response: Thanks for contacting Bromcom support. It looks like these students are still sitting within modules>admin>finalise admissions. You will need to go through ALL of your admission groups and change the Action to 'Withdraw confirmation'>find the students>click on Update and then change the Action back to Confirm All and press Admit NOT Update. Check the admission date entered is correct also. https://docs.bromcom.com/knowledge-base/how-to-finalise-admissions/ This should then show them in on roll list only. We have both tried to follow these instructions, but I have not been able to proceed further, as per the attached. I am wary of proceeding further for fear of making irreversible errors. Would it be possible for someone to provide precise instructions as to how to do this? Just to reiterate – we only want to remove them from pre-admission groups, and not their current student record. Many thanks in anticipation. To remove students from pre-admission groups.pdf

Hi I am interested in the possibility of importing data directly into a Google Data sheet. The current training sheet https://docs.bromcom.com/knowledge-base/how-to-import-data-directly-into-a-google-sheet/ incorporates an excerpt from a Google Data sheet, which indicates that it is possible to access Script Editor via the Tools dropodown. However, this option is not available in my version of Google Sheets, as illustrated by the attached screenprint. Is there another route by which I can access Script Editor? Many thanks in anticipation of your assistance. Script Editor not appearing in Tools dropdown in Google Sheets.pdf

Hi We are trying to ascertain the most effective and efficient means of requesting information from parents/guardians of parents of prospective new students, and ensuring it is transferred onto Bromcom. At the moment, we ask them to complete a pupil admission form (PAF), the information from which has then to be input manually into Bromcom, which as you might imagine, is an incredibly time-consuming task. We are looking to automate the process as much as we possibly can. I have looked at the possibility of manual data export/import, but many of the required fields in our PAF do not correspond with the data fields in Bromcom. I understand it is possible to configure MCAS to enable parents/guardians of prospective new students to complete the relevant admission form online. Could someone point me in the right direction as to what needs to be done to set this up? Is there scope to perform trial runs using our bespoke admission form? For those who have gone down the MCAS route in trying to automate the admissions process – have you had any feedback from parents as to how user-friendly the process is? Many thanks in anticipation.

Hi I would like my weekly scheduled behaviour/attendance reports on Bromcom to return data for the most recent academic week only. For example, for the current week, I need this Friday’s report to return data from Mon 25th to Fri 29th only; for the following Friday’s report, I need it to return data from Mon 2nd Dec to Fri 6th Dec; and so on for each week. It is not clear (to me at any rate) which option I should select when it comes to selecting the start/end dates; am I right in thinking it should be ‘Relative to the Academic Week’? Many thanks in anticipation of your help. Query re scheduling reports date options.pdf

Hi Just to let you know I’ve resolved the issue. It was quite simple in the end, a process of trial and error. I removed the pedagogy wheel image, tabbed the positive/negative points image to where I wanted it to be at the bottom of page 1; and pasted the pedagogy wheel image back onto page 2. The merge works as intended now. Many thanks for your contributions with this issue.

Thanks for your reply, yes, I've been on Bromcommunity and have a few responses. Just trying to collate all responses at the moment.

Hi I am having problems in ensuring that a Word mail merge document is formatted in the way that I intend it to. I have never encountered these problems before in any Bromcom mail merge process. SLT want our student reports to go out as a double-sided document, with a so-called ‘pedagogy wheel’ illustration on the reverse page. The report incorporates a header which should only appear on the first page. In addition, fields containing both positive and negative behaviour points should appear at the bottom of the page. (The file should appear as the attached example ‘Example report KS3’.) The Word mail merge document I originally created (‘Y7 Autumn Term Review’, attached) originally had the header setting ‘Different First Page’. However, when I ran the merge, the header only appeared on the first page of the whole mail merge document (i.e. not on the first page of the individual student reports, other than the first student in the cohort). The fields containing positive and negative behaviour points did actually appear at the bottom of the page as required. The strange thing is that when I change the header settings from ‘Different First Page’ to ‘Different Odd & Even Pages’, the heading does not appear on any pages in the merge document. To try and overcome this, I cloned a new Word template (‘Y7 Autumn Term Review 2’, also attached), with the header setting as ‘Different Odd & Even Pages’. However, for some reason completely beyond my comprehension, I cannot get the positive and negative behaviour points to appear at the bottom of the page as required. I’ve tried adjusting the size/layout of the header (including the crest within), but to no avail. At least when I ran the merge, the heading appeared on alternate pages as required. I think the solution could be to reduce the margin of the footer, but it doesn’t appear to be able to do this. I’ve attached a file (‘Y7 Mail Merge Issue’) showing the steps I’ve taken to date. I will ultimately try and run the merge using ‘Y7 Autumn Term Review 2’, but I need to know how to adjust the appropriate settings to ensure that (i) the positive and negative behaviour points appear at the bottom of the page, (ii) the pedagogy wheel appears in its entirety on the reverse of the front page. Would anyone be able to assist me with this please? Very many thanks in anticipation of your assistance. Y7 Mail Merge issue.docx Example report KS3.docx Y7 Autumn Term Review.docx Y7 Autumn Term Review V2.docx

Hi, We have duplicated a new student in Bromcom in error. Is there a way to combine his two records, or does this have to be done manually? Many thanks in anticipation of your help.

Good morning Following the departure of a colleague at the end of the last AY, I have inherited elements of her role, including importing CTFs for new students. However, it's not clear to me which students already have CTFs imported, and which are still awaiting import. Is there an easy means of identifying those students for whom CTFs are still required? Many thanks in anticipation of your assistance.

I'm guessing there's no scope for doing this for KS3 students (the student in question has gone into our y8), in which case we'll presumably have to wait until she enters y10?

Thanks very much for clarifying this. Just as a matter of interest - how do you gain access to the override column of their KS2 prior attainment area? Many thanks in anticipation,

Hi I have just downloaded KS2 results for a student from the DfE GIAP site. It just so happens that the READSCORE, MATSCORE & GPSSCORE are all 3 higher than the READSCORE_noSpeccon, MATSCORE_noSpeccon & GPSSCORE_noSpeccon scores. I’ve never encountered a case where the ‘normal’ scores differ from the ‘noSpeccon’ scores. How do I know which ones to import into our MIS? Many thanks in anticipation of your help.

Thank you for your prompt reply. I've just checked the permissions allocated to the Support Officer role under Framework (as per the attached file), and unfortunately there is no permission to add a new record/edit/delete - only to Access or Save. Would those rights for the 'Health Background' area be available under another module, perhaps? Is there an easy means (a report, perhaps) which enables me to identify under which modules where it's possible to add a new record/edit/delete for a particular permission? (obviously in this case, I'd be interested in all of the 'Health Background' permissions.) Once again, many thanks in anticipation of your help. Support Officer - Framework permissions.docx

Hi I have been asked to give a member of teaching staff the capability to modify Medical Information and User Defined fields on Bromcom. This is due to her role as Mobility Officer and dealing with Health Care Plans. At the moment, her only assigned role on Bromcom is as ‘Teacher’. Would anyone be able to advise which role she will need to be assigned, in order to enable her to perform the above tasks? Please could you also confirm the permissions within each module attached to the role which need to be amended (e.g. would it be relevant to amend any of the permissions listed under the ‘Framework’ module within the ‘Safeguarding User’ role?). Query re amending permissions re health.docxMany thanks in anticipation of your assistance.

Hi Is it possible to create any kind of report within Bromcom whereby a mail merged letter with personalised data (in this case, y10 option choices) is sent to a certain cohort of people (i.e. in this case, the parents of current y9 students)? In addition to sending out hard copies of the letters, our SLT would like electronic copies to be sent. But short of laboriously creating single documents for each y9 student, then attaching them manually to 40-odd emails, I don’t currently know any other way of sending them electronically. Many thanks in anticipation of your assistance.