Processing & Presenting Data

Processing & Presenting Data

1. The problem with incorrect data on stock levels is that this can lead to having too much which can be a waste.

2. The problem with incorrect employee data is that this could lead to an employee being paid too much or too less that what they originally worked for.

3. Validation is to check whether the information is sensible and reasonable to use.

   • Length check, type check etc.

4. Verification is used to ensure that data matches with the original source.

   • Proofreading check, double entry check etc.

5. A database is when all your data is gathered and organised in one place.

6. A database query is when we are able to extract and sort information from the database.

7. Extracting: this can be performed by choosing specific fields and using filters to select data that meet specific criteria.

8. Sorting: can organise data by any retrieved field in ascending or descending order.

9. Numerical modelling is where mathematical calculations are used to simulate a real-life system.

10. Data modelling is a process used to plan the structure of a database to ensure that data is stored in the most organised and efficient manner.

11. Tabular presentation is a text presentation of data within a table.

    • This is used where precise data and detail is required.

12. Graphical presentation is where data is presented using a chart or some other form of diagram.

    • This is used where ease of interpretation and spotting trends is required.