Cambridge Technical Level 3 IT 2016 Unit 1 Word Search Activities / Revision / Starters

Cambridge Technical Level 3 IT 2016 Unit 1 Word Search Activities / Revision / Starters

5 word searches, each with 35 words, based around each of the 5 Learning Objectives of Unit 1 - Fundamentals of IT. These have all been created in Word so that you can modify them easily, or use as per the 'Word Search Tasks' sheet which suggests the option of deleting the words from the word list and trying to identify relevant words independently. Task sheet also gives a few other suggestions for extension tasks related to the word searches so that students can better revise or extend learning.
mrsvernonict
Advanced Spreadsheets: 3D Refs, IF AND, LOOKUP, PMT, RANK, Data Validation, Conditional Formatting

Advanced Spreadsheets: 3D Refs, IF AND, LOOKUP, PMT, RANK, Data Validation, Conditional Formatting

*Updated June 2016! 2 more resources added!* A selection of easy to follow task sheets and accompanying Excel spreadsheet to develop more complex spreadsheet skills. Techniques covered include working with 3D cell references in a formula, beginning to use VLOOKUP, using AND within an IF statement, the PMT function, the ROUND and RANK functions, Data Validation and applying Conditional Formatting. These Advanced Spreadsheets resources were developed originally to help students build skills required for the Level 3 Advanced ECDL, but are also useful for developing more complex spreadsheet skills for other purposes, both at KS4 and KS5. Files: 3D Referencing and LOOKUP 3D-Referencing-and-LOOKUP-in-Excel.docx - instructions / task sheet 3D-Ref---Student-Markbook.xlsx - 4 worksheets to be used with this task Conditional Formatting Conditional-Formatting---Quick-Practice.xlsx - 5 sets of data requesting different conditional formatting Data Validation Data-Validation-in-Excel.docx - instructions / task sheet Data-Validation-Workbook.xlsx - 3 worksheets to be used with the Data Validation task IF and AND IF-AND-in-Excel.docx - instructions / task sheet Animal-Rescue-Worksheet.xlsx - 4 worksheets to use with the IF and AND task PMT Function Loans-Spreadsheet.xlsx - a worksheet containing details of 6 loans to calculate the repayments on PMT-in-Excel.docx - instructions / task sheet ROUNDUP and RANK ROUNDUP-and-RANK.docx - instructions / task sheet Measurements-and-Statistics.xlsx - multi-sheet workbook containing data to use with the task sheet
mrsvernonict