logo

Unit SS2: Spreadsheet software

16 Pages2978 Words795 Views
   

Added on  2021-06-22

Unit SS2: Spreadsheet software

   Added on 2021-06-22

ShareRelated Documents
Essential IT Skills (Level 2)Spreadsheet Software Level 2 (Credit value 4)AssessmentUnit SS2: Spreadsheet softwareYou should use this file to complete your Assessment.How to complete and send your assessment:Save a copy of this document, either onto your computer or a diskWork through your Assessment, remembering to save your work regularlyWhen you’ve finished, print out a copy to keep for referenceThen, 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 13 pages and is made up of 6 Parts. © Creating Careers Ltd, 2014. All rights reserved.Page 1 of 16Amended July 2014
Unit SS2: Spreadsheet software_1
Essential IT Skills (Level 2)Spreadsheet Software Level 2 (Credit value 4)AssessmentLearning outcomesThroughout this Assessment, you will meet a number of different learning outcomes and assessment criteria. Take a look at the information below to see which criteria you will meet in which Parts of the Assessment.Learning outcomes & Assessment criteria metPart 1:1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured1.2 Enter and edit numerical and other data accurately1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where availablePart 2:1.1 Identify what numerical and other information is needed in the spreadsheet and how it should be structured1.2 Enter and edit numerical and other data accurately1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available2.2 Select and use a range of appropriate functions and formulas to meet calculation requirements2.3 Use a range of tools and techniques to analyse and manipulate data to meet requirementsPart 3:2.1 Identify which tools and techniques to use to analyse and manipulate data to meet requirements2.2 Select and use a range of appropriate functions and formulas to meet calculation requirements2.3 Use a range of tools and techniques to analyse and manipulate data and meet requirementsPart 4:1.3 Combine and link data across worksheets1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available3.1 Plan how to present and format spreadsheet information effectively to meet needs3.2 Select and use appropriate tools and techniques to format spreadsheet cells, rows, columns and worksheets3.4 Select and use appropriate page layout to present and print spreadsheetsPart 5:1.3 Combine and link data across worksheets1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available3.3 Select and format an appropriate chart or graph type to display selected informationPart 6:1.4 Store and retrieve spreadsheet files effectively, in line with local guidelines and conventions where available3.5 Check information meets needs, using spreadsheet tools and making corrections as necessary3.6 Describe how to find errors in spreadsheet formulas3.7 Respond appropriately to any problems with spreadsheets© Creating Careers Ltd, 2014. All rights reserved.Page 2 of 16Amended July 2014
Unit SS2: Spreadsheet software_2
Essential IT Skills (Level 2)Spreadsheet Software Level 2 (Credit value 4)AssessmentAssessmentScenarioYou work for the Sales department of The Fruit and Veggie People Ltd, a company that sellsorganic, ethically sourced fruit and vegetable boxes. You are responsible for overseeing the production of a spreadsheet that will be used to analyse the summer sales of different fruits.You have been given some initial content for your spreadsheet by the Head of the Sales department to edit and prepare before it is used to analyse future sales strategies. You have been asked to edit and prepare the spreadsheet, analysing the data so that it can be easily interpreted by the rest of the Sales team. © Creating Careers Ltd, 2014. All rights reserved.Page 3 of 16Amended July 2014
Unit SS2: Spreadsheet software_3
Essential IT Skills (Level 2)Spreadsheet Software Level 2 (Credit value 4)AssessmentPart 1: Creating and managing a spreadsheet (1.1, 1.2, 1.4)In this Part of the Assessment, you will need to apply the knowledge you have gained in Session 1 and 2 of your SS2 Unit.You will need to download and save the resource file spreadsheet_content from the Unit Assessment Page to complete this part of the Assessment.1.Save this assessment document as SS2 Assessment in an appropriate location. Take a screenprint of the file saved in this location and paste it in the space below:2.What types of information might be included in a spreadsheet? List at least 4 types of information.Excel spreadsheet is the best way to enter and analyse the numerical data accurately and easily. We can include various types of information in a excel spreadsheet. It can be a numbers, text, images, charts, and hyperlinks. The information is entered in the cells in the spreadsheet.© Creating Careers Ltd, 2014. All rights reserved.Page 4 of 16Amended July 2014
Unit SS2: Spreadsheet software_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
STAT1250 - Business Statistics
|6
|2421
|282

Business Plan- Gusto Cuisine
|8
|1181
|79

SD1420 Introduction to Java Programming Assignment
|98
|10941
|360

Assignment 2: Statistical Techniques for Business Environment
|10
|2655
|460

Assignment 2 for Statistics and Business Analytics
|11
|2975
|163

Data Handling and Business Intelligence Report
|13
|3501
|33