Introduction to Microsoft Excel 2003
Price: £39.99 (Excluding VAT at 17.5%)
Format
|
|
Subject: Information & Communication Technology
Level: Secondary
Age Group: 14 - 16
Order Number: 8045
The MS Excel 2003 Guide has been developed to explain and demonstrate MS Excel features in order to improve existing skills or develop new ones. The guides are aimed at all Key Stages, from 3 to 5 (11-18 age range) and adults wishing to gain an accreditation for the Microsoft Office Specialist Certification course. The guide is ideal for developing spreadsheet solutions in the DiDA - Unit 1 - Using ICT and OCR Nationals in ICT - Unit 1 - ICT in Business Skills and Unit 6 Spreadsheet Design and Use. The guides can be used in any KS3 Teaching Units, spreadsheet and modelling elements. The guides can be used to assist in developing an AS level Unit 3 project. The guides are well structured to cater for students of all abilities when using ICT. The guides have been broken down into eight key parts, ideal for beginners and advanced users, so learning is maximised in small sections of information, with interactive elements and is ideal for developing independent learning skills.
Overall the guides can help students and teachers to reach their full potential when using the latest version of MS Excel. Part One describes key elements of Excel interface explaining different Excel Screens, layouts and views that are available. Part Two describes different views of MS Excel including inserting objects, hyperlinks and diagrams. Also covering additional elements and functions including shared workbooks and freeze panes. Part Three covers styles and formatting elements of MS Excel, including cells, numbers, currency, date/time, applying styles and using styles. Part Four covers functions and formulas within MS Excel including basic functions (Sum, Average, Max, Min, Today) and advanced functions (IF statement, Hlookup and Vlookup) Part Five describes charts and graphics in MS Excel, how to create and use. Part Six describes data elements of MS Excel including Pivot Table. Part Seven describes graphics elements of MS Excel including inserting images, grouping and using auto shapes. Part Eight describes four main Excel templates, how to create, use and develop. Overall, this is a fully compacted and detailed guide about how MS Excel functions.
Once purchased, the CD can be freely copied and networked throughout the school.
