
N5 BM Technology in Finance
Presentation
•
Business
•
11th - 12th Grade
•
Practice Problem
•
Medium
Jessica Suk Ching Martin
Used 3+ times
FREE Resource
12 Slides • 12 Questions
1
2
3
Dropdown
The formulae function within the spreadsheet can be used to carry out instant calculations
‘
Information held can be easily secured using a
Time can be saved in the finance department by using spreadsheet
4
5
6
Categorize
less chance of error
Mistakes can be easily changed
Graphs and charts are easier to read and interpret
It can be costly to purchase the hardware and software
Staff need to be trained
The software and hardware can become out of date relatively quickly
Spreadsheets
7
8
9
10
Multiple Select
Choose the correct statements about Banking Apps:
Online banking allows businesses to make payments quickly
Business can have online access to accounts
Easy to use due to formulae
Payments can only be made within a specific regional area
Forgetting the password could lock you out of the app for a period of time
11
12
Multiple Choice
Emails can be used in Finance to:
let the marketing department know what their budget will be this year
let customers know that there is a promotion on
contact suppliers to order inventory
to attach a job description and person spec to an applicant
13
Multiple Choice
Word processing can be used in the Finance department to:
create a job advert
to create a list of local suppliers
to make a promotional flyer
to create a report to include an income statement
14
Multiple Choice
Databases can be used in the Finance department to:
keep a record of potential job applicants
keep a record of inventory held
create a report of payment outstanding to suppliers
keep a record of customer's email addresses
15
16
Reorder
Reorder the following
Powerpoint is used to integrate with a
spreadsheet to display charts and
information on the financial position
of the business when
speaking to management
17
Reorder
Reorder the following
Internet could be used to
gain information on
potential customers before
deciding on
appropriate credit terms
18
19
Multiple Choice
EPOS stands for...
20
Exam Style Questions
21
Multiple Choice
Justify the use of spreadsheets in the Finance department. (1 mark)
The Finance department would use spreadsheets because calculations can be carried out automatically using formulae.
The Finance department would use spreadsheets because it is easy to keep a record of suppliers accounts and what they owe.
The Finance department would use spreadsheets because staff need to be trained to use the package effectively and this involve additional costs.
Graphs and charts are easier to read and interpret than lots of figures.
It can be costly to purchase the hardware and software required.
22
Multiple Choice
Describe advantages of using spreadsheet software.
Formulae can be used to calculate information
which allows for automatic calculation if anything changes.
One advantage is that the software and hardware can become out of date relatively quickly and may have to be updated.
Graphs/Charts can be created to display information
which makes it more difficult for comparison of complex financial information
All transactions can be viewed giving a more complete view of the current state of the organisation’s finances, therefore this helps with budgeting
Spreadsheet records can be searched and sorted quickly which means critical information can be found quicker. The reports can be stored and referred back to at a later date.
23
Open Ended
Describe the ways that other software can be used in the finance department. (2 marks)
DO NOT USE SPREADHSHEETS
24
Describe the ways that other software can be used in the finance department. (2 marks)
Word Processing – to create documents informing departments of their annual budget figure Word Processing – to compile the Shareholders’ Annual Financial Report
Database – to keep records of suppliers’ accounts due and/or debtors’ accounts owed Database – to create reports of overdue accounts
PowerPoint – to display financial information at the shareholders meeting
Internet/website/online…
Show answer
Auto Play
Slide 1 / 24
SLIDE
Similar Resources on Wayground
16 questions
The Theory of Evolution
Presentation
•
8th Grade
19 questions
More Venn Diagrams
Presentation
•
11th - 12th Grade
19 questions
Homeostasis
Presentation
•
11th - 12th Grade
20 questions
Mixed Numbers
Presentation
•
4th - 5th Grade
21 questions
ohms law
Presentation
•
11th - 12th Grade
17 questions
Compound Probability
Presentation
•
11th - 12th Grade
19 questions
Layers of the Earth
Presentation
•
10th - 12th Grade
19 questions
Inverse Functions
Presentation
•
11th Grade
Popular Resources on Wayground
10 questions
HCS SCI 03 Summer School Review 4
Quiz
•
3rd Grade
11 questions
HSMS - Standard Response Protocol
Quiz
•
6th - 8th Grade
16 questions
1.1-1.2 Quiz Review
Quiz
•
9th - 12th Grade
12 questions
Exponent Expressions
Quiz
•
6th Grade
20 questions
Adding and Subtracting Integers
Quiz
•
6th - 7th Grade
11 questions
Northeast States
Quiz
•
3rd - 4th Grade
10 questions
Characterization
Quiz
•
3rd - 7th Grade
10 questions
Common Denominators
Quiz
•
5th Grade