Course Overview
Diploma in Computer Application (DCA) at SPARC: The Diploma in Computer Application (DCA) at Sardar Patel Academy & Research Centre (SPARC)** is designed to help learners develop practical computer skills that are directly applicable in today's professional environment. Instead of limiting students to basic computer operations, the course focuses on building expertise across office productivity, creative design, web technologies, and digital communication.
Structured Learning Path : The curriculum follows a structured learning path, beginning with computer fundamentals and office applications such as MS Word, Excel, PowerPoint, Google Docs, Google Sheets, and Google Slides.As students progress, they gain hands-on experience in graphic design using Adobe Photoshop, Illustrator, InDesign, and Canva, followed by website development with HTML, CSS, JavaScript, and WordPress. The programme also introduces Filmora for video editing and AI-powered tools that improve productivity in modern workplaces.
Practical & Project-Based Learning: Every topic is taught through practical exercises, live assignments, and project-based learning so that students can confidently apply their knowledge in real-world situations.By the end of the programme, learners possess a balanced combination of technical, creative, and digital skills that are valuable across multiple industries.
Convenient Location: Conveniently located near GTB Nagar Metro Station in North Delhi, SPARC attracts students from GTB Nagar, Mukherjee Nagar, Kamla Nagar, Civil Lines, North Campus, and nearby areas who are looking for quality computer education with practical exposure.
Industry-Focused DCA Programme: If you want a comprehensive DCA programme that combines computer applications, office management, graphic design, web development, and video editing in one industry-focused curriculum, this course provides the right platform to begin your professional journey.
What You Will Learn
Industry-Ready Courses | Real-World Projects Based Training | Course Curriculum
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
- 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.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. Introduction to Canva
- Overview of Canva and its features
- Setting up a Canva account
- Navigating the Canva dashboard
2. Social Media Graphics
- Designing social media posts for Facebook, Instagram, Twitter, and LinkedIn
- Creating social media stories and ads
- Using Canva's social media templates and design tools
3.Presentations
- Creating engaging presentations for work, school, or personal projects
- Using Canva's presentation templates and design tools
- Adding text, images, and graphics to presentations
4.Infographics
- Visualizing data and information with Canva's infographic templates
- Designing and customizing infographics
- Using charts, graphs, and icons in infographics
5.Posters, Flyers, and Brochures
- Designing eye-catching posters for events, promotions, or advertising
- Creating flyers for events, businesses, or services
- Designing tri-fold or bi-fold brochures for marketing materials
6.Business Cards and Branding Materials
- Creating professional business cards with Canva's templates and design tools
- Developing brand guidelines, logos, and visual identities
- Designing letterheads, envelopes, and other branding materials
7.Videos and Animations
- Creating short videos or animations using Canva's video editing tools
- Adding text, images, and graphics to videos
- Exporting and sharing videos
8.Invitations and Advanced Topics
- Creating invitations for events, parties, or weddings
- Using advanced Canva features like custom fonts, illustrations, and animations
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
1.Introduction Of WordPress
- WordPress intro
- Xmapp Intro
- Apace , SQL , Localhost
- PHP, my admin
2.Log-in Directory Interface
- Dashboard
- Front end , Backend Appearance
- Theme , Site Identity
3.Menu/Page Creation
- Page (Simple)
- ADD,
- Edit
- Delete
- Menu Location
4.Plugins
- About Plugins
- Download , Activate
- Elementor
- (Text, Inner Section, Button Video , Heading ,Image)
5.Plugins(Form)
- Contact From , Short Code
- WP-from
- Gravity Form
- Formidable From
- Ninja From
6.Plugins(Gallery)
- Envira Gallery
- Nextgen Gallery
- Photo Gallery By Loweb
- Lightbox
- Divi Gallery Extended
7.Widgets & Posts
- Widgets
- Main, Secondary Post
- Add , Delete , Edit
- Category
- Tags
8.Roles and Capabilities Of User
- Administrator , Super Admin
- Author , Editor
- Subscriber
- Add Plugins
- Easy Collage Plugins
9.Comments And Appearanc
- Comment
- Moderate & Unmoderated
- Hide Comments Appearance
- Style.CSS , 404 Template
10.Website Completion
- Revision
11.Google Sites
- Intro Of Google Sheet
- Creation a Website
12.Advance In Google Sheet
- Page Creation
13.Google Site With Google Other App
- Docs, Sheets , Sliders , Form
Introduction to Filmora
- Overview of Filmora: Features and capabilities
- Installing Filmora: System requirements, download, and installation process
- Interface tour: Understanding the workspace, panels, and tool
Getting Started
- Creating a New Project
- Importing Media: Video, audio, and image files
- Organizing Media: Managing files within the software
Basic Editing Techniques
- Cutting, trimming, and splitting clips
- Adding Transitions: Applying transitions between clips
- Adding Text: Titles, subtitles, and captions
- Working with Audio: Adjusting volume, adding music, and sound effects
Advanced Editing Techniques
- Green Screen (Chroma Key): Removing background from footage
- Picture in Picture: Overlaying multiple videos
- Speed Control: Slow motion and fast-forward effects
- Color Correction: Adjusting brightness, contrast, and color balance
Effects and Filters
- Applying Filters: Presets and custom filters
- Adding Motion Graphics: Animated elements and overlays
- Using Effects: Special effects and visual enhancements
- Working with Layers: Overlaying multiple tracks
Exporting and Sharing
- Exporting Options: Formats, resolutions, and settings
- Rendering Process: Understanding the export process
- Uploading to Social Media: Sharing videos on platforms like YouTube, Facebook, and Instagram
Advanced Features (Optional)
- Audio Editing: Advanced audio manipulation techniques
- Keyframing: Creating animated movements and effects
- Advanced Transitions: Custom transitions and effects
- 3D LUTs: Applying color grading presets
Project Examples and Case Studies
- Step-by-step walkthroughs of editing projects
- Analysis of professional edits using Filmora
- Final Project
- Applying skills learned throughout the course to create a complete video project
1.Lets Upgrade Advance Skills
- Type Of Function
- Find, Concatenate , Length , Abs ,Round ,Roundup , Rounddown,
- Power ,Exact ,Left, Right, Trim, Find , Substitute , ABS , Text
2.Audit & Management Of Data
- Trace Precedent , Trace Dependent ,
- Remove Arrow , Error Checking ,
- Text to Column , Flash Fill,
- Data Validation , Remove Duplicate ,
- Consolidate
3.Salary Sheet
- Definition
- Salary sheet Calculation
- Pay slip
4.Dashboard
- Pivot Table
- Pivot Chart
- Slicer
- Timeline
- Value Function
- Convert Function
5.Loan Installment Sheet
- Financial Function
- PMT, NPER, PV , FV, RATE
6.Garbage Clearing
- If function in Loan Sheet
- Age Calculation
7.Working With Function
- Double Vlookup Function
- Vlookup With Match
- Vlookup With Hlookup
8.Xfunction
- If with Vlookup & Hlookup
- IF with Not
- Xlookukp Function
- XOR
9.Special Tools In Excel
- Name Manager
- Conditional Formatting
- Calendar
- Checkbox
10.Attendance Sheet
- If Error Function
- Eomonth Function
11.Trick & Techniques
- Basic Tricks
- Subtotal With Filter
1.Responsive Website
- Intro of Javascript
- How to Script Tags
- String Operator
2.Marksheet & Interest Calculation
- Operators
- String Operators
- Arithmetical Operators
- Conditional Operators
- Comparison Operators
3.Your Turn to Give Command
- Input Box
- Prompt()
- Data Type
- ParseIent()
- ParseFloat()
4.Online Entrance Exams
- Functions & Event
- Disabled Property
- Conditional statement
- Simple If
- If-Else
- Nested If
5.What Colour You Want
- Switch Case
- OnChanges Event
- document.Bgcolor
- document.Fgcolor
6.Check User Id & Password
- Functions
- Alert()
- Confirm()
- Validate Form
- OnLoad Event
- unOnLoad Event
1.Website Planning
- What are the websites and types of websites?
- Website Rough Layout Plan
- Elements of Website Pages Competitors Website Evaluation
2.Domain, Hosting And SSL
- Domain
- Hosting
- SSL
- Why it is important
- What are 3.O Domains &
- Hosting
3.WordPress Website Development
- Introduction to WordPress Installation of
- WordPress Content Creation in WordPress
- User Management
- Plugins in WordPress
- Themes in WordPress
- Menu and Widgets
- Finishing up the basic
- Projects
1.Canva
- Introduction of Canva
- Difference between the paid version and free version of Canvas
- Finding the right template designing for social media
2.Photoshop
- Photoshop
- Photoshop Basic
- Understand the Layer Panel
- The Selection Tools
- Shapes, Titles, and Text
- Layer Styles
- Gradients
Tools & Skills Covered
Get hands-on training in the most in-demand tools and real-world skills.
MS- POWERPOINT
MS -Excel
MS- Word
Google Sheets
Google Docs
google slides
Window
Internet
Chat-GPT
All Tools
Claude -AI
Google Gemini
The SPARC Advantage
Project-Based Training— project-based live classes with real-time examples, monitored and scheduled through our Class Status Sheet (CSS) system so no class goes untracked.
Project Based Training
Every module includes practical assignments and live projects, helping you apply your learning while building a professional portfolio.
Affordable Fees
We offer industry-relevant training at affordable fees, making quality education accessible without compromising on practical learning.
CSS Based Classes
Track your daily progress, completed topics, assignments, and upcoming lessons through our organised class status system.
Mobile Application
Access study materials, assignments, recorded resources, and course updates anytime through our dedicated mobile application.
Job Placement
Get placement assistance, interview preparation, resume guidance, and career support to help you begin your professional journey.
Study Material
Our research-based study materials are created by SPARC's in-house publication team to provide accurate, up-to-date, and industry-relevant content. Each module is designed to support practical learning and help you understand every topic with clarity.
Certifications You’ll Earn
At Sardar Patel Academy & Research Centre (SPARC), the Diploma in Computer Application (DCA) is designed to build practical computer skills that are relevant to academic, professional, and workplace requirements. After completing the course, you will receive certifications that validate your learning and practical knowledge.
Along with the SPARC Course Completion Certificate, you will also receive the Government-recognised NIELIT CCC Certification, adding credibility to your computer skills and strengthening your resume for future job opportunities.
What You'll Receive
- SPARC DCA Course Completion Certificate
- Government-Recognised NIELIT CCC Certification
-Practical Computer Application Training
- Hands-On Learning & Lab Practice
- Industry-Relevant Computer Skills
-Skill Validation for Job Applications
- Certificate Support for Resume & LinkedIn Profile
Our successful alumni
We are proud to present our alumni who have made it big in the industry. Magic happens when our training and their hard work come together.
Placement Support
At Sradar Patel Academy - SPARC, we don’t just teach skills—we prepare students for successful careers. Our Placement Support program is designed to help learners become job-ready through professional resume building, interview preparation, and direct job assistance. We also conduct mock interviews and communication skills training sessions to boost confidence and improve performance during real job interviews. Additionally, our team provides job assistance by connecting students with hiring companies and recruiters, helping them explore relevant career opportunities and take the next step toward a successful future.
Career Opportunities After This Diploma in Computer Application (DCA)
Build skills that can open multiple career paths across agencies, startups, brands, freelancing, and business growth.
What Our Students Say
Delivering practical skills, real projects, and career-focused training across Delhi-NCR
Average Rating:
4.9 /5 from 2500+ Reviews
Career Guidance Blog
Let's Clear up some doubts
Everything you need to know before joining — from eligibility to fees and career opportunities.
The DCA course covers computer fundamentals and the operating system, MS Office (Word, Excel, PowerPoint) with Google equivalents, Internet & ChatGPT/AI basics, graphic design (InDesign, Photoshop, Canva, Illustrator), web development (HTML, CSS, JavaScript, WordPress), and video editing (Filmora) — all in one 12-month programme.
Yes. The programme starts from the very basics of how a computer works and builds up gradually to design, web, and multimedia skills. No prior software knowledge is necessary.
The DCA course runs for 12 months, with each class lasting 1 hour and regular practical sessions built in throughout.
The entire course is delivered through projector-based practical training on real tools — Photoshop, Illustrator, and Canva for design; HTML, CSS, and WordPress for web; and Filmora for video. You practice on actual software from day one.
Students can move into roles such as Junior Graphic Designer, Web Designer, Video Editor, Office Administrator, Computer Operator, Data Entry Executive, or start freelancing across design and web.
Yes. SPARC offers structured placement support, including resume building, HR mock interviews, and soft-skills development.
Yes. Flexible batch timings are designed to accommodate working professionals and college students who want to upskill without disrupting their schedules.
Yes. Along with your main DCA course completion certificate, additional skill/tool certifications are provided covering the key modules taught in the course.