This editable spreadsheet allows your students to calculate their grades easily.
It has the following units:
Online World, Tech Systems, Digital Portfolio, Graphics, Animation, Spreadsheets, Databases. Web Design, Computer Networks.
It does give ‘false’ results if students enter high grades for some units and none for the others so there is a note at the side warning them of this!
These spreadsheet exercises were created for the BTEC Level 2 Extended Certificate in Information and Creative Technology but might be used in any beginners Spreadsheet class.
They are design to be done after some teacher input and cover a number of simple function and formulae. These include:
Addition
Subtraction
Multiplication
Percentages
Simple IF statement
Minimum
Maximum
Average
Creating simple charts and graphs
Wrapping Text
Borders and fills
Change of font and size
The aim, too, is to get learners to think about the math rather than blindly following instructions without really ‘getting it’. These exercises can be done by students of varying abilities - and there are some additional activities on each sheet for those who finish first.
This spreadsheet allows users to enter marks for each question for GCSE English Language. There is a spreadsheet for Paper 1 and Paper 2 for each of the three 9-1 GCSE English Language 8700 sittings so far.
The spreadsheets will not allow errors so they will not let users type in 9 marks for an 8 mark question, for example.
They calculate the total marks - plus they also automatically give you the final grade for that paper.
These are editable spreadsheets so you can further change them if you so wish.
There is a separate spreadsheet containing grade boundaries for all 6 past papers (Paper 1 and Paper 2 x3).
This was created for learners doing GCSE English Language - the new Grade 9-1 Course. It can be used as a revision but more particularly as an introduction to structural features. Paper 1 Question 3 is the structure questions where learners must comment on structure (see example question below from the June 2018 examination). A student response can easily become muddled if they are not confident with the terminology used to do that.
The game is designed to be naturally differentiated - the quality of the responses will depend on the ability of the students but all can participate. Learners are given individual structural features to investigate and must report back on it to the class, including an easy-to-understand definition and hopefully examples of where it is used in one of a variety of forms. If there are no opportunities to use internet enabled devices in class, this could be easily changed to be a homework activity. It is also perfect for a cover class!
The game is an editable PowerPoint so you can also adapt it if you wish. Please do not redistribute afterwards in any format.
Also included is a full lesson plan for this session - again it is editable if you wish to make changes (inevitable as your learner needs may be subtly or very different to those of my own).
Assessment Objective: AO2: Explain, comment on and analyse how writers use language and structure to achieve effects and influence readers, using relevant subject terminology to support their views
The resource also works towards paper 1 question 5 (AQA board at least!) when learners must incorporate structural features in to their own creative writing, either descriptive or narrative.
This pack of picture questions is designed for AQA GCSE English Language 9-1. They simulate Paper 1 Question 5 where students are given a picture and are presented with two options (it’s hard, almost to call them questions!). The tasks can be for a descriptive or a narrative response (although both tasks can be descriptive or narrative and this pack reflects that). I hope that you will be able to use this pack to help you increase the story-telling powers of your learners as well as their descriptive prowess!
The pack gives teachers the opportunity to have a selection of ready-made questions for Paper 1 Question 5. These can be used to ensure that there are always writing tasks at hand. They might be used to stimulate class or small group discussion or can be used as interchangeable exercises to be done during a session. I hope that there is a sufficient variety of images in this pack to pique the interest of even the most reluctant of writers. By giving your learners a choice of task (while the assessment objectives - A05 and A06 remain the same) these sample questions might help to ensure both differentiation and an element of choice.
Each is formatted to include the question on a single A4 sheet. The originals are also included on their own if you would like to use them without the question stimulus.
They would probably also be very useful if you are covering a class - the skills that students develop with these questions are vital for success in GCSE English as this question alone represents 25% of the entire exam.
All of the wonderful pictures have been ethically sourced and are available under a Creative Commons license which means you do not have to worry about copyright with them at all. Each originator is credited by use of a link to the original.
This could save some time…
This spreadsheet contains five sheets:
A front page enter their details (name etc) and yours, that are then copied through to all other sheets (so name only goes in once).
A writing FCP (Form, Content, Purpose) Skills Tracker sheet for the Writing Unit
A Writing SPAG (Spelling and Grammar) Skills Tracker for the Writing Unit
A Reading Skills Tracker for the Reading Unit
A Speaking & Listening Skills Tracker
Together they build to give you a complete picture of where your student’s skills lie. They can be updated twice during the year so that students can measure their progress.
Hope it’s useful to you!
Subtitle: The minor scales - ancient secrets hidden in plain sight
Short description:
The keyboard instrument has evolved to fit the natural shape of our hands; its design follows an essential feature of their anatomy: symmetry.
Long description:
If you find it easier to learn visually, this brochure is perfect for you.
The simplified depiction of the minor scales will help you understand your keyboard instrument in a coherent way.
A complete collection of scale fingering charts will also enable you to start playing along to your favorite music.
You will soon begin uncovering more complex music theory during infinitely more enjoyable practice sessions.
Fancy having a go at letting a spreadsheet do your thinking for you?
This spreadsheet has been created with Paper 1 Section B in mind. As such it only generates a mark for creative writing.
This spreadsheet allows you to enter the skills your students demonstrated (from a drop-down list). Marks for Content and Organisation and Technical Accuracy will be automatically generated using a cute algorithm.
This is based on Nov 18’s mark scheme where a 4 was a straightforward 50% (sounds reasonable).
If you disagree with the marks the spreadsheet generates, you can change them manually and it will still work. It has entries for up to 30 students (hopefully your class is no bigger than that!).
This spreadsheet comes with instructions!
This will be of use if you have done a progress test focusing on Paper 1 Q1-Q4.
I’ve created the attached spreadsheet (the template file) which enable you to enter marks and generate grades for the students. The grade boundaries are from November 2018 but you can adapt this spreadsheet easily to other papers.
Student names and numbers need to be entered on to the front sheet - as well as the marks for each question. This will generate an overall grade for the students and count how many get each grade in your class.
I’ve added a bit more functionality, though. Once the grades have gone in, they generate a progress report for each student which can be used as a feedback sheet. The mark that they get for each question generates a comment about it…
You will need to add a comment on each of these but I have put 30 examples of comments on the second sheet in the spreadsheet which you could adapt, copy and paste…
You will also need to do a comment on attendance, punctuality and behaviour using drop down lists (at the bottom of each student sheet).
Please feel free to use, adapt and so on!
Many learners do a mock exam, receive their grade and react accordingly. The reaction, however, is often short-lived and they quickly move on to something else. This form has been designed to encourage a period of self-reflection on their GCSE English mocks. I developed it because I found that although many of my students could answer the question “Why do we do mock exams?”, a large number of them could not fully answer this one: “How will you use your mock exam to improve your future performance?”.
In other words, I got the impression that many of them thought that mock exams were wholly or solely a tool for teachers. This form, I hope, encourages learners to reflect more on their mock exam performance and to use that reflection to move towards doing better next time.
As such there are rather a lot of questions – and I am quite happy for you to adapt this form to suit your own learners. I hope it’s “good to go” for most English GCSE situations.
Plus, if you are reading this as a student, hope that you could even use it independently of your teacher in order to create an overview of how you did and what can be improved.
The questions are split in to three sections – before, during and after the exam. In this way I hope I have caught the three important processes for successful exam performance. However, as I have indicated above, please feel free to adapt. I would be grateful, if you do, to indicate any changes in the comments below – these will help me to reflect on the form itself and to improve upon it.
Two quizzes based on structure.
Quiz 1
This quiz is based on a very short story of just 386 words called “The Unbroken Bond”. It is followed by 19 multiple choice questions and 3 order questions. For those who finish early there is an extension task at the end. This resource was originally created as there don’t seem to be many “structure” resources out there that are good quality and teach the learners anything except the terminology! I believe this quiz provoked some thought about how to respond to the question in an exam scenario.
This is ideal for a cover lesson, too, as it produces no marking, as long as the answers are given out once the quiz is complete (learners can mark their own or can exchange their papers with others).
I would advise reading the story out loud at the start to ensure that all the learners have read it and do not (as is sometimes the case) attempt the “pot luck”” strategy of answering the question.
The story is very PG. It focuses on a dog whose “boy” has gone missing and his frantic search for his friend. It is resolved when “boy” returns, simply having been to school for the day. It is based on the June 2023 P1Q5 – “Write a story about a human meeting an animal”. As such, it can also be used as an exemplar for that question.
There is also a comprehensive answer booklet with explanations so that the teacher who is doing the lesson can respond to learner questions about why the right answer was… the right answer!
The order questions are a student responses (done in the PEE manner). Learners have to put them in the right order. The point and evidence are presented in the first sentence. The two explanatory sentences can be separated in terms of order because the final point has a linking word or phrase indicating summation is in process.
Although this quiz is “low stakes” in nature, it covers a large amount of subject terminology which can be discussed at the time when the answers are given. The aim is to embed this terminology as well as exposing students to ways in which it could be incorporated into their own attempts at P1Q3.
The text is also provided separately as there are always learners who ask for this so they do not have to keep flicking back and forth.
PDF and Word formats for the documents are included.
This quiz would easily be adaptable into an online version if you wanted to do the quiz as homework, The questions and answers could be quickly copied and pasted into MS Forms or a Moodle interface – and the explanations given in the answer booklet could also be used to enable online automated feedback.
Quiz 2
This quiz is based on a very short story of just 458 words called “The Dream of Billy Williams”. It is followed by 19 multiple choice questions and 3 order questions. For those who finish early there is an extension task at the end. This resource was originally created as there don’t seem to be many “structure” resources out there that are good quality and teach the learners anything except the terminology! I believe this quiz provoked some thought about how to respond to the question in an exam scenario.
This is ideal for a cover lesson, too, as it produces no marking, as long as the answers are given out once the quiz is complete (learners can mark their own or can exchange their papers with others).
I would advise reading the story out loud at the start to ensure that all the learners have read it and do not (as is sometimes the case) attempt the “pot luck”” strategy of answering the question.
The story is set during the First World War and focuses on a soldier, Billy Williams who can sleep through anything - but unfortunately this does not ultimately save him. The description of his death is not “blood and guts” but focuses on his obliteration by a shell. The story uses all the skills to get a very high grade for Paper 1 Question 5. As such, it can also be used as an exemplar for that question, too.
There is also a comprehensive answer booklet with explanations so that the teacher who is doing the lesson can respond to learner questions about why the right answer was… the right answer!
The order questions are a student responses (done in the PEE manner). Learners have to put them in the right order. The point and evidence are presented in the first sentence. The two explanatory sentences can be separated in terms of order because the final point has a linking word or phrase indicating summation is in process.
Although this quiz is “low stakes” in nature, it covers a large amount of subject terminology which can be discussed at the time when the answers are given. The aim is to embed this terminology as well as exposing students to ways in which it could be incorporated into their own attempts at P1Q3.
The text is also provided separately as there are always learners who ask for this so they do not have to keep flicking back and forth.
PDF and Word formats for the documents are included.
This quiz would easily be adaptable into an online version if you wanted to do the quiz as homework, The questions and answers could be quickly copied and pasted into MS Forms or a Moodle interface – and the explanations given in the answer booklet could also be used to enable online automated feedback.
Enjoy!
What happens after the opening lines of a story? Often, the writer will shift focus to describe the setting. This set of ten picture prompts (for GCSE English but could be used at any level) gives students a visual nudge.
Their job is to create a setting description which could be used as a second paragraph in a story. However, they must also incorporate some important elements that would help them to grab marks in an exam.
This helps students to think about the structure of a whole text – often in GCSE English paper 1 (AQA) the second paragraph is descriptive so that candidates can answer the “language question” in the exam. More than that, of course, the description of the setting helps to bring the text alive with a little “world building”.
This set of ten picture prompts could be used for a complete lesson, but the idea behind them was to use as starters – a “do now” activity. As only a single paragraph is demanded, this could be done in ten minutes or so, with time for some of the learners to read their out loud. Alternatively, could make a great activity on a VLE.
In class these could be shown on a smartboard one by one, or you could do a mix and match, so the students get given a random picture to describe. It’s up to you – this set of picture prompts is versatile enough for you to think of a number of ways in which to use it!
Files included are Powerpoint and a PDF version.
This short lesson was devised to help students to learn what the markers are looking for if they are asked to write a letter in GCSE English Paper 2 Question 5 (AQA).
The letter, it must be stressed, is a great example but this would probably not be achievable in the 45 minutes available for this task in the exam. However, it covers all the necessary skills to get 40/40 for the question - or if not that, pretty close to it!
There are a series of short exercises too. These cover the “Content and Organisation” skills, as well as those for “Technical Accuracy”. Students are encouraged to discuss the assessment objectives associated with these skills.
This is a beautifully presented set of 40 “Do Now” activities for GCSE English.
I call it “exam paralysis” – when students sit in an exam for five, ten, fifteen minutes or more, apparently doing nothing. They are so unused to writing spontaneously and in time-constrained conditions that they freeze. This not only wastes valuable exam time, it stops them doing as well as they could (in terms of final grade).
I created this set of prompts/activities as a response to this. Free writing increases confidence, generates honesty in writing, develops writing abilities and voice, promotes the process of writing, rather than the outcome – and help overcome writer’s block. It isn’t supposed to be marked, it is simply to help the students allow themselves to write as creatively and as honestly as they can.
However, I realise that this doesn’t suit all the teachers all of the time, so I have also adapted this set of prompts into exam-style exercises, where content, organisation and technical accuracy are taken into account.
The “free writing” set is designed without marking in mind – they are designed simply to develop the ability to write quickly, developing voice and confidence. However, I will pace the room making comments and encouraging the writing process, of course! The “exam style” set would necessarily involve more formal feedback or at least more of an eye on the prize, as it were.
Both sets are editable so the instructions can be tweaked, if needed, to suit your learners.
(Sometimes it’s difficult to activate learning, especially at the beginning of the first session of the day or week. A great way to kickstart a class, assess prior learning and to give the students instant feedback is a “Do Now” activity.)
With your help, your students will be able to create a checklist of the skills they need to demonstrate in the exam. There is a “worked example” in this resource (written by a real 2024 student) which demonstrates high level skills. Your students discuss read it and come up with their own “rubric” -in their own words.
This can be done without the pressure of them getting things wrong or being marked.
The notes are not an additional student handout – they might be a little too much for all but the most engaged learners. The notes cover all of the elements contained in the marking scheme for GCSE English Language (AQA) Paper 1 Question 5 (i.e. the rubric that articulates specific components and expectations for a piece of creative writing). They have been created so that you know the story and how it is organised, structured and technically accurate inside out.
It’s your cheat sheet in other words!
My own students really enjoyed this activity. It helped a lot of them to understand (and more importantly remember) the skills that they need to demonstrate to the markers for AO5 and AO6.
O5: Communicate clearly, effectively and imaginatively, selecting and adapting tone, style and register for different forms, purposes and audiences. Organise information and ideas, using structural and grammatical features to support coherence and cohesion of texts
AO6: Candidates must use a range of vocabulary and sentence structures for clarity, purpose and effect, with accurate spelling and punctuation. (This requirement must constitute 20% of the marks for each specification as a whole.)
I wanted to focus on P1Q1 in a lesson but didn’t want to exhaust my limited amount of past papers - so I came up with this - get the students to write the paragraph themselves.
This lesson can be quite a lot of fun!
As well as covering Assessment Objective 1 (AO1) – “identify and interpret explicit and implicit information and ideas” – it also covers some ground in terms of AO5 and AO6. These are where writing skills come to the fore – candidatess must communicate clearly, adapt to a certain tone and style and organise their ideas (not to mention sentence structures, spelling and punctuation…).
The files are included in PowerPoint format and PDFs to suit your needs. I have also included a PP and PDF of the pictures on their own if you wish to display them. All pictures were ethically sourced under a Creative Commons license - so please keep the URL on the slides as the originators should be credited.
All of the extracts in this document are free from copyright restrictions. This is either because of when they were written (and so now fall out of copyright statutes), have no copyright restrictions and/or were originally published under a Creative Commons license.
They have been carefully collated to ensure that a wide range of voices can be heard by students studying towards their GCSE English. We have not overlooked famous authors by any means but a pivotal reason for putting these core texts together was to counter the inherent Eurocentricity of past and current curricula.
Although there are no associated tasks included here (they are on the VLE) we are happy to make these texts available to anyone who cares to read them. They were chosen for their engaging content and so even if you do not use these as specific tasks, we hope that you will find them collectively an enjoyable and thought-provoking read. If you love to dip in and out of literature, you have come to the right place!
When substantial additions are made (this is an ongoing project) we will update the document available online.
These three resources can be used as whole classes.
However, they are also great as ‘fillers’ - to take up a short amount of time in a class (at the beginning or end, perhaps!).
They were created in response to student need. Looking at the whole of Paper 1 Question 5 can become repetitious - and does not always suit less able students.
The three resources are:
Flashback writing exercised (students given a picture and a pre-written paragraph and must imagine what has happened previously).
Write Four Things - a game, of sorts. Students become the examiner and have to provide their peers with a paragraph which could be used to answer Paper 1 Question 1.
Openings - students are given a scaffold with which to build the first paragraph of a description or narrative.
These exercises fit in a lot of what A05 and A06 cover.
AO5: Communicate clearly, effectively and imaginatively, selecting and adapting tone, style and register for different forms, purposes and audiences. Organise information and ideas, using structural and grammatical features to support coherence and cohesion of texts
AO6: Candidates must use a range of vocabulary and sentence structures for clarity, purpose and effect, with accurate spelling and punctuation. (This requirement must constitute 20% of the marks for each specification as a whole.)
This bundle enables you to purchase our last 12 resources at a discount to you of 25%,
Although you can see their descriptions individually, I’ll just run through the content for you!
Scaffolded Descriptive Writing (4 resources)
20 English scaffold openers (short, bite-size, lots of 'em!)
Whole text excercise using scaffolding
2 whole text scaffolded exercises using the same picture to create different tone
3 self-scaffolded exercises where students create their own scaffold.
Questions for Paper 1 Question 5 (4 resources)
Two sets of tasks for descriptive and/or narrative writing. Altogether that will give you 90 tasks to mix and match (or otherwise!) with your students.
Structural Features Game (1 resource)
Fun for all the family (well, OK, no) with this game - students research a structural feature and then have to report their findings to the class.
Word Gym Homework and Tests (2 resources)
Need to give homework but don’t want to do any marking? Give them these (editable) quizzes. Over 10 sessions (week, however you want) send your students to the WORD GYM. 10 tasks to do as homework (probably take them an hour each) for classroom based tests (10-15 mins). 100 KS4 words for them to discover!
Spreadsheet (1 resource, 6 spreadsheets)
Using the grade boundaries for each paper (Jun 17 and 18, November 17) if you give them a mock using these spreadsheets you will be able to see your students’ grades quickly and easily.
ENJOY!
This bundle incorporates all the scaffolded writing resources I have uploaded to TES. Together they create a continuous resource from the introduction of “bite size” openers to whole text creation. The aim, ultimately is to “self-scaffold” and that is what the last resource does. Once at that point students should be able to scaffold quickly with no assistance.
Contents:
20 English scaffold openers (short, bite-size, lots of 'em!)
Whole text excercise using scaffolding
2 whole text scaffolded exercises using the same picture to create different tone
3 self-scaffolded exercises where students create their own scaffold.
This is enough to keep your students busy for quite a while. It is also an alternative approach to descriptive writing which may enliven teaching and learning.
The aim, ultimately, is to significantly increase the marks awarded for Paper 1 Question 5 (descriptive writing) of GCSE English Language (AQA but these are editable and easily adaptable for any board).
These exercises cover the following Assessment Objectives:
AO5: Communicate clearly, effectively and imaginatively, selecting and adapting tone, style and register for different forms, purposes and audiences. Organise information and ideas, using structural and grammatical features to support coherence and cohesion of texts
AO6: Candidates must use a range of vocabulary and sentence structures for clarity, purpose and effect, with accurate spelling and punctuation.