Spreadsheet Software — WJEC-CBAC Vocationally-Related Qualification Digital Skills & IT Revision

    This unit introduces learners to the basics of spreadsheet software, focusing on entering and editing numerical data accurately. It covers fundamental tool

    Topic Synopsis

    This unit introduces learners to the basics of spreadsheet software, focusing on entering and editing numerical data accurately. It covers fundamental tools such as selecting cells, using simple formulas, and formatting data for clarity. Practical application includes creating basic budgets, simple lists, and performing straightforward calculations to support everyday tasks.

    Key Concepts & Core Principles

    Exam Tips & Revision Strategies

    Common Misconceptions & Mistakes to Avoid

    Examiner Marking Points

    Spreadsheet software

    WJEC-CBAC
    vocational

    This element introduces learners to the fundamental skills of creating and managing spreadsheet data, including accurate data entry, formula construction, and effective presentation. It emphasizes the practical application of spreadsheets for numerical analysis, summarisation, and visual communication of information in a vocational context, ensuring learners can produce professional outputs for business or personal use.

    36
    Learning Outcomes
    54
    Assessment Guidance
    57
    Key Skills
    31
    Key Terms
    62
    Assessment Criteria

    Assessment criteria

    WJEC Level 1 Award for IT Users (ITQ)
    WJEC Entry Level Certificate for IT Users (Entry 1)
    WJEC Entry Level Award for IT Users (Entry 1)
    WJEC Level 1 Certificate for IT Users (ITQ)
    WJEC Entry Level Award for IT Users (Entry 2)
    WJEC Entry Level Certificate for IT Users (Entry 2)
    WJEC Entry Level Certificate for IT Users (Entry 3)
    WJEC Entry Level Award for IT Users (Entry 3)

    Topic Overview

    The WJEC Entry Level Certificate for IT Users (Entry 1) is a foundational qualification designed to introduce students to the basic concepts and practical skills needed to use information technology effectively. This course covers essential topics such as using a computer, creating simple documents, and understanding online safety. It is ideal for students who are new to IT or who need to build confidence before progressing to higher levels.

    This qualification is part of the wider Digital Skills & IT curriculum, which aims to equip students with the digital literacy required for everyday life and future employment. At Entry 1, the focus is on developing basic competence in common IT tasks, such as turning on a computer, using a mouse and keyboard, opening and saving files, and navigating simple software. Students also learn about staying safe online, including the importance of passwords and not sharing personal information.

    Mastering these foundational skills is crucial because IT is now integral to almost every aspect of modern life, from education and work to communication and entertainment. By completing this course, students gain a recognised qualification that demonstrates their ability to use IT safely and effectively, providing a stepping stone to further study or employment opportunities.

    Key Concepts

    Core ideas you must understand for this topic

    • →Basic computer operations: turning on/off, logging in, using a mouse and keyboard, and opening/closing programs.
    • →File management: creating, saving, opening, and deleting files and folders in a simple directory structure.
    • →Simple document creation: using a word processor to type text, change font size/colour, and insert basic images.
    • →Online safety: understanding the need for strong passwords, not sharing personal details, and recognising safe websites.

    Learning Objectives

    What you need to know and understand

    • Enter and edit numerical and other information accurately in spreadsheet cells
    • Apply appropriate formulas and functions to perform calculations and summarise data
    • Utilise spreadsheet tools to format and present information in a clear and professional manner
    • Validate data entry to minimise errors using appropriate techniques
    • Select and create suitable chart types to represent data effectively
    • Enter and edit numerical information using spreadsheets., Use spreadsheet software tools.
    • Enter and edit numerical information using spreadsheets., Use spreadsheet software tools.
    • Enter numerical and text data accurately into designated cells
    • Edit existing cell contents using standard editing techniques
    • Apply simple arithmetic formulas to perform calculations
    • Use summary functions like SUM and AVERAGE to aggregate data
    • Format cells and ranges to enhance readability and professional appearance
    • Enter and edit data accurately into spreadsheet cells, including text, numbers, and dates.
    • Apply basic arithmetic formulas (addition, subtraction, multiplication, division) to perform calculations.
    • Use common functions such as SUM, AVERAGE, MIN, and MAX to summarize data sets.
    • Select appropriate chart types (e.g., bar, pie, line) to display spreadsheet data visually.
    • Apply formatting techniques such as font styles, borders, and number formatting to enhance readability.
    • Organize data using sorting and filtering tools to manage and analyze information effectively.
    • Demonstrate the use of cell referencing (relative and absolute) in formula creation.
    • Produce a well-structured spreadsheet with clear labels, headings, and consistent formatting.
    • Enter and edit text, numbers and dates into spreadsheet cells accurately.
    • Apply basic formulas using arithmetic operators and functions such as SUM, AVERAGE, and COUNT.
    • Format cells and ranges to enhance readability, including alignment, borders, and number formats.
    • Organise data by sorting and filtering to manage and display records effectively.
    • Create simple charts from spreadsheet data to visually represent trends and comparisons.
    • Prepare spreadsheet outputs for printing or sharing, ensuring a professional and clear layout.
    • Use absolute and relative cell references appropriately in formula construction.
    • Utilise data summarisation tools like Subtotals or PivotTables to analyse datasets.
    • SSE:1 Enter and edit numerical and other information using spreadsheets, SSE:2 Use appropriate formulas and tools to summarise and display spreadsheet information, SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively
    • SSE:1 Enter and edit numerical and other information using spreadsheets, SSE:2 Use appropriate formulas and tools to summarise and display spreadsheet information, SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively
    • Enter and edit numerical information using spreadsheets., Use spreadsheet software tools.
    • SSE:1 Enter and edit numerical and other information using spreadsheets, SSE:2 Use appropriate formulas and tools to summarise and display spreadsheet information, SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively
    • Enter and edit numerical information using spreadsheets., Use formulas and tools to summarise spreadsheet information., Use tools and techniques to present spreadsheet information.
    • SSE:1 Enter and edit numerical and other information using spreadsheets, SSE:2 Use appropriate formulas and tools to summarise and display spreadsheet information, SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively
    • Enter and edit numerical information using spreadsheets., Use formulas and tools to summarise spreadsheet information., Use tools and techniques to present spreadsheet information.
    • Use a spreadsheet to enter, edit and organise numerical and other data, Use appropriate formulas and tools to summarise and display spreadsheet information, Select and use appropriate tools and techniques to present spreadsheet information effectively

    Assessment Criteria

    Key criteria assessors look for in your portfolio

    • Award credit for demonstrating accurate data entry with correct cell references and consistent formatting.
    • Credit for selecting and applying appropriate formula (e.g., SUM, AVERAGE) to summarise data accurately.
    • Credit for using formatting tools (borders, alignment, number formats) to enhance readability and professional appearance.
    • Award credit for creating a chart that accurately represents the data with suitable labels, legends and title.
    • Credit for showing an understanding of relative versus absolute cell references when copying formulas.
    • Award credit for demonstrating the ability to select a specific cell and enter numeric data correctly, with minimal errors.
    • Give evidence of editing cell content, such as correcting a typo or updating a figure, using either direct typing or the formula bar.
    • Show competence in using basic spreadsheet tools like AutoSum to add a range of numbers, or changing font size to improve readability.
    • Produce a simple spreadsheet with at least two columns of numbers and one formula-based calculation, printed or saved as evidence.
    • Award credit for demonstrating the ability to enter numerical data into individual cells accurately, with evidence of correct cell navigation.
    • Evidence should clearly show the learner using basic editing functions such as deleting cell contents, using undo/redo, and overwriting data.
    • Look for appropriate use of at least one spreadsheet tool, such as the Autosum button, basic formatting (e.g., bold or number format), or simple sorting, even if guided.
    • Award credit for demonstrated ability to enter data types correctly (e.g., numbers, dates, text) without errors.
    • Credit given for accurate use of basic formulas that produce logically correct outputs.
    • Expect evidence of appropriate formatting choices such as font styling, bolding, borders, and alignment.
    • Look for clear evidence that the learner has checked and corrected any data entry mistakes.
    • Award credit for accurate data entry with minimal errors in cell content.
    • Credit given for correct use of at least two different basic formulas (e.g., =A1+B1, =SUM(B2:B10)).
    • Evidence of applying appropriate number formatting (e.g., currency, percentage, decimal places).
    • Inclusion of a chart with correct data selection and appropriate chart title and axis labels.
    • Demonstration of sorting data alphabetically or numerically as required by the task.
    • Use of borders and shading to distinguish headers from data.
    • Award credit for accurate data entry with appropriate formatting (e.g., currency symbols, percentage signs).
    • Expect correct use of cell references in formulas, including distinguishing relative from absolute references where needed.
    • Look for utilisation of functions like SUM, AVERAGE, MIN, MAX to derive meaningful summaries.
    • Check that charts include essential elements such as titles, axis labels, legends, and appropriate chart type selection.
    • Assess ability to sort data logically and apply filters to extract specific information.
    • Credit effective visual presentation through consistent formatting, clear headings, and adjusted column widths.
    • Award credit for demonstrating the ability to enter numerical and text data into cells accurately, with no more than minor typographical errors.
    • Award credit for successfully editing cell content, including modifying existing entries and using undo/redo functions to correct mistakes.
    • Award credit for correctly selecting and applying simple formulas (e.g., SUM, AVERAGE) to summarise data, with evidence of cell referencing where expected.
    • Award credit for using appropriate presentation tools (e.g., font formatting, borders, alignment) to enhance readability of the spreadsheet.
    • Award credit for creating and labelling a basic chart (e.g., bar chart, pie chart) that accurately represents a given data set.
    • Award credit for accurately entering data into cells, including text, numbers, and dates.
    • Award credit for editing cell content using appropriate methods such as double-clicking, the formula bar, or overwriting.
    • Award credit for correctly applying basic formulas (e.g., =SUM(A1:A5), =AVERAGE(B1:B5)) to perform calculations.
    • Award credit for using autosum and other quick analysis tools to summarise data efficiently.
    • Award credit for applying formatting techniques (e.g., bold, borders, shading, number format) to enhance the clarity of data.
    • Award credit for producing a simple chart (e.g., bar chart, pie chart) from a selected data range, including titles and labels.
    • Award credit for demonstrating the ability to open a spreadsheet application and navigate to a new or existing worksheet.
    • Award credit for accurately entering numerical data into designated cells without typographical errors.
    • Award credit for using basic editing tools such as undo, redo, and delete to correct mistakes.
    • Award credit for applying simple formatting like bold, font size, or cell borders to enhance readability.
    • Award credit for saving the spreadsheet with an appropriate filename and in the correct location.
    • Award credit for demonstrating accurate data entry and editing: evidence should show cells containing both numerical and text data, with no typographical errors, and the ability to modify cell contents (e.g., correcting a value).
    • Award credit for using appropriate formulas and tools: evidence must include at least one basic formula (e.g., =A1+B1) or function (e.g., =SUM) to summarise data, with the formula correctly referencing cells and producing accurate results.
    • Award credit for effective presentation: evidence should show the use of formatting techniques such as bold, borders, or alignment to improve readability, and the spreadsheet data should be laid out in a logical manner.
    • Award credit for demonstrating the ability to enter numerical data into cells without errors and edit cell contents (e.g., changing a value).
    • Award credit for correctly using a simple formula (e.g., =SUM) to total a range of cells, with accurate results shown in the spreadsheet.
    • Award credit for applying at least two formatting techniques (e.g., bold text, currency format, borders) to enhance the presentation of spreadsheet data.
    • Enter and edit data accurately in a spreadsheet.
    • Use formulas such as SUM, AVERAGE, and COUNT.
    • Create charts or graphs to display data.
    • Format cells and apply appropriate presentation tools.
    • Award credit for accurately entering numerical data into correctly identified cells, with attention to consistent data types.
    • Award credit for demonstrating the use of basic arithmetic formulas (e.g., using cell references to add, subtract) to derive new values.
    • Award credit for employing simple summary functions like SUM or AVERAGE via the formula bar or AutoSum button.
    • Award credit for applying appropriate formatting tools (e.g., bold headers, currency style, borders) to improve readability.
    • Award credit for creating a simple chart (e.g., bar or pie) from a selected data range, with clear labels and a title.
    • Award credit for accurate data entry with appropriate cell formatting (e.g., currency, date, text alignment).
    • Credit correct application of basic formulas (e.g., SUM, AVERAGE) and functions to summarise data accurately.
    • Look for effective use of presentation tools such as charts, conditional formatting, or sorting to enhance data clarity.

    Assessment Guidance

    Guidance for achieving higher grades

    • 💡Always double-check cell references before copying formulas to avoid propagation of errors.
    • 💡When presenting data, ensure charts have clear titles, axis labels, and legends to meet assessment criteria for interpretation.
    • 💡Use cell formatting to distinguish headers from data, and apply consistent number formats (e.g., currency, decimal places) to enhance clarity.
    • 💡Always double-check that numbers are in the correct cells before applying any formulas.
    • 💡Use the Undo button if you make a mistake, and practise using simple formulas like SUM so they become second nature.
    • 💡For the assessment, read instructions carefully to ensure you use the specific tool requested, e.g., 'AutoSum' not manual addition.
    • 💡Keep your spreadsheet tidy by using clear headings and formatting numbers consistently (e.g., two decimal places) to demonstrate professional presentation.
    • 💡Always double-check numerical entries for accuracy, as even small errors can undermine the evidence of competence; use the formula bar to review cell contents.
    • 💡Practise using clearly labelled rows and columns (e.g., 'Item', 'Cost') to structure data logically, which demonstrates an understanding of spreadsheet organisation.
    • 💡Always begin with a plan: identify the required data, formulas, and final layout before starting.
    • 💡Use the 'print preview' function to check how the final spreadsheet will appear on paper.
    • 💡Double-check all formula ranges, especially when copying formulas across rows or columns.
    • 💡Practice on sample datasets to become comfortable with common tasks and avoid last-minute errors.
    • 💡Always check your formulas by manually calculating a few results to ensure accuracy.
    • 💡Use the 'Undo' feature (Ctrl+Z) to quickly correct mistakes without restarting.
    • 💡Before starting the assessment, plan your spreadsheet layout on paper to ensure logical structure.
    • 💡Label your worksheets clearly and use meaningful file names when saving your work.
    • 💡Practice creating a variety of chart types to choose the most effective one for your data.
    • 💡Always test your formulas with simple data to verify they return expected results before finalising.
    • 💡Use print preview to check page layout and ensure all data fits on the printed page as intended.
    • 💡Label all charts clearly and add data labels if it improves readability for the assessor.
    • 💡Save your work regularly and use descriptive filenames to keep track of versions.
    • 💡Practise common functions until you can apply them quickly, as time management is crucial in assessments.
    • 💡Read the assignment brief carefully to identify which specific formulas or presentation features are required.
    • 💡Always double-check that formulas reference the correct cells; use the formula bar to verify before finalising.
    • 💡When presenting data in a chart, add clear titles and axis labels to demonstrate effective communication of information.
    • 💡Practise using shortcut keys (e.g., Ctrl+Z for undo, Ctrl+S for save) to improve efficiency during timed assessments.
    • 💡Review the difference between relative and absolute cell referencing—if it appears in the learning, it's likely to be assessed in advanced tasks.
    • 💡In assignment tasks that require summarising, often a simple SUM or AVERAGE will suffice; avoid overcomplicating with advanced functions unless explicitly required.
    • 💡Always check that numerical data is right-aligned in cells; left-aligned numbers may be stored as text and can cause formula errors.
    • 💡Use cell references in formulas rather than typing actual values to make the spreadsheet dynamic and easier to update.
    • 💡Preview the spreadsheet in print layout before finalising to ensure all data fits on the page and is clearly visible.
    • 💡When creating charts, select only the necessary data and ensure axes are labelled appropriately for the intended audience.
    • 💡Practice using the 'Undo' feature (Ctrl+Z) to quickly correct mistakes without starting over.
    • 💡Always double-check cell references before entering or editing data to ensure accuracy.
    • 💡Utilise the undo function (Ctrl+Z) immediately after making a mistake to quickly revert changes.
    • 💡Present data clearly by using simple formatting tools, such as bold headings, to make the spreadsheet easy to assess.
    • 💡Save your work frequently and maintain at least one backup copy to prevent loss of evidence.
    • 💡Always double-check your data entries and formula ranges to ensure accuracy before submitting your evidence.
    • 💡Use spreadsheet formatting consistently (e.g., bold headings, currency symbols) to make your work easy to read and meet presentation criteria.
    • 💡Provide screenshots as evidence showing both raw data and the final presented spreadsheet, ensuring formulas are visible in the formula bar.
    • 💡Label your data clearly with headings and use consistent formatting to make your spreadsheet easy to understand for the assessor.
    • 💡Double-check that your charts have titles and labels for axes where appropriate, as this demonstrates effective presentation techniques.
    • 💡Practise using basic formulas and functions.
    • 💡Learn how to create and format charts.
    • 💡Check data entry for accuracy before using formulas.
    • 💡Always begin by planning your spreadsheet layout on paper, ensuring you understand which data goes where before entering anything.
    • 💡Use the AutoSum tool (Σ) rather than typing SUM formula syntax manually—it reduces errors and is quicker.
    • 💡Apply cell formatting early to distinguish headers from data; this makes the spreadsheet easier to read for both you and the assessor.
    • 💡When creating charts, highlight only the necessary data range and choose a chart type that clearly represents the information, then add descriptive titles and axis labels.
    • 💡Double-check all totals and calculations with a quick manual estimate to ensure your formulas are working as intended.
    • 💡Always label chart axes and titles clearly; unlabelled charts are a common reason for lost marks.
    • 💡Double-check formula ranges to ensure all required data is included before finalising the spreadsheet.
    • 💡Practise with sample datasets to become fluent in common tasks like creating a chart from a table or applying filters.
    • 💡Practise using the mouse to click, double-click, and drag items. Many tasks in the assessment require precise mouse control, so spend time on this skill.
    • 💡When creating documents, always check your spelling and layout before finishing. Simple mistakes like missing capital letters or messy alignment can lose marks.
    • 💡For online safety questions, remember the key rule: never share your full name, address, phone number, or school name online without a trusted adult's permission.

    Common Mistakes

    Common errors to avoid in your coursework

    • Mistaking absolute and relative cell references leading to incorrect formula replication across cells.
    • Selecting inappropriate chart types that misrepresent data, such as using a pie chart for trends over time.
    • Overlooking data validation and consistency, resulting in entry errors and unreliable outputs.
    • Confusing rows and columns when entering data, leading to misplaced values.
    • Forgetting to press Enter or clicking another cell before finishing data entry, causing the input to be lost.
    • Typing letters or symbols into cells intended for numbers, which can cause formula errors.
    • Not saving the spreadsheet file, resulting in lost work and no evidence for assessment.
    • Learners often confuse rows and columns, leading to disorganised data entry and difficulty in referencing cells.
    • A frequent error is forgetting to press Enter or Tab to confirm a cell entry, resulting in incomplete data or accidental deletion.
    • Students may accidentally overwrite existing data by clicking a cell and typing without first using the formula bar or double-clicking to edit.
    • Inconsistent data entry leading to sorting or formula errors.
    • Misunderstanding formula syntax (e.g., missing equals sign, incorrect cell references).
    • Overusing decorative elements that detract from readability.
    • Failing to label data, making it unclear for other users.
    • Misunderstanding of absolute vs. relative cell references, leading to incorrect copied formulas.
    • Selecting incorrect data ranges for formulas or charts, resulting in inaccurate results.
    • Forgetting to save work regularly, leading to data loss.
    • Over-formatting spreadsheets with excessive colours and fonts, reducing professional appearance.
    • Entering numbers as text, which prevents them from being used in calculations.
    • Confusing absolute and relative cell references, leading to incorrect results when formulas are copied.
    • Forgetting to adjust column widths to fully display cell contents, especially long text or numbers.
    • Using an inappropriate chart type for the data, such as a pie chart for time series data.
    • Overlooking consistent number formatting, causing misalignment of decimal places or currency symbols.
    • Forgetting to save work frequently, risking loss of unsaved changes.
    • Inconsistent data entry, such as mixing date formats or including extra spaces, which hinders sorting and filtering.
    • Learners often confuse cell references with literal values when constructing formulas, e.g., typing '=SUM(10+20)' instead of referencing cells.
    • Misalignment of data: entering numbers as text (e.g., preceded by an apostrophe) can prevent formulas from working correctly.
    • Selecting inappropriate chart types for the data, such as a pie chart for data that does not represent parts of a whole.
    • Neglecting to adjust column widths to display all content, leading to truncated data or ###### errors.
    • Forgetting to save work regularly, resulting in lost progress if the software closes unexpectedly.
    • Entering numbers as text (e.g., with an apostrophe before the number), causing formulas to exclude them from calculations.
    • Selecting incorrect cell ranges in formulas, leading to inaccurate totals or averages.
    • Forgetting to use the equals sign at the start of a formula, which results in the expression being treated as text.
    • Overlapping data in adjacent cells due to insufficient column width, making the spreadsheet difficult to read.
    • Creating a chart from non-adjacent or incorrectly highlighted data, resulting in a misleading representation.
    • Neglecting to save work regularly, leading to loss of data if the application crashes.
    • Confusing cell references: learners often input data into the wrong cell, mistaking rows for columns.
    • Overlooking the importance of data validation: entering text where numbers are required, leading to calculation errors.
    • Forgetting to save work regularly, resulting in data loss.
    • Using inconsistent number formats (e.g., mixing currency and general formats without intention).
    • Typing numbers as text, which prevents formulas from calculating correctly.
    • Forgetting to start formulas with an equals sign (=), resulting in the formula being interpreted as plain text.
    • Selecting the wrong cell range when using functions like SUM, leading to incomplete or incorrect totals.
    • Misunderstanding cell references, leading to incorrect formula ranges (e.g., =SUM(A1:A3) missing A4).
    • Failing to format numbers as currency or percentage, causing confusion when presenting financial or statistical data.
    • Selecting incorrect data ranges when creating a chart, resulting in a chart that does not represent the intended information.
    • Incorrect cell references in formulas.
    • Not selecting the correct chart type for data.
    • Forgetting to save work regularly.
    • Inserting numbers as text, causing errors in calculations and making summarisation impossible.
    • Using incorrect cell references in formulas, leading to inaccurate results or circular references.
    • Forgetting to anchor cell references when copying formulas, which can distort intended calculations.
    • Over-complicating tasks by attempting to use advanced functions instead of simpler, more reliable methods.
    • Neglecting to proofread the data entered, resulting in typographical errors that affect all subsequent outputs.
    • Misplacing data in incorrect cells or rows, causing formula errors or misrepresentation.
    • Using incorrect cell references (e.g., absolute vs. relative) when copying formulas across cells.
    • Selecting an inappropriate chart type that fails to clearly convey the intended data comparison or trend.
    • Misconception: 'You don't need to save your work because the computer does it automatically.' Correction: Most programs do not auto-save; you must manually save your work regularly to avoid losing it.
    • Misconception: 'A strong password is just a long word.' Correction: A strong password includes a mix of letters, numbers, and symbols, and should not be a dictionary word or easily guessed information like your name.
    • Misconception: 'If a website looks professional, it is safe.' Correction: Scammers can create convincing fake websites. Always check for a padlock icon in the address bar and think before entering personal information.

    Frequently Asked Questions

    Common questions students ask about this topic

    Before You Start

    Prior knowledge that will help with this topic

    • •No formal prerequisites are required for this Entry 1 qualification. However, basic familiarity with using a computer (e.g., turning it on and using a mouse) is helpful.

    Key Terminology

    Essential terms to know

    • Accurate Data Entry
    • Formula and Function Use
    • Data Summarisation
    • Effective Visual Presentation
    • Enter and edit numerical information using spreadsheets., Use spreadsheet software tools.
    • Enter and edit numerical information using spreadsheets., Use spreadsheet software tools.
    • Data Entry and Editing
    • Formula Construction
    • Data Summarisation
    • Effective Presentation
    • Spreadsheet Formatting
    • Data entry and editing
    • Basic formula construction
    • Data summarization with functions
    • Visual data display
    • Spreadsheet formatting for clarity
    • Appropriate tool selection
    • Data entry and editing
    • Formula and basic functions
    • Data organisation and sorting
    • Charts and visual presentation
    • Spreadsheet formatting
    • Summarising and analysing data
    • SSE:1 Enter and edit numerical and other information using spreadsheets, SSE:2 Use appropriate formulas and tools to summarise and display spreadsheet information, SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively
    • SSE:1 Enter and edit numerical and other information using spreadsheets, SSE:2 Use appropriate formulas and tools to summarise and display spreadsheet information, SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively
    • Enter and edit numerical information using spreadsheets., Use spreadsheet software tools.
    • SSE:1 Enter and edit numerical and other information using spreadsheets, SSE:2 Use appropriate formulas and tools to summarise and display spreadsheet information, SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively
    • Enter and edit numerical information using spreadsheets., Use formulas and tools to summarise spreadsheet information., Use tools and techniques to present spreadsheet information.
    • SSE:1 Enter and edit numerical and other information using spreadsheets, SSE:2 Use appropriate formulas and tools to summarise and display spreadsheet information, SSE:3 Use appropriate tools and techniques to present spreadsheet information effectively
    • Enter and edit numerical information using spreadsheets., Use formulas and tools to summarise spreadsheet information., Use tools and techniques to present spreadsheet information.
    • Use a spreadsheet to enter, edit and organise numerical and other data, Use appropriate formulas and tools to summarise and display spreadsheet information, Select and use appropriate tools and techniques to present spreadsheet information effectively

    Ready to learn?

    AI-powered learning tailored to this unit

    Related Topics in WJEC-CBAC vocational Digital Skills & IT

    Data Quality

    View Topic

    Data, Information and Knowledge

    View Topic

    Databases

    View Topic

    Emerging Technologies

    View Topic