Project Management SoftwareOCN London Digital Functional Skills Qualification Digital Skills & IT Revision

    This element focuses on the practical application of project management software to plan, organize, and monitor project activities. Learners will develop s

    Topic Synopsis

    This element focuses on the practical application of project management software to plan, organize, and monitor project activities. Learners will develop skills in creating project plans, allocating resources, updating progress, and generating status reports, essential for effective project coordination in a business environment. Mastering these tools enables efficient tracking of timelines, budgets, and deliverables, ensuring projects stay on track and stakeholders are informed.

    Key Concepts & Core Principles

    Exam Tips & Revision Strategies

    Common Misconceptions & Mistakes to Avoid

    Examiner Marking Points

    Project Management Software

    OCN LONDON
    vocational

    This element focuses on the practical application of project management software to plan, organize, and monitor project activities. Learners will develop skills in creating project plans, allocating resources, updating progress, and generating status reports, essential for effective project coordination in a business environment. Mastering these tools enables efficient tracking of timelines, budgets, and deliverables, ensuring projects stay on track and stakeholders are informed.

    12
    Learning Outcomes
    13
    Assessment Guidance
    14
    Key Skills
    9
    Key Terms
    16
    Assessment Criteria

    Assessment criteria

    OCNLR Level 2 Diploma in IT User Skills (ITQ)
    OCNLR Level 3 Diploma in IT User Skills (ITQ)
    OCNLR Level 2 Certificate in IT User Skills (ITQ)

    Topic Overview

    The OCNLR Level 2 Diploma in IT User Skills (ITQ) is a vocational qualification designed to equip students with practical, hands-on IT skills for the modern workplace. It covers a wide range of software applications, including word processing, spreadsheets, databases, presentation software, and email management. The qualification is structured around real-world tasks, such as creating business documents, analysing data, and communicating effectively using digital tools. This diploma is ideal for students who want to demonstrate competence in IT user skills, whether for employment, further study, or everyday use.

    This qualification is part of the IT User Skills (ITQ) framework, which is recognised by employers and educational institutions across the UK. It focuses on developing transferable skills that are essential in almost every job role, from administrative support to project management. By completing this diploma, students will gain confidence in using industry-standard software, improve their problem-solving abilities, and learn to work efficiently with digital information. The course is assessed through practical tasks and portfolio evidence, ensuring that students can apply their knowledge in real-world scenarios.

    In the wider context of digital skills, this diploma provides a solid foundation for further study in IT, such as the Level 3 Diploma in IT or specialised qualifications in areas like cybersecurity or data analytics. It also aligns with the UK government's digital skills agenda, which emphasises the importance of digital literacy for economic participation. Students who achieve this qualification will be well-prepared for roles that require basic to intermediate IT proficiency, and they will have a strong base for lifelong learning in technology.

    Key Concepts

    Core ideas you must understand for this topic

    • File management: organising, saving, and retrieving files in a logical folder structure, including understanding file extensions and version control.
    • Data handling: entering, editing, and formatting data in spreadsheets, using formulas and functions (e.g., SUM, AVERAGE, IF) to perform calculations and analyse information.
    • Document production: creating professional documents using word processing software, including formatting text, inserting tables, images, and applying styles for consistency.
    • Communication tools: using email effectively, managing calendars, and collaborating on documents using cloud-based platforms like Microsoft 365 or Google Workspace.
    • Presentation skills: designing engaging slide presentations with appropriate layouts, transitions, and multimedia elements to convey information clearly.

    Learning Objectives

    What you need to know and understand

    • Define a new project by setting start date, calendar, and project-wide settings in the software.
    • Create and edit a work breakdown structure (WBS) with task dependencies and milestones.
    • Assign resources to tasks, including work, material, and cost resources, and adjust allocations.
    • Update project progress by entering actual start/finish dates, percentage complete, and remaining work.
    • Select and apply appropriate views and reports, such as Gantt charts and resource usage sheets, to display project status.
    • Create and define a project, Enter and edit information about project tasks and resources, Update information about project progress, Select and use appropriate tools and techniques to display and report on project status
    • Define the project scope, objectives, and parameters within the software environment.
    • Enter and edit project tasks, including descriptions, durations, dependencies, and constraints.
    • Allocate and manage resources such as personnel, equipment, and materials, adjusting for availability and cost.
    • Update project progress by recording actual task completion, resource usage, and schedule changes.
    • Select and employ Gantt charts to visualise project timelines and identify the critical path.
    • Generate and interpret status reports to communicate project health to stakeholders.

    Assessment Criteria

    Key criteria assessors look for in your portfolio

    • Award credit for creating a project plan with at least 10 tasks, clear milestones, and correct dependencies.
    • Credit for accurately entering resource details (e.g., names, rates, availability) and assigning them to tasks.
    • Credit for demonstrating the use of progress tracking by updating task completion percentages or actual dates.
    • Credit for generating a Gantt chart and a resource usage report that clearly communicate project status.
    • Credit for evidence of using print preview or export feature to produce professional reports.
    • Award credit for demonstrating the ability to create a new project file with appropriate calendar settings and project start date.
    • Award credit for accurately entering task names, durations, dependencies, and milestones, ensuring logical sequencing.
    • Award credit for assigning resources to tasks, including cost and availability, and levelling overallocations.
    • Award credit for updating actual progress, such as percentage complete or actual start/finish dates, and rescheduling incomplete work.
    • Award credit for selecting relevant views (e.g., Gantt Chart, Network Diagram) and generating and formatting reports that clearly convey project status to stakeholders.
    • Award credit for successfully creating a project file with a clear name and start date.
    • Award credit for entering a set of at least 10 interrelated tasks with logical dependencies.
    • Award credit for assigning resources to tasks and demonstrating an understanding of resource overallocation.
    • Award credit for updating task progress (e.g., percentage complete) and reflecting changes in the Gantt chart.
    • Award credit for producing a formatted Gantt chart that highlights critical tasks and milestones.
    • Award credit for generating a report that summarises project status, including completed and pending tasks.

    Assessment Guidance

    Guidance for achieving higher grades

    • 💡Always save a baseline immediately after creating a project plan to enable variance analysis later.
    • 💡Use the Gantt Chart view frequently to visualize task dependencies and identify the critical path.
    • 💡Regularly review resource usage views to detect and resolve overallocations before they cause delays.
    • 💡When generating reports, select the appropriate format (e.g., timeline, cost, resource) tailored to the stakeholder's needs.
    • 💡Always set a baseline immediately after entering the initial plan and before recording any progress to enable variance analysis.
    • 💡Use project summary tasks and work breakdown structures to neatly organise complex projects, demonstrating advanced planning skills.
    • 💡Show critical path in Gantt chart views or reports to highlight tasks that directly impact the project finish date, impressing assessors with analytical depth.
    • 💡Before submission, verify resource workloads and resolve overallocations using automated levelling features to showcase professional resource management.
    • 💡Tailor printed or exported reports to the specific audience by applying filters, grouping, and highlighting, evidencing an ability to communicate status effectively.
    • 💡Familiarise yourself with the software's interface by practising on a sample project before the assessment.
    • 💡Always set a baseline immediately after defining the project plan to enable progress tracking.
    • 💡Use the help features and templates within the software to speed up project setup.
    • 💡Double-check that all report outputs are clearly labeled and include essential elements like project title and date.
    • 💡When creating documents, always use consistent formatting (e.g., same font size for headings, proper line spacing) to demonstrate attention to detail. Examiners look for professional presentation, not just content.
    • 💡In spreadsheet tasks, show your working by using cell references in formulas rather than typing numbers directly. This proves you understand how formulas update automatically when data changes, which is a key skill.
    • 💡For presentation tasks, avoid overcrowding slides with text. Use bullet points, images, and speaker notes to support your delivery. Examiners value clarity and visual appeal over information overload.

    Common Mistakes

    Common errors to avoid in your coursework

    • Confusing work hours with calendar days when entering task durations, causing scheduling errors.
    • Failing to set task dependencies correctly, leading to an unrealistic project timeline.
    • Neglecting to save a project baseline before tracking progress, making it impossible to compare planned vs actual performance.
    • Over-allocating resources and ignoring resource leveling warnings, resulting in overallocation issues.
    • Failing to save a project baseline before tracking progress, making it impossible to compare planned vs. actual performance.
    • Confusing task duration with work effort, leading to incorrect resource assignment and scheduling.
    • Over-allocating resources without using leveling tools, causing unrealistic work schedules and project delays.
    • Neglecting to link tasks or using incorrect dependency types, resulting in illogical task sequencing and flawed critical path analysis.
    • Forgetting to regularly update task progress, leaving the project plan outdated and status reports inaccurate.
    • Confusing task duration with work effort, leading to incorrect scheduling.
    • Failing to set a baseline, making it impossible to measure project variance accurately.
    • Neglecting to update task dependencies after changes, resulting in an inaccurate critical path.
    • Overlooking resource levelling, causing unrealistic resource allocations.
    • Misinterpreting Gantt chart symbols, misreading task relationships.
    • Misconception: 'IT user skills are just about knowing how to use a computer.' Correction: While basic computer literacy is important, this qualification focuses on applying specific software tools to complete tasks efficiently and accurately, such as using mail merge in word processing or creating pivot tables in spreadsheets.
    • Misconception: 'I can just rely on spell check and grammar tools to produce error-free work.' Correction: Spell checkers can miss context-specific errors (e.g., 'their' vs. 'there') and do not check for factual accuracy or appropriate formatting. Students must proofread manually and understand document layout principles.
    • Misconception: 'Spreadsheets are only for accountants.' Correction: Spreadsheets are used in many fields, including marketing, HR, and science, for tasks like budgeting, data tracking, and creating charts. The diploma teaches versatile skills applicable to any data-driven role.

    Frequently Asked Questions

    Common questions students ask about this topic

    Before You Start

    Prior knowledge that will help with this topic

    • Basic computer literacy: ability to turn on a computer, use a mouse and keyboard, and navigate the desktop environment.
    • Familiarity with common software applications: students should have used a word processor, spreadsheet, and email at a basic level before starting the diploma.
    • Understanding of file types: knowing the difference between .docx, .xlsx, .pptx, and .pdf files helps in managing and submitting work correctly.

    Key Terminology

    Essential terms to know

    • Project initiation and task scheduling
    • Resource allocation and management
    • Progress tracking and monitoring
    • Reporting and communication of project status
    • Create and define a project, Enter and edit information about project tasks and resources, Update information about project progress, Select and use appropriate tools and techniques to display and report on project status
    • Project Initiation and Setup
    • Task and Resource Management
    • Progress Tracking and Updating
    • Visual Reporting and Communication

    Ready to learn?

    AI-powered learning tailored to this unit