Vocational Skills in Accounting II

Vocational Skills in Accounting & Finance Paper – II
Course (Preparation of Financial Budgets) (Semester I; Credits 02

Level 4.5)
No of Teaching
Type VSC, SEC: (VSEC) 30
hours
Evaluation/
50 marks - 30 marks semester end evaluation and 20 marks continuous evaluation
Assessment
Preface
In today's fast-paced business environment, organizations rely heavily on accurate financial budgets to make
informed decisions and allocate resources effectively. Excel has emerged as the go-to tool for budget preparation
due to its versatility and powerful features. This course aims to equip learners with the excel skills needed to excel
in financial budgeting and analysis.
Through this course, learners will not only gain a solid understanding of financial budgeting fundamentals but also
master the use of Excel for budget preparation. They will learn to set up excel worksheets, import data from various
sources, and utilize Excel's functions for efficient data analysis. Additionally, learners will be trained to create
Pivot tables and charts to visualize budgetary information effectively.
The need for this course is evident in today's job market, where employers seek candidates with strong excel skills
for financial analysis roles. By enhancing their excel proficiency, learners will not only increase their employability
but also improve their efficiency and accuracy in financial budgeting tasks.
Aims and Objectives
CO1 To introduce learners to the fundamentals and preparation of financial budgets.

CO2 To equip learners with the skills to set up excel worksheets and convert data from various sources into
excel.
CO3 To train learners in the preparation of financial budgets using Excel, leveraging its functionalities for
efficient data analysis.
CO4 To enable learners to analyze data, create Pivot tables, and generate charts to visualize budgetary
information effectively.
Learning Outcomes
On successful completion of the course,
LO1 Learners will be able to summarize, compare and contrast different components of financial budgets.
LO2 Learners will acquire the skills to set up excel worksheets and import data from different sources,
ensuring accuracy and efficiency in budget preparation.
LO3 Learners will be proficient in preparing financial budgets using excel, utilizing its features for accurate
calculations and data organization.
LO4 Learners will be able to analyze budgetary data, create Pivot tables, and generate charts in excel to
effectively visualize and interpret budget information.
Page no 19
Module No Content No of
Hours
 Understanding the concept of financial budgeting
1. Introduction  Importance and benefits of budgeting 15
to Financial  Types of budgets.
Budgeting  Preparation of Flexible Budget and Sales Budget manually.
 Setting up a worksheet or converting data from picture into

excel.
2. Preparation  Preparation of Flexible Budget and Sales Budget in excel. 15
of Budgets  Analyse Data using Excel.
in Excel  Prepare Pivot table and chart.
(Note:
The module/s are to be taught with the help of the computer wherever practical exposure is required)
Information: Model question paper for external exam will be provided during the workshops
References
1. Introduction to Financial Planning by Indian Institute of Banking & Finance
2. David N. Hyman: Public Finance A Contemporary Application of theory of policy, Krishna
Offset, Delhi
3. Hoiughton E.W. (1998) : Public Finance, Penguin, Baltimore
4. Hajela T.N: Public Finance – Anne Books Pvt. Ltd
5. Excel with Microsoft Excel: Comprehensive & Easy Guide to Learn Advanced MS Excel
2019 by Naveen Mishra
6. Mastering Microsoft Excel Functions and Formulas 2010 by Web Tech Solutions
7. Microsoft Excel: Shortcut keys and Formulas 2021 by Kabir Das
Format of Question Paper: for the final examination

Attempt any 2 out of 3 questions.
Question Questions Marks

No
Q1 Practical/ Theory 15
TOTAL 30
Note
1. Equal Weightage is to be given to all the modules.
2. 15 marks question may be subdivided into 8 marks + 7 marks, 10 marks + 5 marks
Page no 20
and 5 marks + 5 marks + 5 marks. Internal options may be given however it is not mandatory.
3. Use of simple calculator is allowed in the examination.
4. Wherever possible more importance is to be given to the practical problems.
Continuous Evaluation through:

Assessment/ Evaluation Marks
1. Class Test during the lectures. (Physical/ Online mode). 10

(Short notes/ MCQ’s/ Match the Pairs/ Answer in one sentence/
puzzles)
2. Participation in Workshop/ Conference/Seminar/ Case Study/Field 10
Visit/ Certificate Course. (Physical/Online mode)
TOTAL 20
Page no 21

Vocational Skills in Accounting II

Uploaded by

Copyright:

Available Formats

Vocational Skills in Accounting II

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Vocational Skills in Accounting II

Uploaded by

Copyright:

Available Formats

Vocational Skills in Accounting & Finance Paper – II

Course (Preparation of Financial Budgets) (Semester I; Credits 02

Aims and Objectives

CO1 To introduce learners to the fundamentals and preparation of financial budgets.

On successful completion of the course,

 Setting up a worksheet or converting data from picture into

Format of Question Paper: for the final examination

Question Questions Marks

Continuous Evaluation through:

1. Class Test during the lectures. (Physical/ Online mode). 10

You might also like