OCNLR Level 2 Certificate in Digital Skills

What you'll be able to do

• Use coding or macro(s) to automate multiple actions within a word processing program.
• Use formulae and/or functions to automate calculations/tasks within a spreadsheet program.
• Use coding and/or macros to automate multiple actions within a spreadsheet program.

What you'll be able to do

• Prepare collaborative technologies for use in accordance with organisational procedures.
• Set up collaborative technologies to meet the needs of the task.
• Use collaborative technology safely, adhering to security protocols.
• Initiate tasks using collaborative technologies, clearly defining objectives and expected outcomes.
• Contribute effectively to tasks using collaborative technologies, sharing information and ideas constructively.
• Value contributions from others in tasks using collaborative technologies, demonstrating respect and consideration for diverse perspectives.

What you'll be able to do

• Understand key computational thinking concepts, including decomposition, pattern recognition, abstraction, and algorithms

What you'll be able to do

• Understand the principles of networking computers, including network topologies, protocols, and addressing schemes.
• Understand the associated benefits and disadvantages of networking computers, considering factors such as resource sharing, security risks, and cost.
• Use networking devices, such as routers, switches, and hubs, to connect computers and create a network.
• Use networking software, such as operating system network settings and network management tools, to configure and manage a network.
• Understand security features and requirements for computer networks, including firewalls, passwords, and access controls.

What you'll be able to do

• Design a digital publication that incorporates audio and video content, such as an electronic document, web page, blog, social media page, and online survey
• Input audio and video material elements within a rich media publication design
• Format and produce a rich media digital publication

What you'll be able to do

• Design a digital publication that effectively incorporates text and images to achieve a specific purpose.
• Input text accurately and efficiently into a digital publication.
• Combine text with other digital media, such as images, within a publication design, ensuring visual coherence.
• Edit text and images within a digital publication to improve clarity, accuracy, and impact.
• Format a digital publication to enhance readability and visual appeal, using appropriate styles and layouts.
• Produce a digital publication to a professional standard, ready for distribution or publication.

What you'll be able to do

• Safeguard self and others when working online by identifying and mitigating potential risks
• Take precautions to maintain data security by implementing appropriate measures to protect personal and sensitive information
• Follow legal and organisational constraints, guidelines and procedures which apply when working online, demonstrating an understanding of relevant regulations and policies

What you'll be able to do

• Use HTML and CSS for web design.
• Use CSS selectors.
• Incorporate styling into a web page.
• Use current HTML and CSS standards to create simple layouts.

What you'll be able to do

• Understand the operation of a PC system, including its key components and their functions.
• Upgrade PC hardware components, following recognised procedures and safety guidelines.
• Troubleshoot common hardware faults in a PC system, using appropriate diagnostic tools and techniques.
• Assemble a fully functional PC system from individual components, ensuring compatibility and correct installation.
• Install software applications on a PC, configuring them for optimal performance and security.
• Use system tools and utilities to monitor, maintain, and optimise the performance of a PC system.

What you'll be able to do

• Plan the use of digital software to improve productivity
• Use digital systems efficiently to complete planned tasks
• Use digital software efficiently to complete planned tasks
• Review the selection and use of digital tools to make improvements in productivity

What you'll be able to do

• Design a mobile app, considering user needs and functionality.
• Create and trial a mobile app, using appropriate development tools and techniques.
• Review and improve a mobile app based on testing and feedback.

What you'll be able to do

• Use the different data types provided by the programming language, including integers, floating-point numbers, strings, and Booleans.
• Use assignment statements to calculate results from expressions using basic mathematical functions, such as addition, subtraction, multiplication, and division.
• Use selection commands, such as if-then-else statements, to control the flow of execution based on conditions.
• Use loops, such as for loops and while loops, to repeat a block of code multiple times.
• Use subroutines to organise code into reusable modules.
• Use functions to perform specific tasks and return values.
• Use arrays to store and manipulate collections of data.
• Use logical operators AND, OR and NOT to combine and negate conditions.
• Read from and write to data files to persist data between program executions.
• Debug a program to identify and fix errors.

What you'll be able to do

• Interrogate a database using Structured Query Language (SQL) statements to retrieve records from a single table, using SELECT, FROM, and WHERE clauses
• Use SQL join statements to combine data from multiple tables, including INNER JOIN, LEFT JOIN, and RIGHT JOIN
• Sort records using ORDER BY, group records using GROUP BY, and summarise records using aggregate functions such as COUNT, SUM, AVG, MIN, and MAX in SQL Statements
• Create and use a parameter query to allow users to input values to filter data
• Manipulate tables using SQL, including INSERT, UPDATE, and DELETE statements

What you'll be able to do

• Design a visual application, considering user interface, functionality, and user experience
• Create visual applications using appropriate visual programming tools and techniques
• Test a visual program to ensure it functions correctly and meets the design specifications