To,
The Principal Secretary
Rajbhavan, Bihar, Patna
Sub.- Regarding submission of pro; a Hata sev and uniform
syllabus of [Link] eeetl?tr 1 and 2™
Semester of 4-Year See
Ref.- Letter No.-BSU(UGC)-02/2023-871/GS(1), Dated-09-06-2023
Sir,
In Compliance with your letter no.-BSU(UGC)-02/2023-871/GS(1),
dated 09-06-2023 followed by above ee letter no, we are submitting
the proposed course structure and syllabus of 9.0 io Huenas. Resernen Mes
for 1“ and 2™ semester of the 4 year under graduate course system as per
UGC regulations.
Hany)
Yours faithfully,
Enclosed-as above.
@ Re +69
® BH G0}
Mieka
(es J | eR ras
) Cay. al
oo wee?
OaUniversity of Bihar
Faculty of Commerce
4 year Degree Course under
CHOICE BASED CREDIT SYSTEM
Semester Scheme with Multiple Entry and Exit Option for
Under Graduate Course as per NEP 2020
Syllabus for
[Link]- HRM
Session -2023-27 onwards i es oi
yo? Eeresv” ae
A
ve 617029) a dy eaeSyllabus for four years [Link] in Human Resource Management
Subject under CBCS system and Semester System as per UGC
Regulations
(Curriculum and Credit framework for undergraduate programme)
(Group-C) Human Resource Management
(A) Major Core Courses
Si. | Sem | Typeof | Course Name ofCourse Credits] Marks
No. Course | Code CIAVESE
30470
1 | T | MIC-T BCHRM/M| Principles & Functions of 6 100
IC-1 ‘Management
2. | I | MIC-2- BCHRMM | Fundamentals of Human Resource | 6 100
{ IC -2 Management
3. | Ti | MIC-3 [BCHRMM | Training & Development 3 100
IC -3 |
4. | TIT | MIC-4”BCHRM/M|— Compensation Management 4 100
C4
5. | IV | MICS” BCHRMM| Labour & Employment Laws in 3 100
| IC-5 India
6. | IV | MIC” BCHRM/M | Labour Welfare & Social Security 3 100
IC-6
7. | WV | MCT [BCHRMM Industrial Relations 3 100
IC-7
8 | V | MICS BCHRMM Group Dynamics 3 100
IC-8
9. | V_ | MIC-9 [BCHRMIM| Business Mathematics & Statisties 3 100
IC-9
10. | VI /MIC-10 [BCHRM/M | Organisational Behaviour 4 100
IC-10
1. | VI [MIC-TT_[BCHRMM Stress Management 3 100
IC =I
12, VI |MIC-I2|BCHRMIM| Management of Change 3 100
IC-12
13, | Vit [MIC-13 BCHRMM ‘Business Economics 3 100
1C=13
14. Vil [MIC-14 BCHRMIM ‘Research Methodology 5 100
C14
15. | Vit |MIC-1S [BCHRMIM Business Law 6 100
IC -15
16. | VIII |MIC-16 BCHRM/M| Business Communication 4 100
IC -16 |
Sub Total = 80
Note:
MIC ~ Major Course
BCHRM- [Link] in Human Resource Management veer
CTA- Continous Internal Assessment
ESE- End Semester Examination
et Pe
io
eur"?
Bie we? eS =(B) Minor Courses MIC to be offered by the Department for
students of other Departments of Commerce
‘SLNo.| Sem | Type of] Course Code Name of Course Credits Marks
Course CIA+ESE,
30470
T T__| MIC-T BCHRMIMIC-1 Fundamentals of IRM a 100
2 T | MIC-2 BCHRM /MIC-2 [Training & Development 3 100
3 Ti | MIC-3 BCHRM /MIC-3 [Compensation Management 3 100
4..[ TV _| MIC-@ BCHRM /MIC-4 |indusirial Relations 3 100
5. | _V__ | MICS |BCHRM /MIC-5 Labour & Empoloyment Laws in India) 3 100
6 V__| MIC-6 [BCHRM/MIC-6 [Labour Welfare & Social Security 3 100
7. Vi_| MIC-7 BCHRMMIC-7 Management of Change 3 100
8 Vi MIC-8 BCHRM/MIC-8 Group Dynamics 3 100
9. | Vil_| MIC-9BCHRMIMIC-S Sires Management 4 100
10.) VI | MIC. BCHRM/MIC-10 Strategic HRM 4 700
10
Sub Total =32
Note:The Department may reduce the syllabus of the Minor Courses as per the eredit distribution, The
Department concerned may also decide practical courses.
(©) Multidisciplinary Courses to be offered
SINo.| Sem | Type of Course ‘Name of Course Credits | Marks
|. MDC-1 fo be selected from the basket 3 100
2; |i MDC-2 [To be selected from the basket 3 100
3. [MT | MDC-3_— To be selected from the basket 3 100
Sub Total =09
(D) Ability Enhancement Courses to be offered
SL No. [Sem | Type of Course ‘Name of Course [ Credits
lea ‘ALC a z
2 [ot ALC-Z aa Belence 2
3. | AFC-3 Disaster Risk Management 2
4 [IV | AEC4 _ NCCINSSINGOs/Social Service? 2
SScout and Guide/Sports
Sub Lotat= us
(E) Skill Enhancement Courses to be offered
‘SI. No, [Sem | Type of Coures Name of Course [ Credits | Marks
Eft SEC-T__ [fo be selected from the basket x | 100
2 | a SEC-2__ [To be selected from the basket 3 | 100
SECA(F) Value Added Courses to be offered
[Link]. [Sem | Type of Course
Name of Course Credits | Marks
Td VAC-I__ [fo be selected from the basket 3 100
2 | VAC-2__ fo be selected from the basket 3 100
Sub Total= 06
SILNo. [Sem | Type of Course ] Name of Course Credits | Marks
r fv INT-I___ Summer Internship 4 100
|
[Link]. | Sem_|Type of Course Name of Course Credits [Marks
i._| var RP-1_Research/Dissertation 2 100
Grand Total= 160 Credits
(G) Basket for Multidisciplinary Courses (MDC)
To be decided by Respective Department
(A) Basket for Skill Enhancement Courses (SEC)
See at the end of structure (this booklet)
(D Basket for Value Added Courses (VAC)
See at the end of structure (this booklet)GROUP C: HUMAN RESOURCE MANAGEMENT
SEMESTER I
BCHRM/MJC-1: PRINCIPLES AND FUNCTIONS OF MANAGEMENT
Objecti
‘To acquaint the learners with the basic concept of business, different forms of business
organisation, basics of management concept and the different management functions,
Learning Outeomes:
After completion of the course, the learners will be able to:
1. Know the Principles of Management and the different levels at which decisions are
taken by the Managements
Identify and explain Managerial skills used in business;
Analyse the concept of Delegation of Authority, coordination, and control;
Assess the importance of effective communication in management
Validate the role of Motivation and Leadership in modem day management
COURSE CONTENTS:
BCHRM/MJC-i1: PRINCIPLES AND FUNCTIONS OF MANAGEMENT
(Theory: 6 credits)
Unit | Topics to be covered No. of
Lectures
1 | Principles of Management 10
Management - Meaning and Characteristics; Fayol’s 14 Principles of
Management; Levels of Management Importance of Management, Arts and
Science of Management~ Skills of Management; Scientific Management -
meaning, objectives, relevance and criticism.
2 | Functions of Management: Planning and Organizing 10
Planning- Meaning, Characteristics, Types of Plans, Advantages and
Disadvantages — Approaches to Planning - Management by Objectives
(MBO) - Steps in MBO - Benefits -Weaknesses; Organizing - Process of
Organizing; Principles of Organisation - Formal and Informal
Organisations —Line, Staff Organisations, Line and Staff Conflicts.
Functional Organisation; Span of Management - Meaning - Determining
Span - Factory influencing the Spaii of Supervislon,
3 _| Functions of Management: Authority and Coordination 70
Meaning ot Authonty, Power, responsibility avid accountability
Delegation of Authority - Decentralization of Authority; Definition,
importance, process, and principles of Coordination techniques of Effective
Coordination
4 Functions of Management: Control and Communication 15
Control-Meaning, Relationship between planning and control, Steps in
Control — Types (post, current, and pre-control). Requirements for effective
[Link]-purpose, process, formal and informal
communication, barriers to effective communication and overcoming these \ ry
Sho [ser Nec?
es ) fL Ve Ss
07 an bilan 007 Sieg:
pe Mm ms wetFunctions of Management: Motivation and Leadership 8
Motivation-Meaning, importance, major motivation theories- Maslow's
Weed hierarchy theory, Herzberg’s two-factors theory, Vroom’s Expectation
Theory, extrinsic and intrinsic motivation; Leadership- meaning, theories,
ssential qualities, global leadership attributes, practicing leadership
[TOTAL [6
Suggested Readings:
1 Basu C. R (1998). Business Organization and Management. New Delhi.
MeGraw Hill Publishing India,
2. Chhabra, T.N. (2011). Business Organization and Management. New Delhi:
‘Sun india Publications,
3. Gupta, C. B. (2011), Modern Business Organization. New Delhi Mayur
Paperbacks.
+ Kaul, ¥. K. (2012). Business Organization and Management, Text and Cases:
New Dethi: Pearson Education
5 Koonts, H, & Wethrich, H. (2008). Essentials of Management. Now York:
McGraw Hill Education.
6 Singh. B. P., & Singh, A. K. (2002), Essentials of Management. New Delhi.
Excel Books.
& F.C Sharma, Business Organisation,SBPD Publications, Agra
& MC Shukla, Business Organisation, S. Chand Publications, New Delhi.
9. ¥. P. Verma, Business Organisation, Sahitya Bhawan Publications, Agra,
|
|
]GROUP C: HUMAN RESOURCE MANAGEMENT
BCHRM/MJC-2: FUNDAMENTALS OF HUMAN RESOURCE MANAGEMENT
Objective
To acquaint the leamers with the basics Principles of Human Resource Management and to promote
their skill about recruitment, training and grievance handling in the organization,
Learning Outcomes
After the completion of the course, the student will be able to:
1. Understand the importance of human resources and their effective management in organizations
as well as utilise the knowledge to gain competitive advantage through people,
2. Analyse the current theory and practice of recruitment and selection as well as real
importance of performance management system in enhancing employee performance.
3. Recommend action based on results of the compensation analysis and design compensation
schemes that are cost effective and increase productivity of the workforce.
BCHRM/MJC-2: FUNDAMENTALS OF HUMAN RESOURCE MANAGEMENT
ing the
(Theory: 6 credits)
Unit | Topies to be covered No. of
Lectures
T” Introduction: 10
Concept, Nature, Functions, Importance and Scope of HRM; Funetions and
Qualities of a successful HR. Manager; Human Resource Policies — ‘Need,
Sources, Process, Types and Contents; A conceptual Framework of HR
Planning; Job-Analysis; Job description and Job specification.
Recruitment, Selection and Training: 15
Recruitment - Meaning and Sources of Recruitment,
Selection ~ Process, Recruitment Vs, Selection, Common mistake in Group
Discussion and Interview.
Placement and Induction ~ Conceptual Framework, Job Change, Transfer
and Promotion.
‘raining - Meaning, Need, Importance and Method (on the job training and
off the job training).
3. | Fxecutive Development and Remuneration: 12
Executive Development Programme - Meaning, Significance, Contents
‘and Methods; Performance Appraisal-Concept, Need, Objectives, Methods
of Performance Appraisal; Job Evaluation
- Conceptual Framework
Methods of Remuneration: An Elementary Knowledge of Methods of wage
rh Wy
\ [Payment and Fringe Benefits,
WN“Maintenance of Employees and Grievance Management:
Maintenance: Employee Health and Safety; Employee Welfare; Employer
and Employee Relations — An overview.
Grievance: Handling and Redressal; Grievance Procedure; Management of
Employees Grievance
Industrial Disputes: Causes and Settlement Machinery.
12
Morale and Discipline:
Morale ~ Meaning, Factors Affecting, Methods of ‘Measurement,
Suggestive for Improving morale.
Discipline - Need, Causes of Indiscipline, Suggestions for Effective
iscipline, Procedure for Disciplinary Action,
HR Audit — A Conceptual Framework of Human Resource Audit,
i
TOTAL
60
Suggested Readings:
Nove ee
8.
9.
Human Resource Management: Text and Cases ~ VSP Rao, Excel Books
Human Resource Management: Text and Cases ~ K. Ashwatappa — TMM
Human Resource Management: Cary Dessler — Pearson Publication
Human Resource Management: Cyrithia Fisher, Shaw — Wiley Biztantra
‘Human Resource Management: C. B. Gupta — Sultan Chand
Human Resource Management: Rosy & Joshi — Kalyani Publisher
Human Resource Management and OrganisationBehaviour: PKS Menon — Himalaya
Publishing
Personnel Management: C. B, Memoria - Himalaya Publishing
Human Resource Management: Seema Sanghi ~ Vikas
10. Human Resource Management: S. S. Khanka~ S. ChandGROUP C: HUMAN RESOURCE MANAGEMENT.
BCHRM/MIC-1: FUNDAMENTALS OF HUMAN RESOURCE MANAGEMENT
Objective:
To acquaint the learners with the basics Principles of Human Resource Management and to promote their
skill about recruitment, training and grievance handling in the organization,
Learning Outcomes
After the completion of the course, the student will be able to:
1. Understand the importance of human resources and their effective management in organizations as
well as utilise the knowledge to gain competitive advantage through people.
2. Analyse the current theory and practice of recruitment and selection as well as realizing the
importance of performance management system in enhancing employee performance.
3. Recommend action based on results of the compensation analysis and design compensation schemes
that are cost effective and increase productivity of the workforce,
BCHRM/MIC-1: FUNDAMENTALS OF HUMAN RESOURCE MANAGEMENT ~]
(Theory: 3 eredits)
Unit | Topies to be covered No. of
Lectures _|
T” Introduction: 8
Concept, Nature, Functions, Importance and Scope of HRM; Functions and
Qualities of a successful HR Manager; Human Resource Policies ~ Need, Sources,
Process, Types and Contents; A conceptual Framework of HR. Planning; Job-
Analysis; Job description and Job specification.
2” | Recruitment, Selection and Training: 10
Recruitment - Meaning and Sources of Recruitment.
Selection ~ Process, Recruitment Vs. Selection, Common mistake in Group
Discussion and Interview.
Placement and Induction ~ Conceptual Framework, Job Change, Transfer and
Promotion.
Training ~ Meaning, Need, Importance and Method (on the job training and off
the job training).
3 | Executive Development and Remuneration: 12
Executive Development Programme — Meaning, Significance, Contents
and Methods; Performance Appraisal-Concept, Need, Objectives, Methods of
Performance Appraisal; Job Evaluation
= Conceptual Framework
Methods of Remuneration: An Elementary Knowledge of Methods of wage
payment and Fringe Benetits
TOTAL,
Suggested Rendings:
1. Human Resource Management: Yext and Cases — VSP Rao, Excel Books
2. Human Kesouree Management: ext and Cases — K. Ashwatappa — TMM
3. Human Kesouree Management: Cary Dessler ~ Pearson Publication
4, Human Resource Management: Cyrithia Fisher, Shaw ~ Wiley Biztantra
S. Human Resource Management: C. B, Gupta ~ Sultan Chand
6. Human Resource Management: Rosy & Joshi ~ Kalyani Publisher
7, Human Resource Management and OrganisationBehaviour: PKS Menon ~ Himalaya Publishing
8. Personne! Management: C. B, Memoria - Himalaya Publishing
9, Human Resource Management: Seema Sanghi ~ Vikas yy
10 |
\
\, Human Resource Management: S. S. Khanka ~ §. Chand
Mo Hao”
SA™ICT. + face we Pr EBGROUP C: HUMAN RESOURCE MANAGEMENT
BCHRM/MIC-2: TRAINING AND DEVELOPMENT
Objective:
The couse aims at exposing the leamer to the concept and practice of training and development in the
modern organizational setting with practical and recent experiences.
Learning Outcomes
After completing the course, the student shall be able to:
1, Learn the practical applications of training and development theories in recent times.
2. Leam to design training programmes for diverse workforce.
3. Evaluate training and development programmes.
5. Recognize the mechanism of career development programmes.
Course Contents
BCHRM/MIC-2: TRAINING AND DEVELOPMENT
(Theory: 3 credits)
Unit | Topics to be covered No. of
Lectures
I | Nature of Training and Development 8
Theories of management training and development and practical application of
these theories in today’s organisations, inputs and gaps in training, Training and
development as a source of competitive advantage; Resistance to change
2 | Designing Training Programmes 10
Training process and practical application of designing programmes in today’s
environment,
Methods of training; Human re-engineering, managing change, workmen training,
re-training, government initiatives, self-directed work teams, learning curves,
managing a diverse workforce
3 | Evaluation of Training and Development Programme and Career 12
Development
Evaluation of Training and Development Programme ~ Statistical methods, use of
appropriate training and development software puckageges. Career Development
and Planning, Career Development Programme and Counselling
TOTAL 0
Suggested Readin
1 Bhattachryya, D. K. Taining and Development: Theories and Applications. New Delhi. Sage
Publications India Pvt. Ld.
2. Lynton, R., & Pareek, U. Training for Development. New Delhi: Vistaar.
Phillips, JJ. Hand book of Training Evaluation nad Measurement Methods. Houston Gulf
Publishing Co.
I Sw Prior, J. Handbook of Training and Development. Mumbai : Jaico Publishing Hees
wie “4 15 Mit 509 @a
Personal Financial Planning |» Prospecting E-waste for |
sustainability ‘© Visual Communication & sustainability
'+ Visual Communication & Photography © Sustainable Ecotourism &
Photography /* Statistical Software Package ‘Entepreneurship
Ege Pas. Asimation /s Comminication in Professional |» Visual Communication & |
© Statistic re Package tee —
Communication in Professional | MY fede el
Life je eure deat _ onerure
| ‘+ Communication in Professional
eo eria ee
Gow! as
Page 1 of 44
6
GamLIST OF SKILL ENHANCEMENT COURSES (SEC)
Total Marks
se Course Title me
No.
tle
1 | Advance Spreadsheet Tools ols 3a |
2 | Basie rr Tots ofa] 3
3 | Beginners Course w Callganhy of3| 3
4 | Big Deta Analysis ols] 3
5 | Business Communication of3 |] 3
6 | Communication in Everyday life ofa] 3
7. | Communication in Professional Life of3] 3
8 | Creative Writing of3/ 3 |# 2
9 | Digital Marketing wst>o lf #
ee KH E 3
11 | Introduction to Cloud Computing (AWS) o| 3 3 EB g
a rt |
[13 _ | Personality Development & Communication of3[ 3 |é& i
14 | Prospeeting E-waste for sustainability of[3]/ 3 |B =
15 _ | Public Speaking in English Language & Leadership ofa] 3
16 _| Statistic! Software Package of3] 3
17-_| Sustsinsble Eootoursm & Entrepreneurship e[3| 3
118 | Visust Communication & Photography ofa] 3
19 | see aera of 3 | 3
20 | rein ofa] 3
o[3s] 3
Sut @late
Poge 2 of 44Skill Enhancement Course (SEC)
* Course Title - Advance Spreadsheet Tools
Learning Objectives
‘The Leaming Objectives of this course aro as follows:
+ To enable the students to use Excel for advanced data analysis
+ To equip the students to with automation skills on excel
+ To enable the students to use excel for informed decision making.
Learning outcomes
‘The Learning Outcomes of this course are as follows:
+ By studying this course, students will be able to make meaningfol representations of data
in the form of charts and pivot tables.
+ By studying this course, students will be able to draw analysis on data using spreadsheets
and use interpretation to make decisions,
+ By studying this course, students will be able to generate word documents with
appropriate formatting, layout, proofing.
+ By studying this course, students will be able to manage data for generating queries, forms
and reports in a database.
‘SYLLABUS
Unit I: Excel Advanced Techniques
‘Templates, Efficiency, aud Risk (Standard Deviation, Variance, and Coetficient of Variation),
Data Validation; *Fusetions and Power functions, Array Fonmulae (Frequency Distribution,
modesmutt, [Link])), Tables, Advanced Range Names, Whatitanalysis: Goalseek, Data
tables, and Scenario Manager; Data analysis ToolPak: Descriptive Statistics, Moving averages,
Histogram, Covariance, correlation, and Regression analysis (anly for projection); solver add
in, Problem Solving using Solver (optimal product mix, workforce scheduling, transportation,
‘capital budgeting, financial planning), Integrating excel with other tools: MS word, outlook,
PowerPoint, Access, Power BI.
Unit 2: Excel Interactivity and Automation
Index and Match, Offset, Dynamic Charting, Database functions, Text functions, and Error
functions: Iftrror, IsEnror, Aggregate, Circular Reference, Formule Auditing, Floating-Point
Enors, Form Controls (Button, Combo, Check box, Spinner, List, Option), Visual Basie (enly
basic). Recording Macros, Absolute and relative macros, editing macros, Use of spinner
bbttons and command buttons; Sub Procedure, Function Procedure (creating New Functions);
Working with Loops: De_while loop, For Next loop; Creating User Forms: Message Box,
Input Box; If_Then Else.
Unit 3: Introduction to VBA
‘Conditional Formatting, Charts that Inspire (Waterfall, Column, Line, Combo, Thermometer,
Seater, Histogram) Sheers, Sparklines, Graphics Tricks and Techniques, Worksheet,
Automation using Macros: Absolute and relative macros, editing macros, Creating new
functions using macros, Use of spinner buttons and command buttous.
Qe ee Be 8 fa-74
Page 3 of 44‘Unit 4: Data Analysis and Decision-Making
Working with External Data, Advanced Uses of PivotTables, PowerPivot, Reporting with
PowerPivot, Power query, Dashboard, Creating spreadsheet in the area of! Loan and Lease
statement; Ratio Analysis; Payroll Accounting; Capital Budgeting (NPV & IRR), Portfolio
Management, Breakeven analysis, and Sensitivity analysis; Operations Management:
Constraint, Forecasting & Trend Analysis optimization, Assignment Problems; Depreciation
Accounting (Single Method); Graphical representation of data; Frequency distribution and
its statistical parameters; Conelation and Regression Analysis
Essential/recommended readings
+ Excel 2016 Power Programming with VBA, Michael Alexander, Dick Kusleika, Wiley.
+ Financial Analysis and Modelling Using Excel and VBA, Chandan Sengupta,
‘Second Edition, Wiley Student Edition,
+ MS Excel 2016, Data Analysis & Business Modelling, Wayne Winston, PHI.
Suggestive readings
Microsoft Excel 2016 - Data Analysis and Business Modelling Paperback - | May
2017 Wayne L. Winston, Microsoft Press.
‘Microsoft Excel Practical Formulae: From Basic Data Analysis to Advanced
Formulae :
Manipulation Diane Griffiths.
G@ t4=-%
Page 4 of 44© Course Title — Basic IT Tools
Learning Objectives
‘The Leaming Objectives of this course are as follows:
To enable students develop IT skills that are a pre-requisite in today’s work envizonment.
To equip them with besic computing skills that will enhance their employability in general,
To enable the student to analyse and present information in a meaningful manner.
Learning outcomes
‘The Leaming Outcomes of this course are as fellows:
By studying this course, students will be able to use word-processor to generate
gecamens with appropriate formating layout review and eftrencing
By studying this course, students will be able to manage data in worksheets and
‘workbooks and analyze it using spreadsheet functions and inbuilt formulas.
By studying this course, students will be able to draw analysis on data using
spreadsheets to make decisions.
By studying this course, studens will be able to make meaningful representations of
data in the form of charts and pivot tables.
‘By studying this couse, students will be able to manage data in database tables and use
‘the same for generating queries, forms and reports,
SYLLABUS,
Course Contents:
Unit 1: Introduction ¢o Spreadsheets
Spreadsheets: Concept of worksheets and workbooks, creating, opening, closing and saving
workbooks, moving, copying, inserting, deleting and renaming worksheets, working with
‘mukiple worksheets and multiple workbooks, controlling worksheet views, naming cells using
name box, name cteate and name define; Exchanging data using clipboard, object linking and.
embedding; Printing and Protecting worksheets: Adjusting margins, creating headers. and
{boters, setting page breaks, changing orientation, creating portable documents and printing, data
‘and formulae; Implementing file level security and protecting data within the worksheet
Understanding absolute, relative and mixed referencing in formulas, referencing cells in other
worksheets and workbooks, comeeting common formula errs, working with inbuilt function
‘categories lke mathematical, statistical, text, lookup, information, logical, database, date and
‘ime and basic financial functions.
Unit 2: Data Analysis in Spreadsheets
Consolidating worksheets and workbooks using formmilae and data consolidate command;
‘Choosing a chart type, understanding data points and dala series, editing and formatting chart
elements, and creating sparkline graphics, Analysing data using pivot tables: Creating,
formatting and modifying a pivot table, sorting, filtering and grouping items, creating calculated
field and caleulsted item, creating pivot table charts, producing a report with pivot tables
Introduction to recording and execution of macros.
Sr etebh Oe sys
Page 5 of 44Unit 3: Word Processing
Inwoduction: Creating and saving your document, displaying different views, working with
siyles aud character formating, working with paragraph formatting techniques using indents,
‘abs, aligament, spacing, bullets end numbering and ereating borders; Page setup and sections:
Setting page margins, orientation, headers and footers, end notes and footnotes, creating section
breaks and page borders: Working with tables: Creating tables, modifying table layout and
design, sorting, inserting graphics in a table, wble math, converting text to table aud vice versa;
CCeeate newspaper columns, indexes and table of contents, Spell check your document using
inbuilt and custom dictionaries, checking grammar and style , using thesaurus and finding snd
replacing text Create bookmarks, ceptions and cross referencing, adding hyperiinks, adding
sources and compiling and bibliography; Mail merge: Creating and editing your main document
and data souce, sorting and filtering merged documents and using merge instructions like ask,
filhin and if-then-else: Linking and embedding to keep things together.
Unit 4: Databases
Introduction to Database Development: Database Terminology, Objects, Creating Tables,
‘working with fields, understanding Data types, Changing table design, Assigning Field
Properties, Setting Primary Keys, using field validation and record validation rules, Indexing,
working with mukiple tables, Relationships & Integrity Rules, Join Properties, Record
manipulation, Sorting & Filtering: Select data with queries: Creating Query by design & by
wizard (Select, Make Table, Append, Delete, Cross Tab, Update, Parameterized Query, Find
Duplicate and Find Unmatched), Creating multi table quetes, creating & working with table
Joins. Using operators & expressions: Creating simple & advance cxteria; Working with fomms:
Creating Basic forms, working with bound, unbound and calculated controls, understanding
property sheet, Working with Data on Forms: Changing Layout, creating Sub Forms, creating
list box, combo box and option groups; Working with Repors: Creating Basie Reports, Creating
Header & Footer, Placing Comms on report, sorting & grouping, Creating Sub reports.
EssentiaVrecommended readings
+ Swinford, E., Dodge, M, Couch, A., Melion, B.A. (2013). Microsoft Office Profesional
2013. United States: OReilly Media
+ Wang, W. (2018). Oiice 2019 For Dummies. United States: Wiley. Microsoft
Lambert, J. 2019), Microsoft Word 2019 Step by Step. Unied States: Pearson Education,
Suggestive readings
Jefe, B. 2013). Excel 2013 Charts and Graphs. United Kingdom: Que.
‘Alexander, M, Jelen,B. 2013). Excel 2013 Pivot Table Data Crunching. United
‘+ Kingdom: Pearson Education
Alexander, M., Kusleika, R. (2018). Access 2019 Bible. United Kingdon: Wiley.
Row ebm BG ty
Page 6 of 44+ Course Title — Beginners Course to Calligraphy
Learning Objectives
‘The Leaming Objectives ofthis course are as follows:
+ To teach students the art of Calligraphy.
+ To make suadents beter at handwiting and embellish the scripts.
+ To ielp the students communicate with creativity
Learning outcomes
The Leaming Outcomes of this course are as follows:
Students willbe skilled in calligraphy scrips,
‘Leeming flourishing will help to develep good waiting
Practice sessions will further project a the end of semester
Will induce skills vo setup a busines, too,
SYLLABUS
‘Ua: imroduton te Calligraphy
*+ "Definition, History of calligraphy, Calligraphy atthe Global level, Types of
Calligraphy:Classical Calligraphy & Modem Calligraphy
+ Practice Sessions: Inoducing smidents o Calligraphy and is types through
images,videos and animations.
‘Unit 2: Introduction to the Writing fools
+ Tool Kit, Different Types of Pens, Different Types of Nibs, Different Types of
Brushes, Different Types of Inks
+ Practice Sessions: Display of Wiring items, Discussion on the usage of different types
‘of pens, nis and brashes through hands-on activities
Unit 3: Foundation to Calligraphy
+ How to write lelters?, Majuscules, Miniscules, Numbers, Learning Strokes, Sans
SerifB- point, Celtic, Italian Script, Roman Script, Gothic Script
+ Practice Sessions: Learning and practicing srokes- Upstroke, Downstroke, Overtum,
Underura, Compound curve, Oval, Ascending loop
+ Hands-on activities and Assessment on Sans Serif B-point, Celtic, Italian
‘Script Roman Seript, Gothic Seript, Flourishing
‘EssentiaV/recommended readings
+ Suepsuan, PA. (2021), Start Calligraphy The Right way to write: Leam Calligraphy
‘The Complete Book - Modem Calligraphy Pen For Beginners, Learning Resources
Sie By Sep Number Line, Maserng Moser Calirapy. nkpndety
* C,&Co,, TP. (2020). Modern Calligraphy Set for Beginners: A Creative Craft Kit
for Adults featuring Hand Lettering 101 Book, Brush Pens, Calligraphy Pens, and
More. Paige Tate & Co.
Page 7 of 44‘* Course Title - Big Data Analytics
Learning Objectives
‘The Leaming Objectives of this couse are as follows:
‘To Understand the Big Data Platform and its Uses
Provide an overview of Apache Hadoop
Provide HDFS Concepts and Interfacing with HDFS,
Provide hands on Hadoop Eco System
To understand spark framework
Learning outcomes
‘The Learning Outcomes ofthis course are as follows:
+ After studying this course, students will be able to
identify Big Data and its Business
Implications.
+ Aller studying this course, stidents will be able wo list the components of Hadoop
‘and Hailoop Eco-System.
‘Aer suing this course, students will be able to access and process data on
distributed file system,
+ After studying this course, students will be able to manage job execution in Hadoop
environment.
+ After studying this course, students will beable to develop Big Data Solutions using
Hadoop Eco System.
SYLLABUS,
Unit 1: Fundamentals of Rig Data Analysis
Data Storage and Analysis, Characteristics of Big Data, Big Data Analytics, Typical
Analytical Architecture, Requirement for new analytical architecture, Challenges in Big
‘Data Analytics - Need of big data frameworks
‘Unit 2: Hadoop Framework
Hadoop, Requirement of Hadoop Framework, Design principle of Hadoop -Comparison
‘with other system, Hadoop Components - Hadoop 1 vs Hadoop 2, Hadoop Daemoi’s
- HDFSCommands, Map Reduce Programming: VO formals, Map side join, Reduce Side
Join, Secondary sorting, Pipelining Map Reduc jobs
Unit 3: HDF (ladoop Distbuted Fie System)
‘The Design of HDFS, HDES Concepts, Command Line Interface, Hadoop file system
interfaces, Data flow. Data Ingest with Flume and Scoop and Hadoop archives, Hadoop
‘Compression, Serialization, Avro and File-Based Data structures,
‘Unit 4: Spark Framework and Data Analysis with Spark Shell
Introduction to GPU Computing, CUDA Programming Model, CUDA API, Simple
Masix, Mukiplication in CUDA, CUDA Memory Model, Shared Memory Metrix
Makipication, Additional CUDA’ API Features. Writing Spark Application ~ Spark
Programming in Scala, Pylon, R. Java - Application Execution.
Ret QF CG £4
Page 8 of 44Practical Exersises
+ Downloading and installing Hadoop.
+ Understanding different Hadoop modes. Starup scripts, Configuration files.
+ Hadoop Implementation of file management tasks, such as Adding files and
directories, rewieving files and Deleting files.
+ Rum abasic word count Map reduce program to understand map reduce paradigm:
"To count words in given file, to view the output fle, and to calculate the
execution time,
+ Map Reduce Program to analyse time-temperature statistics and generote report
with may/min temperature,
+ Implement of Matrix Multiplication with Hadoop Map Redues.
+ Implementation of K-means clustering using Map Reduce
+ Tostudy and implement basic fimctions and commands in R programming.
+ To build Word cloud, a text mining method using R for easy to understand and
visualization than a table data
* To implement clustering program using R programming
. ellappan, "Big Data Analytics" Wiley 2015.
+ Mike Frampton, “Mastering Apache Spark”, Packt Publishing, 2015,
+ Tom White, “Hadoop:TheDefinitiveGuide”,0”Reilly-4thEdition 2015.
+ Nick Pentreath, Machine Leaming with Spark, PacktPublishing 2015,
*+ Mohammed Gulle, Big Data Analytics with Spark, Apress.2015.
+ Donald Miner, Adem Shock, “Map Reduce Design Pattom”, O'Reilly, 2012
Qa G&
Page 9 of 44© Course Title - Business Communication
Learning Objectives
‘The Leaming Objectives ofthis course are as follows:
+ To train students to enhance written 3s well as otal communication inthe corporate
world,
+ To help students in understanding the principles and techniques of business
communication.
+ To understand the use of electronic media for communication.
‘Learning outcomes
“The Leaming Outcomes of this course areas fllows:
+ Alter studying this course, students will be able to explain the need for
communication in management
+ After smying this course, students wil be able t appreciate the need of effective
‘weting for commusication.
+ After suedying this course, studenis will beable vo demenstate the skil of effective
‘eport waiting and summaizing ennval reports.
+ After sudying this course, students willbe able analyse business correspondence
and
*+ After studying this course, stadents will be able to appreciate oral presentations,
‘SYLLABUS
Unit 1: Introduction tothe essentials of Business Communication
Meaning, process and fimetions. Need and importance. Medium: verbal & non-verbal
communication. Channels: formal & informal. Levels of communication, Direction of
communication: downward, upward, lateral, & diagonal, Effective communication:
Gificuliestberiers and soltions. Interactive and non-interactive techniques of
communication. Listening asa tool of communication, Guidlines for effective listening,
Unit 2: Effective Writing
Guidelives for clear writing. References, bibliographical research tools. Citing methods,
foomotes, discussion foomotes. Use of library and internet for collection, classification and
interpretation of data and information,
Unit 3: Report Writing
‘Types of reports. Formal report: components and purpose. Organising information: outlining
.& numbering sections, section headings, sub-headings, & presentation, Writing reports on
field work/visits to industries, business concems. Surmarising anal reports of companies:
‘Purpose structure and principles. Drafting minutes.
Unit 4: Business Correspondence and E-Correspondence
‘Need and importance of business leters. Office memorandum, office circulars, notices and
orders. Technology for communication. Effective IT communication tools, Electronic: mail
‘advantages, safety and smartness in email. E-mail etiquettes,
Unit : Spoken English and Oral Presentation
Effective negotiation: elements, process and general guidelines, Telephonic conversation.
Conducting & facing interviews. Conducting & participating in group decisions. Making
Presentations: content and organising. Features of a good presentation, Delivering a
Page 10 of 4aPractical Exercises:
‘The leamers are required 1:
‘Team how to summarise ennual reports of companies.
+ prepare presentations using power-point
+ participate in Group discussions and mock interviews,
+ smartly draft business emails
EssentiaVrecommended readings
+ [Link] (2019), Esseatials of Business Communication, Sultan Chand & Sons.
+ Kaul, A. Effective Business Communication, 2nd ed. PHI leaming
+ Lesikar, RLV. & Flaley, M.E. (2001), Basic Business Communication Skis for
Empowering the Intemet Generation, Tata McGraw Hill Publishing Company Ltd.
‘New Delhi,
+ Ludlow, R. & Panton, F(1992). The Esseace of Effective Communications, Prentice
Hall of India Pvt. Lad, New Deli
+ Meyer C,Dev(2021). Communicating for Results, Oxford University Press
* Quintanilla, Kelly M, (2021), Business and Professional Communieaton, 42, Sage
Textbook
+ R.C. Bhatia (2008), Business Communication, Ane Books Pvt Ltd, New Delhi.
+ Raman and Singh(2012). Business Communication, Oxford University Press
+ Scot, O., Contemporary Business Communication, Biziantra, New Delhi
Cor een Spat
eeensennnans
Page 11 of 44© Course Title — Communication in Everyday Life
Learning Objectives
‘The Leaming Objectives of this course are as follows:
+ To lay down a basic foundation for basic communicetion that is a part of a
student severyday life.
+ Toinculcate the fundamentals of communication with the aim to enance
listening,speaking and writing skills.
+ Tohhone practical skills that can he used in day-to-day affairs.
‘Learning outcomes
‘The Leaming Outcomes of this course are as follows:
‘After studying this course, students will be able to improve mediation skills.
‘After studying this course, students willbe able to building buman relationships.
Afer studying this course, students will be abl to foster societal understanding
develop aa independent perspective.
After sindying this course, students willbe able to enhance social Communication
skils of smdeats,
SYLLABUS.
UNIT
‘Theory of Communication
+ Meaning, Features, Uses, Cycle, Feedback, Advantages
+ Baxtiess
+ 7C@sof Communication
unir2
Listening Skis
+ Netiquettes
+ Andio-book Listening & Diseussions
+ Note-king
Spain Sth
‘Oral Presentation- Audio-Visual aids, Audicace & Feedback, Delivery
ofPresentation, Handling Questions
+ Group Discussion- Cutan & History, Curent Affairs, Socicty-elated
+ Public Speaking- Public Speech, Extempore
+ Interview Personal, Conversational, Public
* Noemaking
+ Essays- Expository Essay, Descriptive Essay, Namative Essay
eter i iy
Page 12 of 44+ Reports- Incidence, Newspape, Organisational Report
+ Analysis & Interpretation- Textual
+ nts & inter-personal Skills - Monologue, Dialogue
Saggested Readings
* Chaudhary, Shoma. “Understanding Interviews, Billy Elliot is my Story, Only
LLessHappy”. Tehelka: The People’s Paper, 18 February 2006.
+ Kumar, Dinesh. “Understanding Values, Our Muddled Generation”. The Hindu,
26March 2006.
+ Leaming to Write 1, “Free Writing”. In Fluency in English 1, ed. Varma,
Pramodinind Maki Sanyal, pp. 1, Oxford, New Delhi, 2015.
+ Leaming to Write I, “Eating”. n Flueaey in English I, ed. Varma, Pramodini
‘andMulai Sanyal, pp. 25-27, Oxford, New Delhi, 2015.
+ Leaming to Write Il, “What makes Good Writing Good”. In Fhuency in English T,
ed. Varma, Pramodini and Mukti Sanyal, pp. 48-51, Oxford, New Delhi, 2015.
So eb
Page 13 of 44Course Title - Communication in Professional Life
Learning Objectives
‘The Leaming Objectives of this course are as follows:
‘To prepare the students for their upcoming professional fields.
To inculcate the fandamentals of professional and business communication.
To leam aspects of global communication,
‘To enhance employability skills of the learners by enabling them to waite effective
resumes and face interviews with confidence
‘Learning outcomes
‘The Learning Outcomes ofthis course are os follows:
* After studying this course, students will be able to improve presentation skis to be
lecamt by effective use of verbal and non-verbal communication for the professional
field
* Afr studying this course, students Will be able to acquire practical employability
skills to be disseminated through focused sessions on practical employable
knowleds
*+ After studying this course, students will be able to enhance professional
communication.
+ After studying this couse, studcats will be able to improve persuasion and
‘negotiation skills which will be usefl forthe professional field.
UNITL
‘Theory of Business Communication
Introduction
‘What is Business Communication?
Language of Business Communication
‘Cultural Components Cross-Cultural Communication, Cultural Shock,
Ethnocentism
Stereotyping, ;
+ Miscommunication & Effective Communication
UNIT?
Listening Skins
+ Netiquettes
+ Audio-book Listening & Discussions
+ Note-aking:
UNIT
Speaking Skills
*+ Presentation Skill- Oral Presentation, Ppt. Preparation, Ppt. Presentation
Group Discussion
‘Talks- Domain specific, Tod-Talks, Business Meets, Motivational Talks
Telephoaic Skills
Persuasion Skills
Meeting & Negotiation
Interview. Prototion Interview, Job Interview, Business Interview
‘Functions and activites of PR
Rot OA fr
Page 24 of 44‘Summarising & Paraphrasing
Job-Oriented Skills- CV, Resume & Bio- Data, Job Application Letter
Documentation
+. Advensements & Invitation
Report Analytical Report, Project Report
Digital Communication in Social Spare- Social Media Posts (Twitter, Facebook), Blog
‘Writing, Review Writing
+ Advertisement Invitation Poster Designing- Canva/MS Word/Coral
+ Memo, Office Order, Minutes
+ Making Online Acadeenic/Work Profile- Linkedin
Suggested Readings
+ Kaushik, J.C. and KK. Sinha ods., English for Students of Commerce,
OxfontLiniversity Press, New Delhi.
+ Sethi, Anjane & Bhavana Adhikari, Business Communication, Tata McGraw Hill,
* Anjan Neira Dev, [Link], eds. Business English, Department of English,
Page 15 of 44Course Title — Communication in Professional Life
Learning Objectives
The Leaming Objectives of this couse are as follows:
+ To build creative writing skils of students in the main inodes of creative writing
vvizpoetry, fiction (novel, short stories), non-fiction (life narratives, autobiographies
andbiographies) and drama.
+ To inculcate practical skills in students by mapping their creative talent which
‘bebeneficial for employability too,
+ To perform hands-on-activities ip students to develop theit creative skills
throughprsctieal sessions.
‘Learning outcomes
‘The Leaming Outeomes ofthis course are as follows:
+ After studying this course, students will be able tobe sensitive t the texture
offterary language.
+ After smidying this course, students will be able to develop craft in ereative writing.
+ After studying this couse, students will beable to develop sense of
cexpressingthemselves through poetryishortstorybiography.
+ Affersuidying this course, students will be abl to induce an understanding of|
‘herelationship between a1 individual and society.
+ Afr studying this course, students will be able to get into different fields
andpursve versatile career opportunities,
+ Afler studying ths course, shidents wl beable to develop an understanding of
{heat and performance through drama will also help thom to develop
‘observatoryand bebavioural shall,
+ _Afler studying this cours, sidents will beable to develop critical thought
processand a knack in puting it in words. Students may aso utilis the learnings
‘of proofreading and editing for their academic and professional growth.
+ After stadying this couse, students will be able to go for publishing their own work.
‘+ After studying this course, stadents will be able to waite « book and submit
SYLLABUS.
UNITE
*+ Introduction o Creative Wrting- Meaning, importance
+ Imagination & Writing. Peer interaction, Activities on Imagination
*+ Tropes, Motifs and Figuces- Leaming tropes, moti nd figures though videos,
Discussion on the findings
+ Craft of Writing. Figure of Speect, Word Play, Character Creation
*+ Character Creation Dialogue Enaction, Leaming Characters through discussien on
farnous writings, Character Analysis, Writing actvities on ereating diferent eypes
ofeharacters(genderfeceal backgroundethniciy ete)
UNE:
+ Close Reading
+ Analysis and Interpretation- Reading different works in Literatur, Disevssionin small
groups, Practice Weiting Sess
+ Proofieading & Editing: Practice sessions on Proofreading & Eéting of different types
of writing
earl CL Bg)
Page 16 of aaUNIT
+ Steps of Creative Writing: Pre-Writing, Writing, Post- Writing Final Draft
+ ‘Types of Creative Whiting- Poetry, Fiction, Non-Fiction (Life Naratives), Drama
+ Greative Writing & Media- Film Review, Book Review, Other Writings in Media,
Submission, Publication
+ Leaming to write Poetry- Reading & understanding Poetry; Practising tone, rhyme,
‘mete, verses; Writing sessions
*+ Learning to write Fition- Reading & understanding Fiction; Practicing diferent
Das könnte Ihnen auch gefallen