O GoConqr está de visual novo! Conte para nós o que você achou.

Mapa mental

Data handling

MaxG Inglês

Conteúdo do mapa

Data handling

  1. Spreadsheets

    • Modelling
      • Goal seek allows the user to see what needs to change in their spreadsheet in order to reach a certain target such as more money. This can be used to see how many more things a company will need to sell in order to get a certain amount of money.
      • If a value on spreadsheet is changed, formulae make sure that the change is updated throughout the rest of the spreadsheet.
    • Formulas and functions
      • Functions such as SUM allow date to be easily entered into a spreadsheet and helps solve the solution quicker and easier.
    • Features such as merging and formatting cells allow the spreadshet to look more proffesional and overall better.
  2. Databases

    • Validation and verification
      • Range check
        • A range check allows you to set boundaries for numbers, for example the cell must have between 10 and 20 characters entered into it.
      • Type check
        • Will check that the correct type of data is being entered into the cell.Like number data.
      • Check digit
        • This will check that a correct amount of digits have been entered, this would be useful in entering barcode information.
      • Length check
        • Make sure all the data has the same number of characters, for example a landline telephone which has 11 characters.
      • Format check
        • The data will consiste of the same pattern, this is useful in entering postcodes.
      • Presence check
        • Checks that something has been entered in the cell. The cell has to have data in it

Informações

Descrição
Mapa Mental sobre Data handling, criado por MaxG em 19-04-2014.
Criado por
MaxG
Visualizações
14
Avaliação

Mais sobre Data Validation and Verification

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?