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.

Interactive powerpoint and spreadsheet to demonstrate and calculate the following statistical functions required for A Level Biology: Standard Error Standard Deviation Chi-Squared for ecological studies Chi-Squared for phenotype ratios Student’s t-test for unpaired data Student’s t-test for paired data Spearman’s Ranked Coefficient of Correlation Where degrees of freedom and p=0.05 confidence levels are used they are automatically calculated from the inputted data and an indication is shown as to whether a null hypothesis for the data is to be accepted or rejected. The power point goes step by step through each statistical test, describing how to use it, how to calculate each one and what the results mean. The work sheet contains exam style questions and answers upon chi-squared which is covered with a step by step explanation at the end of the power point. A watermarked preview video if the ppt can be found at https://youtu.be/1LcW3EO0MpU

NEW AND UPDATED A tracker for monitoring student progress in the new AQA A Level Physics required practical tasks for the CPAC skills INCLUDING THE SUB COMPETENCIES The tracker will monitor attendance for each student. Monitor the attainment of CPAC skills for the students in each RP activity. Produce a print out showing the individual performance of each student showing the CPAC skills they have acquired from each RP activity. Trackers for Biology and Chemistry are also available

A tracker to record up to 20 separate test results and provide an analysis of the results. Caters for grades A-E, so is suitable for any A Level subject. Entering grade boundaries for each test the tracker will calculate %'s and show the grades for each student, their ranked position and a summary of all their test results and position overall in their teaching group. Allows up to 40 students to be tracked at a time. Individual student summary page can be produced that can be used when mentoring students or for parent evenings, showing their progress over the year.

NEW AND UPDATED A tracker for monitoring student progress in the new AQA A Level Biology required practical tasks for the CPAC skills INCLUDING THE SUB COMPETENCIES The tracker will monitor attendance for each student. Monitor the attainment of CPAC skills for the students in each RP activity. Produce a print out showing the individual performance of each student showing the CPAC skills they have acquired from each RP activity. The tracker can be modified to match the RP activities for Chemistry and Physics by changing the RP titles and use of apparatus criteria on the Titles sheet.