Social Media
This element explores the dual nature of social media, examining both the potential benefits—such as enhanced communication, marketing reach, and collaboration—and the associated risks including privacy breaches, misinformation, and reputational damage. It also covers practical applications across personal, educational, and business contexts, enabling learners to critically evaluate and effectively utilise various platforms.
Assessment criteria
Quick Revision Summary (Key Takeaway)
The OCN NI Level 2 Award in Information Technology Applications covers practical digital skills including word processing, spreadsheets, databases, presentations, and safe internet use. This qualification focuses on applying IT tools to real-world tasks, preparing students for further study or employment in digital environments.
Topic Overview
The OCN NI Level 2 Award in Information Technology Applications is designed to equip students with practical skills in using common software applications. It covers word processing, spreadsheets, databases, presentations, and safe internet practices. These skills are essential in almost every modern workplace, from creating reports to managing data.
The qualification emphasizes hands-on application rather than theory alone. Students learn to produce professional documents, analyse data using formulas and charts, design relational databases, and deliver effective presentations. It also covers legal and ethical issues around IT use, such as data protection and copyright.
This award is part of the wider Digital Skills & IT curriculum, providing a foundation for further study in IT or for entering the workforce. It is assessed through practical tasks and written exams, testing both technical ability and understanding of concepts. Mastery of these applications is not only examinable but also directly transferable to real-life scenarios.
Key Concepts
Core ideas you must understand for this topic
- →Word processing: formatting text, inserting images, using styles, mail merge.
- →Spreadsheets: formulas, functions (SUM, AVERAGE, IF), absolute and relative references, charts.
- →Databases: tables, records, fields, primary keys, queries, forms, reports.
- →Presentations: slide design, transitions, animations, embedding media.
- →Safe internet use: protecting personal data, recognising phishing, respecting copyright.
Learning Objectives
What you need to know and understand
- Understand the opportunities and threats associated with using social media., Understand the application of social media.
- Understand the opportunities and threats associated with using social media., Understand the application of social media.
Assessment Criteria
Key criteria assessors look for in your portfolio
- Award credit for accurately identifying at least two distinct types of social media platforms (e.g., social networking, media sharing, microblogging) and explaining their primary functions with examples.
- Credit should be given when learners articulate specific opportunities of social media use, such as increased brand awareness or enhanced customer engagement, supported by relevant real-world case studies or statistics.
- Expect learners to demonstrate understanding of threats by describing a realistic scenario where social media misuse led to negative consequences (e.g., cyberbullying, data breach), citing authoritative sources to strengthen the analysis.
- Credit for evaluating the role of social media policies and data protection legislation (e.g., GDPR) in mitigating risks within an organisational context, showing awareness of compliance requirements.
- Award credit for demonstrating a clear understanding of at least two distinct opportunities (e.g., networking, marketing, collaboration) and two threats (e.g., data security, reputation damage) with relevant examples.
- Credit should be given for evidence of applying social media in a practical scenario, such as creating a simple plan for a small business or community group that includes platform choice, target audience, and purpose.
- Assessors should look for the ability to evaluate the suitability of different social media platforms (e.g., LinkedIn vs. Instagram) for specific purposes, with justification linked to features and user demographics.
Assessment Guidance
Guidance for achieving higher grades
- 💡Use the PEE (Point, Evidence, Explanation) structure when discussing opportunities and threats to ensure your arguments are clear, well-supported, and analytical.
- 💡When describing applications, always link back to the platform's core functionality and the intended audience, demonstrating practical understanding.
- 💡Reference current, credible examples and up-to-date statistics to strengthen your points, as assessors value contemporary relevance and research depth.
- 💡For high marks, show critical thinking by comparing different social media tools and justifying which is most suitable for a given scenario, considering both benefits and limitations.
- 💡When answering questions, always link opportunities or threats to specific, named platforms and real-world consequences to show depth of understanding.
- 💡For application tasks, structure your response using a recognised framework (e.g., SMART objectives) to demonstrate strategic planning rather than ad hoc use.
- 💡Use recent examples (within the last two years) to illustrate social media trends and threats, as this demonstrates current awareness expected at Level 2.
- 💡Always read the question carefully to identify the exact software feature being tested. For example, if it says 'use a formula to calculate the average', do not just write the answer manually.
- 💡In practical exams, save your work regularly and check that your file is in the correct location. Losing work due to not saving is a common avoidable mistake.
- 💡When answering theory questions, use correct terminology (e.g., 'field', 'record', 'query') to show your understanding and gain full marks.
Common Mistakes
Common errors to avoid in your coursework
- Confusing personal social media use with professional applications, failing to consider context, audience, and appropriate tone.
- Listing threats without explaining their potential impact on individuals or organisations, resulting in superficial responses.
- Overlooking the importance of privacy settings and consent when discussing data sharing, leading to incomplete risk assessments.
- Providing generic descriptions of platforms without linking features to specific business or communication objectives.
- Conflating personal social media use with professional application, failing to distinguish between casual posting and strategic content management.
- Overlooking legal and ethical considerations such as copyright, data protection, and terms of service when discussing opportunities or creating application plans.
- Providing only theoretical knowledge without practical examples or case studies, which weakens the demonstration of application understanding.
- Misconception: Spreadsheets and databases are the same. Correction: Spreadsheets are for calculations and data analysis, while databases are for storing and retrieving structured data efficiently.
- Misconception: The internet is always safe if you use a password. Correction: Passwords are just one layer; you must also be aware of phishing, malware, and sharing personal information.
- Misconception: In a presentation, more animations and transitions make it better. Correction: Overuse can distract; effective presentations use them sparingly to enhance understanding.
Revision Plan
How to revise this topic in 1–2 weeks
- 1Week 1: Focus on word processing and presentations. Practice formatting documents and creating slides. Learn keyboard shortcuts.
- 2Week 2: Move to spreadsheets. Master formulas, functions, and charts. Practice creating a budget spreadsheet.
- 3Week 3: Study databases. Understand tables, relationships, and queries. Create a simple database for a library.
- 4Week 4: Review all topics, attempt past papers, and focus on weak areas. Practice time management in mock exams.
Exam Question Types
How this topic typically appears in the exam
- 📋Multiple-choice questions: Test knowledge of software features and concepts. Read each option carefully; eliminate obviously wrong answers.
- 📋Short-answer questions: Require one or two sentences. Use correct terminology and be concise.
- 📋Practical tasks: You will be given a scenario and asked to produce a document, spreadsheet, or database. Follow instructions precisely and save your work.
- 📋Extended writing: For example, 'Evaluate the use of spreadsheets versus databases for managing customer data.' Structure your answer with an introduction, points for and against, and a conclusion.
Command Word Expectations (OPEN COLLEGE NETWORK NORTHERN IRELAND)
What examiners look for when using specific command words in this specification
Give a detailed account of the features or steps involved. For example, 'Describe how to insert a header in a word processor.' You must mention the specific menu options and steps.
Give reasons or causes. For example, 'Explain why a database is better than a spreadsheet for storing customer records.' You need to provide logical reasoning, not just a description.
Weigh up the pros and cons and come to a justified conclusion. For example, 'Evaluate the use of cloud storage versus local storage for a small business.' You must consider both sides and give a balanced judgement.
How Students Lose Marks (Examiner Pitfalls)
Common mark loss traps and how to write 100% full-mark answers
Step-by-Step Worked Solutions
Detailed solution breakdown for typical exam problems
Question: A student is creating a spreadsheet to track monthly expenses. They have amounts in cells B2 to B13 and want to calculate the total in cell B14. Write the formula they should use and explain how to make it show the result as currency.
- 1.Step 1: Identify the range of cells containing the expenses: B2 to B13.
- 2.Step 2: Use the SUM function: =SUM(B2:B13).
- 3.Step 3: To display as currency, select cell B14, go to Format Cells, choose Currency, and set decimal places to 2.
Question: Explain the difference between a primary key and a foreign key in a relational database, and give an example of each.
- 1.Step 1: Define primary key: a unique identifier for each record in a table.
- 2.Step 2: Define foreign key: a field in one table that refers to the primary key in another table, creating a relationship.
- 3.Step 3: Example: In a Customers table, CustomerID is the primary key. In an Orders table, CustomerID is a foreign key linking each order to a customer.
Active Recall Memory Test
Test your memory before revealing the key facts
Frequently Asked Questions
Common questions students ask about this topic
Pass / Merit / Distinction Evidence Checklist
How your portfolio evidence is graded for OPEN COLLEGE NETWORK NORTHERN IRELAND Social Media
Every vocational unit is marked against named criteria rather than an exam percentage. Your tutor's brief lists the exact codes for this unit — here is what each band is asking you to do.
Demonstrate baseline knowledge, accurate terminology, and core practical application.
Provide detailed analysis, structured explanations, and clear workplace reasoning.
Deliver thorough evaluation, original problem solving, and fully justified recommendations.
Before You Start
Prior knowledge that will help with this topic
- •Basic computer literacy: using a mouse, keyboard, and file management.
- •Understanding of common file types (e.g., .docx, .xlsx, .pptx).
- •Familiarity with using the internet for research.
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- Understand the opportunities and threats associated with using social media., Understand the application of social media.
- Understand the opportunities and threats associated with using social media., Understand the application of social media.
Ready to learn?
AI-powered learning tailored to this unit