Using Spreadsheets in Supply Chain Logistics — Open Awards Vocational Warehousing & Logistics
Learning outcomes
- Use a spreadsheet to enter, edit and organise numerical and other data 1.
- Identify what numerical and other information is needed in the spreadsheet and how it should be structured 1.
- Enter numerical and other data accurately 1.
Show all 20 objectives
- Edit numerical and other data to meet needs 1.
- Combine data across worksheets 1.
- Create links in data across worksheets 1.
- Store spreadsheet files effectively, in line with local guidelines and conventions where available 1.
- Retrieve spreadsheet files effectively, in line with local guidelines and conventions where available
- Select and use appropriate formulas and data analysis tools to meet requirements 2.
- Identify tools and techniques to analyse and manipulate data to meet requirements 2.
- Use a range of appropriate functions and formulas to meet calculation requirements 2.
- Use a range of tools and techniques to analyse and manipulate data to meet requirements
- Select and use tools and techniques to present and format spreadsheet information 3.
- Plan how to present and format spreadsheet information effectively to meet needs 3.
- Use appropriate tools and techniques to format spreadsheet cells, row, columns and worksheets 3.
- Format an appropriate chart or graph type to display selected information 3.
- Use appropriate page layout to present and print spreadsheet information 3.
- Check information meets needs, using spreadsheet tools 3.
- Make correction to information in the spreadsheet as appropriate 3.
- Describe how to find errors in spreadsheet formulas 3.
Using Spreadsheets in Supply Chain Logistics assessment help
Unit assessment details
Loading assessment details…