Your roadmap · आपका रोडमैप
- 1
Admission & first meetingप्रवेश और पहली मुलाकातEnquire at your nearest NDSS centre, meet the teacher, fix the batch time and get your study material.
- 2
Part 1 of the syllabusपाठ्यक्रम भाग 1Unit-wise coaching with notes and doubt classes.
Lab 1: Advanced Excel and What-if AnalysisLab 2: Excel for Finance
- 3
Part 2 of the syllabusपाठ्यक्रम भाग 2Unit-wise coaching with notes and doubt classes.
Lab 3: Database ManagementLab 4: Accounting with Tally Prime
- 4
Unit tests & assignmentsयूनिट टेस्टRegular tests in the university / board pattern.
- 5
Semester 3 exam (university / board)विश्वविद्यालय / बोर्ड परीक्षाPrevious papers and full revision before the exam.
- 6
Online tests & resultऑनलाइन टेस्ट और रिज़ल्टTake the tests online; your marks and result show in your student login and at the centre.
सिलेबस · पाठ्यक्रम
1 subject · 4 chapters · 19 topics
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
About this course
आप यह कर पाएँगे
- 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)
- अकाउंटिंग का बेसिक ज्ञान
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
सवाल
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.
