Biology ppts suitable for GCSE & A Level.
Spreadsheets to track and analyse AQA A Level Required Practical data.
Report Writing, create pupil reports with a click from comment banks, automatically inserts names & adjusts gender pronouns.
Teacher planner book, automatically creates timetable, weekly lesson outlines, registers with pupil data analysis. Create schemes of works.
Biology ppts suitable for GCSE & A Level.
Spreadsheets to track and analyse AQA A Level Required Practical data.
Report Writing, create pupil reports with a click from comment banks, automatically inserts names & adjusts gender pronouns.
Teacher planner book, automatically creates timetable, weekly lesson outlines, registers with pupil data analysis. Create schemes of works.
Fully interactive, playable Wordle game. This power point game has a database of over 400 five letter words. Words are chosen at random from the database list. The game plays according to the standard Wordle rules with letters in the correct place showing up in green, a correct letter in the wrong place in orange and subsequent occurrences of a wrongly placed correct letter remains grey. You have 6 attempts to find the correct word, if this is not achieved you will be informed of the correct word. The pptm requires macros to be enabled to work. When opening the pptm for the first time please ensure when asked to enable macros, that you check the option. Without doing this the automated processes in the game will not work. Please do not rename the pptm.
Warning - If the first slide is deleted or altered then the game WILL NOT work.
An automated COVID-19 Absence tracker for Primary Schools
This automated spreadsheet allows you to monitor the impact of coronavirus upon your pupils and staff. Information can be recorded for each year group cohort, recording days absent due to confirmed positive absences, school enforced contact absences & self-isolating absences.
All inputs are automated to speed up the entry and display of key data. Including a colour coded calendar displaying the reasons for absences. The calendar can be re-ranked upon numerous criteria with the click of a single button. Individual pupil summaries can be displayed as can the impact of the absences for a set date. This last option aids the calculations necessary for the daily DfE Education Setting Status questions which have to be submitted at 2pm on each term time day.
Term dates can again be adjusted with the click of a button for all calendars to suit your establishment.
The free evaluation version caters for 13 pupils in a single year group cohort. The full paid for version allows for 250 pupils per year group and for year groups 1 - 6 & Staff.
The spreadsheet requires the use of macros (computer code) to enable the automations. When you first open the spreadsheet, you must enable Macros within Excel. Due to the use of macros this version CAN ONLY be run on Windows Versions of Microsoft Excel.
A free evaluation version is available from:
https://www.tes.com/teaching-resource/covid-19-coronavirus-absence-tracking-software-12425518
A paid for version for Secondary Schools is available from:
https://www.tes.com/teaching-resource/covid-19-absence-tracking-software-12425525
An automated COVID-19 Absence tracker.
This automated spreadsheet allows you to monitor the impact of coronavirus upon your pupils and staff. Information can be recorded for each year group cohort, recording days absent due to confirmed positive absences, school enforced contact absences & self-isolating absences.
All inputs are automated to speed up the entry and display of key data. Including a colour coded calendar displaying the reasons for absences. The calendar can be re-ranked upon numerous criteria with the click of a single button. Individual pupil summaries can be displayed as can the impact of the absences for a set date. This last option aids the calculations necessary for the daily DfE Education Setting Status questions which have to be submitted at 2pm on each term time day.
Term dates can again be adjusted with the click of a button for all calendars to suit your establishment.
The free evaluation version caters for 13 pupils in a single year group cohort. The full paid for version allows for 250 pupils per year group and for year groups 7-13 & Staff.
The spreadsheet requires the use of macros (computer code) to enable the automations. When you first open the spreadsheet, you must enable Macros within Excel. Due to the use of macros this version CAN ONLY be run on Windows Versions of Microsoft Excel.
A free evaluation version is available from:
https://www.tes.com/teaching-resource/covid-19-coronavirus-absence-tracking-software-12425518
A Paid for version for Primary Schools is available from:
https://www.tes.com/teaching-resource/covid-19-primary-pupil-absence-tracker-12450160
An automated COVID-19 Absence tracker.
Paid for versions for Primary and Secondary Schools see below.
This automated spreadsheet allows you to monitor the impact of coronavirus upon your pupils and staff. Information can be recorded for each year group cohort, recording days absent due to confirmed positive absences, school enforced contact absences & self-isolating absences.
All inputs are automated to speed up the entry and display of key data. Including a colour coded calendar displaying the reasons for absences. The calendar can be re-ranked upon numerous criteria with the click of a single button. Individual pupil summaries can be displayed as can the impact of the absences for a set date. This last option aids the calculations necessary for the daily DfE Education Setting Status questions which have to be submitted at 2pm on each term time day.
Term dates can again be adjusted with the click of a button for all calendars to suit your establishment.
The free evaluation version caters for 13 pupils in a single year group cohort. The full paid for version allows for 250 pupils per year group and for year groups 7-13 & Staff,
The spreadsheet requires the use of macros (computer code) to enable the automations. When you first open the spreadsheet, you must enable Macros within Excel. Due to the use of macros this version CAN ONLY be run on Windows Versions of Microsoft Excel.
The full paid for version for Secondary Schools is available from:
https://www.tes.com/teaching-resource/covid-19-absence-tracking-software-12425525
The full paid for version for Primary Schools is available from:
https://www.tes.com/teaching-resource/covid-19-primary-pupil-absence-tracker-12450160
This is the Full paid for version of the Electronic Teacher Planner/Mark book spreadsheet for teachers with a TWO WEEK TIMETABLE. The Free evaluation version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-free-evaluation-version-11912398
The paid version for a ONE WEEK TIMETABLE is available from: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-12357931
This is a full teacher’s planner book enabling you to replace your paper based record book. It enables you to create a colour coded timetable (and will automatically generate a blank timetable with the appropriate number of periods per day), a week by week lesson outline planning sheet, a register for each class that records attendance, performance and behavioural information upon each pupil, homework and test scores. The registers will rank the pupils according to assessment criteria, absences and upon test scores. The class analysis page will give detailed information upon the number of lates/tardiness, discipline issues, forgotten books, no homework, incomplete pieces of work and work graded excellent, good, satisfactory and poor. Schemes of work can be created, and reports written upon individual students. Print outs of each class can be used at parent consultation evenings and as a record for SLT. Cover lesson instructions can also be created. I have used this spreadsheet in an ongoing developing form for the last 20 years and haven’t used a paper-based planner in that time. The spreadsheet uses macros (embedded code) to automate the functions so you only have to click a button to add registers and so they need to be enabled in excel, see the help page in the spreadsheet on how to do this.
Please note this spreadsheet will not run on Mac versions of Excel, it will only run on Windows PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.
This is the Full paid for version of the Electronic Teacher Planner/Mark book spreadsheet. The Free evaluation version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-free-evaluation-version-11912398
A TWO WEEK Timetable version is available at: https://www.tes.com/teaching-resource/electronic-teacher-planner-mark-book-two-week-version-12358075
This is a full teacher’s planner book enabling you to replace your paper based record book. It enables you to create a colour coded timetable (and will automatically generate a blank timetable with the appropriate number of periods per day), a week by week lesson outline planning sheet, a register for each class that records attendance, performance and behavioural information upon each pupil, homework and test scores. The registers will rank the pupils according to assessment criteria, absences and upon test scores. The class analysis page will give detailed information upon the number of lates/tardiness, discipline issues, forgotten books, no homework, incomplete pieces of work and work graded excellent, good, satisfactory and poor. Schemes of work can be created, and reports written upon individual students. Print outs of each class can be used at parent consultation evenings and as a record for SLT. Cover lesson instructions can also be created. I have used this spreadsheet in an ongoing developing form for the last 20 years and haven’t used a paper-based planner in that time. The spreadsheet uses macros (embedded code) to automate the functions for you so you just have to clickand so they need to be enabled in excel, see the help page in the spreadsheet on how to do this.
Please note this spreadsheet will not run on Mac versions of Excel, it will only run on Windows PC versions of, due to incompatibility issues between Microsoft Office on the 2 different platforms.
A fully interactive Boggle game, suitable for Key Stage 2 and 3, which is a fun way for pupils to develop their vocabulary and spelling skills.
The game has a database of over 300, nine letter words, which are automatically selected randomly by the game.
The word’s letters are displayed in a random order in a 3 x 3 grid with the first letter of the 9-letter word displayed as a capital.
Pupils have 3 minutes to come up with as many words as possible using the letters, they do not have to use all the letters in their words. A bonus can be given if they find the 9-letter word.
Click on the Select new word button to automatically create a new 3x3 grid of letters from a new 9-letter word.
Click on the Go button to start the 3-minute timer. A horn will sound at the end of the 3 minutes.
To display the 9-letter word click on the reveal the 9-letter word box.
The game requires macros to be enabled within Power-point to allow the automated features to work. For this reason it will only run on Power-point for Windows and Power-point for Mac’s, it will not run on other ppt viewers.
Further games and educational resources can be found at:
https://www.tes.com/teaching-resources/shop/john_leather
An interactive Hangman game preloaded with a 104-word, word bank of Year 5 + 6 English National Curriculum recommended common spellings.
The blanks for the word are automatically shown on the game slide. Clicking on a letter called out by your pupils will either reveal the letters and turn the keyboard letter green or it will add a hangman piece and turn the keyboard letter red. If the word is discovered, then a you win message is shown. If the pupils lose a you’re hanged message is shown. Pupils can opt to be shown a hint message which will cost them one additional hangman piece added to the gallows. Multiple words will be automatically separated by a “/” on the screen.
The game can be played in 3 ways:
The game automatically selects a random word from the word bank
By entering a single word(s) before running the game.
By entering a word while playing the game, (remember to blank the presentation screen when entering the word and hint.
The word bank contains 104 words and hints
A free evaluation version of the game (for GCSE Biology terms) can be downloaded from:
https://www.tes.com/teaching-resource/hangman-game-for-gcse-biolofy-free-evaluation-version-12233754
Please be aware the game uses macros in Power-point which must be enabled when you first open the pptm file and so will only run on Microsoft Power-point for windows or Apple. It will not run on other ppt viewers.
An interactive Hangman game preloaded with a 109 Year 3 + 4 English National Curriculum recommended common spellings word bank.
The blanks for the word are automatically shown on the game slide. Clicking on a letter called out by your pupils will either reveal the letters and turn the keyboard letter green or it will add a hangman piece and turn the keyboard letter red. If the word is discovered, then a you win message is shown. If the pupils lose a you’re hanged message is shown. Pupils can opt to be shown a hint message which will cost them one additional hangman piece added to the gallows. Multiple words will be automatically separated by a “/” on the screen.
The game can be played in 3 ways:
The game automatically selects a random word from the word bank
By entering a single word(s) before running the game.
By entering a word while playing the game, (remember to blank the presentation screen when entering the word and hint.
The word bank contains 109 words and hints
A free evaluation version of the game (for GCSE Biology terms) can be downloaded from:
https://www.tes.com/teaching-resource/hangman-game-for-gcse-biolofy-free-evaluation-version-12233754
Please be aware the game uses macros in Power-point which must be enabled when you first open the pptm file and so will only run on Microsoft Power-point for windows or Apple. It will not run on other ppt viewers.
An interactive Hangman game preloaded with 70 Science Equipment words in a word bank.
The blanks for the word are automatically shown on the game slide. Clicking on a letter called out by your pupils will either reveal the letters and turn the keyboard letter green or it will add a hangman piece and turn the keyboard letter red. If the word is discovered, then a you win message is shown. If the pupils lose a you’re hanged message is shown. Pupils can opt to be shown a hint message which will cost them one additional hangman piece added to the gallows. Multiple words will be automatically separated by a “/” on the screen.
The game can be played in 3 ways:
The game automatically selects a random word from the word bank
By entering a single word(s) before running the game.
By entering a word while playing the game, (remember to blank the presentation screen when entering the word and hint.
The word bank of 70 words and hints can easily be edited by deleting existing words and over-typing new words. The game will cope with word(s) up to 32 characters long including any spaces.
A free evaluation version of the game (for GCSE Biology terms) can be downloaded from:
https://www.tes.com/teaching-resource/hangman-game-for-gcse-biolofy-free-evaluation-version-12233754
Please be aware the game uses macros in Power-point which must be enabled when you first open the pptm file and so will only run on Microsoft Power-point for windows or Apple. It will not run on other ppt viewers.
This is a free evaluation version of Hangman, limited to 5 words and a maximum length of 6 letters per word. The full paid for version is described below:
A Hangman game preloaded with 70 GCSE Biology words in a word bank.
The blanks for the word are automatically shown on the game slide. Clicking on a letter called out by your pupils will either reveal the letters and turn the keyboard letter green or it will add a hangman piece and turn the keyboard letter red. If the word is discovered then a you win message is shown. If the pupils lose a you’re hanged message is shown. Pupils can opt to be shown a hint message which will cost them one additional hangman piece added to the gallows. Multiple words will be automatically separated by a “/” on the screen.
The game can be played in 3 ways:
The game automatically selects a random word from the word bank
By entering a single word(s) before running the game.
By entering a word while playing the game, (remember to blank the presentation screen when entering the word and hint.
The word bank of 70 words and hints can easily be edited by deleting existing words and over-typing new words. The game will cope with word(s) up to 32 characters long including any spaces.
A the full version of the game can be downloaded from:
https://www.tes.com/teaching-resource/hangman-game-with-70-gcse-biology-words-12233742
Please be aware the game uses macros in Power-point which must be enabled when you first open the pptm file and so will only run on Microsoft Power-point for windows or Apple. It will not run on other ppt viewers.
A Hangman game preloaded with 70 GCSE Biology words in a word bank.
The blanks for the word are automatically shown on the game slide. Clicking on a letter called out by your pupils will either reveal the letters and turn the keyboard letter green or it will add a hangman piece and turn the keyboard letter red. If the word is discovered then a you win message is shown. If the pupils lose a you’re hanged message is shown. Pupils can opt to be shown a hint message which will cost them one additional hangman piece added to the gallows. Multiple words will be automatically separated by a “/” on the screen.
The game can be played in 3 ways:
The game automatically selects a random word from the word bank
By entering a single word(s) before running the game.
By entering a word while playing the game, (remember to blank the presentation screen when entering the word and hint.
The word bank of 70 words and hints can easily be edited by deleting existing words and over-typing new words. The game will cope with word(s) up to 32 characters long including any spaces.
A free evaluation version of the game can be downloaded from:
https://www.tes.com/teaching-resource/hangman-game-for-gcse-biolofy-free-evaluation-version-12233754
Please be aware the game uses macros in Power-point which must be enabled when you first open the pptm file and so will only run on Microsoft Power-point for windows or Apple. It will not run on other ppt viewers.
A Blockbuster style quiz game. This is the restricted free version the full paid for version has over 1000 questions targeted at building up the vocabulary of A Level Biology students. All question revealing, answer revealing, changing of hexagon colours, scoring, identifying a winning run and assigning hexagons a random letter are carried out AUTOMATICALLY by the game, all you need to do is click on the screen.
This restricted version is limited to 5 moves per game and 5 questions from each letter.
The full version allowing full games and over 1000 questions of this evaluation quiz can be downloaded from:
https://www.tes.com/teaching-resource/a-level-biology-vocabulary-technical-term-quiz-based-on-blockbusters-12230069
The quiz automatically displays questions and answers and changes the selected letter hexagons from yellow to blue and white and totals the scores for each team.
The quiz will also automatically identify when a team wins by achieving complete run from left to right for blue and from top to bottom for white.
Each game consists of 8 rounds with the winning team’s score for each round being shown on a scoreboard. Though you can play single rounds if you want to.
Each time a new game is played the positions of the letters on the Blockbusters board are randomised as are the questions chosen from a bank of over 1000 technical terms appropriate for A Level Biology.
The games follow the basic rules of the iconic 1980-1990s Blockbuster TV show.
By using the games during your teaching or as a part of a revision programme, it will allow pupils to gain familiarity with the terms and be able to recall them more easily in their exams.
This quiz uses macros to carry out the automated functions which you select to run on first opening the power point, so will only work with Microsoft Windows and Apple versions of Power Point and not with other ppt viewers.
A Blockbuster style quiz game. Has over 1000 questions targeted at building up the vocabulary of A Level Biology students. All question revealing, answer revealing, changing of hexagon colours, scoring, identifying a winning run and assigning hexagons a random letter are carried out AUTOMATICALLY by the game, all you need to do is click on the screen.
A free restricted evaluation version of this quiz can be downloaded from:
https://www.tes.com/teaching-resource/a-level-vocabulary-technical-terms-blockbuster-style-quiz-free-evaluation-version-12230087
The quiz automatically displays questions and answers and changes the selected letter hexagons from yellow to blue and white and totals the scores for each team.
The quiz will also automatically identify when a team wins by achieving complete run from left to right for blue and from top to bottom for white.
Each game consists of 8 rounds with the winning team’s score for each round being shown on a scoreboard. Though you can play single rounds if you want to.
Each time a new game is played the positions of the letters on the Blockbusters board are randomised as are the questions chosen from a bank of over 1000 technical terms appropriate for A Level Biology.
The games follow the basic rules of the iconic 1980-1990s Blockbuster TV show.
By using the games during your teaching or as a part of a revision programme, it will allow pupils to gain familiarity with the terms and be able to recall them more easily in their exams.
This quiz uses macros to carry out the automated functions which you select to run on first opening the power point, so will only work with Microsoft Windows and Apple versions of Power Point and not with other ppt viewers.
A Blockbuster style quiz game. This is a free evaluation version that has been limited to one game topic and only 5 moves. the full paid for version is unrestricted.
The full version can be found at:
https://www.tes.com/teaching-resource/aqa-gcse-biology-blockbuster-vocabulary-reinforcement-revision-quiz-12228147
Has 9 games each focusing on a different module of technical terms that fit in with the AQA GCSE Trilogy & Triple Biology specification.
The quiz automatically displays questions and answers and changes the selected letter hexagons from yellow to blue and white and totals the scores for each team.
The quiz will also automatically identify when a team wins by achieving complete run from left to right for blue and from top to bottom for white.
Each time a new game is played the positions of the letters on the Blockbusters board are randomised.
Each of the 9 games focuses on 20 technical terms. You can easily edit the questions and answers to suit the ability of your pupils.
The games follow the basic rules of the iconic 1980-1990s Blockbuster TV show.
By using the games during the teaching of a module or as a part of a revision programme, it will allow pupils to gain familiarity with the terms and be able to recall them more easily in their exams.
This quiz requires macros to carry out the automated functions, so will only work with Microsoft Windows and Apple versions of Power Point and not with other ppt viewers.
A Blockbuster style quiz game. Has 9 games each focusing on a different module of technical terms that fit in with the AQA GCSE Trilogy & Triple Biology specification.
A free restricted evaluation version of this quiz can be downloaded from:
https://www.tes.com/teaching-resource/aqa-gcse-biology-blockbuster-vocabulary-reinforcement-revision-quiz-free-evaluation-version-12228577
The quiz automatically displays questions and answers and changes the selected letter hexagons from yellow to blue and white and totals the scores for each team.
The quiz will also automatically identify when a team wins by achieving complete run from left to right for blue and from top to bottom for white.
Each time a new game is played the positions of the letters on the Blockbusters board are randomised.
Each of the 9 games focuses on 20 technical terms. You can easily edit the questions and answers to suit the ability of your pupils.
The games follow the basic rules of the iconic 1980-1990s Blockbuster TV show.
By using the games during the teaching of a module or as a part of a revision programme, it will allow pupils to gain familiarity with the terms and be able to recall them more easily in their exams.
This quiz requires macros to carry out the automated functions, so will only work with Microsoft Windows and Apple versions of Power Point and not with other ppt viewers.
This is a cut down version of the paid for quiz which has all 22 deal or no deal boxes, automatic scoring for 4 teams and 22 questions.
This free evaluation version has only 6 boxes and 2 teams and 6 questions.
The full paid for version can be found at:
https://www.tes.com/teaching-resource/christmas-quiz-2019-premium-deal-or-no-deal-quiz-12222452
Details for the full versio are below
A Deal or No Deal type power point quiz that automatically randomizes the values of the 22 boxes and will automatically display the scores for each of up to 4 teams.
Divide your group up into up to 4 teams. Each team is assigned a colour. The power point will automatically randomly assign values from 2p to £1500,000 to each box. The 5th slide shows team scores and has a button to jump to the next question.
After each question the answer will be displayed with a jump to the Deal or No Deal boxes. The team that got the question can choose a box, clicking on it will display its value, clicking again allows it to be assigned the team colour. click to the next slide will show the team scores which are automatically updated. The jump to the next question box will also automatically change to show the next question and jump to it.
If no team is able to give the correct answer to the question then once the answer is shown click on the jump to the Deal or No Deal slide and choose a box and click on it so it goes dark blue and it will then not be counted for any of the 4 teams.
When all 22 questions have been answered the show will stop on the score slide, go back to the red boxes slide and click on the reset box to reset all the boxes back to 1-22 and reassigns them with a random value, scores on the score slide will also be reset back to zero and the jump to question box resets back to question 1.
The Christmas quiz has 22 questions. You can modify the questions and answers by clicking on and editing their text box contents, but remember DO NOT delete any slides or reorder them, doing so will stop the automation from working.
The slide show uses macros; small pieces of code which enables the automation. You MUST enable macros when opening the slide show for the first time, if they are not enabled then the automation will not work. Due to the use of macros the slide show will only work with Microsoft for Windows and Microsoft for Apple version of Power Point and will not work with other slide show presenting software.
A Deal or No Deal type power point quiz that automatically randomizes the values of the 22 boxes and will automatically display the scores for each of up to 4 teams.
got to the link below to try a cut down evaluation version.
https://www.tes.com/teaching-resource/christmas-2019-quiz-deal-or-no-deal-free-evaluation-version-12224425
Divide your group up into up to 4 teams. Each team is assigned a colour. The power point will automatically randomly assign values from 2p to £1500,000 to each box. The 5th slide shows team scores and has a button to jump to the next question.
After each question the answer will be displayed with a jump to the Deal or No Deal boxes. The team that got the question can choose a box, clicking on it will display its value, clicking again allows it to be assigned the team colour. click to the next slide will show the team scores which are automatically updated. The jump to the next question box will also automatically change to show the next question and jump to it.
If no team is able to give the correct answer to the question then once the answer is shown click on the jump to the Deal or No Deal slide and choose a box and click on it so it goes dark blue and it will then not be counted for any of the 4 teams.
When all 22 questions have been answered the show will stop on the score slide, go back to the red boxes slide and click on the reset box to reset all the boxes back to 1-22 and reassigns them with a random value, scores on the score slide will also be reset back to zero and the jump to question box resets back to question 1.
The Christmas quiz has 22 questions. You can modify the questions and answers by clicking on and editing their text box contents, but remember DO NOT delete any slides or reorder them, doing so will stop the automation from working.
The slide show uses macros; small pieces of code which enables the automation. You MUST enable macros when opening the slide show for the first time, if they are not enabled then the automation will not work. Due to the use of macros the slide show will only work with Microsoft for Windows and Microsoft for Apple version of Power Point and will not work with other slide show presenting software.
Quickly create weekly science equipment requisitions which can be automatically printed or emailed to your technician with the click of a single button.
The spreadsheet uses macros to automate functions and so will only run with the Windows version of excel.
Automatically creates a timetable with the number of lessons per day to suit your needs with the click of a single button.
A blank master timetable is created which you populate with your groups and room numbers where groups or locations can be colour coded.
The spreadsheet copies the blank timetable to create new weekly timetables which are date stamped with a single click of a button. Scrolling to the right of these weekly timetables allows previous weeks requests to be seen and if necessary requests can be copied and pasted into the current/upcoming week. This enables a record of experiments to be kept and speeds up creating future requests.
Once the current week’s request information has been entered it can be easily printed out to automatically fill a complete A4 landscape page again with the click of a single button.
The current/upcoming week’s request sheet can be emailed to your technician with a single click of a button. The email includes an attached spreadsheet titled with your name and the week date that contains your current week’s requests.
Macros must be enabled for the spreadsheet to run.
A helpfile for the paid for spreadsheet to track English Reading and Writing skills and word document available at:
https://www.tes.com/teaching-resource/english-reading-and-writing-skills-tracker-and-reporting-to-parents-document-12075019
9 Reading and 9 Writing skills are tracked for each pupil. Teachers grade pupils upon a 1-4 point scale, each skill can be assessed up to 10 times in an academic year.
The reading skills are: Read aloud with fluency, Comprehension, Language Terms, Structure Terms, Analysing Language, Analysing Structure, Relevant Quotations, Comparison, Response to Task
The Writing skills are: Vocabulary Choices, Spelling -Common words, Spelling -Complex words, Clarity, Structural devices, Punctuation between sentences, Punctuation within sentences, Varied Sentences, Handwriting
The spreadsheet will then generate a graded comment upon each skill for each pupil to go into a mail merge document which can be sent out to parents.
Data from SIMS can be entered upon teaching group, forename, surname, Target Level, OPT Level at end of Key Stage, Gender, PP (Pupil premium status), MA (More able status), SEN status, reading and writing scores and reading age upon entry.
The spreadsheet uses macros (Will only work with Microsoft Excel for Windows) that automatically sort with the click of one button pupil data to be sorted by cohort or by teaching group alphabetically, by target Levels, OPT Levels, Reading criteria, Writing criteria, reading age upon entry. This is useful if you or your staff are not very familiar with spreadsheet commands.
The Word document included allows a mail merge to be carried out from the spreadsheet data to produce cohort and group reports which pupils can self evaluate to identify their strongest and weakest skill areas, what is interfering with their progress and how they can make improvement in the future. These documents can be used to show progression over time, aid closing the gap meetings, show intervention strategies in performance management meetings.
Includes: a fully detailed instruction/help power point, the tracking spreadsheet, the mail merge word document