Wir haben derzeit keine Zusammenfassung für diesen Artikel.

Mike Dolan, Salford College, England June, 2002 This and your other books are written in a style easy to follow and are student and lecturer friendly. Mrs. L Toms, Oxford CFE, OXFORD "I find the books well laid out and easy for the students to grasp" and "Comprehensive cover of topics". Mr M Armstrong Harris, Edgbarrow Schools, CROWTHORN, Berkshire "We are likely to adopt the AVCE texts as standard texts next year. We remain impressed by the quality of ICT texts". Mr D Day, King Edward VI Community College, TOTNES "All three of these books are just what I have been looking for. Well written, pitched at the correct level, packed full of good ideas. Will save me HOURS of work". A must buy if you taking AVCE ICT, 19 December, 2001 Reviewer: A Reader from Bristol, UK The book is very good, covers everything you need to know for the first year in units 1-3. It explains technical information like Management information systems and down to how to write a fax. I highly recommend it to any taking AVCE ICT in their first year. Allan A. Blakeley & Peter M. Nurse, Course tutors GNVQ ICT Intermediate & AVCE ICT, 25 November, 2002 Reviewer: We wish to take this opportunity to express our appreciation of the quality of your books and the service that we have received. We have compared your books for AVCE in ICT with those from other publishers and have come to the conclusion that yours are the better by far. They contain more detail and guidance for the student, and are well laid out. The examples the students have to work through provide excellent preparation for unit assessment, both external and portfolio.

Rosemary Richards has taught IT for many years at an FE College. She is now in publishing and has written several books on IT. Pat Heathcote has worked as a programmer and systems analyst, and has many years of experience in teaching Computing and Information Technology. She has served as an Assistant Examiner with AQA, is on the Subject Committee for Computing and is Chair of Examiners for Edexcel AVCE and GNVQ. She is now a full-time author and publisher.

Preface iii Unit Presenting Information Chapter 1 - Accuracy and style of writing 1.1. Spelling and Grammar - get it right! 1.2. Dictionaries 1.3. Writing Style 1.4. Using different writing styles to meet different needs 1.5. Using tools to help with style 1.6. Using a thesaurus 1.7. Producing draft copies 1.8. Displaying readability statistics 1.9. Proofreading 1.10. Software tools to help with proofreading 1.11. Building your portfolio Chapter 2 - Styles of Presentation 2.1. Page Layout 2.2. Headers and Footers 2.3. Paragraph formats 2.4. Textual styles 2.5. The Drawing toolbar 2.6. Special Presentation styles 2.7. Bullets and numbers 2.8. Tables 2.9. Working with columns 2.10. Building your portfolio Chapter 3 - Working with longer documents 3.1. Layout features for longer documents 3.2. Setting up the document outline 3.3. Adding headers and footers 3.4. Inserting a Table of Contents 3.5. Creating captions and cross-references 3.6. Creating an index of entries 3.7. Creating a bibliography 3.8. Building your portfolio Chapter 4 - Maintaining a Consistent Style 4.1. The letter layout 4.2. Creating and using a document template 4.3. Defining, assigning and modifying a style 4.4. Inserting fields 4.5. Building your portfolio Chapter 5 - Combining Information 5.1. Planning the presentation 5.2. Starting PowerPoint 5.3. Changing the view 5.4. Adding a new slide 5.5. Viewing the presentation 5.6. Saving, closing and opening your presentation 5.7. Making global changes 5.8. Editing the Slide Master 5.9. Adding charts 5.10. Inserting Clip Art pictures, animation and sound 5.11. Adding autoshapes 5.12. Adding slide transitions 5.13. Adding animation to text and objects 5.14. Printing your slides 5.15. Delivery 5.16. Building your portfolio Chapter 6 - Managing Information 6.1. Printed Questionnaires 6.2. Web sites 6.3. On-line forms 6.4. Faxed Specification for flyer 6.5. Publicity flyers 6.6. Memos 6.7. E-mails 6.8. Agendas 6.9. Minutes 6.10. Itineraries 6.11. Sales and Marketing Budgets 6.12. Invoices and Delivery notes 6.13. Building your portfolio Unit ICT Serving Organisations Chapter 7 - Organisational Structure 7.1. How organisations work 7.2. Ingredients for success 7.3. The people in an organisation 7.4. The functions of an organisation 7.5. External pressures on an organisation 7.6. ICT in organisations 7.7. Organisations and information systems 7.8. Data processing systems 7.9. Knowledge work systems 7.10. Management information systems Chapter 8 - Studying an Organisation 8.1. Finding out about an organisation 8.2. The function of each department 8.3. Researching in further detail 8.4. Information in organisations 8.5. Exercises Chapter 9 - Information Flows 9.1. Internal and external information 9.2. Formal and informal information systems 9.3. Relationships between departments 9.4. Information flow diagram 9.5. Other external agencies 9.6. Exercises Chapter 10 - Sales Order Processing 10.1. Marketing and sales 10.2. How is an order processed? 10.3. Placing an order 10.4. Inputting an order 10.5. Processing the order 10.6. Receiving payment 10.7. Exercises Chapter 11 - Stock Control 11.1. Why hold stock? 11.2. The function of a stock control system 11.3. Inputs to a stock control system 11.4. Outputs from the stock control system 11.5. Purchase ordering 11.6. Exercises Chapter 12 - Finance and Administration 12.1. Functions of a Finance Department 12.2. A budget for a new product 12.3. Cash flow forecast 12.4. The Sales Ledger 12.5. The Purchase Ledger 12.6. The Nominal Ledger 12.7. Payroll 12.8. Human Resources (Personnel) 12.9. Administration 12.10. Exercises Chapter 13 - Management Information Systems 13.1. Introduction 13.2. Information systems v. data processing systems 13.3. The purpose of a management information system 13.4. What managers do 13.5. Types of decision 13.6. Stages of decision-making 13.7. The benefits of a management information system 13.8. Typical functions of a MIS 13.9. Exercises Chapter 14 - E-commerce and Other Applications 14.1. E-commerce 14.2. Advantages of e-mail 14.3. Using Microsoft Outlook 14.4. Computer-aided design 14.5. Exercises Unit Spreadsheet Design Chapter 15 - Getting Started 15.1. Choosing a project 15.2. Starting the sample project 15.3. Formatting numbers 15.4. Entering a formula 15.5. Formatting the presentation of cells Chapter 16 - Manipulating Spreadsheet Data 16.1. Finding and replacing data 16.2. Adding worksheets 16.3. Repositioning data 16.4. Linking worksheets 16.5. Relative and absolute cell referencing 16.6. Naming cells Chapter 17 - Formulae and Functions 17.1. Operators in formulae 17.2. The SUM function 17.3. Functions to calculate averages 17.4. MIN and MAX functions 17.5. COUNT functions 17.6. The Paste Function wizard 17.7. IF function Chapter 18 - Data Input 18.1. Comments 18.2. Data Validation 18.3. Forms 18.4. Macros 18.5. Adding command buttons Chapter 19 - Creating Reports 19.1. Creating the monthly pay report 19.2. Page Layout 19.3. Sorting and subtotalling 19.4. Creating a macro to update Department Summary 19.5. Create a routine to print the Management Summary 19.6. Initialising for a new month 19.7. Opening the workbook automatically Chapter 20 - Graphs and Charts 20.1. Creating a bar chart 20.2. Formatting the bar chart 20.3. Using drawing tools 20.4. Creating a line chart 20.5. Charting more than one data series Chapter 21 - Completing the Application 21.1. Protecting spreadsheet data 21.2. Templates 21.3. Evaluating your application 21.4. Testing 21.5. The Auditing toolbar 21.6. Displaying formulae 21.7. Screenshots Chapter 22 - Design Specification 22.1. The contents of a design specification Chapter 23 - Documentation 23.1. Checking the assessment criteria 23.2. Keeping a log 23.3. The contents of technical documentation 23.4. Sample technical documentation Chapter 24 - User Documentation 24.1. Introduction 24.2. Word processing your user manual 24.3. Sample user manual Appendices Appendix A Standard Ways of Working Introduction Managing your work Keeping information secure Working safely Appendix B Victory Publishers Ltd Introduction The Departments Appendix C ShoeShock Ltd Introduction The Company structure Organisation Chart for ShoeShock UK Information flow within the organisation Appendix D Assessment Evidence for Units 1-3 Unit 1: Presenting Information Unit 2: ICT Serving Organisations Unit 3: Spreadsheet Design Index