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 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

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.

Save time and effort writing report cards. A report card writing assistant allowing you to automatically create termly or yearly student report cards from a statement bank. Quickly and easily create a report by selecting statements with a click from 18 statements in each of 9 categories (162 statements in all) to build up a complete report comment, all of which will automatically adjust gender pronouns (he/she etc) and insert the students name where appropriate. Comments can also be free typed in the report comment box. All the statements in each category can be customised by the user. A class list with the gender of the students can be inserted and the final report comments can be copied and pasted into any other report package and the overall class comments saved to an xls file for archiving. The spreadsheet uses macros and will require macro access to be enabled, see the help sheet in the spreadsheet for details how to do this.   Rd see a demo at https://youtu.be/7rNxxekoUpk Have a look and download the free evaluation version at https://www.tes.com/teaching-resource/report-writer-free-evaluation-version-11751250 Please note this spreadsheet will not run on Mac versions of Excel, it will only run on PC versions of , due to incompatibility issues between Microsoft Office on the 2 different platforms.

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.

Enter up to 22 phrases to automatically generate a hexagon sheet with the terms randomly arranged. Pupils can then cut out the phrases and then sort them into logical groups. Will also allow you to enter 11 different terms and their definitions which are then automatically randomly assigned to the hexagons sheet which can be printed out so that pupils can then cut them out and match up the terms with their definitions. Good for reinforcing vocabulary and the definitions of terms also to make links between terms. Suitable for all subjects and ages

A power point presentation upon nerve cells, the formation of the resting potential, how an action potential is produced when an impulse is transmitted along a neurone. How the message is carried on to a 2nd neurone by the synapse. All processes are demonstrated using animations to show the movement of positive ions by active transport, the opening/closing of gates, the movement of vesicles and neurotransmitter molecules in the synapse. Suitable for A Level Biology students. A sample video of the ppt is available at https://youtu.be/SDckofymhC4 The version you purchase will not have the Biology Store watermark banner

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.

A series of powerpoints and a pdf document showing the steps involved in aerobic respiration. The 1st powerpoint goes through each process step by step for aerobic respiration. The 2nd powerpoint shows animated diagrams for each step showing the movement of molecules and how molecules change during each step, all with accompanying explanations. The pdf shows step by step the reactions that occur during aerobic respiration, covering glycolysis, the link-reaction, the Kreb’s citric acid cycle and the electron transport chain. Suitable for A Level Biology.

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.

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.

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.

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.

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 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 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.

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

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. 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.