ADCA, Advance Diploma in Computer Application, is a diploma course (18 MONTHS ) in computer applications that include the study of numerous computer applications such as MS Office, Internet applications, operating systems, accounting, graphics such as Photoshop, Coral Draw, and web content such as HTML and CSS among other topics.
Diploma in Computer Application
Course Curriculum for Advance Diploma in Computer Application
- Operating System Basics
Desktop Environment:
1. Understanding the Start Menu and Taskbar.
2. Navigating system folders: Documents, Downloads, and Pictures.
File Management:
1. Creating, Renaming, and Deleting Files/Folders.
2. Understanding File Extensions and Types.
OS Applications : ms paint,notepad,wordpad - Microsoft Word
Home Tab:
Font Formatting: Bold, Italic, Underline, Font Size, and Color.
Paragraph Formatting: Alignment, Line Spacing, Indentation, Bullets,
and Numbering.
Styles: Applying and Modifying Styles.
Insert Tab:
Inserting Tables, Pictures, Shapes, and SmartArt.
Adding Headers, Footers, and Page Numbers.
Creating and Formatting Tables.
Design Tab:
Document Themes and Styles.
Page Backgrounds: Colors, Watermarks, and Borders.
Layout Tab:
Setting Margins, Orientation, and Size.
Paragraph Spacing and Indentation.
Column Layouts and Page Breaks.
References Tab:
Inserting Table of Contents, Footnotes, and Endnotes.
Adding Citations, Bibliography, and Captions.
Managing Sources and Cross-References.
Mailings Tab:
Creating Mail Merge Documents for Letters, Labels, and Envelopes.
Setting Up Recipients and Merging Fields.
Previewing and Completing the Mail Merge.
Review Tab:
Spelling & Grammar Check.
Using Thesaurus and Word Count.
Track Changes, Comments, and Comparing Documents.
View Tab:
Document Views: Read Mode, Print Layout, and Web Layout.
Show/Hide Ruler, Gridlines, and Navigation Pane.
Managing Windows: Split, Arrange, and Switch - Microsoft Excel
Introduction to Excel:
Understanding the Excel Interface: Ribbon, Workbook, Worksheets.
Basic Data Entry: Numbers, Text, Dates.
Formats of Cells:
Formatting Cells: Font, Alignment, Number, Border, Fill, and
Protection.
Conditional Formatting: Applying Rules, Using Data Bars, Color
Scales, and Icon Sets.
Working with Cells:
Inserting, Deleting, Merging, and Splitting Cells.
Protection of Excel Data: Locking Cells, Protecting Worksheets, and
Workbooks.
Working with Charts:
Creating and Customizing Charts: Column, Line, Pie, Bar.
Formatting Chart Elements: Titles, Legends, Axes, Data Labels.
Formulas and Functions:
Basic Arithmetic: SUM, SUBTRACTION, MULTIPLICATION, DIVISION.
AVERAGE Formula, RANK Function.
Conditional Functions: IF, COUNTIF, SUMIF.
Advanced Conditional Functions: COUNTIFS, SUMIFS with Multiple
Conditions.
Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP.
Fixing Formulas: Absolute and Relative References.
Financial Functions: PMT (Per Month Installment Calculation), Simple
Interest Calculation.
Running Total: Creating a Cumulative Sum.
Text Functions: CONCATENATE, LEFT, RIGHT, MID, UPPER, LOWER,
PROPER.
Rounding Functions: ROUND, ROUNDUP, ROUNDDOWN.
Worksheets:
Managing Worksheets: Inserting, Deleting, Renaming, Moving, and
Copying.
Formatting Worksheets: Headers, Footers, Page Setup, and Printing.
Practical Applications:
Mark Sheet Creation: Using Formulas to Calculate Totals, Averages,
and Grades.
Payroll Sheet Creation: Managing Salaries, Taxes, and Deductions.
Bills Creation with GST: Designing and Calculating Tax in Excel.
Attendance Sheet Format: Tracking and Analyzing Attendance Data - Microsoft PowerPoint
Creating Presentations:
Selecting Themes and Layouts.
Inserting and Formatting Text, Images, and Shapes.
Adding and Arranging Slides.
Design and Formatting:
Using Slide Master for Consistent Design.
Applying Transitions and Animations.
Customizing Slide Backgrounds and Themes.
Multimedia and Interactivity:
Embedding Videos and Audio.
Creating Hyperlinks and Action Buttons.
Designing Interactive Presentations.
Final Project:
Comprehensive Project Combining Word, Excel, and PowerPoint.
Creating Creative Templates and Resume Format in MS WORD
- HTML
What is HTML
HTML Documents
Basic Structure of an HTML Document
Creating an HTML Document
Mark up Tags
Heading and Paragraph
Line Breaks
Introduction to Elements of HTML
Working with Text
Text Formatting
1. Strong
2. Em
3. Ins
4. SuperScript
5. Subscript
Working with Lists, Tables, and Frames
Working with Hyperlinks, Images, and Multimedia
Working with Forms and Controls - CSS
CSS Introduction
Types of CSS
1. Inline
2. Internal
3. External
Combinators
1. Accessing Immediate Child
2. Accessing First Sibling
3. Accessing All Siblings
Pseudo Classes
Text Formatting
Background
1. Setting Background Color
2. Setting Background Image
3. Setting Multiple Background Images
4. Setting Gradient Color
Float
Position
1. Sticky
2. Fixed
3. Absolute
4. Relative
5. Static
Filters
Transformations
1. Rotations
2. Scaling
3. Skew
4. Translatory Motion using Translate
Animations - JavaScript
Introduction to JavaScript
Formulas
1. Addition
2. Subtraction
3. Multiplication
4. Division
5. Modulus
6. Power
Random Function
Conditional Statements
1. switch case
2. If Statement
3. Ladder If-Else 4. Statement
5. Nested If-Else
JavaScript Loops
1. For Loop
2. While Loop
3. Do While Loop
4. For Each
5. Break & Continue in Loop
JavaScript Alerts and Pop-ups
Events in JavaScript – Click, Blur , Change
1. Key Events
2. Mouseout
3. MouseOver
Scroll
4. EventListener
Form Validations
JavaScript Worksheet
Project - DHTML
Introduction to DHTML
Dynamic Content
CSS Positioning in DHTML
JavaScript for Interactivity
Combining HTML, CSS, and JavaScript for DHTML
Projects
- Adobe Illustrator
Introduction to Illustrator Interface
1. Understanding the workspace
2. Basic tools and panels overview
Creating Simple Vector Shapes
1. Drawing basic shapes (rectangle, ellipse, polygon)
2. Understanding paths and anchor points
Working with Colors
1. Fill and stroke colors
2. Color swatches and gradients
Basic Text Manipulation
1. Adding and editing text
2. Basic typography settings
Introduction to Layers
1. Understanding the layers panel
2. Organizing elements using layers - Adobe Photoshop
Introduction to Photoshop Interface
1. Navigating the workspace and tools
2. Understanding the toolbar and panels
Basic Image Editing
1. Cropping, resizing, and rotating images
2. Adjusting brightness, contrast, and color balance
Working with Layers
1. Creating, duplicating, and organizing layers
2. Understanding layer styles and blending modes
Basic Selection Tools
1. Using the Marquee, Lasso, and Magic Wand tools
2. Simple photo manipulations with selections
Text and Typography
1. Adding text to images
2. Basic text effects and styles - Adobe InDesign
Introduction to InDesign Interface
1. Understanding the workspace and tools
Creating and Saving New Documents
1. Working with Pages
2. Adding, deleting, and organizing pages
3. Master pages and page numbering
Text and Typography Basics
1. Creating text frames
2. Basic paragraph and character styles
Placing and Formatting Images
1. Placing images within a document
2. Basic image adjustments (fit, crop)
Creating Simple Layouts
1. Using grids and guides
2. Designing a basic magazine or brochure layout - Canva
Introduction to Canva Interface
1. Overview of the workspace and templates
Basic Tools and Elements
1. Creating Simple Designs
2. Using pre-made templates for social media, posters, etc.
3. Customizing text, colors, and images
Working with Elements
1. Adding and editing shapes, lines, and icons
2. Basic layering and grouping
Exporting and Sharing Designs
1. Saving and downloading designs in various formats
2. Sharing designs directly from Canva
- Introduction to Excel
Excel Interface Overview
1. Ribbon, Toolbars, and Key Shortcuts
2. Customizing the Excel Interface
Basic Excel Operations
1. Creating, Saving, and Navigating Workbooks
2. Understanding Cells, Rows, Columns, and Ranges
Arithmetic and Logical Operations
1. SUM, AVERAGE, MIN, MAX
2. IF, AND, OR, NOT
Text Functions
1. CONCATENATE, TEXTJOIN, TRIM, LEN
2. FIND, REPLACE, UPPER, LOWER
Data Entry Techniques
1. AutoFill, Flash Fill
2. Data Validation and Dropdown Lists
Formatting Techniques
1. Number Formatting, Custom Formats
2. Conditional Formatting Basics
Managing Worksheets
1. Adding, Deleting, and Moving Sheets
2. Grouping and Linking Worksheets
Introduction to Sorting and Filtering
1. Custom Sorts, Advanced Filters
2. Using Subtotals
Basic Charts
1. Creating and Customizing Charts
2. Using Sparklines for Data Visualization
Lookup & Reference Functions
1. VLOOKUP, HLOOKUP, XLOOKUP
2. INDEX and MATCH
Date & Time Functions
1. TODAY, NOW, DATEDIF
2. NETWORKDAYS, WORKDAY
New Excel Formulas in MS Office 2024
1. TEXTSPLIT: Splitting text strings into arrays.
2. TEXTBEFORE and TEXTAFTER: Extracting text based on delimiters.
3. LAMBDA: Creating custom functions.
4. o LET: Storing intermediate calculations and values.
5. o ARRAYTOTEXT: Converting an array to text format. - Advanced Sorting and Filtering • Sorting by Custom Lists
• Using Multiple Criteria in Filters • Data Cleaning Techniques
• Removing Duplicates
• Text to Columns for Data Parsing
• Using Flash Fill for Data Cleaning • Introduction to Pivot Tables
• Creating and Modifying Pivot Tables
• Grouping and Filtering Data in Pivot Tables • Advanced Pivot Table Techniques
• Calculated Fields and Items
• Slicers and Timelines
• Pivot Charts
• Creating and Customizing Pivot Charts
• Using Pivot Charts for Dynamic Reporting
• Advanced Conditional Formatting
• Using Formulas in Conditional Formatting • Icon Sets, Data Bars, and Color Scales
• Data Validation Techniques
INSTITUTE
• Custom Data Validation Rules
• Error Messages and Input Messages
• Power Query Basics
• Introduction to Power Query
• Data Import from Various Sources
TM
• Basic Data Transformation (Merge, Append)
• Cleaning Data with Power Query
• Advanced Data Manipulation
• Unpivoting Data
• Creating Custom Columns and Conditional Columns
• Advanced Charting Techniques
• Waterfall, Funnel, and Radar Charts
• Combo Charts with Secondary Axes
• Interactive Dashboards
• Creating Interactive Elements (Slicers, Buttons) • Linking Charts and Tables in Dashboards
1. Introduction of Tally
2. Basics of Accounting
3. Formation of company
4. Masters of tally
- Accounts info
- Single and multiple ledgers
- Alteration of ledgers
- Deletion of ledgers
- Groups of Tally
- Inventory details
- Stock groups, categories and stock items
5. Vouchers entries
- Company features details
- Payment, receipt, journal and contra
- Voucher mode and invoice mode
- Sale and purchase invoices
- Debit and credit notes details
- Order processing
- Purchase and sales order processing
- Purchase and sales challan
- Rejections
- Invoicing
- Returns and payments/receipts
- Modes of discounts
6. Manufacturing of goods
- Purchasing of goods
- Bills of material
- Voucher creations
- Manufacturing details
7. Payroll maintenance
- Employees group, categories
- Employees details
- Units
- Attendance heads
- Pay heads
- Attendance of employees
- Payroll voucher details
8. Analysis of data
- Balance sheet
- Profit and loss and trial balance
- Stock details and summary
- Day book
- Outstanding’s and payables analysis
- Godown management
9. Taxation
- Vat: payable, refundable and multi vat
- CST
- Service tax
10. GST (goods and services tax)
- Introduction of GST
- Establishment of tally
- Components of tally
- Dealers of market
- Rules and rates of GST
- Benefits of GST
- Statutory and taxation
- Goods and services treatment in tally
- Inter state
- Intra state
- Multi GST
- GST with discounts
- GSTIN details
- Printing of invoicing
- Analysis of GST
- Computation of GST
- Payment transaction of GST
11. TDS
12. Practical problems of tally
13. Worksheets
- Post dated voucher entry
- Interest calculation
- Job costing
- Cost centers
- Price level/multiple price level
- Sale of assets with depreciation
- Zero / actual valued
- Bills transection in voucher mode
- Export & import
- Company backup/ restore
- Logo
- Multi-Currency
- Invoice printing
- Cheque printing
MERN Stack Development: This well-liked open-source technology stack makes it possible to develop dynamic websites that are scalable, reliable, and effective. What is MERN stack? How does it function? How are these apps organized on the contemporary internet? How everything functions internally and how they are hosted. We’ll pay close attention and comprehend everything!
This course aims to give you the complete knowledge and practical skills what you need to design robust and scalable web applications, regardless of your level of experience Whether you’re a developer with experience hoping to upgrade your skills or someone just attempting to get started.
Tools and Technologies covered
MS Word
Excel
AI
HTML
Get Certified and Grow your career
You will receive a certificate from ESS Institute for completing the ADCA Computer course that will help you find the most relevant jobs like…
Applications support engineer, Computer Technician, Data Entry Operator, Application Support Executive, BPO Executive, Back Office Executive, Computer Operator, Clerk, Systems Officer, Computer Operator
Skills you will learn
MS Office, Internet Applications, Operating System, Accounting , Graphics such as Photoshop , coral draw, and web content like HTML and CSS
Job Opportunities
Graphic Designer, Web Developer, System Tester, Application Support, Executive, Web Designer, Computer Operator, Software Developer, Data Entry Operator.
Course For
Freshers, Students, Business Owners, Entrepreneurs
Minimum Eligibility
Candidates should beat least 17 years of age and should have passed Class X from any recognized board.
Enroll Now
Frequently Asked Questions
Look at the most common frequently asked questions of students in 2023-24
It is imperative that before learning the MERN stack, one has a basic understanding of web development. You must therefore have knowledge of HTML5, CSS3, and JavaScript before you can begin learning MERN Stack. Gaining these skill sets will help you learn MERN Stack more quickly as you work your way through its complexities. But if you are a beginner, it won’t be a big issue to get all these things. Your basics will be all cleared with in the course itself.
MERN Stack outperforms rival Stacks in Ul rendering and performance, is still fully open-source, and only requires JavaScript as its programming language. The JavaScript library/framework used by MERN Stack is React.js, as opposed to Angular.js, which is the only distinction between it and MEAN Stack. Therefore, the differences in Ul rendering and performance are found in the framework and library. Although the Angular.js framework and the React.js library are more recent, there are advantages and disadvantages to both. Additionally, Angular.js has a steeper learning curve than React.js, according to some programmers.
MERN Stack is a highly sought-after skill because creating modern web pages and applications is critical for almost every business, large or small. The technologies in this stack are the current industry leaders for dynamic and responsive JavaScript programming. If you’ve worked with other web stacks, learning MERN could be just what you need to advance your career. MERN is a great option if you’re learning web stacks for the first time because of its wide range of applications. MERN Stack developers frequently benefit from high beginning pay, remote work options, and chances for continued professional growth.