levo

Implementation and System Security

Data conversion

  • 3 things to know
  • AS Unit 1

Overview

Data conversion, two ways in which data can be converted and data cleansing.

What you need to know

Answer each one before you reveal it.

Your recallNot started
Key term

Why is data conversion needed even when both systems are computerised?

Key term

Give one drawback of converting data by manual re-entry.

Key term

Why is data cleansed before transfer rather than afterwards?

Questions from this subtopic

Each one with the model answer underneath.

  1. 1

    What is data conversion?

    Model answer

    Data conversion is the work of taking the data held by the old system and putting it into the form and the structure the new system requires.

  2. 2

    Why is data conversion needed even when both systems are computerised?

    Model answer

    Two systems rarely store data in the same way, so field names, data types, code values and file formats must all be translated before the new system can use the old records.

  3. 3

    Describe two ways in which data can be converted.

    Model answer

    Data can be converted by writing a program that reads the old files and writes them out in the new format, or by keying the records in by hand where no usable electronic copy exists.

  4. 4

    Give one drawback of converting data by manual re-entry.

    Model answer

    Manual re-entry is slow and introduces typing errors, so a large volume of records takes a long time and arrives in the new system less accurate than it was before.

  5. 5

    What is data cleansing?

    Model answer

    Data cleansing is the correction of existing records before they are transferred, removing duplicates, filling gaps and putting inconsistent entries into one agreed form.

  6. 6

    Why is data cleansed before transfer rather than afterwards?

    Model answer

    Faulty records loaded into the new system spread through its reports and calculations at once, and cleaning them in place afterwards is far harder than cleaning the extract first.

Other ways to work this

The same content, four other ways.

What is inside Levo

Six ways to work the same material.

1Closed book
2Open book
3Closed book

The 3-step method, run for you

Answer cold, learn it, then prove it stuck. Levo tracks the jump between your first attempt and your last.

Systems Analysis and Development Approaches
Design, Development and Testing
Implementation and System Security
Programming

Cram a whole paper in one sitting

Sort every topic into what you know and what you do not, then drill only the weak ones.

A check requires a value.
presencerangeformat

Blank Blitz makes facts automatic

Rapid timed gap-fills on the terms and numbers you need to recall without thinking.

ANormal data is 12, which should be accepted.
BBoundary data is 1 and 50, which should be accepted.
C0 and 51, just outside the limits, should be rejected.

Build It gets the exam shape right

Assemble a full-mark answer from its marking points, in the order an examiner wants them.

One byte is made up of 8 bits.
TrueFalse

Test It catches misconceptions

Spot the fault in a statement. The traps are the mistakes students actually make.

721941163128510

Brain Breaks between sessions

Short focus games to reset attention, so the next set lands better than the last.

Every question in Implementation and System Security, on a schedule.

Attempt a question from memory, write the correct version, then attempt it again. Levo records the jump between your first attempt and your last, and brings each question back on the day you are due to forget it.

Or £46 a year, about £3.83 a month. Cancel anytime.