The Excel Range
Microsoft Excel Guides 1 & 2These resources are designed to help the computer user who wants to learn how to use spreadsheets and, in particuluar Microsoft Excel. They start by scratch so can be used to intoduce pupils from year 7 to sixth formers to spreadsheets and very quickly move into teaching them the features of Excel that they will need - whether for an IT spreadsheets exam or for applying to their work in other subjects.
The resources have been designed as self-learn packs for use by individuals or by ICT teachers in the classroom. It is suggested that pupils work through each sheet and then apply what they have learnt where relevant - and then use the worksheets (see below) to further develop their spreadsheets expertise.
Guide 1 (Beginner to Intermediate) includes: Orientation, Introduction to Spreadsheets, Text and Numbers in cells, Formatting, Formulae & Replication, Absoloute Formulae, Graphing and useful tips. Page setup, printing and the Excel toolbars are also covered.
Guide 2 (Intermediate to Advanced) includes: Shortcut keys, macros, databases, data forms, data sorting, importing, solver, dialogue boxes, exercises, protecting worksheets. It also revises some aspects of Guide 1, excellent for consolidating students learning, and reminding them of what they may have forgotton.
Worksheets and Tasks 1 & 2The worksheets take students through step-by-step exercises – ideal for classwork.
Guides/Worksheets/Tasks cross-link so they can be used together - each resource can also be used standalone.
Mimic ExercisesThis resource is specifically designed to give students practise in formatting their spreadsheets - students ‘mimic’ a data file to a fully formatted version. New 'special features used' section for easy reference & with hints ensure the advanced skills are practised appropriately. Tasks will also give students experience of when Microsoft Excel can be a better tool for producing tables and other documents than Microsoft Word.
The Excel Range has always been highly praised by our customers.