Skip to topic
    ← Back to course topics

    Using Spreadsheets in Supply Chain Logistics — Open Awards Vocational Warehousing & Logistics

    Learning outcomes

    1. Use a spreadsheet to enter, edit and organise numerical and other data 1.
    2. Identify what numerical and other information is needed in the spreadsheet and how it should be structured 1.
    3. Enter numerical and other data accurately 1.
    Show all 20 objectives
    1. Edit numerical and other data to meet needs 1.
    2. Combine data across worksheets 1.
    3. Create links in data across worksheets 1.
    4. Store spreadsheet files effectively, in line with local guidelines and conventions where available 1.
    5. Retrieve spreadsheet files effectively, in line with local guidelines and conventions where available
    6. Select and use appropriate formulas and data analysis tools to meet requirements 2.
    7. Identify tools and techniques to analyse and manipulate data to meet requirements 2.
    8. Use a range of appropriate functions and formulas to meet calculation requirements 2.
    9. Use a range of tools and techniques to analyse and manipulate data to meet requirements
    10. Select and use tools and techniques to present and format spreadsheet information 3.
    11. Plan how to present and format spreadsheet information effectively to meet needs 3.
    12. Use appropriate tools and techniques to format spreadsheet cells, row, columns and worksheets 3.
    13. Format an appropriate chart or graph type to display selected information 3.
    14. Use appropriate page layout to present and print spreadsheet information 3.
    15. Check information meets needs, using spreadsheet tools 3.
    16. Make correction to information in the spreadsheet as appropriate 3.
    17. Describe how to find errors in spreadsheet formulas 3.

    Using Spreadsheets in Supply Chain Logistics assessment help

    Unit assessment details

    Loading assessment details…