Maths Teaching Resources from
Oaks Park High School
Mathematics Department
A Specialist Music College (September 2006)
|
Maths Teaching Resources fromOaks Park High School |
A Specialist Music College (September 2006) |
|
| Name | Details | File |
|---|---|---|
| Key Stage 3 SATs Analysis Suite v 1.0 | Populate with Year 9 pupil data from SIMS or similar, add Maths Sets and SATs Entry Tiers, then enter pupil raw scores from SATs. Package calculates pupil NC level & sublevel, gives analysis of year group (e.g. % L5+ or %L6+), allows instant viewing of pupils in a given set of criteria via filters (e.g. all those in either Set 2 who achieved a 7) and enables easy investigation by gender, ethnicity, teacher assessment, KS2 baseline, maths set, free school meals etc via pivot tables. As my own Head responded, "So what percentage of left-handed Sri Lankan girls achieved a Level 6b?" | Excel workbook |
| Key Stage 3 SATs Analysis Guide | Documentation for above with screen shots. Prepared for Redbridge Leading Maths Teachers meeting, June 2006. | Word document |
| Optional Test Analysis Yr 7 Levels 4-6 (2008) UPDATED!! | Enter pupil names on first tab, then enter marks by question (as 1 or 0) for each paper. Last tab summarises all data in a colour-coded class table (Gold = strength, Blue = on target, Grey = area for development / target). Teacher can view class trends as well as individual performance. Mark is converted to sub-level for each child for easy comparison with KS2 data. Whole page can be printed off for parents' evening, report writing, next year's teacher etc. Another use might be a mail merge for individual pupils to stick their Maths targets into their school planners. Each question is coded according to the Framework objective it assesses, so these can simply be edited if a different assessment is being used. |
Excel Workbook |
| Progress Tests Yr 7 Levels 3-5 (2006) |
The file above already edited to match the 2006 Progress Tests for Year 7. | Excel Workbook |
Optional Test Analysis Yr 8 Levels 4-6 (2008) UPDATED!! |
Edited for Yr 8 (4-6) | Excel Workbook |
Optional Test Analysis Yr 8 Levels 5-7 (2008) UPDATED!! |
Edited for Yr 8 (5-7) | Excel Workbook |
Course Component Calculators |
Using this tool, students can see the effect of all the various components (strands in each piece of coursework plus scores in both papers) as they count towards the overall mark. By moving the sliders, the student can set personal targets for each part in order to aim for the desired overall grade. | 3 Excel Workbooks: |
| All Key Stage 2 and Key Stage 3 (Yrs 3 - 9) Analysis for 2006 | Analysis Spreadsheets for all the Optional Tests (Years 3, 4, 5, 7 and 8) and the SATs (Years 6 and 9, all tiers) have now been commissioned and completed for the London Borough of Redbridge. They include new features such as the automatic entry of a sample class and an age-standardised score calculator. Please use the Redbridge Team Page or direct from here: Y3_Opt_2006; Y4_Opt_2006; Y5_Opt_2006; KS2_2006; Y7Progress; Y7Optional; Yr8Opt46; Yr8Opt57; 2006SATS35; 2006SATS46; 2006SATS57; 2006SATS68 |
Contact Nikki Martin (KS3 & 4) or Paula Murray-Mower (KS 1 & 2) at Lynton House for details. |
| Instructions for Using Excel to handle Grades and NC Sub-Levels | A collection of three worksheets which take you through the process of building a functioning markbook which can convert scores to grades/levels and highlight results based on progress or attainment. | |
| Name | Details | File |
|---|---|---|
| Twenty Questions | Teacher enters a word or number which the pupils have to guess using no more than 20 yes/no questions. Word/number can be entered while pupils watch the screen since it remains hidden while being typed. Pupils ask the questions and the program magically appears to give the appropriate response (Yes/No) whenever the teacher clicks on the button. How does it know? "It can hear you!" Point system based on questions asked and guesses made. Program keeps track of number of questions asked and current high score. |
NB Contains macros |
| Su Doku Solver | Enter the 9x9 Su Doku from the paper and use the buttons to guide you to the solution. The program can be used either to tell you which number to enter next or to solve the puzzle completely. Features Reset button and four memories for solving extra-hard Su Doku. | Excel Workbook
NB Contains macros |
| Baked Bean Sim | You are in charge of quality assurance at the baked bean factory. During one shift you have to try to get ten successive batches out within the specified tolerance, even though the machine has a built-in random drift from the desired mean. Reset the machine to start again. As the QA inspector you then have to judge the right settings for mean (fill volume) and s.d. (production speed) in order to minimise the percentage rejected without sacrificing output/profit. Used to illustrate Quality Assurance as part of GCSE Statistics. Introduces Normal Distribution function in Excel to generate realistic Normal samples. |
Excel Workbook
NB Contains macros |
| Quadratics and Factors | A simple illustration of macros and buttons. As it stands, two linear expressions are multiplied to give a quadratic. Endless generation of new examples. Either the quadratic or the two factors can be hidden for pupils to guess. Reveal button allows checking. Once you see how easily this is all done you will want to create your own similar hide/reveal/generate projects. | Excel Worksheet
NB Contains macros |
| Mathemagic | My compilation of Mathematical Magic tricks with emphasis on class use. Written for delegates at local inter-borough Maths Week in July 2005. | Word Document |
| Magic Total | Spreadsheet generates and prints pages and pages of different 4x4 squares, a unique one for each child in the class. Try as they might, each child's four-number total is always 76, as you predicted. This trick is documented in the book above under "Total Disbelief". The magic total can be altered by simple tweaking of the code within. | Excel Worksheet
NB Contains macros |
| Tables Grid | Click the buttons to generate multiplication table practice grids, ideal for pre-lesson warm-ups. Either work them out yourself or else generate and print off the answer grid. | Excel Worksheet
NB Contains macros |
| Yummy Flakes | Used to illustrate Simulation in GCSE Statistics. Inside every promotional packet of Yummy Flakes Cereal is a plastic Yummy Bear. There are six differently coloured Yummy Bears to collect, but the colours are not equally likely. How many boxes of Yummy Flakes does Mummy have to buy? Spreadsheet runs the simulation with the click of a button and displays the number of trials needed each time. Probabilities associated with each colour can be edited and the effect noted. *Improved version uses VBA to run 50 simulations automatically and to record the results as it goes. Displays increasing number of trials and cumulative mean. |
NB Contains macros NEW! *Improved version Excel VBA Worksheet |
| BMI Calculator | Developed for the use of the school staff "Target 25" Club. Simple interface to help the user work in either Imperial or Metric to find both their BMI and their ideal weight. (Healthy adult BMI is 20-25; >25 is Overweight; >30 is Obese) | Excel Worksheet |
| Dice & Spinners | Excel VBA Dice & Spinner Simulations. Either use as an example of simulating dice rolls, or as a simple guide to Excel VBA Programming. Fully-commented code makes it easy to follow and adapt. To access the code go to Tools - Macro - Visual Basic Editor then double click on one of the Sheets in the Project window. | Excel Worksheet contains VBA macros |
| Arithmetic Machine | Excel spreadsheet used as a training exercise in macros, sliders, spinners and buttons. Your choose the two numbers, then ask the machine to add / subtract / multiply / divide them. Quite fun! | Excel Worksheet
NB Contains macros |
| Name | Details | File |
|---|---|---|
| KS4 Markbook | Holds all the pupil info, end of year data since Yr 6, candidate numbers, etc. Sheet takes the test marks, automatically grades them from A* to U (according to your thresholds), keeps track of the Coursework Portfolio and finds the total of the best strands to give the coursework total for the OPTEMS. | Available on request |
| Stock Ordering | Each tab is for a different supplier. Tabs for GLS, Tarquin, Fredrik Johnson provided as examples. Enter the order required. Spreadsheet calculates item cost and keep a running total. Can contain email links direct to suppliers or else be printed out to staple to purchase orders. | Available on request |
| KS3 Data Manager | Each set in the lower school has its own tab. The file is kept on the staff network. Each tab gives the full class list, complete with KS2 data, CAT scores, SEN info, UPN, DOB, etc. as well as previous end of year results for Yrs 8 and 9. After tests each member of the department enters the raw scores for their group(s). The KS3 Coordinator configures each page (in advance) so that these raw scores are immediately converted to sublevels. Conditional formatting can highlight highs and lows by suitable colouring. |
Available on request |
| Long Term and Medium Term Plans | Schemes of work and other planning documents created for GCSE Statistics (1389), 3-Tier Linear Maths (1387) and the new 2-Tier Linear Maths (2540), plus full resources for Key Stages 3 and 5 | Available on request |
| Edexcel Coursework | Two guidelines provided by Edexcel, each with content exemplification and elaboration of marking guidelines | |
| 1387 Specification (3-Tier) |
The old 1387 specification document (Linear) | Specification 1387 |
| 1387 Scheme of Work | This huge thing breaks it down into convenient modules. Your own Dept SoW will presumably choose the order of these modules if different. | 1387 SoW |
| Formula Sheet | Single sheet pdf documents - could be posted in dept websites for students. These are the old 3-Tier versions. | |
| Student Guide | Short guide explaining "Why Maths" and "Why Edexcel" | Guide |
| Understanding UMS | Does exactly what it says on the tin. | UMS Guide |
| New Specification (2-Tier) |
Available in two flavours: Modular and Linear | |
| 2-Tier New Material | What's new to Foundation Tier? What's new to Higher Tier? You are just one click away from knowing the answer... |
|
| Specimen papers And Mark Schemes (SAMS) | Big document from Edexcel. Zipped-idoodah. | |
| SEF Questionnaire | We sent out this questionnaire to all pupils / parents to help us in the preparation of the Maths Self Evaluation Form. It was later heavily quoted by OFSTED. | Word Document |
| Questionnaire Analysis | No self-respecting Maths Department would do a survey without crunching the data afterwards! Here's the Excel Worksheet we used to input, filter and analyse our data within an inch of its life. | Excel Worksheet |
Excel programming by Stephen Froggatt (Head of Maths)
Thanks to Nikki Martin (Redbridge Maths Consultant) for the AFL ideas. Contact me during school time or out of hours with comments/questions. |
  |