Resource bundle include PowerPoint Presentation, lesson plan and Task Booklet (10 tasks, 15 pp) Importing delimited data Advanced sorting of lists Advanced filtering of lists Pivot tables Formulae and functions: IF and VLOOKUP The PowerPoint presentation will serve as a visual aid during the training, explaining concepts and demonstrating examples. The lesson plan will provide a detailed outline for the trainer, including suggested timings and activities. The task booklet will contain a series of 10 practical tasks with step-by-step instructions and sample data for participants to practice and apply the learned skills. Examples of scenarios covered: Importing records of employees saved as delimited text and sort this list in hierarchical order (Director, Manager, Supervisor…) Using advanced filtering to find invoices; invoice numbers less than 170 and amounts of more than £1,000 excluding Creating and updating a pivot table for a list of people surveyed so that the data items in the pivot table are a count of the people surveyed, organised by town and subdivided into gender Using a Lookup function to search a product code in a table of products and return the description of the product or its unit price, without copying and pasting it. Using the IF function to calculate travel expenses refunds when mileage is differentiated into two different tiers. e.g. Each employee is reimbursed £0.35 per mile for the first 500 miles travelled (Tier 1) and £0.25 thereafter (Tier 2).

Show that 𝑥=−2 is a possible solution of 𝑥^2+9𝑥+14=0 Identify a possible formal method to solve quadratic equations without linear terms in 𝑥, Use simple factorization as a method to solve quadratic equations Expand/multiply out double set of brackets Factorise quadratic expressions as a strategy to solve a quadratic equation (foundation)

Powepoint - Inttroduction to algebra (from words to symbols) and an introduction to forming algebraic expressions and equations. Understand notations and symbols used in algebra Form algebraic expressions from worded information An introduction to forming and solving equations Appreciate the purpose of algebraic variables and the good practice of simplifying algebraic expressions