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.
Syllabus · पाठ्यक्रम
1 subject · 4 chapters · 19 topics
01Lab 1: Advanced Excel and What-if Analysis
5 topics+
- 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 topics+
- 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 topics+
- 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 topics+
- Company creation and features (F11)
- Groups and ledgers
- Accounting vouchers: contra, payment, receipt, journal, sales, purchase
- GST setup and GST invoices
- Trial balance, profit and loss account and balance sheet reports
About this course
You will be able to
- 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
Who it is for
- 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
What you need
- Computer Fundamentals and Applications (Semester 1)
- Basic accounting knowledge
Online tests & result
Practice and unit tests online; marks and result show in your student login and at the centre.
Student login →
Questions
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.
