Topic 2D: Data and Presenting Information: Reports & Spreadsheets

Question 1

What is the purpose of a report?

Answer 1

To initiate a decision or action by readers of the report.

Question 2

What are the two types that reports may be?

Answer 2

Control actions
Planning decisions

Question 3

What are the likely contents of reports?

Answer 3

Information
Narrative or description
Analysis
Evaluation

Question 4

What is the difference between a report being routine or not routine?

Answer 4

Routine reports include budgetary control reports, sales reports or progress reports while non routine reports include market research reports

Question 5

What does the format of a report depend on?

Answer 5

Depends on who the report is for

Question 6

What are the likely contents of reports?

Answer 6

Information
Narrative or description
Analysis
Evaluation

Question 7

What does the format of a report depend on?

Answer 7

Depends on who the report is for

Question 8

What might a short formal report incude?

Answer 8

Terms of reference of information

Procedure or method

Findings

Conclusions

Recommendations

Question 9

What is data visualisation?

Answer 9

The process of presenting report formats that represent data and information in a pictorial or graphical format that helps the receipient to understand the significance more easily than if presenting in a traditional report format

Question 10

What are dashboards?

Answer 10

These provide a relevant summary and are often used to provide four or five relevant drivers that give an overview of a business area. Each driver can be further analysed by drilling down into the supporting data.

Question 11

What are line charts?

Answer 11

These are used to show trend analysis or timebased resutls

Question 12

What are mapping charts?

Answer 12

These present geographically for example, countries or regions can be clicked on and drilled into to find information specfic to those areas

Question 13

What are bar and pie charts?

Answer 13

The traditional methods of comparing data which is made up of component parts

Question 14

What are tables?

Answer 14

The traditional method of presenting reference method material by breaking it down into rows and columns

Question 15

What is the main impact of data visualisation of informations?

Answer 15

They bring chance to how information is presented. Data presented in dashboards and mapping charts can be drilled down further, for example, if the headline figure is sales, it would be possible to drill down further to shows sales by product or location

Question 16

What are the ways of presenting data?

Answer 16

Tables
Charts
Graphs

Question 16

What is the essence of data visualisation in terms of understanding (an advantage and disadvantage?

Answer 16

Can make it easier to understand, although it can also oversimplify things or even mislead in certain cases

Question 17

What is a matrix?

Answer 17

A table of data presenting charts and graphics What is the essence

Question 17

What is a table?

Answer 17

A matrix of data in rows and columns with the being titled. Two dimensional shows two variables

Question 17

What are multiple bar charts?

Answer 17

Have a set of bars for each class, with each bar representing a single constituent part of the total. Within each set, the bars are physically joined and always arranged in the same sequence.

Question 18

What are components bar charts?

Answer 18

Have each bar representing a class and split into constituent parts. Within each bar, components are always stacked in the same order

Question 19

What are percentage component bar charts?

Answer 19

Have each bar representing a class but all drawn to the same height, representing 10% of the total. The constituent parts of each class are then calculated as percentages of the total and shwn within each bar accordingly

Question 20

What are the essence of spreadsheets?

Answer 20

They are the basic tool of accountants to record and manipulate management informaton