Skip to topic
    ← Back to course topics

    IT Communication Fundamentals — Learning Machine Vocational Digital Skills & IT

    The TLM Level 2 Certificate in IT User Skills in Open Systems and Enterprise (ITQ) assesses practical competence in using IT software and systems in a business context. It covers word processing, spreadsheets, databases, presentation software, and safe, secure working practices, preparing learners for digital roles in the workplace.

    IT Communication Fundamentals explained

    This subtopic equips learners with essential skills to identify, access, and critically appraise information from diverse sources, particularly internet-based ones, ensuring it meets specific needs.

    Read the full explanation

    It also focuses on using IT tools to communicate and share information safely, responsibly, and effectively in personal and professional contexts, aligning with best practices in digital literacy and online conduct.

    Learning outcomes

    1. Select and use a variety of sources of information to meet needs, Access, search for, select and use Internet-based information and evaluate its fitness for purpose, Select and use IT to communicate and exchange information safely, responsibly and effectively

    Which command word is this?

    Provide a clear, detailed account of a concept or process, including reasons or causes. For example, 'Explain the purpose of a primary key in a database' – you must state that it uniquely identifies records and why that is important.

    IT Communication Fundamentals assessment help

    Topic Overview

    The TLM Level 2 Certificate in IT User Skills in Open Systems and Enterprise (ITQ) is a vocational qualification that equips learners with the practical IT skills needed in modern workplaces. It focuses on using open systems (such as Linux) and enterprise software (like Microsoft Office) to complete tasks efficiently and securely. The qualification covers a range of applications, including word processing, spreadsheets, databases, presentation software, and using email and the internet, all within a business context.

    This qualification is important because it demonstrates to employers that you can use IT tools effectively to solve problems, handle data, and communicate professionally. It also covers essential topics like data protection, cybersecurity, and legal obligations, which are critical in any job that involves handling information. By completing this course, you build a solid foundation for further study or entry into the workforce, and you gain skills that are transferable across industries.

    The course is assessed through practical tasks and a portfolio of evidence, rather than a single written exam. This means you need to show your competence by completing real-world tasks, such as creating a spreadsheet with formulas, designing a database, or producing a professional presentation. The qualification is recognised by employers and can be a stepping stone to higher-level IT qualifications or apprenticeships.

    Key Concepts
    • →Open source vs proprietary software: Understand the differences in licensing, cost, and user freedom.
    • →Health and safety: Know how to set up a workstation correctly to avoid repetitive strain injury and eye strain.
    • →Data protection: Understand the principles of the Data Protection Act 2018 and GDPR, and how to apply them when handling personal data.
    • →Spreadsheet formulas and functions: Use SUM, AVERAGE, IF, VLOOKUP, and absolute/relative cell references.
    • →Database design: Create tables with primary keys, establish relationships, and use queries to extract data.
    Assessment Criteria
    • Award credit for demonstrating the selection of at least three different types of information sources (e.g., websites, databases, e-books, online forums) tailored to the task's purpose.
    • Award credit for evaluating internet-based information using explicit criteria such as authority (author credentials), currency (date of publication), accuracy (cross-referencing), and relevance to the given brief.
    • Award credit for evidencing safe communication practices, including awareness of data protection (e.g., not sharing personal data without consent), use of secure platforms, and appropriate netiquette in email, messaging, or collaborative tools.
    Assessment Guidance
    • 💡Always document your search process and evaluation: keep a log of search terms, sources considered, and reasons for selection or rejection to demonstrate critical thinking in your portfolio.
    • 💡When evaluating information, use a structured framework like CRAAP (Currency, Relevance, Authority, Accuracy, Purpose) and reference it explicitly in your evidence to satisfy assessment criteria.
    • 💡For communication tasks, choose the most appropriate IT tool for the context (e.g., email for formal requests, instant messaging for quick collaboration) and explain your choice to show responsible and effective practice.
    • 💡Review your evidence against common security and data protection principles (e.g., GDPR basics) before submission, and highlight how you’ve adhered to them in your work.
    • 💡Always save your work regularly and use appropriate file names – this is part of the assessment criteria.
    • 💡When answering questions about software, give specific examples (e.g., 'Microsoft Excel' or 'LibreOffice Calc') to show your knowledge.
    • 💡Read the task carefully: if it asks for a 'formula', write the formula, not the result. If it asks for 'steps', list them in order.
    Common Mistakes
    • Relying on the first search result without verifying source credibility or cross-referencing, leading to use of outdated or biased information.
    • Failing to distinguish between facts, opinions, and sponsored content, which undermines the fitness-for-purpose evaluation.
    • Neglecting to tailor communication style and tools to the audience (e.g., using informal language in a professional email, or overusing CC/Reply All), compromising effectiveness and professionalism.
    • Ignoring basic security measures like strong passwords or phishing risks when exchanging information, increasing vulnerability to data breaches.
    • Misconception: 'Open source software is always free of charge.' Correction: While many open source programs are free, the key point is that the source code is open for modification, not necessarily that it costs nothing. Some open source software may have paid support or enterprise versions.
    • Misconception: 'A spreadsheet is just a table of numbers.' Correction: Spreadsheets are powerful tools for data analysis, with functions, formulas, charts, and the ability to perform 'what-if' scenarios.
    • Misconception: 'Databases are the same as spreadsheets.' Correction: Databases are designed for storing and retrieving large amounts of structured data with relationships, while spreadsheets are more suited to calculations and small datasets.
    Revision Plan
    1. 1Week 1: Focus on word processing and presentation software. Practise formatting documents, inserting images, and creating slides with transitions. Complete a practice task that involves creating a business report and a presentation.
    2. 2Week 2: Move on to spreadsheets and databases. Learn key formulas (SUM, AVERAGE, IF) and how to create a simple database with two tables and a query. Practise using absolute references and sorting/filtering data.
    3. 3Week 3: Revise health and safety, data protection, and legal issues. Create flashcards for key terms like 'GDPR' and 'ergonomics'. Take a mock assessment to identify weak areas.
    4. 4Week 4: Consolidate by completing full practice tasks under timed conditions. Review your portfolio and ensure all evidence is complete and well-organised.
    Exam Question Types
    • 📋Multiple-choice questions: These test your knowledge of definitions and concepts. Read each option carefully and eliminate clearly wrong answers.
    • 📋Short-answer questions: You may be asked to explain a term or describe a process. Give a clear, concise answer with an example if possible.
    • 📋Practical tasks: You will be given a scenario and asked to produce a document, spreadsheet, or database. Follow the instructions exactly and save your work in the correct format.
    • 📋Extended response questions: These may ask you to evaluate a situation, such as the pros and cons of using open source software. Structure your answer with points for and against, and a conclusion.
    Command Word Expectations (THE LEARNING MACHINE)
    Explain

    Provide a clear, detailed account of a concept or process, including reasons or causes. For example, 'Explain the purpose of a primary key in a database' – you must state that it uniquely identifies records and why that is important.

    Evaluate

    Consider both strengths and weaknesses of something, then make a judgement. For example, 'Evaluate the use of open source software in a business' – discuss advantages like cost savings and disadvantages like lack of support, then conclude with a reasoned decision.

    Describe

    Give a detailed account of what something is or how it works, without necessarily explaining why. For example, 'Describe the steps to create a mail merge in Word' – list the steps in order.

    How Students Lose Marks (Examiner Pitfalls)
    Pitfall: Students often confuse the terms 'open source' and 'proprietary' software, leading to incorrect answers in questions about software licensing and costs.
    ❌ Weak Answer (Loses Marks):Open source software is free and can be used by anyone.
    Example improved answer:Open source software is software whose source code is made available to the public, allowing users to view, modify, and distribute it, often under a licence like the GNU General Public License. Proprietary software is owned by a company, and users must purchase a licence to use it, with restrictions on modification and redistribution. Examples include Linux (open source) and Microsoft Windows (proprietary).
    Examiner Tip: Always give a definition and an example for each term to secure full marks. Mention that 'free' does not always mean open source – it refers to freedom to modify, not price.
    Pitfall: In spreadsheet tasks, students often lose marks by not using absolute cell references when copying formulas, resulting in incorrect calculations.
    ❌ Weak Answer (Loses Marks):I used the formula =B2*C2 and copied it down, but the answers were wrong.
    Example improved answer:When copying a formula that should always refer to a specific cell, such as a tax rate in cell $B$1, I use an absolute reference like =$B$1*C2. This ensures that when I copy the formula down, the reference to B1 remains fixed, while C2 changes relative to the row.
    Examiner Tip: Practise using F4 to toggle between relative, absolute, and mixed references. In the exam, check that your formulas produce correct results when copied – this is a common source of lost marks.
    Step-by-Step Worked Solutions

    Question: A company has a spreadsheet with sales figures for each month in column B (B2 to B13). In cell C2, they want to calculate the total sales for the year. Write the formula they should use in C2.

    1. 1.Step 1: Identify the range of cells containing the monthly sales figures: B2 to B13.
    2. 2.Step 2: Use the SUM function to add all values in that range: =SUM(B2:B13).
    3. 3.Step 3: Press Enter to display the total.
    Final Answer: =SUM(B2:B13)

    Question: Explain the difference between a primary key and a foreign key in a relational database, and give an example of each.

    1. 1.Step 1: Define a primary key as a unique identifier for each record in a table.
    2. 2.Step 2: Define a foreign key as a field in one table that links to the primary key of another table.
    3. 3.Step 3: Provide an example: In a 'Customers' table, CustomerID is the primary key. In an 'Orders' table, CustomerID is a foreign key that links each order to a customer.
    Final Answer: A primary key uniquely identifies each record in a table (e.g., CustomerID in Customers). A foreign key is a field in a table that matches the primary key of another table to create relationships (e.g., CustomerID in Orders).
    Active Recall Memory Test
    What is the difference between a primary key and a foreign key?
    Key Fact: A primary key uniquely identifies each record in a table; a foreign key is a field in one table that links to the primary key of another table to create a relationship.
    Name three health and safety considerations when using a computer for long periods.
    Key Fact: Adjust chair height to keep feet flat, position monitor at eye level to avoid neck strain, and take regular breaks to prevent eye strain and RSI.
    What does GDPR stand for and what is its main purpose?
    Key Fact: General Data Protection Regulation. It protects the personal data of individuals in the EU/UK and gives them control over how their data is used.
    Give an example of an open source office suite and a proprietary one.
    Key Fact: Open source: LibreOffice. Proprietary: Microsoft Office.
    Frequently Asked Questions
    What is the difference between the TLM Level 2 ITQ and other IT qualifications like GCSE Computer Science?
    The ITQ is a vocational qualification focused on practical IT skills for the workplace, such as using software applications effectively. GCSE Computer Science is more academic, covering programming, algorithms, and computer systems theory. The ITQ is ideal if you want to demonstrate your ability to use IT in a job, while GCSE is better if you want to study computing further.
    Do I need to know how to code for the ITQ Level 2?
    No, coding is not a requirement for the ITQ Level 2. The qualification focuses on using software applications like word processors, spreadsheets, and databases. You will learn how to use these tools to complete tasks, not how to write programs.
    How is the ITQ Level 2 assessed?
    The ITQ is assessed through a portfolio of evidence, which you build up by completing practical tasks. You will be given assignments that simulate real workplace scenarios, and you must produce documents, spreadsheets, presentations, or databases to show your skills. There is no written exam for most units; instead, your work is assessed by your tutor and moderated by the awarding body.
    Can I take the ITQ Level 2 online?
    Yes, many colleges and training providers offer the ITQ Level 2 as an online course. You will need access to a computer with the required software (e.g., Microsoft Office or LibreOffice) and an internet connection. You can complete the coursework at your own pace, but you will have deadlines for submitting your portfolio.
    What jobs can I get with an ITQ Level 2?
    The ITQ Level 2 can help you get entry-level roles such as administrative assistant, data entry clerk, IT support technician, or office manager. It demonstrates that you have the digital skills needed for many office-based jobs. You can also progress to higher-level qualifications like the Level 3 ITQ or an apprenticeship.
    Is the ITQ Level 2 equivalent to a GCSE?
    Yes, the ITQ Level 2 is roughly equivalent to a GCSE at grades A*-C (or 9-4 in the new grading system). It is a Level 2 qualification, so it is recognised as a good standard of achievement for employment or further study.
    Unit assessment details

    Loading assessment details…