Advance Diploma in Computer Application

Advance Diploma in Computer Application course has been designed for meeting the demand of the growing needs of experts in the fields of computers, internet, operating systems, office automation, programming languages, photo editing, web design, etc. This course is suited for the person who wish to have complete knowledge of computer application, Internet uses, MS Office application, programming and basics of web design.

Outcomes:

Upon completion of this course, students will be able to:

  • Identify the computer peripherals
  • Understand Windows UI and work with it
  • Understand C & C++ Programming
  • Understand MS Office Application & work with them
  • Understand basics of Internet and it’s functionality
  • Design web pages using HTML
  • Work with Adobe Photoshop

Who can join?

  • School/College Students
  • Working Professionals
  • House Wives
  • Business Owners
  • Government Exam Aspirants
  • Anyone who is starting his/her journey into computer world

SYLLABUS

1. INTRODUCTION TO COMPUTER
  1. Introduction
  2. Objectives
  3. What is Computer?
    1. History of Computers
    2. Characteristics Of Computer System
    3. Basic Applications of Computer
  4. Components of Computer System
    1. Central Processing Unit
    2. Input devices
    3. Output devices
    4. Computer Memory
  5. Concept of Hardware and Software
    1. Hardware
    2. Software
  6. Summary
2. INTRO TO OPERATING SYSTEM
  1. Introduction
  2. Objective
  3. Basics of Operating System
    1. What is operating system?
    2. Types of operating system
  4. The user interface
    1. Task bar
    2. Icons
    3. Start Menu
    4. Personalize

  5. Control Panel and its options
  6. Other important features
  7. Summary
3. MS WORD AND ITS ELEMENTS
  1. Introduction
  2. Objective
  3. Basics of MS Word
    1. Opening Word Processing Package
    2. Menu Bar
    3. Using The Help
    4. Icons Below Menu Bar
  4. Opening and Closing Documents
    1. Opening Documents
    2. Save and Save as
    3. Page Setup
    4. Print Preview
    5. Documents Printing
  5. Text Creation and manipulation
    1. Document Creation
    2. Editing Text
    3. Text Selection
    4. Cut, Copy, Paste
    5. Font and Size selection
    6. Alignment of Text
  6. Text Formatting
    1. Paragraph Indenting
    2. Bullets and Numbering
    3. Changing case
  7. Table Manipulation
    1. Draw Table
    2. Changing cell width and height
    3. Alignment of Text in cell
    4. Delete / Insertion of row and column
    5. Border and shading border and shading
  8. Advance Skills
    1. Design and create forms and templates
    2. Design and create forms
    3. Mail merge
    4. Macros
    5. Format & Re-Use Headers
    6. Manage Page Layout
  9. Summary
4. MS EXCEL AND ITS ELEMENTS
  1. Introduction
  2. Objectives
  3. Elements of spread sheet
    1. Opening of Spread Sheet
    2. Addressing of Cells
    3. Printing of Spread Sheet
    4. Saving Workbooks
  4. Manipulation of Cells
    1. Entering Text
    2. Numbers and Dates
    3. Creating Text
    4. Number and Date Series
    5. Editing Worksheet Data
    6. Inserting and Deleting Rows
    7. Column
    8. Changing Cell Height and Width
  5. Function and Charts
    1. Using Formulas
    2. Function
    3. Charts
  6. Summary
5. ADVANCE EXCEL
  1. Data Validation
  2. Spreadsheets Protection
  3. Lookup Tables
  4. Conditional Formatting With Rules
  5. Conditional Formatting With Color Scales
  6. Linking External Sources
  7. Pivot Tables
6. MS ACCESS
  1. Introduction to MS-Access
  2. Menus
  3. Create a Database Using Template
  4. Create Table
  5. Form
  6. Query
  7. Report
  8. Pages and Macro
  9. Table Sorting
  10. Filtering
  11. Database Security
7. MS POWER POINT AND ITS ELEMENTS
  1. Introduction
  2. Objectives
  3. Basics of MS PowerPoint
    1. Using PowerPoint
    2. Opening a PowerPoint Presentation
    3. Saving a Presentation
  4. Creation a Presentation
    1. Creating a Presentation Using a Template
    2. Creating a Blank Presentation
    3. Entering & Editing Text
    4. Inserting & Deleting Slides in a Presentation
  5. Preparation of Slides
    1. Inserting Word Table or an Excel Worksheet
    2. Adding Clip Art Pictures
    3. Inserting Other Objects
    4. Resizing and Scaling an Object
  6. Providing Aesthetics
    1. Enhancing Text Presentation
    2. Working with Color & Line Style
    3. Adding Movie and Sound
    4. Adding Headers and Footers
  7. Presentation of Slides
    1. Viewing A Presentation
    2. Choosing a Set Up for Presentation
    3. Printing Slides & Handouts
  8. Slide Show
    1. Running a Slide Show
    2. Transition and Slide Timings
    3. Automating a Slide Show
  9. Summary
8. INTRODUCTION TO INTERNET, WWW & WEB BROWSER
  1. Introduction
  2. Objectives
  3. Basics of Computer Networks
    1. Local Area Network (LAN)
    2. Wide Area Network (WAN)
  4. Internet
    1. Concept of Internet
    2. Basics of Internet Architecture
  5. Services on Internet
    1. World Wide Web and Websites
    2. Communication on Internet
    3. Internet Services
  6. Connecting PC to Internet
    1. ISPs and examples (Broadband/Dialup/WiFi)
    2. Internet Access Techniques
  7. Web Browsing
    1. Popular Web Browsers
    2. Setting up Web Browser
  8. Search Engines
    1. Popular Search Engines
    2. Techniques to use Search Engines
    3. Web Browser Setups
  9. Account Creation
    1. Gmail Setup
    2. Other Required Tips to create any account
  10. Online Security
    1. Why Security Matters
    2. Complete Offline Security
    3. Safe Browsing
    4. Safe Banking
    5. Creating Strong Password
    6. Some Important Security Tips
9. PROGRAMMING WITH C
  1. Introduction
  2. C Character Set , Constants, Variables and Key words
  3. Decision and Control Structure
    1. if, if-else, forms of if-else statement
    2. Operator
    3. Types of Loops
    4. Case and Switch
  4. Arrays and Functions
    1. Arrays
    2. C Functions – Call by values and Call by reference
10. PROGRAMMING WITH C++
  1. C++ Overview
    1. Introduction to OOP
    2. Object-Oriented Terminology
    3. Polymorphism
    4. Abstract Data Types
    5. I/O Services
  2. Functions and Variables
    1. Functions: Declaration and Definition
    2. Variables: Definition, Declaration, and Scope
    3. Variables: Dynamic Creation and Derived Data
    4. Arrays and Strings in C++
    5. Qualifiers
  3. Classes in C++
    1. Defining Classes in C++
    2. Classes and Encapsulation
    3. Member Functions
    4. Instantiating and Using Classes
    5. Using Constructors
    6. Multiple Constructors and Initialization Lists
    7. Friends
  4. Operator Overloading
    1. Operator Overloading
    2. Working with Overloaded Operator Methods
  5. Initialization and Assignment
    1. Initialization vs. Assignment
    2. Initialization vs. Assignment
    3. Initialization vs. Assignment
    4. Initialization vs. Assignment
    5. Initialization vs. Assignment
  6. Storage Management
    1. Memory Allocation
    2. Memory Allocation
  7. Inheritance
    1. Overview of Inheritance
    2. Defining Base and Derived Classes
    3. Constructor and Destructor Calls
  8. Polymorphism
    1. Overview of Polymorphism
  9. Input and Output in C++ Programs
    1. Standard Streams
    2. Manipulators
    3. Unformatted Input and Output
    4. File Input and Output
  10. Exceptions
    1. Exceptions
    2. Inheritance and Exceptions
    3. Exception Hierarchies
    4. Inside an Exception Handler
11. HTML
  1. Introduction of HTML
  2. Menus
  3. Different Tags
  4. Creating Lists
  5. Formatting of Text
  6. Using Images
  7. Creating Links
  8. Table
12. ADOBE PHOTOSHOP
  1. Introduction
  2. Getting Started with Photoshop
  3. Opening an Existing File
  4. The Photoshop Interface
  5. The Toolbox
  6. Creating a New File
  7. Saving Files
  8. Reverting Files
  9. Closing Files
  10. Bitmap and Vector Images
  11. Editing Images
  12. Color Modes
  13. The Color Picker Palette
  14. The Selection Tools
  15. The Lasso Tools
  16. The Magic Wand Tool
  17. The Grow and Similar Command
  18. Moving a Selection
  19. Filing Selection
  20. Transforming Selection
  21. Inverting a Selection
  22. The Painting Tools
  23. The History Palette
  24. The Gradient
  25. Tool
  26. The Paint Bucket Tool
  27. The Editing Tools
  28. The Eraser Tools
  29. Layers, Layer Effects
  30. Filter
→ PROJECT WORK
  1. Project on MS Word
  2. Project on MS Excel
  3. Project on Advance Excel
  4. Project on Access
  5. Project on MS PowerPoint
  6. Project on C
  7. Project on C++
  8. Project on HTML
  9. Project on Photoshop

Buy this course

Live Projects

Project – 1: Complete Hosting, Domain & WP Setup

Project – 2: Personal/resume Website

Project – 3: 5 Pages Professional Website

Project – 4: Professional Blogging Website

Project – 5: Landing Page Design

Project – 6: E-Commerce Website

FAQ

What kind of support will I get?

You get all the required support to learn all the modules mentioned in the course. You will be able to interact with educators in the live class. You can schedule one on one meetings with educators as per their availability.

Will I get help in how to set up for live class?

Yes, you will get all the required help to come onboard and learn.

Is this recorded lessons or live session?

These are live classes where you can learn, interact and ask questions in real time. Also, there will be recorded sessions of every module in the course which learners can refer to.

Will I get individual attention?

Yes, you can interact with educators in real time. Also our educators mentor learners one on one basis.

Instructors

Rajesh Ravidas

Rajesh Ravidas

Operations Specialist at ROYAL FREELANCING, Web Designer & Developer

Manjay Ray

Manjay Ray

Full Stack Web Developer

Connect Us