Successful ICT Projects In Excel (2nd Edition)
Seiten
2004
Payne-Gallway Publishers (Verlag)
978-1-903112-26-7 (ISBN)
Payne-Gallway Publishers (Verlag)
978-1-903112-26-7 (ISBN)
- Titel erscheint in neuer Auflage
- Artikel merken
Zu diesem Artikel existiert eine Nachauflage
A guide to writing 'A' Level/BTEC/GNVQ projects using Microsoft Excel (v. 5 to 2000) covering analysis, design and implementation using advanced features of Excel.
It is organised as follows: Part 1 Basic skills in Excel covers entering data, copying and moving cell contents and worksheets, naming cell ranges and worksheets, simple formulae, relative and absolute addressing, functions including VLOOKUP, IF, TRUNC, RAND etc., auditing, Lookup tables, Goal Seek, 'What-if' scenarios and Solver. Part 2 Data analysis and presentation covers linking workbooks, filtering, sorting and subtotalling lists, PivotTables, charts and graphs, and printing. Part 3 Customising an application provides coverage of on-line forms, templates, transferring data to a database, protecting worksheets, macros and the Visual Basic interface, creating custom buttons, menus and toolbars. Part 4 Tackling the project handles ideas, the systems life-cycle and writing up the project. A Sample Project demonstrates how to lay out a complete project report, and the AQA project mark scheme is also included. The template for the sample project as well as a sample chapter entitled 'Project Ideas' are available on the web site www.payne-gallway.co.uk
It is organised as follows: Part 1 Basic skills in Excel covers entering data, copying and moving cell contents and worksheets, naming cell ranges and worksheets, simple formulae, relative and absolute addressing, functions including VLOOKUP, IF, TRUNC, RAND etc., auditing, Lookup tables, Goal Seek, 'What-if' scenarios and Solver. Part 2 Data analysis and presentation covers linking workbooks, filtering, sorting and subtotalling lists, PivotTables, charts and graphs, and printing. Part 3 Customising an application provides coverage of on-line forms, templates, transferring data to a database, protecting worksheets, macros and the Visual Basic interface, creating custom buttons, menus and toolbars. Part 4 Tackling the project handles ideas, the systems life-cycle and writing up the project. A Sample Project demonstrates how to lay out a complete project report, and the AQA project mark scheme is also included. The template for the sample project as well as a sample chapter entitled 'Project Ideas' are available on the web site www.payne-gallway.co.uk
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.
Part 1 Excel Basics 1 Part 2 Data Analysis and Presentation 55 Part 3 Customising an Application 91 Part 4 Tackling the Project 135 Appendix A Sample Project Appendix B AQA Project Mark Scheme
Erscheint lt. Verlag | 31.12.2004 |
---|---|
Zusatzinfo | illustrations |
Verlagsort | Harlow |
Sprache | englisch |
Themenwelt | Schulbuch / Wörterbuch |
Informatik ► Office Programme ► Excel | |
ISBN-10 | 1-903112-26-5 / 1903112265 |
ISBN-13 | 978-1-903112-26-7 / 9781903112267 |
Zustand | Neuware |
Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
Komplett in Farbe. Ideal für alle Einsteiger, Umsteiger und auch …
Buch | Softcover (2022)
Markt + Technik Verlag
12,95 €
Datenanalyse und Reporting mit Power Query, Power Pivot und Power BI …
Buch (2023)
Carl Hanser (Verlag)
44,99 €