Article thumbnail

DE1V35 IT in Business – Advanced Spreadsheets

By SQA

Abstract

This unit is about developing spreadsheet skills to be able to manage, analyse and forecast data. This unit would be suitable for candidates wishing to be proficient in advanced spreadsheet features and techniques within a numeric working environment. There are three separate outcomes. On completion of the unit, the candidate should be able to: 1. Use a wide range of data management features in a spreadsheet. 2. Use spreadsheet analysis tools. 3. Forecast statistical data using a spreadsheet application. This package contains a zip file of student files (download to extract).

Topics: DE1V35 IT in Business – Advanced Spreadsheets, DE1V 35, correlation, regression, coefficient of determination, scatter diagram, trendline, PivotTable, forecasting, auditing, data validation, SCQF Level 8
Year: 2013
OAI identifier: oai:dspace.jorum.ac.uk:10949/18067
Provided by: Jorum Open
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • http://hdl.handle.net/10949/18... (external link)
  • Suggested articles


    To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.