B.com

Program Scheme for Bachelor of Commerce (B.com)

Th -Theory; OP-Practical; Pro-Project; T-Total; Crd –Credit

 

I Semester

 

Course Code Course Title Credit Sem Th/P
LBM0101 Introduction to Accounting 4 1 Th
LBM0102 Fundamental of Computers 4 1 Th
LBM0103 Business Communication 4 1 Th
LBM0104 Micro Economics 4 1 Th
LBM0121 Fundamental of Computers- Practicals 4 1 OP
SEM ITOTAL CREDIT 20  

 

 

Introduction to Accounting

 

Course Code: LBM0101 Course Title:Introduction to Accounting (4 Credits)
Course Objectives: –

Ø  To explain the basic concepts, rules & scope of Accounting.

Ø  To assess the steps in the accounting process.

Ø  To describe whether the items related with the business are of capital or revenue nature.

Ø  To design Final Accounts for the trading concerns.

Ø To analyze the depreciation accounting methods adopted by trading firms.

Course Contents

Unit No. Unit Description Learning Outcome
1 Introduction to Accounting Principles & Standards: GAAP- Basic Accounting Concepts & Conventions along with examples. Students will be able to understand and evaluate the basic accounting concepts and conventions of accounting. BTL2: Understand, BTL5: Evaluate
2 Accounting Standards: An Overview of Accounting Standards issued by ICAI and IFRS issued by IASB. Students will be able to understand and evaluate the accounting standards. BTL2: Understand, BTL5: Evaluate
3 Accounting Process and special Accounting Treatment: Books of Original Entry format and recording – Journal. Students will be able to understand how to enter transaction in accounting book i.e., journal and to make entries in journal. BTL2: Understand, BTL3: Apply
4 Preparation of Ledger and Trial Balance. Meaning and format of ledger, posting of journal entries to ledger accounts, balancing of ledger accounts, Meaning and objectives of trial balance, Methods of preparing trial balance: Students will be able to understand how to prepare basic accounts of business related to journal. BTL2: Understand, BTL3: Apply
5 Rectifications of Errors:Types of accounting errors, Stages at which errors are identified, Rectification entries Students will be able to correct the mistakes or wrong entries which were made while journalizing the transactions BTL4: Analyze
6 Depreciation: Meaning & Importance, Depreciation Methods, Change in method, Provisions and Reserves. Students will be able to apply the depreciation techniques on different assets of the firms. BTL3: Apply
7 Final Accounts of Sole Trading Concerns: Preparation of Trading & Profit/loss Account and Balance Sheet – Accounting treatment of General and Special adjustments.(Sole Proprietorship only) (Without adjustments). Students will be able to prepare the book of accounts of the business and will be able to understand the financial position of business. BTL3: Apply, BTL5: Evaluate
8 Final Accounts of Sole Trading Concerns: Preparation of Trading & Profit/loss Account and Balance Sheet – Accounting treatment of General and Special adjustments.(Sole Proprietorship only) (With adjustments). Students will be able to prepare the book of accounts of the business and will be able to understand the financial position of business. BTL3: Apply, BTL5: Evaluate
9 Departmental Accounts: Meaning and purpose, allocation of expenses, Inter-departmental transfers. Students will able to understand the basics of departmental accounting. BTL2: Understand
10 Accounting of Hire Purchase: Meaning and calculation of Interest, partial and full repossession, Hire purchase trading (total cash price basis), stock and debtors system; Students will able be to calculate the value of hire purchase and the scheme of hire purchase which is used by all business units. BTL3: Apply
10 Concepts of Lease – Operating and Financial lease (theory only) Students will be able to understand the concept of lease. BTL2: Understand
12 Consignment Accounts: Important terms, accounting records, Books of Consigner andConsignee, Valuation of unsold stock, Conversion of consignment into branch, loss of goods—normal and abnormal. Students will develop the basic understanding of the working of consignment accounts.BTL2: Understand, BTL4: Analyze, BTL6: Create
13 Insurance Claims: – I Claims on account of loss of stock, loss of profit or consequential loss, loss of fixed assets, application of average clause, self-insurance and co-insurance. Students will develop the understanding and working and will also learn the importance of consignment accounts.BTL2: Understand, BTL5: Evaluate
14 Insurance Claims: – II Entries in books of accounts, Workmen compensation insurance. Students will develop the understanding and working and will also learn the importance of consignment accounts.BTL2: Understand, BTL5: Evaluate
Text book References: –

1.    Mohamed Hanif and Mukherjee Amitabha., “Financial Accounting”, McGraw Hill Education, New Delhi.

2.    Maheshwari, S.N., and Maheshwari, S. K., “Financial Accounting”, Vikas PublishingHouse, New Delhi.

Other References:-

1.      Anthony, R.N. and Reece, J.S., “Accounting Principles”, Richard Irvin Inc.

2.      Lal, Jawahar., and Srivastava, Seema., “Financial Accounting Text & Problems”,

3.      Himalaya Publishing House, New Delhi.

4.      Tulsian, P.C., “Financial Accounting”, Tata McGraw Hill, New Delhi.

5.      Elliott, Barry. and Elliott, Jamie., “Financial Reporting and Analysis”, Prentice HallInternational.

6.    Horngren, Charles T., “Introduction to Financial Accounting”, Pearson Education.

(Bloom’s Taxonomy: BT level 1: Remembering; BT level 2: Understanding; BT level 3: Applying; BT level 4: Analyzing; BT level 5: Evaluating; BT level 6: Creating)

Fundamentals of Computers

 

Course Code: LBM0102 Course Title: Fundamentals of Computers (4 Credits)
Course Objectives: –

Ø  To Identify computer hardware components and describe their function

Ø  To describe the essential elements of the computer’s architecture and discuss how this architecture functions.

Ø  To evaluate and describe the characteristics and representations of data, and interpret and compare data in different representations.

Ø  To understand and identify operating system features and internet

Ø To understand the fundamentals of computers like basic working and structure of computer, data representation, and office automation and networking

Course Contents

Unit No. Unit Description
Learning Outcome
1 Introduction to Computers: Defining Computers, features, History, Generations, Components, classification of computers. Understand the definition, history, generations, features, components, and classification of computers. BTL1: Remember, BTL2: Understand
2 Functional Units of Computer Processing System: Processing Unit, Input Devices & Output Devices, Hardware, Memory andsecondary storage devices, Information Concept andProcessing. Identify the major hardware units, memory types, and input-output devices, and explain their roles in data processing. BTL1: Remember, BTL2: Understand
3 Data Communication and Networks: Data Communication Definition, Network, Definition Types of Network – LAN, MAN, SAN, WAN, Network Structure, StarNetwork, Bus Network, Mesh Network. Describe data communication basics, explain different types of networks and network topologies BTL2: Understand, BTL4: Analyze
4 Data representation: Representation of Data, Bits and Bytes,

Number System: Decimal, Binary, Octal, Hexadecimal, Conversions b/w numbersystem, Arithmetic Operations in Binary Number, ASCII and BCD Codes.

Convert between number systems, perform binary arithmetic, and understand the use of ASCII and BCD codes. BTL3: Apply, BTL2: Understand
5 Introduction to Boolean Algebra: AND, OR, NOT, NAND gates, Half Adder, Full–Adder, Kannaugh Maps, Simplification. Understand the principles of Boolean algebra, logic gates, and simplify logic expressions using Karnaugh Maps. BTL2: Understand, BTL4: Analyze
6 Classification of languages: Assembly Language, High Level Language, Machine Languages, Compiler, Interpreter, Assembler. Distinguish between machine, assembly, and high-level languages and understand the role of compiler, interpreter, and assembler. BTL2: Understand, BTL4: Analyze
7 Algorithms: Representation of Algorithms, Structure of Algorithms, Properties of Algorithms, Analysis of an algorithm, Need of Algorithms. Define algorithms, describe their structure, properties, and importance in computing. Analyze simple algorithms. BTL2: Understand, BTL4: Analyze
8 Internet and itsApplications: introduction of internet, History and Importance of internet,

E-mail: History of email, Advantage of email, Email program, Email account. Email address, parts of email messages, Mail attaching a file in Gmail, World Wide Web, Extranet and

Computer Threats: Virus,Worm, Trojan horse, Malware.

Explain the history, applications of the Internet and E-mail, identify online threats like malware, and describe the concept of WWW and Extranet.BTL2: Understand, BTL3: Apply
9 MS word – part-1: Introduction, Objectives, What is Word-Processing, Important Features of MS-Word, Main menu option,

Creating and Editing a documents: Creating a Documents, Entering Text In the documents, Editing Operations, Inserting, Replacing and Deleting Character, Using the toolbar, Undo-Repeat, Find and Replace Text, Save and Exit.

Create, edit, and manage documents using MS Word, including text formatting and document operations. BTL3: Apply
10 MS word – part-2: Formatting a Document: Default and Customized Format, Character Formatting, Line Spacing, Alignment, Boarding and Shading, Page Breaks, Columns, Changing Case, Adding and Removing Numbers, Tab Setting, Indenting, Margins, Header and Footer, Spell Checking the Documents, Creating and Managing Tables, Preview and Printing a documents, printing to file.
Mail Merge: Introduction, Objectives, What is Mail Merge, Concepts of Mail Merge and its Components, Mail Merge option of word, Merged Printing, Conditional Merging 
·         Format documents using advanced tools, manage tables, headers, footers, and execute Mail Merge for bulk personalized communication. BTL3: Apply, BTL5: Evaluate
11 ·         MS Excel – part-1:  Introduction to Microsoft Excel. Starting excel, Component of Excel window, Changing the active cell, Creating and save worksheet, Deleting a worksheet, Switching between the worksheet, Creating a series.

·

·         Use Excel for basic data entry, worksheet creation, navigation, and organizing data in a spreadsheet. BTL3: Apply
12 MS Excel – part-2: Calculate the Sum, AutoCorrect and AutoFill, Display Formulas, Manage Page Layout.

 

Perform calculations, apply AutoFill and AutoCorrect features, and manage Excel’s page layout settings.  BTL3: Apply, BTL4: Analyze
13 MS Power point introduction: Introduction, Using themes and templates, Applying team, applying templates, Changing PowerPoint view, Normal view, Slide plane, Slide, Thumbnail panel, Outline view, Slide shorter view, Reading view, Slideshow view, Modifying a background, Project.

 

Design presentations using themes, templates, different views, and customize backgrounds. BTL3: Apply, BTL6: Create
14 MS Access: Introduction of Database, Use Microsoft Access, Planning the Database, Design Rules, Organizing Data, No Derived Fields, and Data is broken down into Smallest Logical Parts, Descriptive Field Names, Unique Field Names, No Calculated Fields, Unique Records, and Basic Access Objects. Understand database concepts, design principles, and manage data organization using Microsoft Access. BTL2: Understand, BTL3: Apply
Text book References: –

1.    Rajaraman, V., Introduction to Information Technology, PHI.

2.    Hall, J.A., “Accounting Information System”, South-Western College Publishing.

3.    P.K.Sinha ,P.Sinha, Computer Fundamentals, 6th ed., BPB Publications, 2015.

4.    V. Rajaraman, Fundamentals of Computers, 6th ed., PHI, 2015

Other References:-

1.    Boockholdt, J.L., “Accounting Information System: Transaction Processing and Control”, Irwin Mcraw-Hill.

2.    Gelinas, Ulric J., and Steve G. Sutton, Accounting Information System, South Western Thomson Learning.

(Bloom’s Taxonomy: BT level 1: Remembering; BT level 2: Understanding; BT level 3: Applying; BT level 4: Analyzing; BT level 5: Evaluating; BT level 6: Creating)

 

 

 

Business Communication

Course Code: LBM0103 Course Title:Business Communication (4 Credits)
Course Objectives: –

Ø  To understand the concept, process and importance of effective business communication.

Ø  To demonstrate her verbal and non-verbal communication ability through presentations.

Ø  To identify key principles of effective public speaking and develop skills in listening actively and empathetically.

Ø  To evaluate the appropriate usage of informative business messages and writes an informative business message.

Ø To prepare and present effective presentations aided by ICT tools and able to compose e-mail, Resume, formal reports and business letters.

Course Contents

Unit No. Unit Description Learning Outcome
1 Introduction: Nature, Process and Importance of Communication, Students will be able to understand and evaluate the basic concepts of appropriately use of concept, process and importance of effective business communication. BTL2: Understand, BTL5: Evaluate
2 Forms of Communication:Types of Communication (Verbal & Non-Verbal), Different forms of Communication. Students will be able to understand the basic concept of different forms of communication.BTL1: Remember, BTL2: Understand
3 Barriers to Communication:Linguistic Barriers, Psychological Barriers, Interpersonal Barriers, Cultural Barriers, Physical Barriers, Organizational Barriers. Students will be able to understand the barriers of communications. BTL2: Understand, BTL4: Analyze
4 Non-Verbal Aspects of Communication: Body language, Kinesics, Proxemics, Para language Students will be able to understand the nonverbal aspects of communication. BTL2: Understand, BTL4: Analyze
5 Business Correspondence: Letter Writing, presentation, inviting quotations, sending quotations, Placing orders, Inviting tenders. Students will be able to understand the business correspondence. BTL2: Understand, BTL3: Apply
6 Business Letter Process: Sales letters, claim & adjustment letters and social correspondence, Memorandum. Students will be able to understand and practical application of business communication terminology. BTL3: Apply, BTL6: Create
7 Preparation of Office Documents:Inter -office Memo, Notices, Agenda, and Minutes, Job application letter, preparing the resume. Students will be able to understand and learn the preparation of different office documents. BTL3: Apply, BTL6: Create
8 Effective Listening: Principles of effective listening, Factors affecting listening exercises, Oral, Written, Video sessions and Seminars. Students will be able to learn the effective learning skills also. BTL3: Apply, BTL5: Evaluate
9 Report Writing: Identify the types of reports, define the basic format of a report, identify the steps of report writing, and write a report meeting the format requirements. Students will be able to appropriately use the business information and will be able to write appropriate & informative business messages. BTL3: Apply, BTL6: Create
10 Process of writing a Report: Process and importance of including visuals such as tables, diagrams and charts in writing report, apply citation rules (APA style documentation) in reports. Students will be able to understand and learn how to write a report. BTL4: Analyze, BTL6: Create
11 Business language: Importance of Business language, Vocabulary Words often confused, Words often misspelt, Common errors in English. Students will be able to prepare and learn effective business language. BTL2: Understand, BTL3: Apply
12 Presentation: Oral Presentation Importance, Characteristics, Presentation Plan, Power point presentation, Visual aids. Students will be able to prepare and present effective presentations. BTL3: Apply, BTL6: Create
13 Technology and Business Communication: Role, effects and advantages of technology in Business Communication like email, text messaging, and instant messaging. Students will have a hands on experience of composing e-mail, Resume-writing, formal reports and business letters. BTL3: Apply, BTL5: Evaluate
14 Modern Techniques of Communication: Video conferencing, social networking. Strategic importance of e-communication. Students will be able to understand and will update their knowledge by learning the modern techniques of communication.BTL2: Understand, BTL5: Evaluate
Text book References: –

1.      Kaul, “Business Communication”, Prentice Hall, New Delhi.

2.      Gupta, C.B., “Business Communication”, Sulthan Chand & Sons, New Delhi.

3.      Internet Generation, Tata McGraw Hill Publishing Company Ltd. New Delhi.

4.      Bovee, and Thill, Business Communication Today, Pearson Education

5.      Shirley, Taylor, Communication for Business, Pearson Education

Other References:-

1.      Locker and Kaczmarek, Business Communication: Building Critical Skills, TMH

2.      Sharma, R.C., and Krishna Mohan, “Business Correspondence and Report Writing”, Tata

3.    McGraw-Hill Publishing Company Limited, New Delhi.

(Bloom’s Taxonomy: BT level 1: Remembering; BT level 2: Understanding; BT level 3: Applying; BT level 4: Analyzing; BT level 5: Evaluating; BT level 6: Creating)

 

 

 

 

 

 

Micro Economics

Course Code: LBM0104 Course Title:Micro Economics (4 Credits)
Course Objectives: –

Ø  To understand the basic concepts related to consumer behavior using different types of elasticity concepts.

Ø  To evaluate the relevance of demand and supply behavior in the short run and long run.

Ø  To highlight the various concepts of production function and cost theory.

Ø  To analyze the relationship between various types of cost curves with the help of examples.

Ø To create the differences between various forms of market for with the help of relevant examples.

Course Contents

Unit No. Unit Description Learning Outcome
1 Elasticity of Demand:Basic demand and supply analysis; Elasticity of demand: price, income and cross elasticity, point elasticity and arc elasticity. Students will be able to understand and evaluate the basic concepts of elasticity of demand and how it affects the business. BTL2: Understand, BTL4: Analyze, BTL5: Evaluate
2 Revenue Concepts:Marginal Revenue, Average Revenue. Students will learn the different concepts of revenue. BTL1: Remember, BTL2: Understand
3 Utility Concept: Ordinal Utility, Cardinal Utility. Students will be able to understand the concept of utility and its practical implication. BTL2: Understand, BTL3: Apply
4 Consumer Behaviour:Ordinal utility analysis of consumer behaviour: Budget line and indifference curve, consumer equilibrium. Income consumption curve and Engel curve, Price consumption curve and derivation of demand curve, Income and Substitution Effects of a price change. Students will be able to understand basic concepts related to consumer behavior using different types of elasticity concepts. BTL4: Analyze, BTL5: Evaluate
5 Indifference Curve: Indifference Curve and approaches Students will learn about the concept of Indifference curve.BTL2: Understand, BTL3: Apply
6 Consumers’ Surplus:Concept of Consumer Surplus; Revealed Preference theory. Students will learn about concept of consumer surplus and how does it works. BTL1: Remember, BTL4: Analyze
7 Production and Cost: Total, average and marginal product curves, Three stages of production. Students will be able to define different concepts of production function and cost theory. BTL1: Remember, BTL3: Apply
8 Concepts ofproduction function: Production isoquants, marginal rate of technical substitution, economic region of production, Iso-cost lines, optimal combination of resources, the expansion path, returns to scale. Students will be able to understand the concepts ofproduction function and their usage.  BTL4: Analyze, BTL5: Evaluate
9 Cost of Production: Concept of explicit costs, implicit costs and opportunity costs of production, derivation of short run and long run cost curves. Students will be able to understand the concepts ofcost of production and how does it affects the business in short and long run. BTL2: Understand, BTL6: Create
10 Scales: Economies and Diseconomies of scale and the shape to the long run average cost. Learning curve and economies of scope. Students will be able to understand the meaning of economies of scale and there importance. BTL4: Analyze, BTL5: Evaluate
11 Perfect Competition: Assumptions, Equilibrium of the firm and the industry in the short run, Supply curve of firm and industry in the long run. Consumers’ and Producers’ Surplus and the efficiency of perfect competition. Welfare effects of an excise tax. Students will be able to understand the perfect market terminology. BTL4: Analyze, BTL5: Evaluate
12 Imperfect Competition: Monopolistic competition – price and output decision in the short run and long run monopolistic competition and economic efficiency. Students will able to understand the imperfect market structure and its working. BTL2: Understand, BTL4: Analyze
13 Monopoly: Monopoly short run and long run equilibrium. Shifts in demand curve and the absence of the supply curve. Measurement of monopoly power and the rule of thumb for pricing. Comparison of pure competition and monopoly and the social costs of monopoly power including deadweight loss. Degree of price discrimination. Students will able to understand in detail the concept of monopoly market and how it is different from other two types of market.BTL4: Analyze, BTL5: Evaluate
14 Oligopoly and Interdependence:Cournot’s Duopoly Model (with reaction curves) kinked demand curve model, dominant firm price-leadership model, centralized cartels. Prisoners’ Dilemma. Students will able to understand in detail the concept of oligopoly market and its working.BTL2: Understand, BTL4: Analyze
Text book References: –

1.      Dwivedi, D. N., “Principles of Economics”, Vikas Publishing House New Delhi.

2.      Deepashree, “Microeconomics-Theory & Applications”, McGraw Hill, New Delhi.

3.      Salvatore, Dominick, “Principles of Microeconomics”, Oxford International Student

4.      Edition.

5.      Gould, J.P., and Lazear, E.P., “Microeconomic Theory”, All India Traveller Bookseller,

New Delhi.

Other References:-

1.      Pindyck, R.S., D. L. Rubinfeld and Mehta, P. L., “Microeconomics”, Pearson Education.

2.      Koutsoyiannis A., “Modern micro-economics”, Macmillan New Delhi.

3.      Stigler, G., “The Theory of price”, Prentice Hall Of India, New Delhi.

4.      Jhingan M.L., “Micro Economic Theory”, Vrinda Publications Pvt. Ltd., Delhi.

(Bloom’s Taxonomy: BT level 1: Remembering; BT level 2: Understanding; BT level 3: Applying; BT level 4: Analyzing; BT level 5: Evaluating; BT level 6: Creating)

Course Code: – LBM0121

Fundamentals of Computers Practicals

 

List of Experiments

EXERCISE 1

Create a document with the text given below and save it as First. Doc

A Read-only Memory is a memory unit that performs the read operation only, it does not have a write capability. This implies that binary information stored in a ROM is made permanent during the hardware production of the unit and cannot be altered by writing different words into it. Whereas RAM is a general-purpose device whose contents can be altered during the computational process, a ROM is restricted to reading words that are permanently stored within the unit. The binary information to be stored specified by the designer is then embedded in the unit to form the required interconnection pattern. Do the following:

a)  Count the occurrences of the word “ROM” in the above document.

b) Replace ROM with Read Only Memory in the entire document

c)  Underline the text Read Only Memory

d) Make an auto-correct entry for ROM and it should be replaced by Read Only Memory.

EXERCISE 2

Perform the following tasks in Ms-Word.

i)                Open a document. Type the following text.

As already mentioned, a word processor is a package that processes textual matter and creates organized and flawless documents. A word processor has everything that a conventional typewriter has. In addition it, a word processor not only removes all the limitations of typewriters but also offers useful features that cannot be even dreamt of with a writer.

Also if the same textual matter is to be reproduced with minor changes, retyping is the only option in typewriters. On the other hand, the same situation can easily be tackled with in word processor using its mail merge feature. The mail merge feature allows you to combine text and data without requiring any retyping.

Word processing originated way back in 1964 when special typewriters, MIST were launched by IBM. These machines were capable of storing documents on magnetic storage. The stored data could easily be reprinted when desired.

ii)               Insert the following text after the first paragraph.

The main components of a word processing system are listed below:

·         Computer

·         Printer

·         A word Processing Software.

iii)             Save the document Word1.doc

iv)             Move the second paragraph to the end of the document, using drag & drop feature.

v)              Restore the original status of the document.

vi)             Nowprovideaheader‘WorkingwithWordProcessor’in14pt.Bold, Italics and in Times New Roman.

vii)           Move the second paragraph to the end of the document using cut, and paste operations.

viii)          Undo the above actions.

ix)             Now redo the above actions.

x)              Go to the end of the document (in one step).

xi)             Go to the beginning of the document (in one step).

xii)           Search the word “computer” in your document with the option Match case, Find whole words only.

xiii)          Replace the word ‘typewriters’ with ‘word processors’.

xiv)          Format the above-written paragraphs and give the options as follows: Alignment :           justified

Indentation:                          Let0.2”Right: 0.2”

Spacing:                                Before 6 pt. After: 6 pt.

Special:                                 First Line by: 0.4”

Line spacing:                         1.5 Lines.

xv)           Set the margins to 1.25”

 

EXERCISE 3

Perform the following in MS Word

i)            Create a new word document and type the following text:

A ROBOT IN THE HOUSE

Correction. You are in error. You are misinforming your father. Correction. The work has not been done. Your computer has not been used. ERROR, ERROR”.The robot’s voice was metallic.

TARUN: You are so lucky, Aditi! Manku can do so many things. It can clean the house. It can answer the telephone, call the doctor and it can even open the door.

ADITI: Wait! There are so many things it can’t do. It can’t laugh. It can’t do MY HOMEWORK FORME. It can’t even help me decide what should I wear for the party.

ii)          SavethedocumentasDOCUMENT.DOC

iii)         Insert the following text before the conversation between Aditi and Tarun

“Oh! Stop interrupting, Manku”. Aditi said a grily. “You are not supposed to participate in every conversation”

iv)         Make the story heading bold, italic and 14 pts.

v)          Change the font style of the entire story to MS-Comic Sans

vi)         Select the heading of the document, cut and paste it at the end of the document

vii)       Undo the previous action

viii)      Select the first two lines of the paragraph and convert it to upper case. Change all the upper case letters to lower case and vice-versa

ix)         Changethefontstyleofthelastparagraph12ptsbolditalicxi.Copythisformattothefirstparagraphusingformat painter

x)          Highlight the second paragraph (Hint: use highlighter or formatting toolbar)

xi)         Change the font size of the entire text to 14 pts

xii)       Make the document a different name(MYBOOK.DOC)

 

EXERCISE 4

Perform the following tasks in Ms-Word.

i)       Try to write the following text in the format as shown:

You come across several documents every day. Some examples of documents are listed below: documents inform

·         Letters

·         Brochures

·         Financial reports Agendas for meetings

·         Research papers

·         Magazines and Newsletters Documents that persuade

·         Advertisements

·         Invitations

·         Press Releases Documents that identify

·         Business cards

·         Certificates

·         Labels

ii)     Insert the following tables in your document

Organic Compound Molecular Formula
Methane CH4
Ethane C2H6
Propane C3H8
Butane C4H10
Symbol Electronic Configuration
H 1s1
He 1s2
Li [He] 2s1
Be [He] 2s2

Save and close the document.

 

EXERCISE 5

Insert a table. The table should have 5 columns. The auto behaviour should be ‘Fixed column width’. The following report has to be created in the table.

Sr.No. Name Basic Pay Designation Department
1 Rahul Roy 10000/- MD Marketing
2 RituGarg 12000/- AD Sales
3 Mohit 8000/- Manager Sales
4 Rakesh 9000/- Senior Manager HR

a)      Headings should have a font size of 18, the colour should be blue and fonts should be bold.

b)      The data should have a font size of 12, the colour should be Red and the font should be italic

c)      Insert a new row between 3&4 type the data and reorder the sr. no column.

EXERCISE 6

Below is given a letter and some addresses, this letter is to be sent to all these addresses, so use mail merge option to do so. The Addresses are:

1)      AmitH.No. 424 sector 8D Chandigarh

2)      RohitH.No. 444, Sector 125C Chandigarh

3)      Jyoti H. NO. 550, Sector 16A Chandigarh The Letter is:-

To

<<Name>>

<<Address>>

Dear<<Name>>

You are called for an interview on the <<Date>>at 9:00 A.M with your original documents Yours Sincerely

ABC Limited Phase –7Mohali

EXERCISE 7

Make a document with the following

a)      Itshouldhave3pages

b)      It should have bookmarks named book1, book2, and book3 for the respective pages.

c)      Using the go-to command go to the

·         Page no 2

·         Bookmark namedbook3

d)     Insert a one-page break on page 2 to make it to the no. of pages 4.

e)      Insert the page number on each page

EXERCISE 8

Use of Formulas Sum, Average, If, Count, Count a, Count if & Sum if

RollNo Student Name Hindi English Math Physics Chemistry Total Average Grade
1 RAM 20 10 14 18 15 77 15.4 A
2 ASHOK 21 12 14 12 18 ? ? ?
3 MANOJ 33 15 7 14 17 ? ? ?
4 RAJESH 15 14 8 16 20 ? ? ?
5 RANJANA 14 17 10 13 18 ? ? ?
6 POOJA 16 8 20 17 15 ? ? ?
7 MAHESH 18 19 3 10 14 ? ? ?
8 ASHUTOSH 19 20 7 14 18 ? ? ?
9 ANIL 22 13 8 12 19 ? ? ?
10 PREM 26 12 10 11 27 ? ? ?

 

·         Find the Total Number & Average in all Subjects in Each Student.

·         Find Grade Using If  Function-If Average Greater > 15 then “A” Grade otherwise “B” Grade

·         How Many Student “A” and “B” Grade Use of Count if

·         Student Ashok and Manoj Total Number and Average Use of Sum if

·         Count how many Students Use of Count a

·         How Many Student Hindi & English Subject Number Grater Then>20and<15 Use of Count if

EXERCISE 9

UseofFormulas-Product,If,Count a,Count if,Sum if

 

S.no. Items Qty. Rate Amount Grade
1 AC 20 40000 800000 expensive
2 FRIDGE 30 20000 ?
3 COOLER 15 10000 ?
4 WASHINGMACHINE 14 15000 ?
5 TV 18 20000 ?
6 FAN 17 2000 ?
7 COMPUTER 10 25000 ?
8 KEYBOARD 5 250 ?
9 MOUSE 25 100 ?
10 PRINTER 30 12000 ?

 

·         Using of Product Formula for Calculate Amount = Qty*Rate

·         How Many Items in a List

·         How Many Items qtyGreate Then>20andLessThen<20

·         Calculate Item Computer Qty, Rate and Amount using the Sum if  Formula

·         If Items Amount is Greater> than 500000, Then Items “Expensive” otherwise “Let’s Buy it”.

 

EXERCISE 10

UseofFormulas-Sum,NestedIf,Counta,Countif,Sumif,Vlookup

 

SUBJECT 1ST 2ND 3RD TOTAL AVERAGE GRADE
HINDI 20 15 20 55 18.33333333 B
ENGLISH 30 12 15 ? ? ?
MATH 15 14 14 ? ? ?
PHYSICS 12 17 17 ? ? ?
CHEMISTRY 14 18 18 ? ? ?
HISTORY 16 25 20 ? ? ?
GEO 18 21 22 ? ? ?
BIO 17 23 13 ? ? ?
BOTANY 20 25 25 ? ? ?

·         HOW MANY SUBJECT ?          Use of Count a

·         HOW MANY SUBJECT 1 PAPER GREATER THAN 20 ?     Use of Count if Use of

·         SUBJECT HINDI, MATH & ENGLISH TOTAL NO. & GRADE       V look up

·         SUBJECT PHYSICS, MATHS & ENGLISH TOTAL /AVERAGE      V look up

EXERCISE 11

Use of Formulas – Sum, Average, Count a, Count if, Sum if, & If

Student Name Subject Result
Name Maths English Physics TOTAL PERCENTAGE GRADE
Alan 80 75 85 240 80 EXCELLENT
Bob 50 30 40 120 ? ?
Carol 60 70 poor 130 ? ?
David 90 85 95 270 ? ?
Eric 20 30 Absent 50 ? ?
Fred 40 60 80 180 ? ?
Gail 10 90 80 180 ? ?
Harry 80 70 60 210 ? ?
Ian 30 10 20 60 ? ?
Janice 10 20 30 60 ? ?

 

·      How Many Students?                                                                      Use Formula Counta

·      How Many Student Percentage Greater Then>50                          Use Formula Countif

·      Student Bob and Eric Total Number?                                              Use Formula Sumif

·      If the Percentage is Greater Than> 70 Then “Excellent”, If the Percentage is Greater Than> 50, “Good”, Otherwise “Bed”

·      How Many Student Good and Bedina list                                     Use Formula Countif

EXERCISE 12

Use of Formulas–LOOK UP

LOOKUPFUNCTIONSYNTAX LOOKUP (LOOKUP_value,lookup_vector,[result_vector])

 

 

Employee ID

 

Pay

First

Name

Last

Name

602693 $84,289 Micheal Vick
611810 $1,37,670 ? ?
549457 $1,90,024 ? ?
612235 $1,22,604 ? ?
580622 $1,11,709 ? ?
830385 $    85,931 ? ?
253072 $1,68,114 ? ?
391006 $    89,627 ? ?
990678 $1,49,946 ? ?
795574 $1,45,893 ? ?
392128 $    64,757 ? ?
352711 $    71,478 ? ?
110608 $1,21,444 ? ?
 

Employee ID

 

Last Name

 

First Name

110608 Doe John
253072 Cline Andy
352711 Smith John
391006 Pan Peter
392128 Favre Bret
549457 Elway John
580622 Manning Eli
602693 Vick Micheal
611810 Woods Tiger
612235 Jordan Micheal
795574 Stark Tony
830385 Williams Prince
990678 Pitt Brad

 

 

 

 

 

EXERCISE 13

Useof Formulas-Count aandV look up

 

 

ProductName

 

Jan

 

Feb

 

Mar

 

Apr

 

May

 

Jun

 

Jul

 

Aug

TotalSales
Apples $2,773 $17,462 $5,954 $1,348 $28,158 $28,799 $25,415 $17,227 $1,27,136
Grapefruit $12,908 $3,083 $24,492 $5,825 $1,080 $2,188 $11,087 $15,544 ?
Lemons $6,554 $14,262 $8,377 $24,982 $12,184 $6,430 $21,159 $18,597 ?
Lime $28,913 $1,437 $20,019 $13,026 $26,952 $27,076 $7,040 $10,884 ?
Oranges $4,768 $7,622 $28,918 $27,141 $3,578 $10,092 $15,207 $12,771 ?
Peaches $13,390 $3,611 $6,226 $27,567 $29,962 $2,967 $5,740 $2,137 ?
Pears $17,585 $28,508 $9,614 $17,110 $12,143 $7,365 $24,185 $1,643 ?
Pineapples $22,579 $16,301 $6,469 $22,050 $8,740 $18,806 $3,334 $3,597 ?

 

·         How Many Fruits?

·         Fruits Lemons and Pineapples sales in March and Jul?

EXERCISE 14

Use of Formulas-Count if, Countifs and Sumifs and Vlookup

Name Gender Country Score
Richard Male United States 74
Jennifer Female United Kingdom 92
James Male United States 65
Lisa Female Canada 82
Sharon Female Australia 50
Elizabeth Female Canada 91
Carol Female United States 96
Mark Male United States 58
John Male Canada 67
Susan Female United Kingdom 54
David Male United States 83

·         How Many Male and Female Candidates in a List? Use of  Formula Count if

·         How Many Male Employees in the United States? Use  of  Formula Count if

·         Lisa and John, Which Country Belong? Use of  Vlookup

·         The United States Male and Female Candidate Scores? Use if Formula.

EXERCISE 15

 

Design a Birthday Invitation card with music.

 

 

EXERCISE 16

 

Design Seasonal Greeting cards card.

 

 

EXERCISE 17

Design an AMU Magazine cover. Use the following:

·         Select a theme for the page,

·         Insert either a picture or clip art, and

·         Use Word Art.

 

EXERCISE 18

Design a poster inviting all students of your department to the IT Fest.

EXERCISE 19

Create a 5-slide presentation on any topic. Use Images, Graphs, Chart, Tables, Animation, Time, Bullets, Transition, Sound, Hyperlink, Back ground template, Header and Footer.

EXERCISE 20

Design a power point presentation of your favorite person to whom you impressed.

EXERCISE 21

Microsoft Access interface.

Tasks:

a)      Open Microsoft Access.

b)      Create a new blank database.

c)      Save the database with a suitable name and location.

d)     Close and reopen the database.

EXERCISE 22

Create tables in Microsoft Access.

Tasks:

a)      Create a new table using the Table Design view.

b)      Define fields with appropriate data types.

c)      Add sample data to the table.

d)     Save the table.

 

EXERCISE 23

Importing and Exporting Data

Tasks:

a)      Import data from an external source (e.g., Excel).

b)      Export data to an external file format (e.g., CSV).

 

EXERCISE 24

Enforce design rules for database integrity.

Tasks:

a)      Attempt to create a table with duplicate field names.

b)      Attempt to create a table with non-descriptive field names.

EXERCISE 25

Understand why calculated fields should be avoided in tables.

Tasks:

a)        Attempt to create a table with calculated fields.

b)        Discuss alternative methods (e.g., using queries or forms) for calculations.

 

EXERCISE 26

Creating Queries

Tasks:

a)      Create a select query to retrieve specific data from a table.

b)      Create a parameter query that prompts for user input.

 

 

EXERCISE 27

Explore the creation of forms and reports.

Tasks:

a)      Create a simple data entry form.

b)      Generate a basic report based on a table or query.

II Semester

 

Course Code Course Title Credit Sem Th/P
LBM0201 Management Principles & Applications 4 2 Th
LBM0202 Environmental Studies 4 2 Th
LBM0203 Business Statistics 4 2 Th
LBM0204 Macro Economics 4 2 Th
LBM0205 Financial Management 4 2 Th
SEM IITOTAL CREDIT 20  

 

 

Management Principles & Applications

 

Course Code: LBM0201 Course Title: Management Principles & Applications (4 Credits)
Course Objectives: –

Ø  To understand the fundamental concepts and theories of management

Ø  To develop skills in managerial thinking and decision-making

Ø  To explore the key functions of management

Ø  To analyze organizational behavior and leadership principles

Ø  To understand the role of management in contemporary business environments

                         Course Contents

Unit No. Unit Description Learning Outcome
1 Introduction to Management:Definition and Importance of Management, Management Functions Planning, Organizing, Directing, Controlling, Levels of Management, Roles of a Manager Interpersonal, Informational, Decisional, Managerial Skills and Effectiveness Students will be able to define management, understand its core functions, identify management levels, describe managerial roles, and analyze managerial skills. BTL 1: Remembering, BTL 2: Understanding, BTL 4: Analyzing
2 Concept and Nature of Management:Principles of management, science vs art debate, management as profession.

 

Students will analyze the principles and dual nature of management as both a science and an art. BTL 1: Remembering, BTL 2: Understanding, BTL 3: Analyzing
3 Management and Administration: Management and Administration; Levels of management; Managerial roles; Management functions; Case study:1; Review Question. Students will differentiate between management and administration and apply managerial concepts.

BTL 2: Understanding, BTL 3: Applying, BTL 4: Analyzing

4 Staffing: Meaning and importance; Manpower planning; Recruitment and selection; Training and development; Performance appraisal; Trends in HRM. Students will apply staffing techniques and evaluate their importance in organizations.

BTL 2: Understanding, BTL 3: Applying, BTL 5: Evaluating

5 Directing: Meaning and importance; Elements: Supervision, leadership, motivation, communication; Leadership styles and theories; Motivation theories (Maslow, Herzberg, McGregor). Students will understand directing elements and apply leadership and motivation theories.

BTL 1: Remembering, BTL 2: Understanding, BTL 3: Applying

6 Controlling: Meaning, nature, and importance; Steps in the control process; Techniques of control: Budgetary control, Break-even analysis, MBO; Link between planning and controlling. Students will apply control techniques and analyze their link with planning.

BTL 2: Understanding, BTL 3: Applying, BTL 4: Analyzing

7 Coordination:Meaning, importance, and principles of coordination; Techniques for effective coordination. Students will understand the importance of coordination and apply techniques for effective coordination.

BTL 1: Remembering, BTL 2: Understanding, BTL 3: Applying

8 Communication: Communication process and types; Barriers and strategies for effective communication. Students will analyze communication barriers and develop effective communication strategies.

BTL 2: Understanding, BTL 3: Applying, BTL 4: Analyzing

9 Emerging Trends in Management I: Total Quality Management (TQM); Business Process Reengineering (BPR); Knowledge Management. Students will explore and apply emerging concepts such as TQM, BPR, and Knowledge Management.

BTL 1: Remembering, BTL 2: Understanding, BTL 3: Applying

10 Emerging Trends in Management:Incorporate Social Responsibility (CSR); Managing change; Sustainable practices. Students will understand CSR concepts, analyze change management techniques, and evaluate sustainable practices.

BTL 2: Understanding, BTL 4: Analyzing, BTL 5: Evaluating

11 Indian Ethos in Management: Indian ethos: Meaning and features; Work ethos; Ethics and social responsibility. Students will explore Indian ethos and apply ethical principles in management practices.

BTL 1: Remembering, BTL 2: Understanding, BTL 3: Applying

12 Indian Values in Management: Indian values for management; Lessons from Indian scriptures (Gita, Upanishads). Students will understand and apply Indian traditional values from scriptures to modern management contexts.

BTL 1: Remembering, BTL 2: Understanding, BTL 3: Applying

Textbook References:-

1.      Tripathi, P.C. & Reddy, P.N., Principles of Management, McGraw Hill Education, 6th Edition

Other References:-

1.      Drucker, P.F., Management: Tasks, Responsibilities, Practices, Harper & Row

2.      Robbins, S.P. & Judge, T.A., Organizational Behavior, Pearson

3.      Mintzberg, H., The Strategy Process: Concepts, Contexts, Cases, Pearson

4.      Bass, B.M. &Riggio, R.E., Transformational Leadership, Lawrence Erlbaum Associates

(Bloom’s Taxonomy: BT level 1: Remembering; BT level 2: Understanding; BT level 3: Applying; BT level 4: Analyzing; BT level 5: Evaluating; BT level 6: Creating)

 

 

Environmental Studies

Course Code: LBM0202 Course Title: Environmental Studies (4 Credits)
Course Objectives: –

Ø  To understand the fundamental concepts of environment, ecosystems, and natural resources through the study of environmental components, ecosystem dynamics, and resource management principles.

Ø  To analyse environmental issues and their solutions by examining pollution types, biodiversity conservation, climate change impacts, and waste management strategies.

Ø  To assess environmental problems and develop sustainable solutions using scientific approaches.

Ø  To develop knowledge of environmental policies and regulations through the study of environmental laws, international agreements, and protection mechanisms at national and global levels.

Ø To evaluate human-environment relationships by studying population impacts, disaster management, environmental movements, and environmental ethics in different cultural contexts.

Course Contents

Unit No. Unit Description Learning Outcome
1 Fundamentals of Environment: Definition, concepts, scope and importance of environmental studies; Components of environment; Concept of sustainability and sustainable development. After completing this unit, students will be able to explain key environmental concepts, interrelationships, and sustainable development principles in a contemporary context.BTL 1: Remembering, BTL 2: Understanding, BTL 4: Analysing, BTL 5: Evaluating
2 Ecosystem: Concept and components of ecosystem; Concept on Ecology; Food chain, Food web and Ecological pyramids; Energy flow and productivity in ecosystem. Case studies of the following ecosystems: a Forest ecosystem b Grassland ecosystem c Desert ecosystem d Aquatic ecosystems ponds, streams, lakes, rivers, oceans, estuaries. After completing this unit, students will be able to analyze ecosystem structures, energy flow, and ecological interactions to assess their functional significance.BTL 2: Understanding, BTL 4: Analysing, BTL 5: Evaluating,BTL 6: Creating
3 Natural Resources: Renewable and Non-Renewable Resources I:

Land resources: Land-use and land cover change; Land degradation, Soil erosion, and desertification.
Forest Resources: Types and scope; Deforestation: Causes and impacts due to mining, dam building on environment, forests, biodiversity, and tribal populations.

After completing this unit, students will be able to evaluate resource use, environmental impacts, and sustainable management strategies for long-term conservation. BTL 2: Understanding, BTL 4: Analysing, BTL 5: Evaluating
4 Natural Resources: Renewable and Non-Renewable Resources II:

Water Recourses: Use and over-exploitation of surface and ground water, floods, droughts, conflicts over water international & inter- state.
Energy resources: Renewable and non-renewable energy sources, use of alternate energy sources, growing energy needs, case studies.

Students will be able to assess challenges of water and energy resource management and propose sustainable alternatives.
BTL 3: Applying, BTL 4: Analysing, BTL 5: Evaluating
5 Biodiversity and its conservation: Biodiversity: Levels of biological diversity; Biogeographically classification of India; Values of biodiversity; Hot-Spots of biodiversity; Mega-biodiversity nations; Threat to biodiversity; Threatened and endemic species of India. Conservation of biodiversity In- situ and Ex-situ. Ecosystem services After completing this unit, students will be able to assess biodiversity patterns, threats, and conservation strategies to enhance ecological sustainability.BTL 1: Remembering, BTL 4: Analysing, BTL 5: Evaluating
6 Environmental Pollution: types, causes, effects and controls; Air, water, soil and noise pollution, nuclear hazards and human health risks, Solid waste; management and control measures of urban and industrial waste with case studies. After completing this unit, students will be able to identify pollution sources, impacts, and mitigation strategies, including effective waste management solutions.BTL 4: Analysing, BTL 5: Evaluating, BTL 6: Creating
7 Environmental Policies and Practices: Climate change, global warming, ozone layer depletion, acid rain and impacts on human communities and agriculture. After completing this unit, students will be able to examine global environmental challenges, legal frameworks, and policy implementation for environmental protection. BTL 3: Applying BTL 4: Analysing, BTL 5: Evaluating
8 Environment Laws: Environment Protection Act; Air Prevention & Control of Pollution Act; Water Prevention and control of Pollution Act; Wildlife Protection Act; Forest Conservation Act. Students will be able to interpret and evaluate various Indian environmental laws and analyze their role in addressing environmental issues.
BTL 2: Understanding, BTL 3: Applying, BTL 4: Analysing, BTL 5: Evaluating
9 International Agreements: Montreal and Kyoto protocols and Convention on Biological Diversity CBD. Students will be able to analyze international environmental agreements and evaluate their effectiveness in promoting global sustainability.
BTL 2: Understanding, BTL 4: Analysing, BTL 5: Evaluating
10 Human Communities and the Environment: Human population growth: Impacts on environment, human health and welfare. Resettlement and rehabilitation of project affected persons.

 

After completing this unit, students will be able to analyze human-induced environmental changes, ethical perspectives, and conservation efforts for sustainability. BTL 3: Applying BTL 4: Analysing, BTL 5: Evaluating
11 Environmental movements: Chipko, Silent valley, Khejarli Movement of Rajasthan.

 

Students will be able to understand the role of grassroots movements in environmental conservation and evaluate their significance in shaping modern environmental awareness.
BTL 2: Understanding, BTL 4: Analysing, BTL 5: Evaluating
12 Environmental ethics: Ecological, economic, social, ethical, aesthetic and Informational value. Role of Indian and other religions and cultures in environmental conservation. Students will be able to critically evaluate diverse environmental ethical perspectives and create culturally informed strategies for ecological conservation.
BTL 2: Understanding, BTL 5: Evaluating, BTL 6: Creating
Textbook References:-

1.      Odum, E. P., & Barrett, G. W. 2017. Fundamentals of ecology 5th ed..Cengage Learning.

2.      Enger, E. D., & Smith, B. F. 2022. Environmental science: A study of interrelationships 16th ed.. McGraw-Hill.

3.      Agarwal, S. K. 2021. Environmental science: Fundamentals and applications 3rd ed.. APH Publishing Corporation.

Other References:-

4.      Singh, Y. K., &Chowdhury, R. 2023. Environmental science with applications in India 2nd ed.. S. Chand Publishing.

5.      Miller, G. T., &Spoolman, S. E. 2023. Living in the environment 20th ed..Cengage Learning.

6.      Rajagopalan, R. 2021. Environmental studies: From crisis to cure 4th ed.. Oxford University Press India.

(Bloom’s Taxonomy: BT level 1: Remembering; BT level 2: Understanding; BT level 3: Applying; BT level 4: Analysing; BT level 5: Evaluating; BT level 6: Creating)

 

 

 

Business Statistics

Course Code: LBM0203 Course Title: Business Statistics (4 Credits)
Course Objectives: –

Ø  To develop comprehensive understanding of statistical concepts and methods

Ø  To master data collection and analysis techniques

Ø  To learn probability and probability distributions

Ø  To apply statistical techniques for decision-making

Ø  To understand measures of central tendency and dispersion and Develop skills in statistical inference and hypothesis testing

Course Contents

Unit No. Unit Description Learning Outcome
1 STATISTICS – AN INTRODUCTION :

Meaning of Statistics, Functions of Statistics, Importance of Statistics, Limitations of Statistics

Critically analyze the fundamental role of statistics in business decision-making by comprehensively understanding its meaning, functions, importance, and inherent limitations. BTL 4: Analyzing
2 DATA COLLECTION:

Types of Data, Scale of Data Measurement, Primary Data Collection, Secondary Data Collection

Develop proficiency in identifying, collecting, and critically evaluating different types of data and measurement scales to ensure accurate and reliable information gathering for business research. BTL 5: Evaluating
3 FREQUENCY DISTRIBUTION :

Data Classification, Frequency Distribution Basics, Data Presentation Techniques

Master the techniques of transforming raw data into meaningful frequency distributions and visualizations that effectively communicate complex statistical information. BTL 3: Applying
4 MEASURES OF CENTRAL TENDENCY:

Mean Calculations, Median Analysis, Mode Interpretation,  Geometric Mean, Harmonic Mean

Comprehensively understand and apply various measures of central tendency to accurately summarize and interpret numerical data sets in business contexts. BTL 3: Applying
5 MEASURES OF DISPERSION :

Range Analysis, Quartile Deviation, Mean Deviation, Standard Deviation

Evaluate data variability through advanced techniques of measuring dispersion, enabling deeper insights into the spread and consistency of statistical data. BTL 5: Evaluating
6 MOMENTS, SKEWNESS, AND KURTOSIS:

Moments Concept, Skewness Analysis, Kurtosis Interpretation

Analyze the shape and characteristics of probability distributions to gain sophisticated understanding of data symmetry and peak concentration. BTL 4: Analyzing
7 CORRELATION ANALYSIS :

Correlation Concepts, Karl Pearson’s Coefficient of Correlation, Rank Correlation

Develop advanced skills in measuring and interpreting relationships between variables using correlation techniques to support evidence-based business decision-making. BTL 4: Analyzing
8 LINEAR REGRESSION ANALYSIS:

Regression Concepts, Regression Equations, Standard Error of Estimate

Create predictive models using regression analysis to forecast and understand relationships between variables in complex business scenarios. BTL 6: Creating
9 INDEX NUMBERS:

Concepts of Index Numbers, Types of Index Numbers, Construction Methods

Construct and interpret index numbers to track economic trends and comparative performance across different business dimensions. BTL 3: Applying
10 TIME SERIES ANALYSIS:

Time Series Components, Trend Analysis Methods, Seasonal Variations

Develop sophisticated techniques for analyzing temporal patterns, trends, and seasonal variations to support strategic business forecasting. BTL 5: Evaluating
11 PROBABILITY BASICS:

Probability Concepts, Probability Rules, Probability Approaches

Comprehensively understand and apply fundamental probability concepts to quantify uncertainty and support rational decision-making in business contexts. BTL 3: Applying
12 MATHEMATICAL EXPECTATION:

Expected Value Calculation, Variance Analysis

Calculate and interpret expected values and variance to assess and manage risk in complex business and economic scenarios. BTL 4: Analyzing
13 PROBABILITY DISTRIBUTIONS:

Binomial Distribution, Poisson Distribution, Normal Distribution

Analyze and apply different probability distributions to model and predict outcomes in various business and economic scenarios. BTL 4: Analyzing
14 STATISTICAL DECISION THEORY:

Decision Making Techniques, Decision Tree Analysis

Develop advanced decision-making skills by integrating statistical methods, probabilistic reasoning, and decision tree analysis to solve complex business problems. BTL 6: Creating
Textbook References:-

1.      Khandelwal, S. K. Business Statistics, International Book House Pvt. Ltd.

Other References:-

1.      Gujarati, D. N., & Porter, D. C. 2009. Basic Econometrics. McGraw-Hill.

2.      Black, K. 2019. Business Statistics: Contemporary Decision Making. Wiley.

3.      Lind, D. A., Marchal, W. G., &Wathen, S. A. 2017. Statistical Techniques in Business and Economics. McGraw-Hill.

4.      Anderson, D. R., Sweeney, D. J., & Williams, T. A. 2019. Statistics for Business and Economics. Cengage Learning.

(Bloom’s Taxonomy: BL 1: Remembering; BL 2: Understanding; BL 3: Applying; BL 4: Analyzing; BL 5: Evaluating; BL 6: Creating)

Macro Economics

Course Code: LBM0204 Course Title: Macro Economics (4 Credits)
Course Objectives: –

Ø  To understand the principles and scope of macroeconomics, including its theoretical and policy dimensions.

Ø  To analyze national income accounting methods and macroeconomic models to explain economic performance.

Ø  To evaluate the role of money, inflation, and unemployment in economic stability and growth.

Ø  To apply macroeconomic theories and policies to solve real-world economic problems.

Ø  To examine the international aspects of macroeconomics, including trade, exchange rates, and balance of payments.

                         Course Contents

Unit No. Unit Description Learning Outcome
1 Introduction to Macroeconomics:

Concept of Economics and Macroeconomics Origin and growth of macroeconomics, Importance of macroeconomics, Limitations of macroeconomics

Students will define macroeconomics, discuss its scope and importance, and identify its limitations. BTL1: Remembering, BTL2: Understanding
2 National Income Accounting:

Concepts of national income, Measures of national income parameters, Nominal and real GNP, Methods of measuring national income, Measurement of national income in India

Students will compute national income and critically analyze its significance in economic planning and evaluation. BTL3: Applying, BTL4: Analyzing
3 The Circular Flow Models:

Economy as a circular flow of products and incomes, Two-sector model, Three-sector model: Role of government, Four-sector model: Incorporating foreign trade

Students will explain and model the circular flow of income and expenditure in different economic systems. BTL2: Understanding, BTL3: Applying
4 Classical and Keynesian Theories:

Classical theory of output and employment, Say’s Law of Markets, Keynesian theory of income determination

Students will compare classical and Keynesian theories and assess their implications for economic policy. BTL4: Analyzing, BTL5: Evaluating
5 Investment Multiplier:

Investment multiplier and its mechanism, Static and dynamic multipliers, Applicability of multiplier in LDCs

Students will compute the investment multiplier and analyze its impact on aggregate demand and income. BTL3: Applying, BTL4: Analyzing
6 Money and Banking:

Definition and functions of money, Deposit creation by commercial banks, Theory of money supply

Students will describe the role of money and banking systems in economic activity and analyze their functions. BTL2: Understanding, BTL3: Applying
7 Inflation:

Meaning and measures of inflation, Types of inflation: demand-pull and cost-push, Social and economic effects of inflation, Policy measures to control inflation

Students will evaluate the causes and effects of inflation and recommend suitable control measures. BTL4: Analyzing, BTL5: Evaluating
8 Unemployment:

Definitions and types of unemployment, Phillips Curve and trade-off between inflation and unemployment, Policy dilemmas: Inflation vs. unemployment

Students will interpret unemployment trends and assess the trade-offs with inflation. BTL2: Understanding, BTL4: Analyzing
9 The IS-LM Model:

Interdependence of product and money markets, IS-LM model: Two-sector economy, Adjustments to equilibrium

Students will apply the IS-LM model to understand equilibrium in goods and money markets. BTL3: Applying, BTL4: Analyzing
10 Balance of Payments:

Meaning and Purpose of BOP, Causes of BOP disequilibrium, BOP Accounting system in India

Students will explain the balance of payments and evaluate strategies for addressing disequilibrium. BTL2: Understanding, BTL4: Analyzing
11 Exchange Rate Theories:

Concept of Exchange Rate, Market determination of exchange rates, Fixed vs. flexible exchange rates

Students will differentiate between exchange rate systems and assess their impacts on international trade. BTL3: Applying, BTL4: Analyzing
12 Economic Growth Theories:

Factors of economic growth, Harrod-Domar Model, Neo-Classical Growth Model

Students will assess various growth theories and apply them to analyze economic development. BTL3: Applying, BTL5: Evaluating
13 Fiscal Policy:

Scope and objectives of fiscal policy, fiscal policy and Macroeconomic Goals, Fiscal policy in India

Students will evaluate fiscal policy instruments and their effectiveness in achieving macroeconomic goals. BTL4: Analyzing, BTL5: Evaluating
14 Monetary Policy and Case studies of Zimbabwe Economy and Sri Lanka Economy:

Instruments of monetary policy, Limitations of monetary policy, Monetary policy in India

Students will analyze monetary policy’s effectiveness in regulating economic activity and controlling inflation. BTL3: Applying, BTL5: Evaluating
Textbook References:-

  1. Dwivedi, D.N., Macroeconomics: Theory and Policy. 4th Edition. McGraw-Hill Education.

Other References:-

  1. Mankiw, N. Gregory. Macroeconomics. 9th Edition. Worth Publishers.
  2. Blanchard, Olivier. Macroeconomics. 7th Edition. Pearson.
  3. Froyen, Richard T. Macroeconomics: Theories and Policies. 10th Edition. Pearson Education.

(Bloom’s Taxonomy: BL level 1: Remembering; BL level 2: Understanding; BL level 3: Applying; BL level 4: Analyzing; BL level 5: Evaluating; BL level 6: Creating)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Financial Management

Course Code: LBM0205 Course Title:Financial Management(4 Credits)
Course Objectives: –

Ø  To understand fundamental concepts of financial management and its role in business

Ø  To develop skills in financial analysis and planning

Ø  To master time value of money concepts and their applications

Ø  To understand working capital and capital structure basics

Ø  To learn fundamental investment and dividend decisions

      Course Contents

Unit No. Unit Description Learning Outcome
1 Introduction to Financial Management:

Role and scope of financial management, Goals of financial management, Functions of financial manager, objectives of Financial Management,Significance and Limitations of Financial Management

Students will understand and explain the fundamental concepts of financial management and its importance in business decisions. BTL 1: Remembering, BTL 2: Understanding
2 Time Value of Money:

Simple interest calculations, Compound interest basics, Present value concept, Future value concept, Annuities and their types ,  Using financial tables

Students will calculate and apply basic time value calculations in real-world scenarios. BTL 3: Applying, BTL 5: Evaluating
3 Financial Statements:

Meaning, Characteristics, Objective of Basic financial statements, Balance sheet components, Income statement analysis, Limitations of Financial statements,

Students will analyze and interpret basic financial statements. BTL 4: Analyzing
4 Ratio Analysis:

Ratio analysis fundamentals, Liquidity ratios, Profitability ratios, Activity ratios, Leverage Ratios, Investment Analysis Ratios

Students will analyze and interpret basic RatiosBTL 4: Analyzing, BTL 5: Evaluating
5  Break Even  Point BEPAnalysis:

Meaning, Objective of BEP Analysis, Methods of BEP analysis, Advantage and limitations of BEP Analysis

 

Students will analyzeBreakeven Point to solve real world problems.BTL 4: Analyzing, BTL 5: Evaluating
6 Working Capital Basics:

Concept of working capital, Working capital cycle, Management of working capital, Working capital policies

Students will understand working capital concepts and apply them to business scenarios. BTL 2: Understanding, BTL 3: Applying
7 Cash Management:

Meaning and Nature of cash, Motives of Holding cash, Cash management basics, Determination of Optimum level of cash, Cash collection techniques, Cash disbursement strategies, Cash budgeting basics

Students will apply cash management techniques and create cash budgets. BTL 3: Applying, BTL 6: Creating
8 Accounts Receivable and Inventory Management:

Credit and Collection Policies, Basics of inventory management, Inventory control techniques, Economic order quantity

Students will analyzecollection policies, inventory management techniques and evaluate their effectiveness. BTL 4: Analyzing, BTL 5: Evaluating
9 Sources of Finance:

Long-term sources, Short-term sources, Bank financing, Common Stock and its features

Students will analyze various sources of finance and evaluate their appropriateness for different business situations. BTL 4: Analyzing, BTL 5: Evaluating
10 Cost of Capital:

Concept of cost of capital, Cost of debt, Cost of equity basics, Weighted average cost of capital

Students will calculate cost of capital components and evaluate optimal capital structure decisions. BTL 3: Applying, BTL 5: Evaluating
11 Capital Budgeting:

Capital budgeting process, Payback period method, Net present value basics, Internal rate of return introduction

Students will evaluate investment proposals using various capital budgeting techniques and create investment recommendations. BTL 5: Evaluating, BTL 6: Creating
12 Capital Structure Basics:

Concept of capital structure, Operating leverage basics, Financial leverage introduction, Trading on equity

Students will analyze different capital structure options and evaluate their impact on firm value. BTL 4: Analyzing, BTL 5: Evaluating
13 Dividend Basics:

Concept of dividends, Types of dividend policies, Factors affecting dividend decisions, Stock dividends and splits

Students will evaluate dividend policies and create dividend strategy recommendations. BTL 5: Evaluating, BTL 6: Creating
14 Case Study:

Tesla’s Capital Structure Decisions

Background
Tesla Inc., the electric vehicle EV manufacturer, is known for its innovative approach to technology and financial management. Since its inception, Tesla faced challenges in balancing its capital structure to fund its aggressive growth strategies. The company relied heavily on external funding through debt and equity to expand its manufacturing capacity and invest in R&D for EVs and energy solutions.

Other Relevant Case studies from the Subject. .

The Tesla case study highlights how a strategic mix of debt and equity financing, operational efficiency, and investor confidence drives growth while managing financial risks.

Students also solve the other relevant cases from the subjectBTL 4: Analyzing, BTL 5: Evaluating

Textbook References:

1.      Van Horne, J.C., &Wachowicz, J.M., Fundamentals of Financial Management, Pearson Education.

2.      Maheshwari A., Gangopadhyay D.R., Chakrabarti A.N., Prasad P.S.R., Financial Management, Macmillan India.

3.      Shashi K Gupta,Sharma R.K ,Financial management, theory and Practice, Kalyani Publishers ,New Delhi

4.      AgarwalM.R.,Financial Management, Garima Publications, Jaipur

Other References:

1.      Brigham, E. F., & Houston, J. F. 2018. Fundamentals of Financial Management. Cengage Learning.

2.      Van Horne, J. C., &Wachowicz, J. M. 2008. Fundamentals of Financial Management. Pearson.

3.      Ross, S. A., Westerfield, R. W., & Jaffe, J. 2016. Corporate Finance. McGraw-Hill Education.

4.      Gitman, L. J., &Zutter, C. J. 2015. Principles of Managerial Finance. Pearson.

(Bloom’s Taxonomy: BT level 1: Remembering; BT level 2: Understanding; BT level 3: Applying; BT level 4: Analyzing; BT level 5: Evaluating; BT level 6: Creating)