Computer Applications in Management (BBA)

Practical use of spreadsheets, databases and accounting software for management tasks.

6 महीनेअवधि 4Chapters19टॉपिक

अभी पूछताछ करें

सिलेबस · पाठ्यक्रम

Download PDF

01Lab 1: Advanced Excel and What-if Analysis 5 टॉपिक

IF, nested IF, COUNTIFS, SUMIFS
VLOOKUP / XLOOKUP and INDEX-MATCH
Pivot tables and pivot charts
Goal Seek, Scenario Manager and Data Tables
Simple sales dashboard

02Lab 2: Excel for Finance 4 टॉपिक

PMT for EMI and loan schedule
FV and PV
NPV and IRR for project appraisal
Depreciation functions SLN and DB

03Lab 3: Database Management 5 टॉपिक

Database concepts and MS Access
Tables, fields, data types and primary key
Relationships between tables
Queries, forms and reports
Basic SQL: SELECT, WHERE, ORDER BY

04Lab 4: Accounting with Tally Prime 5 टॉपिक

Company creation and features (F11)
Groups और ledgers
Accounting vouchers: contra, payment, receipt, journal, sales, purchase
GST सेटअप और GST इनवॉइस
Trial balance, profit and loss account and balance sheet reports

परिचय

आप यह कर पाएँगे

Analyse business data in Excel using functions, pivot tables and what-if tools
Calculate EMI, NPV and IRR with Excel financial functions
Design a simple database with tables, keys, queries and reports
Maintain accounts with GST in Tally Prime and generate financial reports
Present management information clearly with charts and dashboards

यह किसके लिए है

BBA students of Semester 3 in UP state universities and affiliated colleges (Lucknow University pattern)
Students who want job-ready Excel and Tally skills for office and accounts work

आपको क्या चाहिए

Computer Fundamentals and Applications (Semester 1)
अकाउंटिंग का बेसिक ज्ञान

सवाल

Which syllabus does the course follow?

The common UP state university BBA syllabus for Computer Applications in Management (Semester 3, Lucknow University pattern). The centre follows the student's own university syllabus (Lucknow University, MGKVP, VBSPU, CSJMU or any other) where it differs.

How are classes conducted?

Unit-wise lectures with examples from Indian business, short notes, numerical practice where needed and MCQ tests.

Which software is used?

MS Excel, MS Access (or LibreOffice Base) and Tally Prime educational version are used in the lab.

Are previous year questions covered?

Yes, previous university questions are solved unit-wise before the semester examination.