Hero image

228Uploads

560k+Views

1393k+Downloads

Head of Year/College Central Spreadsheet
streetno9streetno9

Head of Year/College Central Spreadsheet

(0)
I designed this spreadsheet to track a bunch of the elements I needed to keep an eye on within the Head of Year role. Remember, hide the columns you don’t need and write comments to keep a fuller track of details. A watered-down version of each area is available to see on the top sheet. Also, you can add/modify the menus The areas are as follows: CONTACT TRACKER: Designed to keep track of meetings and phone calls from class room teacher all the way up to governors. TARGET TRACKER: Similar to contact tracker but it allows for you to track a set of targets. I’d log the target in a comment and then enter a new target should I need to do so. OUTSIDE AGENCIES TRACKER: The original reason I set the spreadsheet up. Allows for you to see who has interactions with an agency (e.g. Early Help) and track your contact with them. BULLYING/INCIDENT TRACKER: Accounts for identification of incident, investigation and follow up. You can then log the action. TOILET/TIME OUT PASS TRACKER: Allows for you to monitor when a pass was set up and keep a check of how frequent it is used. You’ll need to copy some of the sections to expand. Not a spreadsheet for the faint hearted, but you’ll only ever need THIS spreadsheet. EDIT: Hello. I’ve included an updated version of this spreadsheet. I’ve used it over the year and, whilst I have found it to be REALLY useful, there were some issues with ordering things and the information becoming corrupt. So, I’ve made a new one that uses the students admission numbers as a starting point. The spreadsheet offers the same features as the one above, but with the following additions: YEAR TRACKER: Tells you clearly how many FSM, PP, Early Help, CIN and many other categories of students you have in one go. PASTORAL TRACKER: Allows you to track form issues, social issues and a variety of other elements. My intention is to make the spreadsheet available to my Year Team so they can check in on the status of their form members. More importantly, you can re-order things and it won’t screw up the data. The spreadsheet is designed to import information from Bromcom on the initial entry page, but it’s easy enough to fill in using other starting points.
AQA Power and Conflict Poetry True or False Statement Generator
streetno9streetno9

AQA Power and Conflict Poetry True or False Statement Generator

(0)
A useful little resource that can be a starter/plenary element in your lessons. The spreadsheet generates ten randomly selected true or false statements from a bank of over 260. Each of the power and conflict poems is covered and there is the scope for you to add in your own or edit the statements that are there. I released this to my year 11s as a revision tool and they found it very useful. Additionally, I have included a blank copy of the spreadsheet so you can create your own ToF statement generator.
Universal True or False Spreadsheet/Worksheet Generator
streetno9streetno9

Universal True or False Spreadsheet/Worksheet Generator

(0)
An easy to use spreadsheet where you build a bank of true or false statements (tab 3) which will then create a randomly generated worksheet of ten true or false statements (tab 1). Additionally, an answer sheet will be generated too (tab 2) allowing for the resource to be used in a whole class setting. All you need to do is populate the spreadsheet with true/false statements and then identify which statements are true, and which are false. Instructions are built into the spreadsheet itself.
KS3: Born a Crime - Structure Focus
streetno9streetno9

KS3: Born a Crime - Structure Focus

(0)
A lesson take from a collaborative scheme of work. The lesson focuses on the quite excellent Born A Crime by Trevor Noah. The focus is developing an initial understanding of South Africa, then Trevor Noah himself, before focusing in on the context surrounding the story itself. After, the focus switches to analysing the structural choices made in the extract. Additionally, I’ve included a useful little follow up lesson where the focus ins to build a piece of creative writing that follows a specific structural path.
KS3: As You Like It - GCSE Focused SoW
streetno9streetno9

KS3: As You Like It - GCSE Focused SoW

(0)
To make effective use of this scheme I suggest you have a copy of the most recent RSC version of As You Like It (It is quite marvelous…) else a lot of the images I use will make little sense. There are five “lessons” that each last around the two hour mark. Each of the assessments is available, so the whole package is a self-contained unit of work. We had a lot of fun with this unit, and I inter-spaced the learning with periods where the class would act out elements of the play. You don’t necessarily need a copy of the play to teach this unit either.
KS3: Murder on The Orient Express Language Task - Method Focus
streetno9streetno9

KS3: Murder on The Orient Express Language Task - Method Focus

(0)
Using a format that proved successful in the KS4 arena, I’ve adapted the thinking to apply to an AQA English Language P1 Q2/P2 Q3 style task that would fit for a higher ability top set KS3 class. The approach is to initially read the extract then to specifically identify concepts that relate to a language focused task, followed be explicitly identifying language based methods and incorporating into a response.
AQA English Literature: Romeo and Juliet Method Focus Essay Builder
streetno9streetno9

AQA English Literature: Romeo and Juliet Method Focus Essay Builder

(0)
Similar to a lesson I posted on A Christmas Carol. After a bit of a warm-up, the crux of the lesson is focused on establishing concepts then explicitly showing students HOW to identify methods - again, some still confuse quotations and methods - before pointing them at an exam question. UPDATE: I repeated this lesson a few weeks later with a different extract, but backing off a notch in terms of explicitly identifying methods.
AQA English Literature: A Christmas Carol Method Focus Essay Builder
streetno9streetno9

AQA English Literature: A Christmas Carol Method Focus Essay Builder

(0)
My year 11s were STILL struggling with how to frame a method, so I came up with this stand alone lesson. The idea is that, having reviewed the slide where the methods are explicitly identified, the students will see that a method and a quotation are not the same thing. This was a successful lesson. UPDATE: I repeated this process with a bottom set year 10 class where I was even more specific. This was also a successful lesson, so I’ve included it.
KS3: Survival Reading Assessment
streetno9streetno9

KS3: Survival Reading Assessment

(1)
A series of lessons and resources designed for a top set year 8 class. The extracts are a mixture of fiction and non-fiction. The focus was to take a group of year 8 students who are used to using the PEE structure and get them to write a concept focused response. I’ve included the model responses we built as a class, as well as the model response the students were provided.
AQA English Literature: An Inspector Calls essay building lesson
streetno9streetno9

AQA English Literature: An Inspector Calls essay building lesson

(0)
A lesson that models the process of building a high-end An Inspector Calls essay. Please note, the lesson assumes that the class has read the play and has attempted versions of the AQA English Literature questions already. Also, the lesson works best as an aspirational example: I concentrate on using sophisticated language to shape my points, and focus on integrating appropriate references. Please note I’ve deliberately left some academic “gaps” too - this model response is a high-quality response, but there are other avenues of academic insight that can be taken. Bottom line, to get the most out of this lesson, you’ll need to spend a little time going through it all first - hence the low price.
AQA English Language Paper 2 Deconstruction: The Other Side of the Dale vs The Ragged School
streetno9streetno9

AQA English Language Paper 2 Deconstruction: The Other Side of the Dale vs The Ragged School

(1)
I’ve done quite a few of these now, and I always try to improve on the last one. I think this is about as far as I can go with this format. Here’s what you get: An individual breakdown of each of the exam questions. Each section contains the following: A breakdown of the AQA related material A walk-through for Q2, Q3 and Q4 Suggested targets and strategies 5 Case studies using real student responses (Except for Q1. You’ve got 10 for Q5 though) Real students planning processes laid out for discussion It’s a big one - you’ve got 60+ slides to work through. In terms of teaching, this works best after you’ve sat the relevant exam. However, it wouldn’t take much tweaking for a mock-style scenario. Also, this is designed to be given to the students so that they can engage with it at home.
AQA English Language Paper 1 Deconstruction: The Silent Land
streetno9streetno9

AQA English Language Paper 1 Deconstruction: The Silent Land

(1)
Similar to a number of other resources I’ve already posted. Designed to be used after the students have sat the associated AQA English Language Paper 1 GCSE Paper, though with a little tinkering, you could run this as a mock exam itself and then have the students peer/self-assess afterwards. The powerpoint goes through each of the five questions, placing a firm expectation on the students having a pre-established strategy for completing each task. The students are then encouraged to refine this strategy. Each of the sections contains a break down of the associated source, exploration of the stepped Model Responses provided by AQA, and then provides the students with up to FIVE Case Study responses written by students (containing mistakes and all). I’ve had a lot of success with these types of powerpoints and they are especially useful for students working in isolation, or as a revision tool. Hopefully this will be of use to you.
Home Learning Tracking Spreadsheet
streetno9streetno9

Home Learning Tracking Spreadsheet

(0)
A simple spreadsheet that allows you to keep track of your online lessons. My school uses classcharts as its medium in setting online learning - but you can easily change the headings of the columns to reflect whatever software you use.
AQA English Language Paper 1: Glass, Bricks and Dust
streetno9streetno9

AQA English Language Paper 1: Glass, Bricks and Dust

(0)
Two powerpoints, both showing the same thing, but one is designed to be used on a mobile phone (portrait, no animations etc.). The powerpoint can be used one of two ways. Either it can be used as part of a talking mock exam (where the students talk through a strategy before attempting each task, followed by marking and reflective targets) or as part of getting the students to evaluate their own efforts with a view to setting individual targets. Model material is included as well as the source itself (along with the appropriate mark scheme). The only thing this doesn’t “mark” is the AO5 element of Question 5. But everything else is there.
KS3: Woman In Black: Creative Writing focus
streetno9streetno9

KS3: Woman In Black: Creative Writing focus

(0)
Taught as part of a two teacher approach to a top set year 9 class. I focused on developing creative writing skills, with a particular emphasis on the structural components, whilst my partner teacher focused on the more traditional literature style approach. The Woman In Black was used as the stimulus for all elements of this unit and the climax is a GCSE English Language Paper 1 style task (not included in this pack as it is part of my school’s assessment pack). Overall, I found this unit to be really useful in challenging students to think about their creative writing in more than just a reactionary way. The nature of the structure focused questions align with my belief that it is always better to teach the Language Paper 1 Q3 question in the form of a structure-focused creative writing commentary at KS3 level. Hopefully this will provide you with a useful starting point for your own creative writing journey.
AQA English Language Paper 2: Death Zone vs London Snow
streetno9streetno9

AQA English Language Paper 2: Death Zone vs London Snow

(1)
A powerpoint lesson designed to be taught either AFTER a class has sat AQA English Language Specimen Paper 4, or to be used WHILST a class is sitting the same paper in the form of a mock exam where feedback is given immediately. In this powerpoint, I refer directly to the model material provided by AQA and provide some feedback that can be given to the students. The idea with the feedback is that the person marking (teacher or student) writes down the letter/number and, when the marked work is returned, the owner of the response can either write the target down in full or highlight it in a printed version.
AQA English Language Paper 1: The Mill
streetno9streetno9

AQA English Language Paper 1: The Mill

(0)
A PowerPoint designed to be used after students have sat the Section A of the AQA English Language Paper 1 for June 2019. It wouldn’t take much altering to be used as a mock exam itself. The slides are set up to show the model answers from the mark scheme so that students can peer/self assess and give actions and feedback.