Courses Offered

Creating a syllabus for a 6-month Advanced Diploma in Computer Application (ADCA) course requires a comprehensive approach, covering various essential aspects of computer applications. The course should be structured in a way that caters to both theoretical knowledge and practical skills. Here’s a suggested outline:

Month 1-2: Fundamental Concepts and Basic Applications

Week 1-2:

• Introduction to Computers
• Overview of Computer Systems
• Basics of Hardware and Software
• Understanding Operating Systems (Windows, Linux, etc.)
• Basic Troubleshooting

Week 3-4:

• Introduction to Internet and Email
• Basics of Internet, Browsers
• Search Engines and Information Retrieval
• Email: Creating, Sending, Receiving, Email Etiquette

Week 5-6:

• Microsoft Office Basics
• Introduction to Microsoft Word: Basic Document Creation, Formatting
• Introduction to Microsoft Excel: Spreadsheets, Basic Formulas, and Functions
• Introduction to Microsoft PowerPoint: Creating Basic Presentations

Week 7-8:

• Basic Computer Networking
• Understanding LAN, WAN, Internet
• Basics of Wi-Fi and Bluetooth Technology

Month 3-4: Intermediate Skills and Applications

Week 9-10:

• Advanced Microsoft Office
• Advanced Word: Mail Merge, Templates
• Advanced Excel: Charts, Advanced Formulas, PivotTables
• Advanced PowerPoint: Animations, Transitions, Advanced Presentation Techniques

Week 11-12:

• Introduction to Graphic Design
• Basics of Graphic Designing using Adobe Photoshop or equivalent
• Creating Simple Graphics, Image Editing

Week 13-14:

• Web Technologies
• HTML Basics
• Introduction to CSS
• Basic Web Page Design

Week 15-16:

• Introduction to Programming
• Understanding Algorithms and Flowcharts
• Basics of a Programming Language (like Python or Java)

Month 5-6: Advanced Topics and Project Work

Week 17-18:

• Database Management
• Basics of Database Concepts
• Introduction to SQL and Database Operations

Week 19-20:

• Introduction to E-Commerce
• Understanding E-Commerce Platforms
• Basics of Online Transactions and Security

Week 21-22:

• Project Management Basics
• Introduction to Project Management Concepts
• Tools for Project Planning and Management

Week 23-24:

• Final Project
• Students will apply their learned skills in a comprehensive project
• Projects can range from website development, a small-scale software application, a detailed business presentation, or a graphic design portfolio.
• Evaluation and Certification
• Continuous assessment through quizzes, assignments, and practical.
• Final assessment based on the final project and a written examination.

Additional Features

• Guest Lectures from Industry Experts
• Soft Skills Training: Communication Skills, Resume Writing, Interview Preparation
• Regular Workshops on Latest Technologies and Trends in IT
• This syllabus is a general guideline and can be customized according to the specific needs and capabilities of SEWAK Computer Centre and its students. It’s also important to regularly update the content to keep up with the rapidly evolving technology sector.

Month 1-2: Foundation in Computer Science

Week 1-2:

• Introduction to Computers and Computing
• Basics of computer hardware and software

Operating systems fundamentals (Windows, Linux)

Week 3-4:

• Principles of Programming
• Introduction to programming concepts (using languages like Python or Java)
• Basic data types, control structures, functions, and simple data structures

Week 5-6:

• Database Management Systems
• Fundamentals of databases
• Introduction to SQL and basic database operations

Week 7-8:

• Web Technologies
• Basics of HTML, CSS
• Introduction to JavaScript

Month 3-4: Intermediate Skills and Applications

Week 9-10:

• Advanced Programming Concepts
• Object-oriented programming
• Introduction to APIs and libraries

Week 11-12:

• Advanced Database Management
• Advanced SQL
• Introduction to NoSQL databases

Week 13-14:

• Networking and Security Fundamentals
• Basics of computer networks
• Introduction to cybersecurity and ethical hacking

Week 15-16:

• Front-end Web Development
• Deep dive into JavaScript
• Frameworks like React or Angular

Month 5: Specialization and Advanced Topics

Week 17-18:

• Choose one of the following
• Data Science and Analytics
• Cloud Computing and AWS/Azure basics
• Mobile Application Development (Android/iOS)

Week 19-20:

• Project Management and Software Development Life Cycle (SDLC)
• Agile and Scrum methodologies
• Version control systems (Git)

Month 6: Capstone Project and Professional Skills

Week 21-24:

• Capstone Project
• Students will apply the skills learned to a real-world project.
• This could be a software application, a web development project, or a data analytics project.
• Professional Development
• Resume writing and interview preparation
• Soft skills and communication

Additional Components:

• Workshops and Guest Lectures: Regular sessions by industry experts.
• Lab Sessions: Practical sessions in a computer lab to complement theoretical knowledge.
• Assignments and Quizzes: Regular assessments to gauge understanding and progress.

Evaluation:

• Continuous assessment through assignments and quizzes.
• Evaluation of the capstone project.
• Final examination covering all course aspects.
• This syllabus is designed to be dynamic, allowing for adjustments based on technological advancements and student feedback. It aims to equip students with the skills needed to succeed in various computing and IT roles.

Duration:

3 Months

Objective:

To equip students with a thorough understanding of financial accounting principles and practical skills in Tally ERP software, enabling them to manage and analyse financial data effectively for business decision-making.

Month 1: Understanding Financial Accounting

Week 1:

• Introduction to Financial Accounting
• Basics of accounting
• Accounting principles and conventions
• Introduction to financial statements

Week 2:

• Accounting Process
• Journal entries and ledger accounts
• Trial balance preparation
• Understanding debits and credits

Week 3:

• Subsidiary Books
• Sales and purchase books
• Cash book and bank reconciliation
• Bills of exchange and promissory notes

Week 4:

• Final Accounts
• Preparing profit and loss account
• Balance sheet preparation
• Understanding financial ratios

Month 2: Tally ERP Introduction and Basic Operations

 Week 5:

• Introduction to Tally ERP
• Overview of Tally ERP features
• Installation and setting up Tally
• Creating company in Tally

Week 6:

• Basic Accounting in Tally
• Creating ledgers and groups
• Recording basic accounting entries
• Generating trial balance in Tally

Week 7:

• Inventory Management in Tally
• Understanding stock groups and categories
• Recording inventory entries
• Managing stock summary

Week 8:

• Taxation in Tally
• Basics of GST and TDS
• Configuring and computing taxes in Tally
• Generating tax reports

Month 3: Advanced Tally Operations and Practical Applications

Week 9:

• Advanced Accounting in Tally
• Cost centres and cost categories
• Budgets and scenario management
• Bank reconciliation in Tally

Week 10:

• Payroll Management in Tally
• Setting up payroll
• Processing salaries and wages
• Payroll reports and compliance

Week 11:

• Financial Analysis and Reporting
• Cash flow and fund flow analysis
• Generating financial reports
• Analysing financial performance

Week 12:

• Capstone Project and Final Assessment
• Real-world accounting project using Tally
• Comprehensive assessment test

Evaluation:

• Weekly assignments and quizzes
• Mid-term project after Month 2
• Final capstone project and examination

Resources:

• Tally ERP software
• Textbooks and online resources on financial accounting
• Instructional videos and tutorials on Tally ERP

Teaching Methodology:

• Interactive lectures
• Hands-on Tally ERP software training
• Case studies and real-world examples