Name: BYS [INT1010] - PDA IT in Business L7 (Excel)
SKU: 2903
Price: 75.00 GBP
Availability: InStock

BYS [INT1010] – PDA IT in Business L7 (Excel)

£75.00

The Professional Development Award (PDA) in Information Technology in Business at SCQF level 7 delivers the skills and knowledge needed for a range of administrative roles. It has particular emphasis on the use of IT within a business environment. This pack focusses on the Excel element of the award and includes 5 design tasks.

Description

This pack has plenty of practice in all things Excel for the PDA in Business L7 qualification.

It covers Outcome 1 including; formatting, layout, sorting, formulas and functions, conditional formatting, sparklines, worksheet protection, workbook protection and macros. Outcome 2 is also covered with a variety of tasks on statistical functions (mean, median and mode), frequency distribution tables, standard deviation and pivot tables. There’s plenty of practice with graphs that covers Outcome 3 including combo charts, sparklines, call outs, sunburst, pie of pie and much more. There are 5 design tasks at the end that consolidates many of the topics covered in the Outcomes.

Instructions are all onscreen although tasks can be printed off and suggested solutions are included.

With over 60 spreadsheets to work on / design, the price reflects the size of this resource.