BAHRAIN TRAINING INSTITUTE - 77585 Commercial Studies Division Level 3 Pearson BTEC Extended Diploma in Business (Accounting) (VA793/EDAC) (Year 2) Unit Title: Computer Applications for Financial Management Unit Code: (20398D/EAC343)

BTI ASSESSMENT CRITERIA AND CONTENT Learning outcome

Assessment criteria reference

Assessment criteria

Content

LO1

1

Generate financial records for a company in Bahrain using accounting software.

LO2

2

Construct Financial Statements from information abstracted from computerized system.

LO3

3

Analyse information from software applications used in GCC.

4

Select and compile accounting data using presentation software to communicate with users of financial information.

 spreadsheets; accounting programmes; databases;  a wide range of appropriate functions and formulas;  export data, e.g. to spreadsheet, PowerPoint, Word;  save (native, comma separated variable (csv), hypertext mark-up language (html);  validation features to manage the type of data entered;  filter (automatic filter, criteria, exceptional data);  pivot tables and outlines;  appropriate tools and techniques to generate, develop and format charts and graphs;  digital images; sounds; visual appeal, e.g. font colour, style, size;

LO4

Unit Leader: Zahra Isa

PM/IV: Dr. Mark Ramos Abad LIV: Dr. Mary Agnes Dabucol HoD: Dr. Maha Mansoor

QA Auditor:

QA HoD:__________

BAHRAIN TRAINING INSTITUTE - 77585 Commercial Studies Division Level 3 Pearson BTEC Extended Diploma in Business (Accounting) (VA793/EDAC) (Year 2) Unit Title: Computer Applications for Financial Management Unit Code: (20398D/EAC343) BTI – ASSESSMENT MAPPING SHEET 2015-2016 – Semester 2

Assessment Criteria

Reference***

Week

Week

Week

9

13

16

1 ( LO1)

Generate financial records for a company in Bahrain using accounting software.

T1

2 ( LO2)

Construct Financial Statements from information abstracted from computerized system.

T1

3 ( LO3)

Analyse information from software applications used in GCC. Select and compile accounting data using presentation software to communicate with users of financial information. Contribution to Final Grade**

4 ( LO4)

MT

EXAM

Assessment

MT 30%

30%

40%

** - In-course assessments contribute 60% to final grade *** - Must be linked directly to the learning outcomes T-test; MT= Mid-term; Exam= End of semester exam

Unit Leader: Zahra Isa

PM/IV: Dr. Mark Ramos Abad LIV: Dr. Mary Agnes Dabucol HoD: Dr. Maha Mansoor

QA Auditor:

QA HoD:__________

BAHRAIN TRAINING INSTITUTE - 77585 Commercial Studies Division Level 3 Pearson BTEC Extended Diploma in Business (Accounting) (VA793/EDAC) (Year 2) Unit Title: Computer Applications for Financial Management Unit Code: (20398D/EAC343) BTEC ASSESSMENT MAPPING SHEET 2015-2016 – Semester 2 Learning Outcome Ref.

LO1

Assessment and Grading Criteria Reference

P1 M1 P2

LO2 D1 P3 LO3 M2 P4 LO4

M3 D2

Key dates Assessment type

Assessment and Grading Criteria

Record three accounting transactions using a computerised accounting system. Compare the types of software used to record accounting information. Produce information abstracted from a computerised accounting system in a suitable format. Assess the value to an organisation of using software for financial transactions. Produce analytical summaries of the information held on a computerised accounting system. Explain how computerized accounting systems produce summaries and analysis of accounting information. Report the results of information held on a computerised accounting system to interested parties. Compare the presentation features of the software used to communicate financial information. Evaluate the effectiveness of the presentation features of software used to communicate financial information.

Assessment distribution and collection

IV sampling (see N1)

Feedback (see N2)

Resubmission (see N3)

Distribution

Collection

CS1

10/04/2016 (Week 9)

10/04/2016 (Week 9)

17/04/2016

24/04/2016

01/05/2016

CS2

08/05/2016 (Week 13)

08/05/2016 (Week 13)

15/05/2016

19/05/2016

22/05/2016

CS= Case Study N1 – Assessment grades to be made known to trainees only after IV sampling. N2 – Trainee feedback to be provided within 2 weeks after collection. N3 – Resubmissions will only be allowed if trainee meets all conditions.

Unit Leader: Zahra Isa

PM/IV: Dr. Mark Ramos Abad LIV: Dr. Mary Agnes Dabucol HoD: Dr. Maha Mansoor

QA Auditor:

QA HoD:__________