Hero image

Harret's Shop

Average Rating3.71
(based on 156 reviews)

I am a science teacher in Liverpool and have been head of department and senior leadership. I have put resources on here that I know will be beneficial to both individual teachers and middle managers. I'm aware of the time constraints and the resources are to reduce workload as well as inform.

79Uploads

89k+Views

234k+Downloads

I am a science teacher in Liverpool and have been head of department and senior leadership. I have put resources on here that I know will be beneficial to both individual teachers and middle managers. I'm aware of the time constraints and the resources are to reduce workload as well as inform.
Formative Assessment Analysis & Mail Merge Report Generator
harretharret

Formative Assessment Analysis & Mail Merge Report Generator

(0)
I have created an assessment analysis tool that can be used for any test up to 20 questions in length. The Excel sheet is primarily designed for science but could be redesigned for other subjects. A sheet is used to enter the year, title, question type, question marks and question description. The % at which levels are given can be changed to suit the year, assessment test in question. All of these will be used to generate a report. The report will have individual information about a students progress in the test. The data generated will be - Total, %, Residual, Level (9-1), Levels of Progress and Progress label. Depending on how well students did for individual questions, the report will highlight which areas (where a student achieved 50% or less of the marks available) students need work on to get them to standard. The test is broken down into the individual science aspects so that staff, pupils and parents can be aware of the strengths and weaknesses of individuals so that areas can be addressed where the standard is below what is expected. TO SEE WITHOUT PAYING - you can download the instructions. I have attached the instructions for the sheet that shows how the sheet works and examples of the generated Mail Merge report. This sheet will not only inform staff, pupils and parents but save time for the staff and be an invaluable tool in identifying areas to help pupils reach their targets.
AQA Science Additional 2014 Higher Paper Analysis Tool
harretharret

AQA Science Additional 2014 Higher Paper Analysis Tool

(0)
This AQA Additional Paper Analysis Tool will collate the 'mock' results and using the actual grade boundaries will give a grade for a) the whole paper, b) individual grades for the Biology, Chemistry and Physics aspects and c) will show the levels of progress the student has made. This has been invaluable as a monitoring and intervention tool to target individuals and classes that are falling behind. The screen shots to see how this looks when populated can be downloaded free from my page.
GCSE PHYSICS - Learning the SPEED Equations
harretharret

GCSE PHYSICS - Learning the SPEED Equations

(0)
Since the declaration that GCSE Science pupils wont be able to use equations sheets in future exams, I have been thinking of a system that will help them learn the equations and help staff in facilitating that learning. I have devised this. It is supposed to be used as a starter / plenary for pupils to go over and over and try to implant the equations over time. I will use it in every lesson, parrot fashion for success! This is not board specific as they all will need to learn them, and can be used for the current legacy GCSE students too as a revision resource. This is the full PowerPoint, but a free demo version only has the questions for 'Acceleration' questions, but you will get a good idea of what the paid product will be like. The GCSE PHYSICS Speed Equations full can be found in my store. It has questions on SI Units Questions, Speed/Distance/Time (v=d/t), Acceleration (a=v/t), Force?mass?Acceleration (F=ma), Kinetic Energy (1/2 m v^2), Wavelength/Frequency (v=ƒ λ) and Momentum (p=mv) HIGHER TIER Only. There are another demos and full powerpoints on Energy Equations and Electricity Equations on my page. I have used the template for my ABCD cards for this endeavour, but you don't need those to utilise these PowerPoints. Enjoy.
Biology INTERDEPENDENCE Bundle
harretharret

Biology INTERDEPENDENCE Bundle

7 Resources
This is a bundle of 7 lessons that can be used in part or whole to teach the biology topic of interdependence in animals and plants. These lessons are not board specific and can be used (dependent on ability) from KS3 and KS4. Lesson 1 - Interdependence & Biodiversity Lesson 2 - Sampling Plants (Quadrats) Lesson 3 - Abundance of Animals (sampling techniques) Lesson 4 - Competition in Animals Lesson 5 - Competition & Adaptations in Plants Lesson 6 - Adaptations in Animals Lesson 7 - Predator Prey Population Graphs Each lesson has a interactive PowerPoint that has a starter and comprehensive explanations that will allow for questioning and discussion. There is a pupil worksheet (both in Publisher for editing, and PDF forms). The worksheet mirrors what has been taught in the lesson. There is a question (and a mark scheme) that can be used to consolidate the learning in the lesson or as homework. The lesson is labeled in the CLF (common lesson format) so pupils are aware of what that section is about.
6 Film Picture Quizzes in 1 Interactive PowerPoint
harretharret

6 Film Picture Quizzes in 1 Interactive PowerPoint

(0)
This PowerPoint has 6 film picture quizzes (with answers) and interactive format that allows you to go back and forth to the different quizzes in any order you want. The 6 categories are Comedy Films Action Films Horror Films Superhero Films Animated Films Sci-Fi Films Great for end of year class fun, in the classroom and virtually over Zoom / MS Teams or with the family.
AQA Science Additional 2014 Foundation Paper Analysis Tool
harretharret

AQA Science Additional 2014 Foundation Paper Analysis Tool

(0)
This AQA Additional Paper Analysis Tool will collate the 'mock' results and using the actual grade boundaries will give a grade for a) the whole paper, b) individual grades for the Biology, Chemistry and Physics aspects and c) will show the levels of progress the student has made. This has been invaluable as a monitoring and intervention tool to target individuals and classes that are falling behind. The screen shots to see how this looks when populated can be downloaded free from my page.
Splitting or Merging Pupils Names for Excel Spreadsheets
harretharret

Splitting or Merging Pupils Names for Excel Spreadsheets

(0)
If you get lists in different name formats - Joe Bloggs or Bloggs, Joe or Joe in one column and Bloggs in another column... and its sends you out of your mind as you want them all in the same format, then this little tool will do it for you. Copy the list of manes in the format you don't want and use the tool to split or merge the names to your preferred format and then re-paste the list. Dead easy and will save you tons of time not to mention your sanity.
AQA GCSE Science Required Practical Tracker Instructions
harretharret

AQA GCSE Science Required Practical Tracker Instructions

(1)
I have put together a complete system of resources that will allow staff to easily record and monitor the required practical aspect of the new GCSE science that is replacing the old ISA coursework. The resources include Whole Class Practical Tracker, Pupil Cover Sheets for Each of the Practicals and an 'On-The-Day' Practical sheets (again one for each practical, for the teacher to use in class during the practical to record the Apparatus and Technique (AT) skills that each pupil has to be competent with. All of the resources compliment each other, use the key coding for assessment to reduce workload and make things easy. This is just the instructions with some screen shots to see what and how it works. I have mirrored the A'Level AQA Practical Assessment for the AQA GCSE, it just seemed logical so that the systems are similar. The resources outline will be bundled together and can be purchased from my store page. Enjoy.
GCSE Physics - ELECTRICITY Equations PowerPoint - FREE Demo
harretharret

GCSE Physics - ELECTRICITY Equations PowerPoint - FREE Demo

(0)
Since the declaration that GCSE Science pupils wont be able to use equations sheets in future exams, I have been thinking of a system that will help them learn the equations and help staff in facilitating that learning. I have devised this. It is supposed to be used as a starter / plenary for pupils to go over and over and try to implant the equations over time. I will use it in every lesson, parrot fashion for success! This is not board specific as they all will need to learn them, and can be used for the current legacy GCSE students too as a revision resource. This demo only has the questions for 'Resistance' questions, but you will get a good idea of what the paid product will be like. The GCSE PHYSICS Electricity Equations full can be found in my store. It has questions on Units Questions, Resistance (R=V/I), Power (P=E/t), More Power (P=IV), Even More Power (P=I^2 R), and Electrical Energy (E=VQ). There is another demo and full powerpoint on Energy Equations on my page. I have used the template for my ABCD cards for this endeavour, but you don't need those to utilise these PowerPoints. Enjoy.
AQA AS Biology Quick Quizzes - All Sections - Free Demo
harretharret

AQA AS Biology Quick Quizzes - All Sections - Free Demo

(1)
This is a free demo of the 29 quick quizzes I have compiled for the AS AQA new Biology course. Each quiz has 10 questions of varying difficulty and then the answers. The paid version of the PowerPoint contains 29 quizzes spanning the whole AS course with questions and answers and an integrated results sheet to record the results from your class and a handy macro will rank them in order depending on their average through the quizzes. From the menu screen you can skip to any quiz and return back to the menu. Great for starters, plenaries and revision throughout the year. This demo will give you an idea of the quality of what you will get.
New Grade (9-1) GCSE Tracker (Screen Shots)
harretharret

New Grade (9-1) GCSE Tracker (Screen Shots)

(0)
These are screen shots to explain the new GCSE grade 9-1 tracker. I have designed it so that it can be edited and changed so that it can be used in any subject. The sheet has space for 250 students to be housed. This sheet is your one stop place to track your GCSE class data. The sheet are 12 custom tests (which you can change the raw score and label) and 3 summative tests - these are collated to give an average and an old grade (A*-G) and the new GCSE grading system (9-1) along side each other AND the level of progress. The sheet will calculate the %, grades (old and new), averages and levels of progress.The tests are grouped into three sections (4 tests in each) so - science (Biology, Chemistry, Physics) or English (Written, Literature, Creative) etc. There are 3 Monitoring areas that you can record scores that go towards the whole school data - if this data is below the levels of progress then it will flag the possibility of intervention. Parts of the sheet are protected so that staff can only add their raw data and not accidentally enter where there are formulas that generate supplementary data. The sheet comes with instruction and the password to unlock locked areas of the sheet should you wish. The actual sheet can be purchased from my page.
AQA Physics A' Level Assessed Practical Tracker (Better and Improved)
harretharret

AQA Physics A' Level Assessed Practical Tracker (Better and Improved)

(1)
I have taken the free AQA Assessed Practical tracker and have improved it. I have added the AT (Assessed Techniques) definitions and added which AT's are assessed for each practical . These marks for the AT's are collated in an overview sheet that shows how each student has performed in each assessed practical but also an overview of how they are doing for each AT. I've tested it and it seems bug free...
AQA Chemistry A' Level Assessed Practical Tracker (Better & Improved)
harretharret

AQA Chemistry A' Level Assessed Practical Tracker (Better & Improved)

(0)
I have taken the free AQA Assessed Practical tracker and have improved it. I have added the AT (Assessed Techniques) definitions and added which AT's are assessed for each practical . These marks for the AT's are collated in an overview sheet that shows how each student has performed in each assessed practical but also an overview of how they are doing for each AT. I've tested it and it seems bug free...
GCSE Physics - ENERGY Equations PowerPoint - FREE DEMO
harretharret

GCSE Physics - ENERGY Equations PowerPoint - FREE DEMO

(0)
Since the declaration that GCSE Science pupils wont be able to use equations sheets in future exams, I have been thinking of a system that will help them learn the equations and help staff in facilitating that learning. I have devised this. It is supposed to be used as a starter / plenary for pupils to go over and over and try to implant the equations over time. I will use it in every lesson, parrot fashion for success! This is not board specific as they all will need to learn them, and can be used for the current legacy GCSE students too as a revision resource. This demo only has the questions for SI units questions, but you will get a good idea of what the paid product will be like. The GCSE PHYSICS Energy Equations full can be found in my store. It has questions on SI units, Gravitational Potential Energy, Kinetic Energy, Efficiency, Power and Specific Heat Capacity. These take some time to make, but I will group the other equations together as I have for the energy equations. I have used the template for my ABCD cards for this endeavour, but you don't need those to utilise these PowerPoints. Be patient, I'm going as fast as I can. Enjoy.
AQA Biology A' Level  Assessed Practical Tracker (Better and Improved)
harretharret

AQA Biology A' Level Assessed Practical Tracker (Better and Improved)

(0)
I have taken the free AQA Assessed Practical tracker and have improved it. I have added the AT (Assessed Techniques) definitions and added which AT's are assessed for each practical . These marks for the AT's are collated in an overview sheet that shows how each student has performed in each assessed practical but also an overview of how they are doing for each AT. I've tested it with my class and it seems bug free...
GCSE PHYSICS - Learning the SPEED Equations - FREE DEMO
harretharret

GCSE PHYSICS - Learning the SPEED Equations - FREE DEMO

(0)
Since the declaration that GCSE Science pupils wont be able to use equations sheets in future exams, I have been thinking of a system that will help them learn the equations and help staff in facilitating that learning. I have devised this. It is supposed to be used as a starter / plenary for pupils to go over and over and try to implant the equations over time. I will use it in every lesson, parrot fashion for success! This is not board specific as they all will need to learn them, and can be used for the current legacy GCSE students too as a revision resource. This demo only has the questions for 'Acceleration' questions, but you will get a good idea of what the paid product will be like. The GCSE PHYSICS Speed Equations full can be found in my store. It has questions on SI Units Questions, Speed/Distance/Time (v=d/t), Acceleration (a=v/t), Force?mass?Acceleration (F=ma), Kinetic Energy (KE = 1/2 m v ^2), Wavelength/Frequency (v=ƒ λ) and Momentum (p=mv) HIGHER TIER Only. There are another demos and full powerpoint on Energy Equations and Electricity Equations on my page. I have used the template for my ABCD cards for this endeavour, but you don't need those to utilise these PowerPoints. Enjoy.
AQA Science ISA Tracker
harretharret

AQA Science ISA Tracker

(1)
This spreadsheet can be used to collate the ISA grades for Core, Additional, Biology, Chemistry and Physics ISA's. The sheet will calculate the grade achieved from the 2015 AQA grade boundaries. It will also do a count to show how many pupils have achieved A* - G in each piece. There is enough space for 250 pupils in the core and additional and 150 for the triple science. The grade the pupil gets will RAG change colour with regard to what their target is. Enjoy and I hope it helps. If you like have a look at some of the other spreadsheet resources I have in my shop.
DEMO - Formative Assessment Analysis Tool and Mail Merge Report Generator - INSTRUCTIONS
harretharret

DEMO - Formative Assessment Analysis Tool and Mail Merge Report Generator - INSTRUCTIONS

(0)
I have created an assessment analysis tool that can be used for any test up to 20 questions in length. The Excel sheet is primarily designed for science but could be redesigned for other subjects. A sheet is used to enter the year, title, question type, question marks and question description. All of these will be used to generate a report. The report will have individual information about a students progress in the test. The data generated will be - Total, %, Residual, Level (9-1), Levels of Progress and Progress label. Depending on how well students did for individual questions, the report will highlight which areas (where a student achieved 50% or less of the marks available) students need work on to get them to standard. The test is broken down into the individual science aspects so that staff, pupils and parents can be aware of the strengths and weaknesses of individuals so that areas can be addressed where the standard is below what is expected. I have attached the instructions for the sheet that shows how the sheet works and examples of the generated Mail Merge report. This sheet will not only inform staff, pupils and parents but save time for the staff and be an invaluable tool in identifying areas to help pupils reach their targets.
AQA Science Additional 2014 Higher Paper Analysis Tool (screen shots)
harretharret

AQA Science Additional 2014 Higher Paper Analysis Tool (screen shots)

(0)
This is screen shots to show what my AQA Additional Paper Analysis Tool looks like when populated. the tool will collate the 'mock' results and using the actual grade boundaries will give a grade for a) the whole paper, b) individual grades for the Biology, Chemistry and Physics aspects and c) will show the levels of progress the student has made. This has been invaluable as a monitoring and intervention tool to target individuals and classes that are falling behind. The actual sheet can be purchased from my page.