Skip to topic
    ← Back to course topics

    Improving Productivity Using IT — City & Guilds Vocational Digital Skills & IT

    The City & Guilds Level 3 Certificate for IT Users (ITQ) is an advanced vocational qualification that assesses practical digital skills across word processing, spreadsheets, databases, presentations, and IT security. It focuses on applying these skills in real-world contexts, requiring learners to demonstrate autonomy, problem-solving, and adherence to legal and ethical guidelines.

    Improving Productivity Using IT explained

    This element focuses on the strategic use of IT to enhance personal and organisational productivity.

    Read the full explanation

    Learners must demonstrate the ability to evaluate workflow requirements, select appropriate software and systems, and implement iterative improvements through testing and review. The practical application lies in systematically refining IT usage to achieve measurable efficiency gains in real-world tasks.

    Learning outcomes

    1. Plan, select and use appropriate IT systems and software for different purposes, Review and adapt the ongoing use of IT tools and systems to make sure that activities are successful, Develop and test solutions to improve the ongoing use of IT tools and systems

    Which command word is this?

    In City & Guilds ITQ, 'evaluate' requires you to consider the strengths and weaknesses of a solution or approach, and make a judgement based on evidence. You must provide a balanced argument and conclude with a justified decision.

    Improving Productivity Using IT assessment help

    Topic Overview

    The City & Guilds Level 3 Certificate for IT Users (ITQ) is designed for individuals who want to prove their advanced digital skills in a practical, work-related context. It covers a range of software applications and IT concepts, including word processing, spreadsheets, databases, presentations, and IT security. The qualification is recognised by employers and can enhance career prospects in administrative, managerial, or technical roles.

    The course emphasises not just knowing how to use software, but applying it efficiently and safely. You will learn to plan, design, and create documents, analyse data, manage information, and present findings. You will also understand the legal and ethical responsibilities of IT users, such as data protection and copyright. This holistic approach ensures you are not only competent but also professional in your digital practices.

    Assessment is typically through a portfolio of evidence, where you complete real-world tasks and document your processes. This means you need to be organised and reflective, showing how you meet the assessment criteria. The skills you gain are directly transferable to the workplace, making this qualification valuable for career advancement or further study in IT.

    Key Concepts
    • →Advanced word processing: using styles, mail merge, macros, and collaborative tools.
    • →Spreadsheet modelling: using complex formulas, functions (e.g., VLOOKUP, IF), and what-if analysis.
    • →Database design: creating tables, queries, forms, and reports, and understanding relationships.
    • →Presentation skills: designing engaging slides, using multimedia, and delivering effectively.
    • →IT security: understanding threats, protecting data, and following legal and ethical guidelines.
    Assessment Criteria
    • Award credit for demonstrating a systematic approach to planning IT tasks, including justification of software selection against task requirements.
    • Assess how the learner reviews the effectiveness of IT tools during and after task completion, identifying areas for improvement.
    • Evidence of developing and testing at least one solution to enhance the use of IT, with documented results and analysis.
    Assessment Guidance
    • 💡When documenting your planning, clearly link each IT tool choice to specific task needs and productivity gains.
    • 💡For the review portion, provide concrete examples of what worked well and what could be improved, with measurable evidence.
    • 💡In developing and testing solutions, show iterative refinement: initial plan, testing, modifications, and final outcome.
    • 💡Always read the task brief carefully and identify the exact requirements. Underline key words like 'format', 'calculate', 'design', or 'evaluate' to ensure you meet all criteria.
    • 💡Use the software's built-in help and templates to speed up your work, but make sure you understand the underlying concepts. For example, using a template for a newsletter is fine, but you must be able to modify it to suit the task.
    • 💡Save your work regularly and keep backups. In the exam, you may lose marks if you cannot provide evidence of your work due to a technical issue.
    Common Mistakes
    • Students often select software based on personal preference rather than an objective analysis of task requirements.
    • Failing to properly review or evaluate the IT tools used, leading to missed opportunities for improvement.
    • Assuming that familiarity with basic functions equates to optimal use; not exploring advanced features or alternative solutions.
    • Misconception: 'Formatting and layout are the same thing.' Correction: Formatting refers to the appearance of text (font, size, colour), while layout refers to the arrangement of content on the page (margins, alignment, spacing).
    • Misconception: 'Spreadsheet formulas are only for simple calculations.' Correction: Spreadsheets can perform complex data analysis, including logical tests, lookups, and financial functions, which are essential for business decision-making.
    • Misconception: 'Databases are just like spreadsheets.' Correction: Databases are designed for efficient data storage, retrieval, and management of large volumes of structured data, with relationships between tables, unlike flat spreadsheets.
    Revision Plan
    1. 1Week 1: Focus on word processing and presentations. Practice creating professional documents and slides, using styles, themes, and multimedia. Complete at least two practice tasks.
    2. 2Week 2: Focus on spreadsheets and databases. Learn advanced formulas, functions, and database relationships. Create a sample database and spreadsheet model.
    3. 3Week 3: Review IT security and legal issues. Understand data protection, copyright, and safe internet use. Take notes and create flashcards.
    4. 4Week 4: Attempt full practice assessments under timed conditions. Review your answers against the mark scheme and identify areas for improvement.
    5. 5Week 5: Consolidate your knowledge by teaching a friend or writing summaries. Focus on weak areas and revisit key concepts.
    Exam Question Types
    • 📋Practical tasks: You will be given a scenario and asked to produce a document, spreadsheet, or presentation. Advice: Plan your approach, use appropriate software features, and check your output against the requirements.
    • 📋Multiple-choice questions: These test your knowledge of IT concepts, security, and legal issues. Advice: Read each question carefully and eliminate obviously wrong answers.
    • 📋Short-answer questions: You may be asked to explain a process or define a term. Advice: Use correct terminology and give concise, accurate explanations.
    • 📋Case study questions: You will analyse a scenario and recommend solutions. Advice: Apply your knowledge to the context and justify your recommendations.
    Command Word Expectations (CITY & GUILDS LIMITED)
    Evaluate

    In City & Guilds ITQ, 'evaluate' requires you to consider the strengths and weaknesses of a solution or approach, and make a judgement based on evidence. You must provide a balanced argument and conclude with a justified decision.

    Explain

    You need to give a clear, detailed account of how or why something happens, including relevant reasons and causes. Use technical terms accurately and provide examples where appropriate.

    Create

    This command word requires you to produce a tangible output, such as a document, spreadsheet, or presentation, that meets specific criteria. You must demonstrate correct use of software features and ensure the output is fit for purpose.

    How Students Lose Marks (Examiner Pitfalls)
    Pitfall: Students often confuse 'formatting' with 'layout' in word processing tasks, leading to lost marks for not applying the correct styles or alignment.
    ❌ Weak Answer (Loses Marks):I will make the text bold and centre it.
    Example improved answer:To format the heading, I will apply the 'Heading 1' style, which sets the font size, bold, and colour consistently. For the body text, I will use justified alignment and 1.5 line spacing to improve readability. This ensures the document meets the specified formatting requirements.
    Examiner Tip: Always read the task carefully: 'format' refers to font, size, colour, and style; 'layout' refers to alignment, spacing, and page setup. Use built-in styles for consistency.
    Pitfall: In spreadsheet tasks, students often forget to use absolute cell references when copying formulas, resulting in incorrect calculations.
    ❌ Weak Answer (Loses Marks):I will use =B2*C2 and drag it down.
    Example improved answer:To calculate the total cost for each item, I will use the formula =B2*$C$1, where $C$1 is the tax rate. The dollar signs make the reference absolute, so when I copy the formula down, the tax rate remains constant while the item price changes.
    Examiner Tip: Always check whether a reference should be relative or absolute. Use F4 in Excel to toggle quickly. Practice with scenarios where you copy formulas across rows and columns.
    Step-by-Step Worked Solutions

    Question: A spreadsheet contains a list of sales figures for January to June. You need to calculate the average monthly sales and then apply a 10% increase to the average. Show your formula and the final result if the monthly figures are £1200, £1500, £1100, £1800, £1600, £1400.

    1. 1.Step 1: Identify the given data: sales figures for six months.
    2. 2.Step 2: Calculate the average using the AVERAGE function: =AVERAGE(B2:B7) assuming data is in cells B2 to B7.
    3. 3.Step 3: Apply the 10% increase by multiplying the average by 1.10: =AVERAGE(B2:B7)*1.10.
    4. 4.Step 4: Compute the numerical result: Average = (1200+1500+1100+1800+1600+1400)/6 = 8600/6 = 1433.33. Then 1433.33 * 1.10 = 1576.67.
    Final Answer: The final result is £1576.67.

    Question: You are creating a database for a library. Explain how you would set up a relationship between two tables: 'Books' and 'Loans'. Include the field names and the type of relationship.

    1. 1.Step 1: Identify the primary key in the 'Books' table, e.g., BookID.
    2. 2.Step 2: In the 'Loans' table, include a foreign key field, e.g., BookID, that references the primary key.
    3. 3.Step 3: Define the relationship as one-to-many: one book can be loaned many times, but each loan is for one book.
    4. 4.Step 4: Enforce referential integrity to ensure no orphan records.
    Final Answer: The relationship is one-to-many between Books.BookID and Loans.BookID, with referential integrity enforced.
    Active Recall Memory Test
    What is the difference between a primary key and a foreign key in a database?
    Key Fact: A primary key uniquely identifies each record in a table, while a foreign key is a field in one table that refers to the primary key of another table, creating a relationship.
    Name three functions in Excel and describe what each does.
    Key Fact: SUM adds a range of numbers; AVERAGE calculates the mean; VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
    What is the purpose of the General Data Protection Regulation (GDPR) in IT?
    Key Fact: GDPR protects individuals' personal data by regulating how organisations collect, store, and process it, giving individuals more control over their data.
    How can you protect your computer from malware?
    Key Fact: Install antivirus software, keep it updated, avoid clicking on suspicious links or attachments, and regularly update your operating system and applications.
    Frequently Asked Questions
    How long does it take to complete the City & Guilds Level 3 ITQ?
    The duration varies depending on your study mode and pace. Typically, it takes around 6-12 months of part-time study. Some learners may complete it faster if they have prior experience. The qualification is flexible, so you can work at your own speed, but you must complete all required units.
    Is the ITQ Level 3 equivalent to A-levels?
    Yes, the Level 3 Certificate is roughly equivalent to one A-level in terms of UCAS points and difficulty. It is a vocational qualification that demonstrates practical skills, which can be used for university applications or employment.
    Do I need to take an exam or is it coursework?
    The ITQ is primarily assessed through a portfolio of evidence, where you complete tasks and document your work. There is no traditional written exam. You will be assessed on your ability to apply skills in real-world scenarios, and your work is internally assessed and externally moderated.
    Can I study the ITQ online?
    Yes, many colleges and training providers offer the ITQ online. You will have access to learning materials and assessments via a virtual learning environment. You may need to attend occasional workshops or assessments in person, but the majority of the course can be completed remotely.
    What jobs can I get with an ITQ Level 3?
    This qualification can lead to roles such as IT support technician, administrative assistant, data entry specialist, or digital marketing assistant. It also provides a foundation for further study in IT, such as a Level 4 qualification or a degree.
    How is the ITQ different from other IT qualifications like GCSE or A-level Computer Science?
    The ITQ focuses on practical, vocational skills for using IT in the workplace, whereas GCSE and A-level Computer Science are more theoretical and cover programming, algorithms, and computer science principles. The ITQ is ideal if you want to demonstrate your ability to use software effectively, rather than develop software.
    Unit assessment details

    Loading assessment details…