From

A.BABU RAO,
Lecturer in Commerce & Chairman-BOs (UG), VSU,
PRR & VS Govemment Degree College,
Vidavaluru.

To
The Regishar,

V.S.University,

Nellore -524003.

S ir,

Sub. : vSU, Nellore-Bos commerce Submission of revised syllabus for B.coM Honours (computer
Applications) Major (U.G)-Reg.

Under the subject Cited the B.O.S of Commerce (U.G) hand met on 27 -08-2023 at I0 AM in Online to revise
the syllabus for B.COM Honours (Computer Applications) Major for the Academic Year 2023-2024. I am
here with submitting the syllabus for B.COM Honours (Computer Applications) Major after the discussion of
the BoS by online, confirming the Rules and Regulations laid down by the A.p.S.c.H.E . The Revised
Syllabus along with Model Papers and signatures of
B.O.S members , are Enclosed here with for the
circulation among the colleges under thejurisdiction of V.S.U Nellore

Thanking you,

----a"iLr-
(A. BABU RAO)
(Chairman-B.O.S)

Mell.he$ Name of the Collese

(K.Srinivasulu) PRR & VS CDC, Vidavalur

(G.Ramanaiah) J.B. College, Kavali

fl yLJ,i
(M.V.L.Sailaja) S.K.R. GDC, Gudur.
A
P
s ANDHRA PRADESH STATE COUNCIL OF HIGHER EDUCATION
c
H
E
rffi: Programme: B.Com. Honours Computer Applications (Major)

w.c.f. AY 2023-24

COURSESTRUCTURE
Year Semester Course Title of the Course
No. of No, of
HrsA eek Credits
I Fundamental of Commerce 4 4
I
2 Business Organisation 4 4
Financial Accounting 3 J
I J
Financial Accounting Practical Course 2 I
II
Office Automation Tools 3 3
4
Office Automation Tools Practical Course 2 I
Advanced Accounting 3 J
5
Advanced Accounting Practical Coune 2 I
Income Tax 3 3
6
Income Tax Practical Course 2
lll I

E Commerce & Web designing 3 3

7
E Commerce & Web designing Practical Course 2 I

Digital Marketing 3 3
II 8
Digital Practical Course 2 I
torporate Accounting J
9
Corporate Accounting Practical Course 2 I

Cost & Management Accounting 3 3

IV l0
Cost & Management Accounting Practical Course 2 I

DBMS with Oracle 3 3

lt DBMS with Oracle Practical Course 2 I
Advanced Corporate Accounting (OR) Stock
Markets
l2 3 3
Advanced Corporate Accounting (OR) Stock
Markets Practical Course
Advertisement and Media Planning (OR) CST
3 3
Procedures and Practices
r3
Advertisement and Media Planning (OR) GST
2 I
Procedures Practices Practical Course
III
Business Analytics (OR) Cyber Law ., 3
l4 Business Anallics (OR) Cyber Law Practical
2 I
Course dgNh AoDDo D
Mobile Applications Developmeit (OR) [eal 1-rrne
3 .,
Governance S ystem (RTGS) r) Gr.ic^ ArurDcF
t5
Mobile Applications Development (OR) Real Time
2 I
Governance System (RTGS ) Practical Course
VI Semester Internship/Apprenticeship with l2 Credits
VII Courses will be available in due course oftime
IV
v t Courses will be available in due course oftime
 ---r*L"
(A. BABU RAO)
(Chairman-B.O.S)

it1itu,-*"{
(K.Srinivasulu)

(G. Ramanaiah)

lt v tt-s.;lg
(M.V.L Sailaja)
 SEMESTER-Irr
COURSD 5: ADVANCED ACCOUNTING

Theory Credits:3 3 hrs/week

Learning Objectives
The course aims to help Iearners to acquire conceptual
knowledge ofNon-profit organizations, understand
the accounting procedure of singre entry system,
hir" pr.chu.e.Iystem and partnership accounts.

Learning Outcomes:
At the end ofthe coursq the student will able to;
understand the concept ofNon-profit organizations
and its accounting process, comprehend the
of single-entry system and preparation of statement of affairs, concept
Familiaiiie with the legal formalities at the
time ofdissolution ofthe firm, Prepare financial
statements for partnership firmon dissolution ofthe
Emplov critical thinking skills to understand the difference firm
11d between the dissolution of the firm and
dissolution of partnership.

unit l: Accounting for Non Profit organizations: Non profit Entities-

Meaning - Features of Non-profit
Entities -Provisions as per sEC 8 - Accounting
Process- Preparation of Accounting Records -
and Payments Account- Income and Expenditure Receipts
Account - preparation of Balaice Sheet (including
problems).

unit 2: Single Entry system: Features

Disadvantages of Single Entry- Ascertainment
- Differences between singre Entry and Double
Entry _
of Profit and preparation of Statement of Affairs (including
Problems).

Unit 3: Hire Purchase System: Features

-Difference between Hire purchase and Installment purchase
Systems - Accounting Treatment in the Books
of Hire purchaser(including problems).

unit 4: Partnership Accounts-r: Meaning partnership Deed

-
Accounting Treatment of Goodwill Admission,
- Fixed and Fructuating capitars-
- Retirement of a partner (including probrems).

unit 5: Partnership Accounts-Ir: Dissolution of a partnership

Firm - Application of Gamer v/sMurray
Rule in India - Insolvency of partners (including problems).

Activities:
r Quiz Programs
o Problem Solving exercises
r Co-operative leaming
. Seminar
. Visit a single-entry firm, collect data and Creation
ofTrial Balance ofthe firm
o Visit Non-profit organization and collect financial
statements
o Critical analysis of rate of interest on hire purchase schemes
r Visit a partnership firm and collect partnership deed
o Debate on Gamer v/s Murray rule in India and outside India
o Group Discussions on problems relating to topics covered by syllabus
o Examinations (Scheduled and surprise tests) on all units
o Collect data from your college and prepare a Receipt and Payment Account, Income andExpenditure
Account and Balance Sheet

Reference Books:
t. Advanced Accountancy: T S Reddy and A Murthy by Margham publications.
2. Financial Accounting: SN Maheswari & SK Maheswari by Vikas Publications.
3. Principles and Practice of Accounting: R.L. Gupta & V.K. Gupta, Sultan Chand & Sons.
4. Advanced Accountancy: R.L.Gupta & Radhaswamy, Sultan Chand &Sons..
Advanced Accountancy : S.N.Maheshwari&V.L.Maheswari, Vikas publishers.
6. Advanced Accountancy: Dr. G. Yogeshwaran, Julia Allen - PBp publications.
7. Accountancy-Ill: Tulasian, Tata McGraw Hill Co.
8. Accountancy-III: S.P. Jain & K.L Narang, Kalyani Publishers.
9. Advanced Accounting (IPCC): D. G. Sharma, Tax Mann Publications.
10. Advanced Accounting: Prof B Amamadh, Seven Hills lntemational publishers.
ll. Advanced Accountancy: M Shrinivas& K Sreelatha Reddy, Himalaya publishers.
 Sf,MESTER-III
COURSE 5: ADVANCED ACCO

Practical Credits: I 2 hrs/week

Lab Exercise:

' Non Trading Concems - Creation ofCompany, Creation of Ledger Accounts,

creation ofAccounting
vouchers, and display of Income and Expenditure Account and Balance
Sheet using Accounting
Software / Package or in MS Excel.
. Hire Purchase Accounts - preparation of Statement of Affairs in MS-Excel
o Partnership Accounts - Creation ofCompany, Creation of Ledger Accounts,
Creation of Accounting
Vouchers, and Display of Concem Ledgers and Balance sheet using Accounting
Software / package
or in MS Excel.
. Single entry - Preparation of Statement of Affairs in MS-Excel

(A. BABU RAO)

(Chairman-B.O.S)
I6;*"{-
(K.Srinivasulu)

(C. Ramanaiah)

7t vr,*c;[g
(M.V.L Sailaja)
 SEMESTER-TII
COIJRSE 6: INCOME, TAX

Theory Credits:3 3 hrs/week

!4qqi!@:
At the end ofthe course, the student will able to;
> Acquirc the complete knowledge ofthe tax evasion, tax avoidance and tax planning.
> Understand the provisions and compute income tax for various sources.
> Grasp amendments made from time to time in Finance Act.
> Compute total income and define tax complicacies and structure.
> Prepare and File IT returns ofindividual at his own,

SYLLABUS:
UNIT-I: INTRODUCTION: Income Tax Act-1961 - Basic Conceps: Income, Person, Assessee - Assessment
Year. Previous Year, Rates of Tax, Agricultural Income, Residential Status of Individual - Incidence of Tax -
Incomes Exempt from Tax (Simple Problems).

UNIT-ll: INCOME FROM SALARIES: Basis of Charge, Tax Treatmenl of Different Types of Salaries
Allowances, Perquisites, Profits in Lieu of Salary, Deductions from Salary lncome, Computation of Salary lncome
(Simple problems).

UNIT-III : INCOME FROM HOUSE PROPERTY: Annual Value, Let-out/Self Occupied -Deductions from
Annual Value - Computation oflncome from House Property (Simple problems).

UNIT-IV: INCOME FROM BUSIN ESS AND PROFESSIO N: Definition ofBusiness and Profession-
Procedure for Computation oflncome from business and income from profession-Revenue And Capital
Nature of lncome and Expenses-Allowable Expenses-Expenses Especially Disallowed{Simple problems).

UNIT.V: INCOME FROM CAPITAL GAINS.INCOME FROM OTHER SOUR CESES.TOTAL INCOME :

Meaning of capital asset - types - procedure for computation oflong term and short-term capital gains/Losses (SEC
; 54,54b and 54fonly).
Meaning of Other Sources - General lncomes - Specific Incomes - Computation (lncluding problems). Deductions
under section 80 - Computation ofTotal Income, (simple Problems)

Activities:
. Seminar on different topics oflncome tax
o Quiz programs
o Problem Solving Exercises
. Debate on Tax Evasion and Avoidance
. Practice of provisions ofTaxation
o Visit a Tax firm
o Talk on Finance Bill at the time of Union Budget
. Guest lecture by Chartered Accountant
. Presentation oftax rates
 Practice offiling IT Retums online
Identifo and educate the individuals not having pAN card and help them to acquire
apAN
Card.
Filling out the online application for the pAN card and prepare the summarized reportfor
the
same.

Finding out Residential status ofany five NRI's from your area.
Identify and evaluate the tax liability of some individuals having income under differentheads
of
income.
Go through the e-filing website of the Govemment of India.

Reference Books:
L Dr. Vinod; K. Singhania; Direct Taxes Law and practice, Taxman publications
,) -
T. S. Reddy and Dr. Y. Hari prasad Reddy - Taxation by Margham publications
,
3. Premraj and Sreedhar, Income Tax, Hamsrala publications
4. B.B. Lal - Direct Taxes; Konark publications
5. Dr. Mehrotra and Dr. Goyal -Direct Taxes, Law and practice, Sahitya Bhavan publication.
6. Balachandran&Thothadri- Taxation Law and practice, pHI Leaming.
7. V.P. Gaur and D.B. Narang - Income Tax, Kalyani publications
8. Dr Y Kiranmayi - Taxation, Jai Bharath publishers
9. Income Tax, Seven Lecture Series, Himalaya publications
 SEMESTER-III
COIIRSE 6: INCOME TAX

Practical Credits: I 2 hrs/week

Lab Exercise:

. E Filing of Income Tax Retums Generation of IT Forms like ITR 01(SAHAJ), ITR 02, ITR 03, lrR
04' ITR 4s (suGAM), ITR 05 and ITR 06 and Register pAN, TAN, TIN, DN and GSTIN online
or
manual.
. Practical Exposure to www.incometaxindiaefiling.gov.in portal and file Return
Electronically on portal with or without Digital Signature Certificate.
. Pay Tax online through Net Banking and Generate Challans online and Manual.
. Form 16 B, How to view Tax credit through 2645 and E Filing TDS Salary Retum form24e and
Challan.

(A. BABU RAO)

(Chairman-B.O.S)

L
fr
(K.Srinivasulu)

(G. Ramanaiah)

fivt,*-e;lvn
(M.V.L Sailaja)
 SEMESTER-III
COIIRSE-7: E-COMMMERCE AND wEB DESIGNTNG
Theo redits:3 3 hrs/w

Course Objectives:
The course aims to help leamers to acquire conceptual knowledge of fundamental concept ofE- commerce
& Web Designing. Emphasize the importance of various E-commerce & Web Designing. Developing and
implementing effi cient algorithms.

Learning Outcomes:
The student will be able to
Explain how to create an e-commerce website from scratch, using PHP and the Bootstrap framework.
Display featured products corectly on a web page, using the bootstrap system. Explain how product
detail
models are programmed to be dynamic.

Unit I: Introduction:
Electronic commerce: Definition, types, advantages and disadvantages, E-commerce transaction on
World Wide Web Electronic Market-Online shopping, Three models of Electronic Market E-Business.
-
Unit-II: E-payment System:
Models and methods of e-payments (Debit Card, Credit Card), Digital Signatures (procedure, Working),
Payment Gateways, online Banking (Meaning, concepts, Importance), Advantages and Disadvantages
of
online Transactions

Unit-III: OnJine Business Transactions:

E-commerce Applications in various Indushies (Banking, Insurance, payment of Bills), Benefits,
Problems and Features, online Services (Financiat, Travel), online Leaming, online Shopping (Amazon,
Flipkart)

Unit-IV: Website Designing:

Introduction to Internet: Internet Terminotogy - History ofthe Intemet - Advantages & disadvantages
of Internet
Introduction to HTML: Basic HTML
- HTML document structure - HTML tags - head tag - titre tag - body tag -
Horizontal Rule Tag - paragraph tag - Text formatting tags - character entities

Unit V: Website Designing:

HTML Lists : Ordered List , Unordered List - Using colors
-Using Images
Hyperlinks: Textual links, Graphical links, tlpes of document links, anchor tag. HTML
Tables+able
creations tags, Nested Tables
References:
(l) E-commerce and E-business Himalaya publishers
(2) E-Commerce by Kenneth C Laudon, pEARSON INDIA
(3) Web
Pesign: Introductory with Mind Tap Jennifer T Campbell, Cengage India
(4) HTML & WEB DESIGN: TIPS & TECHNIQUES JAMSA, KRIS, McGTaw
HiII
(5) Fundamentals Of Web Development by Randy Connolly, fucardo Hoar, pearson
(6) HTML & CSS: COMPLETE REFERENCE PowELL,iHoMAS. McGTawHiII
 SEMESTER.III
COURSE-7: E-COMMMERCE AND WEB DESIGNING
Practical Credits:1 2 hrs/week

LIST OF EXPERIMENTS
l. create a web page to display a hyperlink which when clicked directs you to Amazon website.
2' create a web page to demonstrate your college name arigned with the logo ofyour
college.
3. Create a web page to demonstrate definition lists taking various applications
of e"or*".." u. un
example.
4' Create a web page which asks for mode of payment which includes the options:
Credit card/Debit
card/Online transfer (use radio buttons)
5 Create a web page which asks the user to enter his credit card details. Use textboxes,
drop down
buttons.
6 Create a web page to display definition list which defines the terms: B2B, B2C,
CZB, CZC.
7 create a web page which displays four buttons containing text B2B,Bzc, c2B,czc.Also
when a
button is clicked details about the clicked subject should appear on a separate page.
8 create a web page to display the text "Digital Marketing" which scroIs randomry.
9 create a web page to scroll the text 'E-Commerce" for exactly 5 times from leftio
right of the
screen.
10. create a web page to insert an image which when clicked redirects you to your
college website.
ll Create a web page to display the name of your college in h6 size with
blue as font color and
background color yellow separated by a thick line and below which a paragraph
about the facilities
offered by your college is described.
12. create a web page to demonstrate a pufl-down menu. The menu shourd contain
the list of your
favorite south Ind ian dishes.
r3. create a web page with name ofyour college as text. The text should
scroll, altemate and slide.
14. Create a web page to display an image surrounded by text on all the
four sides.
15. Create a web page to display 3 images which are aligned left,
right and center respectively.

*L-',
(A. BABU RAO)
(Chairman-B.O.S)
l
t.
liLr,,-*l--
(K.Srinivasulu)

(G. Ramanaiah)

ll vL*6.r- ls:
(M.V.L Sailaja)
 SEMESTER-III
COIJRSE-8: DIGITAL MARICTING \-,/"
Theory Credits: 3 3 hrs/week

Course Objectives:
The course aims to identify the impact ofdigital space and digital marketing in reaching out to customers.
Understand the importance of Search Engines and explain the working of Search Engines. Able to Define
email Marketing and have knowledge on how Social Media Marketingis to be used by marketers?

Learning Outcomes:
The Students will be able to:
Use digital media for the creation of products and services and relate Search Engines in the digital
marketing ecosystem. Use Search Engine Marketing for advertisements and know the Social Media
platforms like Face book, Twitter, YouTube & Linkedln for Marketing. Outline email Marketing and
strategy to craft email marketing campaign.
Unit-I: Introduction:- Fundamentals of Digital marketing & its significance, Traditional marketing V/s
Digital marketing, Evolution of digital marketing, digital marketing, digital markets in India, Role of
digital marketing in Indian economy.

UNIT-II: Social Media Marketing:

A new tool for Intemational Marketing, types ofsocial media ; face book marketing, YouTube marketing,
Twitter marketing ,lnstagram marketing, social media advertising.

IIMT-III: E-mail Marketing:

E-mail, Importance and Objectives of E-mail in marketing ,E-mail as a marketing strategy,

E-mail marketing as a process, E-mail marketing as a Business Idea.

IIMT-IV: Digital Marketing strategy in india:

Scope
.of digital marketing in India, Digital products, Digital marketing process, structure of digital
marketing, impact of digitalization in india, Emerging trends in digital markeiing strategies in lndia.

Unit-V: Digital customers:

Digital customer, Types and characteristics of digital customers , digital customer as a global Customer,
digital customer experience in world markets, digital trading, role of digital companies in digital
markets.

Text Books:
l. Digital Marketing by Seema Guptq McGraw Hill Education
2. Fundamentals ofDigital Marketing by Punit Singh Bhatia, pearson
References:
l. Basics of Digital Marketing - Course (swayam2.ac.in)

StrMESTER-III
COURSE-8: DIGITAL MARKETING

Practical Credits: I 2 hrs/week

LIST OF EXPERIMDNTS

l. Digital Marketing Implementation in Business Scenario

.,
Create the Digital Marketing Webpage
J. Conducting the Search Engine Optimization and Search Engine
Marketing
4. Using Google Analyics to anal;ze website performance
5. Creating Promotional banner through Canva
6. Face book Promotion using banners
7. Creating YouTube Channel for Marketing
8. Twitter Marketing
9. Instagram Marketing
t0 Email Marketing

----1"sL",-
(A. BABU RAO)
(Chairman-B.O.S)
I
t
q{a*".^^l*-*
(K.Srinivasulu)

(G. Ramanaiah)

tt vr'--e;15-
(M.V.L Sailaja)
 SEMESTER-IV
COURSE-9: CORPORATE ACCOUNTING v/-
Theory Credits: I 3 hrs/week

Learning Objectives:
This course enables the student to develop awareness about corporate accounting in conformity with the
provisions of company act.

Learning Outcomes:
At the end ofthe coursg the student will able to;
Understand the Accounting treatment of Share Capital and aware of process of book building,
Demonstrate the procedure for issue ofbonus shares, Comprehend the important provisions ofCompanies
Act, 2013 and prepare final accounts of a company with Adjustments, Participate in the preparation of
consolidated accounts for a corporate group Understand analysis of complex issues, formulation of well-
reasoned arguments and reaching better conclusions and Communicate accounting policy choices with
reference to relevant laws and accounting standards.

Unit l:
Accounting for Share Capital: Issue ofShares at Par, Discount and Premium - Forfeiture and
Reissue of Shares (including problems).

Unit 2: Issue and Redemption of Debentures and Issue of Bonus Shares: Accounting Treatment for
Debentures Issued and Repayable at Par, Discount and Premium -lssue of Bonus Shares (including
problems).

unit 3: valuation of Goodwitl: Need and Methods - Average profit Method, super profits Method -
Capitalization Method and Annuity Method (including problems).

Unit 4: Valuation Shares: Need for Valuation - Methods of Valuation - Net Assets Method, yield Basis
Method, Fair Value Method (including problems).

Unit 5: company Final Accounts: Provisions of the companies Act, 2013 - preparation of Final
Accounts- Profit and Loss Account Only (including problems with simple adjustments).

Activities:
r Problem Solving Exercises
. Collect and fill ofa limited Company
the share application form
. Collect Prospectus ofa company and identifu its salient features
 . Collect annual report ofa Company and List out its assets
and Liabilities.
' Collect the annual reports ofcompany and calculate the
value of goodwill under differentmethods
o Power point presentations on qpes ofshares and share
capital
. Group Discussions on problems relating to topics covered
by syllabus
. Students can gather the data relating to accounting
set up ofsome local firms.
' AssiSnments including techlical assignments like working
with Audit company forobservation and
submit to the teacher a Report.

' H'j[*:'rH"ject work on identified real time situarions with respect to preparation ofcompany
o On practical aspects dealt with by an Auditor.

Reference Books:
l. Corporate Accounting: T.S Reddy and Murthy, Margham publications,
Chennai.
2. Advanced Accounts: MC Shukla, T S Grewal an;
S C Gupta, S Chand publications
3. Corporate Accounting: Haneef & Mukherji, Tata McGraw publications.
Hill
4. Corporate Accounting: RL Gupta & Radha Swami, Sultan
Chand & sons
5. Corporate Accounting: p.C. Tulsian, S.Chand publishers
6. Advanced Accountancy: Jain and Narang,,Kalyani publishers
7. Advanced Accountancy: R.L. Gupta and M.Radhaswamy,
S Chand.
8. Advanced Accounrancy : Chakaborthy, Vikas publishers
9. Corporate Accounting: S.N. Maheswari, S.K. Maheswari, Vikas publishing
House.
10. Advanced Accounts: M.C. Shukla, T.S. Grewal, S.C. Cupta, S. Chand & Company
lt. Corporate Accounting: Umamaheswara Rao, Kalyani publishers
12. corporate Accounting: Dr chanda Srinivas, seven Hills Intemational publishers,
 SEMESTER.IV
COURSE-9: CORPORATE ACCOUNTING

Practical Credits: I 3 hrs/week

Lab Exercise:

Preparation of company Final Accounts, creation of company, creation of kdgers, creation of

Accounting Vouchers, Inventory Vouchers and display ofBalance Sheet.
Issue of Shares and Bonus Shares - creation of company, creation of Ledgers, creation of
Accounting Vouchers, and display ofconcemed Ledgers using Accounting Software / package or in
MS Excel. .
Issue and Redemption of Debenture - creation of company, creation of Ledgers, creation of
Accounting vouchers, and display of concerned Ledgers using Accounting Software / package or in
MS Excel.
Valuation of Shares - Valuation of shares and Calculation Consideration in MS-Excel

_._^3,,-
(A. BABU RAO)
(Chairman-B.O.S)

i rs^**r -
(K.Srinivasulu)

(C. Ramanaiah)

nvL--J.;u
(M.V.L Sailaja)
 SEMESTER-IV
COIIRSE-I0: COST & MANAGEMENT ACCOIINTING

Theory Credits: 3 3 hrs/week

Learning Objectives:
The aim ofthis course is to expose the students to the basic concepts and the tools used in cost accounting.

Learning 0utcomes:
At the end ofthe coursg the student will able to;
Understand various costing methods and management techniques, Apply cost and Management
accounting methods for both manufacturing and service industry, Prepare cost sheet to organization for
different works, Analyze cost-volume-profit techniques to determine optimal managerial decisions,
Compare and contrast the financial statements of firms and interpret the results and prepare analysis of
various special decisions, using relevant management techniques.

Unit 1: Introduction: Cost Accounting: Definition - Features - Objectives Management

-
Features - objectives - Functions - Elements ofcost - prepamtion ofcost shiet (including pro6lems)
Accounting:

Unit 2: Material and Labour Cost: Techniques of Inventory Control

- Valuation of Material Issues:
FIFO - LIFO Methods only. Labour - Direct and Indirect Labour Cost Methods of payment of Wages-
-
Incentive Schemes -Time Rate Method, piece Rate Method, Halsey, Rowan Methods only (including
problems).

Unit 3: Job Costing: Definition and Features of Job Costing -Preparation of Job Cost Sheet (includi ng
problems)

Unit 4: Financial Statement Analysis and Interpretation:

Process of Financial Statement Analysis- Comparative Analysis
- Common Size Analysis and Trend
Analysis (including problems).

Unit 5: Marginal Costing: Meaning of Marginal Costing - Contribution -profit Volume Ratio- Break
Even Point - Margin of Safety - Estimation of profit and Estimation of Sales (including problems).

Activities:
o Debate on methods ofpayments ofwages
o Seminars Problem Solving Exercises
. Seminar on need and importance offinancial statement analysis
. Graphs showing the breakeven point analysis
o ldentification ofelements ofcost in services sector by Visiting any service firm
. Cost estimation for the making ofa proposed product
o Listing of industries located in your area and methods ofcosting adopted by them
. Collection offinancial statements ofany two organization for two years and prepare acommon Size
Statements
o Collection ofcost sheet and pro-forma ofquotation
o Invited Lectures and presentations on related topics.
e Examinations (Scheduled and surprise tests)

Reference Books:
l. S.P. Jain and K.L. Narang - Advanced Cost Accounting, Kalyani Publishers.
2. M.N. Arora - A test book of Cost Accounting, Vikas Publishing House Pvt. Ltd.
3. S.P. lyengar - Cost Accounting, Sultan Chand & Sons.
4. Nigam & Sharma - Cost Accounting Principles and Applications, S.Chand& Sons.
5. S.N. Maheswari- Principles of Management Accounting, Sultan Chand & Sons.
6. LM.Pandey- Management Accounting, Vikas Publishing House Plt. Ltd.
7. Sharma & Shashi Gupta - Management Accounting, Kalyani Publishers.
8. Murthy & Guruswamy - Management Accounting, Tata Mccraw Hill, New Delhi.
9. S.P. Gupta - Management Accounting, S. Chand Publishing, New Delhi.
10. Umamaheswara Rao and Ranganath, Cost Accounting, Kalyani Publishers.
IL Dr V Murali Krishna - Cost Accounting, Seven Hills Intemational Publishers.
 SEMESTER-IV
COURSE-I0: COST & MANAGEMENT ACCOUNTIN

Practical Credits: I 2 hrs/week

Lab Exercise:
' Preparation of cost Sheet, preparation of FIFo and LIFo Stores ledgers, usingAccounting
Software / Package or in MS Excel.
o computation of probrems on Marginal costing, BEp and BEp chart in MS Excer.
Preparation of Profit and Loss Account in Contribution, Calculation ofBEp
' usingAccounting
Software / Package or in MS Excel.

' create cost centers; enable Godowns for Job costing, Inventory control method
using
Accounting Software / Package or in MS Excel.
. Calculation of
Labour cost in MS Excel
. Financial statement analysis like Trend Analysis, comparative statements and
commonsize
statements with using Accounting Software / package oi in MS Excel.

(A. BABU RAO)

(Chairman-B.O.S)
alu,-..,,.^,<*-
!

(K.Srinivasulu) -*
(G. Ramanaiah)

ft vt:--e;l7y
(M.V.L Sailaja)
 SEMESTER-IV
COURSE-II: DATABASE MANAGEMENT SYSTEM WITH ORACLE

Theorv Credits:3 3 hrs/week

Course Objectives:
The course aims to help the Students will have the expertise in analyzing real time problems and providing
appropriate solutions related to Computer Science & Engineering. The Students will have the knowledge
of fundamental principles and innovative technologies to succeed in higher studies and research. They
continue to leam and to adapt technology developments combined with deep awareness of ethical
responsibilities in profession.

Learning Outcomes:
An ability to apply Knowledge of computing and mathematics in Computer Science &Engineering. They
will analyze a problem, identifl and define the computing requirements appropriate to its solution. An
ability to design, implement and evaluate a computer-based system to meet desired needs with appropriate
societal considerations. The will have knowledge on to conduct investigations, interpret data and provide
conclusions in investigating complex problems related to Computer Science & Engineering. An ability to
engage in continuing professional development and lifeJong leaming.

Unit l: Overview of Database Systems: Introduction: Introduction to data, information, File based
system, Drawbacks of file based system, database, database management systems, Objectives of DBMS,
classification of Data Base Management Systems, Services ofDatabase System.

Unit 2: Relational Model: Advantages of DBMS, components of database system, Database users,
Introduction to relational model, Codd's rules, concept ofkeys, constraints (Domain, Entity, Referential)

Unit 3r Entity Relationship Model

Introduction, The Building Blocks of an Entity-Relationship, Classification of Entity Set, Attribute
Classification, Relationship Degree, Relationship Classification

Unit 4: BASIC SQL: SQL data types, SQL literals, operators, DDL operations (create, alter, drop), DML
operations (insert, delete, update), queries, aggregate functions, TCL operations: commit, Rollback,
Savepoint , DCL operations: Grant, Revoke

Unit 5: PL/SQL: Introduction, Structure of PUSQL program, Steps to Create a pUSeL program, Data
types of PL/SQL, PL/SQL operators, Control Structures: conditional control statements (if, if..else),
Iterative Control statements (while, do..while, for)

Sussested Text Books

a Database Management Systems, 3'dEdition, Raghurama Krishnan, Johannes Gehrke, TMH

SQL,PUSQLThe Programming language of ORACLE, MN Bayross,BPB Publications
 SEMESTER.IV
COURSE II: DATABASE MANAGEMENT SYSTEM WITH ORACLE
Practical Credits: I 2 hrs/week

LIST OF EXPERIMENTS

SQL:
Employee Datqbase
Aim: An enterprise wish€s to maintain a databas€ to automate its operations. Enterprir is divided into certain depanments
and
each department consists ofemployees, The following two tables desc be the automation schemas,

Emp(Empno, Ename, Job, Mgr, Hir€date, Sal, Comm, Deptno) Dept(Deptnq Dname, Loc)
l. List the details ofemployces who havejoined beforc the end ofSeptembcr 'gl.
2. List the name ofthe employee and designation ofthe employee, who does not repon to anybody.
3. List the name, salary and PF amount ofar the employees(pF is carcurated asr0o/oofsalary)
4. List the names ofemployees who are more than 2 years old in the organization.
5. Determine the number ofemployees, who are taking commission,
6. Update the €mployce salary by 20yqwhose experience is greater than 12 years.
7. Determine the department does not contain any employees.
8. create a view, which contains employee name and their manager names worl<ing in sales department.
9. Determine the employees, whose total salary is like the minimum salary ofany department.
10, List the department numbers and number ofemployees in each department.

PI /SOl. PROGRAMS
l. Writea PUSQL program to check the given sring is palindrome or not.
2. The HRD manager has decided to raise the employee salary by 15% urite a puseL block
to accept the employee
number and updatc the salary oflhat employee. Display appropriate messages based on
the existence ofihe record in the
Emp table.
3. write PLlsQL progmm to dispray the top I o rows in the Emp tabr€ based on their job and sarary.
a
4' wdte a PUSQL program to raise the employee salary by lo% for department number 30 people 8nd
also maintain the
raised details in the rais table.

(A'. BABU RAO)

(Chairman-B.O.S)

(K.Srinivasulu)

(G. Ramanaiah)

fi vL,_s;ld-
(M.V.L Sailaja)
 SEMESTER.V
Course 12 : ADVANCED CORPORATE ACCOUNTING

Theory Credits: 3 3 hrs/week

Learning Objectives
The course aims to help learners to acquire conceptual knowledge of purchase of business and
amalgamation of companies. They able to understand the accounting procedure of liquidation and
corporate accounting procedures.

Learning Outcomes
After completing the course, the student shall be able to:
Understand Corporate Accounting environment and record transactions related to Reconstruction of
companies operating functions of bank and insurance companies. Analyze the situations of Liquidation
and Intemal Reconstruction, Acquire skills of Accounting Procedure of Advanced Corporate Accounting
Environment.

Unit-l : BankAccounts:
Bank Accounts -
Books and Registers to be maintained by Banks - Banking Regulation Act, 1969 - kgal
Provisions Relating to preparation of profits and loss accounts wi0r schedules (From l3 to lQ Rebate on bills
discounted. (Including problems).

Unit 2 : Accounts oflnsurance Companies:

Life Insurance Companies -Preparation of Revenue Account LIC Act, 1956. With schedules from(
- I to
4)- valuation of balance sheet - correct life assurance fund including problems.

Unit 3: Internal Reconstruction of Companies : Meaning - Forms of Intemal Reconstruction -

Alteration of Share Capital and Reduction of Share Capital- Accounting Treatment.

Unit 4: Royalty Accounts: Meaning of royalty-lessee-lessor-minimum rent -short workings-recoupment

of short workings-Joumal entries and ledger accounts in the books oflessee only (including problems).

Unit 5: Liquidation: Meaning - Modes of winding up of a company-calculation of Liquidator's

Remuneration- Liquidator's Final Statement ofAccount (including problems).

Activities:
. Assignments including technical assignments like banks, Insurance companies Working with Audit
Company for Observation.
o Seminars, Conferences, discussions by inviting concemed institutions
r Field Visit
. Invited Lectures and presentations on related topics
Reference Books:
L Goyal, Bhushan Kumar. Corporate Accounting. Taxmann, New Delhi
2. Kumar, AIok. Corporate Accounting. Kitab Mahal
3. Monga, J. R. Fundamentals ofCorporate Accounting. Mayur paper Backs, New Delhi
4. Sah, Raj Kumar, Concept Building Approach to Corporate Accounting, Cengage
5. Sehgal Ashok & Sehgal Deepak. Corporate Accounting
6. Tulsian P. C. Corporate Accounting. S Chand & Co. New Delhi
7. https://thebookee.net/ad/advonced-corporate-accounting-and-accounting-standsrds
8. Web resources suggested by the Teacher concemed and the College Librarian includingreading
material

SEMESTER-V
Course 12 : ADVANCED CORPORATE ACCOUNTING

Practical Credits: I 2 hrs/week

Lab Exercise:
Preparation ofFinancial Statements ofCompanies before and after amalgamation withAccounting
Software
Preparation of Balance Sheet of companies before and after Intemal Reconstruction with
Accounting Software
Preparation of Consolidated Balance sheet of Holding and subsidiary companies using
Accounting Software
Preparation of Statement of Affairs-Deficiency Account-surplus Account of a Liquidating
Company in Microsoft Excel

(A. BABU RAO)

(Chairman-B.O.S)
\
(;"..*"(-
t
(K.Srinivasulu)

(G. Ramanaiah)

tt vt'--e;14-
(M.V.L Sailaja)
 SEMESTER-V
Course 12 : STOCK MARKETS *-,"
Theory Credits: 3 3 hrs/week
Lea ng ect rves:
The objective of this paper is to help students to acquire knowledge on concept of Financial Market and
ability to understand the terminologies associated with the field ofFinancial Market and control along with
their relevance. To impart awareness on Primary and Secondary Market, stock Exchange, SEBI etc.

Learning Outcomes:
By the completion of the course, the students will be able to
Expose to theory and functions of the Share Market in Financial Sector as job careers and 2. Study the
functioning of capital markets and create awareness among the public. Acquire knowledge on operations
of Share Market and Research skills and involve in activities of Mutual Funds and stock market firms.
Enhance their skills by practicing in preparation ofaccounting statements

Unit l:
Introduction': Nature, Scope and basics of stock market, Need of Investment-Short and Long
Term investment- Money market vs capital MarkerPrimary Market-Secondary Market - Types of
Investors- Speculators, Hedgers, Arbitragers.

unit 2: capital Markets: Definition, Participants of capital Market, pa(icipants of primary Market,
issuesof Equity Shares , Preference Shares and Debentures .Types of Mutual Funds. Secondary Market -
Stock Exchange - National Stock Exchange of India.

Unit 3: Financial Intermediaries: Depositories -Buy Back of Shares- Forward Contract and Future
Contract- differences -Participants in Future Contract- Clearing of Mechanism.

Unit 4: stock Indices: Index and its types-SENSEX- calculation Methodology-Types of Clearing
Members.

Unit 5: Regulatory Mechanism: Security and Exchange Board oflndia (SEBI)-Powers, functions - Over
the Counter Exchange (OTCE) of India-Functions and Mechanism.

Activities:
. Students shall individually study the work ofstock market professionals and agencies andmake
observations and Report to the teacher.
. Training ofstudents by a related field expert.
. Assignments (including technical assignments like identifuing the investors and theiractivities in
share markets
o Seminars, Conferences, discussions by inviting concemed institutions
. Visits to local Investment Institutions, offices,
 . Invited lectures and presentations on related topics by field experts.
Reference Books:
. I I.M.Pandey. ,Financial Management, Vikas publishing House
2. Prasanna Chandra, Fincial Management TaTa Mc Graw Hill
3. Bhole.L.M. Financiar Markets and Institutions, Tata McGraw Hilr pubrishing House
4. Khan MY,Jain PK, Financial Management, Tata McGraw Hill
5. Kishore Ravi.M., Financial Management, Taxman publication

SEMESTER.V /
Course 12 : STOCK MARKETS/
Practical Credits: I 2 hrs/week

Lab Exercise:

An Introduction. Practical aspects and background of Depositaries: NSDL, csDl.Statements:

Holding Statement, Transaction Statement. Dematerialization procedure
DEMAT: Account opening procedure, Nomination practices; offrine Demat Account
&online
Demat Account.

' Clearing & Settlement Procedure Delivery Instruction Slip Practices for
Depositaryparticipants &
Beneficial Owner.
o Introduction to Equity Market. Stock Exchanges of Equity in India: NSE,
&
BSE USE.Types of
Market:- Equity, Derivatives and Debt Market.

' Trader work Station -User Interface. practicar terminology of work stations.
o FunctionvKeys forrowing in using Trader work station: Market watch,
Activity Log,order
Status, Market Movement, Security descriptor, Market by price
o Practical Procedure to buy/Sell Shares; Settlement Procedures.
Composition of Sensexand Nifty.

Nole: The simulation Lab of the market will be based on any one of
the following Trader work station:
l.Trader work station-- NEsr rrader by owneys. 2.TCS Trader
work Station 3. oDIN

j-
A. BABU RAO)
(Chairman-B.O.S)
LU.@_-.
(K.Srinivasulu)

*-64 (G. Ramanaiah)

n v (,-r..;ld-
(M.V.L Sailaja)
 SEMESTER.Y
Course 13 : ADVERTISING & MEDIA PLANNING

Theorv Credits: 3 3 hrs/week

Learning Objectives:
The objective of this paper is to help students to acquire knowledge on advertising and mediaplanning and
to acquire skills in creating and developing advertisements.

Learning Outcomes:
At the successful completion ofthe course students are able to:
Understand the role of advertising in business environment and understand the legal and ethical issues in
advertising. Acquire skills in creating and developing adve(isements and understand up{o-date advances
in the current media industry. Acquire the necessary skills for planning and advertising media campaign.

unit l: Introduction: Advertising- Nature and Scope- Functions - Impact on Social, Ethical and
Economical Aspects - Its Significance - Advertising as a Marketing Tool and Process forpromotion of
Business Development - Criticism on advertising

Unit 2: Strategies of Advefiisements: Types of Advertising Agencies and their Strategies in Creating
Advertisements - Objectives - Approach - Campaigning Process - Role ofAdvertising Standard Council of
India (ASCI) - DAGMAR approach

Unit 3: Process of Advertisement: Creativeness and Communication of Advertising {reative Thinking

- Process - Appeals - Copy Writing - Issues in Creation of Copy Testing -Slogan Elements of Design and
Principles of Design

unit 4: Media Planning: Advertising Media - Role of Media - Types of Media - print Media - Elechonic
Media and other Media - Advantages and Disadvantages - Media planning - Selectionof Media.

Unit 5: Analysis of Market Media: Media Strategy - Market Analysis -Media Choices - Influencing
Factors - Target, Nature, Timing, Frequency, Languages and Geographical Issues - Case Studies

Activities:
. Students shall individually choose a local or regional advertising agency, visit, study it's processes,
strategies, business aspects etc. and has to submit his/her Report not exceeding l0 pages in the given
format to the teacher.
o Max marks for FieldworUProject work Report: 05.
. Unit tests (lE).
o Survey on existing products advertisements
o Creation ofadvertising on several products
. Invited Lectures
. Hands on experience with the helpoffield experts
o Debates, Seminars, Group Discussions, euiz, etc.
. Assignments, case studies, compilation ofpaper cuttings, preparation of related videos,class
exhibitions

Reference Books:
l. Bhatia. K.Tej - Adve(ising and Marketing in Rural India - Mc Millan India
2. Ghosal Subhash - Making of Advertising - Mc Millan India
3. Jeth waney Jaishri& Jain Shruti - Advertising Management - oxford university press
4. Advertising Media Planning, seventh Edition paperback
- by Roger Baron (Author), Jack
Sissors (Author)
5. Media Planning and Buying in 2l st Century Ronald DGeskey
-
6. Media Planning and Buying: principles and practice in the Indian context
- Arpita Menon
7. Publications of Indian Institute of Mass Communications
8. Advertising and Salesmanship. p. Saravanavel, Margham publications
9. Publications ofASCI
 SEMESTER-V
Course 13 : ADVERTISING & MEDIA pLANNItic-,/
Practical Credits: I 2 hrs/week

Lab Exercise:

o Creating an online advertisement using MS office or Computer tools.

o Selection of Product or Service - Target your competitors -creating Brand lmage - Develop a
theme with slogan - identifo core group - priorities message- Media Selection

' Creation of Advertisement using MS Word or the PPTCreation of Shorts and Videos in youTube
o Uploading Reels and Stories in Face book and instagram

(A. BABU RAO)

(Chairman-B.O.S)

I
(K,5flnrvasulu)

(G. Ramanaiah)

l'tvL-<{li
(M.V.L Sailaja)
 SEMESTER-V
Course 13 : GST PROCEDIIRES & PRACTICES

Theorv Credits:3 3 hrs/week

Learning Outcomes
After completing the course, the student shall be able to:
l. Understand the concept ofliability and Payment ofGST
2. Creale a new company in Tally with GST components and establish environment for GST
Voucher entry.
3. Comprehend the utilization ofinput tax credit, and the reverse charge mechanism in GST
4. Acquire Skills of preparation of GST Retums in accordance with GST Law and Tally
5. Acquire skill ofonline payment of GST through GST Portal.

unit l: Introduction: overview of GST - concepts -Taxes Subsumed under GST {omponentsof GST-
GST Council- Advantages of GST-GST Registration.

unit 2: GST - Accounting Masters and Inventory Masters in Tally : company creation- General
Ledgers & GST Ledgers Creation - Stock Groups , Stock ltems and Unit of Measure - GST Rate
Allocation to Stocks

Unit 3: GST Voucher Entry: GST Vouchers - Customizing the Existing Voucher types with applicable
GST Rates -Mapping of Input Tax Credit on Purchase Vouchers - Output Tax on Sales Vouchers-
Purchase and Sales Voucher Entries with Single Rated GST and Multiple Rated GST Goods.

Unit 4: GST Returns: Regular Monthly retums and Annual Retum- Retums for Composition Scheme-
Generation of Retums - GSTR-1, cSTR-2, cSTR-3, GSTR-4, GSTR-9, GSTR-3B

Unit 5: Payment of GST online: Payment of GST- Etectronic Filing of GST Retums - Refunds
- Penalties- Administrative structure of GST Officers- Powers- Jurisdiction.
Activities
. Seminars
. Practice of Terminology of Goods and Service Tax
. Prepare chart showing rates ofGST
o Follow GST Council meeting updates rcgularty
. Creation ofGST Vouchers and Tax invoices
o Visit a Tax firm (lndividual and Group)
. Guest lecture by GST official
. Prepare Tax invoice under the GST Act.
. Practice on how to file a Retums
o Debate on Single GS, Dual GST
. Group Discussions on Goods and Services outside the purview ofCST
References:
l. Ahuja Girish, Cupta Ravi, GST & Customs Law.
2. Babbar, Sonal, Kaur, Rasleen and Khuran4 Kritika. Goods and Service Tax (GST) and
Customs Law. Scholar Tech Press.
3. Bansal, K. M., GST & Customs Law, Taxmann Publication.
4. Singhania,Vinod K. and Singhania Monica. Students'guide to Income Tax. UniversityEdition.
Taxmann Publications Pvt Ltd.,New Delhi.
5. Sisodia Pushpendra, GST law, Bharat Law House.
6. lleb resources:https://cbic-gst.gov.in
7. Web resources suggested by the Teacher concemed and the College Librarian includingreading
material
 SEMESTER-V
Course 13 : GST PROCEDURES & PRACTICES

Practical Credits: I 2 hrs/week

Lab Exercise:

. Create Company and with CST and Create duty ledgers in the Tally
r Create stock item with GST and Sales and Purchases vouchers with GST in tally
. Reverse charge mechanism under GST and GST retums in Tally GSTR- l and GSTR-3B
. Registration ofdealer under GST, Regular dealer and Composite dealer
. GST retums for Composite dealer GST CMP48 and Annual return for composite dealerCSTR-4
e GST retums for Regular dealer GSTR-I and Reconciliation of GSTR2B, Actual input taxcredit as
per Books and Regular dealer GSTR -3B
. DRC 03-voluntary tax payments and Regular dealer Annual retums GSTR

(A. BABU RAO)

(Chairman-B.O.S)

tCttr,^-*,L
(K.Srinivasulu)

(C. Ramanaiah)

n vb--c.;ld-
(M.V.L Sailaja)
 SEMESTER.V
Course l4 : BUSINESS ANALYTICS

Theorv Credits:3 3 hrs/week

Course Objectives:

The course aims to help leamers to acquire knowledge on Business Analytics and explain why Business
Analltics is important. State some typical examples of Business Applications and differentiate between
OLAP and OLTP. Explain the concepts of Business Intelligence and understand different types of
Analyics Differentiate between Data Mining and Machine Leaming Concepts
Learning Outcomes:
At the end ofthe course, the student will able to;
. Understand the importance of Statistics in real life
o Formulate complete, concise, and correct mathematical proofs.
. Frame problems using multiple mathematical and statistical tools, measuring relationships by using
standard techniques.
. Build and assess data-based models.
. Leam and apply the statistical tools in day life.
. Create quantitative models to solve real world problems in appropriate contexts.

UMT 1: INTRODUCTION TO BUSINESS AIIIALYTICS:

Definition-Importance. types of business analltics methods-benefits of business statistics-Characteristics
and Limitations of Statistics -Classification and Tabulation - Frequency Distribution Table,primary daa
and secondary data

I,JNIT 2: DESCRIPTryE ANALYTICS:

Measures
9f Cqnlra] Tendency- Mean, Median, Mode only, Merits and demerits of Averages-Problems on
mean, median, Mode.

UNIT 3: DEScRIPTIvf, ANALYTICS MEASURES oF DISPERSION: Meaning and properties of

Dispersion - Qualities of Good measures of dispersion- Types of Dispersion- Meri'is and demerits of
Dispersion-Range - Quartile Deviation -Mean Deviation.

UNIT 4: SKEWNESS: Standard deviation and co-efficient of variation Measures of Skewness- Karl
Pearson's, Bowley's Co-efficient of skewness.

UMT 5: MEASURES oF RELATIoN: Meaning and use of correlation - Types of Correlation -

Karl Pearson's Corelation Coefficient -Spearman's Rank-Correlation (including problems)

ESTED READIN
l. Business Statistics, Reddy C.R., Deep Publications.
2. Statistical Methods: Gupta S.P.Sultan Chand & Sons.
3. Statistics-Problems and Solutions: Kapoor V.K, Sultan Chand &Sons.
4. Fundamentals ofStatistics: Elhance. D.N
5. Business Statistics, Dr.P.R.Vittal, Margham Publications
6. Business Statistics, LS Agarwal, Kalyani Publications.
7. Statistics: Dr V Murali Krishna" Seven Hills International Publishers.
8. Fundamentals of Statistics: Gupta S.C. Sultan Chand &Sons.
9. Statistics-Theory, Methods and Applications: Sancheti, D.C. & Kapoor V.K.
10. Business Statistics: J.K. Sharma, Vikas Publishers.
I l. Business Statistics: Bharat Jhunjhunwala, S Chand Publishers.
12. Business Statistics: SJlAggarvat, S.L.Bhardwaj and K.Raghuveer, Kalyani Publishers

SEMESTER-V
Course 14 : BUSINESS ANALYTICS

Practical its: I 2 hrs/week

LAB EXERCISE

l. To find Frequency Distribution Table for given individual data.

2. To find Mean for continuous frequency distribution.
3. To find Median and mode for given Discrete series.
4. To find Range and its co-efficient for given data.
5. To find Quartile deviation and its co-eflicient.
6. To find Mean Deviation and its co+fficient.
7. To find Standard Deviation and co-efficient ofvariation.
8. To find Karl-Pearson's and Bowley's Co-efficient ofSkewness.
9. To find Correlation for given data .
10. To find rank correlation for given data.
11. paper only.Questions should be covered in all units Equally
12.

(A. BABU RAO)

(Chairman-B.O.S)

L
(K.Srinivasulu)

(G. Ramanaiah)

ft vt,---e.;|4
(M.V.L Sailaja)
 SEMESTER.V
Course 14 : CYBER LAWS

Theory Credits: 3 3 hrs/week

Course Objectives:

r Enable leamers to understand, explore, and acquire a critical understanding ofCyber Law.
. Develop competencies for dealing with frauds and deceptions (confidence tricks, scams) and other
cyber-crimes for example, child pomography etc. that are taking place via the Intemet.
. Make learners conversant with the social and intellectual property issues emerging from
'Cyberspace'.
. Explore the legal and policy developments in various countries to regulate Cyberspace.
. Develop the understanding of relationship between commerce and cyberspace; and give leamers in
depth knowledge of lnformation Technology Act and legal frame work of Right to Privacy, Data
Security and Data Protection.

Learning Outcomes:

At the end ofthe course, students should be able to:

. Critically evaluate ongoing developments in law relating to information technologies.
o Display an understanding ofhow these developments relate to one another.
. Examine areas ofdoctrinal and political debate surrounding rules and theories;
o Evaluate those rules and theories in terms ofintemal coherence and practical outcomes.
o Draw on the analysis and evaluation contained in primary and secondary sources.
UNIT. I
Introduction: Computers and its Impact in Society, Overview ofComputer and Web Technology, Need for
Cyber Law, Cyber Jurisprudence at Intemational and Indian Level.

UNIT-II
Cyber Law - International Perspectives: UN &lntemational Telecommunication Union (lTU) Initiatives,
Asia-Pacific Economic Cooperation(APEC), Organization for Economic Co-operation and
Development(OECD), World Bank, Commonwealth of Nations.

UNIT.III
Constitutional & Human Rights Issues in Cyberspace: Freedom of Speech and Expression in Cybenpace,
Right to Access Cyberspace - Access to lntemet, Right to Privacy, Right to Data Protection.

UNIT.IV
Cyber Crimes & Legal Framework: Cyber Crimes against Individuals, Hacking, Digital Forgery, Cyber
Stalking/Harassment, Cyber Pomography, Identity Theft & Fraud, Cyber terrorism, Cyber Defamation,
Different o{Iences under IT Act, 2000.

UNIT.V
Cyber Torts: Different Types ofCivil Wrong sunder the lT Act, 2000, Intellectual Property lssues in Cyber
Space, Interface with Copyright Law, Interface with Patent Law, Trade marks & Domain Names Related issues
Text Book:
l. Justice Yatindra Singh, Cyber Laws, Universal Law Publishing Co, New Delhi, (2012).

Reference Books:
2. Chris Reed & John Angel, Computer Law, OUP, Newyork,(2007).
3. verma K, Mittal Raman, Legal Dimensions of cyber Space, Indian Law Institute, NewDelhi,(2004)
4. Jonthan Rosenoer, Cyber Law, Springer, New york, ( 1997).
5. SudhirNaib, The Information Technolog Act,2005: A Hand book, OUp, Newyork, (201 l)
6. S.R.Bhansali, Information Technology Act 2000, university Book House pvt. Ltd., Jaipur (2003).
7. vasu Deva, Cyber crimes and Law Enforcement, common wealth publishen, New Delhi,(2003).
 SEMESTER-V
COURSE 14: CYBER LAWS
Practical

LIST OF EXPERIMENTS:

1 Write a report on Impact of computers in Society

2. Write a report on need for cyber law
3. Write a report on cyber crime
4. Write case study on APEC
5. Write case srudy on Cyber space
6. Write a report for Cyber crimes on Individuals
7. Write a report on Cyber defamation
8. Write case study on trade marks

(A. BABU RAO)

(Chairman-B.O.S)
I
t C[U,**l
(K.Srinivasulu)

(G. Ramanaiah)

tl vt,
(M.V.L Sailaja)
 *
C
\^r
SEMESTER-V k\ L
^
COURSE 15: MOBILE APPLICATON DEVELOPMENT USING AI\IDROID

Theory Credits: 3 3 hrs/week

Course Objectives:
The course aims to help leamers to acquire conceptual knowledge of understanding
Android SDK . To
help students to gain a basic understanding of Android application development
and instill working
knowledge ofthe Android Studio development tool

Course Outcomes:

The student will be able to:

Identify various concepts and features of Android operating system. Configure Android
environment and
development tools. Develop rich user lnterfaces by using layouts and
controls. Use User lnterface
components for android application development. Create Android application
using database. publish
Android applications.

Unit l: Introduction to Android: -

Introduction to Android, open headset alliance, Android Ecosystem, Need
ofAndroid, Features ofAndroid,
Tools and software required for developing an Application, Android architecture

Unit 2: Android Application Design Essentials:

Operating system, Android SDK, Android development tools, Android virtual devices,
steps to install and
configure Android studio and SDK

Unit 3: Android User Interface Design Essentials:

control flow' Directory structure, components ofa screen, fundamental UI design,
linear layout, absolute
layout , table layout, rerative layout, text view, edit text button, image button,
, ijio uutton, ioggi" lutr-.
Unit 4: Testing Android applications:
Radio group, check box' list view' image view, scroll view, time and
date picker, Android platform services,
Android system Architecture' Android Security model, Applications, develoiment:
creatingli,uii afptication
Unit 5: Using Common Android ApIs:
Introduction of MIT App Inventor, Apprication coding, programming
Application, Audio & Video, Drawing Application, DevicJocati-on, Web
Basics & Diarog Ararm clock
Browsers

REFERENCE BOOKS:
l. Reto Meier, "Professional Android 2 Apprication Development,', wirey India pl.t Ltd
L Murphy, "Beginning Android",Wiley lndia pvt itd
?.
3. Y*k
Erik Hellman, "Android programming pushing the Limis,,, l st
Edition, wirey India prt Lrd, 20r 4.
4. App Inventor: create your own Android- apps U! WolUer, David (David W"yrJl;:nraioia epplication
Development AII in one for Dummies', by-Barry Burd, Edition: I ,

5. "Android", Dixit, Prasanna Kumar vikas publications, New Delhi 2014, ISBN: g7gg32s977gg4
6. " Android Programming for Beginners" by Hortan, John, packet publication, 20lSISBN: 97g-l -
78588-326-2
7. Lauren Darcey and Shane Conder, "Android Wireless Application Development",Pearson Education,
2nd ed. (201 l)

ONLINE READNG / SUPPORTING MATERIAL:

L htto://www.developer.android.com
2. hfto://develoner.android.com/about/versions/index.html
3. http://developer.android.com/traininey'basics/firstapp/index.html
4' http://docs.oracle.com/javase/tutorial/index.htm (Available in the form of free downloadable ebooks
also).
5. id
6.
7. id fi
8. hhp://developer.android.com/trai ning/multiscreen/screensizes.htm I Syllabus of BCA (Honours)
under CBCS 33 9. http ://deve looer.android.com/ suide/tooicVui/co s.html
I http://developer .android.com/guide/topics/ui/declaring-layout.html
10. http://developer .android.com/training/basics/data-storage/databases.html
 UN'TL
c
SEMESTER-V Ir t\z
COURSE 15: MOBILE APPLICATON DEVELOPMENT USING ANDROID

Practical Credits: I 2 hrs/week

LIST OF EXPERIMENTS:

l. Develop a program to implement frame layout, table layout and relative layout.
2. Develop a program to implement Text View and Edit Text,
3. Develop a program to implement Auto Complete Text View.
4. Develop a program to implement Button, Image Button and Toggle Button.
5. Develop a program to implement login window using the above Ul controls.
6. Develop a program to implement Checkbox.
7. Develop a program to implement Radio Button and Radio Group.
8. Develop a program to implement Progress Bar.
9. Develop a program to implement List View, Grid View, Image View and Scroll View.
10. Develop a program to implement Custom Toast Alert.
I l. Develop a program to implement Date and Time Picker.
t2. Develop a program to implement content provider.
13. Develop a program to implement service.
14. Develop a program to implement broadcast receiver.
15. Develop a program to implement sensors.

(A. BABU RAO)

(Chairman-B.O.S)
Ltta^-*,(
(K.Srinivasulu)

(G. F.amanaiah)

ttvt -s.;ly
(M.v.L Sailaja)
 SEMESTER.V
COURSE 15: REAL TIME GOYERNANCE SYSTEM (RTGS)
Theo rv its: 3 3 week

Learning outcomes:

Upon successful completion of this course, students will have the knowledge and skills to
l. Undentand the terms regarding Govemance, E-Govemance and RTGS
2. Learn about E-Govemance Infrastructure
3. Understand the E-Govemance implementation in several countries
4. Understand the E-Govemance implementation in several Indian states
5. Understand the applications ofRTG

UNIT l: Introduction to E-Governance

* Government, Covemance and Good Govemance
.i. What is E-Governance or Electronic Governance?
.:. E-Govemment and E-Governance: A conceptual Analysis
D Objectives, Components, application domains, four phase model
D implementing E4ovemance, issues while implementing E-Govemance
I Opportunities and challenges
* TypresofE-Governance
* What is Real-Time Governance (RTG)
* Real Time Governance Society (RTGS)

UNIT 2: E-Governance Infrastructure

l. Data Systems infrastructure
a. Executive Information Systems b. Management lnformation Systems
c. Knowledge Management Systems
2. Legal I nfrastructuml preparedness
a. IT Act 2000 b. Challenges to Indian law and cybercrime scenario in India
3. Human Infrastructural preparedness
a. TopJevel management b. MiddleJevel management c. LowJevel management
d. Human Resource Management System

UNIT 3: E-Governance: Country Experi€nce

I. INDIA 2. US 3. UK 4. AUSTRALI.A 5. NEW ZELAND 6. DUBAI

UNIT 4: E-Governance in India

l. Andhra Pradesh 2. Telangana 3. Karnataka 4. Kerala
5. Uttar Pradesh 6. West Bengal 7. Gujarat

UNIT 5: Latest Applications in Real Time Governance

a. Agriculture b. Rural Development c. Health care
d. Education e. Tourism f. Commerce and Trade

Textbooks:
L E-Govemance: concepts and case studiesl CSR Prabhul prentice-Halll
2. E-Covemancel Niranjanpani, Sanhari Mishra I Himalaya publishing House
Website References:
L http://www.egov4dev.org/success/case/
2. https ://vikaspedia. in/e-govemance/resources-for-vles
3. https://altametrics.com,/en/information-systemVinformation-system_types.html
4. https://core.ap.gov.in/CMDashBoard./lndex.aspx

SEMESTER.V
COURSE 15: REAL TIME GOVERNANCE SYSTEM (RTGS)
-,'-
ical Cred

LIST OF EXPERIMENTS
Note:
Here the students have to gather the details intomputer lab by surfing several
websites & Google search
engines and submit the report to the class/lab instructor before leavin! the lab.

l. Write a Report on the role of Nationwide Networking in E-Govemance

2' Write a Repo( on SETU: A Citizen Facilitation Centre in India, regarding
its successful or failure
journey.
3. write a Report on Nationar cyber Security poricy, how it is useful to Indian citizens.
4' Write a Report on mee-seva/Village Secretariat/ward secretariat, a new paradigm
in citizen services.
5 write a Report on any "state Data centre (SDC)": Regarding the features, key applications,
etc.
6. Write a Report on how Andhra pradesh is implementing RTGS in Agriculture.
T write a Report on how Andhra pradesh is imprementing RTGS in sociar welfare
schemes
8 Write a Report on how Andhra Pradesh is implementing RTGS in waste
lands, agricultural lands and
house properties.
9. write a Report on Electronic Birth Registration in any of the four states of
our country.
10. write a detailed report on "types of e-govemance" with rear-life imprementation
in India with
suitable examples.

A.P
(A. BABU RAO)
(Chairman-B.O.S)
I
),iJ,,-*..1.
(K.Srinivasulu)

(G. Ramanaiah)

tt vt"-<;ld-
(M.V.L Sailaja)