14Uploads
5k+Views
1k+Downloads
Chemistry
Excel Prep-Req sheet
Science practical ordering and tracking through Excel. No online sign up, no writing your classes each week or printing them off, no more lost paper or crossing out, and no more practicals going out twice or not being collected. Just a simple, well-designed prep sheet for Science departments everywhere. Please see the images for more information and help notes are included in the file.
This spreadsheet has a named tab for each member of staff where they enter their timetable and requests. This version caters for up to 12 staff, 5 working days and up to 6 periods per day - tell me if your needs are different. Once class names, rooms and sizes have been entered, the master can be kept safely and a copy made available for each week until the technician deadline.
Features include:
1. Resource tracking: know whether a practical is being prepared or ready to go, preventing duplication.
2. Risk assessment: flag unusual practicals and confirm staff have risk assessed each one.
3. Weekly summaries: printable documents for technicians and HoDs.
4. At home access: make the spreadsheet available online. HoD overview of the week ahead.
5. Copy and paste this standard format to create a school practical bank.
The aim is for ease of use with as few formulae and complexities as possible - it has worked in my schools so far!
I hope it is useful for you and if it is please leave a positive review below to help others find it.
Assessment overview (Editable)
A test summary page to guide students (and teachers) to understand the reasons behind the marks the students are getting, organise their next step intervention and to provide a teaching monitoring point. Parts are completed before and after each test. In addition, this sheet works well on A5 and can be stuck into books as a record while the test is stored elsewhere.
This is the Word version, which can be edited. A PDF version is also available for a lower price.
Assessment overview (PDF)
A test summary page to guide students (and teachers) to understand the reasons behind the marks the students are getting, organise their next step intervention and to provide a teaching monitoring point. Parts are completed before and after each test. In addition, this sheet works well on A5 and can be stuck into books as a record while the test is stored elsewhere.
This is the PDF version, which cannot be edited. An editable Word version is also available for a slightly higher price.
9-1 GCSE Science Assessment Matrix (9-1)
Student and teacher versions of a generic GCSE Science assessment matrix.
Created to allow teachers and students to make judgements about work in the 9-1 system based on the current OfQual information that I have interpreted to give greater depth. Divided into 4 areas (Knowledge and Understanding, Mathematical Skills, Data Analysis and Evaluation Skills), the grid allows for peer assessment and the setting of targets after test results.
A linear flight path from Yr7 is also included but can be easily deleted if not required.
Tell me of any issues and I'll try to fix them asap.