Syllabus of DOA

 

Diploma in Office Automation (DOA)

Duration:  9 Months

Fee:  Rs 5000/- only

Course Module



Semester-I (Notes, Video )

Fundamental

    • Introduction of Computer

    • Generation of Computer

    • Computer Hardware and Software

UI- User Interface

    • CUI based OS (Operating System)

    • GUI-based OS (Operating System)

OS- Operating System

    • MS-DOS

      • Introduction to Microsoft Disk Operating System-(MS-DOS)

      • Basic Internal and External Commands

    • Windows 7 / 10 / 11

      • What's new in Windows 11

      • Windows Start Menu

      • Fast Search

      • File Explorer

      • File folder management

      • Mouse Pointer

      • Windows Theme

      • Sticky Notes

      • Notepad

      • WordPad

      • Calculator

      • Desktop Personalize 

      • Mouse settings

      • Paint and Photo

    • Hardware maintenance

      • PC components Identification

      • Building PC

      • Introduction about Ports and Cable

      • System maintenance and troubleshooting 

Internet

    • Introduction to Internet

    • Using different Browser ( Edge, Chrome, etc)

    • Bookmarks and History

    • E-Mail

HTML- Basic

    • Introduction

    • Formatting of Text

    • Inserting Image

    • Creating List

    • Creating Links

Semester II

Microsoft Office Package

Microsoft Word 2021

      • Introduction to MS Word 2021

      • Working with Documents

      • Editing a document & Formatting Text

      • Formatting Paragraph, Table,

      • Mail Merge, Graphics, and Header & Footer

      • Page Layout and Page No

      • Project

Microsoft Excel 2021

      • Introduction to MS-Excel 2021

      • Screen Components and Windows Arrangement

      • Working With Workbook, Modifying Worksheet

      • Performing Basic Calculation

      • Working with Functions,

      • Data Sorting, Filter, and Pivot Table,

      • Chart and Graphics

      • Worksheet Organizing

      • Page Setup and Printing configuration

      • Project

Microsoft PowerPoint 2021

      • Introduction to MS-PowerPoint 2021

      • Concept of Slide and Presentation

      • Slide, Place holder, Graphics in Presentation

      • Slide Design and layout

      • Transition and Animation

      • Slide show and slide Timing

      • Project

Database

Microsoft Access 2021

      • Introduction to MS-Access

      • Database Term

      • Data Type

      • Table, Form, Query, Report

      • Relationship

Semester-III

Accounting Introduction

  • Financial Accounting Concept

  • Introduction of Book Keeping and Accountancy

  • Type of Accounts

  • Process of Accounting

  • Debiting and Crediting Rules (Golden Rule)

Accounts Only in Tally Prime

    • Company Concept in Tally

    • Group, Ledger, and Voucher

    • Ledger Creation and Alteration

    • Voucher Entry

      • Contra Voucher (Banking Module)

      • Purchases Voucher

      • Sales Voucher

      • Payment Voucher

      • Receipt Voucher

      • Journal Voucher

    • Reports

      • Day Book

      • Purchases Register

      • Sales Register

      • Journal-Register

      • Ledger

      • Groups

Accounts With Inventory

    • Introduction to Accounts with Inventory

    • Stock Group

    • Stock Categories

    • Stock Item

    • Unit of Measure

    • Godowns

    • Inventory Voucher Entry

      • Receipts Notes

      • Purchases Bill Pending

      • Purchases Invoice Entry

      • Rejection Out

      • Debit Notes

      • Delivery Notes

      • Sales Bill Pending

      • Sales Invoice

      • Rejection In

      • Credit Notes

      • Stock Journal

      • Physical Stock Transfer / Multiple Godown

      • Consumption and Production

    • Reports

      • Stock Summary

      • Godown Summary

      • Purchases and Sales bill Pending

      • Stock Query

      • Day Book

      • Purchases Register

      • Sales Register

      • Stock Journal Reports

      • Invoice Printing

Goods and Services (GST)

    • Concept of GST

    • Concept of Inter-State and Intrastate Trading

    • ITC (Input tax credit)

    • GST Enable in Tally

    • Tax Ledger Creation

    • GSTIN Concept, HSN SAC

    • GST Enable in Ledger

    • GST Rate and HSN/SAC setup

    • GST Registration Type

    • GST Purchases Entry

    • Sales with GST

    • Invoice Printing

    • GSTR 1, GSTR 2, GSTR 3B Report

    • Export Data for Tally to Excel