Skip to topic
    ← Back to course topics

    3D Drawing and Planning Software — City & Guilds Vocational Digital Skills & IT

    The City & Guilds Level 3 Certificate for IT Users (ITQ) is a vocational qualification that assesses advanced digital skills in word processing, spreadsheets, databases, presentations, and IT security. It focuses on practical, work-ready competencies, requiring learners to apply software features to solve real-world problems and produce professional outcomes.

    3D Drawing and Planning Software explained

    This unit equips learners with the skills to produce professional 3D plans using industry-standard software, ensuring designs meet specified requirements and client briefs.

    Read the full explanation

    It covers the entire workflow from initial concept and modelling to manipulation of objects, application of materials, lighting, and rendering for effective presentation, mirroring real-world architectural, engineering, or product design tasks.

    Learning outcomes

    1. be able to prepare 3D plans to meet requirements, be able to manipulate and present 3D plans

    Which command word is this?

    Give a detailed account of a process or feature, including steps and reasons. For example, 'Describe how to use conditional formatting in Excel' – you must explain what it is, how to apply it, and give an example.

    3D Drawing and Planning Software assessment help

    Topic Overview

    The City & Guilds Level 3 Certificate for IT Users (ITQ) is a vocational qualification that equips learners with advanced digital skills essential for the modern workplace. It covers a range of software applications, including word processing, spreadsheets, databases, presentations, and IT security. The qualification is assessed through practical tasks that simulate real-world scenarios, requiring learners to demonstrate not only technical proficiency but also the ability to apply these skills to solve problems and produce professional outcomes.

    This qualification is part of the wider ITQ suite, which is recognised by employers and educational institutions. It is designed to be flexible, allowing learners to choose units that match their career aspirations. The Level 3 Certificate indicates a high level of competence, suitable for roles that require independent use of IT, such as administrative, managerial, or technical positions. Mastery of these skills is crucial for productivity, data management, and communication in any sector.

    The course emphasises practical application over theory, with assessments that require learners to create documents, analyse data, design databases, and deliver presentations. It also covers important aspects of IT security, ensuring that learners understand how to protect data and use systems safely. By the end of the qualification, learners should be confident in using a range of software tools efficiently and effectively, making them valuable assets to any organisation.

    Key Concepts
    • →Advanced word processing: mail merge, styles, templates, and collaborative editing.
    • →Spreadsheet functions: VLOOKUP, IF statements, conditional formatting, and data validation.
    • →Database design: tables, relationships, queries, and forms.
    • →Presentation design: master slides, animations, and multimedia integration.
    • →IT security: password protection, encryption, and safe internet practices.
    Assessment Criteria
    • Award credit for demonstrating the ability to interpret a client brief and translate it into accurate 3D models with correct dimensions and scale.
    • Credit should be given for effective use of software tools to manipulate geometry, including extrusions, revolutions, and Boolean operations, to refine the plan.
    • Look for evidence of appropriate application of textures, lighting setups, and camera angles to produce clear, photorealistic or stylised rendered outputs for presentation.
    • Assess the final presentation for clarity, use of annotation, and logical layout that communicates the plan effectively to stakeholders.
    Assessment Guidance
    • 💡Always start by analysing the brief thoroughly and check that your model meets every specified requirement before finalising.
    • 💡Use layers and groups to organise your scene; this demonstrates professional workflow and makes it easier to modify elements.
    • 💡When presenting, include multiple views (orthographic and perspective) with clear labels and a title block to mimic industry standards.
    • 💡Save iterative versions of your work to provide evidence of development and to safeguard against data loss.
    • 💡Always read the task brief carefully and highlight the specific requirements, such as 'use a formula', 'create a query', or 'apply a style'. This ensures you meet all the criteria.
    • 💡Save your work frequently and use appropriate file names. In the exam, you may be asked to submit files in a specific format, so check the instructions.
    • 💡Practice using keyboard shortcuts and ribbon commands to speed up your work. Time management is crucial in practical exams.
    Common Mistakes
    • Students often neglect to set up correct units and coordinate systems at the start, leading to scale inaccuracies in the final output.
    • A common error is overcomplicating geometry without understanding optimisation, resulting in large file sizes and slow rendering times.
    • Many learners fail to consider real-world constraints such as structural feasibility or material properties when designing, making the plan impractical.
    • Presentation errors include poor choice of camera angles that hide key features or insufficient lighting that obscures details.
    • Misconception: 'Mail merge is just for letters.' Correction: Mail merge can be used for emails, labels, and envelopes, and can include attachments.
    • Misconception: 'A database is the same as a spreadsheet.' Correction: Databases are designed for storing and retrieving structured data, with relationships between tables, while spreadsheets are for calculations and data analysis.
    • Misconception: 'Using bold and italics makes a document professional.' Correction: Professional documents use consistent styles, proper formatting, and appropriate layout, not just font effects.
    Revision Plan
    1. 1Week 1: Focus on word processing and presentations. Practice creating professional documents using styles, mail merge, and master slides. Complete at least two practice tasks.
    2. 2Week 2: Focus on spreadsheets and databases. Learn key functions like VLOOKUP and IF, and practice creating queries and forms. Use online tutorials and past papers.
    3. 3Week 3: Review IT security topics and take mock exams under timed conditions. Identify weak areas and revise them.
    4. 4Week 4: Consolidate all skills by completing a full practice paper. Seek feedback from a tutor or peer.
    Exam Question Types
    • 📋Practical tasks: You will be given a scenario and asked to produce a document, spreadsheet, database, or presentation. Practice by creating these from scratch.
    • 📋Multiple-choice questions: These test your knowledge of concepts like security and software features. Revise key terms and definitions.
    • 📋Short-answer questions: You may be asked to explain a process, such as how to set up a mail merge. Write clear, step-by-step answers.
    • 📋Scenario-based problem solving: You might be given a data set and asked to analyse it using formulas or queries. Practice interpreting data and choosing the right tool.
    Command Word Expectations (CITY & GUILDS LIMITED)
    Describe

    Give a detailed account of a process or feature, including steps and reasons. For example, 'Describe how to use conditional formatting in Excel' – you must explain what it is, how to apply it, and give an example.

    Explain

    Provide reasons or causes, showing understanding. For example, 'Explain why it is important to use strong passwords' – you must discuss security risks and consequences.

    Evaluate

    Weigh up pros and cons, and make a judgement. For example, 'Evaluate the use of cloud storage for a small business' – you must discuss advantages and disadvantages, then conclude.

    How Students Lose Marks (Examiner Pitfalls)
    Pitfall: Students often confuse 'absolute' and 'relative' cell references in spreadsheets, leading to incorrect results when copying formulas.
    ❌ Weak Answer (Loses Marks):I used =B2*$C$1 but when I copied it down, it still gave the same answer for all rows.
    Example improved answer:In a spreadsheet, an absolute reference (e.g., $C$1) locks the cell reference so it does not change when the formula is copied. A relative reference (e.g., B2) adjusts based on the new location. For example, if you have a tax rate in C1 and amounts in B2:B10, using =B2*$C$1 in cell D2 and copying down will correctly multiply each amount by the same tax rate. Without the dollar signs, the reference would shift, causing errors.
    Examiner Tip: Always check your formula references before copying. Use F4 in Excel to toggle between reference types and test with a small dataset to verify results.
    Pitfall: In database tasks, students often forget to set the correct primary key or misunderstand the difference between filtering and sorting.
    ❌ Weak Answer (Loses Marks):I sorted the records by surname to find all customers from London.
    Example improved answer:Sorting arranges records in a specific order (e.g., alphabetical by surname), but it does not hide records that do not meet a condition. To find all customers from London, you must use a filter (e.g., AutoFilter or Query) that displays only records where the City field equals 'London'. Sorting alone would still show all customers, just in a different order.
    Examiner Tip: Read the question carefully: if it asks to 'show only' or 'display records that meet a condition', use a filter or query, not sorting. Practice creating queries with multiple criteria.
    Step-by-Step Worked Solutions

    Question: A company has a spreadsheet with sales data for January to June. Column A contains months, Column B contains sales figures. In cell C1, the VAT rate is 20%. Calculate the total sales including VAT for each month and then find the overall total. Describe the formulas you would use.

    1. 1.Step 1: Identify the data: months in A2:A7, sales in B2:B7, VAT rate in C1.
    2. 2.Step 2: In cell C2, enter the formula =B2*(1+$C$1) to calculate sales including VAT. Use absolute reference for C1 so it doesn't change when copied.
    3. 3.Step 3: Copy the formula down to C7 to apply to all months.
    4. 4.Step 4: In cell C8, use =SUM(C2:C7) to find the overall total including VAT.
    Final Answer: Use =B2*(1+$C$1) in C2 and copy down, then =SUM(C2:C7) in C8. This gives the total sales including VAT for each month and the overall total.

    Question: You are creating a presentation for a school project. Explain how you would use master slides and slide layouts to ensure consistency and save time.

    1. 1.Step 1: Open the slide master view (View > Slide Master).
    2. 2.Step 2: Edit the master slide to set the background, font styles, and logo placement – these will apply to all slides.
    3. 3.Step 3: Create or modify slide layouts (e.g., title slide, content slide) to define placeholders for text and images.
    4. 4.Step 4: Apply the layouts to individual slides by selecting the appropriate layout from the Home tab.
    5. 5.Step 5: When you need to change the design, edit the master slide and all slides will update automatically.
    Final Answer: Use the slide master to set global design elements, then use custom layouts for different slide types. This ensures consistency and saves time because changes to the master update all slides.
    Active Recall Memory Test
    What is the difference between a relative and absolute cell reference?
    Key Fact: A relative reference changes when a formula is copied, while an absolute reference stays fixed (e.g., $A$1).
    Name three features of a slide master.
    Key Fact: Background design, font styles, and logo placement that apply to all slides.
    What is the purpose of a primary key in a database?
    Key Fact: It uniquely identifies each record in a table, ensuring no duplicates and enabling relationships.
    List two ways to protect data in a spreadsheet.
    Key Fact: Password protection and encrypting the file.
    Frequently Asked Questions
    How long does it take to complete the City & Guilds Level 3 ITQ?
    The duration varies depending on your study mode. Typically, it takes around 6-12 months if studied part-time, but you can complete it faster if you are full-time. The qualification is flexible, so you can work at your own pace.
    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 IT skills, which are highly valued by employers and universities.
    Do I need to take an exam or is it coursework?
    The ITQ is assessed through practical tasks and a portfolio of evidence, not a traditional written exam. You complete assignments that are marked by your tutor and moderated by City & Guilds. This means you can demonstrate your skills in a real-world context.
    Can I study ITQ Level 3 online?
    Yes, many colleges and training providers offer the ITQ online. You will need access to a computer with the required software (e.g., Microsoft Office). Online courses provide flexibility, but you must still complete practical tasks and submit evidence.
    What jobs can I get with an ITQ Level 3?
    The ITQ Level 3 prepares you for roles such as IT support technician, administrative assistant, data analyst, or office manager. It also provides a foundation for further study in IT, such as a Level 4 qualification or a degree.
    What software do I need to learn for the ITQ?
    The ITQ typically uses Microsoft Office applications, including Word, Excel, Access, PowerPoint, and Outlook. Some centres may use alternative software like Google Workspace, but it's best to check with your provider. You'll need to be proficient in these tools to pass the assessments.
    Unit assessment details

    Loading assessment details…