Students will use self marking worksheets to learn to create their own formulae and understand why they should use formulae. Included are tasks that cater for the lower ability, middle ability and higher ability students. Learning pitstops and challenges are provided to check students understanding and learning of the spreadsheet skills needed for the exam. The functions and formula that students will learn include, SUM, AVERAGE, MAX, IF, COUNTIF, =TODAY(), =NOW(), sorting data, absolute cell referencing, * multiplication, + addition and, autosum. Students will have the chance to practise all the skills using the practice skills 1 and 2.xls included in the resources. These are self marking (they have been adapted to suit the needs of my students) so students can work independently. This allows me to provide small group intervention sessions if necessary for the skills that the students struggle with.
Something went wrong, please try again later.
Thank you for you excellent resources.
Very good for autonomous student learning. Well put together excel files for self development and skills practice. Thank you!
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£5.00