course title: retailing managementdte.karnataka.gov.in/institutes/grcibm/filehandler/... ·...
TRANSCRIPT
Directorate Of Technical Education Karnataka State Page 1
Course Title: RETAILING MANAGEMENT
Credits (L:T:P) : 4:0:0 Total Contact Hours: 52 Course Code: 15MM31T
Type of Course: Lectures,
Self Study & Assignment Credit :04 Core/ Elective: Core
PREREQUISITES: Knowledge of Elementary Management.
COURSE OBJECTIVES: The students shall be able to:
1) Apply his mind to enter into the application of Retailing Management
2) Use Human Resources and Administrative Strategies to make use of Retailing
Management.
3) Experiment the Application of Merchandising Management.
4) Relate different Pricing and Communication Strategies in Retailing.
5) Show the Application of Stores Design in different Retailing Areas.
6) Show the Application of Stores Layout in different Retailing Areas. COURSE OUTCOMES:
At the end of the Course the students shall be able to:
COURSE WITH PROGRAM OUTCOMES LEVEL MAPPING:
COURSE
PROGRAMME OUTCOMES
1 2 3 4 5 6 7 8 9 10
Retailing
Management 3 3 1 - - 1 - - 3 -
COURSE OUTCOME CL Linked
PO
Teaching
Hours
CO1 Insight into the World of Modern
Retailing Management U/A 1,2,3,9 12
CO2 Adopt Human Resources and
Administrative Strategies in Retailing
Management
A 1,2,4,9 10
CO3 Well verse in Merchandising Planning
and Category Management. A 1,2,4,9, 12
CO4
Apply various Pricing and
Communication Strategies to cater to
the requirements of Retailing
Management.
U/A 1,2 08
CO5 Interpret the Interior and Exterior
Store Design. A 1,2,6 05
CO6 Applying the Application of Stores
Layout A 1,2,6 05
TOTAL SESSIONS 52
Directorate Of Technical Education Karnataka State Page 2
Level 3- Highly Addressed, Level 2-Moderately Addressed, Level 1-Low Addressed.
Method is to relate the level of PO with the number of hours devoted to the COs which address the given PO.
If >40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 3
If 25 to 40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 2
If 5 to 25% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 1
If < 5% of classroom sessions addressing a particular PO, it is considered that PO is considered not-addressed.
COURSE CONTENT AND BLUE PRINT OF MARKS FOR SEE:
Unit
No
Unit Name Hour
Questions to be
set for
(5marks )
PART - A
Questions to
be set for
(10marks)
PART - B
Marks
weight
age
(%)
R U A R U A
1
INTRODUCTION TO
THE WORLD OF
RETAILING
08 - 01 - - - 02 17.24
2
HUMAN RESOURCE &
ADMINISTRATIVE
STRATEGY
10 - 01 01 - 01 01 20.69
3 MERCHANDISE
MANAGEMENT 12 01 01 - - - 02 20.69
4
PRICING &
COMMUNICATION
STRATEGIES IN
RETAILING
12 01 02 - - 01 01 24.14
5 STORES
MANAGEMENT- I 05 - 01- - - 01 - 10.34
6 STORES
MANAGEMENT-II 05 01 6.90
Total 52 09(45marks)
10(100
marks) 100.00
Legend: R; Remember, U: Understand A: Application
UNIT I – INTRODUCTION TO THE WORLD OF RETAILING
Definition and Meaning of Retail, Retailing, Retailer - Evolution of Indian Retailing –
Functions of Retailing – Types of Retailing – Customer Buying Behavior.
8 Hours
UNIT 2 – HUMAN RESOURCE & ADMINISTRATIVE STRATEGY
Meaning of Human Resource and Administrative Strategy – Organization Structure for
Retailing Firm – Human Resources Management in Retailing.
10 Hours
UNIT 3 – MERCHANDISE MANAGEMENT
Meaning and Definition of Merchandise Management – Merchandising Planning –
Sources of Merchandising – Category Management – Buying System to Stores – Merchandise
Allocation
12 Hours
Directorate Of Technical Education Karnataka State Page 3
UNIT 4 – PRICING & COMMUNICATION STRATEGIES IN RETAILING
Concept of Retail Price – Retail Pricing Strategies – Approaches for setting Prices –
Pricing Adjustments – Consumer Responses to Price – Meaning of Retail Promotion - Selection
of Promotion Mix – Retail Marketing Mix – Retail Advertisement.
12 Hours
UNIT 5 – STORES MANAGEMENT - I
Meaning of Stores Management – Objectives of Stores Design – Exterior of Store Design
– Interior of Store Design
05 Hours
UNIT 6 – STORES MANAGEMENT- II
Stores Layout – Space Planning – Merchandising Presentation – Techniques and
Atmosphere.
05 Hours
TEXT BOOKS FOR REFERENCES:
1. Retail Marketing Communication by Sudhakar – PHI Learning.
2. A Textbook of Retailing Management by Dr.Ansuya Angadi, S.Chand & Company
Ltd.
3. Retailing Management by Swapna Pradhan – McGraw Hill Companies
4. Retail Management by Gibson G Vedhamani – Jaico Publishing House.
REFERENCES:
1. amazon.in/retailing management
2. whitman.syr.edu/programs-and-academics/academics/retail-management
3. www.dmsretail.com 4. www.mica.ac.in/academic-programmes/retail-management
SUGGESTED LIST OF STUDENT ACTIVITY:
* Assignment: At the End of the Coverage of the Syllabus in this particular Subject, a
“RETAIL BUSINESS DAY” is to be conducted in the premises of the
Institution by the concerned teaching faculty to assess and to award the FIVE
assignment marks to the Students against the following listed factors of
evaluation at the rate of ONE mark for every factor of evaluation mentioned
herein below:
a) Utilization of the Knowledge Base Gained
b) Salesmanship Skill
c) Art of Selling
d) Negotiation Skills
e) Adoption of Marketing Strategy
Directorate Of Technical Education Karnataka State Page 4
MODEL OF RUBRICS FOR ASSESSING STUDENT ACTIVITY:
FORMAT FOR STUDENT ACTIVITY ASSESSMENT
DIMENSION Unsatisfactory
1 Developing
2 Satisfactory
3 Good
4
Exemplary 5
Score
Collection of
data
Does not
collect any
information
relating to the
topic
Collects
very limited
information;
some relate
to the topic
Collects
some basic
information;
refer to the
topic
Collects
relevant
information;
concerned
to the topic
Collects a
great deal of
information;
all refer to
the topic
3
Fulfill team’s
roles & duties
Does not
perform any
duties assigned
to the team
role
Performs
very little
duties
Performs
nearly all
duties
Performs all
duties
Performs all
duties of
assigned
team roles
with
presentation
4
Shares work
equally
Always relies
on others to do
the work
Rarely does
the assigned
work; often
needs
reminding
Usually
does the
assigned
work; rarely
needs
reminding
Does the
assigned job
without
having to be
reminded.
Always
does the
assigned
work
without
having to be
reminded
and on
given time
frame
3
Listen to
other Team
mates
Is always
talking; never
allows anyone
else to speak
Usually
does most
of the
talking;
rarely
allows
others to
speak
Listens, but
sometimes
talk too
much
Listens and
contributes
to the
relevant
topic
Listens and
contributes
precisely to
the relevant
topic and
exhibit
leadership
qualities
3
TOTAL
13/4=
3.25=
4
*All student activities should be done in a group of 4-5 students with a team leader.
Directorate Of Technical Education Karnataka State Page 5
COURSE ASSESSMENT AND EVALUATION
Note: I.A. test shall be conducted for 20 marks. Average marks of three tests shall be rounded
off to the next higher digit.
The Course will be Delivered Through Lectures, Class Room Interaction, Exercises and
Self Study Cases.
What
To
Whom
When/Where
(Frequency in
the Course)
Max.
Marks
(Theory)
Evidence
CO’s
Mapped
Direct
Assessment
Method
CIE
IA Test S
TU
DE
NT
S
3 Tests
(Average of 3
tests will be
Taken)
20 Blue Books 1 – 6
Assignment
Assignment
Report 05 *Assign
ment 1 – 6
Total 25
SEE End Exam End of Course 100 Answer Script 1 – 6
Indirect
Assessment
Method
Student Feedback Middle of the
Course
-NA-
Feed Back
Forms
1 – 3 delivery
of the Course
End of Course
Survey End of Course Questionnaire
Effectiveness of
delivery of
Instruction and
assessment methods
Directorate Of Technical Education Karnataka State Page 6
MODEL QUESTION PAPER (CIE)
Test/Date and
Time Semester/year Course/Course Code
Max
Marks
Ex: I test/6 th
weak
of Sem 10 - 11 Am
III SEM RETAILING MANAGEMENT 20
Year: 2015-16 Course code:15MM31T
Name of Course coordinator :
Units:1,2 Co: 1,2
Note: Answer all questions
Question
no Question CL CO PO
1
Explain Consumer Motives which influence Purchasing Decision
in Retailing.
OR
What is Merchandise Management? List out the Advantages of
Category Management.
R 1 1,2
2 What are the benefits of EDLP? A 1 1,2
3
What is Retailing and List out the types of Retailing?
OR
Explain the Concept of Price.
A 2 1,2
4 What are the benefits of EDLP? U 2 1,2
Note to IA verifier: The following documents to be verified by CIE verifier at the end of
semester
1. Blue books ( 20 marks)
2. Student suggested activities report for 5 marks and should be assessed on RUBRICS
3. Student feedback on course regarding Effectiveness of Delivery of instructions &
Assessment Methods.
Directorate Of Technical Education Karnataka State Page 7
GOVERNMENT OF KARNATAKA
DEPARTMENT OF TECHNICAL EDUCATION BOARD OF TECHNICAL EXAMINATIONS
DIPLOMA IN BUSINESS ADMINISTRATION MODEL QUESTION PAPER
15MM31T - RETAILING MANAGEMENT
Time: 3 Hours Max.Marks: 100
Instruction: 1) Part – A. Answer any SIX questions from a set of 9 Questions.
Each question carries 5 Marks.
2) Part – B. Answer any SEVEN questions from a set of 10 Questions.
Each question carries 10 Marks.
PART – A
(Answer any SIX Questions from this Section) 6 x 5 = 30
1. Explain Consumer Motives which influence Purchasing Decision in Retailing.
2. What is Retailing and List out the types of Retailing?
3. Draw an Organization Structure for Retail Firm?
4. What are the different types of Organization Structure?
5. What is Merchandise Management? List out the Advantages of Category Management.
6. Explain the Concept of Price.
7. What are the benefits of EDLP?
8. Explain the basis of Selection for Promotion Mix.
9. Define Advertising and mention its objectives.
PART – B
(Answer any SEVEN Questions from this Section) 10 x 7 = 70
1. Explain the functions of Retailer.
2. Explain the functions involved in Human Resource Management in Retail.
3. Explain OTB? Narrate the Advantages of OTB Plan.
4. Explain the Process of Merchandising Planning.
5. What are the Retailing Pricing Strategies? Briefly Explain.
6. Explain the various steps involved in Retail Advertising Campaigns.
7. What do you mean by Category Management and explain its business process.
8. Distinguish between Exterior and Interior Store Design.
9. What is Store Layout and Explain different Types of Store Layout.
10. Briefly Explain the Approaches for setting Prices.
Directorate Of Technical Education Karnataka State Page 8
MODEL QUESTION BANK
DIPLOMA MODERN OFFICE MANAGEMENT
III Semester
Course title: RETAILING MANAGEMENT
CO1:
REMEMBERING
UNDERSTANDING
APPLICATION
CO2
REMEMBERING
UNDERSTANDING
APPLICATION
CO3:
REMEMBERING
UNDERSTANDING
APPLICATION
CO4:
REMEMBERING
UNDERSTANDING
Directorate Of Technical Education Karnataka State Page 9
APPLICATION
CO5:
REMEMBERING
UNDERSTANDING
APPLICATION
CO6:
REMEMBERING
UNDERSTANDING
APPLICATION
Directorate Of Technical Education Karnataka State Page 1
Course Title: ENTREPRENEURSHIP DEVELOPMENT
Credits (L:T:P) : 4:0:0 Total Contact Hours: 52 Course Code: 15MM32T
Type of Course: Lectures,
Self Study & Assignment Credit :04 Core/ Elective: Core
PREREQUISITES: Basic Knowledge of Business and Management.
COURSE OBJECTIVES: The students shall be able to:
1) Demonstrate the need of Entrepreneurial Development.
2) Glancing into the field of overall Entrepreneurial Development.
3) Recognize the various factors contributing to the growth of Entrepreneurship
Development.
4) Analyze the Role to be played by the Woman Entrepreneurs in the Overall Development of
the Country.
5) Learn the need of Establishing Small Scale Industries.
6) Examine the various sources available for Institutional Finance for Entrepreneurs. At the end of the course the students should be able to:
COURSE WITH PROGRAM OUTCOMES LEVEL MAPPING:
COURSE PROGRAMME OUTCOMES
1 2 3 4 5 6 7 8 9 10
Entrepreneurship
Development 3 3 1 3 1 1 2 1 3 0
COURSE OUTCOME CL Linked
PO
Teaching
Hours
CO1 Insight into the Field of
Entrepreneurial Development U/A 1,2,3,9 08
CO2 Focusing into the various aspects of
Entrepreneurial Development. A 1,2,4,9 08
CO3 Elucidate various factors contributing
to the growth of Entrepreneurship
Development. A 1,2,4,9, 08
CO4 Interpret the Role played by Woman
Entrepreneurs in the Overall
Development of the Country. U/A 1,2,5,8 08
CO5 Well verse in establishing Small Scale
Industries. A 1,2,6,7 10
CO6 Trace out the various sources available
for Institutional Finance for
Entrepreneurs. A 1,2,6,7 10
TOTAL SESSIONS 52
Directorate Of Technical Education Karnataka State Page 2
Level 3- Highly Addressed, Level 2-Moderately Addressed, Level 1-Low Addressed. Method is to relate the level of PO with the number of hours devoted to the COs which address the given PO. If >40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 3 If 25 to 40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 2 If 5 to 25% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 1 If < 5% of classroom sessions addressing a particular PO, it is considered that PO is considered not-addressed.
COURSE CONTENT AND BLUE PRINT OF MARKS FOR SEE:
Unit
No
Unit Name Hour
Questions to
be set for
(5marks )
PART - A
Questions
to be set
for
(10marks)
PART - B
Marks
weight
age
(%)
R U A R U A
1
AN INTRODUCTION TO
ENTREPRENEURIAL
DEVELOPMENT 08 01
01 - -
- 02 20.68
2
AN OVERVIEW OF
ENTREPRENEURIAL
DEVELOPMENT 08 -
01 01 -
- 01 13.80
3 ENTREPRENEURSHIP 08 01 01 -
- - 02
20.68
4 WOMAN
ENTREPRENEUR 08 -
02 - -
- 01 13.80
5 SETTING UP OF SMALL
SCALE INDUSTRY 10 -
- - -
01 01 13.80
6
INSTITUTIONAL
FINANCE FOR
ENTREPRENEURS
10 - 01 -
- 01 01
17.24
Total 52 09(45marks) 10(100
marks) 100.00
UNIT 1: AN INTRODUCTION TO ENTREPRENEURIAL DEVELOPMENT
Definition & Meaning of Entrepreneur – Enterprise - Importance – Pros and Cons of being
Entrepreneur – Characteristics - Functions - Qualities of Outstanding Entrepreneurs. Types of
Entrepreneur The role of Entrepreneur - Rural Entrepreneur - Problems of Rural Entrepreneur -
Distinguish between Entrepreneur and Enterprise.
8 Hours
UNIT 2: AN OVERVIEW OF ENTREPRENEURIAL DEVELOPMENT
Types of Entrepreneurs - The role of Entrepreneurs in overall development of the Country -
Rural Entrepreneurs – Role of Rural Entrepreneurs in the Rural Development - Problems of
Rural Entrepreneurs - Distinguish between Entrepreneur and Enterprise.
Directorate Of Technical Education Karnataka State Page 3
8 Hours
UNIT 3: ENTREPRENEURSHIP
Definition & Concept of Entrepreneurship - Factors Contributing to the Growth of
Entrepreneurship - Role of Government in the Promotion and Development of Entrepreneurship -
Problems of Developing Entrepreneurship in India.
08 Hours
UNIT 4: WOMAN ENTREPRENEUR
Woman Entrepreneur - Meaning - Functions and Problems of Woman Entrepreneurs –
Types of Woman Entrepreneurs – Qualities of Woman Entrepreneurs – Role of Woman
Entrepreneurs.
08 Hours
UNIT 5: SETTING UP OF SMALL SCALE INDUSTRY
Definition and Meaning of Small Scale Industries – Types of SSI Units – Problems faced
by SSI Units and its Measures – Distinguish between Small Scale and Medium Scale –
Suggestion–Steps to be taken while Starting Small Scale Industry – Process of Setting up Small
Scale Industry.
10 Hours
UNIT 6: INSTITUTIONAL FINANCE FOR ENTREPRENEURS
Institutional Finance to Entrepreneurs – Commercial Banks – Other Financial
Institutions – Intuitional Support to Entrepreneurs – Need - Role of various
Financial Institutions - Taxation Benefits to Small Scale Industries – Government Policy for
Small Scale industries - Growth Strategies in Small Scale Business.
10 Hours
TEXT BOOKS FOR REFERENCES:
1. Fundamentals of Entrepreneurship – Mohanty – PHI Learning.
2. Entrepreneurship Development by Dr.Alice Mani
3. Management of Small Scale Industry by Vasanth Desai
4. Small Scale Industries and Entrepreneurial Development by C.S.V.Murthy
5. Issues and Problems of Developing Entrepreneurship by S.V.S.Sharma.
6. Entrepreneurship Development by Khanka.
REFERENCES:
1. web.undp.org/evaluation/documents/Essentials-on-entrepreneurship.pdf 2. https://books.google.co.in/books/about/Entrepreneurship 3. www.enterweb.org/entrship.htm 4. www.womensweb.in/articles/women-entrepreneurship-in-india
Directorate Of Technical Education Karnataka State Page 4
SUGGESTED LIST OF STUDENT ACTIVITY:
* SKILL DEVELOPMENT ACTIVITY:
At the End of the Coverage of the Syllabus in this particular Subject, a ‘SKILL
DEVELOPMENT ACTIVITY’ is to be conducted under the following Topics related by
the concerned Teaching Faculty to assess and to award the FIVE assignment marks to the
Students for any TWO out of Five Activities of the Skill Development in evaluation
mentioned herein below:
a) Preparation of a Mini Project Report to Start a SSI Unit.
b) Preparing a Letter to the concerned authority – seeking license for starting the
Proposed SSI Unit.
c) A feasible Report on the Survey of SSI Units in the Region where college is located.
Course Delivery: The course will be delivered through lectures and Power point presentations/
Video
MODEL OF RUBRICS FOR ASSESSING STUDENT ACTIVITY:
FORMAT FOR STUDENT ACTIVITY ASSESSMENT
DIMENSION Unsatisfactory
1 Developing
2 Satisfactory
3 Good
4
Exemplary 5
Score
Collection of
data
Does not
collect any
information
relating to the
topic
Collects
very limited
information;
some relate
to the topic
Collects
some basic
information;
refer to the
topic
Collects
relevant
information;
concerned
to the topic
Collects a
great deal of
information;
all refer to
the topic
3
Fulfill team’s
roles & duties
Does not
perform any
duties assigned
to the team
role
Performs
very little
duties
Performs
nearly all
duties
Performs all
duties
Performs all
duties of
assigned
team roles
with
presentation
4
Shares work
equally
Always relies
on others to do
the work
Rarely does
the assigned
work; often
needs
reminding
Usually
does the
assigned
work; rarely
needs
reminding
Does the
assigned job
without
having to be
reminded.
Always
does the
assigned
work
without
having to be
reminded
and on
given time
frame
3
Listen to
other Team
mates
Is always
talking; never
allows anyone
else to speak
Usually
does most
of the
talking;
Listens, but
sometimes
talk too
much
Listens and
contributes
to the
relevant
Listens and
contributes
precisely to
the relevant
3
Directorate Of Technical Education Karnataka State Page 5
rarely
allows
others to
speak
topic topic and
exhibit
leadership
qualities
TOTAL
13/4=
3.25=
4
*All student activities should be done in a group of 4-5 students with a team leader.
COURSE ASSESSMENT AND EVALUATION
Note: I.A. test shall be conducted for 20 marks. Average marks of three tests shall be rounded
off to the next higher digit.
The Course will be Delivered Through Lectures, Class Room Interaction, Exercises and
Self Study Cases.
What
To
Whom
When/Where
(Frequency in
the Course)
Max.
Marks
(Theory)
Evidence
CO’s
Mapped
Direct
Assessment
Method
CIE
IA Test
ST
UD
EN
TS
3 Tests
(Average of 3
tests will be
Taken)
20 Blue Books 1 – 5
Assignment
Assignment
Report 05 *Assign
ment 1 – 5
Total 25
SEE End Exam End of Course 100 Answer Script 1 – 5
Indirect
Assessment
Method
Student Feedback Middle of the
Course
-NA-
Feed Back
Forms
1 – 5 delivery
of the Course
End of Course
Survey End of Course Questionnaire
Effectiveness of
delivery of
Instruction and
assessment methods
Directorate Of Technical Education Karnataka State Page 6
MODEL QUESTION PAPER (CIE)
Test/Date and
Time Semester/year Course/Course Code
Max
Marks
Ex: I test/6 th
weak
of Sem 10-11 Am
III SEM ENTREPRENEURSHIP
DEVELOPMENT 20
Year: 2015-16 Course code:15MM32T
Name of Course coordinator :
Units:1,2 Co: 1,2
Note: Answer all questions
Question
no Question CL CO PO
1
Write a note on Entrepreneur and Enterprise
OR
What do you understand by the concept ‘Entrepreneurship’?
R 1 1,2
2 Explain the role of the Government in the promotion and
Development of Entrepreneurship A 1 1,2
3
Explain the Problems faced by the Small Scale Industries
OR
Enumerate the various steps involved in Setting up of Small Scale
Industries.
A 2 1,2
4 Attempt a note on Institutional Finance for Entrepreneurs. U 2 1,2
Note to IA verifier: The following documents to be verified by CIE verifier at the end of
semester
1. Blue books ( 20 marks)
2. Student suggested activities report for 5 marks and should be assessed on RUBRICS
3. Student feedback on course regarding Effectiveness of Delivery of instructions &
Assessment Methods.
Directorate Of Technical Education Karnataka State Page 7
GOVERNMENT OF KARNATAKA
DEPARTMENT OF TECHNICAL EDUCATION BOARD OF TECHNICAL EXAMINATIONS
DIPLOMA IN BUSINESS ADMINISTRATION MODEL QUESTION PAPER
15MM32T - ENTREPRENEURSHIP DEVELOPMENT
Time: 3 Hours Max.Marks: 100
Instruction: 1) Part – A. Answer any SIX questions from a set of 9 Questions.
Each question carries 5 Marks.
2) Part – B. Answer any SEVEN questions from a set of 10 Questions.
Each question carries 10 Marks.
PART – A
(Answer any SIX Questions from this Section) 6 x 5 = 30
1. Write a note on Entrepreneur and Enterprise
2. What do you understand by the concept ‘Entrepreneurship’?
3. Write a note on types of Women Entrepreneurs.
4. Define and explain the meaning of Small Scale Industry.
5. Attempt a note on Institutional Finance for Entrepreneurs.
6. What are the Tax Benefits available for Small Scale Industries?
7. Write a note on the Origin and Development of IDBI.
8. List out the Types of Small Scale Industries?
9. What are the Pros and Cons of being Entrepreneur?
PART – A
(Answer any SEVEN Questions from this Section) 10 x 7 = 70
10. Describe the qualities of an Outstanding Entrepreneur.
11. Explain the role of the Government in the promotion and Development of
Entrepreneurship.
12. Describe various Factors contributing to the Development of Entrepreneurship.
13. Write down various Functions performed by Women Entrepreneurs and also list out
the problems faced by the Women Entrepreneurs.
14. Enumerate the various steps involved in Setting up of Small Scale Industries.
15. Explain the Problems faced by the Small Scale Industries.
16. List out the problems of Rural Entrepreneurs and suggest remedial steps to be taken to
Overcome the problems faced by the Rural Entrepreneurs.
Directorate Of Technical Education Karnataka State Page 8
17. Write down detailed notes on the following:
a) IFCI b) ICICI.
18. What are the different growth strategies to be adopted for improving the Small Scale
Business ?
19. Explain the role of Women Entrepreneurs in the Economic Development of a country.
MODEL QUESTION BANK
DIPLOMA MODERN OFFICE MANAGEMENT
III Semester
Course title: ENTREPRENEURSHIP DEVELOPMENT
CO1:
REMEMBERING
UNDERSTANDING
APPLICATION
CO2
REMEMBERING
UNDERSTANDING
APPLICATION
CO3:
REMEMBERING
UNDERSTANDING
APPLICATION
CO4:
Directorate Of Technical Education Karnataka State Page 9
REMEMBERING
UNDERSTANDING
APPLICATION
CO5:
REMEMBERING
UNDERSTANDING
APPLICATION
CO6:
REMEMBERING
UNDERSTANDING
APPLICATION
Directorate Of Technical Education Karnataka State Page 1
Course Title: ELEMENTS OF CORPORATE
ACCOUNTING
Credits (L:T:P) : 4:0:0 Total Contact Hours: 52 Course Code: 15MM33T
Type of Course: Lectures,
Self Study & Assignment Credit :04 Core/ Elective: Core
PREREQUISITES: Detailed Accounting Knowledge relating to Corporate Entities.
Course Objectives: The students shall be able to:
1) Understanding the Theoretical Framework pertaining to Raising of Corporate Finance.
2) Understand various Accounting Entries as followed in Raising of Corporate Finance.
3) Compute the Value of Goodwill of Corporate Entities by making use of Various
Methods.
4) Calculate the Intrinsic Value of Shares of Corporate Entities by applying different
Available Methods.
5) Understanding the Theoretical Framework pertaining to Final Accounts of Corporate
Entities.
6) Prepare the Final Accounts of the Corporate Entities in Prescribed Format.
At the end of the Course the students shall be able to:
COURSE OUTCOME CL Linked
PO
Teaching
Hours
CO1 Conceptualize the Theoretical
Accounting Framework relating to
Raising of Corporate Finance. U/A 1,2,3,7,9 08 Hours
CO2
Using Theoretical Accounting
Framework to Pass Accounting
Entries relating to Raising of
Corporate Finance.
A 1,2,4,9 08 Hours
CO3 Elucidate different Methods of
Valuation of Goodwill. A 1,2,4,6,9, 10Hours
CO4 Enumerate the Available Methods of
Valuation of Shares. U/A 1,2,4 10 Hours
CO5 Conceptualize the Theoretical
Accounting Framework relating to
Final Accounts of Corporate Entities. A 1,2,6 08 Hours
CO6 Prepare the different Components of
Final Accounts of Corporate Entities
in Statutory Format. A 1,2,6,7 08 Hours
COURSE WITH PROGRAM OUTCOMES LEVEL MAPPING:
COURSE PROGRAMME OUTCOMES
1 2 3 4 5 6 7 8 9 10
Elements of
Corporate
Accounting 3 3 1 3 - 1 2 - 3 -
Directorate Of Technical Education Karnataka State Page 2
Level 3- Highly Addressed, Level 2-Moderately Addressed, Level 1-Low Addressed. Method is to relate the level of PO with the number of hours devoted to the COs which address the given PO. If >40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 3 If 25 to 40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 2 If 5 to 25% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 1 If < 5% of classroom sessions addressing a particular PO, it is considered that PO is considered not-addressed.
COURSE CONTENT AND BLUE PRINT OF MARKS FOR SEE
Unit
No
Unit Name Hour
Questions to be
set for
(5marks )
PART - A
Questions to
be set for
(10marks)
PART - B
Marks
weight
age
(%)
R U A R U A
1 RAISING OF
CORPORATE FINANCE-
I
08 1 1 - - - 1
13.79
2 RAISING OF
CORPORATE FINANCE-
II
08 1 1 -
- - 1
13.79
3 VALUATION OF
GOODWILL 10 -
1 - -
1 1 17.25
4 VALUATION OF
SHARES 10 -
1 - -
1 2 24.13
5 FINAL ACCOUNTS OF
CORPORATE ENTITIES
– I
08 - 1 -
- 1 1
17.25
6 FINAL ACCOUNTS OF
CORPORATE ENTITIES
– II 08
1 1
- 1 13.79
Total 52 09(45marks)
10(100
marks) 100.00
UNIT 1: RAISING OF CORPORATE FINANCE- I:
Meaning of Share– Kinds of Shares – Accounting Entries on Issue of Shares, Allotment and Calls
on Shares - Calls in Arrear and Calls in Advance – Under Subscription and Over Subscription of Shares
– Pro-rata Allotment – Issue of Shares on Par, at Premium and at Discount – Forfeiture of Shares -
Reissue of Forfeited Shares. 08 Hours
UNIT 2: RAISING OF CORPORATE FINANCE- II
Problems on Issue of Shares, Allotment and Calls on Shares – Problems on Calls in Arrear and
Calls in Advance – Problems on Under Subscription and Over Subscription of Shares – Pro-rata
Allotment – Problems on Issue of Shares on Par, at Premium and at Discount – Problems on Forfeiture
of Shares & Reissue of Forfeited Shares – Relevant Entries in the Balance Sheet. 08 Hours
UNIT 3: VALUATION OF GOODWILL:
Meaning of Goodwill – Circumstances necessitating the Calculation of Goodwill – Factors
affecting the Value of Goodwill - Classification of Goodwill - Methods of Valuation of Goodwill –
Problems on Simple Average Profits Method, Weighted Average Profits Method, Super Profit Method,
Capitalisation Method and Annuity Method.
10 Hours
Directorate Of Technical Education Karnataka State Page 3
UNIT 4: VALUATION OF SHARES
Meaning of Valuation of Shares – Circumstances necessitating the Valuation of Shares – Factors
affecting the Value of Shares - Problems on Valuation of Intrinsic Value of Shares under Net Assets
Method, Yield and Earning Capacity Method.
10 Hours
UNIT 5: FINAL ACCOUNTS OF CORPORATE ENTITIES - I:
Components of Final Accounts of Corporate Entities - Format of Profit and Loss Account, Profit
and Loss Appropriation Account and Prescribed Format of Balance Sheet.
08Hours
UNIT 6: FINAL ACCOUNTS OF CORPORATE ENTITIES - II:
Problems on Preparation of Profit and Loss Account, Profit and Loss Appropriation Account and
Balance Sheet under Prescribed Formats by making use of various Adjustments. 08Hours
TEXT BOOKS FOR REFERENCE:
1. Corporate Accounting by Goyal & Goyal – PHI Learning.
2. Corporate Accounting by Dr.P.C.Tulsian – S.Chand & Company
3. Advanced Accounts Vol – II by M.C.Shukla – S Chand & Company
3. Accountancy Vol II by B.S. Raman
4. Accountancy Vol II by Kadkol
5. Advanced Accountancy By S.K.R.Paul
REFERENCES:
1. www.brau.in/images/3rdyear-syllabus-papers/bcom/syllabus.pdf 2. www.futureaccountant.com/accounting-process/study-notes/financial 3. www.unipune.ac.in/Syllabi_PDF/commerce/S.Y.B.Com Syllabus.pdf
Course Delivery: The course will be delivered through lectures and Power point
presentations/Video.
Directorate Of Technical Education Karnataka State Page 4
MODEL OF RUBRICS FOR ASSESSING STUDENT ACTIVITY:
FORMAT FOR STUDENT ACTIVITY ASSESSMENT
DIMENSION Unsatisfactory
1 Developing
2 Satisfactory
3 Good
4
Exemplary 5
Score
Collection of
data
Does not
collect any
information
relating to the
topic
Collects
very limited
information;
some relate
to the topic
Collects
some basic
information;
refer to the
topic
Collects
relevant
information;
concerned
to the topic
Collects a
great deal of
information;
all refer to
the topic
3
Fulfill team’s
roles & duties
Does not
perform any
duties assigned
to the team
role
Performs
very little
duties
Performs
nearly all
duties
Performs all
duties
Performs all
duties of
assigned
team roles
with
presentation
4
Shares work
equally
Always relies
on others to do
the work
Rarely does
the assigned
work; often
needs
reminding
Usually
does the
assigned
work; rarely
needs
reminding
Does the
assigned job
without
having to be
reminded.
Always
does the
assigned
work
without
having to be
reminded
and on
given time
frame
3
Listen to
other Team
mates
Is always
talking; never
allows anyone
else to speak
Usually
does most
of the
talking;
rarely
allows
others to
speak
Listens, but
sometimes
talk too
much
Listens and
contributes
to the
relevant
topic
Listens and
contributes
precisely to
the relevant
topic and
exhibit
leadership
qualities
3
TOTAL
13/4=
3.25=
4
*All student activities should be done in a group of 4-5 students with a team leader.
Directorate Of Technical Education Karnataka State Page 5
COURSE ASSESSMENT AND EVALUATION The Course will be Delivered Through Lectures, Class Room Interaction, Exercises and
Self Study Cases.
What
To
Whom
When/Where
(Frequency in
the Course)
Max.
Marks
(Theory)
Evidence
CO’s
Mapped
Direct
Assessment
Method
CIE
IA Test
ST
UD
EN
TS
3 Tests
(Average of 3
tests will be
Taken)
20 Blue Books 1 – 6
Assignment
Assignment
Report 05 Assign
Reports 1 – 6
Total 25
SEE End Exam End of Course 100 Answer
Script 1 – 6
Indirect
Assessment
Method
Student Feedback Middle of the
Course
-NA-
Feed Back
Forms
1 – 6 delivery
of the Course
End of Course
Survey End of Course Questionnaire
Effectiveness of
delivery of
Instruction and
assessment methods
Note: I.A. test shall be conducted for 20 marks. Average marks of three tests shall be rounded
off to the next higher digit.
MODEL QUESTION PAPER (CIE)
Test/Date and
Time Semester/year Course/Course Code
Max
Marks
Ex: I test/6 th
weak
of Sem 10-11 Am
III SEM ELEMENTS OF
CORPORATE ACCOUNTING 20
Year: 2015-16 Course code:15MM33T
Name of Course coordinator :
Units:1,2 Co: 1,2
Note: Answer all questions
Question
no Question CL CO PO
1
The Capital of Corporate Company consists of 20000 Equity
Shares of ₹ 10 each fully paid. The Annual profit of the
Company is ₹ 20000 which is expected to be maintained even in
future. The normal Rate of Return on the paid up value of shares
for similar type of business is 8% p.a.
Compute the value of each Equity Share by using Yield
Basis Method on profit Basis.
5 Marks
A 1 1,2
Directorate Of Technical Education Karnataka State Page 6
2
From the following particulars extracted from the Books of a
Corporate Entity, Compute the value of Goodwill of the
Corporate Entity under Annuity Method.
i) Expected Future Profit: ₹ 25000
ii) Maintainable Profit/Average Profit :₹ 15000
iii) Super Profit: ₹ 10000
iv) No. of Years over which Super profit is to be paid: 5
years
v) Rate per cent p.a.: 5 %.
A 1 1,2
3 What do you understand by ‘Share’? Briefly describe the
different methods of Valuation of Shares.? U 2 1,2
4 What is meant by ‘Goodwill’? How do you Classify Goodwill? U 2 1,2
Note to IA verifier: The following documents to be verified by CIE verifier at the end of
semester
1. Blue books ( 20 marks)
2. Student suggested activities report for 5 marks and should be assessed on RUBRICS
3. Student feedback on course regarding Effectiveness of Delivery of instructions &
Assessment Methods.
Directorate Of Technical Education Karnataka State Page 7
GOVERNMENT OF KARNATAKA
DEPARTMENT OF TECHNICAL EDUCATION BOARD OF TECHNICAL EXAMINATIONS
DIPLOMA IN MODERN OFFICE MANAGEMENT MODEL QUESTION PAPER
15MM33T - ELEMENTS OF CORPORATE ACCOUNTING
Time: 3 Hours Max.Marks: 100
Instruction: 1) Part – A. Answer any SIX questions from a set of 9 Questions.
Each question carries 5 Marks.
2) Part – B. Answer any SEVEN questions from a set of 10 Questions.
Each question carries 10 Marks.
PART – A
(Answer any SIX Questions from this Section) 6 x 5 = 30 Marks
1. Distinguish between Calls in Arrear and Calls in Advance. 5 Marks
2. What is meant by ‘Goodwill’? How do you Classify Goodwill? 5 Marks
3. What are the different Stages of Collecting Money when shares are issued by a Public
Company? 5 Marks
4. What do you understand by ‘Share’? Briefly describe the different methods of Valuation of
Shares.? 5 Marks
5. The profits of a Corporate Company for the last 4 years were as under:
Year Profit
211 ₹12000
212 ₹15000
213 ₹16000
214 ₹20000
Compute the value of Goodwill of the Corporate Company on the basis of 3 years
Purchase of Weighted Average after assigning Weights 1,2,3,and 4 serially to the given
profits. 5 Marks
6. The Capital of Corporate Company consists of 20000 Equity Shares of ₹ 10 each fully
paid. The Annual profit of the Company is ₹ 20000 which is expected to be maintained
even in future. The normal Rate of Return on the paid up value of shares for similar type
of business is 8% p.a.
Compute the value of each Equity Share by using Yield Basis Method on profit Basis.
6 Marks
7. Abhiram Kumar Company Limited issued 10000 Equity Shares of ₹ 10 each at a
premium of ₹ 2 per share payable as follows:
₹ 3 on Application
Directorate Of Technical Education Karnataka State Page 8
₹ 4 on Allotment (including premium)
₹ 3 on First Call and
₹ 2 on Final Call
All the shares were subscribed and all the calls were made and the money was realized.
You are asked to pass necessary journal entries in the Books of the Company.
5 Marks
8. From the following particulars extracted from the Books of a Corporate Entity, Compute
the value of Goodwill of the Corporate Entity under Annuity Method.
v) Expected Future Profit: ₹ 25000
vi) Maintainable Profit/Average Profit :₹ 15000
vii) Super Profit: ₹ 10000
viii) No. of Years over which Super profit is to be paid: 5 years
ix) Rate per cent p.a.: 5 %.
5 Marks
9. What do you mean by Balance Sheet and what are its contents
5 Marks
PART – B
(Answer any SEVEN Questions from this Section) 10 x 7 = 70 Marks
10. Following particulars have been extracted from the Books of Sasha Aras Company
Limited:
From the above particulars, you are asked to compute the Intrinsic Value of Shares
under Net Assets Method. 10 Marks
11. Shruthi Company Limited issued 25000 Equity Shares of ₹ 25 each at a Discount of 8%
payable as follows:
₹ 5 on Application
₹ 7 on Allotment (excluding Discount)
₹ 6 on First Call and
₹ 4 on Final Call
All the Shares were subscribed and all the calls were duly made and the money
received except one shareholder holding 1000 shares failed to pay the First and Final Call
PARTICULARS ₹
Equity Share Capital: (25000 Shares of ₹ 10 each fully
paid) ₹ 2,50,000
Goodwill ₹ 61,250
9% Debentures ₹ 1,00,000
Sundry Creditors ₹ 65,000
8% Preference Share Capital: (2000 Shares of ₹ 100
each fully paid) ₹ 2,00,000
Fixed Assets ₹ 3,50,000
Investments ₹ 30,000
Current Assets ₹ 2,40,000
Directorate Of Technical Education Karnataka State Page 9
Money. The Directors of the company forfeited these shares. 700 of these shares were
reissued at ₹ 20 per share as fully paid up.
Pass Journal Entries to give effect to the above transactions in the Books of the Shruthi
Company Limited and also prepare the Company’s Balance Sheet as emerging.
10 Marks
12. Domestic Company Limited has invested a sum of Rs. 3, 00,000 in its own business which
is a very profitable one. The Annual Profit earned from its Business is Rs 60,000 which
included a sum of Rs 10,000 received as compensation for acquisition of part of it’s
Business.
The money could have been invested in deposits for a period of 5 years at 10% interest
and itself could earn ₹ 7,200 per annum in alternative employment considering 2% as fair
compensation for the risk involved in the business.
From the above, you are asked to calculate the value of Goodwill of its business on
Capitalization of Super Profits at normal rate of return of 12%. per annum. 10 Marks
13. The Directors of Lucky Ltd. forfeited 1000 Equity Shares of Rs. 10/- each fully Called up,
for Non-payment of First Call of Rs. 3/- and Final Call of Rs. 3 per share.
Out of these forfeited shares, 400 Shares were reissued at Rs. 8/- each as fully paid up.
You are required to pass necessary Journal Entries and Prepare Ledger Accounts for Forfeited
Shares Account and Capital Reserve Account only. 10 Marks
14. Briefly describe the various circumstances necessitating the valuation of Goodwill.
10 Marks
15. Explain the various circumstances necessitating the valuation of Share.
10 Marks
16. What do you understand by the components of Final Accounts of Corporate Entities?
Briefly describe them. 10 Marks
17. Write down the Statutory Format of the Balance Sheet of a Corporate Concern.
10 Marks
18. A Corporate Company is desirous of selling its business to another Corporate Company.
The former has earned an average profit of ₹ 2, 00,000 p.a. and it is likely to be earned
even in the future. The value of the net tangible assets of the business at the proposed date
of sale was ₹ 19, 00,000. It was considered that a reasonable rate of return on capital
invested for this type of business of the Corporate Company was 8% p.a.
Calculate the value of Goodwill of the above Corporate Company which is desirous of
selling its business under Capitalization Method. 10 Marks
19. Following is the Trial Balance of Jyotsna Company Ltd., as on 31st March 215.
Directorate Of Technical Education Karnataka State Page 10
Particulars Dr.
Rs.
Cr.
Rs.
Equity Share Capital
12% Preference Share Capital
Reserve Fund
Buildings
10% Debentures
Plant and Machinery
Purchases and Sales
Salary
Debtors and Creditors
Bills
Directors Fees
Bad Debts
Returns
Wages
Opening Stock
Profit and Loss Account on 1.04.214
Loose Tools
Goodwill
Discount on Issue of Shares
Cash and Bank Balances
12% Investments (1.04.214)
Interest on Investment
-
-
-
5,00,000
-
2,00,000
2,50,000
60,000
2,30,000
80,000
20,000
5,000
15,000
15,000
45,000
-
60,000
80,000
20,000
33,000
2,00,000
-
3,00,000
2,00,000
1,50,000
-
2,00,000
-
6,00,000
-
1,75,000
90,000
-
-
20,000
-
-
60,000
-
-
-
-
-
18,000
18,13,000 18,13,000
Adjustments:
1. Closing Stock is valued at Rs. 1,40,000
2. Outstanding Wages Rs.2, 500.
3. Write off 10% of Goodwill.
4. Write off 10% of Discount on Issue of Shares.
5. Debenture Interest is outstanding for the whole year.
6. Write off Rs. 5,000 further bad debts and create Reserve for doubtful debts at 5 %
7. Building and Plant and Machinery to be depreciated by 5% and 10% respectively.
8. Transfer Rs. 25,000 to reserve.
9. The Directors proposed 15% dividend to Equity Shareholders.
You are required to prepare Company’s Final Accounts. 10 Marks
Directorate Of Technical Education Karnataka State Page 11
MODEL QUESTION BANK
DIPLOMA MODERN OFFICE MANAGEMENT
III Semester
Course title: ELEMENTS OF CORPORATE ACCOUNTING
REMEMBERING
UNDERSTANDING
APPLICATION
CO2
REMEMBERING
UNDERSTANDING
APPLICATION
CO3:
REMEMBERING
UNDERSTANDING
APPLICATION
CO4:
REMEMBERING
UNDERSTANDING
APPLICATION
CO5:
Directorate Of Technical Education Karnataka State Page 12
REMEMBERING
UNDERSTANDING
APPLICATION
CO6:
REMEMBERING
UNDERSTANDING
APPLICATION
Directorate Of Technical Education Karnataka State Page 1
Course Title: CORPORATE BUSINESS
COMMUNICATION
Credits (L:T:P) : 4:0:0 Total Contact Hours: 52 Course Code: 15MM34T
Type of Course: Lectures,
Self Study & Assignment Credit :04 Core/ Elective: Core
PREREQUISITES: Knowledge of Basic English
Course Objectives: The students shall be able to:
1) Discover the Basic Ideas in the Study of Methodology of Corporate Communication.
2) Illustrate various Modern Forms of Corporate Communication.
3) Illustrate various Modern Forms of Listening Skills.
4) Demonstrate various Techniques of Group Decision Making.
5) Express the Concept of Corporate Communication and its relevance in the Corporate
Governance.
6) Develop various Presentation Skills and Public Speaking.
At the end of the course the students should be able to:
COURSE OUTCOME CL Linked
PO
Teaching
Hours
CO1 Familiarize with different ideas in the
Study of Methodology of Corporate
Communication. U/A 1,2,3,9 08
CO2 Elucidate various Modern Forms of
Corporate Communication. A 1,2,4,9 10
CO3 Elucidate various Modern Forms of
Corporate Listening Skills A 1,2,4,9, 12
CO4 Well verse with various Techniques
of Group Decision Making U/A 1,2 10
CO5 Interpret the Centralized theme of
Corporate Communication in the field
of Corporate Governance. A 1,2,6 07
CO6 Employ various Presentation Skills
and Public Speaking. A 1,2,6, 05
COURSE WITH PROGRAM OUTCOMES LEVEL MAPPING:
COURSE PROGRAMME OUTCOMES
1 2 3 4 5 6 7 8 9 10
Corporate
Business
Communication 3 3 1 3 - 1 - - 3 -
Directorate Of Technical Education Karnataka State Page 2
Level 3- Highly Addressed, Level 2-Moderately Addressed, Level 1-Low Addressed. Method is to relate the level of PO with the number of hours devoted to the COs which address the given PO. If >40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 3 If 25 to 40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 2 If 5 to 25% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 1 If < 5% of classroom sessions addressing a particular PO, it is considered that PO is considered not-addressed.
COURSE CONTENT AND BLUE PRINT OF MARKS FOR SEE
Unit
No
Unit Name Hour
Questions to be
set for
(5marks )
PART - A
Questions to
be set for
(10marks)
PART - B
Marks
weight
age
(%)
R U A R U A
1
BASIC IDEAS IN THE
STUDY OF
METHODOLOGY OF
CORPORATE
COMMUNICATION
08 1 - - - 1 1
17.25
2 MODERN FORMS OF
CORPORATE
COMMUNICATION
10 1
-
1 - 1 1
20.69
3 CORPORATE
LISTENING SKILLS 12 1
-
- - 1 1
17.25
4 TECHNIQUES OF
GROUP DECISION
MAKING
10 -
1
1 - 1 1
20.69
5 CORPORATE
COMMUNICATION 07 1
-
- 1 1 -
17.24
6 PRESENTATION SKILLS
& PUBLIC SPEAKING 05 -
1 1
1
13.78
Total 52 09(45marks)
10(100
marks) 100.00
UNIT I: BASIC IDEAS IN THE STUDY OF METHODOLOGY OF
CORPORATE COMMUNICATION:
Meaning – Nature of Communication – Barriers to Communication – Tips for Effective
Communication – Communication Theories and Models – Audience Analysis – SWOT Analysis.
8 Hours
UNIT 2: MODERN FORMS OF CORPORATE COMMUNICATION
Identification of various Modern Forms of Corporation Communication - Meaning –
Advantages and Disadvantages of Fax and Internet/E-mail – Concept of Video Conferencing.
10 Hours
Directorate Of Technical Education Karnataka State Page 3
UNIT 3: CORPORATE LISTENING SKILLS
Concept of Listening – Process of Listening – Barriers to Effective Listening - Benefits of
Active Listening – Tips for Effective Listening - Kinds of Listening – Factors that hampers
Listening – Common Poor Listening Habits.
12 Hours
UNIT 4: TECHNIQUES OF GROUP DECISION MAKING:
Meaning of Group – Decision Making - Committee Meetings – Command Meetings –
Brainstorming Session – Nominal Group Technique - Delphi Technique – Conferences – Types -
Advantages – Disadvantages - Seminars – Symposia and Workshop.
10 Hours
UNIT 5: CORPORATE COMMUNICATION:
Concept of Corporate Communication – Nature – Functions of House Journals –
Corporate Brochures – Information Booklets - Nature – Functions of Press Releases - Press
Conferences – Meaning – Objects of Public Relations – Internal and External PR – Tools of PR.
07 Hours
UNIT 6: PRESENTATION SKILLS & PUBLIC SPEAKING:
Meaning of Presentation – Elements of Presentation – Designing of Presentation - Tips for
Effective Presentation – Public Speaking – Benefits of Public Speaking – Tips for Effective
Public Speaking.
05 Hours
BOOKS RECOMMENDED:
1. Business Communication by V.K.Jain & Omprakash Biyani – S.Chand Company
Ltd.
2. Effective Business Communication by Krizan, Merrer, Logan and William –
Cengage Learning.
3. Communication Skills – Dr. Nageshwar Rao and Dr.Rajendar.P.Das.- Himalaya
Publications
REFERENCES:
1. www.businessdictionary.com/definition/corporate-communication.html 2. www.englishtown.com/community/portal/business/bizcom/free.aspx 3. www.slideshare.net/freelancemkt1/chapt1-ppt-business-communications 4. www.slideshare.net/niks_pinks/business-communication-ppt-15553926
Course Delivery: The course will be delivered through lectures and Power point presentations/
Video
Directorate Of Technical Education Karnataka State Page 4
MODEL OF RUBRICS FOR ASSESSING STUDENT ACTIVITY:
FORMAT FOR STUDENT ACTIVITY ASSESSMENT
DIMENSION Unsatisfactory
1 Developing
2 Satisfactory
3 Good
4
Exemplary 5
Score
Collection of
data
Does not
collect any
information
relating to the
topic
Collects
very limited
information;
some relate
to the topic
Collects
some basic
information;
refer to the
topic
Collects
relevant
information;
concerned
to the topic
Collects a
great deal of
information;
all refer to
the topic
3
Fulfill team’s
roles & duties
Does not
perform any
duties assigned
to the team
role
Performs
very little
duties
Performs
nearly all
duties
Performs all
duties
Performs all
duties of
assigned
team roles
with
presentation
4
Shares work
equally
Always relies
on others to do
the work
Rarely does
the assigned
work; often
needs
reminding
Usually
does the
assigned
work; rarely
needs
reminding
Does the
assigned job
without
having to be
reminded.
Always
does the
assigned
work
without
having to be
reminded
and on
given time
frame
3
Listen to
other Team
mates
Is always
talking; never
allows anyone
else to speak
Usually
does most
of the
talking;
rarely
allows
others to
speak
Listens, but
sometimes
talk too
much
Listens and
contributes
to the
relevant
topic
Listens and
contributes
precisely to
the relevant
topic and
exhibit
leadership
qualities
3
TOTAL
13/4=
3.25=
4
*All student activities should be done in a group of 4-5 students with a team leader.
Directorate Of Technical Education Karnataka State Page 5
COURSE ASSESSMENT AND EVALUATION The Course will be Delivered Through Lectures, Class Room Interaction, Exercises and
Self Study Cases.
What
To
Whom
When/Where
(Frequency in
the Course)
Max.
Marks
(Theory)
Evidence
CO’s
Mapped
Direct
Assessment
Method
CIE
IA Test
ST
UD
EN
TS
3 Tests
(Average of 3
tests will be
Taken)
20 Blue Books 1 – 6
Assignment
Assignment
Report 05 Assign
Reports 1 – 6
Total 25
SEE End Exam End of Course 100 Answer Script 1 – 6
Indirect
Assessment
Method
Student Feedback Middle of the
Course
-NA-
Feed Back
Forms
1 – 6 delivery
of the Course
End of Course
Survey End of Course Questionnaire
Effectiveness of
delivery of
Instruction and
assessment methods Note: I.A. test shall be conducted for 20 marks. Average marks of three tests shall be rounded
off to the next higher digit.
MODEL QUESTION PAPER (CIE)
Test/Date and
Time Semester/year Course/Course Code
Max
Marks
Ex: I test/6 th
weak
of Sem 10-11 Am
III SEM CORPORATE BUSINESS
COMMUNICATION 20
Year: 2015-16 Course code:15MM34T
Name of Course coordinator :
Units:1,2 Co: 1,2
Note: Answer all questions
Question
no Question CL CO PO
1 Write a Short Note on ‘Video Conferencing’. R 1 1,2
2
What do you understand by SWOT Analysis?
OR
What do you mean by Presentation? U 1 1,2
3
Suggest various Tips for Effective Presentation.
OR
Describe various steps involved in the process of Listening
A 2 1,2
Directorate Of Technical Education Karnataka State Page 6
4
Enumerate the application of Brainstorming Session and Delphi
Technique. A 2 1,2
Note to IA verifier: The following documents to be verified by CIE verifier at the end of
semester
1. Blue books ( 20 marks)
2. Student suggested activities report for 5 marks and should be assessed on RUBRICS
Student feedback on course regarding Effectiveness of Delivery of instructions & Assessment
Methods.
Directorate Of Technical Education Karnataka State Page 7
GOVERNMENT OF KARNATAKA
DEPARTMENT OF TECHNICAL EDUCATION BOARD OF TECHNICAL EXAMINATIONS
DIPLOMA IN BUSINESS ADMINISTRATION MODEL QUESTION PAPER
15MM34T - CORPORATE BUSINESS COMMUNICATION
Time: 3 Hours Max.Marks: 100
Instruction: 1) Part – A. Answer any SIX questions from a set of 9 Questions.
Each question carries 5 Marks.
2) Part – B. Answer any SEVEN questions from a set of 10 Questions.
Each question carries 10 Marks.
PART – A
(Answer any SIX Questions from this Section) 6 x 5 = 30
1. Explain the benefits of Public Speaking.
2. Write a Short Note on ‘Video Conferencing’.
3. What do you understand by SWOT Analysis?
4. Explain the Benefits of Fax.
5. Explain the Concept of Modern Listening.
6. Identify various techniques of Group Decision Making.
7. Explain the Concept of Corporate Communication.
8. What do you mean by Presentation?
9. List out the Functions of Corporate Brochures.
PART – A
(Answer any SEVEN Questions from this Section) 10 x 7 = 70
10. Describe various barriers to Effective Corporate Communication.
11. Briefly describe the different types of Audience.
12. What are the advantages and disadvantages of Internet/Email?
13. Describe various steps involved in the process of Listening.
14. Enumerate the application of Brainstorming Session and Delphi Technique.
15. What are the advantages and disadvantages of Conferences?
16. Suggest various Tips for Effective Presentation.
17. What are the advantages and disadvantages of Seminars, Symposia and Workshop?
18. What are the Functions of ‘House Journals’ and ‘Corporate Brouchers’?
Directorate Of Technical Education Karnataka State Page 8
19. What do you understand by the ‘Corporate Public Relations’ and explain the Types of
‘Corporate Public Relations’.
************
Directorate Of Technical Education Karnataka State Page 9
MODEL QUESTION BANK
DIPLOMA MODERN OFFICE MANAGEMENT
III Semester
Course title: CORPORATE BUSINESS COMMUNICATION
REMEMBERING
UNDERSTANDING
APPLICATION
CO2
REMEMBERING
UNDERSTANDING
APPLICATION
CO3:
REMEMBERING
UNDERSTANDING
APPLICATION
CO4:
REMEMBERING
UNDERSTANDING
APPLICATION
CO5:
Directorate Of Technical Education Karnataka State Page 10
REMEMBERING
UNDERSTANDING
APPLICATION
CO6:
REMEMBERING
UNDERSTANDING
APPLICATION
Directorate Of Technical Education Karnataka State Page 1
Course Title: WEB DESIGNING LAB
Credits (L:T:P) : 0:2:4 Total Contact Hours: 78 Course Code: l5MM35P
Type of Course: Tutorial and
Practical’s Credit :03 Core/ Elective: Core
PREREQUISITES: Knowledge of Text Editor and Basics of Internet.
COURSE OBJECTIVES:
The Students shall be able to;
Create HTML Documents with formatting, images, tables, frames, embed multi-media
objects and develop a static website using Hyper Text Mark-up Language.
At the end of the Course the students shall be able to:
Course Outcome CL Experiment
linked
Linked PO Teaching
Hrs
CO1 Understand the concepts
of website development U
Unit-I 1,2,4,8,10 6
CO2
Demonstrate knowledge
and skills utilizing various
HTML tags for designing
a static web page.
U/A 1,2,3,4 1,2,3,4,8,9,10 27
CO3
Apply screen-based user
interfaces, with graphics,
textual components, and
navigation systems to
achieve a unified,
functional environment
that results in static web
pages.
U/A 5,6,7,8,910,11,12 1,2,3,4,8,9,10 24
CO4
Illustrate Table, Frames
and relate the Cascading
Style Sheets (CSS)
features to specify various
aspects of style, such as
colours and text fonts and
sizes, in their HTML
documents and to
understand the difference
between linked,
embedded and inline style
specifications and how
they operate in a
“cascade”.
U/A 13,14,15,16 1,2,3,4,8,9,10 21
Total Sessions 78
Legends: R = Remember U= Understand; A= Apply and above levels (Bloom’s revised taxonomy)
Directorate Of Technical Education Karnataka State Page 2
Course-PO Attainment Matrix
Course
Programme Outcomes
1 2 3 4 5 6 7 8 9 10
Web Design Lab 3 3 3 3 0 0 0 3 3 3
Level 3- Highly Addressed, Level 2-Moderately Addressed, Level 1-Low Addressed. Method is to relate the level of PO with the number of hours devoted to the COs which address the given PO. If >40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 3 If 25 to 40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 2 If 5 to 25% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 1 If < 5% of classroom sessions addressing a particular PO, it is considered that PO is considered not-addressed.
CONTENT
UNIT – I
Tutorials
1. Introduction to HTML: Web site, Web Page, Types of Web Pages, Browsers and their types,
Client –Server Model, Web –Server, Working of different types of Web Pages, General
structure of a Web Page, Scripting languages, URL, Popular Search Engines, WWW
UNIT-II
Note: All attributes pertaining to respective tags to be practiced.
2. Structure of HTML web page:
<Head>, <title>, <body>, comments, <div>, <h1>……<h6>, <hr>, <br>
3. Basic HTML physical character tags:
<b>, <i>, <u>, <big>, <small>, <sup>, <sub>, <strike>
4. Logical character tags:
<em>, <strong>, <del>, <insert>, <cite>, <code>, <dfn>, <ins>, <kbd>, <samp>,
<strong>
5. Other HTML tags:
<p>, <font>, <abbr>, <acronym>, <address>, <blockquote>, <quote>, <q>
6. List tags: all tags pertaining to Lists
7. Table tags.
8. Hyper link tag (both Internal & External).
9. Working with Frame and Form tags.
10. Image tags & embedding a multimedia on to a web page(video, audio, zip)
11. Working with CSS (Cascading Style Sheet).
12. Develop a web page using the above tags.
List of Graded Exercises
1. Design a page having suitable background colour and text colour with title “My First Web
Page” using all the attributes of the Font tag.
2. Create a HTML document giving details of your [Name, Age], [Address, Phone] and
[Register Number, Class] aligned in proper order using alignment attributes of Paragraph
tag.
Directorate Of Technical Education Karnataka State Page 3
3. Write HTML code to design a page containing some text in a paragraph by giving suitable
heading style.
4. Create a page to show different character formatting (B, I, U, SUB, SUP) tags.
viz : log b m p = p logb m
5. Write HTML code to create a Web Page that contains an Image at its centre.
6. Create a web page with an appropriate image towards the left hand side of the page, when
user clicks on the image another web page should open.
7. Create web Pages using Anchor tag with its attributes for external links.
8. Create a web page for internal links; when the user clicks on different links on the web page
it should go to the appropriate locations/sections in the same page.
9. Write a HTML code to create a web page with pink colour background and display moving
message in red colour.
10. Create a web page, showing an ordered list of all second semester courses (Subjects).
11. Create a web page, showing an unordered list of names of all the Diploma Programmes
(Branches) in your institution.
12. Create a HTML document containing a nested list showing a content page of any book.
13. Create the following table in HTML with Dummy Data:
Reg.
Number
Student
Name Year/Semester
Date of
Admission
14. Create a web page which divides the page in two equal frames and place the audio and
video clips in frame-1 and frame-2 respectively.
FRAME-1 FRAME-2
15. Create a web page which should generate following output:
16. Create a web page using Embedded CSS and multimedia
Mini Project (CIE -05 Marks):
Develop a static website consisting of minimum five web pages using any open source
Editor like Bluefish, etc.
FRAME-1 FRAME-2
FRAME-3
Directorate Of Technical Education Karnataka State Page 4
Course Assessment and Evaluation Scheme:
The course will be delivered through tutorials of two hours per week and four hours of hands on
practice.
COURSE ASSESSMENT AND EVALUATION The Course will be Delivered Through Lectures, Class Room Interaction, Exercises and
Self Study Cases.
What
To
Whom
When/Where
(Frequency in
the Course)
Mal.
Marks
(Prac)
Evidence
CO’s
Mapped
Direct
Assessment
Method
CIE
IA Test
ST
UD
EN
TS
Two IA Tests;
Average of two
Tests to be
considered.
l0 Blue
books l,2,3,4
Assign
ment
Record Writing l0 Record
Book
Report
l,2,3,4 Assignment/
Mini Project 05
SEE End Elam TOTAL 25
Indirect
Assessment
Method
Student Feedback Middle of the
Course End of
the
course
Middle
of the
course
50
Answer
scripts at
BTE
End of Course
Survey End of Course
Feedback
forms
*CIE – Continuous Internal Evaluation *SEE – Semester End Examination
Note: 1. I.A. test shall be conducted as per SEE scheme of valuation. However obtained marks shall
be reduced to 10 marks. Average marks of two tests shall be rounded off to the next higher digit.
2. Rubrics to be devised appropriately by the concerned faculty to assess Student activities.
Questions for CIE and SEE will be designed to evaluate the various educational components
(Bloom’s taxonomy) such as:
Sl. No Bloom’s Category %
Weightage
Weightage 1 Remembrance 10
2 Understanding 30
3 Application 60
Directorate Of Technical Education Karnataka State Page 5
FORMAT FOR STUDENT ACTIVITY ASSESSMENT
DIMENSION Unsatisfactory
1 Developing
2 Satisfactory
3 Good
4
Exemplary 5
Score
Collection of
data
Does not
collect any
information
relating to the
topic
Collects
very limited
information;
some relate
to the topic
Collects
some basic
information;
refer to the
topic
Collects
relevant
information;
concerned
to the topic
Collects a
great deal of
information;
all refer to
the topic
3
Fulfill team’s
roles &
duties
Does not
perform any
duties assigned
to the team
role
Performs
very little
duties
Performs
nearly all
duties
Performs all
duties
Performs all
duties of
assigned
team roles
with
presentation
4
Shares work
equally
Always relies
on others to do
the work
Rarely does
the assigned
work; often
needs
reminding
Usually
does the
assigned
work; rarely
needs
reminding
Does the
assigned job
without
having to be
reminded.
Always
does the
assigned
work
without
having to be
reminded
and on
given time
frame
3
Listen to
other Team
mates
Is always
talking; never
allows anyone
else to speak
Usually
does most
of the
talking;
rarely
allows
others to
speak
Listens, but
sometimes
talk too
much
Listens and
contributes
to the
relevant
topic
Listens and
contributes
precisely to
the relevant
topic and
exhibit
leadership
qualities
3
TOTAL 13/4=
3.25=4
*All student activities should be done in a group of 4-5 students with a team leader.
SCHEME OF EXAMINATION:
Sl.
NO. SCHEME
Max.
Marks
l Lab Record/Graded Exercises 05
2 Writing Steps / Procedure to be followed
for one Question from Unit-II l5
3 Execution of the Given Questions 20
4 Viva voce l0
Total 50
Directorate Of Technical Education Karnataka State Page 6
Note: 1. Candidate shall submit Lab Record for the Examination.
2. Student shall be allowed to execute directly even if she / he unable to write the
procedure
3. In case of change in experiment or no write up, marks will not be awarded for
Writing procedure/steps.
BOOKS RECOMMENDED:
1. HTML5 Step by Step by Wempen – PHI Learning
References:
http://www.w3schools.com/html/default.asp
http://sourceforge.net/projects/bluefish/
http://bluefish.openoffice.nl/index.html
http://bluefish.openoffice.nl/features.html
Resource requirements for Web Design Lab
Hardware Requirement:
Sl. No. Equipment Quantity
1 PC systems (latest configurations with speakers) 20
2 Laser Printers 03
3 Networking (Structured) with CAT 6e / wireless
24 Port switches / Wireless Router
I/O Boxes for networking(as required)
03
4 Broad Band Connection 01
Software Requirement: Linux / equivalent Operating System, Editor, Web Browsers.
Note:
Students: Computers Ratio in the Lab should be strictly 1:1 for a Batch of Ttwenty Students.
Directorate Of Technical Education Karnataka State Page 7
MODEL QUESTION BANK
Course Title WEB DESIGN LAB Course Code: l5MM35P
Note: One Question to be given from the following.
1. Illustrate a page having suitable background colour and text colour with title “My First Web
Page” using all the attributes of the Font tag.
2. Create a HTML document giving details of your [Name, Age], [Address, Phone] and
[Register Number, Class] aligned in proper order using alignment attributes of Paragraph
tag.
3. Write HTML code to design a page containing some text in a paragraph by giving suitable
heading style.
4. Create a page to show different character formatting (B, I, U, SUB, SUP) tags.
viz: log b m p = p logb m
5. Write HTML code to create a Web Page that contains an Image at its centre.
6. Create a web page with an appropriate image towards the left hand side of the page, when
user clicks on the image another web page should open.
7. Create web Pages using Anchor tag with its attributes for external links.
8. Create a web page for internal links; when the user clicks on different links on the web page
it should go to the appropriate locations/sections in the same page.
9. Write a HTML code to create a web page with pink colour background and display moving
message in red colour.
10. Create a web page, showing an ordered list of all second semester courses (Subjects).
11. Create a web page, showing an unordered list of names of all the Diploma Programmes
(Branches) in your institution.
12. Create a HTML document containing a nested list showing a content page of any book.
13. Create the following table in HTML with Dummy Data:
Reg.
Number
Student
Name Year/Semester
Date of
Admission
14. Create a web page which divides the page in two equal frames and place the audio and
video clips in frame-1 and frame-2 respectively.
FRAME-1 FRAME-2
15. Create a web page which should generate following output:
16. Create a web page using Embedded CSS and multimedia
FRAME-1 FRAME-2
FRAME-3
Directorate Of Technical Education Karnataka State Page 1
Course Title: RELATIONAL DATA BASE MANAGEMENT
SYSTEM
Credits (L:T:P) : 0:2:4 Total Contact Hours: 78 Course Code: 15MM36P
Type of Course: Tutorial and
Practical’s Credit :03 Core/ Elective: Core
PREREQUISITES: Knowledge of Computers.
COURSE OBJECTIVES:
The Students will be able to;
1. Familiarize the Students with various Concepts of Database and its Uses.
2. Enable the Students to acquire Skills about Database Model.
3. Know the Concept of E.R Diagram and ER Modeling.
4. Understand and Comprehend different SQL Statements or Database
Language.
At the end of the Course the students shall be able to:
Course Outcome CL Experime
nt linked
Linked
PO Teaching
Hrs
CO1
Explain the underlying
concepts of database
technologies. Design and
implement a database schema
for a given problem-domain.
U/A 1,2,3 1 to 10 03
CO2 Apply Normalization to a
database. U/A 1,2,3 1 to 10 03
CO3
Illustrate and query a database
using SQL DML/DDL
commands To motivate the
students to relate all these to
one or more commercial
product environments as they
relate to the developer tasks
A 1 to 7 1 to 10 48
CO4 Design, create, build, and
debug Gambas /Visual Basic
Database applications. A 7 1 to 10 24
Total
sessions 78
Legends: R = Remember U= Understand; A= Apply and above levels (Bloom’s revised
taxonomy)
Directorate Of Technical Education Karnataka State Page 2
Course-PO Attainment Matrix
Course
Programme Outcomes
1 2 3 4 5 6 7 8 9 10
RDBMS 3 3 3 3 0 0 1 2 1 3
Level 3- Highly Addressed, Level 2-Moderately Addressed, Level 1-Low Addressed. Method is to relate the level of PO with the number of hours devoted to the COs which address the given PO. If >40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 3 If 25 to 40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 2 If 5 to 25% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 1 If < 5% of classroom sessions addressing a particular PO, it is considered that PO is considered not-addressed.
List of Graded Practical Exercises
1. Using any Open Source Data Modelling tool (MySQL/Rational Rose/ERwin), design and
develop a ER diagram for the following Library database. Specify relevant Referential
constraints.
BOOK_AUTHORS
BOOK_ID AUTHOR_NAME
PUBLISHER
NAME ADDRESS PHONE
BOOK_COPIES
BOOK_ID BRANCH_ID NO_COPIES
BOOK_LOANS
BOOK_ID BRANCH_ID CARD_NO DATE_HIRED DUE_DATE
LIBRARY_BRANCH
BRANCH_ID BRANCH_NAME ADDRESS
BORROWER
CARD_NO NAME ADDRESS PHONE
2. Consider a GRADE_BOOK database in which instructors within an academic
department record point earned by individual students in theory classes. The data
requirements are summarized as follows:
Each student is identified by a unique identifier, first and last name and an email
address.
Each instructor teaches certain courses each term. Each course is identified by a
course number, a section number and the term in it is taught. For each course he or
she teaches, the instructor specifies the minimum number of points required in order
to earn letter grades, A, B, C, D and F. For Ex. 90 points for an A, 80 points for a B,
70 points for a C and so forth.
Students are enrolled in each course taught by the instructor.
Directorate Of Technical Education Karnataka State Page 3
Each course has a number of grading components (such as mid-term exam, final
exam, project and so forth). Each grading component has a maximum number of
points (100 or 50) and a weight (20% or 10%). The weight of all the grading
components of a course is 100.
Finally, the instructor records the points earned by each student in each of the
grading components in each course. For Ex. The student 1234 earns 84 points for a
mid-term exam, grading component of the section 2 course CS 2310 in the fall term
of 2009. The mid-term exam grading component may have been defined to have a
maximum of 100 points and a weight of 20% of the course grade.
3. Create the following tables for a COMPANY database
EMPLOYEE
Fname Minit Lname Ssn Bdate Address Sex Salary Super_ssn Dno
DEPARTMENT
Dname Dnumber Mgr_ssn Mgr_start_date
DEPT_LOCATIONS
Dnumber Dlocation
PROJECT
Pname Pnumber Plocation Dnum
WORKS_ON
Essn Pno Hours
DEPENDENT
Essn Dependent_name Sex Bdate Relationship
4 Illustrate the use of constraints
NOT NULL
PRIMARY KEY
UNIQUE
CHECK
DEFAULT
REFERENCES
5 DATA MANIPULATION : INSERTING VALUES INTO A TABLE
6 Illustrate the use of SELECT statement
7 Conditional retrieval - WHERE clause
8 Query sorted - ORDER BY clause
9 Grouping the result of query - GROUP BY clause and HAVING clause
10 Aggregate functions in SQL (Count, Sum, Max, Min, Avg)
11 SQL operators(And, Or, Like, Between, In)
12 Query multiple tables using JOIN operation.
13 Write nested and complex queries using multiple tables.
14 Perform UPDATE, ALTER, DELETE, DROP operations on tables
15 Illustrate the use of CREATE VIEW command and manipulating
16 Use COMMIT and ROLL BACK commands
17 Use SAVEPOINT commands
Directorate Of Technical Education Karnataka State Page 4
18. GUI
1. To study about various Gambas/Visual Basic (front end) or any other front
end tool
2. Design a form to use various tools like label, text, combo box, list boxes,
check box, option box, horizontal and vertical scroll bars, etc. Illustrate the
above with an example such as survey form, registration form for an event or
another other example.
3. Design a menu driven form to process student’s results or a shopping list or
any other example.
4. Generate a report for student’s results or employee details or shopping list or
any other example.
5. Based on any database specified in Question No. 1, 2 or 3. The application
must be menu driven having suitable active controls with database
connectivity. Generate different reports as per user requirements.
BOOKS RECOMMENDED:
1. Database Management System by Chatterjee – PHI Learning.
2. Database Management System by Alexis Leon & Mathews Leon
3. Problem – Solving Cases using MS Access by Brandy Mons
4. DBMS a Practical Approach by E R Rajiv Chopra – S Chand Publications.
5. Com Primer – Wrox.
6. Database Management System by Hannur
7. SQL Popcorn by Ghosh – PHI Learning.
References:
http://www.w3schools.com/html/default.asp
http://sourceforge.net/projects/bluefish/
http://bluefish.openoffice.nl/index.html
http://bluefish.openoffice.nl/features.html
Suggested list of student activities
Note: The following activities or similar activities for assessing CIE (IA) for 5 marks (Any
one)
Student activity like mini-project, surveys, quizzes, etc. should be done in group of 3-5 students.
1. Each group should do any one of the following type activity or any other similar
activity related to the course and before conduction, get it approved from concerned
course co-ordinator and programme co-ordinator.
2. Each group should conduct different activity and no repeating should occur.
Build RDBMS application for processing students’ details such as personal
details, results, attendance etc. Use minimum 3-4 tables
Build RDBMS application for maintain a mini library of CD’s. Use minimum
3-4 tables
Using any ER diagram modelling tool demonstrate modelling of any database
containing 3-4 tables.
Directorate Of Technical Education Karnataka State Page 5
Course Delivery
The course will be delivered through Demonstration and Practices:
COURSE ASSESSMENT AND EVALUATION The Course will be Delivered Through Lectures, Class Room Interaction, Exercises and
Self Study Cases.
What
To
Whom
When/Where
(Frequency in
the Course)
Max.
Marks
(Prac)
Evidence
CO’s
Mapped
Direct
Assessment
Method
CIE
IA Test S
TU
DE
NT
S
2 Tests
(Average of 2 tests
will be Taken)
10 Prac
Record 1 – 4
Assignment
Assign/Prac
Record 5+10
Blue
Book/Log
of Activity
1 – 4
Total 25
SEE End Exam End of Course 50 Answer
Script 1 – 4
Indirect
Assessment
Method
Student Feedback Middle of the
Course
-NA-
Feed Back
Forms
1 – 4 delivery of
the Course
End of Course
Survey End of Course
Questio
nnaire
Effectiveness of
delivery of
Instruction and
assessment methods
*CIE – Continuous Internal Evaluation *SEE – Semester End Examination
Note: 1. I.A. test shall be conducted as per SEE scheme of valuation. However obtained
marks shall be reduced to 10 marks. Average marks of two tests shall be rounded off to
the next higher digit.
2. Rubrics to be devised appropriately by the concerned faculty to assess Student activities.
Questions for CIE and SEE will be designed to evaluate the various educational
components (Bloom’s taxonomy) such as:
Sl. No Bloom’s Category %
Weightage
Weightage 1 Remembrance 10
2 Understanding 20
3 Application 70
Directorate Of Technical Education Karnataka State Page 6
Note to IA verifier: The following documents to be verified by CIE verifier at the end of
semester
1. Blue books (10 marks)
2. Record (10 marks)
3. Student suggested activities report for 5 marks
4. Student feedback on course regarding Effectiveness of Delivery of instructions &
Assessment Methods.
Format for Student Activity Assessment
DIMENSION Unsatisfactory
1 Developing
2 Satisfactory
3 Good
4
Exemplary 5
Score
Collection of
data
Does not
collect any
information
relating to the
topic
Collects
very limited
information;
some relate
to the topic
Collects
some basic
information;
refer to the
topic
Collects
relevant
information;
concerned
to the topic
Collects a
great deal of
information;
all refer to
the topic
3
Fulfill team’s
roles &
duties
Does not
perform any
duties assigned
to the team
role
Performs
very little
duties
Performs
nearly all
duties
Performs all
duties
Performs all
duties of
assigned
team roles
with
presentation
4
Shares work
equally
Always relies
on others to do
the work
Rarely does
the assigned
work; often
needs
reminding
Usually
does the
assigned
work; rarely
needs
reminding
Does the
assigned job
without
having to be
reminded.
Always
does the
assigned
work
without
having to be
reminded
and on
given time
frame
3
Listen to
other Team
mates
Is always
talking; never
allows anyone
else to speak
Usually
does most
of the
talking;
rarely
allows
others to
speak
Listens, but
sometimes
talk too
much
Listens and
contributes
to the
relevant
topic
Listens and
contributes
precisely to
the relevant
topic and
exhibit
leadership
qualities
3
TOTAL 13/4=3.25=4
*All student activities should be done in a group of 4-5 students with a team leader.
Directorate Of Technical Education Karnataka State Page 7
SCHEME OF EXAMINATION:
Sl.
NO. SCHEME
Max.
Marks
1 Lab Record/Graded Exercises 05
2 Writing Steps / Procedure to be followed
for one Question from Unit-II 15
3 Execution of the Given Questions 20
4 Viva voce 10
Total 50
**Evaluation should be based on the screen output only. No hard copy required.
**Change of question is allowed only once. Marks of 05 should be deducted in the given
question.
MODEL QUESTION BANK
1. a) Create table Employee and Dependent as per the following schema: Identify the Primary
and referential constraints on the table. Specify suitable constraint on the salary column
such that 12000 < Salary < 120000.
i) Employee Table
Fname Lname ssn Bdate Address Sex Salary Super
ssn
Dno
ii) Dependent Table
Essn Dependent_name Sex Bdate
b) Insert records into the above tables.
c). Queries to be executed
Add another column Relationship to dependent Table
Retrieve all female dependents of the employees who have joined service after 31-
01-2010
Retrieve the no. Of employees and total salary drawn by the employees belonging to
department no. 10.
d) Create a GUI to show any one of the table contents(include data grid view and perform
operations such as add, delete, modify etc)
2. a) Create table BOOK ,BOOK_AUTHORS and PUBLISHER with following Schema.
Identify the Primary and referential constraints on the tables. Specify default constraint
on gender column of BOOK _AUTHOR table.
i) BOOK
Book_id Title Publisher_name
ii) BOOK_AUTHOR
Book_id Author_name Gender
iii) PUBLISHER
Directorate Of Technical Education Karnataka State Page 8
Name Address Phone
b) Insert records into the above tables.
c) Queries to be executed
Retrieve the book details of all the books authored by “Sharma”.
Delete the record for the publisher by name “sapna”.
For each publisher retrieve the total number of book titles published.
d) Create a GUI to show any one of the table contents(include data grid view and perform
operations such as add, delete, modify etc).
3. a) Create table EMPLOYEE,PROJECT and WORKS_ON as per the following schema:
Identify the Primary and referential constraints on the table.
i) Employee Table
Fname Lname Ssn Bdate Address Sex Salary Super ssn Dno
ii) Project table
P_name Pno P_location
iii) Works_On
Essn Pno Hours
b) Insert records into the above tables.
c) Queries to be executed
Retrieve employee name, address and salary with all employee names
first letter in capital.
For each employee retrieve the total projects and total no. of hours he/she
works on.
Illustrate the use of Save point, Rollback and Commit transaction
commands.
d) Create a GUI to show any one of the table contents (include data grid view and perform
operations such as add, delete, modify etc).
4. a). Create table BOOK,BOOK_BORROWED and BOOK_BORROWER as per the
following schema: Identify the Primary and referential constraints on the table.
i) Book
Book_id Title Publisher name
ii) Book Borrowed
Book_id Card_No Date_out Due_Date
iii) Book Borrower
Card_No Name Address Phone
Directorate Of Technical Education Karnataka State Page 9
b) Insert records into the above tables.
c) Queries to be executed
Retrieve the names of people who have borrowed “Computer Network” book.
Retrieve the number of days permitted to borrow “Computer Organization”
by “Cherry”.
Illustrate the use of any four numeric functions.
d) Create a GUI to show any one of the table contents (include data grid view and perform
operations such as add, delete, modify etc).
5. a) Create table CUSTOMER , ACCOUNT, LOAN as per the following schema: Identify
the Primary and referential constraints on the table.
i) Customer
ii) Account
Account_no. Transaction type Amount Balance
iv) Loan
b) Insert records into the above tables.
c) Queries to be executed
Retrieve all customers who have availed the loan amount of more than 5 lakhs.
Create a view with the following attributes: Customer name, bank balance and loan
amount.
Illustrate the use of Grant and Revoke commands.
d) Create a GUI to show any one of the table contents (include data grid view and
perform operations such as add, delete, modify etc).
6. a) Create table ART_OBJECT, PAINTING and STATUE as per the following schema:
Identify the Primary and referential constraints on the table.
i) Art_object
Id_no Artist_Name Year_Created Title Art_type Description
Art type can either Painting or Statue
ii) PAINTING
Paint_type Base_Material Style Price
Paint type can be oil or water colour or organic colour
Base material can be paper, canvas or wood
Style can be Modern or Abstract
iv) Statue
Material type Height Weight Style Price
Material type can be stone, wood, glass
Style can be Modern or Abstract
b) Insert records into the above tables.
c) Queries to be executed
Retrieve the details of the costliest painting using nested queries.
Account_no Name Address Phone
Loan _no Account_no Amount Loan type Interest rate
Directorate Of Technical Education Karnataka State Page 10
Retrieve the names of the artist who have worked on Abstract style
Delete all the records pertaining to the artist by name “Sahithya”.
d) Create a GUI to show any one of the table contents (include data grid view and perform
operations such as add, delete, modify etc).
Directorate Of Technical Education Karnataka State Page 1
Course Title: MICRO PROJECT LAB
Credits (L:T:P) : 0:2:4 Total Contact Hours: 78 Course Code: 15MM37P
Type of Course: Lectures,
Self Study & Assignment Credit :03 Core/ Elective: Core
PREREQUISITES: Knowledge of Business and Management.
COURSE OBJECTIVE:
The Students shall be able to:
1. Apply the usually followed Instructions in compiling and preparing any kind of
Project Reports.
At the end of the Course the Students shall be able to:
COURSE OUTCOME:
Submit the Prepared Micro Project Report strictly adhering to the laid down instructions and guidelines.
INSTRUCTIONS TO BE COMPLIED WITH BY THE CANDIDATES FOR SUBMITTING
THE MICRO PROJECT REPORT:
The Candidates of this particular Subject are instructed to submit the prepared Micro Project
Report on Topics pertaining to the Business and Management to the Evaluators/Examiners
for the purpose of Evaluation in the end Examination. The Micro Project Report may be
compiled and submitted by the Candidates individually to the concerned
Evaluators/Examiners. The Micro Project Report may be submitted by the Candidate on his
own or from the guidance of any Guide belonging to the
Institution/Factory/Industry/Company/MNCs/Government/Semi-Government Organizations.
(The Candidates should be deputed for a period of TWO weeks as
INTERNSHIP to any of the above mentioned organizations)
CRITICAL APPRAISAL OF THE PERFORMANCE OF THE CANDIDATES:
The concerned Guiding Faculty Member(s) of this particular Subject are instructed to
supervise and Review the Task of Submission of Micro Project Report Periodically and assess
the performance of the Candidates from time to time.
SCHEME OF EVALUATION:
End Examination Marks: 50 marks
At the time of End Examination of this Subject, while submission of the Micro Project
Report, the Evaluators/Examiners of the Subject are to evaluate the Performance of the
Candidates strictly adhering to the following laid down guidelines:
Directorate Of Technical Education Karnataka State Page 2
a) For an Orderly and Objective arrangement and submission of Micro Project Report,
Marks are to be awarded out of 5.
b) For Final Presentation of Micro Project Report by the Candidate himself/herself
before the Examiners at the time of end Examination, Marks are to be awarded out
of 40.
c) Finally, a Viva-voce is to be conducted on the contents of the prepared Micro
Project Report by the end Examiners for the purpose of assessing the overall
performance of the Candidates, Marks are to be awarded out of 5.
INTERNAL ASSESSMENT: 25 marks.
Internal Assessment Marks of this particular Subject are to be awarded strictly
adhering to the guidelines as enumerated herein under:
a) For clear cut submission of Synopsis of Micro Project Report, Marks are to be
awarded out of 5 by the Internal Evaluator(s).
b) For submission of Progress Reports in due course while in the process of
preparation of Micro Project Report i.e. One in the First Interval and the another in
the Final Stage of compilation of Micro Project Report, Marks are to be awarded for
both Progress Reports (at the rate of 5 Marks for each Progress Report) put together
out of 10 Marks.
c) For Mini Presentation of Micro Project Report by the concerned candidates on trial
basis in systematic and schematic manner before the Internal Evaluators, Marks are
to be awarded out of 10.
BOOKS RECOMMENDED:
REFERENCES:
1. Project Management by R. Pannerselvam and P.Senthilkumar – PHI Learning.
2. Essential of Project Management by Ramakrishna – PHI Learning.
1. https://products.office.com/en-us/project/project-and-portfolio 2. www.microprojects.ca 3. www.projectconnections.com/.../detail/micro-project-plan-template.html
Course Delivery: The course will be delivered through lectures and Power point
presentations.
Directorate Of Technical Education Karnataka State Page 3
MODEL OF RUBRICS FOR ASSESSING STUDENT ACTIVITY:
FORMAT FOR STUDENT ACTIVITY ASSESSMENT
DIMENSION Unsatisfactory
1 Developing
2 Satisfactory
3 Good
4
Exemplary 5
Score
Collection of
data
Does not
collect any
information
relating to the
topic
Collects
very limited
information;
some relate
to the topic
Collects
some basic
information;
refer to the
topic
Collects
relevant
information;
concerned
to the topic
Collects a
great deal of
information;
all refer to
the topic
3
Fulfill team’s
roles & duties
Does not
perform any
duties assigned
to the team
role
Performs
very little
duties
Performs
nearly all
duties
Performs all
duties
Performs all
duties of
assigned
team roles
with
presentation
4
Shares work
equally
Always relies
on others to do
the work
Rarely does
the assigned
work; often
needs
reminding
Usually
does the
assigned
work; rarely
needs
reminding
Does the
assigned job
without
having to be
reminded.
Always
does the
assigned
work
without
having to be
reminded
and on
given time
frame
3
Listen to
other Team
mates
Is always
talking; never
allows anyone
else to speak
Usually
does most
of the
talking;
rarely
allows
others to
speak
Listens, but
sometimes
talk too
much
Listens and
contributes
to the
relevant
topic
Listens and
contributes
precisely to
the relevant
topic and
exhibit
leadership
qualities
3
TOTAL
13/4=
3.25=
4
*All student activities should be done in a group of 4-5 students with a team leader.
.
Directorate Of Technical Education Karnataka State Page 4
COURSE ASSESSMENT AND EVALUATION The Course will be Delivered Through Lectures, Class Room Interaction, Exercises and
Self Study Cases.
What
To
Whom
When/Where
(Frequency in
the Course)
Max.
Marks
(Prac)
Evidence
CO’s
Mapped
Direct
Assessment
Method
CIE
IA Test
ST
UD
EN
TS
2 Progress
Reports 5 + 5
Sheets 1
Assignment
Synopsis + Mini
Presentation 5 + 10
Sheets +
PPT 1
Total 25
SEE End Exam End of Course 50 Answer
Script 1
Indirect
Assessment
Method
Student Feedback Middle of the
Course
-NA-
Feed Back
Forms
1delivery of the
Course
End of Course
Survey End of Course
Questio
nnaire
Effectiveness of
delivery of
Instruction and
assessment methods
*CIE – Continuous Internal Evaluation *SEE – Semester End Examination
Note:
1. Rubrics to be devised appropriately by the concerned faculty to assess Student activities.