Introduction to IT systems development

    CITY & GUILDS LIMITED
    Vocational

    This topic introduces IT systems development, covering the roles of IT personnel, the systems development life cycle (SDLC) models, and key concepts and processes. Learners will understand how IT systems are planned, designed, and implemented.

    3
    Learning Outcomes
    9
    Assessment Guidance
    9
    Key Skills
    3
    Key Terms
    12
    Assessment Criteria

    Assessment criteria

    City & Guilds Level 2 Award in ICT Systems and Principles
    City & Guilds Level 2 Diploma in ICT Professional Competence
    City & Guilds Level 3 Diploma in ICT Professional Competence

    Topic Overview

    The City & Guilds Level 3 Diploma in ICT Professional Competence is a vocational qualification designed to equip students with the practical skills and theoretical knowledge required for a career in ICT. It covers a broad range of topics including network infrastructure, database design, web development, and IT project management. This diploma is recognised by employers and higher education institutions, providing a solid foundation for roles such as IT technician, network administrator, or software developer.

    The qualification emphasises hands-on learning, with assessments based on real-world scenarios and projects. Students develop problem-solving abilities, technical proficiency, and an understanding of professional standards in ICT. By the end of the course, learners are expected to demonstrate competence in planning, implementing, and maintaining ICT systems, as well as communicating effectively with stakeholders.

    This diploma fits within the wider context of UK vocational education, bridging the gap between academic study and industry requirements. It is particularly valuable for students who prefer a practical approach to learning and wish to enter the workforce directly or progress to higher-level apprenticeships or university courses in computing.

    Key Concepts

    Core ideas you must understand for this topic

    • Network infrastructure: Understanding LANs, WANs, TCP/IP, subnetting, and network security principles.
    • Database design and implementation: Normalisation, SQL queries, entity-relationship modelling, and data integrity.
    • Web development: HTML, CSS, JavaScript, responsive design, and server-side scripting (e.g., PHP).
    • IT project management: Lifecycle models (e.g., waterfall, agile), risk assessment, and documentation.
    • Professional practice: Legal and ethical issues, data protection (GDPR), and health and safety in ICT.

    Learning Objectives

    What you need to know and understand

    • Understand IT Systems and the roles of IT personnel, Understand IT Systems Development Life Cycle (SDLC) models, Understand IT Systems Development Life Cycle (SDLC) concepts and processes
    • Understand IT Systems and the roles of IT personnel, Understand IT Systems Development Life Cycle (SDLC) models, Understand IT Systems Development Life Cycle (SDLC) concepts and processes
    • Understand IT Systems and the roles of IT personnel, Understand IT Systems Development Life Cycle (SDLC) models, Understand IT Systems Development Life Cycle (SDLC) concepts and processes

    Assessment Criteria

    Key criteria assessors look for in your portfolio

    • Describe the roles and responsibilities of IT personnel.
    • Explain different SDLC models such as Waterfall and Agile.
    • Identify key stages in the SDLC and their purposes.
    • Understand the importance of requirements gathering and testing.
    • Recognise the impact of SDLC on project success.
    • Describe the roles and responsibilities of IT personnel in development.
    • Compare different SDLC models such as Waterfall and Agile.
    • Explain key concepts like requirements gathering and testing.
    • Identify processes in each phase of the SDLC.
    • Describes IT systems and roles of IT personnel.
    • Explains different SDLC models (e.g., waterfall, agile).
    • Identifies SDLC concepts and processes.

    Assessment Guidance

    Guidance for achieving higher grades

    • 💡Create a table comparing SDLC models for quick revision.
    • 💡Use real-world examples to illustrate SDLC stages.
    • 💡Focus on the purpose of each phase, not just the name.
    • 💡Use diagrams to illustrate SDLC phases.
    • 💡Give real-world examples of each model's application.
    • 💡Link roles to specific SDLC activities.
    • 💡Compare and contrast waterfall and agile models.
    • 💡Know the key roles: business analyst, developer, tester, project manager.
    • 💡Understand the phases: requirements, design, implementation, testing, deployment, maintenance.
    • 💡When answering scenario-based questions, always relate your answer to the specific context given. For example, if asked about network design for a small business, consider budget constraints and scalability.
    • 💡In database tasks, ensure your SQL syntax is correct and test your queries mentally. Pay attention to JOIN types (INNER, LEFT, RIGHT) and aggregate functions (COUNT, SUM, AVG).
    • 💡For project management questions, use the correct terminology (e.g., 'critical path', 'Gantt chart') and explain how each tool helps manage time, cost, or quality.

    Common Mistakes

    Common errors to avoid in your coursework

    • Confusing the roles of different IT personnel.
    • Mixing up phases of different SDLC models.
    • Underestimating the importance of testing and maintenance.
    • Confusing roles of developers, testers, and project managers.
    • Mixing up phases of different SDLC models.
    • Omitting the importance of user acceptance testing.
    • Confusing SDLC with project management methodologies.
    • Not understanding the iterative nature of agile.
    • Overlooking the importance of testing and maintenance phases.
    • Misconception: SQL is only about SELECT queries. Correction: SQL includes DDL (CREATE, ALTER), DML (INSERT, UPDATE, DELETE), and DCL (GRANT, REVOKE) commands, all of which are essential for database management.
    • Misconception: Network security is just about firewalls. Correction: Effective security requires a layered approach including encryption, access controls, intrusion detection, and regular updates.
    • Misconception: Agile means no planning. Correction: Agile involves iterative planning, with sprints, daily stand-ups, and retrospectives to adapt to changing requirements.

    Frequently Asked Questions

    Common questions students ask about this topic

    Pass / Merit / Distinction Evidence Checklist

    How your portfolio evidence is graded for CITY & GUILDS LIMITED Introduction to IT systems development

    Every vocational unit is marked against named criteria rather than an exam percentage. Your tutor's brief lists the exact codes for this unit — here is what each band is asking you to do.

    Pass (P)

    Demonstrate baseline knowledge, accurate terminology, and core practical application.

    Merit (M)

    Provide detailed analysis, structured explanations, and clear workplace reasoning.

    Distinction (D)

    Deliver thorough evaluation, original problem solving, and fully justified recommendations.

    Before You Start

    Prior knowledge that will help with this topic

    • Basic understanding of computer hardware and software components.
    • Familiarity with file management and operating systems (e.g., Windows, Linux).
    • Foundational maths skills, particularly for subnetting and database queries.

    Coursework AI Review

    Paste your assignment brief and check your draft against its P/M/D criteria

    Key Terminology

    Essential terms to know

    • Understand IT Systems and the roles of IT personnel, Understand IT Systems Development Life Cycle (SDLC) models, Understand IT Systems Development Life Cycle (SDLC) concepts and processes
    • Understand IT Systems and the roles of IT personnel, Understand IT Systems Development Life Cycle (SDLC) models, Understand IT Systems Development Life Cycle (SDLC) concepts and processes
    • Understand IT Systems and the roles of IT personnel, Understand IT Systems Development Life Cycle (SDLC) models, Understand IT Systems Development Life Cycle (SDLC) concepts and processes

    Ready to learn?

    AI-powered learning tailored to this unit