Advance Diploma in Computer Application

Computer Fundamental

Windows 11

Module 1: Introduction to Windows 11

Installing and setting up Windows 11

Navigating the new Start menu

Customizing the taskbar and Start menu

Managing user accounts and sign-in options (PIN, Password, Microsoft Account)

Module 2: File and Folder Management

Creating, renaming, moving, and deleting files/folders

Using File Explorer to manage files

Pinning folders to the Quick Access menu

Searching files and folders in File Explorer

Using the Context Menu (right-click options)

Working with File Extensions and Preview Pane

Module 3: Personalizing Windows 11

Changing the desktop wallpaper and lock screen image

Customizing the taskbar (icons, system tray, transparency)

Changing system themes and colors (light/dark mode)

Setting up multiple desktops and virtual desktops

Adjusting screen resolution and display settings

Using Snap Layouts and Snap Groups for multitasking

Module 4: Working with Windows Settings

Accessing and navigating the Windows Settings app

Configuring system settings (Network, Devices, Time & Language)

Adjusting system sound and notifications

Managing power options and battery settings

Privacy settings and App permissions

Changing system language, region, and keyboard layout

Enabling and configuring Windows Update

Module 5: Managing Apps and Software

Installing, updating, and uninstalling apps from Microsoft Store

Managing installed apps and their permissions

Using Task Manager to monitor and end tasks

Pinning apps to the Start menu and taskbar

Using Settings to manage default apps (browser, email, etc.)

Module 6: File Backup and Recovery

Creating a System Restore Point

Using File History to back up files and restore them

Creating and using Windows 11 backup options (Backup & Restore, OneDrive backup)

Resetting Windows 11 to its default state without losing personal files

Module 7: Security and Privacy Settings

Setting up Windows Defender Antivirus and performing scans

Configuring Windows Security settings (Firewall, Virus & Threat Protection)

Using Windows Hello for secure login (Fingerprint, Face recognition)

Enabling BitLocker for disk encryption

Managing app permissions and privacy settings

Understanding Windows 11 Firewall and network protection

Module 8: Taskbar and Window Management

Customizing the taskbar (alignment, shortcuts, system icons)

Using Windows 11 Snap Assist for multitasking

Managing multiple windows and virtual desktops

Using Quick Settings (Wi-Fi, Bluetooth, Brightness, Focus Assist)

Managing system notifications and widgets

Organizing the desktop using icons, folders, and taskbar shortcuts

Module 9: Networking and Connectivity

Connecting to Wi-Fi and Ethernet networks

Setting up and managing network shares and printers

Troubleshooting network issues using the Network Troubleshooter

Using Airplane Mode, Bluetooth, and VPN settings

Configuring proxy settings and remote desktop connection

Module 10: Windows 11 for Productivity

Using Microsoft Teams and other built-in communication tools

Managing apps using the new Microsoft Store

Using Widgets for news, weather, and personal information

Managing system resources using Task Manager

Working with Windows PowerShell for advanced tasks

Module 11: Updates and Maintenance

Performing manual system updates via Windows Update

Managing update settings (active hours, restart options)

Using Disk Cleanup and Storage Sense for maintenance

Checking system health and performance

Uninstalling apps, software, and cleaning up unnecessary files

Module 12: Advanced Features and Tips

Using Cortana for voice commands and productivity

Configuring advanced security options (Windows Sandbox, Device Encryption)

Using the Windows Subsystem for Linux (WSL)

Exploring PowerToys and other productivity utilities

Managing device drivers and updates using Device Manager

Module 13: Final Project

Students will complete a project incorporating all learned skills. The project may involve:

Customizing the Windows 11 interface and settings

Configuring system and security settings for a personal or business setup

Setting up network connections and sharing files between multiple devices

Troubleshooting common Windows 11 problems and demonstrating solutions

Assessment:

Practical Evaluation: Hands-on exercises and tasks after each module

Final Project: An overall project showcasing the student's learning

Feedback: Continuous feedback after each session to improve practical skills

Tools Required:

Computers with Windows 11 OS installed

Internet access for updates and online resources

External storage devices for backup tasks (USB, External Hard Drives)

Optional: Microsoft Teams for collaboration and online sessions

Microsoft Word 365

Module 1: Introduction to MS Word 365

Opening, closing, and saving documents in Word

Navigating the Ribbon and understanding the interface

Using the Quick Access Toolbar and customizing it

Zoom in and zoom out in the document

Creating a new document and using templates

Module 2: Basic Document Formatting

Typing, editing, and deleting text

Changing font style, size, color, and applying bold, italic, underline

Aligning text (left, right, center, justify)

Adjusting line spacing and paragraph spacing

Using bullet points and numbered lists

Using Undo and Redo options

Formatting headings and subheadings using Styles

Module 3: Working with Pages and Layout

Adjusting page margins (Normal, Narrow, Custom)

Changing page orientation (Portrait, Landscape)

Inserting and removing page breaks

Setting up headers and footers (page numbers, date, document title)

Adding and formatting page borders

Changing paper size and orientation

Module 4: Working with Tables

Inserting a table (number of rows and columns)

Adding and deleting rows/columns

Merging and splitting cells

Adjusting column width and row height

Formatting table (borders, shading, text alignment)

Using table styles for quick formatting

Sorting data within a table

Converting text to a table and vice versa

Module 5: Inserting Graphics and Objects

Inserting pictures and resizing them

Using WordArt for creative text effects

Inserting shapes, icons, and SmartArt

Working with text boxes (inserting, resizing, moving)

Inserting charts (column, pie, bar) and customizing them

Using Screenshots and Snipping Tool in Word

Wrapping text around images and objects

Module 6: Advanced Formatting Techniques

Applying and customizing themes and templates

Using the Format Painter to copy formatting

Creating and modifying paragraph styles

Inserting and formatting columns (newspaper-style text)

Creating and formatting lists with bullets, numbering, and multilevel lists

Inserting and formatting footnotes, endnotes, and citations

Module 7: Working with Headers, Footers, and Page Numbers

Inserting and editing headers and footers

Adding different headers/footers for odd and even pages

Customizing page numbers (position, format)

Inserting document date/time in headers or footers

Using Section Breaks for different formatting in sections

Module 8: Reviewing and Proofreading Tools

Using Spelling and Grammar check

Adding comments and track changes for document review

Accepting or rejecting changes in the document

Using the Thesaurus and synonyms tool

Comparing and merging two documents

Checking document readability and readability scores

Module 9: Collaboration and Sharing

Sharing documents via OneDrive or SharePoint

Collaborating in real-time with others (track changes, comments)

Using @mentions and notifications in shared documents

Protecting a document (password protection, restricting editing)

Using the "Compare" and "Combine" features for document comparison

Saving a document in various formats (PDF, Word, etc.)

Module 10: Using Mail Merge

Setting up a Mail Merge (creating a letter template)

Using Excel as a data source for mail merge

Inserting merge fields (name, address, etc.)

Previewing and finishing the Mail Merge (print, email, or save)

Module 11: Using Templates and Forms

Creating documents using built-in templates

Designing a form with fillable fields (using Content Controls)

Protecting forms (restricting editing to fillable areas)

Saving and using custom templates for future documents

Module 12: Final Project

Creating a professional report or newsletter with tables, images, headers, and footers

Performing mail merge for personalized letters

Designing a form with fillable fields and submitting it

Formatting a document with advanced styles, sections, and columns

Assessment:

Practical Assignments: After each module, students will complete hands-on tasks.

Final Project: A final project incorporating all the features covered in the course.

Feedback: Continuous feedback on each task to enhance learning.

Microsoft Excel 365

Module 1: Introduction to MS Excel 365

Opening, closing, and saving Excel files

Navigating the Excel interface (Ribbon, Formula bar, Cells, Rows, Columns)

Creating a new workbook and worksheet

Understanding the use of cells, rows, columns, and ranges

Adjusting column width and row height

Basic navigation using keyboard shortcuts (e.g., Ctrl + Arrow keys)

Module 2: Data Entry and Formatting

Entering text, numbers, and dates in cells

Formatting cells (font size, style, color)

Number formatting (currency, percentage, decimal places)

Aligning data (left, center, right)

Changing cell borders, fills, and text wrapping

Merging and splitting cells

Using Format Painter to copy formatting

Module 3: Basic Formulas and Functions

Writing simple formulas (addition, subtraction, multiplication, division)

Using AutoSum for quick calculations

Introduction to basic functions (SUM, AVERAGE, MIN, MAX)

Using AutoFill to copy formulas and patterns

Understanding relative, absolute, and mixed references in formulas (e.g., $A$1, A1, A$1)

Using the Quick Analysis tool for basic calculations

Module 4: Working with Data and Sorting

Sorting data (ascending, descending) by one or multiple columns

Filtering data using the Filter tool

Removing duplicates from data

Using Conditional Formatting for highlighting data (color scales, data bars, icon sets)

Using the Flash Fill tool for automatic pattern recognition

Working with Excel tables (inserting, formatting, and managing tables)

Module 5: Advanced Formulas and Functions

Introduction to advanced Excel functions

Using IF function for conditional logic (simple IF, nested IF)

Using COUNTIF, SUMIF, and AVERAGEIF functions for conditional calculations

Working with text functions (CONCATENATE, LEFT, RIGHT, MID, TRIM)

Using date functions (TODAY, NOW, DATE, YEAR, MONTH, DAY)

Using lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)

Using logical functions (AND, OR, NOT)

Module 5: Advanced Formulas and Functions

Importance of data visualization in Excel

Creating basic charts (Column, Line, Bar, Pie)

Customizing charts (titles, labels, legends, data series)

Using Pivot Charts to summarize data visually

Adding trendlines to charts

Using the Recommended Charts tool for automatic chart selection

Formatting charts (colors, styles, and 3D effects)

Working with Sparklines for quick data visualization

Module 7: Working with PivotTables and PivotCharts

Creating and modifying PivotTables

Adding and removing fields in PivotTable

Grouping data in PivotTable (by date, numbers, etc.)

Using calculated fields in PivotTables

Refreshing and updating PivotTables

Creating PivotCharts from PivotTables for advanced data analysis

Module 8: Data Analysis Tools and Functions

Introduction to advanced data analysis tools

Using Goal Seek for finding values

Performing data analysis with the What-If analysis tools

Using Data Tables for sensitivity analysis

Using Solver for complex optimization problems

Using Forecasting tools for trend analysis

Analyzing data with Scenario Manager

Module 9: Working with Multiple Sheets and Workbooks

Managing multiple sheets and workbooks in Excel

Linking data between different sheets and workbooks

Copying and pasting data across workbooks

Grouping and ungrouping worksheets

Renaming, adding, and deleting sheets

Protecting worksheets and workbooks (password protection)

Using the Consolidate tool to combine data from multiple sheets

Module 10: Printing and Sharing Excel Workbooks

Setting print areas and adjusting page layout for printing

Using Page Break Preview and Print Titles

Printing selected data and entire workbooks

Saving workbooks as PDF or XPS

Sharing workbooks via OneDrive or email

Co-authoring and collaborating in real-time with other users

Protecting and securing Excel workbooks while sharing

Module 11: Advanced Excel Features (Power Query, Power Pivot)

Using Power Query to import and transform data from external sources

Connecting Excel to databases, text files, and web sources

Using Power Pivot for advanced data modeling and analysis

Creating relationships between different data sources

Using DAX formulas in Power Pivot for complex calculations

Module 12: Final Project

Create and format a complex Excel report with data, tables, formulas, and charts

Use PivotTables and PivotCharts to summarize and analyze data

Implement advanced functions (IF, VLOOKUP, COUNTIF, etc.) in real-world scenarios

Collaborate on a workbook, sharing data and managing version control

Assessment:

Practical Assignments: Hands-on tasks after each module

Final Project: A final project that integrates all the concepts covered in the course

Feedback: Continuous feedback after each practical exercise

Microsoft PowerPoint 365

Module 1: Introduction to MS PowerPoint 365

Opening, saving, and closing presentations

Navigating the PowerPoint interface (Ribbon, Quick Access Toolbar)

Understanding slide layouts and themes

Creating a new presentation and choosing a template

Using the Design Tab to choose a theme for your presentation

Basic slide navigation (Next, Previous, Go to Slide)

Module 2: Working with Slides

Basics of adding and editing slides

Inserting new slides (title, text, blank, etc.)

Changing slide layouts (Title, Content, Two Content, Comparison)

Deleting, duplicating, and reordering slides

Changing slide background color and design

Applying slide transitions and setting duration

Using the Slide Sorter view for slide organization

Setting up slide master for consistent design

Module 3: Text and Content Formatting

Typing and editing text in text boxes

Formatting text (font style, size, color, bold, italic, underline)

Using bullets, numbering, and multilevel lists

Aligning text (left, center, right, justify)

Inserting text boxes and adjusting their size and position

Copying and pasting content with and without formatting

Formatting paragraphs (line spacing, indentations, etc.)

Module 4: Inserting Visuals and Objects

Inserting images from file and web sources

Inserting icons and graphics from PowerPoint library

Using the "Insert" tab to add shapes, smart art, and charts

Inserting and formatting tables for data display

Inserting screenshots and screen recordings

Using Picture Tools to resize, crop, and adjust images

Applying effects and styles to images (shadows, reflections, borders)

Adding text effects and WordArt

Module 5: Working with Charts and Graphs

Inserting and customizing different types of charts (bar, pie, line, etc.)

Modifying chart data and changing chart types

Formatting chart titles, labels, and legends

Customizing chart colors and styles

Adding trendlines and data labels to charts

Linking Excel data with PowerPoint for dynamic charts

Using the Chart Tools to format and modify charts

Module 6: Animations and Transitions

Applying animations to text, images, and other objects

Customizing animation effects (entrance, emphasis, exit)

Setting animation duration and delay times

Using the Animation Pane for managing animations

Applying slide transitions (Fade, Wipe, Push, etc.)

Setting transition duration and sound effects

Creating interactive animations for engaging presentations

Module 7: Audio, Video, and Multimedia

Inserting and playing audio files in a slide (MP3, WAV)

Inserting and editing video files (MP4, WMV, etc.)

Using the Playback tools for audio and video

Embedding online videos from YouTube or other sources

Adjusting audio and video settings (volume, start, playback options)

Using Action Buttons for interactive presentations (Hyperlinks, triggers)

Module 8: Working with Hyperlinks and Action Buttons

Inserting hyperlinks to navigate to other slides or external websites

Creating interactive presentations using action buttons

Setting up a navigation menu with hyperlinks

Using action buttons to link slides within the presentation

Setting up a self-running presentation with action buttons

Module 9: Collaboration and Sharing

Sharing PowerPoint presentations via OneDrive or SharePoint

Collaborating in real-time with others using Comments and Annotations

Comparing and merging different versions of the presentation

Adding and reviewing comments in slides

Presenting a slide show with notes for the presenter

Exporting presentations to PDF, Word, or video formats

Printing presentations (handouts, notes, and slides)

Module 10: Finalizing and Presenting

Setting up and customizing the Slide Show (loop, auto-advance)

Adding speaker notes and rehearse timings

Using Presenter View during a presentation

Finalizing presentation by checking for consistency

Practicing the presentation using Presenter View

Creating a custom slide show (selecting specific slides for different audiences)

Adding slide transitions for a smoother presentation flow

Module 11: Advanced PowerPoint Features (Optional)

Exploring advanced features for complex presentations

Using PowerPoint Designer to auto-generate slide layouts and designs

Using advanced charts and graphs for complex data presentations

Customizing PowerPoint themes and saving as a template

Using Morph transition for seamless slide animations

Advanced editing of videos within PowerPoint

Creating and using custom slide layouts

Using external add-ins for enhanced functionality

Module 12: Final Project

Students will create a comprehensive presentation that includes:

Custom slide layouts, animations, and transitions

Charts, graphs, images, and multimedia elements

Action buttons and hyperlinks for interactivity

Slide master and consistent design throughout the presentation

Real-time collaboration on a group presentation (if applicable)

Assessment:

Practical Assignments: Hands-on tasks at the end of each module

Final Project: A complete presentation showcasing all learned features

Feedback: Continuous feedback after each session to improve presentation skills

Typing in Hindi & English

Computer Hardware

Application of Internet & Email System

Introduction of Internet & Email System

Gmail Account Creation , Password Change, Sending Email , Attach Any File in Gmail

How to change Profile Picture in Gmail Account ?

How to Change Themes in Gmail Account

What is Two Step Verification ? How to Use Two Step Verification in Gmail ?

What is PAN Card ? Use of Pan Card ?

Apply Pan application using NSDL Portal

Correction Pan application using NSDL Portal

Reprint of PAN Card using NSDL Portal

Introduction of Aadhar Portal https://uidai.gov.in/

What is Aadhaar Features of Aadhaar

Download Aadhaar & Update Aadhaar Data

Order Aadhaar PVC Card o Check Aadhaar PVC Card Status

Check Aadhaar Update Status

National Voter Service Portal https://www.nvsp.in/

Register as a New Elector/Voter

Track Application Status

Download E-EPIC

Passport Seva Portal (https://www.passportindia.gov.in/)

Registration on Passport Seva Portal

Apply Online for the Passport

Book Appointment on PSK

Check Status of Passport

Driving License Portal (https://parivahan.gov.in/)

Apply for DL, Slot Booking,

Ccc online form

Resizing of photo,sign,and thumb impression

E district

CSC

Caste,income residence certificate online

Basic of Financial Accounting

Module 1: Introduction to Financial Accounting

Definition and Importance of Financial Accounting

Role of Accounting in Business

Basic Accounting Terms: Assets, Liabilities, Capital, Revenue, and Expenses

Users of Financial Accounting Information (Internal and External Users)

The Accounting Cycle and its Phases

Module 2: Accounting Principles and Concepts

Generally Accepted Accounting Principles (GAAP)

Accounting Standards and their Importance

Basic Accounting Concepts:

Entity Concept

Going Concern Concept

Matching Concept

Cost Concept

Revenue Recognition Concept

Accrual Concept

Qualitative Characteristics of Accounting Information:

Relevance

Reliability

Comparability

Understandability

Module 3: Double-Entry System of Accounting

The Concept of Double-Entry Bookkeeping

Basic Rules of Debit and Credit:

Debit the receiver, Credit the giver

Debit what comes in, Credit what goes out

Debit all expenses and losses, Credit all incomes and gains

Classification of Accounts:

Personal Accounts

Real Accounts

Nominal Accounts

Module 4: Journal Entries and Ledger

Introduction to the Journal: Meaning, Types, and Importance

Format of Journal Entries

Recording Transactions in the Journal

Posting Journal Entries to the Ledger

Understanding the Trial Balance and its Importance

Difference between Journal and Ledger

Module 5: Subsidiary Books

Meaning and Types of Subsidiary Books

Cash Book

Purchase Book

Sales Book

Purchase Return Book

Sales Return Book

Bills Receivable and Bills Payable Book

Recording transactions in subsidiary books

Transfer from subsidiary books to the ledger

Module 6: Preparation of Financial Statements

Profit and Loss Account:

Purpose and Importance

Structure and Format of Profit and Loss Account

Balance Sheet:

Purpose and Importance

Structure and Format of the Balance Sheet

Relationship Between Profit and Loss Account and Balance Sheet

Adjustments to be made before preparing final accounts

Closing of accounts at the end of the accounting period

Goods and Services Tax (GST)

Module 1: Introduction to Goods and Services Tax (GST)

Definition of GST: Meaning and concept of Goods and Services Tax

GST and its significance: How GST simplifies the taxation system

Objectives of GST: To ensure tax compliance, reduce the cascading effect, and simplify the taxation process

Types of GST:

Central Goods and Services Tax (CGST)

State Goods and Services Tax (SGST)

Integrated Goods and Services Tax (IGST)

Evolution of GST in India: From VAT to GST

Constitutional Amendments: 101st Constitutional Amendment Act, 2016

Module 2: GST Structure and Taxable Events

Basic Structure of GST: Overview of the GST framework in India

Taxable Event under GST: When does GST become applicable (supply of goods and services)

Supply of Goods and Services: Definition and types (composite, mixed, and exempted supplies)

Place of Supply: How the place of supply determines the type of tax (CGST, SGST, IGST)

Time of Supply: Determining the time at which GST is payable on a transaction

Valuation under GST: How to value goods and services for GST

Module 3: GST Registration

GST Registration Process: Who needs to register under GST?

Compulsory Registration: Threshold limit for GST registration

Voluntary Registration: Benefits of voluntary registration

Types of GST Registration:

Normal Registration

Composition Scheme Registration

GSTIN (Goods and Services Tax Identification Number)

GST Registration Procedure: Step-by-step process of registration

Obligations of GST Registrants: Compliance and filing requirements

Module 4: GST on Goods and Services

Classification of Goods and Services under GST: Goods and Services as per HSN and SAC codes

Tax Rates under GST:

0%, 5%, 12%, 18%, and 28% Tax Slabs

Specific tax rates for goods (luxury goods, essential goods, etc.)

Specific tax rates for services (transportation, IT services, hospitality, etc.)

Exemptions under GST: Goods and services exempted from GST

Reverse Charge Mechanism (RCM): When the recipient is liable to pay GST instead of the supplier

Input Tax Credit (ITC): How businesses can claim tax credits on their purchases

Module 5: Composition Scheme under GST

Overview of the Composition Scheme: A simplified tax scheme for small businesses

Eligibility for Composition Scheme: Who can opt for the scheme

Advantages and Disadvantages of the Composition Scheme

Rates under Composition Scheme: Tax rates for various categories of taxpayers

Filing and Compliance under the Composition Scheme

Module 6: GST Invoices, Payments, and Returns

GST Invoice: Types of invoices under GST (Tax Invoice, Bill of Supply, Receipt Voucher, Payment Voucher)

Contents of GST Invoice: Mandatory details to be included in an invoice

GST Payments: How payments of GST are made by taxpayers

GST Returns: Types of GST returns (GSTR-1, GSTR-3B, GSTR-9, etc.)

GSTR-1: Outward supply return

GSTR-3B: Summary return for monthly GST payment

GSTR-9: Annual return

Due Dates for GST Returns: When GST returns need to be filed

GST Filing and Penalties: Consequences of non-filing or late filing of returns

Module 7: Input Tax Credit (ITC) under GST

Meaning and Concept of ITC: How businesses can claim credit for taxes paid on purchases

Eligibility and Conditions for Claiming ITC: When and how can a business claim ITC

ITC on Capital Goods: Special provisions for claiming ITC on capital goods

Blocked Credits: Goods and services on which ITC cannot be claimed

Reversal of ITC: Conditions under which ITC needs to be reversed

Module 8: GST Compliance and Record-Keeping

GST Compliance Requirements: Regular filing of returns, maintaining records, and paying taxes

Books of Accounts under GST: Types of records that need to be maintained by businesses (sales registers, purchase registers, tax payment records)

Audit and GST: Concept of GST audit and its importance for businesses

GST and E-way Bill: What is an E-way Bill, and when is it required for goods transport?

Module 9: GST Refund and Adjudication

GST Refunds: Process of claiming a refund for excess tax paid

Reasons for Refund: Export of goods/services, input tax credit mismatch, etc.

Procedure for Refund: Steps involved in the GST refund process

Adjudication Process under GST: How disputes are resolved in GST-related matters

Appeals and Review under GST: Process of challenging GST assessments

Module 10: GST Enforcement and Penalties

GST Compliance and Enforcement: Role of tax authorities in enforcing GST regulations

GST Audits: Concept of tax audits under GST for taxpayers

Penalties for Non-Compliance:

Penalties for failure to register, file returns, or pay taxes

Penalties for issuing incorrect invoices or documents

Prosecution under GST: Serious offenses under GST and their legal implications

Module 11: Impact of GST on the Economy

GST and Economic Growth: How GST contributes to India’s economy

GST and Business Efficiency: Simplification of business processes, impact on supply chain management

Impact of GST on Various Sectors:

Impact on the manufacturing sector

Impact on the service sector

Impact on small businesses and MSMEs

GST and International Trade: Impact on exports and imports

Tally Prime with GST

Module 1: Introduction to Tally Prime and GST

Installing and configuring Tally Prime with GST settings

Creating a company in Tally Prime with GST configuration

Exploring the GST features in Tally (activation, configuration of GSTIN, tax rates)

Setting up GST tax categories and GST Ledger accounts

Module 2: GST Registration and Setup in Tally

Step-by-step guide to GST registration in Tally Prime

Configuring GST-related details for the company: GSTIN, GST Registration type

Creating GST Ledgers: CGST, SGST, IGST, and Input Tax Credit (ITC) ledgers

Setting up tax rates: 0%, 5%, 12%, 18%, and 28% tax slabs in Tally

Enabling GST on purchases, sales, and expenses in Tally

Module 3: Recording GST Sales and Purchases

Recording GST sales transactions with tax calculation (both cash and credit sales)

Recording GST purchase transactions with tax calculation (both cash and credit purchases)

Generating tax invoices for different GST transactions

Recording GST payments and GST receipts in Tally

Generating sales and purchase reports for GST compliance

Module 4: Managing GST Returns in Tally

Generating GSTR-1 (Outward Supplies) from Tally:

Sales invoices

B2B and B2C details

HSN-wise summary

Filing GSTR-3B from Tally:

Calculating and reporting tax liability (Output tax and Input tax)

Generating ITC (Input Tax Credit) details

Filing GSTR-9 (Annual return) from Tally

Exporting GST Returns in XML format for submission to GST portal

Understanding GST filing deadlines and the process of late filing

Module 5: Advanced GST Transactions

Recording reverse charge transactions (RCM purchases and sales)

Handling GST on export transactions (zero-rated sales, tax-exempt transactions)

Managing stock transfers between different branches or warehouses and its impact on GST

Recording imports and exports in Tally (customs duties and shipping charges)

Generating export-related GST reports for businesses

Module 6: Managing GST in Multi-State Businesses

Configuring multi-state business operations in Tally

Recording sales and purchases for multiple states with appropriate GST tax slabs

Generating state-wise GST reports for compliance

Filing IGST returns for inter-state transactions

Managing inter-state stock transfers and tax implications in Tally

Module 7: Payroll and Taxation Compliance in Tally

Configuring payroll in Tally (salary components, deductions)

Managing Employee-related GST: TDS on salary payments and other employee benefits

Generating payslips and statutory reports (PF, ESI, and TDS) using Tally

TDS adjustments and GST liability from employee-related transactions

Generating compliance reports for payroll-related taxation in Tally

Module 8: GST and Inventory Management

Setting up stock groups, stock categories, and units of measurement for GST-compliant inventory

Recording inventory purchases and sales with GST calculations

Tracking GST Input Tax Credit (ITC) on inventory purchases

Managing stock transfers and GST adjustments in Tally

Generating stock reports: Stock Summary, Stock Movement, and Inventory Valuation reports

Module 9: Bank Reconciliation and GST Compliance

Performing bank reconciliation in Tally while matching GST-related payments and receipts

GST payments: Recording payments to the government for GST tax liabilities

Handling GST refunds: Recording and tracking refunds due to excess payments

Generating GST payment reports and reconciliation statements

Managing GST refund claims and their status in Tally

Module 10: Year-End Process and GST Filing

Closing books for the financial year with GST adjustments

Filing GSTR-9 for the end of the financial year

Generating final GST reports: Annual returns, reconciliation reports

Preparing for GST audits and tax assessments using Tally data

GST-related year-end reconciliation and ITC claims

Assessment:

Practical Exams: Students will be required to handle real-world accounting scenarios with GST in Tally, including transactions, invoicing, GST filing, and reconciliation.

Assignments: Completion of GST returns, sales and purchase entries, and inventory management in Tally.

Project Work: Students will create and maintain complete accounting books for a sample business, ensuring GST compliance and generating all required reports.

Job-Oriented Focus:

Hands-on experience with GST-compliant accounting processes, including GST invoicing, filing returns, and completing transactions.

Practical knowledge of handling GST in multi-state operations, export/import businesses, and GST audits.

Expertise in using Tally Prime software for tax filing, GST reports, and compliance management.

Video Conferencing

Module 1: Introduction to Video Conferencing

Introduction to video conferencing software (Zoom, Google Meet, Microsoft Teams)

Install and set up the software

Overview of the interface (buttons, menus, and settings)

Create a user profile and set up a test meeting

Joining a video meeting as a participant

Practice with muting and unmuting the microphone, turning the video on/off

Module 2: Scheduling and Hosting a Video Meeting

Scheduling a meeting in Zoom, Google Meet, and Microsoft Teams (date, time, invites)

Sending meeting invitations and adding participants

Joining meetings via links or meeting codes

Starting and hosting a meeting

Controlling audio and video settings

Managing participant controls (muting, screen sharing permissions)

Module 3: Communication Tools During Video Conferencing

Chatting with participants during the meeting (text messages, links, file sharing)

Using emoji reactions to express agreement/disagreement during discussions

Screen sharing to present slides, documents, and applications

Practicing virtual hand-raising and participant interaction

Module 4: Managing Participants in Video Conferencing

Managing participants: Muting/unmuting, pinning video, spotlighting speakers

Assigning roles: Co-hosting and managing participant permissions

Using breakout rooms for group discussions in Zoom and Google Meet

Participant interaction: Managing questions, discussions, and using the raise hand feature

Module 5: Advanced Features in Video Conferencing

Recording a meeting for later reference (Zoom/Google Meet)

Enabling and using live captions for accessibility

Sharing files and integrating with Google Drive or OneDrive during a meeting

Security settings: Enabling waiting rooms, password protection, and removing participants

How to lock a meeting and avoid unwanted attendees

Module 6: Troubleshooting and Technical Skills for Video Conferencing

Troubleshooting:

Fixing audio and video issues (checking microphones, cameras)

Connection troubleshooting: Addressing weak internet signals and dropped calls

Adjusting audio settings for better sound clarity

Practicing adjusting video quality based on network speed

Testing equipment before joining a meeting (microphone, camera, and internet speed check)

Module 7: Professional Etiquette for Video Conferencing

Practicing good video conferencing manners:

Dressing appropriately for video calls

Maintaining eye contact and proper posture during video calls

Mute/unmute management during speaking and listening

Maintaining a professional background for meetings

Effective virtual communication: Clear speaking, active listening, and asking relevant questions

Practice participating in a virtual group discussion with appropriate etiquette

Module 8: Collaborative Work and File Sharing During Video Meetings

Collaborative tools: Using Google Docs, Microsoft Office 365 for real-time document editing during a meeting

Sharing files through video conferencing tools: PDFs, documents, and presentations

Working together in real-time on a document shared during the meeting

Screen sharing documents and explaining the content to participants

Module 9: Virtual Networking and Webinars

Difference between webinars and meetings

Key points for virtual networking in online conferences

Hosting and participating in a webinar (Zoom/Teams/Google Meet)

Managing large audiences in webinars: Mute-all, Q&A sessions, and panelist management

Networking exercises: Building virtual connections through chat and private messages

Post-meeting follow-up: Sending thank-you emails and documents shared during the webinar

Module 10: Final Practical Assessment

Final project: Students will host a full-fledged video meeting with multiple participants

Scheduling the meeting

Managing the meeting (participants, screen sharing, and file sharing)

Troubleshooting any issues during the meeting

Demonstrating appropriate video conferencing etiquette

Peer feedback: Each student will participate in a meeting hosted by a peer, providing constructive feedback on their hosting and interaction skills

Assessment and Certification:

Practical Exams: Hosting and managing a video conference meeting with a focus on hosting skills, troubleshooting, and participant management.

Projects: Conducting webinars, collaborative work sessions, and participating in networking exercises.

Final Exam: A comprehensive practical exam where students will host a mock meeting, solve technical issues, and demonstrate video conferencing tools effectively.

Certification: Students will receive a certificate of completion based on their practical performance and understanding of video conferencing tools.

Cloud Storage and File Sharing

Module 1: Introduction to Cloud Storage

Creating accounts on popular cloud storage platforms (Google Drive, OneDrive, Dropbox, iCloud)

Overview of the user interface of each platform

Understanding cloud storage terminology: Files, Folders, Cloud Sync, Backup, etc.

Uploading and downloading files from the cloud

Module 2: Organizing Files and Folders in Cloud Storage

Moving, renaming, and deleting files in cloud storage

Search functionality: How to search for files and folders efficiently in cloud storage

Setting up automatic backup for specific files or folders

Module 3: Sharing Files and Folders

Sharing files and folders via link and email in Google Drive, OneDrive, Dropbox

Setting sharing permissions (view, comment, edit)

Collaborating in real-time on documents (Google Docs, Microsoft Office Online)

Accessing shared files and understanding permission settings

Module 4: Advanced File Sharing and Permissions

Sharing files with specific people and setting up permissions for different users

Using advanced permissions (e.g., restricting download, view-only access)

Password-protecting links for added security

Managing shared files: Viewing who has access and removing access when necessary

Setting up sharing with expiry dates (e.g., Dropbox/Google Drive)

Module 5: Synchronizing Files Across Devices

Setting up file synchronization for Google Drive, OneDrive, Dropbox across devices

Accessing cloud storage from mobile devices (Android/iOS)

Managing offline files and syncing them when online

Understanding sync conflicts and how to resolve them

Microsoft Access 365

Introduction to database – What is a Database

What is Microsoft Access?

Important Terms and Basic Objects

Database File:

Datatypes:

Table

Query

Form

Report

Microsoft Access Data Types

Differences between Access and Excel

Advantages of MS Access

Disadvantages of MS Access

How to Start Microsoft Access

1. From Windows, Start button.

2. From Desktop, ‘New’ option.

How to Create a Database

Create Database from Template

Create a Blank Database

How to Create Table

Create Table - Datasheet View

Create Table - Design View

How to Switch views between Datasheet and Design

MS Access- Adding Data

Summarizing views: Datasheet View:Design view

Forms in MS Access

How to Create a form

1. Create using Form Wizard

2. Create using Form

3. Create form by ‘Multiple Item.’

4. Create form by ‘Split from’.

Edit the existing record via Form.

Add a record to a Form.

Query in MS Access

1. Select Query

Multi Table Query

Update Query

Delete Query

Append Query

Cross Table Query

Make Table Query

Report Designing in MS Access

Microsoft Outlook 365

Module 1: Introduction to Microsoft Outlook

Overview of Microsoft Outlook

What is Outlook?

Difference between Outlook.com and Microsoft Outlook (desktop version)

Outlook interface: Ribbon, Navigation Pane, Reading Pane

Creating and managing profiles in Outlook

Setting Up Outlook

Setting up an Email account (IMAP, POP, Exchange)

Configuring Email settings

Customizing Outlook options (language, display settings, themes)

Understanding the Backstage view and Account Settings

Module 2: Working with Emails

Sending and Receiving Emails

Composing and formatting emails

Adding attachments and hyperlinks

Using signatures for emails

Understanding folders: Inbox, Sent Items, Drafts, etc.

Organizing Emails

Creating and managing folders

Moving and categorizing emails

Using the Search feature effectively

Flags and Follow-up options

Advanced Email Features

Using the Calendar and To-Do list in emails

Managing Junk Emails and Spam filters

Setting up Rules and Alerts

Archiving emails

Module 3: Managing Contacts

Creating and Managing Contacts

Adding new contacts and contact groups

Editing and updating contact information

Using the Address Book

Importing and exporting contacts

Advanced Contact Management

Organizing contacts with Categories

Using Business Cards and VCards

Linking contacts to calendar events and tasks

Contact search and categorization

Module 4: Calendar and Scheduling

Introduction to Calendar Features

Overview of the Calendar

Creating and managing appointments

Scheduling recurring meetings/events

Using the Week, Day, and Month views

Managing Meetings

Creating a meeting invitation

Responding to meeting requests

Setting reminders for meetings

Sharing calendars with others

Advanced Calendar Options

Setting up multiple calendars

Using Scheduling Assistant to find suitable meeting times

Using time zones in calendar events

Color-coding appointments and events

Module 5: Tasks and To-Do List

Managing Tasks

Creating tasks and to-do items

Setting deadlines and priorities for tasks

Using task reminders and notifications

Organizing Tasks

Categorizing and sorting tasks

Using the Task List to manage ongoing tasks

Converting emails into tasks

Sharing and Assigning Tasks

Assigning tasks to others

Tracking task progress

Marking tasks as completed

Module 6: Using Outlook with Other Applications

Integrating with Microsoft Word, Excel, PowerPoint

Using Outlook with Word (Mail Merge, Editing documents)

Using Outlook with Excel (Exporting data from Outlook)

Using Outlook with PowerPoint (Sharing presentations via email)

Using Outlook with OneNote

Sending emails to OneNote

Synchronizing tasks and calendar events with OneNote

Module 7: Security and Privacy in Outlook

Understanding Outlook Security Features

Encryption and Digital Signatures

Phishing email identification

Outlook's built-in security and spam filters

Managing Privacy Settings

Protecting privacy in emails

Customizing the Junk E-mail filter

Managing your Microsoft Account and privacy settings

Module 8: Advanced Features in Outlook

Using Quick Steps

Setting up and customizing Quick Steps for efficient email management

Using Quick Steps to automate tasks like flagging, categorizing, or replying

Working with Notes and Journals

Creating and managing Notes

Using Journals for task and activity tracking

Collaborating Using Microsoft Outlook

Sharing calendars and contacts with others

Working with shared mailboxes

Setting up and participating in group emails

Module 9: Outlook for Mobile

Using Outlook on Mobile Devices

Installing and configuring Outlook on Android and iOS

Syncing emails, calendars, and contacts on mobile

Outlook features on mobile vs desktop

Managing Emails and Calendars on the Go

Composing and responding to emails on mobile

Managing tasks and appointments from mobile

Module 10: Troubleshooting and Optimization

Troubleshooting Common Outlook Issues

Resolving syncing issues

Fixing connectivity problems

Repairing corrupted Outlook profiles

Optimizing Outlook Performance

Managing large mailboxes and reducing data file size

Tips for improving Outlook speed and performance

Assessment and Final Project

Quiz and Written Test covering theoretical knowledge

Practical Demonstration of tasks learned throughout the course

Final Project: Students will be asked to demonstrate their ability to organize an email system, schedule a meeting, and manage tasks in Outlook

Responsive Web Designing

Module 1: Introduction to Responsive Web Design

What is Responsive Web Design?

Importance of responsive design in modern web development

Understanding viewport and device width

Setting up a Basic Web Page with HTML and CSS

Understanding Viewport meta tag:

Viewing the webpage on different screen sizes using browser tools

Module 2: CSS Basics Refresher

CSS Selectors, Properties, and Syntax

Styling Text: font-size, font-family, text-align, and text-color

Background and Borders: Background-color, borders, and padding

CSS Box Model: margin, padding, border, content

Module 3: Media Queries Basics

What are Media Queries in CSS?

How media queries help in creating responsive designs

Creating Simple Media Queries for different screen sizes (mobile, tablet, desktop)

Using max-width and min-width to adjust the layout based on screen size

Changing font size, background colors, and layout for mobile screens

Module 4: Fluid Layouts and Flexible Units

What are fluid layouts and how do they differ from fixed layouts?

Introduction to relative units: %, em, rem, vh, vw

Creating Fluid Layouts: Using percentage-based widths

Using vh, vw for responsive font sizes and containers

Building a Responsive Grid: Using fluid grids with percentages

Module 5: CSS Flexbox for Responsive Design

Introduction to Flexbox and its properties

Why Flexbox is perfect for creating responsive layouts

Creating Flexible Layouts using Flexbox

Aligning items with justify-content, align-items, and align-self

Building a flexible navigation bar that adjusts for different screen sizes

Creating a responsive two-column layout using Flexbox

Working with Flexbox wrap: Adjusting content when the screen size is reduced

Module 6: CSS Grid for Responsive Design

Introduction to CSS Grid Layout and its usage for responsive design

Grid vs Flexbox: When to use each

Setting up a Grid Layout with grid-template-columns and grid-template-rows

Creating a Responsive Grid that adapts to screen size changes

Building a two or three-column layout using CSS Grid

Working with Grid Items: Aligning and spanning items

Module 7: Advanced Media Queries

Using media queries for specific breakpoints

Understanding and working with orientation (portrait vs landscape)

Defining Multiple Breakpoints: Creating different layouts for mobile, tablet, and desktop

Orientation-based Media Queries: Designing layouts that change based on screen orientation (portrait vs landscape)

Testing responsiveness using Chrome Developer Tools and other tools

Module 8: Building a Responsive Navigation Bar

The importance of a responsive navigation bar

The concept of hamburger menus for mobile screens

Building a Simple Navigation Bar: Horizontal and vertical navigation

Creating a hamburger menu using Flexbox and media queries

Making the navigation sticky at the top using position: sticky

Testing Navigation on multiple screen sizes and devices

Module 9: Responsive Typography

Importance of readable text on different screen sizes

Fluid typography using relative units

Setting Responsive Fonts: Using rem, em, and % for font-size

Responsive Heading Sizes: Using media queries to adjust heading sizes

Creating scalable text that adjusts based on viewport size

Module 10: Testing and Debugging Responsive Websites

How to test responsiveness and cross-browser compatibility

Testing Websites on Different Devices: Using Chrome Developer Tools to simulate mobile, tablet, and desktop screens

Cross-Browser Testing: Ensuring the website works on different browsers (Chrome, Firefox, Edge)

Responsive Design Tools: Using tools like BrowserStack or Responsinator for device testing

Module 11: Final Project - Building a Fully Responsive Website

Overview of the steps for building a responsive website

Planning and Designing a responsive website layout (Home Page, About, Services, Contact)

Building a Full Website using HTML, CSS, Flexbox, and CSS Grid

Integrating Responsive Navigation (Hamburger Menu)

Making the Website Fully Responsive: Testing across all devices and screen sizes

Final Project Submission: Complete responsive website with all elements

Assessment and Certification:

Practical Exams: Students will be evaluated based on their ability to create responsive layouts using Flexbox, CSS Grid, and Media Queries.

Final Project: Students will build a fully responsive website as their final project.

Certification: Upon completion of the course and final project, students will receive a Responsive Web Designing Certificate.

Additional Notes:

Encourage students to practice building real websites using responsive design principles throughout the course.

Provide real-world examples of responsive websites for inspiration.

Continuous feedback on design choices and code practices to improve their skills.

HTML

Module 1: Introduction to HTML

HTML क्या है और इसकी जरूरत क्यों है?

Static और Dynamic Web Pages का अंतर

HTML Document Structure (Basic Skeleton)

Web Browsers और HTML

Module 2: Basic HTML Elements

HTML Tags और Attributes

Headings (<h1> to <h6>)

Paragraphs (<p>)

Line Breaks और Horizontal Rules (<br>, <hr>)

Formatting Tags (<b>, <i>, <u>, <strong>, <em>, <mark>, <small>)

Module 3: Links and Navigation

Anchor Tag (<a>) और Hyperlinks

Internal vs External Links

Open Link in New Tab (target="_blank")

Email और Phone Link बनाना

Module 4: HTML Lists

Ordered List (<ol> & <li>)

Unordered List (<ul> & <li>)

Definition List (<dl>, <dt>, <dd>)

Nested Lists

Module 5: Images and Multimedia

Image Tag (<img>), alt और title Attributes

Image Formats (JPG, PNG, GIF, SVG, WebP)

Video Embed (<video> Tag)

Audio Embed (<audio> Tag)

YouTube Videos को Embed करना

Module 6: HTML Tables

Table Structure (<table>, <tr>, <td>, <th>)

Table Borders और Styling

Row और Column Merging (rowspan, colspan)

Responsive Tables

Module 7: Forms and User Input

Form Tag (<form>) और Attributes

Input Fields (<input> Types: text, password, email, number, etc.)

Labels (<label>) और Placeholders

Radio Buttons और Checkboxes

Dropdown (<select> और <option>)

Textarea और Submit Button

Form Validation (Basic)

Module 8: Semantic HTML & Accessibility

Semantic Tags (<header>, <nav>, <section>, <article>, <aside>, <footer>)

SEO Friendly HTML Writing

Screen Readers के लिए HTML Optimization

Module 9: HTML5 Advanced Features

HTML5 Structural Elements

Canvas और SVG Basics

Local Storage और Session Storage

Geolocation API

HTML5 Form Enhancements

Module 10: Responsive Web Design (Basics)

Meta Viewport Tag

Media Queries (CSS Basics)

Mobile Friendly HTML Structure

Module 11: Project & Final Assessment

एक Simple Website बनाना

Best Practices और Code Optimization

Final HTML Quiz और Certification

CSS

Module 1: Introduction to CSS

What is CSS, and why is it needed?
Types of CSS:
- Inline CSS
- Internal CSS
- External CSS
CSS Syntax and Basic Structure
Advantages of Using CSS

Module 2: CSS Selectors & Properties

Basic Selectors:
- Element Selector (p {})
- Class Selector (.classname {})
- ID Selector (#idname {})
- Universal Selector (* {})
Advanced Selectors:
- Grouping Selector (h1, h2, h3 {})
- Attribute Selector (input[type="text"] {})
- Child & Descendant Selectors (div > p, div p)
Pseudo-classes & Pseudo-elements:
- :hover, :focus, :first-child, :last-child
- ::before, ::after, ::first-letter, ::first-line

Module 3: CSS Box Model

Margin, Padding, Border, and Content
Width and Height Properties
Box Sizing (content-box vs border-box)
Overflow (visible, hidden, scroll, auto)

Module 4: CSS Colors & Backgrounds

Color Formats (HEX, RGB, RGBA, HSL, HSLA)
Background Properties:
- background-color
- background-image
- background-position
- background-size
- background-repeat
Opacity and Transparency

Module 5: CSS Typography

Font Properties (font-family, font-size, font-weight)
Text Properties (text-align, text-transform, letter-spacing)
Line Height and Word Spacing
Google Fonts Integration

Module 6: CSS Flexbox (Responsive Layouts)

Introduction to Flexbox
Flex Container Properties:
- display: flex
- flex-direction
- justify-content
- align-items
Flex Item Properties (flex-grow, flex-shrink, flex-basis)

Module 7: CSS Grid (Advanced Layouts)

Introduction to CSS Grid
Grid Container Properties:
- display: grid
- grid-template-columns & grid-template-rows
- grid-gap
- justify-items & align-items
Grid Item Properties (grid-column, grid-row, grid-area)

Module 8: CSS Positioning & Display

position Property (static, relative, absolute, fixed, sticky)
z-index and Stacking Order
display Property (block, inline, inline-block, none)
visibility vs display: none

Module 9: CSS Animations & Transitions

CSS Transitions (transition-property, transition-duration, ease-in-out)
CSS Animations (@keyframes, animation-name, animation-duration)
Transformations (rotate, scale, translate, skew)

Module 10: Responsive Web Design (RWD)

Introduction to Responsive Web Design
Media Queries (@media rules)
Mobile-First vs Desktop-First Approach
CSS Units (px, %, em, rem, vh, vw)
Viewport Meta Tag

Module 11: CSS Frameworks (Introduction)

Introduction to Bootstrap / Tailwind CSS
Using Predefined Classes
Grid System in Bootstrap
Responsive Components

Module 12: CSS Best Practices & Final Project

Writing Clean and Maintainable CSS
CSS Optimization Tips
Common CSS Mistakes to Avoid
Final Project: Building a Complete Responsive Website

JavaScript

Module 1: Introduction to JavaScript

What is JavaScript and why is it used?
JavaScript vs Other Programming Languages
Client-Side vs Server-Side JavaScript
Setting Up JavaScript in HTML (<script> Tag)
Writing JavaScript in External Files

Module 2: JavaScript Basics

Variables and Constants (var, let, const)
Data Types in JavaScript (string, number, boolean, array, object)
Operators (+, -, *, /, %, ++, --, +=, -=, etc.)
Comments in JavaScript
String Manipulation and Template Literals

Module 3: Control Structures (Conditions & Loops)

Conditional Statements (if, else if, else, switch)
Looping Statements (for, while, do-while)
break and continue Statements
Nested Loops and Conditions

Module 4: Functions in JavaScript

Defining and Calling Functions
Function Parameters and Return Values
Arrow Functions (()=>{})
Function Expressions
Callback Functions

Module 5: JavaScript Arrays & Objects

Creating and Accessing Arrays
Array Methods (push, pop, shift, unshift, splice, slice, map, filter, reduce)
Creating Objects and Accessing Properties
Object Methods
JSON Introduction and Parsing

Module 6: DOM (Document Object Model) Manipulation

Understanding the DOM Tree
Selecting Elements (getElementById, querySelector, querySelectorAll)
Changing Content and Attributes (innerHTML, textContent, setAttribute)
CSS Manipulation using JavaScript
Creating and Removing Elements (appendChild, removeChild)

Module 7: Event Handling in JavaScript

Adding Event Listeners (click, mouseover, keydown, keyup, submit)
Event Bubbling and Capturing
Preventing Default Actions (event.preventDefault())
Keyboard and Mouse Events

Module 8: JavaScript Timing Functions

setTimeout and setInterval
Stopping Timers (clearTimeout, clearInterval)
Animation using JavaScript

Module 9: JavaScript Form Validation

Validating Text, Email, Password, and Number Fields
Regular Expressions (RegExp) in JavaScript
Showing Error Messages Dynamically
Preventing Form Submission on Errors

Module 10: JavaScript ES6+ Features

Template Literals
Destructuring Arrays and Objects
Spread and Rest Operators (...)
Promises and Async/Await
Modules (import and export)

Module 11: Introduction to AJAX & Fetch API

What is AJAX?
Fetch API vs XMLHTTPRequest
Handling JSON Data from APIs
Asynchronous JavaScript Execution

Module 12: Introduction to JavaScript Libraries & Frameworks

Introduction to jQuery
Introduction to React.js (Basic Concepts)
Using External JavaScript Libraries

Module 13: JavaScript Project & Best Practices

Creating a Mini JavaScript Project (To-Do List, Calculator, etc.)
JavaScript Best Practices
Debugging JavaScript Code
Final Assessment and Certification

Google Docs

Module 1: Introduction to Google Docs

Overview of Google Docs interface
How to create, open, and save documents
Exploring document templates
Basic formatting: Text style, font size, and alignment
Using the toolbar: Cut, copy, paste, and undo/redo
Inserting text, images, and links
Using voice typing and basic accessibility features

Module 2: Formatting and Styling Documents

Advanced text formatting (bold, italics, underline, strikethrough)
Paragraph formatting: Indentation, line spacing, and lists
Working with headers, footers, and page numbers
Inserting tables and adjusting columns/rows
Using section breaks and page layout options

Module 3: Collaboration Tools and Sharing

Sharing documents with others: Public, private, and link-sharing options
Setting permissions: Viewer, commenter, and editor
Real-time collaboration: Editing, commenting, and suggesting mode
Using Google Docs chat and comment features effectively
Revision history and version control

Module 4: Working with Styles and Formatting Tools

Using and customizing paragraph styles (Heading 1, Heading 2, etc.)
Creating a table of contents (TOC)
Inserting footnotes, endnotes, and citations
Page layout: Margins, orientation, and page size
Using Google Docs as a writing tool: Dictation, grammar check, and suggestions

Module 5: Advanced Features and Add-ons

Using Google Docs add-ons (e.g., Grammarly, EasyBib)
Inserting drawings and diagrams using Google Drawings
Adding charts and graphs from Google Sheets
Exploring Google Docs' integration with Google Slides, Google Sheets, and Google Forms
Using Google Keep for note-taking and task management

Module 6: Creating and Managing Documents for Business/Professional Use

Creating resumes, cover letters, and reports
Templates for business documents: Memos, newsletters, and brochures
Merging data with Google Sheets for mail merges
Using Google Docs for team projects: Setting deadlines and tracking progress

Module 7: Accessibility and Publishing

Setting up document accessibility features for different needs
Accessibility tools: Screen readers, voice commands, and braille displays
Converting Google Docs to PDF or other file formats
Publishing documents to the web or embedding them in websites

Module 8: Review and Hands-on Projects

Hands-on practice with all Google Docs features covered
Creating and sharing a collaborative document as a group project
Final exam or project submission (optional)

Google Sheets

Module 1: Introduction to Google Sheets

Overview of Google Sheets interface
How to create, open, and save spreadsheets
Exploring spreadsheet templates
Basic data entry and formatting
Using the toolbar: Cut, copy, paste, undo/redo
Working with rows, columns, and cells
Basic cell formatting: Font style, size, and color

Module 2: Data Formatting and Basic Functions

Number formatting: Currency, percentages, dates, etc.
Text formatting: Alignment, wrapping text, merging cells
Using basic functions: SUM, AVERAGE, COUNT
Introduction to cell references (relative, absolute, mixed)
Working with data types: Text, numbers, dates, and times

Module 3: Working with Formulas and Functions

Using more advanced functions: IF, VLOOKUP, HLOOKUP
Nested functions and combining formulas
Data validation: Dropdown lists, data restrictions
Using conditional formatting to highlight data
Creating simple calculations using formulas

Module 4: Managing Data and Organizing Sheets

Sorting and filtering data
Using multiple sheets within a single spreadsheet
Protecting ranges and sheets to control editing
Grouping and ungrouping rows and columns
Using named ranges to simplify formulas

Module 5: Advanced Functions and Features

Working with pivot tables and charts
Using the QUERY function for complex data extraction
Importing data from other sheets and external sources
Advanced date and time functions
Using array formulas for efficient calculations

Module 6: Collaboration and Sharing in Google Sheets

Sharing spreadsheets with others: Permissions and access settings
Collaborating in real-time: Commenting, suggesting, and editing
Using Google Sheets' version history and restoring previous versions
Embedding Google Sheets into websites or presentations
Exporting and importing data from different formats (CSV, Excel, etc.)

Module 7: Data Visualization and Reporting

Creating charts and graphs: Bar, line, pie, etc.
Customizing chart styles and colors
Using sparklines for small data visualizations within cells
Adding annotations and titles to charts
Using Google Sheets as a reporting tool for data analysis

Module 8: Review and Hands-on Projects

Hands-on practice with all Google Sheets features covered
Creating and sharing a collaborative spreadsheet as a group project
Final exam or project submission (optional)

Google Slides

Module 1: Introduction to Google Slides

Overview of Google Slides interface
Creating, opening, and saving presentations
Exploring slide templates and themes
Adding text, images, and shapes to slides
Using the toolbar: Basic formatting and alignment tools
Navigation between slides and organizing content

Module 2: Slide Layouts and Customization

Choosing and customizing slide layouts
Creating custom slide backgrounds
Adjusting slide size and orientation
Inserting and modifying shapes, icons, and lines
Using the master slide for consistent design

Module 3: Text and Media in Google Slides

Adding and formatting text boxes
Using bullet points, numbered lists, and text alignment
Inserting images, videos, and audio
Embedding links to external websites and documents
Working with charts and tables in slides

Module 4: Animations and Transitions

Adding slide transitions: Fade, slide, and other effects
Animating text and objects on slides
Customizing animation timing and order
Using motion paths and effects for more dynamic presentations
Previewing and adjusting animations for smoother flow

Module 5: Collaboration and Sharing

Sharing presentations with others: Permissions and access settings
Real-time collaboration and simultaneous editing
Using comments and suggestions in collaborative presentations
Using Google Slides on mobile devices for collaboration
Presenting and controlling slides remotely with a mobile device

Module 6: Advanced Features and Add-ons

Using Google Slides add-ons for enhanced functionality
Embedding Google Forms, Sheets, and YouTube videos into slides
Incorporating live data from Google Sheets into slides
Creating and using templates for consistent slide designs
Mastering keyboard shortcuts for efficient slide creation

Module 7: Presenting with Google Slides

Setting up presentation settings (auto-advance, timing, etc.)
Using presenter notes to guide your presentation
Presenting remotely using Google Meet or other platforms
Sharing slides with audience members and embedding presentations
Creating interactive presentations with clickable elements and hyperlinks

Module 8: Review and Hands-on Projects

Hands-on practice: Creating a full Google Slides presentation from scratch
Incorporating multimedia, animations, and transitions
Group project: Collaborative Google Slides presentation
Final project submission and/or presentation

Google Chart

Module 1: Introduction to Google Charts

Overview of Google Charts and its applications
Understanding the Google Charts API
Setting up and embedding Google Charts in web pages
Exploring different types of charts: Bar, Line, Pie, etc.
Basic chart creation: HTML, JavaScript, and Google Visualization API

Module 2: Basic Chart Types and Customization

Creating basic charts: Line, Bar, Column, and Pie Charts
Customizing chart titles, labels, and tooltips
Changing chart colors and styles
Understanding chart axes and data series
Using Google Charts’ built-in theme and style options

Module 3: Advanced Chart Types and Features

Working with GeoCharts and maps
Creating Gauge charts and Combo charts
Interactive charts with drilldowns and data selection
Using time series and trend lines in charts
Implementing annotations and highlighting data points

Module 4: Data Handling and Formatting in Google Charts

Feeding data into Google Charts from different sources (e.g., arrays, Google Sheets, JSON)
Handling large datasets with Google Charts
Formatting numbers and date/time values in charts
Customizing chart data labels and legends
Using dynamic data updates in real-time charts

Module 5: Google Charts and Google Sheets Integration

Importing data from Google Sheets into Google Charts
Creating live-updating charts from Google Sheets
Chart customization using data directly from Sheets
Visualizing Google Sheets data in interactive charts
Embedding Google Charts into Google Sites or web pages

Module 6: Interactivity and User Input

Adding interactive features to charts (e.g., click events, hover events)
Using drop-down menus and controls to filter data in charts
Integrating Google Charts with Google Forms for data collection
Creating dashboard-style interfaces with multiple charts
Using Google Chart controls for chart interactivity

Module 7: Customizing and Styling Charts

Styling charts with custom colors, fonts, and themes
Adding custom tooltips and hover effects
Using JavaScript to create complex, dynamic charts
Customizing chart axes and gridlines
Using CSS to style charts and control layout

Module 8: Review and Hands-on Projects

Hands-on practice creating and customizing charts
Creating a final interactive dashboard using Google Charts
Project submission and/or presentation

Revision and Project Report with GST

Module 1: Introduction to GST

Overview of Goods and Services Tax (GST)
History and evolution of GST in India
Key features of GST: Dual GST Model (CGST, SGST, IGST)
Understanding the GST Council and its functions
Types of GST: CGST, SGST, IGST, and UTGST
Importance and impact of GST on businesses and consumers

Module 2: GST Registration and Compliance

Eligibility for GST registration
GST registration process: Steps and requirements
GSTIN (GST Identification Number) and its significance
Types of GST returns and their filing procedures
Due dates for GST return filings
Penalties for non-compliance with GST regulations

Module 3: GST Tax Structure and Rates

Overview of GST tax rates: 5%, 12%, 18%, and 28%
Exemptions and concessions under GST
Understanding GST on goods vs. services
GST on imports and exports
Composition Scheme under GST
Reverse Charge Mechanism (RCM) and its implications

Module 4: Input Tax Credit (ITC)

Concept of Input Tax Credit (ITC)
Eligibility for claiming ITC
Conditions for availing ITC
How to claim and utilize ITC in GST returns
Blocking/unblocking of ITC claims
Common issues related to ITC and their resolutions

Module 5: GST Invoicing and Documentation

Importance of GST-compliant invoices
Types of invoices: Tax invoices, Bill of Supply, Debit/Credit Notes
GST invoice format and required details
GST e-way bill: Purpose, generation, and requirements
Documentation for GST audits and assessments
Maintaining records for GST purposes

Module 6: GST Audit and Assessment

Overview of GST audit procedures
GST assessment types: Self-assessment, provisional assessment
GST audit report and filing
Role of the GST auditor and responsibilities
GST audit checklist and common mistakes to avoid
Dealing with GST disputes and appeals

Module 7: GST Impact on Business and Economy

Impact of GST on small, medium, and large businesses
GST and its role in simplifying indirect taxes
GST and its effects on pricing, competition, and supply chains
GST and its impact on exports and imports
Case studies of GST implementation in different sectors

Module 8: Revision and Project Report

Comprehensive revision of all topics covered in the course
Discussion of key GST concepts, calculations, and compliance
Project Report Guidelines: Research on the impact of GST on a selected business sector
Project Report Structure: Introduction, Analysis, Conclusion, and Recommendations
Presentation and submission of project reports
Final assessment based on the project and report findings

GIT Padrauna

Advance Diploma in Computer Application

Course Curriculum

Computer Fundamental

Windows 11

Microsoft Word 365

Microsoft Excel 365

Microsoft PowerPoint 365

Typing in Hindi & English

Computer Hardware

Application of Internet & Email System

Basic of Financial Accounting

Goods and Services Tax (GST)

Tally Prime with GST

Video Conferencing

Cloud Storage and File Sharing

Microsoft Access 365

Microsoft Outlook 365

Responsive Web Designing

HTML

CSS

JavaScript

Google Docs

Google Sheets

Google Slides

Google Chart

Revision and Project Report with GST

Gayatri Institute of Technology

Contact

Company

Our Features

Advance Diploma in Computer Application

Course Curriculum

Computer Fundamental

Windows 11

Microsoft Word 365

Microsoft Excel 365

Microsoft PowerPoint 365

Typing in Hindi & English

Computer Hardware

Application of Internet & Email System

Basic of Financial Accounting

Goods and Services Tax (GST)

Tally Prime with GST

Video Conferencing

Cloud Storage and File Sharing

Microsoft Access 365

Microsoft Outlook 365

Responsive Web Designing

HTML

CSS

JavaScript

Google Docs

Google Sheets

Google Slides

Google Chart

Revision and Project Report with GST

Subscribe Our Newsletter

Gayatri Institute of Technology

Contact

Company

Our Features