Software development fundamentals
CITY & GUILDS LIMITED
Vocational
This topic covers software development fundamentals including programming, OOP, web and desktop applications, and databases. Learners will apply knowledge to create applications and manage data.
8
Learning Outcomes
24
Assessment Guidance
24
Key Skills
8
Key Terms
35
Assessment Criteria
Assessment criteria
City & Guilds Level 3 Diploma in ICT Systems Support
City & Guilds Level 3 Certificate in ICT Systems and Principles
City & Guilds Level 2 Certificate in ICT Systems Support
City & Guilds Level 2 Diploma in ICT Professional Competence
City & Guilds Level 3 Diploma in ICT Professional Competence
City & Guilds Level 3 Diploma in ICT Systems and Principles for IT Professionals
City & Guilds Level 2 Diploma in ICT Systems Support
City & Guilds Level 2 Diploma in ICT Systems and Principles for IT Professionals
Quick Revision Summary (Key Takeaway)
The City & Guilds Level 2 Diploma in ICT Professional Competence covers essential IT skills, including hardware, software, networking, and professional practice. This qualification prepares students for entry-level ICT roles by developing practical competence in installing, configuring, and supporting ICT systems.
Topic Overview
The City & Guilds Level 2 Diploma in ICT Professional Competence is a vocational qualification that equips learners with the practical skills and knowledge required for a career in ICT support and administration. The diploma covers a broad range of topics, including computer hardware, software installation, networking fundamentals, and professional communication. It is designed to reflect real-world IT environments, ensuring that students are job-ready upon completion.
This qualification is essential for those seeking roles such as IT support technician, network administrator, or helpdesk analyst. It emphasizes hands-on competence, with assessments that test both theoretical understanding and practical application. The curriculum is aligned with industry standards, making it highly valued by employers in the UK.
The diploma also develops soft skills like problem-solving, teamwork, and customer service, which are critical in the ICT sector. By studying this qualification, students gain a solid foundation for further study, such as an advanced apprenticeship or a Level 3 qualification, and they build confidence in using technology to solve business problems.
Key Concepts
Core ideas you must understand for this topic
- →Hardware components: CPU, RAM, storage devices, and their functions.
- →Software installation and configuration, including operating systems and applications.
- →Networking fundamentals: IP addressing, protocols, and network devices.
- →Health and safety in ICT, including ergonomics and electrical safety.
- →Professional communication and customer service skills in an IT context.
Learning Objectives
What you need to know and understand
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
Assessment Criteria
Key criteria assessors look for in your portfolio
- Explain core programming concepts and structures.
- Describe object-oriented programming principles.
- Develop a simple application using appropriate tools.
- Store and retrieve data using a database.
- Understands core programming concepts.
- Explains object-oriented programming principles.
- Identifies software requirements for different applications.
- Creates applications using appropriate technologies.
- Stores and uses data effectively.
- Demonstrate understanding of core programming fundamentals.
- Explain object-oriented programming concepts.
- Identify requirements for software and web application development.
- Apply knowledge to create applications and use databases.
- Understand core programming concepts like variables, loops, and functions.
- Explain object-oriented programming principles: encapsulation, inheritance, polymorphism.
- Identify requirements for software development including testing and documentation.
- Create simple desktop and web applications using appropriate languages.
- Use databases to store and retrieve data via SQL.
- Explains core programming concepts such as variables, loops, and conditionals.
- Describes the principles of object-oriented programming including classes and inheritance.
- Identifies requirements for software, web, and desktop application development.
- Demonstrates database design and data storage techniques.
- Creates a functional application that stores and retrieves data.
- Explain core programming constructs like loops and conditionals.
- Describe object-oriented principles: encapsulation, inheritance, polymorphism.
- Identify requirements for web and desktop applications.
- Demonstrate database design and data manipulation.
- Award credit for demonstrating an understanding of basic programming constructs such as variables, loops, and conditionals through correct implementation in a simple program.
- Credit should be given for accurate identification and explanation of the four pillars of object-oriented programming (encapsulation, inheritance, polymorphism, abstraction) with relevant examples.
- Assessors should look for a functional database design that includes tables with appropriate data types and relationships, as evidenced in a created schema or ER diagram.
- In the application development task, expect a working program that successfully interacts with a database, performing CRUD operations.
- Explains core programming concepts like variables and loops.
- Describes object-oriented programming principles.
- Identifies requirements for different application types.
- Creates a simple application with data storage.
Assessment Guidance
Guidance for achieving higher grades
- 💡Practice writing pseudocode before coding.
- 💡Test your code incrementally.
- 💡Understand SQL for database queries.
- 💡Practice coding regularly to build fluency.
- 💡Use version control for project management.
- 💡Test applications thoroughly before submission.
- 💡Practice writing simple programs to reinforce concepts.
- 💡Understand the software development lifecycle.
- 💡Practice writing pseudocode before actual coding.
- 💡Use version control like Git to manage code changes.
- 💡Test applications with different inputs to ensure robustness.
- 💡Use pseudocode to plan logic before coding.
- 💡Ensure database relationships are clearly defined.
- 💡Comment code to explain key sections.
- 💡Practice writing simple programs to reinforce concepts.
- 💡Use diagrams to explain OOP relationships.
- 💡Focus on SQL commands for data storage tasks.
- 💡When developing applications, always start by clearly planning and documenting your requirements before coding to ensure you meet the given specification.
- 💡For the database task, demonstrate normalization up to third normal form (3NF) to show advanced understanding.
- 💡In web development, ensure you follow responsive design principles and test your application on multiple devices.
- 💡Include comments in your code to explain your logic, as this demonstrates professionalism and aids assessment.
- 💡Practice writing pseudocode.
- 💡Understand the software development lifecycle.
- 💡Debug systematically.
- 💡Always use correct technical terminology in your answers; for example, say 'volatile memory' instead of 'temporary memory' to gain full marks.
- 💡In practical assessments, follow the exact steps you have been taught, and always check your work against the marking criteria before submitting.
- 💡For calculation questions, show all your working out, even if you are confident in the answer, as method marks are often awarded.
Common Mistakes
Common errors to avoid in your coursework
- Not understanding variable scope and data types.
- Poor error handling leading to crashes.
- Failing to normalise database design.
- Confusing syntax across different programming languages.
- Neglecting error handling in applications.
- Poor database design leading to data redundancy.
- Confusing syntax between different programming languages.
- Neglecting to test and debug code thoroughly.
- Misunderstanding scope and lifetime of variables.
- Poorly structured code lacking comments or modularity.
- Incorrect SQL syntax or failing to handle database connections.
- Confusing object-oriented programming with procedural programming.
- Neglecting to normalise databases leading to data redundancy.
- Failing to test applications thoroughly before submission.
- Mixing up OOP concepts like inheritance and polymorphism.
- Ignoring user requirements in application design.
- Poor database normalisation leading to redundancy.
- Mistaking procedural programming for object-oriented programming by not encapsulating data and behavior within classes.
- Failing to include input validation, resulting in applications that crash or produce errors when unexpected data is entered.
- Poor database design, such as creating flat tables without normalization, causing data redundancy and update anomalies.
- Not understanding the difference between local and remote databases when developing web applications.
- Confusing syntax between languages.
- Not testing code thoroughly.
- Ignoring user requirements.
- Misconception: 'The CPU is the same as the computer's memory.' Correction: The CPU (Central Processing Unit) is the processor that executes instructions, while memory (RAM) stores data temporarily for quick access.
- Misconception: 'The internet and the World Wide Web are the same thing.' Correction: The internet is the global network of interconnected computers, while the World Wide Web is a service that uses the internet to access web pages.
- Misconception: 'Cloud storage is always safer than local storage.' Correction: Cloud storage has security risks like data breaches; local storage can be more secure if properly protected, but both have pros and cons.
Revision Plan
How to revise this topic in 1–2 weeks
- 1Week 1: Focus on hardware components and their functions. Create flashcards for each component and test yourself daily.
- 2Week 2: Study networking basics, including the OSI model and IP addressing. Practice setting up a small network in a simulated environment.
- 3Week 3: Review software installation and configuration. Install a virtual machine and practice installing an operating system.
- 4Week 4: Revise professional practice and communication skills. Role-play customer service scenarios and review health and safety regulations.
- 5Final days: Complete past papers and practice questions under timed conditions to build exam technique.
Exam Question Types
How this topic typically appears in the exam
- 📋Multiple-choice questions on hardware and software definitions.
- 📋Short-answer questions requiring explanations of concepts like the difference between RAM and ROM.
- 📋Scenario-based questions where you must apply knowledge to a real-world IT problem, such as recommending a network solution.
- 📋Practical assessments where you demonstrate skills like installing software or configuring a router.
Command Word Expectations (CITY & GUILDS LIMITED)
What examiners look for when using specific command words in this specification
Describe
Provide a detailed account of the features or characteristics of a concept. For example, 'Describe the function of the CPU' requires you to explain what it does and how it works, not just name it.
Explain
Give reasons or causes for why something happens. For example, 'Explain why a switch is more efficient than a hub' requires you to discuss the technical reasons, such as reduced collisions and targeted data transmission.
Evaluate
Weigh up the pros and cons of a topic and come to a justified conclusion. For example, 'Evaluate the use of cloud storage versus local storage' requires you to discuss advantages and disadvantages and give a reasoned recommendation.
How Students Lose Marks (Examiner Pitfalls)
Common mark loss traps and how to write 100% full-mark answers
Pitfall: Students often confuse the functions of RAM and ROM, leading to incorrect answers in hardware questions.
❌ Weak Answer (Loses Marks):RAM is the memory that stores data permanently, while ROM is temporary.
✅ 100% Model Answer (Full Marks):RAM (Random Access Memory) is volatile memory used for temporary storage of data and instructions currently in use, allowing quick read/write access. ROM (Read-Only Memory) is non-volatile memory that permanently stores firmware or boot instructions, which are not lost when power is off.
Examiner Tip: Always link RAM to 'temporary' and 'volatile', and ROM to 'permanent' and 'non-volatile'. Use examples like running programs (RAM) and BIOS (ROM).
Pitfall: In networking questions, students often mix up the OSI model layers, especially the Transport and Network layers.
❌ Weak Answer (Loses Marks):The Network layer is responsible for error checking and the Transport layer handles routing.
✅ 100% Model Answer (Full Marks):The Transport layer (Layer 4) provides end-to-end communication, error recovery, and flow control (e.g., TCP/UDP). The Network layer (Layer 3) handles logical addressing and routing of packets between networks (e.g., IP).
Examiner Tip: Remember the mnemonic 'Please Do Not Throw Sausage Pizza Away' to recall the order: Physical, Data Link, Network, Transport, Session, Presentation, Application. Focus on the key functions of each layer.
Step-by-Step Worked Solutions
Detailed solution breakdown for typical exam problems
Question: A company has 200 computers and needs to connect them in a local area network. Each computer requires a network interface card (NIC) and a cable. If each NIC costs £15 and each cable costs £3, calculate the total cost of NICs and cables. Show your working.
- 1.Step 1: Identify the number of computers: 200.
- 2.Step 2: Calculate cost of NICs: 200 × £15 = £3000.
- 3.Step 3: Calculate cost of cables: 200 × £3 = £600.
- 4.Step 4: Add the two costs: £3000 + £600 = £3600.
Final Answer: The total cost is £3600.
Question: Explain the difference between a hub and a switch in a network. (6 marks)
- 1.Step 1: Define a hub: a basic device that broadcasts data to all connected devices.
- 2.Step 2: Define a switch: a more intelligent device that sends data only to the intended recipient using MAC addresses.
- 3.Step 3: Compare efficiency: switches reduce network traffic and improve performance, while hubs cause collisions and inefficiency.
- 4.Step 4: Mention security: switches provide better security as data is not sent to all devices.
- 5.Step 5: Conclude with typical usage: hubs are obsolete, switches are standard in modern networks.
Final Answer: A hub broadcasts data to all ports, causing unnecessary traffic, while a switch forwards data only to the destination device, making it more efficient and secure.
Active Recall Memory Test
Test your memory before revealing the key facts
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 Software development fundamentals
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.
- •Familiarity with using a computer, including file management and internet browsing.
- •Basic maths skills for calculations in cost and data analysis.
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
- Know the fundamentals of core programming, Know what is involved in object orientated programming, Know requirements for software development, Know requirements for web application development, Know the requirements to create desktop applications, Know databases know how to store and use data, Be able to apply knowledge to create applications and store data
Ready to learn?
AI-powered learning tailored to this unit