ICT

HideShow resource information
View mindmap
  • ICT
    • Input
      • used to enter information
      • keyboard
      • touchpad
      • microphone
    • Output
      • used to display infomation
      • monitor
      • printer
      • speakers
    • Storage
      • stores information
      • hard Disk
      • memory stick
      • DVDs
    • Spreadsheets
      • cell formats
        • number
        • text
        • currency
        • date/time
          • DOB. time of appointment
        • boolean
          • can have 2 options
        • autonumber
          • primary key
      • formulas
        • =B3*C3
        • =SUM(D3:D16)
        • =D17/B5
        • =B5-F4
      • Advantages
        • carry out what if investigations
        • easer to change data
        • quicker
      • Disadvantages
        • learn how to use it
        • viruses
    • Data validation
      • way of trying to reduce number of errors
      • range check
        • sets suitable boundaries
      • check digit
        • to make sure a range of numbers have been entered right
      • length check
        • no longer than a certain length
      • lookup
        • drop down list
      • presence check
        • something is there (eg number)

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all Spreadsheets and Databases resources »