Project Management Software — Open College Network Northern Ireland Vocationally-Related Qualification Digital Skills & IT Revision

    This element develops practical competence in using project management software to plan, execute, and monitor a project lifecycle. Learners will acquire ha

    Topic Synopsis

    This element develops practical competence in using project management software to plan, execute, and monitor a project lifecycle. Learners will acquire hands-on skills in defining project parameters, populating task and resource data, tracking progress, and communicating status through reports, mirroring the responsibilities of administrative and project support staff in a business environment.

    Key Concepts & Core Principles

    Exam Tips & Revision Strategies

    Common Misconceptions & Mistakes to Avoid

    Examiner Marking Points

    Project Management Software

    OPEN COLLEGE NETWORK NORTHERN IRELAND
    vocational

    This element develops practical competence in using project management software to plan, execute, and monitor a project lifecycle. Learners will acquire hands-on skills in defining project parameters, populating task and resource data, tracking progress, and communicating status through reports, mirroring the responsibilities of administrative and project support staff in a business environment.

    5
    Learning Outcomes
    19
    Assessment Guidance
    21
    Key Skills
    5
    Key Terms
    21
    Assessment Criteria

    Assessment criteria

    OCN NI Level 2 Award in Information Technology Applications
    OCN NI Level 2 Certificate in Information Technology Applications
    OCN NI Level 3 Award in Information Technology Applications
    OCN NI Level 3 Certificate in Information Technology Applications
    OCN NI Level 3 Diploma in Information Technology Applications

    Topic Overview

    The OCN NI Level 2 Award in Information Technology Applications is a vocationally-related qualification designed to equip students with practical IT skills essential for the modern workplace. This award covers a range of software applications, including word processing, spreadsheets, databases, and presentation software, as well as fundamental concepts of file management and online collaboration. By focusing on real-world tasks, students develop the ability to create professional documents, analyse data, and communicate information effectively using digital tools.

    This qualification is particularly valuable because it bridges the gap between basic computer literacy and more advanced IT certifications. It is recognised by employers and further education providers across Northern Ireland and the UK, demonstrating that a student can apply IT skills in a business context. The course emphasises accuracy, efficiency, and problem-solving, preparing students for roles in administration, customer service, and data management, or for progression to Level 3 qualifications in IT or business.

    Within the wider subject of Digital Skills & IT, this award serves as a foundational stepping stone. It aligns with the UK government's digital strategy to boost digital skills in the workforce, ensuring students are confident in using common software packages. The practical nature of the assessment means students build a portfolio of evidence, which can be used to showcase their abilities to potential employers or in further study.

    Key Concepts

    Core ideas you must understand for this topic

    • →File management: organising, saving, and retrieving files in appropriate formats and locations, including understanding file extensions and cloud storage.
    • →Word processing: formatting text, using styles, inserting tables and images, and applying mail merge for personalised documents.
    • →Spreadsheets: creating formulas and functions (SUM, AVERAGE, IF), generating charts, and using cell references (absolute and relative).
    • →Databases: designing tables with appropriate field types, creating queries using criteria, and generating reports from data.
    • →Presentation software: designing slides with consistent themes, adding animations and transitions, and delivering a presentation effectively.

    Learning Objectives

    What you need to know and understand

    • Be able to create and define a project., Be able to enter and edit information about project tasks and resources., Be able to update information about project progress., Be able to display and report on project status.
    • Be able to create and define a project., Be able to enter and edit information about project tasks and resources., Be able to update information about project progress., Be able 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.
    • 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 creation of a new project file with clear objectives, start and finish dates, and a logical work breakdown structure containing at least three summary and subtask levels.
    • Credit should be given for accurate data entry and editing, including task durations, dependencies (finish-to-start, start-to-start), constraints, and assignment of specific resources with associated costs or working calendars.
    • Assessors should expect evidence of updating task progress, such as percentage complete or actual start/finish dates, and adjusting resource allocations to reflect real-time changes, while noting the impact on the project schedule.
    • When reporting, credit for generating at least two different reports (e.g., Gantt chart, resource usage) that compare current progress against an established baseline, with clear identification of variances and critical tasks.
    • Award credit for demonstrating the accurate creation and definition of a project, including setting key parameters such as start date, calendar, and file properties.
    • Award credit for entering and editing comprehensive task lists with correct durations, dependencies, milestones, and assigned resources.
    • Award credit for inputting and updating actual progress data, including task completion percentages, actual start/finish dates, and resource work hours.
    • Award credit for generating and clearly presenting reports that display project status, such as Gantt charts, resource usage views, and task summary reports, with appropriate filtering and formatting.
    • Award credit for demonstrating the ability to create a new project file with clearly defined start/end dates and a working calendar.
    • Award credit for demonstrating accurate entry and editing of task details, including dependencies, durations, and assigned resources.
    • Award credit for demonstrating the ability to update task progress (e.g., percentage complete, actual dates) and show impact on schedule.
    • Award credit for producing relevant reports (e.g., Gantt charts, resource usage, milestone reports) that clearly communicate project status to stakeholders.
    • Award credit for clearly defining a complete project with a start date, calendar, and file structure within the software.
    • Evidence must demonstrate accurate entry of tasks with durations, dependencies, and milestones, alongside resource names, types, and costs.
    • Assessors should look for consistent updates to actual start/finish dates, percentage complete, and resource usage, with explanations of variances.
    • Select and apply appropriate reporting tools (e.g., Gantt charts, resource histograms, dashboards) to depict status, and ensure outputs are tailored to different stakeholders.
    • Award credit for accurately creating a project with a defined start date and calendar that aligns with the project brief.
    • Assess effective use of task dependencies (e.g., finish-to-start, start-to-start) to establish realistic scheduling logic.
    • Evidence of resource allocation including assigning resource types, costs, and work effort to tasks.
    • Accurate updating of actual progress (e.g., percentage complete, actual start/finish) against the saved baseline to reflect project status.
    • Appropriate selection and customisation of views (Gantt chart, network diagram, resource graph) and reports to communicate project status clearly.

    Assessment Guidance

    Guidance for achieving higher grades

    • 💡Always baseline your project after completing the initial plan; this provides a snapshot against which all updates can be compared for assessment purposes.
    • 💡Use the software’s built-in reports rather than screenshots; printing or exporting to a PDF ensures formatting consistency and clear evidence of your ability to generate status outputs.
    • 💡Before submitting evidence, use the project health or audit feature to check for logical errors such as missing dependencies or over-allocated resources, demonstrating professional practice.
    • 💡Always set and save a baseline immediately after defining tasks and resources to enable meaningful progress tracking.
    • 💡Use appropriate views (e.g., Gantt Chart, Task Usage) for data entry and editing to minimize errors and ensure consistency.
    • 💡Regularly update actual progress against the baseline to maintain accurate reports; do not wait until the end of the project.
    • 💡When displaying reports, select filters and highlights that directly address the assessment criteria, ensuring clarity and relevance to stakeholders.
    • 💡Always verify the project calendar and working hours before entering tasks to avoid scheduling errors.
    • 💡Use the critical path feature to identify tasks that directly impact the project finish date—this is often assessed.
    • 💡When updating progress, consistently use the status date to ensure accurate reporting and earned value analysis.
    • 💡In report generation, select views and filters that highlight the most relevant information for the given scenario, such as variance tables for control.
    • 💡Always start by saving a baseline; this is a key differentiator for high marks in the 'update progress' objective.
    • 💡When displaying status, use a mix of graphical and tabular reports to demonstrate versatility, and annotate them with brief commentary on corrective actions.
    • 💡For resource management, show screenshots of resource usage views and resolve overallocations using levelling or manual adjustments—assessors value problem-solving.
    • 💡In the assignment, link reporting choices explicitly to project stakeholder needs, e.g., a summary dashboard for sponsors versus a task list for team members.
    • 💡Always start by setting the project start date and standard working calendar, ensuring non-working time is accounted for.
    • 💡Use clear and consistent naming conventions for tasks and resources to enhance readability and maintainability of the project plan.
    • 💡When tracking progress, mark tasks as percentage complete or enter actual dates, rather than just adjusting durations, to maintain data integrity.
    • 💡For stakeholder reports, select visual tools like Gantt charts with progress lines or milestone-based reports to highlight key deliverables and status.
    • 💡Always read the task brief carefully. Many students lose marks by not following specific instructions, such as naming files correctly or using a particular font size. Highlight key requirements before starting.
    • 💡In spreadsheet tasks, show your working. Use cell references in formulas rather than typing numbers directly, as this demonstrates understanding and allows for easy updates. Also, label your data clearly with headers.
    • 💡For presentation tasks, focus on clarity and consistency. Use a master slide to ensure uniform fonts and colours. Avoid overcrowding slides with text; use bullet points and visuals to support your message.

    Common Mistakes

    Common errors to avoid in your coursework

    • Failing to set a project baseline immediately after initial planning, making it impossible to later measure schedule or cost variances accurately.
    • Confusing task dependencies, such as using a finish-to-start link when a start-to-start link is required, leading to illogical scheduling and an inaccurate critical path.
    • Entering resources without assigning them to tasks, resulting in work not being tracked against individuals and the project plan remaining unactionable.
    • Misinterpreting the Gantt chart; for example, assuming the critical path is shown by task colour rather than by analysing the longest sequence of dependent tasks.
    • Confusing duration with work effort, leading to unrealistic scheduling when resources are assigned.
    • Failing to set a project baseline before entering progress, making it impossible to track variances accurately.
    • Overlooking task dependencies, resulting in illogical task sequences and incorrect critical path calculations.
    • Entering progress updates without adjusting remaining work, thus generating misleading completion forecasts.
    • Confusing task dependencies (e.g., using Start-to-Start instead of Finish-to-Start) leading to illogical scheduling.
    • Failing to set a project baseline before updating progress, which prevents meaningful variance analysis.
    • Over-allocating resources without resolving conflicts, resulting in unrealistic project plans.
    • Generating status reports without interpreting the data or tailoring them to the audience's needs.
    • Failing to set a project baseline before tracking progress, making it impossible to measure variance accurately.
    • Over-allocating resources without checking workload, leading to unrealistic schedules and ignored overallocations.
    • Using only static views like task lists instead of dynamic reports, missing the software's capability to filter and highlight critical paths.
    • Neglecting to update progress regularly, causing reports to become outdated and undermining project control.
    • Confusing work effort with duration, leading to unrealistic schedules where tasks appear longer than necessary.
    • Neglecting to set a project baseline, which prevents meaningful comparison of planned versus actual progress.
    • Overlooking resource over-allocations and failing to level resources, causing conflicts and overallocation errors.
    • Manually updating summary task progress instead of relying on subtask roll-up, which can cause data inconsistency.
    • Incorrectly linking tasks that should be concurrent as sequential, artificially lengthening the critical path.
    • Misconception: 'Using the spell checker means my document is error-free.' Correction: Spell checkers do not catch all errors, especially homophones (e.g., 'their' vs 'there') or context-specific mistakes. Always proofread manually.
    • Misconception: 'I can just copy and paste data from the internet without referencing it.' Correction: Plagiarism is a serious academic offence. You must cite sources and respect copyright laws, especially when using images or data.
    • Misconception: 'Formulas in spreadsheets are too hard; I'll just calculate manually.' Correction: Formulas save time and reduce errors. Start with simple arithmetic (e.g., =B2+C2) and build up to functions like SUM and IF.

    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.
    • •Understanding of file types and storage: knowing the difference between saving to a hard drive, USB, or cloud service.
    • •Familiarity with common software interfaces: experience with any version of Microsoft Office or similar suite (e.g., LibreOffice) is helpful but not essential.

    Key Terminology

    Essential terms to know

    • Be able to create and define a project., Be able to enter and edit information about project tasks and resources., Be able to update information about project progress., Be able to display and report on project status.
    • Be able to create and define a project., Be able to enter and edit information about project tasks and resources., Be able to update information about project progress., Be able 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.
    • 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 NORTHERN IRELAND vocational Digital Skills & IT

    OCN NI Entry Level 3 Certificate in Essential Skills – Digital ICT - Core Content

    View Topic

    OCN NI Level 1 Certificate in Essential Skills – Digital ICT - Core Content

    View Topic

    OCN NI Level 2 Certificate in Essential Skills – Digital ICT - Core Content

    View Topic

    Bespoke Software

    View Topic