п»їUnit SS2: Spreadsheet application
You should use this file to complete your Assessment.
Tips on how to complete and send the assessment:
Conserve a copy of this document, both onto your pc or a disk Work through your Assessment, remembering to save your work regularly The moment you've completed, print out a duplicate to keep intended for reference After that, go to www.vision2learn.com and give your finished Assessment on your tutor by means of your My own Study location вЂ“ ensure it is plainly marked together with your name, the course subject and the Product and Examination number.
You should be aware that this Analysis document offers 13 web pages and is composed of 6 Parts.
Through this Assessment, you will meet a number of different learning outcomes and assessment conditions. Take a look at the knowledge below to find out which requirements you will fulfill in which Regions of the Evaluation.
Learning effects & Analysis criteria met
1 . you Identify what numerical and also other information is needed in the spreadsheet and how it should be structured 1 . 2 Enter in and modify numerical and also other data effectively
1 . 4 Store and retrieve schedule files effectively, in line with community guidelines and conventions exactly where available
1 ) 1 Recognize what statistical and other information is needed in the spreadsheet and exactly how it should be structured 1 . two Enter and edit statistical and other info accurately
1 ) 4 Retail store and obtain spreadsheet documents effectively, in accordance with local rules and exhibitions where obtainable 2 . 2 Select and use a variety of appropriate capabilities and formulas to meet calculation requirements installment payments on your 3 Make use of a range of equipment and methods to analyse and manipulate info to meet requirements
Part a few:
2 . 1 Identify which in turn tools and techniques to use to analyse and manipulate info to meet requirements 2 . 2 Select and use a selection of appropriate capabilities and formulations to meet computation requirements installment payments on your 3 Use a range of tools and processes to analyse and manipulate data and meet requirements
1 . 3 Incorporate and website link data across worksheets
1 ) 4 Retail store and retrieve spreadsheet documents effectively, in line with local rules and events where obtainable 3. 1 Plan the right way to present and format spreadsheet information properly to meet requires 3. a couple of Select and use suitable tools and techniques to file format spreadsheet cells, rows, columns and worksheets 3. four Select and use appropriate page design to present and print spreadsheets
Part a few:
1 . three or more Combine and link data across worksheets
1 . four Store and retrieve schedule files successfully, in line with community guidelines and conventions in which available a few. 3 Select and structure an appropriate data or graph type to show off selected info
1 . some Store and retrieve schedule files effectively, in line with community guidelines and conventions exactly where available a few. 5 Verify information satisfies needs, employing spreadsheet equipment and making corrections as necessary 3. 6 Describe how to locate errors in spreadsheet formulas
3. 7 Respond properly to any problems with spreadsheets
You work for the Sales department of The Fresh fruit and Vegetable People Limited, a company that sells organic, ethically procured fruit and vegetable packing containers. You are in charge of for managing the production of the spreadsheet that is to be used to evaluate the summer sales of different fruits.
You have received some first content to your spreadsheet by Head with the Sales office to edit and make before it truly is used to review future revenue strategies.
You have been asked to edit and prepare the spreadsheet, analysing the data in order that it can be quickly interpreted by the rest of the Sales force.
Part 1: Creating and managing a spreadsheet
(1. you, 1 . a couple of, 1 . 4)
In this Part of the Assessment, you will need to apply the knowledge you have gained in Program 1 and 2 of the SS2 Product.
You will need to download and conserve the source file spreadsheet_content from the Device Assessment Web page to finish this...