Hero image

Captain scarlet's Shop

Average Rating4.04
(based on 67 reviews)

Excel workbooks. and a couple of full lessons

18Uploads

76k+Views

37k+Downloads

Excel workbooks. and a couple of full lessons
Class Assessment/Test Analyser Spreadsheet
captain scarletcaptain scarlet

Class Assessment/Test Analyser Spreadsheet

(4)
Excel spreadsheet which can be used to analyse test results for a class so you can see where to target your revision? Graph shows poorly answered questions. There is a set of example data already in the data set page. This is help, so that you can see how to fill in. To remove the data, highlight and then CLEAR CONTENTS
Kite Graph for Biotic and Abiotic data
captain scarletcaptain scarlet

Kite Graph for Biotic and Abiotic data

(3)
Plot data onto the spreadsheet and get a kite graph out. If you are looking at environmental factors affecting biotic components of an ecosystem, then this template will plot up to 2 abiotic sets of data over the kite. Thus you can see at a glance if the environmental factors are affecting your biotic species. You may plot any combination, eg, pH and light, or ph and moisture, or temperature and light. there are endless combinations you can look at, whilst comparing to your species research.
Plants: Poison in the garden
captain scarletcaptain scarlet

Plants: Poison in the garden

(5)
A brief insight into plants which although very pretty, hide a dark secret. There are many more plants which are poisonous, but I’ve tried to include the most popular. There are also a few which you would never know they could cause illness. You will probably require the music for this, then just link the two files together http://www.tes.co.uk/teaching-resource/Music-for-poison-3007160/ http://www.tes.co.uk/teaching-resource/Music-for-poison-II-3007161/ http://www.tes.co.uk/teaching-resource/notes-for-music-for-poison-in-the-garden-3007159/
House point, Merit accumulator
captain scarletcaptain scarlet

House point, Merit accumulator

(7)
Ever tried to keep track of house points? This sheet is user defined, so if you award prizes for merit points, an easy to see status grid shows how many points are still required for particular prize. User defined, up to 7 prizes can be awarded. Also shows pupils where they stand in the class. Graph shows same details. There is also a handy help page if you get stuck. Can also show pupils with low merits. Can also show pupils with compliments for good work, as well as concern slips. Divided in half termly sections, so setting half term targets is easy. Grid accompanies this to show pupils who have attained the half term target. HAVE FUN
Assessment made EASY  GUIDE
captain scarletcaptain scarlet

Assessment made EASY GUIDE

(1)
GUIDE TO ASSESSMENT MADE EASY This is only a guide, some of the pages are disabled. It does show you though what is obtained from the Assessment made easy spreadsheet. You can then decide if it would be worth downloading it, Especially as you can see the outcome without wasting any of your time .
Assessment made EASY
captain scarletcaptain scarlet

Assessment made EASY

(4)
Easy to use. A guide and fully working sheet. Use defined up to 138 tests assignment or homework, or a combination of all 3. Up to 250 pupils can be added to the sheet. colour code for easy reading. readout for pupils on target or below or above. Space for awards of extra merits. You only have to input the minimal of data. Easy to follow, saves bucket loads of time once the initial data has been input. PLEASE NOTE: There is also available in my resources a guide to show you how to fill in this workbook,
Random letter generator
captain scarletcaptain scarlet

Random letter generator

(0)
Generate a series of random letters 14. Guaranteed at least 2 vowels each time. Can generate up to 32 rounds. Give pupils the challenge, as it nominates certain criteria. Start with, either Red, Blue or black letters. Sometimes an ‘Any’ letter option will be nominated. Sometimes the word has to start with a capital letter. You can allow ‘proper names, as it generates both Upper case and Lower case letters. All totally random. No 2 turns will give the same letters. Divide pupils into teams and score points for the length of words made. Generates 14 letters. Within the sheet are 2 help sheets
The development of the periodic table
captain scarletcaptain scarlet

The development of the periodic table

(4)
Powerpoint and worksheets for the sessions based upon the development of the periodic table. Questions based on the table as you go through the presentation. Tables as a handout can be stuck into books as pupils go through the powerpoint with you. Should take about 1 hour to go through the who presentation, Having taught this topic many times, it is a little dry for the pupils, this presentation tries to make it more interactive and get the students to think.
Music for poison II
captain scarletcaptain scarlet

Music for poison II

(0)
This is the second music file for the power point POISON IN THE GARDEN PLEASE NOTE: Put the file on the slide after the one in the notes page. In other words, this section of music belongs on the slide POTATO OK, THERE WILL BE A COUPLE OF SECONDS DELAY IN IN RUNNING OF THE MUSIC, but it sounds better. Have fun
Revised Money collection sheet
captain scarletcaptain scarlet

Revised Money collection sheet

(0)
Excel sheet to log all payments for trips out. Easy to use. Please note, some of the sheets are password protected. You do not need the password, it is there to protect the calculations behind the sheet. Up to 190 spaces (pupils) Sheet shows how much paid by each pupil and how much is still outstanding. There is also a sort sheet at the back. Will tell you when the trip has been paid in full. Payment made by pupils an be entered in any order, up to 26 payment increments allowed for.
Revised Merit/House point accumulator (version XL5)
captain scarletcaptain scarlet

Revised Merit/House point accumulator (version XL5)

(5)
Sorry people, section for concerns and compliments, not working correctly in the revised version of this sheet. THIS HAS BEEN RESOLVED IN THIS SHEET. Any data already typed into your revised version can but cut and pasted into this one. Keep track of all those house points earned by your form/house/year. Easy to use, set out in 1/2 term sections. room for prizes for certain amount of points. THIS WILL SAVE YOU OODLES OF TIME. ROOM FOR 37 PUPILS ON THE SHEET. on the first sheet, scroll down to row 40+, you will need to fill in a little data there. There are a couple of useful help sheets contained as well.
Kite Diagrams Quadrat sampling  / Graphs template
captain scarletcaptain scarlet

Kite Diagrams Quadrat sampling / Graphs template

(15)
Kite diagram / Graph template This is a very easy to use template, it also contains a couple of easy to follow help pages. It would also be nice if you could comment on the resource. It will only take a couple of seconds, Cheers. Collect data from up to 6 species data types. Enter data, graph plots, Simple. Graphs on 1 sheet for easy comparisons, also 6 large single graphs. See also Kite Graph template, Quadrats, transects sampling + additional plotting of line graph to compare, also available on this TES site, This one plots the kite, as well as being able to plot environmental conditions such as Ph, moisture, light etc. Can be used for both number frequency plots or percentage coverage plots. Version XL5 gives graphs specific for % coverage, whereas the original file had automatic scales. So this would be very good for KS5+ as well as other years. Version SIG has no labels on x axis. REVIEW on this one would be well appreciated.
Revised Merit accumulator / House point Accumulator
captain scarletcaptain scarlet

Revised Merit accumulator / House point Accumulator

(6)
Keep track of all those house points earned by your form/house/year. Easy to use, set out in 1/2 term sections. room for prizes for certain amount of points. THIS WILL SAVE YOU OODLES OF TIME. ROOM FOR 37 PUPILS ON THE SHEET. on the first sheet, scroll down to row 40+, you will need to fill in a little data there. There are a couple of useful help sheets contained as well.NOTE: to users who have downloaded this resource: There is a slight problem with the compliments/concern sheets, (not all work). However, this has been rectified in the resource: http://www.tes.co.uk/article.aspx?storycode=6001851 Revised Merit/House point accumulator (version XL5). Any data already typed into the first version can be cut and pasted into the xl5 version, by simply pasting special, then selecting values