City & Guilds Level 2 Diploma in ICT Systems and Principles for IT Professionals

What you'll be able to do

• Know .NET framework concepts, including the Common Language Runtime (CLR) and the .NET class library.
• Know key components in the .Net framework, such as assemblies, namespaces, and types.
• Know the requirements of .Net code compilation, including the role of the compiler and the intermediate language (IL).
• Know Input/Output (I/O) classes in the .NET framework for reading and writing data to files and streams.
• Secure a .NET application, including authentication, authorisation, and encryption techniques.
• Know key aspect of .NET languages, such as C# and VB.NET, including syntax, data types, and control structures.
• Know what is involved in memory management in .NET, including garbage collection and resource disposal.
• Create .NET applications using appropriate tools and techniques.

What you'll be able to do

• Deploy server images, including selecting appropriate deployment methods and configuring deployment settings
• Manage Domain Name Systems (DNS), including configuring DNS zones, records, and resolvers
• Maintain domain controllers, including performing routine maintenance tasks, troubleshooting issues, and managing replication
• Implement a group policy infrastructure, including creating and configuring Group Policy Objects (GPOs)
• Manage remote access, including configuring VPNs and other remote access technologies
• Manage the network server, including configuring network services and managing network resources
• Optimise file services, including configuring file sharing permissions and optimising file server performance
• Manage group policy, including troubleshooting group policy issues and managing group policy settings

What you'll be able to do

• Install SQL Server, following the correct procedures and configurations.
• Use databases, including creating, modifying, and querying databases.
• Restore SQL Server databases, ensuring data integrity and availability.
• Authorise users, granting appropriate access permissions to different users.
• Audit SQL Server Environments, monitoring and analysing database activity for security and compliance purposes.
• Automate SQL Server Management, using scripting and scheduling tools to streamline administrative tasks.
• Configure security for SQL Server Agent, protecting the agent from unauthorised access and misuse.
• Perform ongoing database maintenance, including tasks such as backups, index maintenance, and performance tuning.
• Use tracing options, capturing and analysing database events to diagnose performance issues and identify potential problems.
• Manage multiple servers, administering and monitoring multiple SQL Server instances from a central location.
• Troubleshoot SQL Server administrative issues, identifying and resolving common problems related to database administration.

What you'll be able to do

• Apply matrix methods to solve IT-related problems
• Apply series, probability, and recursions in IT contexts
• Apply graph theory to model and analyse IT systems

What you'll be able to do

• Explain different business structures and the key functions within a business organisation.
• Explain the relevant legislative issues that impact business operations.
• Analyse financial information to assess business performance and make informed decisions.
• Evaluate strategic information to support business planning and decision-making.

What you'll be able to do

• Know different types of organisations, including sole traders, partnerships, limited companies, and public sector organisations
• Know the key functions within organisations, including finance, marketing, operations, and human resources
• Understand how the external environment creates the need for organisations to change, including factors such as economic conditions, technological advancements, and social trends
• Describe the main legal and regulatory issues for organisations, including employment law, data protection, and health and safety
• Know the essential financial operations within organisations, including budgeting, financial reporting, and cash flow management

What you'll be able to do

• Design a network infrastructure that meets specified requirements.
• Implement a prototype network according to the design specifications.
• Maintain a prototype network, ensuring its continued functionality and performance.

What you'll be able to do

• Configure a switched infrastructure according to specified requirements
• Test and troubleshoot a routed and switched infrastructure to identify and resolve issues
• Understand traffic filtering techniques and implement a suitable solution to manage network traffic

What you'll be able to do

• Understand the diverse types of network systems in common use
• Understand the diverse types of network devices in common use
• Explain how different network technologies operate
• Explain how different network technologies communicate
• Understand basic security and its impact on the user
• Configure cross network communication
• Troubleshoot cross network communication

What you'll be able to do

• Identify different routing protocols used in small-to-medium businesses and ISPs
• Understand the function of different routing protocols
• Configure a router to communicate with a Wide Area Network (WAN) infrastructure
• Test the functionality of a configured network system
• Troubleshoot issues within a network system using appropriate tools and techniques
• Implement address management strategies within a network environment

What you'll be able to do

• Implement a Wide Area Network (WAN) according to specified requirements.
• Test a Wide Area Network (WAN) implementation to ensure functionality.
• Troubleshoot a Wide Area Network (WAN) implementation to identify and resolve issues.
• Plan security measures for a Wide Area Network (WAN) to protect against threats.
• Evaluate the performance and security of a Wide Area Network (WAN).
• Implement security technologies to protect a Wide Area Network (WAN).
• Implement network address management technologies to efficiently manage IP addresses within a Wide Area Network (WAN).

What you'll be able to do

• Configure a switched and trunked VLAN infrastructure according to specified requirements.
• Test and troubleshoot a VLAN infrastructure to identify and resolve any issues.
• Enable a VLAN Trunk Protocol (VTP) client/server structure to operate and effectively manage a LAN environment.
• Understand the operation of wireless systems, including their configuration and security aspects.

What you'll be able to do

• Know the diverse types of network systems and devices in common use, including their functions and characteristics
• Know how different network technologies operate and communicate, including protocols and standards
• Understand the OSI and TCP/IP models and their relationship to the operation of network systems
• Configure a workstation for connection to a network, including setting up IP addresses, DNS servers, and gateway settings
• Design a sub-network scheme, including IP addressing and subnetting
• Recommend improvements to an existing network infrastructure, based on performance, security, and scalability considerations

What you'll be able to do

• Identify and understand different routing protocols, including distance vector, link-state, and path vector protocols
• Configure a router to communicate with a WAN infrastructure, including configuring routing protocols and network interfaces
• Test and troubleshoot a network system to identify faults and quality of communication, including using network diagnostic tools and techniques

What you'll be able to do

• Understand the hardware principles of a computer system
• Safely assemble and maintain a range of computer systems and their components
• Maintain operating system and security components
• Maintain network communication for a computer system

What you'll be able to do

• Understand the principles involved in managing computer systems effectively.
• Manage the support of operating systems, including installation, configuration, and troubleshooting.
• Manage and maintain networked systems, ensuring their stability and security.

What you'll be able to do

• Identify and use various Personal Computer Components effectively
• Understand Personal Computer Troubleshooting techniques for diagnosing and resolving issues
• Apply Personal Computer Repair and Maintenance procedures to ensure optimal performance
• Understand the principles and functions of Operating Systems
• Understand Basic Networking Fundamentals, including network topologies and protocols
• Understand Security Concepts and Technology related to personal computers and networks
• Understand Operational Considerations when working with Personal Computers, including safety and best practices

What you'll be able to do

• Understand the fundamental principles of computer hardware components and their functions.
• Understand the configuration and troubleshooting of various computer hardware components.
• Understand the principles of operating systems, including installation, configuration, and maintenance.
• Understand the features and functionalities of Microsoft Windows 2000, Windows XP Professional, XP Home, XP MediaCenter, Windows Vista Home, Home Premium, Business and Ultimate operating systems.
• Understand the principles of computer networking, including network topologies, protocols, and devices.
• Understand network security concepts and best practices to protect computer systems and data.

What you'll be able to do

• Understand fundamental network technologies and concepts
• Understand different types of network media, including wired and wireless options
• Understand various network topologies and their characteristics
• Understand the functions and configurations of different network devices
• Understand the roles of routers, switches, and firewalls in a network
• Understand network management principles and practices
• Understand how to monitor network performance and troubleshoot issues
• Understand the use of network management tools for configuration and monitoring
• Understand the purpose and application of various network tools
• Understand how to use network analysers and diagnostic tools
• Understand network security threats and vulnerabilities
• Understand security measures to protect networks from unauthorised access and attacks

What you'll be able to do

• Understand the principles of Systems Security
• Understand the components of Network Infrastructure
• Understand the methods of Access Control
• Understand the processes of Assessments & Audits
• Understand the principles of Cryptography
• Understand the requirements of organisational Security

What you'll be able to do

• Understand the principles of system hardware components and their functions
• Understand the configuration of system hardware components
• Understand the purpose and function of different types of software
• Understand the installation and configuration of software
• Understand different storage technologies and their applications
• Understand the configuration and management of storage solutions
• Understand the components and characteristics of the IT environment
• Understand environmental factors affecting server performance and stability
• Understand the principles of disaster recovery planning
• Understand disaster recovery procedures and techniques
• Understand troubleshooting methodologies for server-related issues
• Understand the use of diagnostic tools for troubleshooting

What you'll be able to do

• Understand the systems that support ‘Shells, Scripting and Data management’ within a Linux environment.
• Effectively manage user interfaces and desktops in a Linux operating system.
• Manage Linux-based administrative tasks, including user management and system configuration.
• Manage essential system services within a Linux environment.
• Understand networking fundamentals relevant to Linux server administration.
• Manage Linux-based security measures to protect systems and data.

What you'll be able to do

• Use shell scripting to automate tasks and manage system configurations.
• Configure a user interface, including customising the desktop environment and managing user preferences.
• Administer systems, including user account management, file system maintenance, and system monitoring.
• Manage system services, including starting, stopping, and configuring services.
• Configure networks, including setting up network interfaces, configuring routing, and managing network services.
• Secure networks, including implementing firewalls, configuring intrusion detection systems, and managing user access controls.

What you'll be able to do

• Implement advanced network services according to organisational requirements
• Implement advanced file services according to organisational requirements
• Implement Dynamic Access Control according to security policies
• Implement directory services according to organisational procedures
• Implement certificate services according to industry best practices
• Implement Rights Management Services (RMS) according to data protection regulations
• Implement Federation Services (FS) according to interoperability standards
• Implement Network Load Balancing (NLB) to ensure high availability
• Implement failover clustering to minimise downtime
• Implement disaster recovery plans to ensure business continuity

What you'll be able to do

• Install Microsoft Exchange Servers
• Configure Microsoft Exchange Servers
• Configure Recipients within Microsoft Exchange
• Configure Public Folders within Microsoft Exchange
• Configure the Exchange Infrastructure
• Monitor the Exchange Infrastructure
• Report on the Exchange Infrastructure
• Configure Disaster Recovery for Microsoft Exchange

What you'll be able to do

• Plan the installation of ISA Server 2006
• Install ISA Server 2006
• Install client computers for ISA Server 2006
• Configure client computers for ISA Server 2006
• Configure ISA Server 2006
• Manage ISA Server 2006
• Configure web caching
• Configure firewall policy
• Manage firewall policy
• Configure remote network connectivity
• Manage remote network connectivity

What you'll be able to do

• Install and manage Microsoft Office Communications Server (Communications Server) 2007 R2 effectively
• Deploy and configure Communications Server 2007 R2 clients for users
• Configure conferencing features within Communications Server 2007 R2
• Configure enterprise voice functionality within Communications Server 2007 R2
• Configure external connectivity for Communications Server 2007 R2
• Monitor and maintain Communications Server 2007 R2 to ensure optimal performance and security

What you'll be able to do

• Configure Microsoft SQL Server 2005 and Analysis Services 2005 for optimal Project Server 2007 performance.
• Configure Microsoft SharePoint to integrate effectively with Project Server 2007.
• Deploy Project Server according to specified requirements and best practices.
• Administer Project Web Access to manage user access and project data.

What you'll be able to do

• Configure System Center Operations Manager 2007, including initial setup and configuration of core components
• Deploy and configure Management Packs within System Center Operations Manager 2007, including importing, configuring, and customising packs
• Build and deploy custom Management Packs within System Center Operations Manager 2007, including authoring rules, monitors, and discoveries
• Maintain System Center Operations Manager 2007, including performing routine maintenance tasks, troubleshooting issues, and applying updates
• Configure Client Monitoring within System Center Operations Manager 2007, including agent deployment and configuration

What you'll be able to do

• Install and upgrade the Microsoft Windows Vista operating system effectively
• Configure and troubleshoot post-installation system settings to ensure optimal performance
• Configure Windows security features to protect the system from threats and vulnerabilities
• Configure network connectivity to enable seamless communication and data transfer
• Configure applications included with Windows Vista to meet specific user requirements
• Maintain and optimise systems that run Windows Vista to ensure stability and efficiency
• Configure and troubleshoot mobile computing features for users on the move

What you'll be able to do

• Configure Domain Name System (DNS) for Active Directory to ensure proper name resolution and network functionality.
• Configure the Active Directory infrastructure, including domain controllers, sites, and replication.
• Configure additional Active Directory server roles, such as DHCP, file services, and print services.
• Create and maintain Active Directory objects, including users, groups, and computers, adhering to organisational policies.
• Maintain the Active Directory environment, performing regular backups, monitoring performance, and troubleshooting issues.
• Configure Active Directory Certificate Services to enable secure communication and authentication within the domain.

What you'll be able to do

• Deploy servers within a specified environment.
• Configure terminal services to meet given requirements.
• Configure a web services infrastructure according to best practices.
• Configure network application services to ensure optimal performance.

What you'll be able to do

• Configure IP Addressing and Services within a Windows Server 2008 network infrastructure.
• Configure Name Resolution services to ensure proper network communication.
• Configure Network Access settings to control user access and security.
• Configure File and Print Services to enable resource sharing within the network.
• Monitor and Manage a Network Infrastructure using appropriate tools and techniques.

What you'll be able to do

• Install Windows operating systems on a computer
• Manage user state, including profiles and data migration
• Use Windows tools for system administration and troubleshooting
• Configure network connections, including wired and wireless connections
• Configure resource access, including file sharing and printer sharing
• Secure networks, including firewalls and intrusion detection systems
• Manage file access, including permissions and encryption
• Secure Windows devices, including passwords and biometrics
• Maintain Windows client computers, including updates and backups
• Configure applications for Windows, including installation and settings
• Configure remote access, including VPNs and remote desktop
• Configure desktop virtualisation, including virtual machines and thin clients
• Recover a Windows based operating system from a failure

What you'll be able to do

• Understand the principles of hierarchical network design and its benefits for scalability and manageability.
• Understand the different Wide Area Network (WAN) access technologies available for small to medium-sized networks.
• Configure a serial interface to enable WAN communication between network devices.
• Configure an Ethernet interface to enable broadband communication for network access.
• Implement network address translation (NAT) for IP address conservation and security.
• Configure a tunnelling protocol to enable secure site-to-site communication over a public network.
• Configure network monitoring tools and techniques to track network performance and identify issues.
• Troubleshoot data networks using appropriate diagnostic tools and methodologies.

What you'll be able to do

• Work safely with copper cabling in an internal environment, adhering to relevant health and safety regulations and guidelines.
• Understand basic electrical theory and safety principles when installing data communications cabling, mitigating potential risks.
• Install copper communication cabling following recommended installation procedures and current applicable standards, ensuring optimal performance and reliability.
• Terminate copper communication cabling using appropriate tools and techniques, creating secure and reliable connections.
• Test FTP, UTP and multicore copper links to verify performance and identify any faults or issues.

What you'll be able to do

• Explain the functions of an operating system, including resource management, process scheduling, and input/output handling
• Describe multiprogramming and multitasking systems concepts, including their benefits and limitations
• Describe file management concepts, including file systems, directories, and file permissions
• Describe the software development environment, including tools and processes used for creating and maintaining software
• Create automated procedures for ICT operating systems using scripting or other automation tools

What you'll be able to do

• Implement software solutions using procedural programming techniques
• Refine a procedural programme to improve its quality, efficiency, and maintainability
• Test the operation of a procedural programme to ensure it meets specified requirements

What you'll be able to do

• Implement a software design using procedural programming techniques, adhering to coding standards
• Refine a procedural program to improve quality, considering factors such as efficiency and maintainability
• Test the operation of a procedural program thoroughly to ensure it meets requirements
• Document a computer program clearly and comprehensively, including comments and user guides

What you'll be able to do

• Implement a software design by writing code using event driven programming principles and techniques
• Refine an event driven program to improve its quality, considering factors such as efficiency, maintainability, and user experience
• Test the operation of an event driven program to ensure it functions correctly and meets the specified requirements
• Document an event driven program, including its design, functionality, and usage instructions

What you'll be able to do

• Implement software using event driven programming techniques.
• Refine an event driven program to improve its overall quality and performance.
• Test the operation of an event driven program to ensure it functions correctly and meets specified requirements.

What you'll be able to do

• Implement software solutions using object-oriented programming principles
• Refine an object-oriented program to improve its overall quality and efficiency
• Test the operation of an object-oriented program to ensure it functions as intended
• Analyse test results and implement necessary modifications to the program

What you'll be able to do

• Implement a software design using object oriented programming techniques
• Refine an object oriented program to improve its quality and performance
• Test the operation of an object oriented driven program to ensure it functions correctly
• Document an object oriented driven program, including its design and functionality

What you'll be able to do

• Identify and analyse a problem, defining its scope and impact.
• Plan, monitor, and evaluate the implementation of a problem solution, ensuring its effectiveness and efficiency.
• Review their approach to problem solving and the proposed problem solution, identifying areas for improvement and learning.

What you'll be able to do

• Provide technical information and support in response to customer requirements.
• Identify potential improvements in the customers’ use of resources.
• Assist in reviews to identify how automated procedures may improve customers’ use of resources.
• Create routine automated procedures and assist in the creation of complex automated procedures.

What you'll be able to do

• Manipulate real numbers and integers within IT applications.
• Use co-ordinate systems, vectors, and linear transformations in IT contexts.
• Use simple functions and basic algebraic operations to solve IT-related problems.
• Apply Boolean algebra to analyse and resolve problem situations in IT.

What you'll be able to do

• Enter structured information into a database
• Edit structured information within a database
• Organise structured information within a database
• Use database software tools to extract information
• Use database software tools to produce reports

What you'll be able to do

• Create non-relational database tables according to requirements
• Modify non-relational database tables to meet changing needs
• Enter structured information accurately into a database
• Edit structured information within a database effectively
• Organise structured information within a database logically
• Use database software tools to run queries effectively
• Use database software tools to produce reports that meet specified requirements

What you'll be able to do

• Plan the structure of relational database tables to meet specific requirements.
• Create and modify relational database tables using appropriate database management system tools.
• Enter, edit, and organise structured information within a database, ensuring data integrity.
• Use database software tools to create, edit, and run data queries to retrieve specific information.
• Produce reports from the database, presenting data in a clear and organised manner.

What you'll be able to do

• Deploy the 2007 Microsoft Office System to client desktops.
• Configure Windows Vista Automated Installation Settings for efficient deployment.
• Deploy Windows Vista operating system to client desktops.
• Use Business Desktop Deployment (BDD) Workbench to streamline the deployment process.
• Use the Application Compatibility Toolkit to address application compatibility issues.
• Manage User State Migration during operating system deployment.

What you'll be able to do

• Obtain, insert and combine information from various sources for designs, ensuring accuracy and relevance
• Use design software tools to create, manipulate and edit designs, applying appropriate techniques and features

What you'll be able to do

• Obtain, insert, and combine information from various sources to inform software designs.
• Use design software tools to create, manipulate, and edit designs according to specifications.

What you'll be able to do

• Obtain, insert and combine relevant information effectively for software designs
• Use design software tools proficiently to create, manipulate and edit software designs

What you'll be able to do

• Survey a site for the provision of an external overhead telecoms infrastructure, understanding the factors that need to be considered.
• Survey a site for the provision of an external overhead telecoms infrastructure, accurately recording relevant information.
• Produce preliminary designs for the provision of an external overhead communications cabling infrastructure and select an optimum solution, understanding the design principles and selection criteria.
• Produce preliminary designs for the provision of an external overhead Communications cabling infrastructure and select an optimum solution, creating viable design options and justifying the chosen solution.
• Produce a design for the provision of an external overhead communications cabling infrastructure, understanding the detailed design requirements.
• Produce a design for the provision of an external overhead communications cabling infrastructure, creating a comprehensive and accurate design document.

What you'll be able to do

• Conduct a preliminary site survey for the provision of an external underground communications infrastructure.
• Survey a site to determine the requirements for the provision of an external underground communications cabling infrastructure.
• Produce preliminary designs for the provision of an external underground communications cabling infrastructure and select an optimum solution.
• Produce preliminary designs for the provision of an external underground communications cabling infrastructure and select an optimum solution based on given criteria.
• Produce a detailed design for the provision of an external underground communications cabling infrastructure, incorporating relevant standards and regulations.
• Plan and produce a comprehensive design for the provision of an external underground communications cabling infrastructure, taking into account all relevant factors such as cost, environmental impact, and future scalability.

What you'll be able to do

• Survey a site to determine the requirements for the provision of an internal network cabling infrastructure
• Survey a site accurately and comprehensively for the provision of an internal network cabling infrastructure
• Identify a range of viable options for the provision of an internal network cabling infrastructure and select the optimum solution based on identified needs
• Produce schematic designs and detailed plans that clearly outline the provision of an internal network cabling infrastructure
• Co-ordinate the practical provision of an internal network cabling infrastructure, ensuring efficient and effective implementation

What you'll be able to do

• Envisage and design an application based on given requirements and specifications
• Design and develop an application framework that provides a foundation for building enterprise applications
• Design application components that are modular, reusable, and maintainable
• Stabilise and test an application to ensure its reliability, performance, and security
• Migrate, deploy, and maintain an application in a production environment, addressing any issues that arise

What you'll be able to do

• Select and use appropriate designs and page layouts for publications, considering the target audience and purpose
• Input and combine text and other information within publications, including images, graphics, and tables
• Use desktop publishing software techniques to edit and format publications, including typography, colour management, and page layout

What you'll be able to do

• Select and use appropriate designs and page layouts for publications, considering the target audience and purpose of the publication.
• Input and combine text and other information within publications, ensuring accuracy and consistency.
• Use desktop publishing software techniques to edit and format publications, including text formatting, image manipulation, and page layout adjustments.

What you'll be able to do

• Select and use appropriate designs and page layouts for publications to meet specific communication objectives.
• Input and combine text and other information within publications, ensuring accuracy and consistency.
• Use desktop publishing software techniques to edit and format publications, enhancing their visual appeal and readability.

What you'll be able to do

• Query and display data from a single table using SQL
• Query and display data from multiple tables using SQL
• Manipulate data within tables using SQL commands
• Create and manage tables, views, and indexes using SQL
• Control user access to database objects using SQL

What you'll be able to do

• Understand the principles of application security and its importance
• Understand application security features and how they protect against threats
• Understand network security considerations for mobile applications
• Understand data security measures for protecting sensitive information in mobile apps
• Understand secure Java coding practices for developing secure Android applications

What you'll be able to do

• Understand the fundamental principles of application security in the context of mobile applications.
• Understand the core concepts of Objective-C coding relevant to iOS application development.
• Understand the various application security features available within the iOS operating system.
• Understand the principles of network security as they apply to mobile applications and data transmission.
• Understand the methods and techniques for ensuring data security within mobile applications, including storage and access control.
• Understand the techniques involved in application hardening to protect against common vulnerabilities and attacks.

What you'll be able to do

• Input, organise, and combine information effectively for the creation of drawings or plans.
• Use a range of tools and techniques to edit, manipulate, format, and present drawings or plans to a professional standard.

What you'll be able to do

• Input, organise, and combine information effectively for the creation of drawings or plans
• Use appropriate tools and techniques to edit, manipulate, format, and present drawings or plans to a professional standard

What you'll be able to do

• Input information accurately into drawing or planning software
• Organise information effectively within the drawing or planning software environment
• Combine different types of information to create comprehensive drawings or plans
• Use appropriate tools and techniques to edit drawings or plans
• Manipulate drawing elements to achieve desired visual effects and accuracy
• Format drawings or plans to meet specific standards and requirements
• Present drawings or plans in a clear and professional manner

What you'll be able to do

• Know the safety rules for working with optical fibres in an external environment to prevent injury and damage.
• Follow recommended installation procedures and current standards to ensure the integrity and performance of fibre optic cabling.
• Prepare fibre optic cable for fibre splicing, ensuring proper alignment and cleanliness.
• Joint fibre optic cables by splicing, creating a low-loss connection.
• Terminate fibre optic cables by splicing on pre-terminated pigtails, providing a secure and reliable connection.
• Test fibre optic links to verify signal strength and identify any faults.

What you'll be able to do

• Know the safety rules for working with optical fibres in an internal environment.
• Work safely with optical fibres in an internal environment.
• Work safely with optical fibres in an internal environment.

What you'll be able to do

• Know core database concepts, including data types, tables, relationships, and indexes.
• Create database objects, such as tables, views, and stored procedures.
• Manipulate data using SQL commands, such as SELECT, INSERT, UPDATE, and DELETE.
• Know how data is stored in a database, including file structures and storage engines.
• Know database administration tasks, such as backup and recovery, security management, and performance tuning.
• Create and configure a database, including setting up users, permissions, and storage parameters.

What you'll be able to do

• Operate Linux based operating systems effectively.
• Use package management tools to install and update software.
• Use Linux based operating system commands to perform common tasks.
• Manage files and directories within a Linux based operating system.

What you'll be able to do

• Know different operating system configurations and their purposes
• Know the hardware and software requirements for installing client systems
• Manage applications, including installation, configuration, and removal
• Manage file systems, including creating, formatting, and maintaining file systems
• Manage devices, including installing, configuring, and troubleshooting devices
• Know operating system maintenance procedures, including updates, backups, and security measures
• Configure Windows based operating systems, including setting up user accounts, network connections, and security settings

What you'll be able to do

• Know the fundamental hardware and software components of a server.
• Know the different roles a server can perform within a network environment.
• Know the various types of server storage solutions, including RAID configurations and network attached storage (NAS).
• Know the purpose and functionality of Active Directory in managing users, computers, and resources within a domain.
• Know the key performance indicators (KPIs) involved in server performance management and monitoring.
• Know the essential tasks involved in server maintenance, including patching, backups, and security updates.
• Administer Windows-based servers, including user management, resource allocation, and troubleshooting.

What you'll be able to do

• Know the key aspects of game design, including game genres, target audiences, and design principles.
• Know the different types of gaming hardware, including consoles, PCs, and mobile devices, and their management requirements.
• Create gaming graphics, including 2D and 3D assets, textures, and special effects.
• Implement gaming animation, including character animation, environmental animation, and special effects animation.
• Create games using appropriate software and tools, incorporating design principles, graphics, and animation.

What you'll be able to do

• Manage the application life cycle, including planning, development, testing, and deployment
• Build the user interface using HTML5, incorporating semantic elements and accessibility features
• Format the user interface using CSS, applying styles and layouts for different devices and screen sizes
• Code using JavaScript to add interactivity and dynamic behaviour to web applications
• Create HTML5 based web applications that meet specified requirements and user needs

What you'll be able to do

• Describe the legislative requirements for repair centre operations
• Detail specific technical resource requirements for repair centre operations
• Develop a repair centre specification
• Provide technical support to others

What you'll be able to do

• Monitor the operation of ICT systems to ensure optimal performance and identify potential issues.
• Operate and maintain systems and peripherals according to established procedures and manufacturer guidelines.
• Perform back-up and restoration of data to ensure data integrity and business continuity in the event of system failure or data loss.

What you'll be able to do

• Understand the principles of application security and vulnerabilities
• Understand methods for securing applications against threats
• Assemble a desktop computer to meet specified requirements
• Select appropriate hardware components for a desktop computer
• Use preventative maintenance techniques to maintain computer systems
• Perform routine maintenance tasks on computer hardware and software
• Install operating systems on computer systems
• Configure operating system settings
• Know the principles of networks and networking technologies
• Know different network topologies and protocols
• Understand the components of a basic laptop computer
• Understand the functions of laptop components
• Understand the capabilities of mobile devices such as smartphones and tablets
• Understand the features and limitations of mobile devices
• Network computers and mobile devices together
• Configure network settings on computers and mobile devices
• Configure printers for network access
• Troubleshoot printer connectivity issues
• Know security requirements for computer systems and networks
• Know security best practices for protecting data and systems
• Understand the roles and responsibilities of the IT professional
• Understand ethical considerations for IT professionals
• Troubleshoot problems with computer systems and networks
• Diagnose and resolve common IT issues

What you'll be able to do

• Use test equipment and diagnostic software to determine the condition of equipment accurately
• Dismantle and re-assemble common types of ICT hardware safely and effectively
• Identify and apply remedial solutions for failures in equipment, following established procedures

What you'll be able to do

• Understand the role that the consultant plays in helping to bring about technology driven organisational change
• Structure a client assignment and specify the key management deliverables involved
• Capture, document and present back the functional requirements of business users
• Agree and document the manner in which the success of an assignment will be judged
• Use standard techniques to plan and control the work involved in producing the products associated with a consulting assignment
• Manage the client during an assignment and develop an appreciation of the challenges faced when dealing with difficult clients

What you'll be able to do

• Know the key aspects of security layers within IT systems.
• Know the requirements and issues related to operating systems security.
• Know the requirements to establish network security within an organisation.
• Know the protection options available for system security.
• Configure security settings for IT systems.

What you'll be able to do

• Obtain, insert, and combine information from various sources to create composite images
• Use imaging software tools to create original images from scratch
• Use imaging software tools to manipulate existing images to achieve desired effects
• Use imaging software tools to edit images, including adjusting colour, brightness, and contrast

What you'll be able to do

• Obtain, insert and combine information from various sources for use in images
• Use imaging software tools to create new images
• Use imaging software tools to manipulate existing images
• Use imaging software tools to edit images

What you'll be able to do

• Obtain information for images from various sources
• Insert information into images
• Combine different types of information within images
• Use imaging software tools to create images
• Use imaging software tools to manipulate images
• Use imaging software tools to edit images

What you'll be able to do

• Implement over-the-air (OTA) technologies for mobile device management.
• Understand the network infrastructure required to support a mobile computing environment.
• Manage mobile devices effectively, including configuration and monitoring.
• Understand mobile security issues and implement appropriate security measures.
• Troubleshoot mobile problems and provide effective solutions.

What you'll be able to do

• Understand fundamental networking concepts, including network topologies, protocols, and addressing schemes.
• Implement networks according to given specifications, configuring network devices and services.
• Understand the components of network infrastructure, including hardware, software, and cabling.
• Manage networks effectively, monitoring performance, troubleshooting issues, and maintaining network security.
• Secure networks against unauthorised access and cyber threats, implementing security measures and protocols.

What you'll be able to do

• Implement tables and views within a Microsoft SQL Server 2008 database.
• Implement programming objects such as stored procedures, functions, and triggers.
• Work with fundamental query techniques to retrieve and manipulate data.
• Apply additional query techniques, including subqueries, joins, and aggregations.
• Work with additional SQL Server components, such as indexes, constraints, and security features.
• Work with XML data within a SQL Server database.
• Gather performance information to optimise database queries and overall performance.

What you'll be able to do

• Understand the hardware requirements for a data warehouse, including server specifications and storage capacity.
• Implement a data warehouse solution, including database design and configuration.
• Create an Extract, Transform and Load (ETL) solution for populating the data warehouse.
• Implement an incremental ETL process to update the data warehouse with new data.
• Use a cloud data warehousing solution, understanding its benefits and limitations.
• Use Data Quality Services (DQS) to ensure data accuracy and consistency.
• Use Master Data Services to manage and maintain master data entities.
• Use SSIS packages to automate data integration and transformation tasks.
• Understand the principles and applications of Business Intelligence (BI) in data warehousing.

What you'll be able to do

• Analyse and identify ICT system security issues and vulnerabilities
• Implement security measures on email and instant messaging systems to protect against threats
• Implement and maintain internet and network security protocols to safeguard the ICT system
• Maintain data integrity and system security through appropriate policies and procedures

What you'll be able to do

• Install and configure Microsoft SQL Server 2008 according to best practices
• Maintain SQL Server instances to ensure their ongoing stability and performance
• Manage SQL Server security effectively to protect sensitive data
• Maintain a SQL Server database to ensure data integrity and availability
• Perform data management tasks, including backup, recovery, and migration
• Monitor and troubleshoot SQL Server to identify and resolve performance issues
• Optimise SQL Server performance to improve query execution and overall system responsiveness
• Implement high availability solutions to minimise downtime and ensure business continuity

What you'll be able to do

• Understand fundamental cloud computing concepts and terminology
• Understand different cloud service models (IaaS, PaaS, SaaS)
• Understand cloud deployment models (Public, Private, Hybrid, Community)
• Create a cloud infrastructure based on specified requirements
• Configure virtual machines and storage within a cloud environment
• Deploy applications and services to a cloud platform
• Manage networks associated with cloud computing, including virtual networks and subnets
• Configure network security groups and firewalls in a cloud environment
• Implement network connectivity between on-premises and cloud environments
• Undertake systems management tasks in a cloud environment, including monitoring and maintenance
• Implement backup and disaster recovery procedures for cloud-based systems
• Troubleshoot common issues related to cloud infrastructure and services

What you'll be able to do

• Prepare the IT infrastructure to deploy Microsoft Office Live Communications Server 2005.
• Install Microsoft Office Live Communications Server 2005.
• Implement remote user access and federation within Live Communications Server 2005.
• Manage a Live Communication Server infrastructure effectively.
• Configure Microsoft Office Communicator 2005 for optimal performance.

What you'll be able to do

• Prepare hardware and equipment for installation according to manufacturer guidelines and safety regulations.
• Install hardware and equipment according to specified configurations and industry best practices.
• Configure hardware and equipment to meet specific system requirements and user needs.
• Test installed hardware and equipment to verify proper functionality and performance.
• Prepare for the installation and upgrade of an operating system, including backing up data and verifying system compatibility.
• Carry out the installation and upgrade of an operating system, following documented procedures and best practices.
• Document the installation and upgrade of an operating system, including configuration settings and troubleshooting steps.
• Configure an installed operating system to meet specific user requirements and security policies.
• Test an installed operating system to ensure stability, performance, and compatibility with applications and hardware.

What you'll be able to do

• Install system hardware
• Implement Network Operating System (NOS) software
• Configure storage
• Implement server access
• Implement disaster recovery
• Troubleshoot server problems

What you'll be able to do

• Carry out risk assessments to identify potential hazards during installation activities
• Ensure health and safety procedures are followed at all times to maintain a safe working environment
• Survey the user environment to assess requirements for hardware equipment and systems installation
• Install hardware equipment and systems according to manufacturer specifications and industry best practices
• Install and configure systems software to ensure proper functionality and compatibility
• Expand ICT systems through integration of additional hardware and software components to provide enhanced facilities

What you'll be able to do

• Prepare for, carry out, and document the installation of software according to organisational procedures
• Configure installed software to meet user and system requirements
• Test installed software to ensure correct functionality and resolve any identified problems
• Operate installed software effectively to perform required tasks
• Uninstall standard application software following established procedures

What you'll be able to do

• Identify network concepts and terminology, including protocols, topologies, and addressing schemes
• Configure installed software according to specified parameters and network requirements
• Test and install software and resolve problems, ensuring compatibility and functionality
• Operate installed software according to standard operating procedures
• Uninstall standard application software according to organisational guidelines

What you'll be able to do

• Prepare thoroughly for the installation of software, ensuring compatibility and necessary prerequisites are met.
• Install and configure a range of system and application software according to specified requirements.
• Check that the system operates as planned during and after the installation of system and application software, verifying functionality and stability.
• Resolve any unwanted changes to the system caused by the installation and configuration of system and application software, restoring the system to its desired state.

What you'll be able to do

• Deploy Windows based servers according to organisational requirements and best practices.
• Understand the role and function of domain controllers in a Windows Server environment.
• Manage user accounts, including creation, modification, and deletion, in accordance with security policies.
• Implement Internet Protocol (IP) addressing and subnetting for network communication.
• Implement dynamic host configuration protocols (DHCP) to automatically assign IP addresses to network devices.
• Implement domain name systems (DNS) to resolve domain names to IP addresses.
• Configure server storage, including RAID configurations and disk management.
• Manage group policy to enforce security settings and configurations across the domain.
• Implement server virtualization using appropriate technologies and best practices.

What you'll be able to do

• Understand the role of networking within a business context and its impact on communication and collaboration.
• Understand how standardisation supports interoperable end-to-end communications across different network devices and systems.
• Understand the process by which devices access network resources using the TCP/IP suite of protocols.
• Design an IP addressing scheme to provide network connectivity for a given network infrastructure.
• Implement network connectivity between devices using appropriate cabling, hardware, and protocols.
• Configure network access controls and security measures to protect network resources.
• Configure initial Inter Network Operating System (IOS) device settings for routers and switches.

What you'll be able to do

• Investigate existing ICT systems and processes to understand their current functionality and limitations.
• Analyse gathered information to identify customer needs, requirements, and constraints for new or improved ICT systems.

What you'll be able to do

• Understand core database concepts such as relational databases and data modelling
• Understand the principles of database design
• Create database objects such as tables, views and indexes
• Define data types and constraints
• Manipulate data using SQL commands
• Insert, update and delete data in a database
• Understand data storage concepts such as filegroups and partitioning
• Understand how data is physically stored in a database
• Administer a database, including backup and recovery
• Manage user access and permissions

What you'll be able to do

• Understand Network Infrastructures
• Understand Network Hardware
• Understand Protocols and Services

What you'll be able to do

• Understand security layers
• Understand operating system security
• Understand network security
• Understand security software

What you'll be able to do

• Understand the core principles of programming and their application in software development.
• Understand the fundamental concepts of object-oriented programming, including classes, objects, inheritance, and polymorphism.
• Understand the general software development lifecycle, methodologies, and best practices.
• Understand the architecture, technologies, and development processes involved in creating web applications.
• Understand the architecture, technologies, and development processes involved in creating desktop applications.
• Understand the fundamental concepts of databases, including data models, database management systems, and SQL.

What you'll be able to do

• Understand how to program web applications
• Understand how to work with data and services in web applications
• Understand how to troubleshoot and debug web applications
• Understand how to work with client-side scripting
• Understand how to configure and deploy web applications

What you'll be able to do

• Understand Windows programming basics
• Understand how to create Windows Forms applications
• Understand how to create Windows Services applications
• Understand how to access data in a Windows Forms application
• Understand how to deploy a Windows application

What you'll be able to do

• Identify different types of system maintenance procedures and their applications.
• Collect information on technical problems encountered with ICT systems, using appropriate methods and tools.
• Evaluate technical problems with ICT systems to determine the root cause and potential impact.
• Implement solutions to resolve identified technical problems with ICT systems, following established procedures.

What you'll be able to do

• Identify hazards associated with ICT equipment and implement measures to reduce risks to systems and personnel.
• Identify failures in ICT equipment and apply appropriate fixes to restore functionality.
• Apply preventative maintenance procedures to ICT systems to ensure optimal performance and longevity.

What you'll be able to do

• Implement management procedures for a Windows based operating system
• Implement an installation strategy for a Windows based system
• Implement Windows authentication methods to secure a system
• Implement intranet connectivity for a Windows based system
• Implement an application strategy for Windows based systems
• Implement a solution for managing user settings within Windows
• Configure access to cloud services from a Windows based system
• Implement access to file and print services within a Windows environment
• Implement encryption techniques for Windows based systems
• Implement endpoint security measures for Windows based systems
• Implement extranet connectivity for a Windows based system
• Implement recovery solutions for Windows based systems

What you'll be able to do

• Create Services using Windows Communication Foundation.
• Expose and Deploy Services effectively within the .NET Framework 3.5.
• Instrument and Administer Services to ensure optimal performance and reliability.
• Consume Services from other applications and systems.
• Secure Services to protect sensitive data and prevent unauthorised access.
• Manage the Service Life Cycle, including versioning and maintenance.

What you'll be able to do

• Create a User Interface (UI) for a Windows Forms Application by Using Standard Controls
• Integrate Data in a Windows Forms Application
• Implement Printing and Report Functionality in a Windows Forms Application
• Enhance Usability within a Windows Forms Application
• Implement Asynchronous Programming Techniques to Improve the User Experience
• Develop Windows Forms Controls
• Configure and Deploy Applications

What you'll be able to do

• Configure dimensions within Microsoft Office PerformancePoint Server 2007.
• Configure models within Microsoft Office PerformancePoint Server 2007.
• Configure business roles and process management within Microsoft Office PerformancePoint Server 2007.
• Develop business rules within Microsoft Office PerformancePoint Server 2007.
• Build Microsoft Office Excel Add-In forms and reports.
• Develop dashboards using Microsoft Office PerformancePoint Server 2007.
• Install PerformancePoint Server.

What you'll be able to do

• Configure Tools and Options within Microsoft Office Project 2007
• Set Up a Project using Microsoft Office Project 2007
• Estimate, Schedule, and Budget Tasks within a project using Microsoft Office Project 2007
• Resource Project Plans using Microsoft Office Project 2007
• Update and Report on Project Performance using Microsoft Office Project 2007

What you'll be able to do

• Initiate Projects using Microsoft Office Project Server 2007
• Plan Projects using Microsoft Office Project Server 2007, defining tasks, resources, and timelines
• Execute Projects using Microsoft Office Project Server 2007, managing tasks and resources
• Monitor and Control Projects using Microsoft Office Project Server 2007, tracking progress and addressing issues
• Manage Project Professional and PWA Environments, configuring settings and managing user access

What you'll be able to do

• Manage Enterprise Content effectively
• Audit Windows SharePoint Services content by using a custom policy
• Create Business Intelligence Solutions by Using Office SharePoint Server 2007
• Integrate Business Data with Office SharePoint Server 2007 by Using the Business Data Catalog (BDC)
• Access Office SharePoint Server 2007 Application Platform Services
• Search Data by Using the Search Service
• Target Content Based on Audience Membership
• Customise Functionality by Using Profiles

What you'll be able to do

• Understand mobile phone capabilities, including hardware and software features
• Understand the use of data with mobile devices, including data storage, transfer, and security considerations
• Understand the mobile application development environment, including platforms, tools, and frameworks
• Understand how to develop mobile applications, including design principles, coding practices, and testing procedures
• Create mobile applications that meet specified requirements and function effectively on target devices

What you'll be able to do

• Plan the content and organisation of multimedia products to meet identified needs.
• Obtain, input, and combine content effectively to build multimedia outcomes.
• Use multimedia software tools to edit and format multimedia content to meet specified requirements.
• Play and present multimedia outcomes in a suitable format.

What you'll be able to do

• Plan the content and organisation of multimedia products to meet identified user needs and project specifications
• Obtain, input, and combine various content types (e.g., text, images, audio, video) to build multimedia outcomes
• Use appropriate software tools and techniques to build and edit multimedia content effectively
• Play and present multimedia outcomes in a suitable format for the intended audience

What you'll be able to do

• Plan the content and organisation of multimedia products to meet needs, considering target audience and objectives.
• Obtain, input and combine content to build multimedia outcomes, ensuring compatibility and accessibility.
• Use multimedia software tools to edit and format multimedia content to meet requirements, optimising for different platforms and devices.
• Play and present multimedia outcomes, evaluating their effectiveness and making necessary adjustments.

What you'll be able to do

• Know the key aspects of network infrastructures, including their components and functions.
• Know the different types of network hardware and their specific uses.
• Know the various networking protocols and their roles in data transmission.
• Know the different networking services and their applications.
• Set up networks according to specified requirements.

What you'll be able to do

• Understand physical topologies, including their characteristics and advantages.
• Understand logical topologies, including their characteristics and advantages.
• Understand different networking systems and their components.
• Understand the purpose and functions of each layer of the Open System Interconnection (OSI) model.
• Understand the protocols and standards associated with each layer of the OSI model.
• Understand the components and protocols of the Internet Protocol Suite (TCP/IP).
• Understand the process of data transmission using the TCP/IP model.

What you'll be able to do

• Know the functions and layers of the OSI model and the TCP/IP suite.
• Know different network topologies, including their characteristics and applications.
• Know different transmission systems used in networking, such as wired and wireless technologies.
• Know the advantages and disadvantages of different types of network, considering factors like cost, performance, and security.
• Know media access control methods used in local area networks, including their purpose and operation.

What you'll be able to do

• Input and combine text and other information within presentation slides.
• Use presentation software tools to structure, edit and format slides effectively.
• Prepare slides for presentation to meet specific needs and objectives.

What you'll be able to do

• Input text and other information within presentation slides
• Combine text and other information within presentation slides
• Use presentation software tools to structure slide sequences
• Use presentation software tools to edit slide sequences
• Use presentation software tools to format slide sequences
• Prepare a slideshow for presentation

What you'll be able to do

• Input and combine text and other information within presentation slides
• Use presentation software tools to structure, edit and format presentations
• Prepare interactive slideshow for presentation

What you'll be able to do

• Understand the characteristics of cloud services, including scalability, elasticity, and pay-per-use pricing.
• Create a cloud infrastructure, including virtual machines, storage, and networking.
• Understand the technical perspectives of cloud computing, including virtualisation, containerisation, and software-defined networking.
• Understand how cloud services are adopted, including migration strategies, security considerations, and compliance requirements.
• Understand the impact of cloud computing on organisations, including cost savings, increased agility, and improved collaboration.

What you'll be able to do

• Know the common types of threat to ICT systems and data, including malware, phishing, and social engineering attacks
• Protect ICT systems, including implementing security measures such as firewalls, antivirus software, and access controls
• Be aware of the applications of cryptography to ICT systems and data, including encryption, digital signatures, and hashing algorithms

What you'll be able to do

• Understand the common types of threat to ICT systems and data, including malware, phishing, and social engineering.
• Understand how to protect ICT systems through measures such as firewalls, antivirus software, and access controls.
• Understand the applications of cryptography to ICT systems and data, including encryption, digital signatures, and hashing.

What you'll be able to do

• Prepare for and carry out a site survey for the provision of telecoms services, identifying relevant factors and potential challenges.
• Identify a range of options for the provision of telecoms services and select the optimum solution based on technical and commercial considerations.
• Produce designs for the provision of telecoms services, incorporating relevant standards and regulations.
• Produce detailed plans for telecoms services, including resource allocation, timelines, and risk assessments.
• Co-ordinate the provision of telecoms services, ensuring effective communication and collaboration between stakeholders.

What you'll be able to do

• Design and implement controls within an ASP.NET application.
• Design the presentation and layout of an ASP.NET application to ensure usability.
• Access data and services from within an ASP.NET application.
• Establish a robust and maintainable ASP.NET solution structure.
• Leverage and extend the ASP.NET architecture to meet specific needs.
• Apply security principles to protect an ASP.NET application from vulnerabilities.

What you'll be able to do

• Create HTML5 pages using appropriate elements and structure
• Code using JavaScript to add functionality to web pages
• Create forms using HTML5 elements for data input
• Communicate with a remote data source using appropriate techniques
• Style HTML5 elements by using CSS3 to control appearance
• Create interactive pages using HTML5 Application Programming Interfaces (APIs) to enhance user experience
• Add offline support to web applications using appropriate technologies
• Implement an adaptive User Interface (UI) that responds to different screen sizes and devices
• Create graphics using HTML5 canvas or other relevant technologies
• Animate the User Interface (UI) to provide visual feedback and enhance engagement
• Implement Real Time communications by using Web sockets for interactive applications
• Create a Web Worker Process to perform tasks in the background without blocking the main thread

What you'll be able to do

• Plan for the identification of customer requirements
• Establish customer requirements
• Produce logical and physical design specifications
• Identify implementation and maintenance procedures

What you'll be able to do

• Configure switching hardware to facilitate network access
• Implement wireless Local Area Networks (LANs) to provide network access
• Implement Open Shortest Path First (OSPF) to enable end-to-end connectivity
• Implement Enhanced Interior Gateway Routing Protocol (EIGRP)
• Manage Inter Network Operating System (IOS) system image files

What you'll be able to do

• Implement network security measures to protect against unauthorised access and cyber threats
• Implement operational security procedures in an ICT environment to ensure data integrity and system availability
• Discover potential threats and vulnerabilities in ICT systems and networks through risk assessments and security audits
• Implement data host security measures to protect sensitive information stored on servers and workstations
• Configure access control mechanisms to restrict user privileges and prevent unauthorised actions
• Implement cryptography techniques to encrypt data and secure communications

What you'll be able to do

• Understand the principles of software design, including modularity, abstraction, and information hiding.
• Apply the techniques of software design, including use case modelling, class diagrams, and sequence diagrams.

What you'll be able to do

• Demonstrate knowledge of the fundamentals of core programming concepts
• Explain the key principles involved in object-oriented programming
• Identify and describe the requirements for software development projects
• Identify and describe the requirements for web application development
• Identify and describe the requirements for creating desktop applications
• Explain database concepts and how to store and use data effectively
• Apply knowledge of programming and databases to create functional applications
• Apply knowledge of programming and databases to store and retrieve data

What you'll be able to do

• Know about different software testing strategies and techniques
• Contribute to a test process for a software solution

What you'll be able to do

• Understand different software testing strategies, including black box, white box, and grey box testing.
• Understand various software testing techniques, such as unit testing, integration testing, system testing, and acceptance testing.
• Manage the test process for a software solution, including planning, execution, and reporting.
• Implement test plans and test cases to ensure software quality.
• Analyse test results and identify defects in the software solution.

What you'll be able to do

• Know the fundamental concepts of software testing, including its purpose and importance.
• Know different software testing methodologies, such as Agile, Waterfall, and V-model.
• Create effective software tests, including test cases and test data.
• Manage software testing projects, including planning, scheduling, and resource allocation.
• Manage bugs effectively, including identification, reporting, and tracking.
• Automate software testing using appropriate tools and techniques.
• Test software applications to identify defects and ensure quality.

What you'll be able to do

• Use a spreadsheet to enter, edit, and organise numerical and other data effectively
• Use appropriate formulas and tools to summarise and display spreadsheet information, including calculations, charts, and graphs
• Select and use appropriate tools and techniques to present spreadsheet information effectively, considering the target audience and purpose

What you'll be able to do

• Use a spreadsheet to accurately enter, edit and organise numerical and other data, ensuring data integrity.
• Select and use appropriate formulas and data analysis tools within a spreadsheet to meet specified requirements, demonstrating an understanding of their application.
• Select and use appropriate tools and techniques to effectively present and format spreadsheet information, ensuring clarity and accessibility for the intended audience.

What you'll be able to do

• Use a spreadsheet to enter, edit, and organise numerical and other data efficiently.
• Select and use appropriate formulas and data analysis tools and techniques to meet specified requirements.
• Use tools and techniques to present, format, and publish spreadsheet information in a clear and professional manner.

What you'll be able to do

• Configure and troubleshoot applications on a Microsoft Windows XP Operating System
• Resolve issues related to application usability
• Resolve issues related to application customisation
• Configure and troubleshoot connectivity for applications
• Configure application security settings

What you'll be able to do

• Install a Windows Desktop Operating System, following best practices and ensuring compatibility.
• Manage and troubleshoot access to resources within a Windows XP environment, resolving user issues effectively.
• Configure and troubleshoot hardware devices and drivers, ensuring proper functionality and compatibility.
• Configure and troubleshoot the desktop and user environments within Windows XP, customising settings and resolving user-related problems.

What you'll be able to do

• Install and upgrade Windows Vista according to best practice guidelines
• Customise and configure settings post-installation to meet user requirements
• Configure Windows Vista security features to protect against threats
• Configure, troubleshoot and repair networking issues on Windows Vista clients
• Install, configure and troubleshoot devices connected to Windows Vista clients
• Troubleshoot and repair Windows Vista operating system problems effectively

What you'll be able to do

• Know the different methods of representing information within a computer system, including binary, hexadecimal, and other relevant formats
• Use an operating environment, including command-line interfaces and graphical user interfaces
• Be aware of the communication processes involved in distributed operating systems and computer networks, including protocols and architectures

What you'll be able to do

• Understand the representation of information within a computer system, including different data types and encoding methods
• Understand the way information is processed within a computer system, including the roles of the CPU, memory, and input/output devices
• Make effective use of the operating environment of current computer systems, including command-line interfaces and graphical user interfaces
• Know the communication process in distributed operating systems, including the concepts of client-server architecture and message passing
• Know the communication process in computer networks, including network protocols and topologies
• Know distributed applications and their characteristics, including examples such as cloud computing and peer-to-peer networks
• Know transaction processing in mainframe systems, including the concepts of ACID properties and concurrency control

What you'll be able to do

• Understand the electromagnetic spectrum and its application to telecommunications
• Know the relationship between telecommunication circuits and transmission lines
• Explain the effect of telecommunication circuits and transmission lines on a digital signal
• Know how binary information is transmitted as a digital signal
• Understand the process of converting an analogue signal to a digital signal
• Demonstrate an understanding of signal multiplexing techniques

What you'll be able to do

• Use typical diagnostic and test procedures to assess ICT systems effectively
• Apply standard test procedures to PC systems and peripherals methodically
• Interpret test results to identify faulty components accurately and apply simple fixes appropriately

What you'll be able to do

• Plan and produce standard testing procedures, documenting the steps and resources required for each test.
• Select tests and determine expected results, ensuring that the tests are appropriate for the system and that the expected results are clearly defined.
• Identify and manage consequences of testing, including potential risks to the system and data, and implementing appropriate mitigation strategies.
• Apply tests and analyse results, documenting the actual results and comparing them to the expected results to identify any issues or defects.

What you'll be able to do

• Explain the fundamental concepts behind the internet
• Describe the history and purpose of the internet
• Know the technologies that enable communication across the internet
• Explain the technologies behind the World Wide Web
• Describe how to make information available on the World Wide Web
• Understand the additional services available on the internet
• Explain the function and use of additional internet services
• Understand the security implications of making information available on the internet
• Evaluate the risks associated with online information sharing

What you'll be able to do

• Describe the fundamental concepts of the UNIX operating system environment
• Configure and customise the Shell environment to meet specific user needs
• Develop and write shell scripts to automate tasks and processes
• Control data flow effectively using redirection techniques
• Control data flow effectively using pipes to connect commands
• Interrogate and monitor UNIX processes to understand system behaviour
• Manipulate UNIX processes to manage system resources
• Control file and directory access permissions to ensure data security
• Use the 'find' command to locate files and directories based on various criteria
• Operate effectively within a Transport Control Protocol/Internet Protocol (TCP/IP) network environment
• Utilise advanced tools for system administration and troubleshooting

What you'll be able to do

• Use e-mail software tools to compose clear and concise messages.
• Use e-mail software techniques to format and structure messages effectively.
• Use e-mail software tools to send messages to individuals and groups.
• Manage incoming email effectively by using folders, filters, and other organisational tools.
• Apply appropriate email etiquette and security practices.

What you'll be able to do

• Use e-mail software tools to compose clear and concise messages
• Use e-mail software tools to send messages to intended recipients
• Manage incoming e-mail effectively by using appropriate organisational techniques
• Manage incoming e-mail effectively by prioritising and responding to messages in a timely manner

What you'll be able to do

• Use e-mail software tools and techniques to compose and send messages effectively
• Manage the use of e-mail software effectively to ensure efficient communication and organisation

What you'll be able to do

• Connect to the Internet using appropriate hardware and software
• Use browser software to navigate webpages effectively, utilising features such as bookmarks and history
• Use browser tools to search for information from the Internet, employing effective search strategies
• Use browser software to communicate information online, utilising email, instant messaging, and social media
• Understand the need for safety and security practices when working online, including password management and virus protection

What you'll be able to do

• Select and set up an appropriate connection to access the Internet
• Set up and use browser software to navigate webpages
• Use browser tools to search effectively and efficiently for information from the Internet
• Use browser software to communicate information online
• Develop and apply appropriate safety and security practices and procedures when working online

What you'll be able to do

• Connect to the internet using appropriate hardware and software.
• Use browser software to navigate web pages effectively.
• Use browser tools to search for information from the internet, evaluating the reliability of sources.
• Use browser software to communicate information online through various methods.
• Follow and understand the need for safety and security practices when working online, including data protection and online behaviour.

What you'll be able to do

• Know the fundamental concepts of web architecture and its components, including servers, clients, and networks.
• Know about the technologies used to build and operate websites, including HTML, CSS, JavaScript, and server-side scripting languages.
• Implement specified components of a website, such as forms, navigation menus, and content sections.

What you'll be able to do

• Understand web architecture, including client-server models and network infrastructure.
• Understand the different components of a website, such as web servers, databases, and content management systems.
• Understand the technologies that can be used to build a website, including HTML, CSS, JavaScript, and server-side scripting languages.
• Understand the technologies that can be used to operate a website, including web hosting, domain name registration, and security protocols.
• Develop a detailed web-site specification, including functional and non-functional requirements.
• Implement elements of a web-site, including page layouts, navigation, and content.

What you'll be able to do

• Programme web applications using appropriate languages and technologies
• Use data effectively for webpages, including data storage and retrieval methods
• Troubleshoot web applications to identify and resolve common issues
• Know client-side scripting code, such as JavaScript, and its purpose in enhancing web page functionality
• Configure web applications, including server settings and security measures
• Create a web-based application that meets specified requirements

What you'll be able to do

• Plan web pages
• Create web pages
• Use website software tools to structure web pages
• Use website software tools to format web pages
• Publish web pages to the Internet
• Publish web pages to an intranet

What you'll be able to do

• Create appropriate structures for websites, considering usability and accessibility
• Create styles for websites using appropriate technologies to ensure a consistent visual appearance
• Use website software tools to prepare content for websites, ensuring it is optimised for online viewing
• Publish websites to a web server, ensuring they are accessible to intended users

What you'll be able to do

• Create website structures using appropriate markup languages (e.g., HTML)
• Create website styles using appropriate styling languages (e.g., CSS)
• Use structures and styles effectively to produce well-organised and visually appealing websites
• Select appropriate website software tools for developing websites
• Use website software features to create multiple page websites
• Develop websites with multimedia elements, such as images, audio, and video
• Incorporate interactive features into websites, such as forms and animations
• Publish websites to a web server or hosting platform
• Test websites thoroughly to ensure functionality and compatibility
• Test websites across different browsers and devices
• Test websites for accessibility and usability

What you'll be able to do

• Install Windows 7 operating systems
• Upgrade existing operating systems to Windows 7
• Migrate user data and settings to Windows 7
• Deploy Windows 7 using appropriate methods
• Configure hardware devices within a Windows 7 environment
• Configure applications for optimal performance in Windows 7
• Configure network connectivity in Windows 7
• Configure access to network resources within Windows 7
• Configure mobile computing settings in Windows 7
• Monitor systems running Windows 7 to ensure optimal performance
• Maintain systems running Windows 7 through troubleshooting and updates

What you'll be able to do

• Identify the cause of and resolve desktop application issues
• Identify the cause of and resolve networking issues
• Manage and maintain systems that run Windows 7 Client
• Support mobile users accessing Windows 7 Enterprise systems

What you'll be able to do

• Plan network and application services within a Windows Server 2008 Enterprise environment.
• Design core identity and access management components to control user authentication and authorisation.
• Design supporting identity and access management components to enhance security and manage user roles.
• Design solutions for business continuity and data availability to ensure minimal downtime and data loss.

What you'll be able to do

• Plan for Server Deployment, considering factors such as hardware requirements, network infrastructure, and security considerations.
• Plan for Server Management, including defining roles and responsibilities, establishing monitoring procedures, and implementing security policies.
• Monitor Servers to track performance metrics, identify potential issues, and ensure optimal operation.
• Maintain Servers by applying updates, patching vulnerabilities, and performing routine maintenance tasks.
• Plan Application Provisioning, including selecting appropriate deployment methods, configuring application settings, and managing user access.
• Plan Data Provisioning, including designing storage solutions, implementing backup and recovery procedures, and ensuring data security.
• Plan for Business Continuity, including developing disaster recovery plans, implementing redundancy measures, and testing failover procedures.
• Plan for High Availability, including implementing clustering solutions, configuring load balancing, and ensuring minimal downtime.

What you'll be able to do

• Understand the process of installing and configuring Windows Server operating systems.
• Understand the different server roles available in Windows Server and their respective functions.
• Understand the concepts and implementation of Active Directory for user and resource management.
• Understand different storage technologies and their management within a Windows Server environment.
• Understand how to monitor and manage server performance to ensure optimal operation.
• Understand the procedures for performing server maintenance tasks, including updates, backups, and troubleshooting.

What you'll be able to do

• Create Windows applications using appropriate development tools
• Create Windows Form applications with graphical user interfaces
• Create Windows Services applications that run in the background
• Access data in Windows form applications using appropriate data access methods
• Deploy Windows applications to different environments
• Create Windows applications using appropriate development tools and techniques

What you'll be able to do

• Enter, edit and combine text and other information accurately within word processing documents, ensuring clarity and consistency
• Structure information effectively within word processing documents using appropriate formatting and layout techniques
• Use word processing software tools to format and present documents to a professional standard, meeting specific requirements

What you'll be able to do

• Enter and combine text and other information accurately within word processing documents, ensuring consistency and clarity.
• Create and modify layout and structures for word processing documents, including headings, tables, and lists.
• Use word processing software tools to format and present documents effectively to meet requirements, considering audience and purpose.

What you'll be able to do

• Enter and combine text and other information accurately within word processing documents
• Create and modify appropriate layouts, structures and styles for word processing documents
• Use word processing software tools and techniques to format and present documents effectively to meet requirements