Diploma in Computer Application - DCA

IT/Digital Era - Entering into Computer World Keep your Data (Storage Device)

• Computer Definition & Features
• Application of computer
• How to start Computer
• login screen - user & Password
• Desktop- Taskbar, Wallpaper, Icons
• How to start paint, some basic tools

• Computer Architecture Diagram
• Father of computer
• Devices of computer: Input, output & processing Memory Unit(MU)
• Primary memory, Secondary memory
• Unit of measurements
• Hardware & Software
• File & folder

Find your Space in Computer (File & Folder)

• Window explorer , File & folder

Searching : Find your File/Folder Wild Cards

• Extensions of program
• Wild card Asterisk(*), Question mark(?)
• Searching for file and folder

1.Start your Career - CV/Resume Creation

• Definition, Feature
• How to start Ms Word
• File, font group

2.Beautifying your CV/Resume (Formatting)

• Quick Access Tool Bar
• Paragraph Group, Clipboard group, Editing group

3.Letterhead - Show case of Your Company

• Insert tab: Header & footer group
• Date & Time, Symbol Picture
• Home tab: change Case, Border & Shading

4.News Paper & Magazine Creation (Column)

• Page layout tab: columns, column break
• Insert tab: Drop cap, Book cover
• file:Auto correct
• Review tab: Word Count, Spell Check, Thesaurus

5.Create your Own Book

• Refrence tab: Insert endnotes, Insert footnotes, table of content
  watermark, Hyphenation

6.Links and Security

• Refrence tab: Insert caption, index entry,
• Links: Booksmarks, Hyperlink, cross Reference
• Review tab: Track changes, Protect document

7.Connect your Customer (Bulk Mailing)

• Mail Merge , Main document & Data source

8.Connect your selected customer(Record filtration)

• Sorting of Record
• Filter of Record
• Lables
• Envelope

9.Mark sheet Creation (Tabular format data )

• Insert table, Draw table
• Layout tab
• Design tab

10.Document is ready to print/Record your actions

• Page setup
• Print preview
• Print
• Macro

1.World of Row and Column - First interaction with excel

• Introduction of excel, Workbook, Worksheet, Row, Column, Cell, type of entries
• Home tab: Cell group, Font group, Alignment

2.Invoice / Bill of Supply

• Type of Reference : Absolute, Relative
• Basic formulas
• Sum, Product, Minus, Quotient, Mod, Percentage)

3.Result Declared (Automatic Calculation)

• Function

4.Secure your Data/ Lock your data/ Restrict editing

• Styles group :  Format as table, Conditional Formatting, Cell styles
• Protection: Track Changes, Protection

5.Data Analysing Tool (Expense Limit & Comparision)

• What if Analysis: Goal seek, Scenario, Data table

6.Pictorial Representation of Data (Chart Magic)

• Pictorial Represntation of data
• Chart, type of chart, formatting of charts

7.Organize your Data (Easier to Analyze)

• Data validation, Data filtration, sort, subtotal

8.Analyzing Complex Data (Pivot Table)

• Logical function: if and, if or
• Pivot table, Pivot chart, Paste special

9.Lookup & Reference , Extract Your Data

• Lookup functions : lookup, vlookup, hlookup
  match, index

10.Data is ready to Print /Page Setup

• Page setup
• Print preview

1.Welcome to Presentation World

• PowerPoint - Definition feature, purpose ,view of slides
• Home tab-slide group

2.Beautifying presentation (Formatting of presentation)

• Font & Alignment Group
• Inset tab - Illustration group
• Themes & Background

3.Masters of Slide/ Slide Automation

• Masters
• Animation(triggers
• Transition
• Hyperlink, Actions
• Slide background

4.Its presentation time now

• Slide show tab - From beginnng, from current slide, Custom slide show,setup slide, Hide slide, Record narratio, Rehearse timing, slide show
• Inset tab- photo album

5.Advance feature of Presentation

• Running Clock, Moving Car, Making Picture, Bouncing Ball

1.World of Internet 

• Internet introduction & Benefit
• Computer Network: LAN, WAN, MAN
• Services of internet
• Search engine, Web browser

2.Online Communication

• Inbox , Reply, Forward, composing, Attachments of file,
  Change password(setting of E-mails) , Facebook account handling, 
  Facebook page creation

3.Downloads/Booking

• Ticket Reservation & Booking, Online shopping, Online Bill payment, Book movie ticket
• Download: Image, font style, app, pdf, song, movie

4.Digital India

• Cash less society
• E-wallets, UPI, Plastic money, USSD, Net Banking

1.My Business Card

• Document (Page Setup), Size of Business Card
• Tools (Selection, Direct Selection , Shape Tool(Rectangle, Ellipse, Polygon)
• Shapes Property Fill Color & Outline Color
• File Menu New, Open, Save, Save as, Exit

2.Typography

• Tools Gradient, Text Tool & its properties, Type on Path Tool
• Object Menu Arrange, Group, Ungroup, Lock, Unlock
• Place Image

3.Magazine Cover

• Tools Text tool, Gradient Tool
• Layout Menu Ruler Guides, Create Guides, Layout Adjustment
• Object Menu Effects

4.Stylish Brochure Template

• Tools Frame Tool (Ellipse, Rectangle, Polygon), Eye Dropper, Pen, Pencil, Eraser, Line
• Object Menu Corner Options, Pathfinder"
• Layout Menu Columns, Ruler Guides, Create Guides, Layout Adjustment

5.Books & News Paper Publishing

• Layout Menu Add Page, Go to Page, Edit In Story, Auto flow
• Page Pallete Insert Page Number, Master Page
• Type Menu Drop Cap, Bullets & Numbering, Alignments

6.Indexing

• Type Menu Character, Paragraph, Table & Object style
• Layout Menu Table Of Contents

7.Design & Database Fusion-Merging

• Window Menu Data Merge
• File Menu Export

8.Mail and Print

• Types of Printing
• File Menu Export, Print

1.Layering - Backbone Of Picture /Photo

• Intro Photoshop, Application of Photoshop
• Difference Between Image & Layer
• Color Foreground & Background
• Tools Move, Marquee, Zoom, Hand
• File Menu New, Open, Save

2.Play With Background

• Tools Pencil tool , sharpen , smudge , dodge
  ,burn , sponge , Lasso, Magic Wand, Crop, Slice
• Layer pallete new, duplicate,delete,
• Image menu color balance, hue & saturation

3.Masking (Amazing creativity)

• Tools Brush tool
• Layer Menu Layer Mask, Vector Mask, Clipping Mask
• Filter Menu Effects

4.Movie Poster Making

• Gradient ,eraser , paint, bucket, eye dropper
• Layer menu layer style ,merge visible, merge down, flattern 

5.Wedding Album

• Tools  Pattern Stamp, History Brush, Art History Brush
• Layer Menu Masking

6.Logo Creation

• Tools Text and its Parts
• Image Menu modes (RGB, CYMK ,Grayscale)
• Shape Tools Custom Shape Tool, Other Shapes

7.Day to Night Conversion , Water Ripple

• Tools Pen, Path Selection, Direct Selection
• Edit Menu Define Brush
• View Menu Ruler

8.Retouching Image

• Tools Healing Brush, Patch, Clone Stamp, History Brush, Smudge
• Layer Pallate Blending Modes

9.Light & Glow

• Filter Menu Extract, Liquefier, Distort, Stylize, Artistic Gallery
• Layer Pallate Blending Modes

10.Animated Photo & Waterfall

• Layer Pallete Adjustment Layer
• Image Menu Adjustment
• Window Menu Animation (Frames , Timeline)

11.Web Layout/Thumbnail

• Filter Menu Vanishing Point
• Edit Menu Free Transform

12.Passport Size Photos

• File Menu Automate (Batch Create Droplet, Conditional Mode Change, Fit Image, Photo Merge, Crop & Straighten Photo, Picture Package, Contact sheet II Action)
• Layer Menu Smart Object

13.2D Painting

• Image Menu Adjustment Options
• Layer Menu Blending Options

1.Masking

• Intro of Illustrator, Document (page Setup)
• Tools Selection Tool, Direct Selection Tools, Shape Tool(Rectangle, Rounded Rectangle, Ellipse, Polygon), Bloat Tool, Warp Tool
• Shape Property Fill Color & Outline Color
• Clipping Mask

2.Logo Creation

• Tools Gradient, Pen Twirl, Pucker, Scalop , Crystalize, Wrinkle, Group Selection, Magic Wand, Lasso
• Object Menu Arrange Group, Ungroup, Lock, Unlock, Hide, Show
• File Menu Place Image

3.Create Your Own Pattern / Now Your Creativity

• Tools Text & Its Part, Line Segment, Arc, Spiral, Polar Grid, Rectangle Grid,
• Symbol & Its Part, Shape Bulider tool ,object menu :Blend

4.Floral Vector

• Tools Brush, Pencil, Smooth, Path Eraser, Rotate, Reflect
• Object Menu Blend Option
• Effects Menu Distort & Transaction
• Window Menu Align, Gradient, New Brush

5.Social Media Post

• Tools Scale, Shear Text tool, Gradient tool
• Object Menu Clipping Mask
• Effects Menu Photoshop Effects

6.Boucher /Flyer Designing

• Tools Shapes, Pen tool, Gradient
• Type Menu (Font, Recent Fonts, Size, Glyphs, Area Type options, Type on a path, Create Outlines, Find Fonts, Change Case
• Object Menu Clipping Mask
• View Menu Ruler Guide

7.3D Fun

• Effects Menu 3D > Extrude And Bevel
• Tools Eraser, Hand, Zoom, Star, Flare
• Edit Menu Copy, Paste in Front, Paste in Back , Key board shortcuts

8.Beautiful Flower pot With Symbol

• Object Menu Expand & Expand Appearance
• Effects Menu 3D > Revolve
• Tools Shapes, Pen Tool, Star, Flare

9.Funny Hairy Text (Effect)

• Effect Menu Distort and Transaction, Pathfinder
• Object Menu Blend Options

10.Portrait (Vector Art)

• Tools Pen tool, Pencil Tool
• Object Menu Live Trace
• Effects Menu Illustrator Effects, Convert To Shape, Distort & Transform, Stylize

11.Landscape ( Scenery)

• Effects Menu Photoshop Effects( Noise , Flim Grain ,Grain, etc)
• Tools:- pen tool , Brush Tool
• Object Menu :- Path , Offset Path

12.Mandala Art (Graphics)

• Window Menu Pathfinder, Swatches, Transform, Transparency, Creating Symbols
  Brush Pallete & Creating Brush,

13.Smart Features

• Window Menu  Align, Appearance & Creating Texture Using Appearance, Graphic Style, etc

14.Car Parking ( Smart Features)

• Theory - Revision (Assignment Solve)
• Practical Day - Written Test

1.Learn Web Development 

• HTML Basic Intro and Version
• Elements & Tags , Types of elements(Empty and Container)
• Basic HTML element, Hgroup
• Element(H1 to H6)

2.Styles your webpage

• Using Font Element & Its Attributes
• Styles Element (B,I,U,SUB,SUP,EM,MARK)
• Paragraph Element ,Contents Editable
• Center Element, BR element

3.News Section/Digital Showroom

• Image Element, Image Placeholder, Image Map
• Quotation Element (q , bdo , abbr, address)
• Marquee Element

4.Landing Site/Linking 

• Types of Linking : (Local, Interrnal, External, Download, Mail)
• Anchor Element and its Atributes

5.Count The Points

• Order List , Unorder List, Nested List
• Definition List

6.Result Declaration

• Table Element
  Its Components (TR, TH, TD)
  Its Attributes
• Rows &column Merge, Caption Element

7.Framing

• Frameset Element
  Frameset Rows, Frameset Cols, Frame Src ,
• Iframe Element

8.Video/Audio Gallery

• Use Video Element And Audio Element

9.Enquiry Form/Lead Generation

• Form Element
• Input Element And Its Type
  (Text, Radio, Checkbox, Number, range, Email, Password, Button, Submit, Reset, Image, File, Color, Date, Time, Date time-Local, Search)

10.Banking Form/KYC Form

• Form Element
• Advance Attribute of  Input Element (Autocomplete, Autofocus, Tab index, Required, Size, Step)
• Advance Form Element (Select, Text area, Field set, Legend) 

1.Dynamic Site

• CSS Introduction
• Types Of CSS
  (Inline CSS , Embedded CSS, Link/External CSS)

2.Blocks Creation

• DIV Element, Span Element , Margin, Padding, ID & Class

3.Background Magic

• Background Effects
• Background Properties
• Gradient Background
• Linear, Radial, Angular, Diagonal, Repeating
• Browser Supports Key

4.Customize Text

• Formatting Text Font Properties
• Text Properties Text-Overflow, Word-Break, Word-Wrap, Columns
• Border Effects Style, Width, Color

5.Designer List/Chart Library

• Modified List & Tables
  List Properties, Table Properties
• Shadow Effect Box-shadow, Text-Shadow
• Round Corners
• Div, Button etc 

6.Menu Bars/Google Map

• Creating Menu Bar, Anchor Properties, Transition Effects
• Hover Effect Text, Image

7.Timeline/Animated Webpage

• Animation/Transition
• 2D Animation And 3D Animation

Introduction Of  WordPress

• WordPress intro 
• Xmapp Intro
• Apace , SQL , Localhost 
• PHP,  my admin

Log-in Directory Interface

• Dashboard 
• Front end , Backend Appearance
• Theme , Site Identity

Menu/Page Creation 

• Page (Simple)
• ADD,
• Edit
• Delete
• Menu Location

Plugins

• About Plugins
• Download , Activate
• Elementor 
• (Text, Inner Section, Button Video , Heading ,Image)

Plugins(Form)

• Contact From , Short Code
• WP-from
• Gravity Form
• Formidable From
• Ninja From

Plugins(Gallery)

• Envira Gallery
• Nextgen Gallery
• Photo Gallery By Loweb
• Lightbox 
• Divi Gallery Extended

Widgets & Posts

• Widgets 
• Main, Secondary Post
• Add , Delete , Edit 
• Category
• Tags

Roles and Capabilities Of User

• Administrator , Super Admin 
• Author , Editor 
• Subscriber 
• Add Plugins 
• Easy Collage Plugins

Comments And Appearanc

• Comment 
• Moderate & Unmoderated 
• Hide Comments Appearance
• Style.CSS , 404 Template 

Website Completion

• Revision

Google Sites 

• Intro Of Google Sheet 
• Creation a Website

Advance In Google Sheet 

• Page Creation

Google Site With Google Other App

• Docs, Sheets , Sliders , Form