Know and understand input formats including data capture forms

Systems Life Cycle – Input Formats & Data Capture Forms

Objective

By the end of this lesson students will be able to:

• List and describe the eight stages of the Systems Life Cycle (SLDC) and the key activities in each stage (AO3).
• Identify and evaluate different input formats used to capture data.
• Design a data‑capture form that meets the requirements of the analysis and design phases.
• Explain how testing, implementation, documentation, maintenance and evaluation fit into the SLDC.
• Apply e‑safety, data‑protection and audience‑analysis principles when creating input solutions.

1. The Systems Life Cycle (SLDC)

Stage (as in the Cambridge syllabus)	Key Activities (AO3 focus)
Analysis	Gather requirements (observation, interview, questionnaire, document review), produce a system specification, identify inputs & outputs, create artefacts such as a requirements list, process map and data‑dictionary.
Design	Specify file/data structures, choose input & output formats, design validation routines, produce mock‑ups or prototypes, draft a data‑dictionary.
Development / Construction	Write or configure software, build databases, create electronic or paper forms, integrate hardware.
Testing	Develop test plans, prepare normal/abnormal/extreme test data, record results, correct faults, retest.
Implementation	Select a rollout method (direct change‑over, parallel, pilot, phased), train users, migrate data.
Maintenance	Monitor system performance, fix bugs, apply patches or updates, manage version control, update documentation, add enhancements.
Documentation	Produce technical documentation (data‑dictionary, field specifications, validation rules, hardware configuration) and user documentation (step‑by‑step guides, FAQs, troubleshooting).
Evaluation	Assess efficiency, ease of use and appropriateness; compare actual performance with the original specification; recommend improvements and produce an evaluation report.

2. Analysis (Stage 2)

Method	When to use it	Typical output
Observation	Current process is routine and can be watched directly.	Notes on steps, timings, equipment used.
Interview	Detailed, subjective information is needed from staff or users.	Transcripts, key quotes, refined requirement list.
Questionnaire / Survey	Data required from a large or dispersed group.	Compiled responses, statistical summary.
Document review	Existing records (forms, reports, manuals) contain useful specifications.	Extracted data fields, process maps, initial data‑dictionary entries.

Output Checklist for Analysis (AO1)

• Requirements list (functional & non‑functional).
• Process map / flow‑chart of the current system.
• Preliminary data‑dictionary (field names, types, lengths).
• Stakeholder & audience analysis summary.

3. Design (Stage 3)

3.1 File / Data Structures

• Decide field names, data types (text, numeric, date, Boolean), field length, coding (e.g., “Y/N”).
• Produce a full data‑dictionary (see example below).

Sample Data‑Dictionary

Field Name	Data Type	Length	Coding / Format	Purpose
student_id	Alphanumeric	8	AA999999	Unique identifier for each pupil.
first_name	Text	30	—	Given name of the pupil.
dob	Date	10	YYYY‑MM‑DD	Date of birth (used for age calculations).
course_code	Alphanumeric	4	ICT, MATH, SCI	Selected course.
email	Text	50	email‑address pattern	Contact address.

3.2 Input Format Selection

• Paper questionnaire
• Online web form
• Barcode / QR scanner
• OCR (scanner + software)
• Voice / speech recognition
• Touchscreen / pen input

3.3 Validation Routines

• Mandatory field (required)
• Data‑type check (numeric, date, Boolean)
• Range check (e.g., 0‑100)
• Length check (exact or maximum characters)
• Format check (e.g., email pattern, postcode format)

Validation Rule – AO2 Mapping

Validation Rule	AO2 Skill Demonstrated
Mandatory field	Apply knowledge of system requirements to produce a solution that prevents missing data.
Data‑type check	Use appropriate data structures and enforce correct data entry.
Range check	Implement logical constraints to improve data quality.
Length check	Design fields that match storage limits and prevent truncation.
Format check	Apply pattern‑matching techniques (e.g., regular expressions) to ensure consistency.

3.4 Usability Considerations

• Logical field order and grouping.
• Clear, concise labels and help text.
• Tab order for keyboard navigation.
• Colour contrast and font size for readability.
• Accessibility tags (e.g., label elements) for screen readers.

4. Development / Construction (Stage 4)

4.1 Building a Form in a Mainstream Office Suite (LibreOffice Writer)

1. Open LibreOffice Writer → View → Toolbars → Form Controls.
   
2. Insert a Text Box for each data field (e.g., First Name, Last Name). Right‑click → Control → set Name, Maximum Length, and Mandatory properties.
3. Insert a Combo Box for “Course Selection” and define the list entries (ICT, Mathematics, Science).
4. Add a Date Field for Date of Birth and set the required format (YYYY‑MM‑DD).
5. Place a Push Button labelled “Submit”. In the Events tab, assign a macro that validates the fields and writes the data to a CSV file.
6. Save the document as .odt for editing and export as .pdf for distribution if a static form is required.

4.2 Creating an HTML Web Form (quick reference)

<form action="register.php" method="post">
    <fieldset>
        <legend>Personal Details</legend>
        <label for="fname">First name:</label>
        <input type="text" id="fname" name="first_name" required maxlength="30"><br>
        <label for="lname">Last name:</label>
        <input type="text" id="lname" name="last_name" required maxlength="30"><br>
        <label for="dob">Date of birth:</label>
        <input type="date" id="dob" name="dob" required><br>
    </fieldset>
    <fieldset>
        <legend>Course Selection</legend>
        <label for="course">Choose a course:</label>
        <select id="course" name="course">
            <option value="ICT">ICT</option>
            <option value="MATH">Mathematics</option>
            <option value="SCI">Science</option>
        </select>
    </fieldset>
    <input type="submit" value="Submit">
</form>

5. Testing (Stage 5)

Testing checklist for a data‑capture form

1. Prepare normal test data that satisfies all validation rules.
2. Prepare abnormal data (e.g., letters in a numeric field, missing mandatory fields).
3. Prepare extreme data (e.g., maximum field length, dates far in the past/future).
4. Execute each test case, record the system’s response and any error messages.
5. Confirm that valid data is stored correctly in the database or file.
6. Log defects, correct them, and retest until all cases pass.

6. Implementation (Stage 6)

• Direct change‑over – switch off the old system and start the new one immediately.
• Parallel – run old and new systems side‑by‑side for a defined period.
• Pilot – introduce the new system to a small, representative group first.
• Phased – roll out the system module by module or site by site.

7. Maintenance (Stage 7)

• Monitor system performance (response times, error logs).
• Fix bugs and apply security patches or software updates.
• Implement minor enhancements (e.g., adding a new drop‑down option).
• Maintain version control – keep a change‑log and archive previous releases.
• Update technical and user documentation to reflect changes.
• Example: Applying a monthly patch to a school‑management system to address a newly discovered SQL‑injection vulnerability.

8. Documentation (Stage 8)

• Technical documentation – data‑dictionary, field specifications, validation rules, hardware configuration, installation guide.
• User documentation – step‑by‑step guide, screenshots, FAQs, troubleshooting tips.
• Store both securely (e.g., on the school intranet) and keep them up‑to‑date after maintenance.

9. Evaluation (Stage 9)

Assess the input solution against the three AO3 criteria:

Criterion	What to look for
Efficiency	Speed of data entry, reduction in manual work, processing time.
Ease of use	Clarity of instructions, error‑rate, user satisfaction (survey results).
Appropriateness	Fit for the target audience, suitability for the environment, cost‑effectiveness.

10. Safety, Security & Data Protection

• Use strong passwords; encrypt stored data where appropriate.
• Apply access controls – only authorised staff may view or edit captured data.
• Comply with data‑protection legislation (GDPR‑style principles): obtain consent, keep data only as long as necessary, provide a privacy notice.
• Validate input to prevent injection attacks or malformed data.
• Back‑up data regularly and store backups securely (off‑site or cloud).

11. Audience Analysis & Communication

• Identify primary users (age, language, technical skill, accessibility needs).
• Adapt form language, layout and input devices accordingly (e.g., larger fonts for older users, pictograms for young learners).
• Choose appropriate communication media when presenting the solution – email, intranet posting, printed hand‑outs – and observe netiquette.
• Include copyright statements for any reused graphics or code.

12. Input Formats – How Data Is Captured

Format	Typical Device	Data Type Captured	Key Advantages	Key Disadvantages
Paper questionnaire / form	Pen & paper	Text, check‑boxes, numeric entries	Low initial cost; familiar to most users	Manual transcription required; prone to illegible handwriting
Online web form	Computer, tablet, smartphone	Text, numbers, dates, selections, file uploads	Instant validation; data stored digitally; easy to update	Requires internet access; design and programming effort
Barcode / QR code scanner	Handheld or fixed scanner	Encoded product or asset identifiers	Very fast entry; eliminates typing errors	Initial hardware cost; codes must be printed and maintained
Optical Character Recognition (OCR)	Scanner + OCR software	Printed text, forms, invoices	Automates conversion of existing paper records	Accuracy depends on print quality; may need manual verification
Voice / Speech recognition	Microphone, speech‑to‑text software	Spoken words, commands	Hands‑free entry; useful for users with mobility impairments	Background noise reduces accuracy; limited language support
Touchscreen / Pen input	Tablet, interactive kiosk	Handwritten or drawn input, signatures	Intuitive for drawing or signing; can capture free‑form data	Requires calibration; conversion to text may need additional software

13. Data Capture Forms

13.1 Types of Forms

• Static paper forms – pre‑printed, used where electronic devices are unavailable or impractical.
• Dynamic electronic forms – built with HTML, XML, or specialised form‑building tools; can include client‑side validation, auto‑complete and conditional fields.

13.2 Elements of a Good Form

• Clear headings and logical sections.
• Logical field order that follows the natural flow of information.
• Appropriate field types (text box, drop‑down, radio button, check‑box, date picker).
• Input validation (required, data‑type, range, format).
• Instructions, examples and tool‑tips to reduce ambiguity.
• Accessibility features – label tags, tab order, high‑contrast colour scheme, screen‑reader friendly markup.
• Consistent naming convention for fields (e.g., student_id, dob).

13.3 Example: Simple Student Registration Form (HTML)

<form action="register.php" method="post">
    <fieldset>
        <legend>Personal Details</legend>

        <label for="fname">First name:</label>
        <input type="text" id="fname" name="first_name" required maxlength="30"><br>

        <label for="lname">Last name:</label>
        <input type="text" id="lname" name="last_name" required maxlength="30"><br>

        <label for="dob">Date of birth:</label>
        <input type="date" id="dob" name="dob" required><br>
    </fieldset>

    <fieldset>
        <legend>Course Selection</legend>

        <label for="course">Choose a course:</label>
        <select id="course" name="course">
            <option value="ict">ICT</option>
            <option value="math">Mathematics</option>
            <option value="science">Science</option>
        </select>
    </fieldset>

    <input type="submit" value="Submit">
</form>

13.4 Testing the Form (Development & Testing Stage)

1. Enter valid data – confirm that the form submits and data is stored correctly.
2. Leave a required field blank – verify that an error message appears.
3. Enter a non‑numeric value in a numeric field – verify format validation.
4. Enter data that exceeds the maximum length – check that the system truncates or rejects it.

14. Choosing the Right Input Format

Use the following decision‑making criteria during analysis and design:

1. Volume of data – High volume → scanners, barcode readers, OCR.
2. Accuracy required – Critical accuracy → validation, barcodes, OCR with verification.
3. Cost & resources – Low budget → paper forms; higher budget → electronic solutions.
4. User skill level & audience – Choose devices familiar to the target group.
5. Environment – Mobile/field work → handheld scanners or voice input.
6. Security & privacy – Sensitive data → encrypted online forms, restricted access.

15. Advantages & Disadvantages Summary

Format	Advantages	Disadvantages
Paper forms	Simple, no power needed, low set‑up cost	Manual transcription, slower processing, storage space required
Online web forms	Instant validation, central storage, easy to update	Internet dependency, programming effort
Barcode / QR scanners	Very fast, high accuracy, reduces typing errors	Initial hardware cost, need for printed codes
OCR	Automates conversion of existing paper records	Accuracy varies with print quality; may need manual correction
Voice input	Hands‑free, improves accessibility	Background noise, limited language support
Touchscreen / pen input	Intuitive for drawing or signing; captures free‑form data	Requires calibration; conversion to text may need extra software