You should use this file to complete your Assessment.
• The first thing you need to do is save a copy of this document, either onto your computer or a disk • Then work through your Assessment, remembering to save your work regularly • When you’ve finished, print out a copy to keep for reference • Then, go to www.vision2learn.com and send your completed Assessment to your tutor via your My Study area – make sure it is clearly marked with your name, the course title and the Unit and Assessment number.
Please note that this assessment document has 9 pages and is made up of 6 Parts.
Name: Alvaro Estrada
Achieving your qualification
In order to achieve your Level 2 ITQ Certificate in IT User Skills qualification, you will need to demonstrate to your tutor that you can meet all of the learning outcomes for this Unit.
By completing this Assessment, you will cover the following learning outcomes:
The learner will…
1. Use a spreadsheet to enter, edit and organise numerical and other data 2. Select and use appropriate formulas and data analysis tools to meet requirements 3. Select and use tools and techniques to present and format spreadsheet information
You will also satisfy the following assessment criteria:
The learner can…
1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured 1.2 Enter and edit numerical and other data accurately
1.3 Combine and link data across worksheets
1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available
2.1 Identify which tools and techniques to use to analyse and manipulate data to meet requirements 2.2 Select and use a range of appropriate functions and formulas to meet calculation requirements 2.3 Use a range of tools and techniques to analyse and manipulate data to meet requirements
3.1 Plan how to present and format spreadsheet information effectively to meet needs 3.2 Select and use appropriate tools and techniques to format spreadsheet cells, rows, columns and worksheets 3.3 Select and format an appropriate chart or graph type to display selected information 3.4 Select and use appropriate page layout to present and print spreadsheet information 3.5 Check information meets needs, using spreadsheet tools and making corrections as necessary 3.6 Describe how to find errors in spreadsheet formulas
3.7 Respond appropriately to any problems with spreadsheets
The references in brackets below show you where these criteria are covered.
You work in a newsagents’ shop. Your boss has asked you to analyse the sales of chocolate bars using a spreadsheet.
Part A (B1.1, B1.2, B2.1, B2.3, B1.4)
1. Open Excel to create a spreadsheet about chocolate bar sales. The spreadsheet should contain the following data:
• Price of the chocolate bars
• Shelf location in the shop
• Sales of each chocolate bar for January
• Sales of each chocolate bar for February
Use the information below to create the spreadsheet.
Chocolate bar data
Chocolate bar prices:
Mars: 0.58, Dairy Milk: 0.65, Double Decker: 0.66, Twix: 0.53, Caramel: 0.55, Snickers: 0.57, Boost: 0.71, Bounty: 0.35, Aero: 0.68, Wispa: 0.65, Milky bar: 0.40, Yorkie; 0.70, Galaxy: 0.67, Lion bar: 0.65, Rolo: 0.63.
Shelf location in the shop
Shelf one: Snickers, Mars, Galaxy, Yorkie
Shelf two: Dairy Milk, Caramel, Boost, Rolo, Bounty
Shelf three: Twix, Milky bar, Aero, Double Decker, Lion Bar, Wispa
January chocolate bar sales volume:
|Mars |54 |
|Dairy Milk |36 |
|Double Decker |30 |
|Twix |24 |
|Caramel |48 |