This unit has been designed to prepare for the N5 and Higher Admin & IT Assignment, with a greater emphasis on Higher. There is plenty of practice with formatting, sorting data and a few tasks where graphs are required. As well as basic formulas there are more complex scenarios in the tasks that require working with %’s & VAT, Lookups, IF Statements, Nested IFs, Sum & CountIF & Pivot Tables. The last task incorporates a VLookup combined with an IF Statement and is more complex than required for Higher. However, this is based on a spreadsheet that was designed for an actual business and has been included to give students an example of how Excel could be used to problem solve and make data input easier for the end user. Step-by-Step instructions have been included for this Task (16).
All the instructions are on screen with additional “help sheets” provided. Suggested Solutions also included as well as a task list that outlines in detail what is required for each task.