DE1V35 IT in Business – Advanced Spreadsheets

SQA

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)

DE1V35 IT in Business – Advanced Spreadsheets

Abstract

Suggested articles