Project Management Software — Open College Network Yorkshire and Humber Region trading as Certa Vocationally-Related Qualification Digital Skills & IT Revision

    This subtopic focuses on the practical application of project management software to plan, monitor and communicate project information. Learners will maste

    Topic Synopsis

    This subtopic focuses on the practical application of project management software to plan, monitor and communicate project information. Learners will master creating project plans with tasks, dependencies and resources, tracking progress against baselines, and producing status reports using built-in tools. These skills are essential for effective collaboration and decision-making in professional environments.

    Key Concepts & Core Principles

    Exam Tips & Revision Strategies

    Common Misconceptions & Mistakes to Avoid

    Examiner Marking Points

    Project Management Software

    OPEN COLLEGE NETWORK YORKSHIRE AND HUMBER REGION TRADING AS CERTA
    vocational

    This subtopic introduces learners to the fundamental principles of using project management software to plan, track, and report on small-scale projects. It equips candidates with the practical skills to create a project plan, define tasks and resources, update progress, and generate status reports, which are essential for effective administrative and IT support roles.

    2
    Learning Outcomes
    8
    Assessment Guidance
    9
    Key Skills
    2
    Key Terms
    10
    Assessment Criteria

    Assessment criteria

    Certa Level 1 Diploma in IT User Skills (ITQ) (QCF)
    SEG Awards Certa Level 3 Certificate in IT User Skills (ITQ)

    Topic Overview

    The SEG Awards Certa Level 3 Certificate in IT User Skills (ITQ) is a vocational qualification designed to equip learners with advanced, practical IT skills essential for the modern workplace. It covers a broad range of digital competencies, including word processing, spreadsheets, databases, presentation software, and using the internet securely. This qualification is ideal for students who want to demonstrate their ability to use IT effectively in a professional context, whether for employment, further study, or personal development.

    This certificate is part of the IT User Skills suite, which is recognised by employers and educational institutions across the UK. It focuses on real-world applications, requiring students to complete tasks that mirror typical office scenarios, such as creating complex documents, analysing data with spreadsheets, and designing professional presentations. By achieving this Level 3 qualification, students prove they can work independently and solve problems using IT, making them more competitive in the job market.

    The qualification is assessed through a portfolio of evidence, meaning there are no formal exams. Instead, you build a collection of work demonstrating your skills, which is then internally assessed and externally moderated. This approach allows you to learn at your own pace and apply your knowledge to tasks relevant to your interests or career goals. It's a flexible, practical pathway to boosting your digital skills and earning a recognised credential.

    Key Concepts

    Core ideas you must understand for this topic

    • →Advanced word processing: using styles, templates, mail merge, and collaborative editing tools to produce professional documents.
    • →Spreadsheet modelling: creating complex formulas, using functions like VLOOKUP and IF, and generating charts to analyse data.
    • →Database management: designing relational databases, creating queries with multiple criteria, and generating reports.
    • →Presentation design: incorporating multimedia elements, using master slides, and applying animation/transition effects for impact.
    • →Digital security: understanding data protection, secure online practices, and managing digital identities responsibly.

    Learning Objectives

    What you need to know and understand

    • 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
    • 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

    Assessment Criteria

    Key criteria assessors look for in your portfolio

    • Award credit for demonstrating the ability to create and save a new project file with an appropriate name and start date.
    • Award credit for accurately entering and editing task details including names, durations, dependencies, and milestones.
    • Award credit for assigning resources to tasks and correctly specifying resource types (e.g. work, material) and costs.
    • Award credit for updating task completion percentages and recording actual start/finish dates to reflect progress.
    • Award credit for selecting and generating a suitable report or view (e.g. Gantt Chart, Task Sheet, Resource Usage) that clearly communicates project status.
    • Award credit for demonstrating the ability to create a new project file with accurate start date, calendar and scheduling settings.
    • Award credit for entering and editing task details including names, durations, dependencies and constraints, ensuring logical sequencing.
    • Award credit for assigning resources (work, material, cost) to tasks and resolving overallocations.
    • Award credit for updating project progress by entering actual start/finish dates and completion percentages, and for comparing against the baseline.
    • Award credit for selecting and using appropriate display tools such as Gantt Chart, Network Diagram or Resource Graph, and for generating a clear project status report.

    Assessment Guidance

    Guidance for achieving higher grades

    • 💡Always use the correct sequence: define the project calendar first, then enter tasks, then assign resources, and finally track progress.
    • 💡Screenshot your key views at each stage (planning, tracking, reporting) to provide clear evidence for your portfolio.
    • 💡Practice generating at least two different types of reports (e.g. an overview report and a resource report) to demonstrate your ability to tailor outputs to an audience.
    • 💡Double-check that all task dates and resource allocations are logically consistent before submitting your assessment evidence.
    • 💡In assignment work, always document your planning process: explain why you chose specific dependencies, resource allocations and reporting formats.
    • 💡Use screenshots to evidence correct use of software features, such as the Gantt Chart with critical path highlighted.
    • 💡Before finalising your evidence, check that all fields required by the assessment criteria are accurately filled and consistent.
    • 💡When generating reports, tailor the content to the intended audience (e.g., summary for managers, detailed task list for team members).
    • 💡Always label your evidence clearly. Use a consistent naming convention for files and include a contents page for your portfolio. This makes it easy for assessors to find specific tasks and shows you are organised.
    • 💡Don't just show the final product—include screenshots of key steps, such as formula creation or query design. Annotate these to explain what you did and why. This demonstrates your understanding and problem-solving process.
    • 💡Read the assessment criteria carefully before starting each task. Highlight keywords like 'create', 'modify', 'analyse', and 'evaluate'. Ensure your evidence directly addresses each point. If a criterion asks for 'evaluation', include a written reflection on your choices.

    Common Mistakes

    Common errors to avoid in your coursework

    • Assuming task duration and work are the same, leading to inaccurate scheduling when resources are assigned.
    • Forgetting to set task dependencies, resulting in an unrealistic project timeline where tasks run in parallel.
    • Neglecting to save a baseline, making it impossible to compare planned versus actual progress effectively.
    • Inputting progress data without updating the % complete field, causing reports to show outdated information.
    • Confusing duration with effort/work, leading to incorrect task lengths and resource assignments.
    • Neglecting to set a baseline, meaning progress tracking lacks a reference point for variance analysis.
    • Overlooking task dependencies, resulting in a schedule that does not reflect realistic sequencing.
    • Using inappropriate reporting views (e.g., Task Sheet when a Gantt Chart is needed) to communicate project status.
    • Forgetting to save a baseline or protect the project file, causing loss of original plan data.
    • Misconception: 'I already know how to use Word and Excel, so this will be easy.' Correction: Level 3 requires advanced features like macros, pivot tables, and conditional formatting, which go beyond basic use. You need to demonstrate depth, not just familiarity.
    • Misconception: 'The portfolio is just about collecting screenshots.' Correction: Screenshots alone are not enough. You must annotate your work, explain your choices, and show the process behind each task. Evidence must be clear and contextualised.
    • Misconception: 'I can use any software I like.' Correction: While you can use different applications (e.g., Google Docs vs. Microsoft Word), you must meet the assessment criteria. Some features may not be available in all software, so check your chosen tools against the specification.

    Frequently Asked Questions

    Common questions students ask about this topic

    Before You Start

    Prior knowledge that will help with this topic

    • •Basic IT user skills (e.g., using a computer, saving files, browsing the internet) at Level 1 or 2.
    • •Familiarity with common office applications like Microsoft Office or Google Workspace.
    • •Understanding of file management and data organisation.

    Key Terminology

    Essential terms to know

    • 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
    • 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

    Ready to learn?

    AI-powered learning tailored to this unit

    Related Topics in OPEN COLLEGE NETWORK YORKSHIRE AND HUMBER REGION TRADING AS CERTA vocational Digital Skills & IT

    Audio Software

    View Topic

    Bespoke Software

    View Topic

    Computerised Accounting Software

    View Topic

    Data Management Software

    View Topic