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

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.

Produces tests each consisting of 16 questions. Will automatically insert new numbers each time the sheet is updated. Produce a new test with ONE click of a button. Will produce tests that work upon the following areas: Addition Subtraction Multiplication Division Mixed ±/ Decimals Fractions (±/) Percentages Will print out the test sheet on the 1st page and the questions with the answers on the 2nd page.