OCNLR Level 2 Extended Certificate in Skills for Professions in Digital Industries and Technology

What you'll be able to do

• Use a variety of modelling tools to build 3D objects
• Use a variety of modelling tools to build 3D characters
• Define surface textures for 3D objects
• Apply surface textures to 3D objects
• Use lighting techniques to enhance 3D scenes

What you'll be able to do

• Understand the use of algebraic expressions to accurately describe a given situation or problem.
• Understand and recognise different types of number patterns and their underlying rules.
• Understand and manipulate algebraic expressions effectively, including simplification and expansion.
• Use algebraic methods to solve linear equations accurately and efficiently.
• Use and apply Cartesian co-ordinates to represent and analyse data graphically.

What you'll be able to do

• Know the different methods used to apply for jobs
• Know the information required when applying for jobs
• Prepare a job application, ensuring all required information is included
• Present a job application in a professional manner

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

• Investigate a range of career options within a chosen field
• Assess the suitability of different career options based on personal skills and interests
• Plan specific steps to achieve a career-related goal
• Know about different routes for career progression within a chosen field

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

• Plan a digital game according to a specific brief.
• Design the game and create a test plan to ensure functionality.
• Create games from established designs, incorporating game mechanics and assets.
• Understand how to review the completed game against the original brief to ensure objectives are met.
• Log and record project data throughout the game development process.

What you'll be able to do

• Create bitmap and vectored images using appropriate software.
• Edit bitmap and vectored images to meet specific requirements.
• Edit text within a graphic design project.
• Save and open image files in various formats.
• Print an image with appropriate settings for desired output.

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

• Explore the purpose and methods of recording digital sound for various applications.
• Plan a digital sound sequence to meet a specific brief, considering factors such as duration, style, and target audience.
• Create, save, and test the digital sound sequence using appropriate software and equipment.
• Understand how to review the digital sound outcome against the original brief, identifying strengths and weaknesses.

What you'll be able to do

• Investigate the world of digital video, exploring different genres, techniques, and technologies.
• Plan the pre-production and the original video to a specific brief, considering factors such as script, storyboard, and location.
• Record and test the video footage, using appropriate equipment and techniques.
• Understand how to review the video against the original brief, identifying strengths and weaknesses and suggesting improvements.

What you'll be able to do

• Use appropriate structures and styles when creating websites
• Use website software tools effectively to prepare content for websites
• Publish websites using appropriate methods and technologies

What you'll be able to do

• Understand the nature and importance of critical thinking, recognising its role in effective decision-making and problem-solving.
• Understand key terms relating to critical thinking, such as logic, reasoning, and evidence.
• Understand the nature of assumption, bias and stereotyping in argument and point of view, recognising how these can distort reasoning.
• Understand how structure and style impact on argument, recognising how these can strengthen or weaken a case.
• Form an argument, presenting a clear and logical case with supporting evidence.
• Question an argument or point of view, identifying weaknesses and inconsistencies in reasoning.

What you'll be able to do

• Understand basic cyber security concepts and terminology.
• Understand different types of cyber security threats and vulnerabilities that can affect systems and data.
• Understand how to minimise the potential impact of cyber security attacks through preventative measures and response strategies.

What you'll be able to do

• Implement a database system, including designing tables, defining relationships, and setting up data validation rules
• Manipulate information in the database, including adding, updating, deleting, and querying data
• Test a database system to ensure data integrity, security, and performance

What you'll be able to do

• Create a detailed character sheet, including visual references and personality traits, for an animated character
• Make line tests and animatics to plan and refine the movement and timing of an animation
• Work from a storyboard to create a digital animation, following the planned sequence of events
• Review the final animation, identifying areas for improvement and assessing its overall effectiveness

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

• Understand the importance of effective communication in the workplace, considering its impact on productivity and team dynamics.
• Know how different types of communication, such as verbal, non-verbal, and written, are appropriate for different situations and audiences.
• Use appropriate forms of written communication, including emails, reports, and memos, ensuring clarity, accuracy, and professionalism.
• Use appropriate forms of oral communication, including presentations, meetings, and phone calls, adapting style and tone to suit the context.

What you'll be able to do

• Know about behaviours that contribute to effectiveness at work
• Demonstrate effective working practices in a given task or activity
• Evaluate own performance and identify areas for improvement
• Identify ways to improve own practice based on evaluation

What you'll be able to do

• Understand the fundamental concepts of emerging technologies, including their potential applications and limitations
• Understand the core principles of the Internet of Things (IoT), including its architecture, components, and communication protocols
• Analyse the impact of emerging technologies and IoT on various industries and sectors
• Evaluate the security and privacy implications of emerging technologies and IoT devices
• Investigate the ethical considerations surrounding the development and deployment of emerging technologies and IoT solutions
• Explore the potential future trends and developments in emerging technologies and IoT

What you'll be able to do

• Recognise and organise grouped data effectively.
• Construct and interpret histograms accurately.
• Construct and interpret frequency polygons accurately.
• Calculate averages for grouped data using appropriate methods.
• Construct a cumulative frequency table and graph correctly.
• Extract and use information from a cumulative frequency graph to solve problems.
• Compare different sets of data using appropriate statistical measures.
• Calculate the probabilities of combined events accurately.
• Interpret the meaning of probabilities of combined events in context.

What you'll be able to do

• Generate a viable business idea
• Assess the potential of a business idea
• Take a business idea forward

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

• Understand roles and responsibilities for health, safety and welfare in the workplace.
• Understand how risk assessments contribute to health and safety in the workplace.
• Understand how to identify and control the risks from common workplace hazards.
• Know the procedures for responding to accidents and incidents in the workplace.

What you'll be able to do

• Understand the role and the essential knowledge base required of an IT Technical Salesperson in a business context.
• Create and effectively manage sales opportunities within the IT sector.
• Communicate effectively with clients and colleagues within an IT Technical Salesperson role.

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

• Understand different learning styles and methods.
• Relate different learning styles and methods to own learning preferences.
• Use own strengths, aptitudes and skills to identify realistic learning targets.
• Make informed decisions about how to achieve learning targets effectively.
• Review own performance against learning targets and identify areas for improvement.

What you'll be able to do

• Investigate a range of interactive multimedia technologies and products, considering their features and applications
• Plan an interactive multimedia product that meets the requirements of a specific brief, including identifying target audience and purpose
• Create the interactive multimedia product according to the plan, ensuring appropriate functionality and user experience
• Save the interactive multimedia product in a suitable format for testing and distribution
• Test the interactive multimedia product to identify and resolve any errors or issues
• Review the completed interactive multimedia product against the original brief to ensure all requirements have been met and evaluate its overall effectiveness

What you'll be able to do

• Understand the principles of internet broadcasting.
• Plan for internet broadcasting.
• Produce an internet broadcast.

What you'll be able to do

• Present oneself effectively for an interview situation
• Demonstrate appropriate behaviour and communication skills during an interview
• Actively take part in an interview, responding to questions and providing relevant information
• Review own performance in an interview to identify strengths and weaknesses
• Improve own performance in future interviews

What you'll be able to do

• Understand the use of Big Data in business, including its applications in areas such as marketing, finance, and operations.
• Understand how meaningful information is derived from Big Data, including data mining, statistical analysis, and visualisation techniques.
• Carry out basic analysis of Big Data, using appropriate tools and techniques to identify trends, patterns, and insights.

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

• Know about the key aspects of self-employment in a given sector
• Recognise the characteristics of successful self-employed people
• Understand how to manage income and expenditure as a self-employed person
• Know the legal and ethical responsibilities of a self-employed person
• Know about the key steps involved in planning for self-employment
• Understand the types of support available to people considering self-employment, including financial, mentoring, and training opportunities

What you'll be able to do

• Reflect on what was learnt during a work placement experience
• Assess own performance during a work placement, identifying areas of strength and areas for development
• Use learning from a work placement to set realistic and achievable career-related goals
• Identify how the work placement has influenced career aspirations

What you'll be able to do

• Speak to an audience in a clear, concise, and engaging manner
• Listen with understanding, demonstrating active listening skills and empathy
• Respond to questions effectively, providing relevant and informative answers
• Engage in discussion, contributing constructively and respectfully to the conversation
• Understand the strengths and weaknesses of own oral presentation skills, identifying areas for improvement

What you'll be able to do

• Understand the key skills involved in preparing effective presentations
• Understand the key skills involved in delivering engaging presentations
• Use different visual aids effectively to enhance presentations
• Use different delivery styles to suit the audience and purpose of the presentation
• Plan a presentation, considering the audience, purpose, and key messages
• Deliver a presentation confidently and effectively
• Assess own performance after delivering a presentation
• Identify areas for improvement in future presentations

What you'll be able to do

• Know about the company or organisation where work placement is planned, demonstrating an understanding of its structure, operations, and culture.
• Know about a work placement, including its purpose, benefits, and potential challenges.
• Know what the company or organisation expects of the learner during work placement, including responsibilities, conduct, and performance standards.
• Set targets relating to work placement, ensuring they are specific, measurable, achievable, relevant, and time-bound (SMART).

What you'll be able to do

• Collate information required in preparing for an interview, ensuring all relevant details are gathered and organised effectively.
• Understand the information required in preparing for an interview, demonstrating a clear grasp of the necessary background and context.
• Prepare questions to ask an interviewer, ensuring they are relevant, insightful, and demonstrate engagement.
• Prepare answers to interview questions, demonstrating a clear understanding of the questions and providing concise and relevant responses.

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

• Understand the purpose of a range of texts, including informational, persuasive, and narrative texts, and their intended audience.
• Read critically to evaluate information and ideas presented in texts, identifying bias, assumptions, and logical fallacies.
• Use reading strategies, such as skimming, scanning, and close reading, depending on the purpose of the reading task.
• Use organisational features and systems, such as headings, subheadings, indexes, and tables of contents, to locate texts and information efficiently.
• Understand vocabulary associated with different types of text, including technical, academic, and everyday language.

What you'll be able to do

• Understand different types of research methods and their uses, including qualitative and quantitative methods.
• Plan a piece of research, including formulating a research question, selecting appropriate methods, and developing a research proposal.
• Report on a piece of research, including presenting findings in a clear and concise manner.
• Evaluate a piece of research, including assessing the validity and reliability of the findings.

What you'll be able to do

• Understand the purposes of academic examinations, including assessing knowledge, skills, and understanding of a subject.
• Establish a study environment that is conducive to learning, free from distractions, and well-organised.
• Plan own revision schedule, allocating sufficient time to each subject and topic, and prioritising areas of weakness.
• Use revision techniques, such as mind mapping, flashcards, and practice questions, to consolidate learning and improve recall.
• Maintain personal health and well-being when undertaking academic revision and examination, including getting enough sleep, eating healthily, and managing stress.
• Use exam techniques, such as time management, question selection, and effective answering strategies, to maximise performance.
• Review own revision and exam skills, identifying areas for improvement and developing strategies to enhance future performance.

What you'll be able to do

• Describe the application of robotics in a variety of industries
• Design a robotic solution to address a clearly defined problem
• Evaluate a planned robotic solution to a defined problem, identifying potential improvements

What you'll be able to do

• Know about sources of information about job vacancies, including online job boards, recruitment agencies, and company websites.
• Use information about jobs to identify suitable vacancies, matching skills and interests to job requirements and company culture.

What you'll be able to do

• Understand different software development methodologies, including Agile, Waterfall, and Scrum
• Understand the roles and responsibilities within a software development team, such as developers, testers, and project managers
• Understand the difference between functional and non-functional requirements in the software development process
• Plan a basic software development project, including defining scope, tasks, and timelines
• Develop a basic software solution using appropriate programming languages and tools

What you'll be able to do

• Understand the fundamental principles that underpin software testing.
• Understand the role of software testing within the overall product development lifecycle.
• Understand a range of different software testing techniques.
• Conduct a range of software tests, using appropriate techniques.

What you'll be able to do

• Understand the types of problems that can arise in the workplace.
• Access and utilise appropriate sources of help for resolving workplace problems.
• Understand different methods for solving problems in the workplace.
• Apply appropriate strategies to effectively solve workplace problems.

What you'll be able to do

• Understand key concepts in data transmission.
• Understand the main features of networks.
• Understand the features of the key networking models.
• Understand how telecommunications can be implemented.

What you'll be able to do

• Understand the characteristics of user interfaces (UI), including usability, accessibility, and aesthetics
• Design a UI that is user-friendly, visually appealing, and meets the needs of the target audience
• Understand the principles of user experience (UX) methodology, including user research, prototyping, and testing

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