Cambridge OCR · RQF Level 3

OCR Level 3 Diploma in ICT Professional Competence (PROCOM) (QCF)

You don’t just earn this. You learn to use it, one-to-one, on your own real work.

  • LevelRQF Level 3
  • Total credits72
  • Units in this qualification222

Awarded by Cambridge OCR · on the Ofqual register

Start here

See how this course maps onto your role

Ten quick questions, one per Future Fluency, asked against this qualification rather than a generic one.

Check my fluency, free

About 5 minutes · No card · Nothing to commit to

What you’ll learn

What each unit actually teaches you to do

This Level 3 diploma develops the professional competence required for ICT practitioners. It allows learners to gain skills in areas such as server virtualisation, systems management, and software configuration. The qualification is suitable for those working in digital technology roles.

These are the units Cambridge OCR registers against this qualification. It is a catalogue, not a syllabus. Which of them you take depends on the combination the qualification requires, and that is set by the awarding body rather than by us. Every unit here is regulated, and every one you earn is yours to keep.

Business Intelligence Development and Maintenance using Microsoft SQL Server 2008Real unit · Cambridge OCR
This unit provides learners with skills to implement, configure, deploy, and maintain Business Intelligence solutions using Microsoft SQL Server 2008. Focus is on SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS) for data processing and analysis.

What you'll be able to do

  • Implement an SQL Server Integration Services (SSIS) solution using Microsoft SQL Server 2008
  • Configure SSIS using Microsoft SQL Server 2008
  • Deploy SSIS using Microsoft SQL Server 2008
  • Maintain SSIS using Microsoft SQL Server 2008
  • Implement an SQL Server Analysis Services (SSAS) solution using Microsoft SQL Server 2008
  • Configure SSAS using Microsoft SQL Server 2008
  • Deploy SSAS using Microsoft SQL Server 2008
  • Maintain SSAS using Microsoft SQL Server 2008
  • Implement an SQL Server Reporting Services (SSRS) solution using Microsoft SQL Server 2008
  • Configure SSRS using Microsoft SQL Server 2008
  • Deploy SSRS using Microsoft SQL Server 2008
  • Maintain SSRS using Microsoft SQL Server 2008
Cisco CCNP RouteReal unit · Cambridge OCR
You'll gain a comprehensive understanding of routing services within a Cisco environment. The unit covers routing protocols, implementation and troubleshooting of EIGRP and OSPF solutions, manipulation of routing updates, path control, and BGP implementation for ISP connectivity.

What you'll be able to do

  • Explain the principles of Routing Services, including routing protocols, metrics, and path selection.
  • Implement an EIGRP-Based Solution, including configuring EIGRP, troubleshooting issues, and optimising performance.
  • Implement an OSPF-based Solution, including configuring OSPF, troubleshooting issues, and optimising performance.
  • Explain the manipulation of Routing Updates, including route filtering, redistribution, and summarisation.
  • Explain path control mechanisms, including policy-based routing and route maps.
  • Implement a BGP solution for ISP connectivity, including configuring BGP, troubleshooting issues, and optimising performance.
  • Implement Routing Facilities for Branch Offices and Mobile Workers, including VPNs and remote access solutions.
  • Implement IPv6 in an Enterprise Network, including addressing, routing, and security considerations.
Cisco CCNP SwitchReal unit · Cambridge OCR
You'll gain a comprehensive understanding of Enterprise Campus Architectures and implement key networking technologies. The unit covers VLANs, Spanning Tree Protocol, inter-VLAN routing, high availability, redundancy, and campus infrastructure security.

What you'll be able to do

  • Understand the analysis required for an Enterprise Campus Architecture.
  • Implement Virtual LANs (VLANs) in Campus Networks.
  • Implement Spanning Tree Protocol (STP) to prevent network loops.
  • Implement inter-VLAN Routing to facilitate communication between VLANs.
  • Understand High Availability and Redundancy mechanisms in a Campus Network.
  • Understand Campus Infrastructure Security measures to protect against unauthorised access.
  • Understand the preparation of the Campus Infrastructure for Advanced Services.
Cisco CCNP TroubleshootingReal unit · Cambridge OCR
It teaches you to plan maintenance schedules and apply troubleshooting processes for complex enterprise networks. You'll implement maintenance tools and maintain campus switched and routed network solutions effectively.

What you'll be able to do

  • Plan maintenance schedules for complex network infrastructures.
  • Understand the processes involved in troubleshooting complex enterprise networks.
  • Implement maintenance and troubleshooting tools and applications effectively.
  • Maintain and troubleshoot campus switched solutions to ensure optimal performance.
  • Maintain and troubleshoot routing solutions to ensure network connectivity.
  • Maintain and troubleshoot addressing services within a complex network environment.
  • Maintain and troubleshoot network performance issues on converged networks.
  • Maintain and troubleshoot network security implementations to protect against threats.
  • Maintain and troubleshoot integrated, complex enterprise networks to resolve issues efficiently.
Cisco Discovery Designing and Supporting Computer NetworksReal unit · Cambridge OCR
You'll develop the ability to design, implement, and maintain computer networks. The unit covers analysing requirements, designing topologies, selecting devices, configuring and connecting network equipment, and maintaining prototype networks.

What you'll be able to do

  • Design a network infrastructure to meet specified requirements.
  • Implement a prototype network based on a given design.
  • Maintain a prototype network, including troubleshooting and resolving issues.
Cisco Discovery Introducing Routing and Switching in the EnterpriseReal unit · Cambridge OCR
You'll learn to configure switched infrastructures using Cisco technologies, test and troubleshoot routed and switched networks, and implement traffic filtering solutions within enterprise environments.

What you'll be able to do

  • Configure a switched infrastructure to support network communication.
  • Test and troubleshoot a routed and switched infrastructure to identify and resolve network issues.
  • Understand traffic filtering techniques and implement a solution to control network traffic.
Cisco Discovery Networking for Home and Small BusinessReal unit · Cambridge OCR
This unit provides learners with an understanding of network systems and devices commonly used in home and small business environments. You'll explore how different technologies operate and communicate, basic security principles, and cross-network communication configuration and troubleshooting.

What you'll be able to do

  • Understand the diverse types of network systems and devices in common use and how the different technologies operate and communicate with each other
  • Understand basic security principles and their impact on the user experience and network integrity
  • Configure and troubleshoot cross network communication to ensure seamless connectivity
Cisco Discovery Working at a Small-to-Medium Business or ISPReal unit · Cambridge OCR
It teaches you to understand and configure routing protocols for WAN communication in small-to-medium business or ISP environments. You'll develop skills in network testing, troubleshooting, and address management implementation.

What you'll be able to do

  • Identify and understand different routing protocols used in networks
  • Configure a router to communicate effectively with a WAN infrastructure
  • Test and troubleshoot a network system to identify and resolve issues
  • Implement address management techniques within a network environment
Cisco Entrepreneur : Growing a businessReal unit · Cambridge OCR
This unit covers the stages of business growth, including the challenges and opportunities at each stage. You'll learn to set SMART objectives, plan strategies, analyse business environments, forecast trends, and manage change and expansion effectively.

What you'll be able to do

  • Understand the growth process of a business
  • Plan for business growth, including setting objectives and strategies
  • Analyse the business environment and forecast future trends to support growth
  • Manage change effectively during periods of business expansion
Cisco Entrepreneur : Starting a BusinessReal unit · Cambridge OCR
You'll understand the strategic considerations involved in starting a new enterprise. The unit covers analysing key decisions, evaluating market research, legal requirements, developing business models, and managing enterprise operations.

What you'll be able to do

  • Understand the strategic requirements for starting a new enterprise
  • Manage and develop a suitable business model for an enterprise
  • Effectively manage an enterprise
Cisco Entrepreneur : iExec Enterprise EssentialsReal unit · Cambridge OCR
This unit provides learners with knowledge of enterprise strategic requirements and the ability to manage and develop strategic plans. You'll also acquire skills to manage corporate portfolios aligned with an enterprise's mission and vision.

What you'll be able to do

  • Understand the strategic requirements of an enterprise
  • Manage and develop a strategic plan for an enterprise
  • Manage a corporate portfolio
Cisco Exploration Accessing the WANReal unit · Cambridge OCR
This unit covers the implementation, testing, and troubleshooting of Wide Area Network (WAN) connections. You'll gain skills in configuring WAN protocols, planning security measures, and evaluating network address management and security technologies.

What you'll be able to do

  • Implement a Wide Area Network (WAN)
  • Test and troubleshoot a WAN implementation
  • Plan security measures for a WAN
  • Evaluate a WAN and implement appropriate security and network address management technologies
Cisco Exploration LAN Switching and WirelessReal unit · Cambridge OCR
This unit equips learners with the skills to configure, test, and troubleshoot switched and trunked VLAN infrastructures, including VLANs, trunk links, and VLAN Trunk Protocol (VTP) management. You'll also understand wireless system operations, standards, and security protocols.

What you'll be able to do

  • Configure a switched and trunked VLAN infrastructure, including setting up VLANs and trunk links
  • Test and troubleshoot a VLAN infrastructure to ensure proper functionality and connectivity
  • Enable a VLAN Trunk Protocol (VTP) client/server structure to operate and manage a LAN effectively
  • Understand the operation of wireless systems, including wireless standards, security protocols, and network configurations
Cisco Exploration Network FundamentalsReal unit · Cambridge OCR
You'll gain knowledge of diverse network systems and devices, network technologies, and protocols such as OSI and TCP/IP. The unit includes configuring workstations for network connection, designing sub-networks, and recommending network improvements.

What you'll be able to do

  • Know the diverse types of network systems and devices in common use
  • Know how different network technologies operate and communicate
  • Understand the OSI model and TCP/IP protocol suite and their relationship to the operation of network systems
  • Configure a workstation for connection to a network
  • Design a sub-network scheme
  • Recommend improvements to an existing network infrastructure
Cisco Exploration Routing Protocols and ConceptsReal unit · Cambridge OCR
This unit covers the identification and understanding of various routing protocols, including distance vector and link-state types. You'll learn to configure routers for WAN communication and to test and troubleshoot network systems to identify faults and assess communication quality.

What you'll be able to do

  • Identify and understand different routing protocols and their characteristics
  • Configure a router to communicate with a WAN infrastructure, using appropriate routing protocols
  • Test and troubleshoot a network system to identify faults and assess the quality of communication, using appropriate tools and techniques
Cisco IT Essentials Part 1Real unit · Cambridge OCR
It teaches you to understand fundamental computer hardware principles, safely assemble and maintain various computer systems and components, and manage operating system and security features. You'll gain skills in troubleshooting, repair, and maintaining network communications within computer systems.

What you'll be able to do

  • Understand the fundamental hardware principles that underpin the operation of a computer system.
  • Safely assemble a range of computer systems and their components, adhering to health and safety guidelines.
  • Maintain a range of computer systems and their components, including troubleshooting and repair.
  • Maintain operating system components, including updates, drivers, and system configuration.
  • Maintain security components, including anti-virus software, firewalls, and user access controls.
  • Maintain network communication for a computer system, including configuring network settings and troubleshooting connectivity issues.
Cisco IT Essentials Part 2Real unit · Cambridge OCR
It teaches you to understand principles of managing computer systems, including supporting operating systems and security requirements. You'll also develop skills to maintain networked systems and manage security effectively.

What you'll be able to do

  • Understand the principles of managing computer systems
  • Manage the support of operating systems
  • Manage security requirements for computer systems
  • Maintain networked systems
CompTIA A+ 602Real unit · Cambridge OCR
This unit provides learners with comprehensive knowledge of personal computer components, laptops, portable devices, operating systems, printers, scanners, and networks. You'll learn to install, configure, and troubleshoot these systems effectively.

What you'll be able to do

  • Use personal computer components effectively
  • Understand the features and functionality of laptops and portable devices
  • Understand the principles of operating systems, including Microsoft Windows 2000, XP Professional, XP Home and Media Center
  • Use printers and scanners effectively
  • Install and configure networks
  • Work with networks effectively
  • Apply security measures to computer systems and networks
  • Know safety and environmental issues related to computer hardware and software
  • Understand the importance of communication and professionalism in a technical support role
CompTIA A+ 603Real unit · Cambridge OCR
You'll gain a comprehensive understanding of personal computer hardware components, operating systems, printers, scanners, networks, security fundamentals, and professional communication principles. The unit supports configuring, troubleshooting, and maintaining computer systems and peripherals.

What you'll be able to do

  • Understand the function of various personal computer components, including motherboards, CPUs, memory, storage devices, and peripherals.
  • Understand the principles of operating systems, including installation, configuration, troubleshooting, and maintenance.
  • Understand the operation of printers and scanners, including installation, configuration, troubleshooting, and maintenance.
  • Understand the fundamentals of computer networks, including network topologies, protocols, and devices.
  • Understand security fundamentals, including common threats, vulnerabilities, and security measures.
  • Understand the principles of effective communication and professionalism in a technical support environment.
CompTIA A+ 604Real unit · Cambridge OCR
This unit provides learners with foundational knowledge of personal computer components, laptops, printers, scanners, and fundamental security and safety issues. You'll understand hardware functions and be able to identify and describe key device components.

What you'll be able to do

  • Understand the function of Personal Computer Components
  • Understand the function of Laptop and Portable Devices
  • Understand the function of Printers and Scanners
  • Understand the fundamentals of security relating to computer systems
  • Understand Safety and Environmental Issues relating to computer systems
CompTIA A+ EssentialsReal unit · Cambridge OCR
You'll learn to assemble, maintain, and troubleshoot personal computers, including understanding operating systems, basic networking, and security concepts. The unit covers computer components, compatibility, and operational considerations.

What you'll be able to do

  • Use personal computer components effectively for assembly and maintenance
  • Understand personal computer troubleshooting techniques for diagnosing hardware and software issues
  • Apply repair and maintenance procedures to personal computers
  • Understand operating system principles and functionalities
  • Understand basic networking fundamentals, including network topologies and protocols
  • Understand security concepts and technology to protect personal computers from threats
  • Understand operational considerations when working with personal computers, including safety and best practises
CompTIA A+ Practical ApplicationReal unit · Cambridge OCR
You'll develop a comprehensive understanding of computer hardware, operating systems, networking, and security principles. The unit covers identification and function of computer components, operating system principles, and network and security fundamentals.

What you'll be able to do

  • Understand computer hardware components and their functions
  • Understand the principles and functionalities of Operating Systems, including Microsoft Windows 2000, Windows XP Professional, XP Home, XP MediaCenter, Windows Vista Home, Home Premium, Business and Ultimate
  • Understand networking concepts and technologies
  • Understand computer security principles and practices
CompTIA Convergence+Real unit · Cambridge OCR
This unit provides learners with knowledge of converged networks, including telephony principles, network engineering, application integration, hardware architecture, network management, and security design. You'll be able to engineer, manage, and secure converged networks.

What you'll be able to do

  • Know the fundamental principles of telephony
  • Engineer a functional computer network
  • Identify the purpose of an application within a converged network
  • Know the key components of hardware and architecture within a converged network
  • Manage a converged network effectively
  • Know the principles of security design within a converged network
CompTIA DHTI+Real unit · Cambridge OCR
You'll learn to configure and maintain home networks and related systems. The unit covers audio and video solutions, telephony and VoIP principles, security systems, home control and management systems, alongside troubleshooting methodologies and documentation.

What you'll be able to do

  • Configure home networks
  • Set up home networks
  • Implement audio solutions
  • Implement video solutions
  • Know telephony principles
  • Know VoIP principles
  • Install security systems
  • Maintain security systems
  • Use home control systems
  • Use home management systems
  • Apply troubleshooting methodology
  • Create documentation
CompTIA Linux+Real unit · Cambridge OCR
You'll gain comprehensive knowledge of Linux installation, client management, and system configuration. The unit covers installation methods, partitioning, distributions, user account management, permissions, network services, security options, and documentation.

What you'll be able to do

  • Describe the installation procedure for Linux
  • Manage Linux based clients effectively
  • Configure system settings, network services and access rights appropriately
  • Implement security options effectively
  • Complete documentation accurately
  • Describe the hardware that relates to typical Linux client and server systems
CompTIA Network + 2009Real unit · Cambridge OCR
This unit provides learners with a comprehensive understanding of network technologies, media, topologies, and devices aligned with CompTIA Network+ 2009 standards. You'll also develop skills in network management, security, and the use of network tools for troubleshooting.

What you'll be able to do

  • Understand Network Technologies
  • Understand Network Media and Topologies
  • Understand Network Devices
  • Understand Network Management
  • Understand Network Tools
  • Understand Network Security
CompTIA Network+Real unit · Cambridge OCR
You'll gain a comprehensive understanding of network fundamentals including media types, topologies, protocols, standards, and network implementation. The unit prepares learners to provide effective network support and management.

What you'll be able to do

  • Understand media and topologies
  • Understand Protocols and Standards
  • Understand Network Implementation
  • Carry out network support
CompTIA Security+Real unit · Cambridge OCR
This unit provides a comprehensive understanding of IT security concepts, including communication and infrastructure security, cryptography basics, and operational and organisational security policies. You'll identify threats, vulnerabilities, and security controls within IT systems.

What you'll be able to do

  • Understand general security concepts relating to information technology systems
  • Recognise and understand communication security protocols and methods
  • Understand and differentiate infrastructure security components and configurations
  • Understand and apply the basics of cryptography in securing data
  • Understand and apply the basics of cryptography in securing data
  • Understand operational and organisational security policies and procedures
CompTIA Security+ 2008Real unit · Cambridge OCR
You'll gain a comprehensive understanding of systems security principles, network infrastructure security, access control, security assessments, cryptography, and organisational security policies. The unit covers identifying threats, vulnerabilities, and risk management.

What you'll be able to do

  • Understand systems security principles
  • Understand network infrastructure components and security considerations
  • Understand access control methods and technologies
  • Understand security assessments and audits
  • Understand cryptography principles and applications
  • Understand organisational security policies and procedures
CompTIA Server+Real unit · Cambridge OCR
This unit provides a comprehensive understanding of server hardware, installation, configuration, upgrading, maintenance, and protection. You'll gain skills to troubleshoot server problems and implement disaster recovery plans within server environments.

What you'll be able to do

  • Know general server hardware
  • Install a server
  • Configure a server
  • Upgrade a server
  • Proactively maintain a server
  • Protect the server environment
  • Troubleshoot Server Problems
  • Identify Server Problems
  • Know the disaster recovery plan
CompTIA Server+ 2009Real unit · Cambridge OCR
You'll gain knowledge of server hardware components, their functions, and compatibility considerations. The unit also covers installation and configuration of server operating systems, user account management, storage technologies, disaster recovery, and troubleshooting within an IT environment.

What you'll be able to do

  • Understand system hardware components and their functions
  • Understand software installation, configuration, and management
  • Understand storage technologies and their implementation
  • Understand the IT environment and its impact on server operations
  • Understand disaster recovery planning and implementation
  • Understand troubleshooting methodologies for server-related issues
Computer Games DevelopmentReal unit · Cambridge OCR
You'll understand computer game components and the structure of the games industry. The unit teaches you to develop detailed game specifications and implement specific game components according to those specifications.

What you'll be able to do

  • Know the components of computer games and the structure of the computer games industry
  • Develop a detailed computer game specification
  • Implement a specific component of a computer game according to the specification
Computer Games DevelopmentReal unit · Cambridge OCR
You'll gain an understanding of computer game architecture, components, and the games industry. The unit includes evaluating existing games, developing game specifications, and implementing elements of computer games to support development projects.

What you'll be able to do

  • Understand the fundamental architecture and key components of computer games
  • Understand the structure and operation of the computer games industry
  • Evaluate the strengths and weaknesses of existing computer games
  • Develop a detailed specification for a computer game, outlining its features and functionality
  • Implement specific elements of a computer game, demonstrating practical development skills
Configuration Microsoft Forefront Client and ServerReal unit · Cambridge OCR
This unit provides learners with the skills to deploy client agents and policies, configure server products, maintain infrastructure, and monitor protection status within the Microsoft Forefront Client and Server environment. You'll manage security and system protection effectively.

What you'll be able to do

  • Deploy client agents and policies using Microsoft Forefront Client and Server
  • Configure server products within the Microsoft Forefront Client and Server environment
  • Maintain the infrastructure of the Microsoft Forefront Client and Server environment
  • Monitor protection status and activity within the Microsoft Forefront Client and Server environment
Configuring Microsoft Desktop optimisation PackReal unit · Cambridge OCR
It teaches you to configure the Microsoft Desktop Optimisation Pack. You'll manage Group Policy Objects using Advanced Group Policy Management, monitor desktops with Microsoft Desktop Error Monitoring, manage software inventory, and use diagnostics and recovery tools.

What you'll be able to do

  • Configure Group Policy Objects (GPOs) by Using Advanced Group Policy Management (AGPM)
  • Monitor desktops by Using Microsoft Desktop Error Monitoring (DEM)
  • Manage software inventory by Using the Asset Inventory Service (AIS)
  • Repair computer systems by Using the Diagnostics and Recovery Toolset (DaRT)
  • Diagnose computer systems by Using the Diagnostics and Recovery Toolset (DaRT)
  • Configure Application Virtualization Servers
  • Configure Application Virtualization Clients
  • Deploy the Application Virtualization Sequencer
  • Manage the Application Virtualization Sequencer
Configuring Microsoft Exchange Server 2007Real unit · Cambridge OCR
You'll gain the skills to install and configure Microsoft Exchange Server 2007, including setting up recipients, public folders, and the Exchange infrastructure. The unit also covers monitoring, reporting, and configuring disaster recovery to maintain server performance and reliability.

What you'll be able to do

  • Install and configure Microsoft Exchange Servers according to best practices and organisational needs
  • Configure Recipients and Public Folders within Microsoft Exchange Server 2007 to facilitate communication and collaboration
  • Configure the Exchange Infrastructure, including connectors and transport rules, to ensure proper mail flow
  • Monitor and Report on the performance and health of the Microsoft Exchange Server 2007 environment
  • Configure Disaster Recovery options for Microsoft Exchange Server 2007 to ensure business continuity in the event of a failure
Configuring Microsoft Internet Security and Acceleration Server 2006Real unit · Cambridge OCR
You'll learn to plan, install, and configure Microsoft ISA Server 2006. The unit covers client computer management, firewall policy configuration, web caching, remote network connectivity, and monitoring ISA Server activity.

What you'll be able to do

  • Plan and install ISA Server 2006, considering network topology and security requirements
  • Install and configure client computers to work with ISA Server 2006, ensuring proper authentication and access control
  • Configure and manage ISA Server 2006, including its firewall rules, web filters, and intrusion detection system
  • Configure web caching in ISA Server 2006 to improve web performance and reduce bandwidth consumption
  • Configure firewall policy in ISA Server 2006 to protect the network from external threats
  • Configure and manage remote network connectivity in ISA Server 2006, allowing remote users to securely access the network
Configuring Microsoft Office Communications Server 2007Real unit · Cambridge OCR
You'll learn to install, manage, and configure Microsoft Office Communications Server 2007 R2. The unit includes configuring server roles, deploying clients, setting up conferencing and enterprise voice functionality, and managing external connectivity and server maintenance.

What you'll be able to do

  • Install and manage Office Communications Server (Communications Server) 2007 R2, including server roles and features
  • Deploy and configure Communications Server 2007 R2 clients, ensuring proper connectivity and functionality
  • Configure conferencing features in Communications Server 2007 R2, including audio, video, and web conferencing
  • Configure enterprise voice functionality in Communications Server 2007 R2, enabling VoIP and PBX integration
  • Configure external connectivity in Communications Server 2007 R2, allowing users to communicate with external contacts
  • Monitor and maintain Communications Server 2007 R2, ensuring its performance, security, and availability
Configuring Microsoft Office Project Server 2007Real unit · Cambridge OCR
This unit equips learners with the ability to configure Microsoft SQL Server 2005, Analysis Services 2005, and SharePoint for Project Server 2007. You'll gain practical skills in deploying Project Server and administering Project Web Access for optimal performance.

What you'll be able to do

  • Configure Microsoft SQL Server 2005 for Project Server 2007
  • Configure Analysis Services 2005 for Project Server 2007
  • Configure Microsoft SharePoint for Project Server 2007
  • Deploy Project Server
  • Administer Project Web Access
Configuring Microsoft Office SharePoint Server 2007Real unit · Cambridge OCR
This unit covers configuration and management of Microsoft Office SharePoint Server 2007. You'll configure core functionalities, manage search and content, implement business forms, manage business intelligence, and handle administration and deployment tasks.

What you'll be able to do

  • Configure Microsoft Office SharePoint Server 2007
  • Manage Search functionality within Microsoft Office SharePoint Server 2007
  • Configure Content Management features in Microsoft Office SharePoint Server 2007
  • Configure Business Forms using Microsoft Office SharePoint Server 2007
  • Manage Business Intelligence tools within Microsoft Office SharePoint Server 2007
  • Manage the Administration of Microsoft Office SharePoint Server 2007
  • Deploy or Upgrade Microsoft Office SharePoint Server 2007
Configuring Microsoft System Center Configuration Manager 2007Real unit · Cambridge OCR
This unit covers deploying, configuring, and managing Microsoft System Centre Configuration Manager 2007 (SCCM). You'll manage resources, distribute applications, deploy operating systems, secure network infrastructure, and maintain an SCCM environment.

What you'll be able to do

  • Deploy a System Center Configuration Manager 2007 (SCCM) Server
  • Configure an SCCM Infrastructure
  • Manage Resources using SCCM
  • Distribute Applications using SCCM
  • Deploy Operating Systems using SCCM
  • Secure a Network Infrastructure using SCCM
  • Manage an SCCM Infrastructure
  • Maintain an SCCM Infrastructure
Configuring Microsoft System Center Operations Manager 2007Real unit · Cambridge OCR
This unit focuses on configuring and maintaining Microsoft System Centre Operations Manager 2007. You'll be able to deploy and configure Management Packs, build custom packs, and set up client monitoring to meet specific IT infrastructure monitoring requirements.

What you'll be able to do

  • Configure System Center Operations Manager 2007 to meet specific monitoring requirements.
  • Deploy and configure Management Packs to monitor specific applications and services.
  • Build and deploy custom Management Packs to address unique monitoring needs.
  • Maintain System Center Operations Manager to ensure its continued functionality and effectiveness.
  • Configure Client Monitoring to gather data from client computers.
Configuring Microsoft Windows Vista ClientReal unit · Cambridge OCR
This unit provides learners with the knowledge and skills to install, configure, and maintain Microsoft Windows Vista client operating systems. You'll configure system settings, security features, network connectivity, and applications, as well as troubleshoot common issues.

What you'll be able to do

  • Install and upgrade Windows Vista correctly
  • Configure and troubleshoot post-installation system settings effectively
  • Configure Windows security features appropriately
  • Configure network connectivity efficiently
  • Configure applications included with Windows Vista correctly
  • Maintain and optimise systems that run Windows Vista effectively
  • Configure and troubleshoot mobile computing issues
Configuring Windows Essential Business Server 2008Real unit · Cambridge OCR
This unit provides learners with the knowledge to prepare, install, configure, and manage Windows Essential Business Server 2008. It includes hardware and software requirements, user account and security configuration, and setting up remote access for authorised users.

What you'll be able to do

  • Prepare a system for the deployment of Windows Essential Business Server
  • Install and configure Windows Essential Business Server according to best practise
  • Manage Windows Essential Business Server, including user accounts and security settings
  • Configure remote access to Windows Essential Business Server for authorised users
Configuring Windows Server 2008 Active DirectoryReal unit · Cambridge OCR
This unit covers configuring and maintaining Active Directory in Windows Server 2008. You'll manage DNS, Active Directory infrastructure, server roles, objects, and certificate services to ensure a stable and secure environment.

What you'll be able to do

  • Configure Domain Name System (DNS) for Active Directory to ensure proper name resolution
  • Configure the Active Directory infrastructure, including domains, forests, and trusts
  • Configure additional Active Directory server roles to provide specific services
  • Create and maintain Active Directory objects, such as users, groups, and computers
  • Maintain the Active Directory environment to ensure its stability and performance
  • Configure Active Directory Certificate Services for secure authentication and encryption
Configuring Windows Server 2008 Applications InfrastructureReal unit · Cambridge OCR
You'll learn to deploy servers and configure Terminal Services, Web Services Infrastructure, and Network Application Services within a Windows Server 2008 environment. The unit emphasises best practices and meeting specified organisational requirements.

What you'll be able to do

  • Deploy servers within a Windows Server 2008 environment
  • Configure Terminal Services within a Windows Server 2008 environment
  • Configure a Web Services Infrastructure within a Windows Server 2008 environment
  • Configure Network Application Services within a Windows Server 2008 environment
Configuring Windows Server 2008 Network InfrastructureReal unit · Cambridge OCR
It teaches you to configure and manage key network services in a Windows Server 2008 environment. You'll develop practical skills in IP addressing, name resolution, network access, file and print services, and network infrastructure monitoring and management.

What you'll be able to do

  • Configure IP Addressing and Services within a Windows Server 2008 network infrastructure
  • Configure Name Resolution within a Windows Server 2008 network infrastructure
  • Configure Network Access within a Windows Server 2008 network infrastructure
  • Configure File and Print Services within a Windows Server 2008 network infrastructure
  • Monitor and Manage a Windows Server 2008 Network Infrastructure
Configuring Windows Server VirtualizationReal unit · Cambridge OCR
You'll develop the ability to install, configure, and manage Windows Server Virtualization using Hyper-V. The unit covers deployment and management of virtual machines, performance optimisation, resource allocation, and virtual networking configuration.

What you'll be able to do

  • Install Hyper-V to enable virtualisation capabilities
  • Configure and optimise Hyper-V to maximise performance and resource utilisation
  • Deploy virtual machines to create isolated environments for applications and services
  • Manage and monitor virtual machines to ensure availability and performance
Configuring Windows SharePoint Services 3.0Real unit · Cambridge OCR
It teaches you to deploy, monitor, and administer Windows SharePoint Services 3.0. You'll configure security, manage customisation, and set up network infrastructure to support effective SharePoint service delivery.

What you'll be able to do

  • Deploy Windows SharePoint Services 3.0 (WSS)
  • Monitor the performance of Windows SharePoint Services
  • Configure security settings for Windows SharePoint Services
  • Administer Windows SharePoint Services effectively
  • Manage customisation options within Windows SharePoint Services
  • Configure the network infrastructure to support Windows SharePoint Services
Configuring Windows Small Business Server 2008Real unit · Cambridge OCR
You'll gain skills to configure and maintain Windows Small Business Server (SBS) 2008, including deploying hardware and software for SBS servers and network computers. The unit also covers migration to SBS 2008 and maintaining system availability, remote access, users, collabouration, and messaging.

What you'll be able to do

  • Deploy Hardware for Small Business Server (SBS) Servers
  • Deploy Software for Small Business Server (SBS) Servers
  • Migrate to SBS 2008
  • Deploy Hardware for Computers on the Network
  • Deploy Software for Computers on the Network
  • Maintain Systems Availability
  • Maintain Services Availability
  • Maintain Remote Access
  • Maintain Users
  • Maintain Computers
  • Maintain Collaboration
  • Maintain Messaging
Configuring, and Managing Windows Server 2003 Hosted EnvironmentsReal unit · Cambridge OCR
It teaches you to plan, deploy, configure, and manage Windows Server 2003 hosted environments. You'll develop skills in deploying hosting infrastructures, configuring IIS and hosted services, designing automated provisioning, and troubleshooting hosted solutions.

What you'll be able to do

  • Plan a hosted environment that meets specific requirements
  • Deploy a core hosting infrastructure to support hosted services
  • Deploy and configure IIS to serve web content
  • Deploy hosted services to provide functionality to users
  • Design and configure automated provisioning to streamline service deployment
  • Administer, manage, and optimise hosted solutions to ensure optimal performance
  • Troubleshoot a hosted environment to resolve issues and maintain uptime
Creating a procedural computer programReal unit · Cambridge OCR
You'll implement software solutions using procedural programming techniques, refine programmes to improve quality, and test programme operation to ensure correct functionality. The unit covers designing, implementing, optimising, and testing procedural programmes.

What you'll be able to do

  • Implement software solutions using procedural programming techniques
  • Refine a procedural programme to improve its overall quality
  • Test the operation of a procedural programme to ensure it functions correctly
Creating a procedural computer programReal unit · Cambridge OCR
This unit develops learners' ability to implement, refine, test, and document procedural computer programs. You'll apply procedural programming constructs, improve program quality, conduct testing, and produce appropriate documentation.

What you'll be able to do

  • Implement a software design using procedural programming techniques
  • Refine a procedural program to improve its overall quality and efficiency
  • Test the operation of a procedural program to ensure it functions correctly
  • Document a computer program clearly and comprehensively
Creating an event driven computer programReal unit · Cambridge OCR
This unit equips learners to create event-driven computer programs by implementing software designs, refining program quality, testing functionality, and documenting programs to ensure effective event handling and performance.

What you'll be able to do

  • Implement a software design 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.
  • Document an event driven program, including its design, implementation, and testing.
Creating an event driven computer programReal unit · Cambridge OCR
It teaches you to create and refine event-driven computer programs. You'll implement event-driven programming techniques, improve program quality and performance, and test program operation to ensure it meets specified requirements.

What you'll be able to do

  • Implement software solutions using event-driven programming techniques.
  • Refine an event-driven program to improve its overall quality, performance, and maintainability.
  • Test the operation of an event-driven program to ensure it functions correctly and meets specified requirements.
Creating an object oriented computer programReal unit · Cambridge OCR
You'll create and refine object-oriented computer programs by applying principles such as encapsulation, inheritance, and polymorphism. The unit includes implementing classes and objects, improving program quality, and testing to ensure functionality meets requirements.

What you'll be able to do

  • Implement software using object oriented programming principles, including encapsulation, inheritance, and polymorphism
  • Refine an object oriented program to improve its quality, considering factors such as maintainability, readability, and efficiency
  • Test the operation of an object oriented driven program to ensure it meets specified requirements and functions correctly
Creating an object oriented computer programReal unit · Cambridge OCR
You'll implement object-oriented programming principles to create software designs, refine programs for quality improvement, test program functionality, and document their work. The unit focuses on class creation, inheritance, encapsulation, and object interaction.

What you'll be able to do

  • Implement a software design using object oriented programming principles, creating classes, objects, and methods to represent real-world entities
  • Refine an object oriented program to improve quality, addressing issues such as code duplication, complexity, and performance
  • Test the operation of an object oriented driven program to ensure it meets specified requirements and functions correctly under various conditions
  • Document an object oriented driven program, providing clear and concise explanations of its design, functionality, and usage
Customer Care in ICTReal unit · Cambridge OCR
You'll explore the significance of establishing positive customer relationships in ICT. The unit covers communication methods, techniques to establish rapport, and the use of appropriate language and tone to respond professionally to customer enquiries.

What you'll be able to do

  • Provide customer care by establishing customer relationships.
  • Provide customer care by establishing customer relationships.
Customer Care in ICTReal unit · Cambridge OCR
This unit develops learners' understanding of providing effective ICT customer care through building positive customer relationships. You'll address customer queries, resolve technical issues, and contribute to improving service delivery by identifying areas for enhancement.

What you'll be able to do

  • Understand how to provide ICT customer care by developing customer relationships, including communication skills, empathy, and problem-solving techniques.
  • Provide ICT customer care by developing customer relationships, addressing customer queries, and resolving technical issues effectively.
  • Contribute to improving the delivery of service by identifying areas for improvement and suggesting solutions.
Customer Care in ICTReal unit · Cambridge OCR
This unit introduces the key principles of customer care within an ICT environment. You'll develop knowledge of various communication methods and understand the importance of effective communication skills when providing customer care in familiar contexts.

What you'll be able to do

  • Provide customer care in a familiar context within an ICT environment
  • Provide customer care in a familiar context within an ICT environment
Data ModellingReal unit · Cambridge OCR
You'll develop an understanding of logical data modelling concepts and techniques. The unit covers creating and refining logical data models, identifying entities and attributes, and applying methods to ensure data integrity and optimise performance.

What you'll be able to do

  • Understand the concepts of logical data modelling thoroughly
  • Use data modelling techniques to create logical data models effectively
  • Use data modelling techniques to refine logical data models accurately
Data modellingReal unit · Cambridge OCR
You'll gain foundational knowledge of logical data modelling concepts and techniques. The unit enables the creation of logical data models, including entity-relationship diagrams, and understanding of normalisation principles in database design.

What you'll be able to do

  • Know the basic concepts of logical data modelling
  • Use simple data modelling techniques to create logical data models
Data structures and algorithmsReal unit · Cambridge OCR
You'll gain an understanding of various data structures and associated algorithms, including arrays, linked lists, trees, and graphs. The unit covers algorithm operation and selection of appropriate data structures for specified problems, with non-executable descriptions.

What you'll be able to do

  • Understand the structure and uses of various data structures and their associated algorithms, including arrays, linked lists, trees, and graphs.
  • Understand the operation of established algorithms, including sorting, searching, and graph traversal algorithms.
  • Select appropriate data structures and associated algorithms for specified problems, considering factors such as efficiency, memory usage, and complexity.
  • Describe the data structures and associated algorithms in a non-executable program specification language, using appropriate notation and terminology.
  • Implement data structures and algorithms in an executable programming language, writing code that is efficient, reliable, and well-documented.
  • Understand how strings are structured and processed, including string manipulation, pattern matching, and text processing techniques.
Deploying Messaging Solutions with Microsoft Exchange Server 2007Real unit · Cambridge OCR
This unit provides learners with the skills to plan Microsoft Exchange Server 2007 deployments, upgrades, and migrations. You'll plan for high availability, design Exchange topologies, implement messaging security and compliance, and maintain the messaging environment.

What you'll be able to do

  • Plan Microsoft Exchange Server 2007 upgrades and migrations, considering all relevant factors.
  • Plan for High Availability implementation to ensure continuous messaging service.
  • Plan the Exchange Topology Deployment to meet organisational needs.
  • Plan Messaging Security and Compliance implementation to protect sensitive data.
  • Plan for Messaging Environment Maintenance to ensure optimal performance and reliability.
Deploying and Maintaining Windows Vista Client and 2007 Microsoft Office System DesktopsReal unit · Cambridge OCR
You'll learn to deploy and maintain Windows Vista client systems and the 2007 Microsoft Office System. The unit includes configuring automated installation settings, deploying operating systems and applications, using Business Desktop Deployment tools, and managing user state migration.

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 manage desktop deployments.
  • Use the Application Compatibility Toolkit to resolve application compatibility issues.
  • Manage user state migration during operating system deployments.
Designing Database Solutions and Data Access Using Microsoft SQL Server 2008Real unit · Cambridge OCR
You'll develop the ability to design database solutions using Microsoft SQL Server 2008 aligned with business objectives. The unit covers database strategy, table design, programming objects, transaction management, XML strategies, query optimisation, and performance tuning.

What you'll be able to do

  • Design a database strategy that aligns with business objectives
  • Design database tables to efficiently store and manage data
  • Design programming objects to enhance database functionality
  • Design a transaction and concurrency strategy to ensure data integrity
  • Design an XML strategy for data exchange and storage
  • Design queries for performance to optimise data retrieval
  • Design a database for optimal performance to ensure efficiency and scalability
Designing Database Solutions by Using Microsoft SQL Server 2005Real unit · Cambridge OCR
It teaches you to design comprehensive database solutions using Microsoft SQL Server 2005. You'll develop database testing procedures, code management strategies, application solutions, and database objects to create robust and maintainable database systems.

What you'll be able to do

  • Design database testing procedures using Microsoft SQL Server 2005
  • Design code management procedures using Microsoft SQL Server 2005
  • Design an application solution for SQL Server 2005
  • Design database objects using Microsoft SQL Server 2005
  • Design a database using Microsoft SQL Server 2005
  • Develop applications that use SQL Server support services
Designing Messaging Solutions with Microsoft Exchange Server 2007Real unit · Cambridge OCR
It teaches you to design messaging solutions using Microsoft Exchange Server 2007. You'll plan messaging services, high availability, coexistence, migration strategies, and define policies and security procedures.

What you'll be able to do

  • Design and plan messaging services using Microsoft Exchange Server 2007 to meet organisational needs
  • Design and plan server high availability solutions for Microsoft Exchange Server 2007 to ensure business continuity
  • Design and plan coexistence and migration strategies for Microsoft Exchange Server 2007 environments
  • Define policies and security procedures for Microsoft Exchange Server 2007 messaging systems to protect data and maintain compliance
Designing Security for a Windows Server 2003 NetworkReal unit · Cambridge OCR
You'll design security for Windows Server 2003 networks, including conceptual, logical, and physical designs. The unit covers access control strategies, client infrastructure security, and analysis of business and technical requirements.

What you'll be able to do

  • Create the Conceptual Design for Network Infrastructure Security by Gathering and Analysing Business and Technical Requirements
  • Create the Logical Design for Network Infrastructure Security
  • Create the Physical Design for Network Infrastructure Security
  • Design an Access Control Strategy for Data
  • Create the Physical Design for Client Infrastructure Security
Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008Real unit · Cambridge OCR
You'll learn to design and manage business intelligence infrastructures using Microsoft SQL Server 2008. The unit covers report design, data mining models, BI architecture, administration, and deploying SQL Server Integration Services (SSIS) and Analysis Services databases.

What you'll be able to do

  • Design reports for a business intelligence infrastructure using Microsoft SQL Server 2008
  • Manage reports within a business intelligence infrastructure using Microsoft SQL Server 2008
  • Design data mining models for a business intelligence infrastructure using Microsoft SQL Server 2008
  • Administer a business intelligence (BI) solution using Microsoft SQL Server 2008
  • Design the business intelligence architecture using Microsoft SQL Server 2008
  • Design SQL Server Integration Services (SSIS) packages
  • Deploy SQL Server Integration Services (SSIS) packages
  • Design an Analysis Services database
Designing a Business Intelligence Infrastructure by Using Microsoft SQL Server 2005Real unit · Cambridge OCR
This unit covers the planning and design of Business Intelligence (BI) infrastructures using Microsoft SQL Server 2005. You'll design SQL Server Reporting Services (SSRS) and Analysis Services (SSAS) solutions and maintain and optimise SSAS solutions using online or offline methods.

What you'll be able to do

  • Plan BI Solutions
  • Design SSRS Solutions
  • Design SSAS Solutions
  • Maintain and Optimise SSAS Solutions
  • Maintain SSAS solutions by using either online or offline methods
Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005Real unit · Cambridge OCR
This unit provides learners with the knowledge and skills to design a database server infrastructure using Microsoft SQL Server 2005. Topics include infrastructure design, security, physical database design, high availability, data recovery, and data archiving strategies.

What you'll be able to do

  • Design a database server infrastructure
  • Design security for a database server solution
  • Design a physical database
  • Design a database solution for high availability
  • Design a data recovery solution for a database
  • Design a strategy for data archiving
Designing a Windows Server 2003 Active Directory and Network InfrastructureReal unit · Cambridge OCR
You'll learn to design comprehensive Windows Server 2003 Active Directory and network infrastructures. The unit covers gathering and analysing business and technical requirements to create conceptual, logical, and physical designs that meet organisational needs.

What you'll be able to do

  • Create the conceptual design by gathering business requirements
  • Create the conceptual design by analysing business requirements
  • Create the conceptual design by gathering technical requirements
  • Create the conceptual design by analysing technical requirements
  • Create the logical design for an Active Directory infrastructure
  • Create the logical design for a network services infrastructure
  • Create the physical design for an Active Directory infrastructure
  • Create the physical design for a network infrastructure
Designing and Developing Enterprise Applications Using the Microsoft .NET Framework 3.5Real unit · Cambridge OCR
This unit equips learners with skills to design and develop enterprise applications using Microsoft .NET Framework 3.5. You'll analyse requirements, design application frameworks and components, stabilise and test applications, and manage deployment and maintenance.

What you'll be able to do

  • Envisage and design an enterprise application using the Microsoft .NET Framework 3.5
  • Design and develop an application framework using the Microsoft .NET Framework 3.5
  • Design application components using the Microsoft .NET Framework 3.5
  • Stabilise and test an application developed using the Microsoft .NET Framework 3.5
  • Migrate, deploy, and maintain an application developed using the Microsoft .NET Framework 3.5
Designing and Developing Enterprise Applications by Using the Microsoft .NET FrameworkReal unit · Cambridge OCR
It teaches you to design, develop, test, deploy, and support enterprise applications using the Microsoft .NET Framework. You'll plan application architecture, design components and frameworks, and ensure application stability and support.

What you'll be able to do

  • Envision an application
  • Design an application
  • Design a component
  • Develop a component
  • Design an application framework
  • Develop an application framework
  • Test an application
  • Stabilise an application
  • Deploy an application
  • Support an application
Designing and Developing Web-Based Applications by Using the Microsoft .NET FrameworkReal unit · Cambridge OCR
You'll learn to design, develop, test, and deploy web-based applications using the Microsoft .NET Framework. The unit covers application envisioning, user interface and component design, application framework development, and implementation of stabilisation techniques.

What you'll be able to do

  • Envision an application using the Microsoft .NET Framework
  • Design an application using the Microsoft .NET Framework
  • Design and develop a user interface using the Microsoft .NET Framework
  • Design and develop a component using the Microsoft .NET Framework
  • Design and develop an application framework using the Microsoft .NET Framework
  • Test an application developed using the Microsoft .NET Framework
  • Stabilise an application developed using the Microsoft .NET Framework
  • Deploy an application developed using the Microsoft .NET Framework
  • Support an application developed using the Microsoft .NET Framework
Designing and Developing Windows Applications Using the Microsoft .NET Framework 3.5Real unit · Cambridge OCR
This unit covers the design and development of Windows applications using the Microsoft .NET Framework 3.5. You'll validate application designs against specifications, plan data management and user interaction strategies, design security implementations, and plan deployment and maintenance to optimise performance.

What you'll be able to do

  • Validate an application design against specifications
  • Plan data management
  • Plan user interaction and presentation strategy
  • Design security implementation
  • Plan application deployment and maintenance
  • Design the application architecture
  • Design for optimised performance
Designing and Developing Windows-Based Applications by Using the Microsoft .NET FrameworkReal unit · Cambridge OCR
You'll learn to design, develop, test, and deploy Windows-based applications using the Microsoft .NET Framework. The unit includes requirements analysis, user interface design, component and framework development, application testing, stabilisation, and support.

What you'll be able to do

  • Envision and design an application based on specified requirements and user needs.
  • Design and develop a user interface that is intuitive and user-friendly.
  • Design and develop a component that performs a specific function within the application.
  • Design and develop an application framework to provide a foundation for the application.
  • Test and stabilise an application to ensure it meets quality standards.
  • Deploy and support an application to ensure its successful implementation and ongoing operation.
Designing and developing a Web siteReal unit · Cambridge OCR
You'll learn to design and build websites addressing loosely-defined requirements. The unit covers website structure, navigation, accessibility, use of (X)HTML and CSS, multimedia integration, and development of test strategies.

What you'll be able to do

  • Design a Web site to address loosely-defined requirements, taking into account user needs and accessibility.
  • Use web development tools to build (X)HTML- and CSS-based websites to address well-defined specifications.
  • Understand the technology and tools needed to use multimedia in the context of a website, including audio, video, and interactive elements.
  • Develop test strategies and apply these to a Web site to ensure functionality and usability.
  • Understand the need for Web standards, including accessibility guidelines and coding best practices.
  • Understand the concepts associated with using the Internet and the World Wide Web for business, including e-commerce and online marketing.
Designing and developing event-driven computer programsReal unit · Cambridge OCR
This unit covers the design and development of event-driven computer programs to solve loosely-defined problems. You'll design program structures and user interfaces, implement event handlers, and develop test strategies, applying established programming and software engineering practices.

What you'll be able to do

  • Design event-driven programs to address loosely-defined problems, considering user needs and system requirements.
  • Produce a working event-driven program which meets the design specification, demonstrating functionality and usability.
  • Develop event-driven programs that reflect established programming and software engineering practice, including coding standards and version control.
  • Develop test strategies and apply these to event-driven programs to ensure functionality, reliability, and performance.
  • Develop design documentation for use in program maintenance and end-user documentation, including flowcharts and user manuals.
Designing and developing object-oriented computer programsReal unit · Cambridge OCR
This unit equips learners to design and develop object-oriented computer programs addressing loosely-defined problems. You'll apply design principles, create UML diagrams, implement programs meeting specifications, and develop test strategies in line with software engineering practices.

What you'll be able to do

  • Design object-oriented programs to address loosely-defined problems, applying appropriate design principles
  • Produce a working object-oriented program which meets the design specification and functional requirements
  • Develop object-oriented programs that reflect established programming and software engineering practice, including coding standards and best practices
  • Develop test strategies for object-oriented programs, covering unit testing, integration testing, and system testing
  • Apply test strategies to object-oriented programs to identify and resolve defects
  • Develop design documentation for use in program maintenance, providing clear and concise information about the program's structure and functionality
  • Develop end-user documentation to guide users on how to effectively use the object-oriented program
Designing and developing procedural computer programsReal unit · Cambridge OCR
It teaches you to design and develop procedural computer programs addressing loosely-defined problems. You'll apply structured programming techniques, produce working programs, and develop and apply test strategies.

What you'll be able to do

  • Design procedural programs to address loosely-defined problems, applying appropriate design principles and structured programming techniques
  • Produce a working procedural program which meets the design specification and functional requirements
  • Develop procedural programs that reflect established programming and software engineering practice, including coding standards and best practices
  • Develop test strategies for procedural programs, covering unit testing, integration testing, and system testing
  • Apply test strategies to procedural programs to identify and resolve defects
  • Develop design documentation for use in program maintenance, providing clear and concise information about the program's structure and functionality
  • Develop end-user documentation to guide users on how to effectively use the procedural program
Designing and optimising Data Access by Using Microsoft SQL Server 2005Real unit · Cambridge OCR
You'll design and optimise data access strategies using Microsoft SQL Server 2005. The unit covers efficient data access methods, query optimisation, error handling, transaction strategies, and performance tuning of databases and applications.

What you'll be able to do

  • Design efficient methods for accessing data within a Microsoft SQL Server 2005 service
  • Design a database query strategy to optimise data retrieval from a Microsoft SQL Server 2005 database
  • Design error-handling routines to manage exceptions and errors during data access operations in Microsoft SQL Server 2005
  • Design a transaction strategy to ensure data integrity and consistency in Microsoft SQL Server 2005
  • Carry out performance tuning of a database and a database application interacting with Microsoft SQL Server 2005 to improve efficiency
Designing, Deploying, and Managing a Network Solution for a Small- and Medium-Sized BusinessReal unit · Cambridge OCR
It teaches you to analyse the IT environment of a small- to medium-sized business and design a suitable network solution. You'll install, configure, support, and expand a Windows Small Business Server 2003 network according to specific requirements and budget.

What you'll be able to do

  • Analyse the existing IT environment of a small- or medium-sized business to identify needs and challenges
  • Design a business technology solution for a small- or medium-sized business, considering its specific requirements and budget
  • Install and configure Windows Small Business Server 2003, including its core components and services
  • Support and maintain Windows Small Business Server 2003, ensuring its stability and security
  • Expand the Windows Small Business Server 2003 network by adding new users, devices, and services
  • Install and configure Windows Server 2003 in conjunction with Windows Small Business Server 2003 to provide additional functionality
Designing, Implementing, and Managing Microsoft Windows MobileReal unit · Cambridge OCR
You'll learn to design, implement, and manage Microsoft Windows Mobile devices. The unit covers device provisioning, management via Exchange Server, messaging infrastructure configuration, mobile application management, network connectivity, and security implementation.

What you'll be able to do

  • Configure Provisioning for mobile devices, including setting up automatic configuration and deployment processes.
  • Manage Devices by Using Exchange Server, including configuring policies, managing security settings, and tracking device usage.
  • Configure a Messaging Infrastructure for mobile devices, including email, SMS, and instant messaging.
  • Design a Mobile Infrastructure, including planning network connectivity, security measures, and device management strategies.
  • Configure Network Connectivity for mobile devices, including Wi-Fi, cellular data, and VPN connections.
  • Manage Mobile Applications, including deploying, updating, and securing applications on mobile devices.
  • Implement Security for Mobile Devices, including password policies, encryption, and remote wipe capabilities.
Designing, optimising and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008Real unit · Cambridge OCR
You'll design and maintain database administrative solutions using Microsoft SQL Server 2008. The unit includes instance and schema design, security, high availability, backup and recovery strategies, monitoring, maintenance, and data distribution planning.

What you'll be able to do

  • Design a SQL Server Instance and a Database Solution
  • Design a Database Server Security Solution
  • Design a Database Solution for High Availability
  • Design a Backup and Recovery Solution
  • Design a Monitoring Strategy
  • Design a Strategy to Maintain and Manage Databases
  • Design a Strategy for Data Distribution
Develop own effectiveness and professionalismReal unit · Cambridge OCR
This unit aims to develop learners' personal and professional skills, including teamwork and continuous professional development. You'll understand professional practice, ethical and legislative IT environments, and contribute to improving organisational effectiveness.

What you'll be able to do

  • Develop own personal and professional skills, identifying areas for improvement and implementing strategies for continuous development.
  • Work as a member of a team to achieve defined goals and implement agreed plans, contributing effectively to team efforts and collaborating with colleagues.
  • Understand what is meant by professional practice in the IT sector, adhering to industry standards and ethical guidelines.
  • Understand the ethical and legislative environment relating to IT activities, including data protection, intellectual property, and cyber security.
  • Improve organisational effectiveness through the application of IT skills and knowledge, contributing to the efficiency and productivity of the organisation.
Develop own effectiveness and professionalismReal unit · Cambridge OCR
This unit aims to develop learners' personal and professional effectiveness within the IT sector. You'll understand professional practice, ethical and legislative considerations, and develop teamwork skills to enhance their career development.

What you'll be able to do

  • Develop own personal skills to enhance performance and career prospects
  • Develop own professional skills to meet industry standards and employer expectations
  • Work as a member of a team, contributing effectively to achieve defined goals
  • Implement agreed plans collaboratively within a team environment
  • Understand what is meant by professional practice in the context of IT
  • Understand the ethical considerations relevant to IT activities and decision-making
  • Understand the legislative environment and legal requirements relating to IT activities
Developing Business Process and Integration Solutions Using Microsoft BizTalk ServerReal unit · Cambridge OCR
You'll plan, develop, debug, and deploy Microsoft BizTalk Server applications. The unit includes integrating business rules, monitoring activities, and analysing business and technical requirements to deliver process and integration solutions.

What you'll be able to do

  • Plan a BizTalk application, taking into account business requirements and technical constraints
  • Develop and debug an integration application using Microsoft BizTalk Server
  • Develop and debug a business process application using Microsoft BizTalk Server
  • Implement business rules within a BizTalk application to automate decision-making
  • Enable business activity monitoring to track and analyse the performance of BizTalk applications
  • Deploy a BizTalk application to a production environment, ensuring its stability and scalability
Health and Safety in ICTReal unit · Cambridge OCR
You'll gain knowledge of Health and Safety procedures relevant to ICT environments. The unit covers identifying hazards, reporting accidents, correct use of personal protective equipment, and maintaining a clean and organised workspace.

What you'll be able to do

  • Comply with relevant Health & Safety procedures in an ICT environment
ICT System OperationReal unit · Cambridge OCR
This unit provides learners with knowledge of ICT system operation, including relevant operating system parts, their functions, and interdependencies. You'll operate specified system parts according to established procedures and guidelines.

What you'll be able to do

  • Know the relevant parts of the operating system, including their functions and interdependencies.
  • Operate specified parts of the system according to established procedures and guidelines.
IT Project Management 2Real unit · Cambridge OCR
You'll develop foundational knowledge of IT project management principles, including project characteristics, roles, and responsibilities. The unit covers project life-cycle activities and the application of project planning and control techniques.

What you'll be able to do

  • Describe the key characteristics of projects and the role of project management
  • Demonstrate an understanding of the fundamental principles that underpin effective project management
  • Describe the typical activities that occur within system and project life-cycles
  • Apply the principles of project planning and control to a simple project scenario
IT Project Management 3Real unit · Cambridge OCR
You'll understand IT project management principles, differentiating programmes, projects, and business as usual. The unit covers risk, quality, change, and configuration management, alongside various management styles and communication techniques.

What you'll be able to do

  • Describe Programmes, Projects and Project Management, and the key differences when compared to Business As Usual (BAU)
  • Apply the principles of Project Risk Management
  • Apply the principles of Project Quality Management
  • Apply Change Control principles
  • Apply Configuration Management principles
  • Use different styles of management within a project environment
  • Use different types of communication within a project environment
  • Understand Team Building using standard models
  • Understand Team Dynamics using standard models
  • Describe typical activities of estimating throughout a project / system development lifecycle
  • Describe the practical problems of estimating throughout a project / system development lifecycle
  • Apply project planning techniques
  • Apply project monitoring techniques
  • Apply project control techniques
IT Security for UsersReal unit · Cambridge OCR
This unit equips learners with knowledge and skills to monitor and minimise security risks to IT systems and data. You'll identify risks, select and implement monitoring procedures, and develop strategies to reduce security vulnerabilities in line with organisational policies.

What you'll be able to do

  • Select appropriate procedures to monitor security risks to IT systems and data
  • Use appropriate procedures to monitor security risks to IT systems and data
  • Develop appropriate procedures to minimise security risks to IT systems and data
IT Security for UsersReal unit · Cambridge OCR
You'll be able to identify potential security risks to IT systems and data, select appropriate methods to minimise these risks, and implement security measures in accordance with organisational guidelines. The unit emphasises risk management and incident reporting.

What you'll be able to do

  • Select appropriate methods to minimise security risk to IT systems and data
  • Use appropriate methods to minimise security risk to IT systems and data
IT User FundamentalsReal unit · Cambridge OCR
This unit provides learners with fundamental IT skills to use systems effectively. You'll manage information storage, apply safety and security practices, and troubleshoot common IT system problems across various applications.

What you'll be able to do

  • Use IT systems effectively to meet a variety of needs and requirements
  • Manage information storage and retrieval appropriately, ensuring data integrity and accessibility
  • Follow and understand the need for safety and security practices within IT systems
  • Maintain IT systems and troubleshoot common IT system problems effectively
Implement and Maintain Microsoft SQL Server 2005 Business IntelligenceReal unit · Cambridge OCR
You'll be able to implement and maintain Microsoft SQL Server 2005 Business Intelligence solutions. The unit covers managing Analysis Services and Reporting Services, developing SSAS and SSRS solutions, and applying data mining techniques using Business Intelligence Development Services.

What you'll be able to do

  • Manage SQL Server Analysis Services (SSAS) instances, including configuration, security, and performance tuning.
  • Develop SSAS Solutions by Using Business Intelligence Development Services (BIDS), including creating cubes, dimensions, and measures.
  • Implement Data Mining by Using BIDS, including selecting appropriate algorithms and evaluating results.
  • Manage SQL Server Reporting Services (SSRS) instances, including configuration, security, and report deployment.
  • Develop Reporting Solutions by Using SSRS, including creating reports, dashboards, and data visualisations.
  • Develop Business Intelligence Solutions by Using SQL Server Integration Services (SSIS), including creating packages, tasks, and data flows.
  • Create event handlers within SSIS packages to manage errors and exceptions.
  • Administer SSIS Packages, including scheduling, monitoring, and troubleshooting.
Implementing Microsoft Internet Security and Acceleration (ISA) Server 2004Real unit · Cambridge OCR
This unit provides learners with skills to implement, configure, and manage Microsoft ISA Server 2004. You'll plan and install ISA Server, configure client computers, manage web caching and firewall policies, and establish remote network connectivity and monitoring.

What you'll be able to do

  • Plan and Install Microsoft Internet Security and Acceleration (ISA) Server 2004
  • Install and Configure Client Computers to work with ISA Server 2004
  • Configure and Manage Microsoft Internet Security and Acceleration (ISA) Server 2004
  • Configure Web Caching within ISA Server 2004
  • Configure Firewall Policy within ISA Server 2004
  • Configure and Manage Remote Network Connectivity using ISA Server 2004
  • Monitor and Report on ISA Server 2004 Activity
Implementing a Microsoft SQL Server 2008 DatabaseReal unit · Cambridge OCR
You'll learn to implement and manage Microsoft SQL Server 2008 databases, including creating tables and views, developing programming objects, applying query techniques, working with additional components and XML data, and gathering performance information.

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 and functions, within a Microsoft SQL Server 2008 database
  • Work with query fundamentals to retrieve and manipulate data
  • Apply additional query techniques to optimise data retrieval and manipulation
  • Work with additional SQL Server components to enhance database functionality
  • Work with XML data within a Microsoft SQL Server 2008 database
  • Gather performance information to optimise database performance
Implementing and Administering Security in a Microsoft Windows Server 2003 NetworkReal unit · Cambridge OCR
You'll be able to implement, manage, and troubleshoot security policies and patch management within a Microsoft Windows Server 2003 network. The unit covers Group Policy Objects, user rights, password policies, security log monitoring, and authentication and authorisation configuration.

What you'll be able to do

  • Implement security policies within a Microsoft Windows Server 2003 network environment
  • Manage security policies within a Microsoft Windows Server 2003 network environment
  • Troubleshoot security policies within a Microsoft Windows Server 2003 network environment
  • Implement a patch management infrastructure within a Microsoft Windows Server 2003 network environment
  • Manage a patch management infrastructure within a Microsoft Windows Server 2003 network environment
  • Troubleshoot a patch management infrastructure within a Microsoft Windows Server 2003 network environment
  • Implement security measures for network communications within a Microsoft Windows Server 2003 network environment
  • Manage security measures for network communications within a Microsoft Windows Server 2003 network environment
  • Troubleshoot security measures for network communications within a Microsoft Windows Server 2003 network environment
  • Plan authentication, authorisation, and Public Key Infrastructure (PKI) within a Microsoft Windows Server 2003 network environment
  • Configure authentication, authorisation, and Public Key Infrastructure (PKI) within a Microsoft Windows Server 2003 network environment
  • Troubleshoot authentication, authorisation, and Public Key Infrastructure (PKI) within a Microsoft Windows Server 2003 network environment
Implementing and Maintaining Microsoft SQL Server 2008Real unit · Cambridge OCR
This unit provides learners with skills to implement and maintain Microsoft SQL Server 2008. You'll install and configure SQL Server, maintain instances, manage security, perform database maintenance, monitor performance, troubleshoot issues, and implement high availability.

What you'll be able to do

  • Install and configure Microsoft SQL Server 2008 according to specified requirements
  • Maintain SQL Server instances to ensure their ongoing stability and performance
  • Manage SQL Server security to protect data and prevent unauthorised access
  • Maintain a SQL Server database, including tasks such as backups and recovery
  • Perform data management tasks within SQL Server, such as importing, exporting, and transforming data
  • Monitor and troubleshoot SQL Server to identify and resolve performance issues
  • Optimise SQL Server performance to ensure efficient data processing
  • Implement high availability solutions for SQL Server to minimise downtime
Implementing and Managing Microsoft Exchange Server 2003Real unit · Cambridge OCR
This unit covers the installation, configuration, management, monitoring, and troubleshooting of Microsoft Exchange Server 2003. You'll learn to manage Exchange Server computers and organisations, implement security measures, and support related technologies to ensure optimal operation.

What you'll be able to do

  • Install Exchange Server 2003
  • Configure Exchange Server 2003
  • Troubleshoot Exchange Server 2003
  • Manage Exchange Server computers
  • Monitor Exchange Server computers
  • Troubleshoot Exchange Server computers
  • Manage the Exchange organisation
  • Monitor the Exchange organisation
  • Troubleshoot the Exchange organisation
  • Manage security in the Exchange environment
  • Manage technologies that support Exchange Server 2003
  • Monitor technologies that support Exchange Server 2003
Implementing, Managing, and Maintaining a Windows Server 2003 Network InfrastructureReal unit · Cambridge OCR
You'll develop expertise in implementing, managing, and maintaining network infrastructure services within a Windows Server 2003 environment. The unit covers IP addressing, name resolution, network security, routing, remote access, and overall network infrastructure maintenance.

What you'll be able to do

  • Implement, manage and maintain IP addressing within a Windows Server 2003 network infrastructure.
  • Implement, manage, and maintain name resolution services within a Windows Server 2003 network infrastructure.
  • Implement, manage, and maintain network security measures within a Windows Server 2003 network infrastructure.
  • Implement, manage, and maintain routing and remote access services within a Windows Server 2003 network infrastructure.
  • Maintain a network infrastructure to ensure optimal performance and reliability.
Implementing, Managing, and Troubleshooting Microsoft Office Live Communications Server 2005Real unit · Cambridge OCR
It teaches you to prepare infrastructure and install Microsoft Office Live Communications Server 2005. You'll implement remote user access, manage the server infrastructure, configure client applications, and troubleshoot to maintain server performance.

What you'll be able to do

  • Prepare the Infrastructure to Deploy Live Communications Server 2005, including hardware, software, and network requirements.
  • Install Live Communications Server 2005, including configuring server settings and integrating with existing infrastructure.
  • Implement Remote User Access and Federation, including configuring access for remote users and integrating with other communication systems.
  • Manage a Live Communication Server Infrastructure, including monitoring server performance, troubleshooting issues, and managing user accounts.
  • Configure Microsoft Office Communicator 2005, including user settings, communication preferences, and integration with other applications.
Installing, Configuring and Administering MS Windows 2000 ProfessionalReal unit · Cambridge OCR
You'll learn to install, configure, and administer Microsoft Windows 2000 Professional. The unit covers resource administration, hardware and driver management, system performance optimisation, desktop environment configuration, and network protocol troubleshooting.

What you'll be able to do

  • Install Windows 2000 Professional operating system.
  • Implement and conduct administration of resources within Windows 2000 Professional.
  • Implement, manage, and troubleshoot hardware devices and drivers within Windows 2000 Professional.
  • Monitor and optimise system performance and reliability within Windows 2000 Professional.
  • Configure and troubleshoot the desktop environment within Windows 2000 Professional.
  • Implement, manage, and troubleshoot network protocols and services within Windows 2000 Professional.
  • Implement, monitor, and troubleshoot security within Windows 2000 Professional.
Installing, Configuring and Administering MS Windows XP ProfessionalReal unit · Cambridge OCR
This unit covers the installation, configuration, and administration of Microsoft Windows XP Professional. You'll learn to manage user accounts, troubleshoot hardware devices and drivers, optimise system performance, and configure the desktop environment effectively.

What you'll be able to do

  • Install Windows XP Professional according to best practices
  • Implement and conduct administration of resources within Windows XP Professional
  • Implement, manage, monitor, and troubleshoot hardware devices and drivers within Windows XP Professional
  • Monitor and optimise system performance and reliability of Windows XP Professional
  • Configure and troubleshoot the desktop environment within Windows XP Professional
  • Implement, manage, and troubleshoot network protocols and services within Windows XP Professional
  • Configure, manage and troubleshoot security settings within Windows XP Professional
Installing, Configuring, and Administering Microsoft Internet Security and Acceleration (ISA) Server 2000, Enterprise EditionReal unit · Cambridge OCR
You'll learn to install, configure, administer, and troubleshoot Microsoft Internet Security and Acceleration (ISA) Server 2000, Enterprise Edition. The unit covers configuring ISA Server services, managing policies and rules, deploying client computers, and monitoring server use.

What you'll be able to do

  • Install ISA Server
  • Configure ISA Server Services
  • Troubleshoot ISA Server Services
  • Configure Policies and Rules within ISA Server
  • Manage Policies and Rules within ISA Server
  • Troubleshoot Policies and Rules within ISA Server
  • Deploy the Client Computer for ISA Server
  • Configure the Client Computer for ISA Server
  • Troubleshoot the Client Computer for ISA Server
  • Monitor ISA Server Use
  • Manage ISA Server Use
  • Analyse ISA Server Use
Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise EditionReal unit · Cambridge OCR
It teaches you to install, configure, administer, monitor, and troubleshoot Microsoft SQL Server 2000 Enterprise Edition. You'll gain practical skills in database creation, management, security, data extraction, transformation, and performance monitoring.

What you'll be able to do

  • Install and configure SQL Server 2000
  • Create SQL Server 2000 Databases
  • Manage SQL Server 2000 Databases
  • Monitor SQL Server 2000 Databases
  • Troubleshoot SQL Server 2000 Databases
  • Extract and transform data with SQL Server 2000
  • Manage SQL Server 2000 Security
  • Monitor SQL Server 2000 Security
  • Manage SQL Server 2000
  • Monitor SQL Server 2000
  • Troubleshoot SQL Server 2000
Interconnecting Cisco Networking Devices (CCNA Parts 3 and 4)Real unit · Cambridge OCR
This unit develops learners' ability to plan, design, implement, operate, and troubleshoot simple networks using Cisco technologies. You'll understand Cisco network technologies and apply this knowledge to create secure and scalable network solutions.

What you'll be able to do

  • Know the main technologies used in Cisco networks, including their functions and applications.
  • Plan and design simple networks using Cisco technology, considering factors such as scalability and security.
  • Implement and operate simple networks using Cisco devices and configurations.
  • Troubleshoot simple networks to identify and resolve common issues.
Interpersonal and written communicationReal unit · Cambridge OCR
This unit develops learners' interpersonal and written communication skills for effective workplace information exchange. You'll practise sending and receiving complex information, using written communication techniques, and guiding colleagues on communication methods.

What you'll be able to do

  • Send and receive complex information by communicating interpersonally with others
  • Understand and use appropriate written communication techniques
  • Provide guidance to immediate colleagues on how to effectively communicate information
Interpersonal and written communicationReal unit · Cambridge OCR
It teaches you to communicate effectively in familiar interpersonal and written contexts. You'll develop active listening skills, respond appropriately to information, and produce clear written communication using suitable language and formats.

What you'll be able to do

  • Send and receive familiar information by communicating interpersonally in familiar situations
  • Communicate in writing in familiar situations
Introduction to Cisco Networking Technologies (CCNA parts 1 and 2)Real unit · Cambridge OCR
This unit provides foundational knowledge of Cisco networking technologies. You'll identify key Cisco devices, demonstrate basic network support, apply troubleshooting techniques, and implement simple Cisco network configurations.

What you'll be able to do

  • Know the main features of IT networks related to Cisco technology.
  • Provide basic support to simple Cisco networks.
  • Implement and operate simple Cisco networks.
Introduction to IT systems developmentReal unit · Cambridge OCR
This unit introduces learners to IT systems components and roles within IT organisations. You'll understand hardware, software, and network elements, the responsibilities of IT personnel, and the concepts and models of the IT Systems Development Life Cycle (SDLC).

What you'll be able to do

  • Understand the components of IT systems and the roles and responsibilities of IT personnel within an organisation
  • Understand different IT Systems Development Life Cycle (SDLC) models and their application
  • Understand IT Systems Development Life Cycle (SDLC) concepts and processes, including planning, analysis, design, implementation, testing, and maintenance
Investigating and defining customer requirements for ICT systemsReal unit · Cambridge OCR
You'll be able to investigate and define customer requirements for ICT systems. The unit covers gathering information on existing systems, analysing functionality and limitations, and identifying needs and constraints to inform system development.

What you'll be able to do

  • Investigate existing ICT systems and processes to understand their functionality and limitations
  • Analyse gathered information to identify customer needs and constraints related to ICT systems
MCAD Skills to MCPD Web Developer by Using the Microsoft .NET FrameworkReal unit · Cambridge OCR
You'll learn to transition from MCAD to MCPD Web Developer using the Microsoft .NET Framework. The unit covers application development with system types and collections, tracing, configuring, deploying applications, and customising web applications.

What you'll be able to do

  • Develop applications that use system types and collections to manage data
  • Trace, configure, and deploy applications to ensure proper functionality
  • Customise and personalize a web application to meet user preferences
  • Implement authentication and authorisation to secure web applications
  • Create ASP.NET mobile web applications for mobile devices
  • Envision and design an application to meet specific requirements
  • Design and develop a user interface to provide a user-friendly experience
  • Design and develop a component to encapsulate functionality
  • Design and develop an application framework to provide a foundation for applications
  • Test and stabilise an application to ensure quality and reliability
  • Deploy and support an application to make it available to users
  • Embed configuration, diagnostic, management, and installation features into a .NET Framework application to simplify administration
  • Implement serialization and input/output functionality in a .NET Framework application to manage data
  • Improve the security of .NET Framework applications by using the .NET Framework 2.0 security features to protect against threats
  • Implement interoperability, reflection, and mailing functionality in a .NET Framework application to integrate with other systems
  • Implement globalization, drawing, and text manipulation functionality in a .NET Framework application to support different languages and cultures
  • Create and program a web application to provide web-based functionality
  • Integrate data in a web application by using ADO.NET, XML, and data-bound controls to access and display data
  • Create custom web controls to extend the functionality of web applications
MCAD Skills to MCPD Windows Developer by Using the Microsoft .NET FrameworkReal unit · Cambridge OCR
You'll develop and deploy applications using the Microsoft .NET Framework, advancing from MCAD to MCPD Windows Developer skills. The unit covers system types, asynchronous programming, user interface design, component development, and application configuration.

What you'll be able to do

  • Develop applications that use system types and collections
  • Implement Asynchronous Programming Techniques to Improve the User Experience
  • Configure and Deploy Applications
  • Envision and Design an Application
  • Design and Develop a User Interface
  • Design and Develop a Component
  • Design and Develop an Application Framework
  • Test and Stabilise an Application
  • Deploy and Support an Application
  • Embed configuration, diagnostic, management, and installation features into a .NET Framework application
  • Implement serialisation and input/output functionality in a .NET Framework application
  • Improve the security of .NET Framework applications by using the .NET Framework 2.0 security features
  • Implement interoperability, reflection, and mailing functionality in a .NET Framework application
  • Implement globalisation, drawing, and text manipulation functionality in a .NET Framework application
  • Create a UI for a Windows Forms Application by Using Standard Controls
  • Integrate Data in a Windows Forms Application
  • Enhance Usability
MCAD Skills to MCTS Web Applications by Using the Microsoft .NET FrameworkReal unit · Cambridge OCR
This unit supports learners in transitioning from MCAD to MCTS Web Applications using Microsoft .NET Framework. You'll develop applications utilising system types and collections, configure and deploy applications, customise web interfaces, and implement authentication and authorisation.

What you'll be able to do

  • Develop applications that use system types and collections
  • Trace, configure, and deploy applications
  • Customise and personalise a web application
  • Implement authentication and authorisation
  • Create ASP.NET mobile web applications
  • Embed configuration, diagnostic, management, and installation features into a .NET Framework application
  • Implement serialization and input/output functionality in a .NET Framework application
  • Improve the security of .NET Framework applications by using the .NET Framework 2.0 security features
  • Implement interoperability, reflection, and mailing functionality in a .NET Framework application
  • Implement globalisation, drawing, and text manipulation functionality in a .NET Framework application
  • Create and programme a web application
  • Integrate data in a web application by using ADO.NET, XML, and data-bound controls
  • Create custom web controls
MCAD Skills to MCTS Windows Applications by Using the Microsoft .NET FrameworkReal unit · Cambridge OCR
You'll transition from MCAD skills to MCTS Windows Applications development using the Microsoft .NET Framework. The unit covers developing applications with system types and collections, asynchronous programming, application configuration, deployment, and implementing serialization and diagnostics.

What you'll be able to do

  • Develop applications that use system types and collections
  • Implement asynchronous programming techniques to improve the user experience
  • Configure and deploy applications
  • Embed configuration, diagnostic, management, and installation features into a .NET Framework application
  • Implement serialization and input/output functionality in a .NET Framework application
  • Improve the security of .NET Framework applications by using the .NET Framework 2.0 security features
  • Implement interoperability, reflection, and mailing functionality in a .NET Framework application
  • Implement globalisation, drawing, and text manipulation functionality in a .NET Framework application
  • Create a UI for a Windows Forms Application by using standard controls
  • Integrate data in a Windows Forms Application
  • Enhance usability
MS 70-271 - Supporting Users and Troubleshooting a Microsoft Windows XP Operating SystemReal unit · Cambridge OCR
This unit covers the installation, management, and troubleshooting of the Microsoft Windows XP operating system. You'll learn to install the OS, manage user access and resources, configure hardware devices and drivers, and troubleshoot desktop and user environment issues.

What you'll be able to do

  • Install a Windows Desktop Operating System
  • Manage access to resources on a Windows Desktop Operating System
  • Troubleshoot access to resources on a Windows Desktop Operating System
  • Configure hardware devices and drivers on a Windows Desktop Operating System
  • Troubleshoot hardware devices and drivers on a Windows Desktop Operating System
  • Configure the desktop environment on a Windows Desktop Operating System
  • Configure the user environment on a Windows Desktop Operating System
  • Troubleshoot the desktop environment on a Windows Desktop Operating System
  • Troubleshoot the user environment on a Windows Desktop Operating System
MS 70-272 - Supporting Users and Troubleshooting Desktop Applications on a Microsoft Windows XP Operating SystemReal unit · Cambridge OCR
You'll gain skills to configure, troubleshoot, and resolve usability and customisation issues for desktop applications on Microsoft Windows XP. The unit includes application installation, configuration, updating, and connectivity troubleshooting.

What you'll be able to do

  • Configure applications on a Microsoft Windows XP operating system
  • Troubleshoot applications on a Microsoft Windows XP operating system
  • Resolve issues related to application usability on a Microsoft Windows XP operating system
  • Resolve issues related to application customisation on a Microsoft Windows XP operating system
  • Configure connectivity for applications on a Microsoft Windows XP operating system
  • Troubleshoot connectivity for applications on a Microsoft Windows XP operating system
  • Configure application security on a Microsoft Windows XP operating system
MTA: Database Administration FundamentalsReal unit · Cambridge OCR
You'll gain an understanding of core database concepts, including relational and non-relational models, data types, keys, and table relationships. The unit also covers creating and manipulating database objects, data storage, and fundamental database administration tasks.

What you'll be able to do

  • Understand core database concepts, including database models, data types, and relationships
  • Create database objects, such as tables, views, and indexes, using appropriate tools and techniques
  • Manipulate data within a database, including inserting, updating, and deleting records
  • Understand data storage mechanisms, including file systems, storage devices, and backup strategies
  • Administer a database, including user management, security configuration, and performance tuning
MTA: Networking FundamentalsReal unit · Cambridge OCR
You'll gain an understanding of network infrastructures, hardware components, and protocols. The unit covers identification of network types and topologies, functions of network hardware, and the purpose and operation of network protocols and services.

What you'll be able to do

  • Demonstrate an understanding of network infrastructures, including different network types and topologies
  • Identify and describe the functions of various network hardware components
  • Explain the purpose and operation of common network protocols and services
MTA: Security FundamentalsReal unit · Cambridge OCR
This unit provides learners with foundational knowledge of security layers, operating system security features, network security protocols, and security software. You'll explore defence in depth concepts and methods to mitigate common security vulnerabilities.

What you'll be able to do

  • Understand the concept of security layers
  • Understand operating system security features and vulnerabilities
  • Understand network security protocols and technologies
  • Understand the purpose and function of security software
MTA: Software Development FundamentalsReal unit · Cambridge OCR
You'll gain foundational knowledge of software development concepts including core programming, object-oriented principles, software methodologies, and application development for web, desktop, and database environments.

What you'll be able to do

  • Demonstrate an understanding of core programming concepts, including data types, control structures, and algorithms
  • Demonstrate an understanding of object-oriented programming principles, including classes, objects, and inheritance
  • Demonstrate an understanding of general software development methodologies, including the software development lifecycle
  • Demonstrate an understanding of web application development concepts, including HTML, CSS, and JavaScript
  • Demonstrate an understanding of desktop application development concepts, including user interfaces and event handling
  • Demonstrate an understanding of database concepts, including relational databases and SQL
MTA: Web Development FundamentalsReal unit · Cambridge OCR
This unit provides learners with skills to program, troubleshoot, debug, and deploy web applications using appropriate technologies. You'll work with data, services, client-side scripting, and configure web applications for deployment in suitable environments.

What you'll be able to do

  • Programme web applications using appropriate technologies
  • Work with data and services in web applications
  • Troubleshoot web applications to identify and resolve issues
  • Debug web applications to ensure correct functionality
  • Work with client-side scripting languages to enhance web application functionality
  • Configure web applications for deployment
  • Deploy web applications to a suitable environment
MTA: Windows Development FundamentalsReal unit · Cambridge OCR
You'll understand the fundamentals of Windows programming, including processes, threads, and memory management. The unit covers creating Windows Forms and Services applications, accessing data within applications, and deploying Windows applications to target environments.

What you'll be able to do

  • Understand Windows programming basics, including core concepts and terminology
  • Create Windows Forms applications with a graphical user interface
  • Create Windows Services applications that run in the background
  • Access data in a Windows Forms application using appropriate data access techniques
  • Deploy a Windows application to a target environment
Managing Software DevelopmentReal unit · Cambridge OCR
You'll gain knowledge of software development methodologies, lifecycle stages, coding standards, and testing techniques. This unit enables them to understand and supervise the technical aspects of software development work effectively.

What you'll be able to do

  • Understand the technical aspects of the software development work of others
  • Supervise the technical aspects of the software development work of others
Managing and Maintaining a Windows Server 2003 EnvironmentReal unit · Cambridge OCR
You'll manage and maintain a Windows Server 2003 environment, including physical and logical devices, user and group management, resource access, server maintenance, and disaster recovery implementation.

What you'll be able to do

  • Manage physical devices
  • Maintain physical devices
  • Manage logical devices
  • Maintain logical devices
  • Manage users
  • Manage computers
  • Manage groups
  • Manage access to resources
  • Maintain access to resources
  • Manage a server environment
  • Maintain a server environment
  • Manage and implement disaster recovery
Microsoft .NET Framework - Application Development FoundationReal unit · Cambridge OCR
You'll develop applications using Microsoft .NET Framework, utilising system types, collections, service processes, threading, configuration, diagnostics, serialization, and input/output features to build robust applications.

What you'll be able to do

  • Develop applications that use system types and collections within the .NET Framework.
  • Implement service processes, threading, and application domains in a .NET Framework application.
  • Embed configuration, diagnostic, management, and installation features into a .NET Framework application.
  • Implement serialization and input/output functionality in a .NET Framework application.
  • Improve the security of .NET Framework applications by using the .NET Framework security features.
  • Implement interoperability, reflection, and mailing functionality in a .NET Framework application.
  • Implement globalization, drawing, and text manipulation functionality in a .NET Framework application.
Microsoft .NET Framework 2.0 - Distributed Application DevelopmentReal unit · Cambridge OCR
You'll learn to create distributed applications using Microsoft .NET Framework 2.0. The unit covers creating and accessing XML Web Services, configuring web service applications, implementing remoting applications, and utilising asynchronous calls and messaging technologies.

What you'll be able to do

  • Create and access XML Web Services within the Microsoft .NET Framework 2.0.
  • Configure and customise a Web Service application to meet specific requirements.
  • Create, configure, and deploy remoting applications using the Microsoft .NET Framework 2.0.
  • Implement asynchronous calls and remoting events within a distributed application.
  • Implement Web Services Enhancements (WSE) 3.0 to improve web service capabilities.
  • Create and access a serviced component and utilise message queuing within the Microsoft .NET Framework 2.0.
Microsoft .NET Framework 2.0 - Web-Based Client DevelopmentReal unit · Cambridge OCR
You'll develop web-based client applications using Microsoft .NET Framework 2.0. The unit covers creating and programming web applications, integrating data with ADO.NET and XML, customising controls, implementing authentication, and deploying responsive and secure web solutions.

What you'll be able to do

  • Create and program a Web application using appropriate technologies and frameworks to meet specified requirements
  • Integrate data in a Web application by using ADO.NET, XML, and data-bound controls, ensuring data is accessible and properly displayed
  • Create custom Web controls to extend the functionality and appearance of the Web application
  • Trace, configure, and deploy Web applications, ensuring they are properly installed and run on target servers
  • Customise and personalise a Web application to meet individual user preferences and needs
  • Implement authentication and authorisation mechanisms to secure the Web application and protect sensitive data
  • Create ASP.NET mobile Web applications that are optimised for viewing on mobile devices
Microsoft .NET Framework 2.0 – Windows-Based Client DevelopmentReal unit · Cambridge OCR
You'll develop Windows-based client applications using Microsoft .NET Framework 2.0. The unit covers creating user interfaces with standard controls, integrating data, implementing printing and reporting, enhancing usability, and applying asynchronous programming techniques.

What you'll be able to do

  • Create a user interface for a Windows Forms application by using standard controls from the .NET Framework 2.0
  • Integrate data into a Windows Forms application using appropriate data access techniques
  • Implement printing and report functionality within a Windows Forms application
  • Enhance the usability of a Windows Forms application through effective design and user interaction
  • Implement asynchronous programming techniques to improve the user experience in a Windows Forms application
  • Develop custom Windows Forms controls to extend the functionality of the user interface
  • Configure and deploy Windows Forms applications to end-users
Microsoft .NET Framework 3.5 – Windows Communication Foundation Application DevelopmentReal unit · Cambridge OCR
You'll learn to create, expose, deploy, administer, consume, and secure services using Microsoft .NET Framework 3.5 Windows Communication Foundation (WCF). The unit covers service creation, hosting options, security implementation, and lifecycle management of WCF applications.

What you'll be able to do

  • Create Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
  • Expose and Deploy Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
  • Instrument and Administer Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
  • Consume Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
  • Secure Services using Microsoft .NET Framework 3.5 – Windows Communication Foundation
  • Manage the Service Life Cycle using Microsoft .NET Framework 3.5 – Windows Communication Foundation
Microsoft .NET Framework 3.5 – Windows Presentation Foundation Application DevelopmentReal unit · Cambridge OCR
You'll learn to create and customise Windows Presentation Foundation (WPF) applications using the .NET Framework 3.5. The unit covers building user interfaces, managing content, data binding, appearance customisation, and application configuration and deployment.

What you'll be able to do

  • Create a Windows Presentation Foundation (WPF) application
  • Build user interfaces using WPF tools and techniques
  • Add and manage content within a WPF application
  • Bind WPF elements to data sources for dynamic content display
  • Customise the appearance of WPF applications to meet design specifications
  • Configure and deploy WPF applications for distribution and use
Microsoft .NET Framework 3.5 – Windows Workflow Foundation Application DevelopmentReal unit · Cambridge OCR
You'll learn to create and host workflows using Microsoft .NET Framework 3.5 Windows Workflow Foundation. The unit includes custom activity creation, applying rules and conditions, managing transactions and compensations, and configuring runtime services.

What you'll be able to do

  • Create and host workflows using the Microsoft .NET Framework 3.5 – Windows Workflow Foundation
  • Communicate with workflows to exchange data and control execution
  • Create and configure custom activities to extend workflow functionality
  • Apply rules and conditions to control workflow execution paths
  • Manage transactions and compensations within workflows to ensure data integrity
  • Create and manage runtime services to support workflow execution
Microsoft .NET Framework 3.5, ADO.NET Application DevelopmentReal unit · Cambridge OCR
This unit provides learners with the skills to connect to, query, modify, and synchronise data from various sources using Microsoft .NET Framework 3.5 and ADO.NET. You'll also perform object relational mapping using the Entity Framework for effective data interaction.

What you'll be able to do

  • Connect to data sources using appropriate methods and technologies
  • Select and query data from various data sources effectively
  • Modify data within data sources, ensuring data integrity
  • Synchronise data between different data sources to maintain consistency
  • Work with disconnected data, enabling offline access and data manipulation
  • Perform object relational mapping by using the Entity Framework to interact with databases
Microsoft .NET Framework 3.5, ASP.NET Application DevelopmentReal unit · Cambridge OCR
This unit covers configuring, deploying, and troubleshooting ASP.NET web applications using Microsoft .NET Framework 3.5. You'll work with server controls, data services, AJAX, client-side scripting, mobile targeting, and web application programming.

What you'll be able to do

  • Configure web applications
  • Deploy web applications
  • Consume server controls
  • Create server controls
  • Work with data
  • Work with services
  • Troubleshoot web applications
  • Debug web applications
  • Work with ASP.NET AJAX
  • Work with client-side scripting
  • Target mobile devices
  • Programme web applications
Microsoft .NET Framework 3.5, Windows Forms Application DevelopmentReal unit · Cambridge OCR
This unit focuses on developing Windows Forms applications using Microsoft .NET Framework 3.5. You'll create user interfaces, integrate data, implement printing and reporting features, enhance usability, and apply asynchronous programming techniques to improve user experience.

What you'll be able to do

  • Create a User Interface (UI) for a Windows Forms Application by using standard controls to meet specified design requirements
  • Integrate data from various sources into a Windows Forms Application, ensuring data integrity and accessibility
  • Implement printing and report functionality within a Windows Forms Application, enabling users to generate hard copies and summaries of data
  • Enhance the usability of a Windows Forms Application through intuitive design, clear navigation, and user-friendly features
  • Implement asynchronous programming techniques to improve the user experience by preventing the application from freezing during long-running operations
  • Develop custom Windows Forms controls to extend the functionality and appearance of the application
  • Configure and deploy Windows Forms Applications, ensuring they are properly installed and run on target systems
Microsoft Office Groove 2007, ConfiguringReal unit · Cambridge OCR
You'll gain skills to manage Microsoft Office Groove 2007 workspaces and accounts, including workspace creation, configuration, administration, and security. The unit also covers managing the Groove domain, installing and administering Groove servers, and facilitating effective collabouration.

What you'll be able to do

  • Manage Groove Workspaces, including creating, configuring, and administering workspaces for collaboration.
  • Maintain Groove Accounts, including user account management, permissions, and security settings.
  • Manage the Groove Domain, including domain configuration, policies, and security settings.
  • Install Groove Servers, including planning, configuring, and deploying Groove servers.
  • Administer Groove Servers, including monitoring server performance, troubleshooting issues, and managing server resources.
  • Deploy the Groove Client, including planning, configuring, and deploying the Groove client software to users.
  • Interpret Groove Communications, including understanding and analysing communication logs and data within the Groove environment.
Microsoft Office PerformancePoint Server 2007, ApplicationsReal unit · Cambridge OCR
You'll develop the ability to configure and use Microsoft Office PerformancePoint Server 2007 for business performance management. The unit includes configuring dimensions, models, business roles, and rules, as well as developing Excel Add-In forms, reports, and dashboards.

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 using PerformancePoint Server 2007
  • Develop Dashboards using Microsoft Office PerformancePoint Server 2007
  • Install PerformancePoint Server
Microsoft Office Project 2007, Managing ProjectsReal unit · Cambridge OCR
You'll learn to manage projects using Microsoft Office Project 2007, including configuring tools and options, setting up projects, estimating and scheduling tasks, resource planning, and updating and reporting on project performance.

What you'll be able to do

  • Configure Tools and Options within Microsoft Office Project 2007
  • Set Up a Project within Microsoft Office Project 2007
  • Estimate, Schedule, and Budget Tasks within Microsoft Office Project 2007
  • Resource Project Plans within Microsoft Office Project 2007
  • Update and Report on Project Performance using Microsoft Office Project 2007
Microsoft Office Project Server 2007, Managing ProjectsReal unit · Cambridge OCR
You'll learn to manage projects within Microsoft Office Project Server 2007. This includes initiating, planning, executing, monitoring, and controlling projects, as well as managing Project Professional and PWA environments.

What you'll be able to do

  • Initiate projects effectively using Microsoft Office Project Server 2007.
  • Plan projects comprehensively within the Microsoft Office Project Server 2007 environment.
  • Execute projects according to the project plan using Microsoft Office Project Server 2007.
  • Monitor and control projects, tracking progress and managing issues within Microsoft Office Project Server 2007.
  • Manage Project Professional and PWA (Project Web Access) environments to support project management activities.
Microsoft Office SharePoint Server 2007 – Application DevelopmentReal unit · Cambridge OCR
It develops skills to manage enterprise content within Microsoft Office SharePoint Server 2007. You'll organise content, implement auditing policies, create business intelligence solutions, and integrate business data using the Business Data Catalog.

What you'll be able to do

  • Manage enterprise content effectively within Microsoft Office SharePoint Server 2007
  • Audit Windows SharePoint Services content by using a custom policy to ensure compliance
  • Create business intelligence solutions by using Office SharePoint Server 2007 to support decision-making
  • Integrate business data with Office SharePoint Server 2007 by using the Business Data Catalog (BDC) to provide a unified view of information
  • Access Office SharePoint Server 2007 Application Platform Services to extend functionality
  • Search data effectively by using the Search Service within Office SharePoint Server 2007
  • Target content based on audience membership to deliver personalised experiences
  • Customise functionality by using profiles to tailor the user experience
Microsoft Office Visio 2007, Application DevelopmentReal unit · Cambridge OCR
You'll learn to deploy and customise Microsoft Office Visio 2007 solutions. The unit covers working with external data sources, developing Visio libraries, automating diagrams, and publishing for effective viewing and sharing.

What you'll be able to do

  • Deploy Visio solutions effectively within a specified environment
  • Work with external data sources to enhance Visio diagrams
  • Develop Visio libraries for re-use in multiple diagrams
  • Automate Visio diagrams using scripting or other automation techniques
  • Publish and view Visio diagrams using appropriate methods
Microsoft SQL Server 2005 - Implementation and MaintenanceReal unit · Cambridge OCR
This unit equips learners with skills to install, configure, and maintain Microsoft SQL Server 2005. You'll implement high availability and disaster recovery solutions, support data consumers, maintain databases, and monitor and troubleshoot SQL Server performance.

What you'll be able to do

  • Install and configure SQL Server 2005 according to specified requirements
  • Implement high availability and disaster recovery solutions for SQL Server 2005
  • Support data consumers by providing access to SQL Server 2005 databases
  • Maintain databases within SQL Server 2005 to ensure optimal performance and data integrity
  • Monitor and troubleshoot SQL Server 2005 performance to identify and resolve issues
  • Create and implement database objects within SQL Server 2005 to meet application requirements
Microsoft Virtual Earth 6.0, Application DevelopmentReal unit · Cambridge OCR
This unit equips learners with the ability to retrieve, analyse, and display location solution data using Microsoft Virtual Earth 6.0. You'll administer the location platform and manipulate map displays to create customised visualisations effectively.

What you'll be able to do

  • Retrieve location solution data effectively
  • Analyse location data accurately
  • Display location solution data clearly
  • Administer your location platform efficiently
  • Manipulate the map effectively
  • Create and customise the map display appropriately
Microsoft Windows Mobile 5.0 - Application DevelopmentReal unit · Cambridge OCR
You'll learn to create mobile applications using Microsoft .NET Compact Framework 2.0 for Windows Mobile 5.0. The unit covers user interface design, data integration via file systems, ADO.NET, XML, and data management using Microsoft SQL Server 2005 Everywhere Edition.

What you'll be able to do

  • Develop Mobile Applications by Using the Microsoft .NET Compact Framework 2.0
  • Design a Windows Mobile User Interface
  • Develop a Windows Mobile User Interface
  • Integrate Data in a Windows Mobile-Based Application by Using File System
  • Integrate Data in a Windows Mobile-Based Application by Using ADO.NET
  • Integrate Data in a Windows Mobile-Based Application by Using XML
  • Manage Data by Using Microsoft SQL Server 2005 Everywhere Edition
  • Develop Communication capabilities in Windows Mobile-Based Applications
  • Develop Connection capabilities in Windows Mobile-Based Applications
  • Implement Interoperability features in Windows Mobile-Based Applications
  • Implement Platform-Specific Features in Windows Mobile-Based Applications
  • Optimise Windows Mobile Based Applications
  • Package Windows Mobile Based Applications
  • Deploy Windows Mobile Based Applications
Microsoft Windows SharePoint Services 3.0 – Application DevelopmentReal unit · Cambridge OCR
You'll learn to deploy Windows SharePoint Services and custom components. The unit covers creating site and feature provisioning components, metadata and workflow provisioning, and developing SharePoint components using the .NET Framework.

What you'll be able to do

  • Deploy Windows SharePoint Services and custom components
  • Create site and feature provisioning components within Windows SharePoint Services
  • Create metadata and workflow provisioning components within Windows SharePoint Services
  • Develop Windows SharePoint Services components by using the .NET Framework
Optimise IT System PerformanceReal unit · Cambridge OCR
This unit provides learners with skills to optimise IT system performance through routine maintenance, file and disk management, and troubleshooting. You'll customise working environments and maintain software to ensure efficient operation.

What you'll be able to do

  • Keep computer hardware and software operating efficiently by performing routine maintenance tasks
  • Manage files and disks to optimise performance, including defragmentation and disk cleanup
  • Troubleshoot and respond to common IT system problems and errors, using appropriate diagnostic tools and techniques
  • Customise the working environment to optimise performance, including configuring settings and preferences
  • Maintain software to meet performance needs, including applying updates and patches
Optimise IT System PerformanceReal unit · Cambridge OCR
It teaches you to optimise IT system performance through effective hardware and software maintenance. You'll manage files, troubleshoot issues, plan routine and non-routine maintenance, and review and modify system configurations to improve performance.

What you'll be able to do

  • Keep computer hardware and software operating efficiently
  • Manage files to maintain and improve IT system performance
  • Troubleshoot and respond to IT system problems quickly and effectively
  • Plan and monitor the routine and non-routine maintenance of hardware and software
  • Review and modify hardware and software to maintain performance
Oracle Academy : Data DesignReal unit · Cambridge OCR
You'll understand the role of database systems within organisations and develop skills to design entity relationship diagrams (ERDs) and create normalised data structures. The unit focuses on effective data design to support organisational functions and optimise data storage.

What you'll be able to do

  • Understand the context of database systems and data design within organisations
  • Design an entity relationship diagram to represent data requirements
  • Create a normalised data structure to optimise data storage and retrieval
Oracle Academy : Database Design and Programming with SQLReal unit · Cambridge OCR
This unit covers the understanding and application of SQL functions, construction of Data Manipulation Language (DML) and Data Definition Language (DDL) statements, creation of data views, and management of database integrity through constraints and validation rules. You'll develop practical skills in using SQL to manage and manipulate databases effectively.

What you'll be able to do

  • Understand the purpose and application of different SQL functions within database management systems.
  • Construct Data Manipulation Language (DML) statements to modify data within a database.
  • Construct Data Definition Language (DDL) statements to define and manage the structure of a database.
  • Construct data views to present data in a specific format or for specific users.
  • Manage database integrity through constraints, validation rules, and transaction management.
Oracle Academy : Database Programming with PL/SQLReal unit · Cambridge OCR
You'll gain comprehensive knowledge of PL/SQL principles and be able to construct PL/SQL code and structures. The unit covers syntax, data types, control structures, and creation of procedures, functions, triggers, and packages for database management.

What you'll be able to do

  • Understand PL/SQL principles, including its syntax, data types, and control structures
  • Construct PL/SQL code to perform various database operations
  • Construct PL/SQL structures such as procedures, functions, triggers, and packages
PRO: Designing and Deploying Messaging Solutions with Microsoft Exchange Server 2010Real unit · Cambridge OCR
It teaches you to design and deploy messaging solutions using Microsoft Exchange Server 2010. You'll plan the Exchange Server infrastructure, deploy server roles and services, design security measures, and implement availability, recovery, compliance, and monitoring solutions.

What you'll be able to do

  • Plan the Exchange Server 2010 infrastructure, considering factors such as server roles, storage requirements, and network topology.
  • Deploy the Exchange Server 2010 infrastructure, including installing and configuring server roles and services.
  • Design and deploy security for the exchange organisation, including access control, authentication, and data encryption.
  • Design and deploy Exchange Server 2010 availability and recovery solutions, including backup and restore procedures and disaster recovery planning.
  • Design and deploy messaging compliance system monitoring, and reporting to meet regulatory requirements and organisational policies.
PRO: Designing and Developing Microsoft SharePoint 2010 ApplicationsReal unit · Cambridge OCR
It teaches you to design and develop Microsoft SharePoint 2010 applications that meet user and business requirements. You'll create application designs, design user experiences, manage development, and optimise SharePoint solutions and features.

What you'll be able to do

  • Create an application design for a Microsoft SharePoint 2010 application, considering user needs and business requirements.
  • Design the user experience (UX) for a Microsoft SharePoint 2010 application to ensure usability and accessibility.
  • Manage the application development process for a Microsoft SharePoint 2010 application, including version control and testing.
  • Optimise the SharePoint application design for performance and scalability.
  • Design SharePoint composite applications by integrating various SharePoint components and features.
  • Design SharePoint solutions and features to meet specific business needs.
PRO: Designing and Developing Web Applications Using Microsoft .NET Framework 4Real unit · Cambridge OCR
You'll design web applications using Microsoft .NET Framework 4, focusing on architecture, user experience, data strategies, security implementation, issue investigation, and deployment strategies to ensure scalable and secure applications.

What you'll be able to do

  • Design the application architecture using the Microsoft .NET Framework 4, considering factors such as scalability, performance, and security.
  • Design the user experience for web applications, focusing on usability, accessibility, and visual appeal.
  • Design data strategies and structures for web applications, including database design, data access methods, and data validation techniques.
  • Design security architecture and implementation for web applications, protecting against common web vulnerabilities and ensuring data confidentiality.
  • Prepare for and investigate application issues in web applications, including debugging, error handling, and performance monitoring.
  • Design a deployment strategy for web applications, including server configuration, deployment procedures, and version control.
PRO: Designing and Developing Windows Applications Using Microsoft .NET Framework 4Real unit · Cambridge OCR
You'll design Windows applications using Microsoft .NET Framework 4, focusing on layered architecture. The unit covers designing presentation and data access layers, planning deployment, and ensuring application stability and maintainability.

What you'll be able to do

  • Design the layers of a solution using the Microsoft .NET Framework 4, adhering to established architectural patterns
  • Design the presentation layer of a Windows application, focusing on user interface design and user experience
  • Design the data access layer of a Windows application, ensuring efficient and secure data access
  • Plan a solution deployment strategy for Windows applications, considering deployment environments and dependencies
  • Design for stability and maintenance of Windows applications, incorporating error handling, logging, and monitoring mechanisms
PRO: Designing and Developing Windows Azure ApplicationsReal unit · Cambridge OCR
You'll design and optimise Windows Azure applications by evaluating data storage options, designing data architectures, and analysing data access methods. The unit includes preparing applications for deployment and designing integrated, scalable, and secure cloud solutions.

What you'll be able to do

  • Design a data storage architecture suitable for Windows Azure applications
  • Optimise data access methods to improve application performance
  • Optimise messaging techniques for efficient communication between application components
  • Design the application architecture, considering scalability, reliability, and security
  • Prepare for application and service deployment on the Windows Azure platform
  • Investigate and analyse existing applications to identify areas for improvement
  • Design integrated solutions that leverage the capabilities of Windows Azure
PRO: Microsoft Lync Server 2010, AdministratorReal unit · Cambridge OCR
You'll learn to design a Microsoft Lync Server 2010 topology, including conferencing and enterprise voice infrastructure. The unit also covers planning for external dependencies, migration, high availability, and business continuity within the Lync environment.

What you'll be able to do

  • Design a topology for Microsoft Lync Server 2010, considering factors such as network infrastructure and user requirements.
  • Design a conferencing and enterprise voice infrastructure for Lync Server 2010, incorporating features such as audio and video conferencing, and voice mail.
  • Plan for external dependencies and migration to Lync Server 2010, including integration with existing systems and data migration strategies.
  • Plan for high availability and business continuity in a Lync Server 2010 environment, implementing redundancy and failover mechanisms.
PRO: Microsoft SharePoint 2010, AdministratorReal unit · Cambridge OCR
You'll learn to design a SharePoint 2010 farm topology considering scalability, performance, and security. The unit also covers planning deployment, defining operations strategies, business continuity, and planning for search and business solutions.

What you'll be able to do

  • Design a SharePoint 2010 farm topology, considering factors such as scalability, performance, and security.
  • Plan a SharePoint 2010 deployment, including hardware and software requirements, installation procedures, and configuration settings.
  • Define a SharePoint 2010 operations strategy and business continuity plan, outlining procedures for monitoring, maintenance, and disaster recovery.
  • Plan for search and business solutions within SharePoint 2010, including configuring search settings and developing custom applications.
Planning and Maintaining a Microsoft Windows Server 2003 Network InfrastructureReal unit · Cambridge OCR
You'll learn to plan and maintain a Microsoft Windows Server 2003 network infrastructure. The unit includes implementing server roles, security measures, network infrastructure components, routing, remote access, and ensuring server availability and network security.

What you'll be able to do

  • Plan and implement server roles within a Microsoft Windows Server 2003 network infrastructure.
  • Plan and implement server security measures to protect the network from threats.
  • Plan, implement, and maintain a network infrastructure using Microsoft Windows Server 2003.
  • Plan, implement, and maintain routing and remote access services within the network.
  • Plan, implement, and maintain server availability to ensure business continuity.
  • Plan and maintain network security protocols and procedures.
  • Plan, implement, and maintain a security infrastructure to protect sensitive data and resources.
Planning, Deploying, and Managing Microsoft Systems Management Server 2003Real unit · Cambridge OCR
This unit covers planning, deploying, and managing Microsoft Systems Management Server 2003. You'll design SMS environments, manage feature packs, configure and maintain systems, and monitor and troubleshoot SMS operations effectively.

What you'll be able to do

  • Design and Plan the Systems Management Server (SMS) Environment
  • Plan and Manage Feature Packs
  • Configure an SMS Environment
  • Manage and Maintain an SMS Environment
  • Monitor and Troubleshoot SMS
Planning, Implementing, and Maintaining a Windows Server 2003 Active Directory InfrastructureReal unit · Cambridge OCR
It teaches you to plan, implement, and maintain a Windows Server 2003 Active Directory Infrastructure. You'll manage users, computers, groups, and Group Policy to ensure a secure and stable Active Directory environment aligned with organisational requirements.

What you'll be able to do

  • Plan and implement an Active Directory Infrastructure, considering organisational requirements.
  • Manage and maintain an Active Directory Infrastructure to ensure its stability and security.
  • Plan and implement user, computer, and group strategies within Active Directory.
  • Plan and implement Group Policy to manage user and computer settings.
  • Manage and maintain Group Policy to ensure consistent application of settings.
Pre-Installing for OEMs Windows Vista and Server operating systemsReal unit · Cambridge OCR
This unit equips learners with skills to prepare, customise, and deploy Windows Vista and Server operating systems using the OEM Pre-Installation Kit. You'll create and modify configuration sets, capture and audit images, and perform image maintenance.

What you'll be able to do

  • Prepare the OEM Pre-Installation Kit (OPK) environment for pre-installing operating systems
  • Create and modify configuration sets to customise the operating system installation
  • Capture and audit images to ensure quality and compliance
  • Deploy and test images to verify functionality and performance
  • Perform image maintenance on existing images to address issues and apply updates
Pro: Designing and Developing ASP.NET Applications Using the Microsoft .NET Framework 3.5Real unit · Cambridge OCR
This unit equips learners with skills to design and develop ASP.NET applications using Microsoft .NET Framework 3.5. You'll focus on control implementation, presentation design, data access, solution structuring, architecture extension, and applying security principles.

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
  • Access data and services within an ASP.NET application
  • Establish a robust ASP.NET solution structure
  • Leverage and extend ASP.NET architecture
  • Apply security principles when designing and developing ASP.NET applications
Quality Management of ICT Products and ServicesReal unit · Cambridge OCR
This unit provides learners with an understanding of organisational quality management procedures and the skills to monitor their implementation. You'll identify deviations from quality standards, report issues, and recommend corrective actions to maintain product and service quality.

What you'll be able to do

  • Understand specified organisational quality management procedures.
  • Monitor quality management procedures effectively.
Remote Support for Products and ServicesReal unit · Cambridge OCR
You'll understand organisational policies and procedures for remote customer support, including legal, ethical, and data protection considerations. The unit develops skills to support products and services remotely while adhering to customer service standards.

What you'll be able to do

  • Understand the organisational requirements for customer care within a remote support context
  • Understand the organisational requirements relating to the products and services being supported remotely
  • Support products or services remotely, adhering to organisational procedures and customer service standards
Security of ICT SystemsReal unit · Cambridge OCR
You'll gain knowledge and skills to maintain ICT system security within an organisation. The unit covers identification of common security threats, application of security measures, and monitoring of security procedures to detect vulnerabilities.

What you'll be able to do

  • Know the common types of security threat to an organisation, its IT system and its data, with relevant methods and procedures for protecting it
  • Apply security measures
  • Monitor security procedures
Security of ICT SystemsReal unit · Cambridge OCR
You'll understand security threats to ICT systems, their operational impact, and methods to combat them. The unit covers maintaining and improving ICT security procedures and implementing security measures to protect against emerging threats.

What you'll be able to do

  • Understand the security threats to an IT system, their operational impact and the methods available to combat them, demonstrating a comprehensive knowledge of cybersecurity principles
  • Maintain and improve ICT security procedures, ensuring they are up-to-date and effectively protect against emerging threats
  • Implement security procedures, ensuring they are consistently applied and effectively mitigate risks
Set Up an IT SystemReal unit · Cambridge OCR
You'll gain the skills to safely select, connect, and configure personal computers and associated hardware, storage media, and communication services. The unit includes software installation and configuration, ensuring the IT system operates securely and meets user needs.

What you'll be able to do

  • Select and connect up a personal computer safely with associated hardware and storage media to meet identified needs
  • Select and connect an IT system to a communication service to meet identified needs, ensuring compatibility and security
  • Install and configure software for use on the IT system, following manufacturer's instructions and best practises
  • Check that the IT system and communication service are working successfully, verifying functionality and connectivity
Set Up an IT SystemReal unit · Cambridge OCR
You'll gain the skills to safely select, connect, and configure a personal computer system with associated hardware, storage media, and communication services. The unit includes installing and configuring operating systems and application software to meet specified needs.

What you'll be able to do

  • Select a personal computer and associated hardware and storage media safely, ensuring they meet specified needs
  • Connect a personal computer safely with associated hardware and storage media to meet specified needs
  • Select an IT system and connect it to a communication service successfully, ensuring it meets specified needs
  • Install an operating system for use on the IT system
  • Configure the operating system for use on the IT system
  • Install application software for use on the IT system
  • Configure application software for use on the IT system
  • Check that the IT system is working successfully
  • Check that the communication service is working successfully
Software installation and upgradeReal unit · Cambridge OCR
This unit covers the software installation and upgrade process, including pre-installation checks, compatibility testing, installation procedures, and rollback methods. You'll develop practical skills to install and upgrade software applications and operating systems.

What you'll be able to do

  • Understand the relevant parts of the software installation and upgrade process, including pre-installation checks, compatibility issues, and rollback procedures.
  • Install or upgrade software applications and operating systems according to specified procedures and best practices.
Software installation and upgradeReal unit · Cambridge OCR
You'll gain knowledge of software installation and upgrade processes, including key steps and potential issues. The unit develops practical skills to carry out and control a wide range of software installations and upgrades effectively and securely.

What you'll be able to do

  • Understand the software installation process
  • Understand the software upgrade process
  • Carry out a wide range of software installations
  • Control a wide range of software installations
  • Carry out a wide range of software upgrades
  • Control a wide range of software upgrades
Supporting Users and Troubleshooting Desktop Applications on a Microsoft Windows XP Operating SystemReal unit · Cambridge OCR
It teaches you to configure, troubleshoot, and resolve issues related to desktop applications on Microsoft Windows XP. It includes managing application settings, usability, customisation, connectivity, and application security.

What you'll be able to do

  • Configure applications on a Microsoft Windows XP operating system
  • Troubleshoot applications on a Microsoft Windows XP operating system
  • Resolve issues related to application usability on a Microsoft Windows XP operating system
  • Resolve issues related to application customisation on a Microsoft Windows XP operating system
  • Configure connectivity for applications on a Microsoft Windows XP operating system
  • Troubleshoot connectivity for applications on a Microsoft Windows XP operating system
  • Configure application security on a Microsoft Windows XP operating system
Supporting Users and Troubleshooting a Microsoft Windows XP Operating SystemReal unit · Cambridge OCR
This unit covers the installation, management, and troubleshooting of the Microsoft Windows XP operating system. You'll learn to install the OS, manage user access and resources, configure hardware devices and drivers, and troubleshoot desktop and user environment issues.

What you'll be able to do

  • Install a Windows Desktop Operating System
  • Manage access to resources on a Windows Desktop Operating System
  • Troubleshoot access to resources on a Windows Desktop Operating System
  • Configure hardware devices and drivers on a Windows Desktop Operating System
  • Troubleshoot hardware devices and drivers on a Windows Desktop Operating System
  • Configure the desktop environment on a Windows Desktop Operating System
  • Configure the user environment on a Windows Desktop Operating System
  • Troubleshoot the desktop environment on a Windows Desktop Operating System
  • Troubleshoot the user environment on a Windows Desktop Operating System
Supporting and Troubleshooting Applications on a Windows Vista Client for Consumer Support TechniciansReal unit · Cambridge OCR
You'll gain skills to install, upgrade, customise, and configure Windows Vista, including security and networking settings. The unit also covers device installation, troubleshooting, and repair to support Windows Vista client applications.

What you'll be able to do

  • Install Windows Vista
  • Upgrade Windows Vista
  • Customise Windows Vista settings post-installation
  • Configure Windows Vista settings post-installation
  • Configure Windows Vista security
  • Configure networking on Windows Vista
  • Troubleshoot networking on Windows Vista
  • Repair networking on Windows Vista
  • Install devices on Windows Vista
  • Configure devices on Windows Vista
  • Troubleshoot devices on Windows Vista
  • Repair devices on Windows Vista
  • Troubleshoot Windows Vista
  • Repair Windows Vista
Supporting and Troubleshooting Applications on a Windows Vista Client for Enterprise Support TechniciansReal unit · Cambridge OCR
It teaches you to deploy, manage, maintain, and troubleshoot Windows Vista clients in an enterprise environment. You'll configure security settings, networking, and support desktop applications to ensure optimal system performance and compliance with organisational policies.

What you'll be able to do

  • Deploy Windows Vista on a client machine
  • Manage Windows Vista security settings
  • Maintain systems that run Windows Vista
  • Configure networking on a Windows Vista client
  • Troubleshoot networking issues on a Windows Vista client
  • Support desktop applications running on Windows Vista
  • Maintain desktop applications running on Windows Vista
System ManagementReal unit · Cambridge OCR
You'll develop knowledge and skills to administer computer systems, including user account management, data backup and restoration, and system performance and security monitoring, following organisational policies and procedures.

What you'll be able to do

  • Understand the procedures involved in administering a system within an organisation.
  • Administer a system according to organisational policies and procedures.
  • Change system configurations in accordance with authorised requests and documented procedures.
System ManagementReal unit · Cambridge OCR
It teaches you to assist in system administration by understanding roles and responsibilities and following organisational policies. You'll implement configuration changes, document procedures, and test system modifications to maintain effective system management.

What you'll be able to do

  • Assist in administering a system
  • Change system configurations
System OperationReal unit · Cambridge OCR
This unit provides learners with knowledge and skills to operate systems following established procedures. You'll identify system components, operate systems efficiently, and maintain operating procedures to ensure performance and security.

What you'll be able to do

  • Operate the system in accordance with established procedures.
  • Operate systems effectively and efficiently.
  • Maintain and implement system operating procedures to ensure optimal performance and security.
TS: Accessing Data with Microsoft .NET Framework 4Real unit · Cambridge OCR
You'll learn to model, query, and manipulate data within applications using Microsoft .NET Framework 4. The unit covers managing database connections, applying data modelling techniques, and developing reliable data-driven applications for deployment.

What you'll be able to do

  • Model data effectively using appropriate data modelling techniques
  • Manage connections and context for data access operations
  • Query data using appropriate query languages and techniques
  • Manipulate data within a .NET Framework 4 application
  • Develop and deploy reliable applications that access data
TS: Microsoft Exchange Server 2010, ConfiguringReal unit · Cambridge OCR
You'll learn to install, configure, and manage Microsoft Exchange Server 2010. The unit includes configuring recipients, public folders, client access, monitoring performance, implementing high availability, and managing message compliance and security.

What you'll be able to do

  • Install and configure Exchange servers according to organisational requirements
  • Configure Exchange recipients and public folders to facilitate communication and collaboration
  • Configure Client Access to Exchange Server 2010 for various client devices
  • Monitor and report on the performance and health of the Exchange Server 2010 environment
  • Implement high availability and recovery solutions for Exchange Server 2010 to ensure business continuity
  • Configure message compliance and security settings within Exchange Server 2010 to meet regulatory requirements
TS: Microsoft Lync Server 2010, ConfiguringReal unit · Cambridge OCR
This unit equips learners with skills to configure and manage Microsoft Lync Server 2010 environments. You'll manage users and client access, configure server topology and enterprise voice, enable external access, and monitor and maintain the deployment.

What you'll be able to do

  • Manage users and client access within a Microsoft Lync Server 2010 environment
  • Configure a Microsoft Lync Server 2010 topology to meet specific requirements
  • Configure enterprise voice features within Microsoft Lync Server 2010
  • Configure Microsoft Lync Server 2010 to enable external access for users
  • Monitor and maintain a Microsoft Lync Server 2010 deployment to ensure optimal performance and availability
TS: Microsoft SharePoint 2010, Application DevelopmentReal unit · Cambridge OCR
It develops skills to create applications within Microsoft SharePoint 2010. You'll navigate and customise SharePoint sites, develop web parts and controls, implement business logic, manage data, and deploy SharePoint components.

What you'll be able to do

  • Work with the SharePoint user interface to navigate, manage, and customise SharePoint sites and content
  • Develop web parts and controls to extend the functionality and appearance of SharePoint sites
  • Develop business logic to automate processes and integrate SharePoint with other systems
  • Work with SharePoint data, including lists, libraries, and metadata, to store and manage information effectively
  • Stabilise and deploy SharePoint components, ensuring they are properly tested and installed in the production environment
TS: Microsoft SharePoint 2010, ConfiguringReal unit · Cambridge OCR
You'll learn to install, configure, and manage a Microsoft SharePoint 2010 environment. The unit includes managing user accounts, site collections, service applications, application deployment, and maintaining the SharePoint environment.

What you'll be able to do

  • Install and configure a SharePoint 2010 environment
  • Manage a SharePoint 2010 environment effectively
  • Deploy and manage applications within a SharePoint 2010 environment
  • Maintain a SharePoint 2010 environment
TS: Silverlight 4, DevelopmentReal unit · Cambridge OCR
You'll gain skills to develop Silverlight 4 applications, focusing on user interface layout and enhancement, application logic implementation, data handling, host platform interaction, application structuring, and deployment for maintainability and performance.

What you'll be able to do

  • Lay out a user interface using appropriate tools and techniques
  • Enhance the user interface to improve user experience and functionality
  • Implement application logic to ensure the application functions correctly
  • Work with data to store, retrieve, and manipulate information within the application
  • Interact with a host platform to enable communication and integration with other systems
  • Structure applications to promote maintainability, scalability, and reusability
  • Deploy applications to make them available to users
TS: Web Applications Development with Microsoft .NET Framework 4Real unit · Cambridge OCR
It teaches you to develop dynamic web applications using Microsoft .NET Framework 4. You'll construct web forms pages, implement client-side scripting and AJAX, manage data display and manipulation, configure applications, and develop using ASP.NET MVC 2.

What you'll be able to do

  • Develop web forms pages using appropriate techniques and tools
  • Develop and use web forms controls to enhance user interaction and functionality
  • Implement client-side scripting and AJAX to improve web application responsiveness
  • Configure and extend a web application to meet specific requirements
  • Display and manipulate data effectively within a web application
  • Develop a web application by using ASP.NET MVC 2 framework
TS: Windows Applications Development with Microsoft .NET Framework 4Real unit · Cambridge OCR
This unit covers the development of Windows applications using Microsoft .NET Framework 4. You'll build and enhance user interfaces with basic and advanced techniques, manage data at the interface layer, improve functionality and usability, and stabilise and release solutions.

What you'll be able to do

  • Build a user interface by using basic techniques
  • Enhance a user interface by using advanced techniques
  • Manage data at the user interface layer
  • Enhance the functionality and usability of a solution
  • Stabilise and release a solution
TS: Windows Communication Foundation Development with Microsoft .NET Framework 4Real unit · Cambridge OCR
This unit covers the creation, hosting, consumption, and securing of services using Windows Communication Foundation (WCF) with Microsoft .NET Framework 4. You'll learn to manage service instance lifecycles and monitor and troubleshoot distributed systems effectively.

What you'll be able to do

  • Create services using appropriate methods
  • Host and configure services effectively
  • Consume services correctly
  • Secure services appropriately
  • Manage the service instance life cycle effectively
  • Monitor and troubleshoot distributed systems efficiently
TS: Windows Server 2008 R2, Desktop VirtualizationReal unit · Cambridge OCR
This unit provides knowledge and skills to deploy and manage enterprise desktop virtualisation, presentation virtualisation, application virtualisation (App-V), and virtual desktop infrastructure environments. You'll address deployment requirements and manage virtualisation issues.

What you'll be able to do

  • Deploy an Enterprise desktop virtualisation environment
  • Manage an Enterprise desktop virtualisation environment
  • Deploy a presentation virtualisation environment
  • Manage a presentation virtualisation environment
  • Deploy an application virtualization (App-V) environment
  • Manage an application virtualization (App-V) environment
  • Manage a virtual desktop infrastructure environment
TS: Windows Server 2008 R2, Server VirtualizationReal unit · Cambridge OCR
You'll gain knowledge and skills to install, configure, and manage server virtualisation using Windows Server 2008 R2. The unit includes configuring host and child settings, managing virtual environments, ensuring high availability, and performing migrations within virtualised systems.

What you'll be able to do

  • Install and configure host and parent settings for server virtualisation, ensuring optimal performance and resource allocation
  • Configure child settings for virtual machines, tailoring them to specific application requirements
  • Manage and monitor virtual environments, proactively addressing performance issues and ensuring system stability
  • Ensure high availability and recoverability of virtualised systems, implementing appropriate backup and disaster recovery strategies
  • Perform migration of virtual machines between hosts, minimising downtime and ensuring data integrity
  • Configure remote desktop (RD) role services infrastructure, enabling secure remote access to virtualised resources
Technical advice and guidanceReal unit · Cambridge OCR
This unit provides learners with the knowledge and skills to provide technical advice and guidance effectively. You'll learn to access technical information, communicate clearly, and apply customer service principles to respond to and resolve customer technical issues.

What you'll be able to do

  • Provide technical advice and guidance to customers
  • Provide reactive technical advice and guidance to customers on a range of topics, addressing their specific needs and issues
Technical advice and guidanceReal unit · Cambridge OCR
It teaches you to provide effective technical advice and guidance by understanding the context, legal and ethical considerations, and confidentiality. You'll learn to deliver both reactive and proactive technical support tailored to customer needs.

What you'll be able to do

  • Understand the context for providing technical advice and guidance in a professional setting
  • Provide reactive technical advice and guidance to customers on a range of technical topics
  • Provide proactive technical advice and guidance to customers to improve their understanding and use of technology
Technical fault diagnosisReal unit · Cambridge OCR
This unit provides learners with knowledge and skills to diagnose technical faults systematically. You'll use diagnostic tools, gather accurate information, select remedies for non-routine faults, and maintain diagnosis and remedy records.

What you'll be able to do

  • Understand the processes, methods and information that are used in the diagnostic process
  • Diagnose faults with a wide range of causes
  • Select remedies for non-routine faults
  • Maintain diagnosis and remedy records
Technical fault diagnosisReal unit · Cambridge OCR
You'll understand the technical fault diagnosis process, including methods for gathering accurate information. The unit covers applying systematic diagnostic techniques to identify faults, selecting appropriate remedies, and maintaining detailed records of diagnosis and repairs.

What you'll be able to do

  • Know the processes, methods and information that are used in the diagnostic process for technical faults
  • Apply processes to diagnose faults with a known range of causes and assist in the diagnosis of other faults
  • Select appropriate fault remedies from given alternatives based on the diagnosis
  • Maintain accurate diagnosis and remedy records for future reference
Testing ICT SystemsReal unit · Cambridge OCR
This unit introduces learners to ICT product functions, testing procedures, and associated activities. You'll identify testing equipment, understand its use, carry out routine testing, and assist in other testing tasks while accurately recording and reporting results.

What you'll be able to do

  • Know technical information about a range of ICT products, testing procedures and associated activities.
  • Know what equipment is to be used for testing and the reasons for each test.
  • Carry out routine testing of ICT systems.
  • Assist in other testing activities related to ICT systems.
Testing ICT SystemsReal unit · Cambridge OCR
You'll gain technical knowledge and practical skills to test ICT systems. The unit covers understanding product specifications, testing procedures, equipment selection, and conducting tests to support system functionality and compatibility.

What you'll be able to do

  • Know technical information about a wide range of ICT products relevant to testing.
  • Understand testing procedures and associated activities within ICT systems.
  • Identify the equipment to be used for testing and justify its selection.
  • Explain the reasons for conducting specific tests on ICT systems.
  • Carry out testing of ICT systems according to established procedures.
  • Support others in the testing process by providing guidance and assistance.
Transition Your MCITP SQL Server 2005 BI Developer to MCITP SQL Server 2008 BI DeveloperReal unit · Cambridge OCR
You'll transition skills from MCITP SQL Server 2005 to 2008 BI Developer roles. The unit covers implementing SSIS and SSAS solutions, designing BI architectures, deploying and maintaining integration and analysis services, and troubleshooting common issues.

What you'll be able to do

  • Implement an SQL Server Integration Services (SSIS) solution according to specified requirements
  • Design the business intelligence (BI) architecture to meet organisational needs
  • Design and deploy SSIS packages in line with best practise
  • Design an Analysis Services database that fulfils business requirements
  • Configure, deploy, and maintain SSIS to ensure optimal performance
  • Implement an SQL Server Analysis Services (SSAS) solution that meets specified requirements
  • Configure, deploy, and maintain SSAS to ensure optimal performance
  • Implement an SQL Server Reporting Services (SSRS) solution that meets specified requirements
  • Configure, deploy, and maintain SSRS to ensure optimal performance
  • Design and manage reports to effectively present data
  • Design data mining models to extract valuable insights
  • Administer a business intelligence (BI) solution to ensure its smooth operation
Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008Real unit · Cambridge OCR
This unit prepares learners to transition from MCITP SQL Server 2005 DBA to MCITP SQL Server 2008 by covering installation, configuration, security design, high availability, backup and recovery, monitoring, maintenance, data distribution, and troubleshooting strategies.

What you'll be able to do

  • Install and configure SQL Server 2008
  • Design a database server security solution
  • Design a database solution for high availability
  • Design a backup and recovery solution
  • Design a monitoring strategy
  • Design a strategy to maintain and manage databases
  • Design a strategy for data distribution
  • Maintain SQL Server instances
  • Manage SQL Server security
  • Maintain a SQL Server database
  • Perform data management tasks
  • Monitor and troubleshoot SQL Server
  • Optimise SQL Server performance
  • Implement high availability
  • Design a SQL Server instance and a database solution
Transition Your MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBDReal unit · Cambridge OCR
You'll transition from MCITP SQL Server 2005 DBD to MCITP SQL Server 2008 DBD by implementing tables and views, designing programming objects, and developing strategies for transactions, concurrency, XML handling, query performance, and database optimisation.

What you'll be able to do

  • Implement tables and views
  • Design programming objects
  • Design a transaction and concurrency strategy
  • Design an XML strategy
  • Design queries for performance
  • Design a database for optimal performance
  • Implement programming objects
  • Work with query fundamentals
  • Apply additional query techniques
  • Work with additional SQL Server components
  • Work with XML data
  • Gather performance information
  • Design a database strategy
  • Design database tables

Showing 200 of 222 units in this qualification.

The honest bit

You’ve started things before

Most courses were built for a room full of people who aren’t you. A cohort moves on whether or not your week allowed it, and by the third week the thing you’re behind on becomes the reason you stop opening it.

There’s no cohort here, and no timetable to fall behind. Before anything starts, Zavmo asks when you’re sharpest and how long you can realistically sit down for, then builds the sessions around those answers. A bad fortnight changes your pace. It doesn’t put you behind.

And you only pay once you start learning. Searching and planning are free, and you can cancel any time — so the cost of finding out is an afternoon, not a year.

Your passport

Every credit is a stamp you keep

Level 3 credits are regulated. They don’t vanish when a subscription ends or a website closes. They travel to any employer, and Zavmo keeps the map of what you’ve earned and what’s next.

Business Intelligence Development and Maintenance using Microsoft SQL Server 2008Cisco CCNP RouteCisco CCNP SwitchCisco CCNP TroubleshootingCisco Discovery Designing and Supporting Computer NetworksCisco Discovery Introducing Routing and Switching in the EnterpriseCisco Discovery Networking for Home and Small BusinessCisco Discovery Working at a Small-to-Medium Business or ISP

Each stamp is a real unit registered against this qualification.

Who’d teach you this

The Evidence Evaluator

Assessor

Helps you show what you can actually do, gathering the evidence that proves it as you learn.

Meet all twelve tutors

Where this connects

Where these credits take you

A qualification is never a dead end here. See the jobs its credits open, the national occupational standards its units map to, and the future skills they quietly build.

Where this can lead

Associate Oracle Database Engineer

Your journey starts here, but where it goes is really up to you. We'll give you the tools, the training, and the opportunities, but your drive to learn and grow will be the biggest factor in your long-term success. This isn't just a job; it's the start of a serious career in a critical technical domain.

See the whole journey →

Showing 6 roles, drawn from 53 job records mapped to this qualification.

How you’ll actually learn this

One-to-one, on your own real work

A qualification is usually something done to you: sit the class, sit the exam, hope it sticks. Here it’s the opposite. You learn it one-to-one with a companion, on your own real work, and you keep going until you can use it, not just recall it.

One-to-one, on your real workNo lectures, no past-papers. Every unit is practised on the actual tasks your job throws at you, a tutor beside you, not a video in front of you.
Taught to the top, not the testMost courses stop at remembering. Your companion keeps climbing: analysing, judging, creating. That’s the part a machine can’t do for you.
Credits you keep, a map that continuesEvery unit is regulated and yours for good. The day you finish, Zavmo already knows the next role your new credits open.
Business Intelligence Development and Maintenance using Microsoft SQL Server 2008Level 3

Applied to your work in any of these jobs

This unit provides learners with skills to implement, configure, deploy, and maintain Business Intelligence solutions using Microsoft SQL Server 2008. Focus is on SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS) for data processing and analysis.

How the thinking builds
  1. Remember
  2. Understand
  3. Apply
  4. Analyse
  5. Evaluate
  6. Create
An illustration of a Zavmo lesson, built from this role’s own route. The unit, its objective and every criterion above are the awarding body’s own words, not an example.
Your PlanIllustration

Built for OCR Level 3 Diploma in ICT Professional Competence (PROCOM) (QCF)

182 units in this credential, in the order it lists them, awarded by Cambridge OCR.

  1. Business Intelligence Development and Maintenance using Microsoft SQL Server 2008
  2. Cisco CCNP Route
  3. Cisco CCNP Switch
  4. Cisco CCNP Troubleshooting
  5. Cisco Discovery Designing and Supporting Computer Networks
  6. Cisco Discovery Introducing Routing and Switching in the Enterprise

and 176 more in the full unit list below.

These are the real units of this credential, in its own order. Nothing here is marked done, because this plan has not been started by anyone yet. Yours would fill in as you go.

One to one, not one to many

No two people run this the same way

A course is written once and handed to everyone. This is assembled around you, and keeps changing as it learns you. Five things it reads, and what each one changes.

  1. Your actual work Every unit is taught against a live piece of your own work, not a worked example from a textbook.
  2. What you already know The first conversation finds your starting point, so you skip what you can already do and spend the time on what you cannot.
  3. The conditions you learn under Not a learning-styles quiz. The evidence does not support those. The dimensions the research does back, read once and used to shape the plan.
  4. How far you got last time It picks up mid-thought. The tutor knows what you said, what you struggled with, and what it asked you to try.
  5. Which tutor suits the moment Twelve of them, each for a different kind of thinking. The one who walks you through a first idea is not the one who stress-tests it.

See how you learn, free. Eight questions, no sign-up. A directional taster; the diagnostic inside Zavmo goes deeper and keeps adapting.

Why it sticks

Most courses stop at remembering

There’s a well-known ladder of how deeply you learn something, called Bloom’s Taxonomy. Most courses get you up the first two rungs: you remember some facts, you pass a test, you forget it. Real skill lives at the top. Judging, deciding, creating. And this isn’t a generic ladder: every rung has a named Zavmo tutor who walks you up it.

  1. 6CreateThe Creative Catalyst
  2. 5EvaluateThe Evidence Evaluator
  3. 4AnalyseThe Analyst
  4. 3ApplyThe Coach
  5. 2UnderstandThe Connector
  6. 1RememberThe Builder

Where most courses leave you Where Zavmo takes you

Why this matters: AI can already remember and understand for you. What it can’t do is take your real problem and judge the right call. So the only learning worth paying for is the learning that takes you to the top. That’s exactly what a tutor doing it with you, on your real work, is for.

The value

Why the companion is worth £70 a month

You’re not paying for the units. They’re regulated, and the same wherever you earn them. You’re paying for the one thing that decides whether you actually get there: a companion that makes them stick, on your real work.

That is one-to-one on this qualification, every day, on the work you already do, for £70 a month. Your first module is free, so you can see the teaching before you pay for any of it. Billed monthly, cancel any time and billing stops.

Earned on your own work, taught to the top.

Everything you just read, learned one-to-one on the job you already do. Your first module is free, so you can see the teaching before you pay for any of it.

Build my plan, free

No card. See how this qualification maps onto your role and meet the tutors who’d teach it, free. The learning begins when you subscribe. It’s £70 a month, billed monthly. Cancel any time and billing stops.