OCNLR
Level 2
QN: 603/2951/8
Curriculum Active
OCNLR Level 2 Award in Digital Skills
Official qualification regulated by Ofqual, awarded by OCNLR. Classified as a Other Vocational Qualification. Total guided learning hours: 376 hours.
Qualification Level
Level 2
Awarding Body
OCNLR
Syllabus Units
14 Units
Guided Hours
376 hrs
Instant access to interactive lessons, quizzes, and spaced revision.
Course Syllabus & Study Modules
Complete breakdown of verified curriculum topics and learning objectives.
1
Automation in Office Programs
Verified
Key Learning Objectives:
- Be able to use coding or macro(s), to automate multiple actions within a word processing program.2.
- Be able to use formulae and/or functions, to automate calculations/tasks within a spreadsheet program.
- Be able to use coding and/or macros, to automate multiple actions within a spreadsheet program.
2
Collaborative Working Using Digital Technology
Verified
Key Learning Objectives:
- Be able to prepare and set up collaborative technologies for use.2.
- Be able to use collaborative technology safely and securely.3.
- Be able to initiate
- contribute to, and value contributions from others, in tasks using collaborative technologies.
3
Computational Thinking Concepts
Verified
Key Learning Objectives:
- Understand key computational thinking concepts.
4
Computer Networks
Verified
Key Learning Objectives:
- Understand the principles of networking computers and the associated benefits and disadvantages.2.
- Be able to use networking devices and software.3.
- Understand security features and requirements for computer networks.
5
Digital Content Creation – Audio and Video
Verified
Key Learning Objectives:
- Be able to design a digital publication that incorporates audio and video content (such as an electronic document, web page, blog, social media page, and online survey).
- Be able to input audio and video material elements within a rich media publication design.3.
- Be able to format and produce a rich media digital publication.
6
Digital Content Creation – Text and Image
Verified
Key Learning Objectives:
- Be able to design a digital publication that includes text and images.2.
- Be able to input text and combine with other digital media within a publication design.3.
- Be able to edit, format and produce a digital publication.
7
Digital Safety and Security
Verified
Key Learning Objectives:
- Be able to safeguard self and others when working online.2.
- Be able to take precautions to maintain data security.3.
- Be able to follow legal and organisational constraints, guidelines and procedures which apply when working online.
8
Hardware and Software
Verified
Key Learning Objectives:
- Understand the operation of a PC system.2.
- Be able to upgrade and troubleshoot hardware.3.
- Be able to assemble a PC.4.
- Be able to install and configure software.5.
- Be able to use system tools/ utilities.
9
HTML and CSS Basics
Verified
Key Learning Objectives:
- Be able to use HTML and CSS for web design.2.
- Be able to use CSS selectors.3.
- Be able to incorporate styling into a web page.4.
- Be able to use current HTML and CSS standards to create simple layout.
10
Improving Personal Productivity
Verified
Key Learning Objectives:
- Be able to plan the use of digital software to improve productivity.2.
- Be able to use digital systems and software efficiently to complete planned tasks.3.
- Be able to review the selection and use of digital tools to make improvements in productivity.
11
Introduction to Mobile App Development
Verified
Key Learning Objectives:
- Be able to design a mobile app.2.
- Be able to create and trial a mobile app.3.
- Be able to review and improve a mobile app.
12
Programming Fundamentals
Verified
Key Learning Objectives:
- Be able to use the different data types provided by the programming language.2.
- Be able to use assignment statements to calculate results from expressions using basic mathematical functions.3.
- Be able to use selection commands.4.
- Be able to use loops.5.
- Be able to use subroutines.6.
- Be able to use functions.7.
- Be able to use arrays.8.
- Be able to use logical operators AND, OR and NOT.9.
- Be able to read from and write to data files.10.
- Be able to debug a program.
13
Using Structured Query Language (SQL)
Verified
Key Learning Objectives:
- Be able to interrogate a database using Structured Query Language (SQL) statements to retrieve records from a single table.2.
- Be able to use SQL join statements to combine data from multiple tables.3.
- Be able to sort, group and summarise records using SQL Statements.4.
- Be able to create and use a parameter query.5.
- Be able to manipulate tables using SQL.
14
Visual Programming
Verified
Key Learning Objectives:
- Be able to design a visual application.2.
- Be able to create visual applications.3.
- Be able to test a visual program.
Regulatory & Verification Details
- Qualification Number (QN)
- 603/2951/8
- Regulated Status
- Available to learners
- Awarding Body
- OCNLR
- Qualification Type
- Other Vocational Qualification
- Operational Start
- Mar 2018