Teacher Excel Markbook

Teacher Excel Markbook

This excel spreadsheet can be used to record student's grades. Using a 1-10 system you can record their marks and it will automatically average the grade. If you enter J, K or L in capitals (which is converted into a smiley face) in the effort column it will also average their effort grade. This provides formative feedback and allows progress to be monitored. This is a concept and could easily be adapted for specific use, i.e. Assessment without levels, BTEC etc.
InformingEducation
Lever Theory Worksheet KS3

Lever Theory Worksheet KS3

Two simple documents that can be printed from the PDF files and photocopied so that they can be combined to a single, double-sided WS. It uses several simple tasks that can be used to reinforce the understanding of levers and their everyday application.
InformingEducation
Pupil Premium Case Study (MS Word Template)

Pupil Premium Case Study (MS Word Template)

A three-part Pupil Premium (PP) case study template, fully editable in MS Word. This allows schools to quickly profile the interventions being implemented to support disadvantaged pupils. It has been designed for secondary schools but can be easily contextualised for all stages of education. Each stage has been presented separately on the document but page breaks could be easily removed if you wanted to consoldiate the document. The structure and content has been base upon good practice across public education and in-line with Ofsted expectations. Please use this to profile successful intervention and those less-successful interventions where the school has had less effect due to factors outside of their control.
InformingEducation
D&T Literacy mats - Investigate, design, make and evaluate

D&T Literacy mats - Investigate, design, make and evaluate

Four A3 literacy mats to support students whilst working in D&T. These include words that may be used for tasks in each of the areas of the subject (please note where words apply to multiple areas these are duplicated). The mats also include punctuation that students should use and guidance for a specific task in each area. Investigate - Design specification Design - Annotation Make - Flowchart Evaluate - Evaluation against specification This guidance is provided to support tasks. Sheets are colour coded and can be printed and laminated, PDF file format ensures that these can be easily viewed on mobile devices and through a projector. Easily scaled down or up using Adobe Reader whilst printing.
InformingEducation
Diamond ranking, class monitoring / analysis

Diamond ranking, class monitoring / analysis

Description: An AfL document that allows teachers to monitor a pupil progress over the duration of a lesson, topic or term. Objective: Allows you to monitor a whole class. You can make a comparison between students utilising the diamond ranking system. This could be put on the back of a lesson plan, or put on the board. Assessment: I use the circles to put the initials of students in, or if I am monitoring boys’ behaviour or effort in relation to girls, colours can also be useful. Expectations: This can be used for continuing assessment of a multitude of things.
InformingEducation
Annotating design work

Annotating design work

An easy to follow worksheet that is presented as a simple flowchart. The sheet has been designed to place underneath a student's design sheet on their non-writing side. Two versions are included with both right-handed and left-handed students catered for. The task is divided into three sections; good and bad features, design specification and moral, social, environmental and cultural issues. This provides a prompt that these should be discussed through annotation and does not provide a detailed overview of what these are. These sheet can be easily printed and laminated to be used across a range of ages and even act as a starting point for AS and A2.
InformingEducation
'AQA style' test paper/template for KS3.

'AQA style' test paper/template for KS3.

This is a word file document which has been designed to reflect the current product design/resistant materials existing AQA GCSE exam paper. A series of metal focused questions have been written for KS3 pupils including; H&S, aesthetics, metalworking tools and brazing. However, if you are looking to write your own paper this will also act as a template. It is fully editable with a cover that includes the same information as the GCSE equivalent. This will make it much easier and quicker to author a paper that resembles the GCSE paper. Please note that the layout and style of the template reflect AQA and is most suitable to those working with the exam board. This resource does not use any information from any GCSE questions published by AQA.
InformingEducation
Class monitoring and/or assessment

Class monitoring and/or assessment

Description: A simple spreadsheet that allows teachers and students to monitor their progress over the course of a project. Using a simple two section layout teachers and pupils can see their progress relative to other pupils. Students can easily fill the cell in once they have completed a specific task green, amber to state that it is started and red if they have not started at all. A teacher only document is still being developed. Prior Knowledge: Students need a brief introduction to the interface and how to change the cell colour.
InformingEducation
Brazing sequence drawing

Brazing sequence drawing

This resource provides pupils with a partially completed sequence 'drawing' and a support sheet of photographs. They can identify the correct sequence of tasks, cut them out and stick onto the A3 overview page. Using the keywords pupils can then explain each of the main four stages. This task can be delivered before pupils tackle an exam-style (AQA) manufacturing question where they have to summarise the process of making into four stages using their own notes and sketches.
InformingEducation
Metals and metalworking

Metals and metalworking

Printable worksheets for: Groups of metals Steel properties Metalworking tools and processes Includes one point perspective grid for free!
InformingEducation
One Point Perspective Grid

One Point Perspective Grid

A photocopiable one-point perspective grid which can be enlarged/reduced if needed. Students could draw directly onto the grid or this could be used as an underlay so that they can draw without the limitations of the grid.
InformingEducation
Types of Metals and Steel's Properties

Types of Metals and Steel's Properties

Two worksheets included in this download; steel and its properties and types of metals. Both files are PDFs which will make them to scale up/down and print from either Mac or PC. The worksheets could be used as a starter, plenary, recap or revision exercise. There is no supporting PPT or additional notes provided with the worksheets. However, these have been used extensively and work well in the classroom.
InformingEducation
Applying tone with pencil poster

Applying tone with pencil poster

A PDF poster that can be enlarged easily using Acrobat Reader. The poster uses a simple colour scheme and diagrams to illustrate where to hold the pencil and the angle required to reproduce a range of tones using a single pencil. This is for quick reference or could be used as a handout whilst focusing on technique. The diagrams are illustrative and try to focus pupils on technique rather than outcome. This poster represents the first of a range of posters I wish to make available on TES in the coming weeks/months.
InformingEducation
Classroom 'Exit Card' - AfL, pupil feedback etc.

Classroom 'Exit Card' - AfL, pupil feedback etc.

A simple word document that has six 'exit cards' per page. Teachers can type, copy and paste a question to ask all students to complete as a plenary/mini-plenary to consolidate learning and assess their knowledge and understanding of a term, concept etc. Alternatively this could be used for pupil feedback, self-assessment etc. for the lesson or a learning resource. This simple sheet provides a simple, yet effective method of communication between the teacher and pupil.
InformingEducation
Assessment - Spelling Correction Worksheet

Assessment - Spelling Correction Worksheet

Used as part of a department's formative assessment strategy this worksheet allows teachers or peers to identify up to six words that a student has misspelled. (Any more and multiples sheets can be used.) The 'marker' writes the words in the space provided before issuing to the pupil, who then copy out the correct spelling five times. The sheet can then be stuck into an exercise book to evidence teacher assessment, student progress etc. Printing the sheets onto a coloured paper i.e. green for assessment. This makes them more impactful.
InformingEducation
Teacher assessment, AoL, Summative, AfL

Teacher assessment, AoL, Summative, AfL

Description: Formal way of sharing assessment with the pupils. Not to be used on its own, but in conjunction with other assessment strategies that are already in place. Objective: It should allow teachers to share with the pupil the marks for effort, their portfolio and product, whilst also communicating a target for further improvement. Expectations: Share assessment strategies with the pupils and promote their participation in Assessment for Learning. Hints: Use it in conjunction with other assessment, mark their folio as a whole or as separate tasks. The mark they achieve at the end is an overall grade, similar to what they would be given for GCSE coursework. This allows pupils to identify each task as having relative and equal importance.
InformingEducation
Taboo - Sustainable products?

Taboo - Sustainable products?

Based upon the popular game of Taboo included in this resource are 12 cards of common everyday products. Students work in pairs or could be completed as a starter to guess the product. The focus should be on describing what it looks like, its use of materials, its sustainability, recyclability etc. The words on each card cannot be used by the student describing the product. This is meant to promote discussion and support other tasks, any comments and suggestions would be welcome.
InformingEducation
Guess What - Sustainable products

Guess What - Sustainable products

Based on the popular game 'Guess Who' this card game can be played in small groups. From two packs of cards one student picks a product whilst the group of students with their pack of cards try to identify it. This is achieved by asking questions about the products sustainability, function, use of material, design, aesthetics etc. This is should promote discussion and encourages students to make links between topics.
InformingEducation