Ict theory

• Cambridge IGCSE™ Information and Communication Technology series

  • Student's Book
  • Boost eBook
  • Workbooks
  • Teacher's Guide with Boost Subscription

  
• Cambridge IGCSE™ Information and Communication Technology Third Edition


  ISBN 9781398318540

  
• Cambridge IGCSE™ Information and Communication Technology Boost eBook

  ISBN 9781398320932

  
• Cambridge IGCSE™ Information and Communication Technology Practical Workbook Second Edition


  ISBN 9781398318519

  
• Cambridge IGCSE™ Information and Communication Technology Theory Workbook Second Edition


  ISBN 9781398318564

  
• Cambridge IGCSE™ Information and Communication Technology Teacher's Guide with Boost Subscription


  ISBN 9781398318533

  
• To explore the entire series, visit www.hoddereducation.com/cambridge-igcse-IT

  
• Cambridge IGCSE™ Information and Communication Technology Teacher's Guide with Boost Subscription


  Created with teachers and students in schools across the globe, Boost is the next generation in digital learning for schools and colleges, bringing quality content and new technology together in one interactive website
• Cambridge IGCSE™ Information and Communication Technology Teacher's Guide with Boost Subscription

  • The Teacher's Guide includes a print handbook and a subscription to Boost, where you will find a range of online resources to support your teaching
  • Confidently deliver the revised syllabus with schemes of work, answers for all Student's Book exercises and exam-style questions, electronic solutions for practical activities in the Student's Book and answers for both Workbooks
  • Aid understanding with vocabulary flashcards to offer support to ESL learners

  
• To purchase Cambridge IGCSE™ Information and Communication Technology Teacher's Guide with Boost subscription, visit www.hoddereducation.com/cambridge-igcse-IT

  
• Cambridge IGCSE™ Information and Communication Technology Third Edition

  
• Authors: Graham Brown, David Watson
• Proportionally spaced font


  A font where each character takes up a variable amount of space, unlike monospaced fonts where each character takes up the same amount of space
• Cascading Stylesheets (CSS)


  A style sheet language used to describe the presentation of a document written in a markup language like HTML
• Proportionally spaced font and Cascading Stylesheets appear in a cerise font

  
• The practical elements of the syllabus can be undertaken on any suitable hardware platform and using any appropriate software packages
• For the purposes of giving examples in this book, we have chosen specific software packages – but the functionality of many other packages is very similar
• Many of the skills demonstrated in Chapters 11 to 21 are transferable and can be adapted for other hardware and software platforms
• Hardware and software used

  • PC platform with Microsoft Windows 10 operating system
  • Notepad
  • Microsoft 365 packages including Word, Excel, Access and PowerPoint
  • Google Chrome web browser

  
• For the website authoring section of the book (Chapter 21), all work has been produced in HTML code without the use of a What You See Is What You Get (WYSIWYG) package such as Adobe Dreamweaver and Microsoft Expression Web
• All HTML written within this chapter is written in HTML version 5, and is W3C validated (at the time of going to print)
• All cascading stylesheets used have been W3C validated

  
• Source files that are required for the practical chapters can be found at: www.hoddereducation.co.uk/cambridgeextras and will need to be downloaded onto your local machine or network drive in order to use them
• Before attempting any of these processes, back up all source files
• The .csv (comma separated value) files have commas as separators between fields and full stops within currency values
• If your regional settings for these values are different (for example, if you use commas within currency values rather than full stops and your software settings require you to use semicolons for separators between fields), then the source data files will need to be edited for use with the regional settings for your software
• Editing .csv files


  1. Open the .csv file in Word

  2. Select the HOME tab, then the Editing section followed by the Replace icon

  3. Enter a , (comma) into the Find what: box and a ; (semicolon) into the Replace with: box, then click on Replace All

  4. Repeat this process, replacing a . (full stop) with a , (comma)

  5. Save the file with the same file name using the File tab and Save
• The Theory Workbook and Practical Workbook provide additional opportunity for practice
• Command words


  • Analyse
  • Compare
  • Contrast
  • Define
  • Demonstrate
  • Describe
  • Discuss
  • Evaluate
  • Explain
  • Give
  • Identify
  • Justify
  • State
  • Suggest
• Exam-style questions and sample answers have been written by the authors
• In examinations, the way marks are awarded may be different
• References to assessment and/or assessment preparation are the publisher's interpretation of the syllabus requirements and may not fully reflect the approach of Cambridge Assessment International Education

  
• Image editing software


  Manipulates lines, curves and text to alter the stored image as required
• Computer-aided design (CAD) software


  Software used to help in the creation, manipulation, modification and analysis of a drawing/design
• CAD software


  • Can produce 2D or 3D diagrams which can be rotated to view the drawing from any angle
  • Can produce full dimensions
  • Can be used to estimate manufacturing costs of the final product
  • Can predict any structural problems
• Spreadsheet software


  Used to organise and manipulate numerical data (in the form of integer, real, date, and so on)
• Spreadsheet


  • Numbers are organised on a grid of lettered columns and numbered rows
  • Can use formulae to carry out calculations
  • Can produce graphs
  • Can do modelling and 'what if' calculations
• Database (management system)


  Software used to organise, manipulate and analyse data
• Database


  • Consists of one or more tables, with each row called a 'record' and each column called a 'field'
  • Can carry out queries on database data and produce a report (DBMS)
  • Can add, delete and modify data in a table
• Applications software are programs that allow the user to do specific tasks