Computer Fundamentals - Syllabus

1. Introduction to Computers

• Definition & Characteristics of Computers

• History & Generations of Computers

• Types of Computers (Super, Mainframe, Mini, Micro)

• Applications of Computers in daily life

2. Computer Organization

• Basic Components of Computer (Input, Process, Output, Storage)

• Input Devices (Keyboard, Mouse, Scanner, etc.)

• Output Devices (Monitor, Printer, Plotter, Speakers)

• Storage Devices (Hard Disk, CD/DVD, Pen Drive, Cloud Storage)

3. Number System & Logic

• Number Systems: Binary, Decimal, Octal, Hexadecimal

• Conversion between Number Systems

• Basic Binary Arithmetic (Addition, Subtraction, Multiplication, Division)

• Logic Gates (AND, OR, NOT, NAND, NOR, XOR, XNOR)

4. Computer Hardware & Software

• Hardware: Definition & Examples

• Software: System Software, Application Software, Utility Software

• Operating System: Functions & Types

• Computer Languages (Machine, Assembly, High-Level)

5. Memory & Data Representation

• Primary Memory (RAM, ROM, Cache)

• Secondary Storage (Magnetic, Optical, Flash)

• Data Representation (Bits, Bytes, Characters, ASCII, Unicode)

6. Computer Networks & Internet

• Basics of Networking (LAN, MAN, WAN)

• Network Topologies (Bus, Star, Ring, Mesh, Hybrid)

• Internet, Intranet, Extranet

• Email, WWW, Cloud Computing

7. Computer Security

• Types of Threats: Virus, Malware, Hacking, Phishing

• Security Tools: Firewall, Antivirus, Encryption

• Cyber Ethics & Safe Practices

8. Latest Trends in IT

• Artificial Intelligence (AI) & Machine Learning

• Big Data & Data Analytics

• Virtual Reality (VR), Augmented Reality (AR)

• Blockchain Technology

• Internet of Things (IoT)

Microsoft Office – Syllabus

1. Introduction to MS Office

• Overview of MS Office Package

• Components: MS Word, MS Excel, MS PowerPoint, MS Access, MS Outlook

• Common Features of MS Office (Ribbon, Tabs, Toolbar, Shortcut Keys, File Menu, etc.)

2. MS Word (Word Processing)

• Introduction to Word Processor

• Creating, Saving, Opening Documents

• Editing & Formatting Text (Font, Paragraph, Bullets, Numbering)

• Page Setup: Margins, Orientation, Size

• Insert: Tables, Pictures, Shapes, Symbols, Header & Footer

• Mail Merge (Letters, Labels, Envelopes)

• Proofing Tools: Spell Check, Grammar Check, Thesaurus

• Printing Documents

3. MS Excel (Spreadsheet)

• Introduction to Spreadsheet

• Workbook, Worksheet, Cells, Rows & Columns

• Data Entry, Editing, Formatting

• Formulas & Functions (SUM, AVERAGE, IF, COUNT, VLOOKUP, HLOOKUP etc.)

• Charts & Graphs (Bar, Pie, Line, Column)

• Data Sorting & Filtering

• Conditional Formatting

• Pivot Tables & Pivot Charts

• Importing & Exporting Data

4. MS PowerPoint (Presentation)

• Introduction to Presentation Software

• Creating, Saving & Opening Presentations

• Slide Layouts, Design Templates, Themes

• Adding Text, Images, Audio, Video, Tables, Charts

• Slide Transitions & Animations

• Slide Master & Custom Slide Show

• Printing Slides & Handouts

5. MS Access (Database Management – Optional in some courses)

• Introduction to Databases

• Tables, Queries, Forms, Reports

• Primary Key & Relationships

• Data Entry & Editing Records

• Simple Queries & Filters

• Generating Reports

6. MS Outlook (Email & Scheduling – Optional)

• Basics of Email Communication

• Sending & Receiving Emails

• Using Contacts, Calendar, Tasks

• Scheduling Meetings & Appointments

7. Common Office Tools

• Shortcut Keys in MS Office

• File Management (Open, Save, Save As, Print, Export)

• Collaboration Tools (Track Changes, Comments, Sharing)

• Security (Password Protection, Read-only, Digital Signature)

Tally Prime with GST – Syllabus

1. Introduction to Tally Prime

• Overview of Tally ERP to Tally Prime

• Installation & Setup of Tally Prime

• Company Creation, Alteration, and Deletion

• Basic Configuration & Features

• Tally Prime User Interface (Gateway of Tally, Menus, Shortcuts)

2. Accounting Fundamentals in Tally

• Basics of Accounting (Debit, Credit, Journal, Ledger, Trial Balance)

• Groups & Ledgers Creation

• Vouchers (Payment, Receipt, Contra, Journal)

• Day Book & Reports

• Bank Reconciliation

3. Inventory Management

• Stock Groups, Categories, Units of Measure

• Stock Items Creation & Management

• Godown Creation

• Purchase & Sales Orders

• Delivery Notes, Rejection In/Out, Stock Journal

4. GST (Goods & Services Tax) in Tally Prime

• Introduction to GST (CGST, SGST, IGST, UTGST)

• Enabling GST in Tally Prime

• Creating GST Masters (Ledgers, Stock Items, Tax Rates)

• Recording GST Transactions (Sales, Purchases, Returns)

• Input Tax Credit (ITC)

• GST Reports (GSTR-1, GSTR-2, GSTR-3B)

• Exporting GST Reports for Filing

5. Advanced Accounting Features

• Cost Categories & Cost Centres

• Budgets & Controls

• Interest Calculation

• Multi-Currency Transactions

• Bill-wise Details & Outstanding Management

• Bank Features (Cheque Printing, Deposit Slips, Bank Reconciliation)

6. Payroll Management (Optional in Some Courses)

• Payroll Configuration & Setup

• Employee Creation & Salary Structure

• Attendance Recording

• Payroll Vouchers

• Payroll Reports

7. Taxation (Other than GST – Optional)

• TDS (Tax Deducted at Source) in Tally Prime

• TCS (Tax Collected at Source)

• Payroll with TDS

8. Reports & Printing

• Trial Balance, Profit & Loss, Balance Sheet

• Cash/Bank Book, Ledger Reports

• Ratio Analysis & Audit Reports

• Export, Backup & Restore of Data

• Printing of Invoices, Vouchers & Reports

Basic Internet Skills – Syllabus

1. Introduction to Internet

• What is Internet?

• History & Evolution of Internet

• How Internet Works (IP Address, Domain, Hosting, Browser, Search Engine)

• Types of Internet Connections (Broadband, Wi-Fi, Mobile Data, Hotspot)

2. Web Browsing

• Web Browsers (Chrome, Edge, Firefox, Safari)

• Basic Browser Functions (Address Bar, Tabs, Back, Refresh, Bookmarks, History)

• Searching Information (Google Search, Bing, DuckDuckGo)

• Safe Browsing Practices

3. Email Communication

• Creating an Email Account (Gmail, Outlook, Yahoo)

• Sending, Receiving, Forwarding & Replying Emails

• Attachments (Documents, Images, Links)

• Organizing Emails (Inbox, Sent, Draft, Spam)

• Email Etiquette & Digital Signature

4. Social Media & Online Communication

• Introduction to Social Media (Facebook, WhatsApp, Instagram, Twitter/X, LinkedIn)

• Creating & Managing Social Media Accounts

• Online Communication Tools (Zoom, Google Meet, MS Teams, Skype)

• Instant Messaging & Video Conferencing

5. Online Services & Applications

• Online Shopping & Payments (Amazon, Flipkart, UPI, Net Banking, Paytm, Google Pay)

• Online Ticket Booking (Railways, Airlines, Buses, Movies)

• E-Governance Services (Aadhaar, PAN, Passport, Online Forms)

• Cloud Storage (Google Drive, OneDrive, Dropbox)

6. Cyber Safety & Security

• Online Threats: Virus, Malware, Phishing, Hacking, Fake News

• Password Management & Two-Factor Authentication

• Safe Use of Social Media & Online Payments

• Data Privacy & Digital Footprints

7. Digital Tools & Productivity

• Using Search Engines Effectively

• Downloading & Uploading Files

• Using Online Forms, Google Docs, Sheets, Presentations

• Online Collaboration (Google Drive, Microsoft OneDrive)

8. Emerging Internet Trends

• IoT (Internet of Things)

• Cloud Computing

• Digital Marketing Basics

• Artificial Intelligence in Internet (Chatbots, Smart Search, Recommendations)

10th