Inventory application
Deliverable: A Python program backed by a MySQL database that adds, searches and reports on stock, with input validation that survives a user trying to break it.
Course
ADCA (Advanced Diploma in Computer Application)
The advanced diploma that follows the basics — programming, databases, accounting and design taught together, so you leave able to do skilled work rather than only office work.
- Duration: 12 months
- Classroom · Online live
- Level: beginner to advanced
What you will be able to do
- Write and debug programs that solve a defined problem end to end
- Design a relational database and retrieve data from it with SQL
- Maintain a complete set of books in Tally including GST entries
- Produce print-ready design work in Photoshop and CorelDraw
- Build and publish a responsive website
- Assemble a portfolio that demonstrates each of these separately
Who this course is for
- Class 12 pass from any stream
- Anyone who has completed DCA or an equivalent foundation course
- Working adults moving from clerical work into skilled computer roles
- Comfortable using a computer, though no programming is assumed
Syllabus
8 modules · 12 months
Module 1. Foundations refresher and operating systems
- Hardware, operating systems and file management at speed
- Networks and how the internet delivers a page
- Software installation, drivers and troubleshooting
- Security, backups and safe practice
Module 2. Advanced office and documentation
- Long documents, styles and automated references
- Advanced spreadsheet functions and lookups
- PivotTables, charts and dashboards
- Report and presentation standards
Module 3. Programming with Python
- Variables, control flow and functions
- Collections, files and external data
- Error handling and defensive input
- Object-oriented programming and structuring a larger script
Module 4. Databases and SQL
- Tables, keys and normalisation
- SELECT, joins and aggregation
- Inserts, updates and referential integrity
- Connecting a database to a program
Module 5. Accounting with Tally and GST
- Company setup, ledgers and voucher types
- Inventory, stock groups and godowns
- GST configuration and return data
- Finalisation and reading the reports
Module 6. Graphic design
- Raster and vector, and when each is right
- Photoshop for image editing and composition
- CorelDraw for layout, logos and print
- Colour modes, bleed and preparing a file for print
Module 7. Web development
- HTML structure and semantics
- CSS layout, responsive design and type
- JavaScript fundamentals and interactivity
- Publishing to a live URL
Module 8. Portfolio and interview preparation
- Choosing which work to show and which to leave out
- Writing up a project so a stranger understands it
- CV structure for skilled computer roles
- Mock interviews with recorded feedback
Tools and technologies you will use
- Python
- MySQL
- Tally Prime
- Adobe Photoshop
- CorelDraw
- HTML, CSS and JavaScript
Projects you will build
A closed set of books
Deliverable: A full simulated quarter in Tally including GST entries, closed out to a trial balance and profit and loss statement you can explain line by line.
Print-ready design set
Deliverable: A logo, a business card and an A4 flyer produced in CorelDraw and Photoshop, exported to print specification with correct colour mode and bleed.
Published responsive website
Deliverable: A multi-page site that works on a phone as well as a laptop, published to a public URL and linked from your portfolio.
Where this course can take you
- Computer Operator
- Junior Programmer
- Accounts Assistant
- Graphic Design Assistant
- MIS Assistant
Duration, modes and fees
- Duration
- 12 months
- Delivery modes
- Classroom · Online live
- Fees
- Share your details for the current fee
- Fees vary by batch and delivery mode. Ask about the instalment options available for the twelve-month diplomas.
Placement assistance
Every student gets placement assistance — that is what 100% placement assistance means. It is support for all, not a job for all. We do not promise a specific salary, a specific number of interviews, or placement at any named company, and you should be wary of anyone who does.
What is included
- A place in the monthly placement drive, held every third Saturday
- The readiness programme every second Saturday — mock interviews and preparation
- CV review against the specific roles you are targeting
- Portfolio review, so your project work is presented the way a reviewer will read it
- Access to the vacancy pool employers send directly to the Samyak network
- Guidance on which roles realistically fit your background and which do not
- A place in the next drive, with coaching, if you are not selected in this one
What is not included
- Any guarantee of a job, an interview, or a particular salary
- Placement at a named or partner company
- Applying to jobs on your behalf
- Support before you have completed the course and its project work
- Visa, relocation or overseas placement assistance
Four skills, four pieces of evidence
The honest criticism of any advanced diploma is that it teaches a little of everything and not enough of anything.
The answer here is that each of the four strands ends in something finished: an inventory application backed by a real database, a quarter of books closed in Tally, a print-ready design set, and a responsive site on a live URL. Four separate things you can put in front of four different kinds of employer.
Breadth with nothing to show would deserve the criticism. Breadth with four finished pieces is simply a wider set of doors.
How it differs from DCA
DCA assumes nothing and spends the year building foundations properly. ADCA moves through those foundations in the first two modules and spends the remaining ten on skilled work — programming, database design, GST accounting and design for print.
If you have never used a computer, start with DCA; arriving here without those foundations makes the middle of the year unpleasant. If you already work comfortably on a machine, DCA will bore you and this is the right entry point.
The point of the last module
You will finish with more work than you should show.
The final module is about choosing — which two projects actually demonstrate something, how to write them up so a stranger understands them without you in the room, and how to answer the follow-up question. It ends in recorded mock interviews, because hearing yourself explain your own project badly once is worth more than being told about it three times.
What it is not
It is an institute diploma, not a government certification, and not a degree.
It will not on its own make you a specialist in any of the four areas. What it does is show you which one you want to be a specialist in, with enough real work behind each to make that judgement honestly rather than from a description.
Questions
ADCA (Advanced Diploma in Computer Application) — frequently asked questions
Should I take DCA or ADCA?
If you are starting from little or no computer experience, take DCA — it builds the foundations at a pace that assumes nothing. ADCA moves faster through those foundations and spends the year on programming, databases, accounting and design instead. If you already use a computer comfortably, start here.
Is ADCA too broad to be useful?
It is broad on purpose, and that is a fair question to ask. The answer is the portfolio — you leave with a working application, a closed set of books, a print-ready design set and a live website, each demonstrating a different skill. Breadth without finished work would be a valid criticism; breadth with four separate pieces of evidence is a wider set of doors.
Who issues the ADCA certificate?
It is an institute diploma issued by Samyak and recognised across our network. It is not a government certification. If an application you are targeting specifically requires a government-issued certificate, look at CCC or the NIELIT O Level and bring the notification in so we can read it with you.
Can I specialise afterwards?
Yes, and most people should. ADCA is designed to show you which of the four areas you actually enjoy, and then you go deeper — full stack development, data analytics, graphic design or Tally with GST. Tell us which part you liked most and we will name the one course that follows it best.
Do I need my own laptop?
Not for the classroom batches — systems are provided and lab time is part of every session. You will get further if you can practise at home, particularly on the programming and design modules, but nobody is excluded for not having a machine.
Enquire about ADCA (Advanced Diploma in Computer Application)
Three details is all we need. A course advisor will call you back.
Related courses
- DCA (Diploma in Computer Application)
The standard entry diploma for office and computer work — fundamentals, Office, accounting basics and the internet, taught as practical work rather than as a syllabus to memorise.
- Python Programming
Python taught as a working tool rather than a syntax tour — you finish able to read unfamiliar code, automate real tasks, call APIs and write tests that catch your own mistakes.
- Tally Prime with GST
Tally Prime taught through a full simulated financial year — vouchers, inventory, GST, TDS and payroll — so you finish having actually kept a set of books, not just clicked through menus.
- Graphic Design
Design principles first and software second, because employers hire for typography and layout judgement — the tools are learnable in weeks and the judgement is not.
Next step
Talk to a course advisor
Tell us what you want to learn and we will help you pick the right course, batch and mode.