Diploma in Computer Application

The Diploma in Computer Application provides an understanding and skills related to the use of computer and its applications. The objective of this programme is to develop professionals to meet the requirement of office automation and electronic data processing. Different application software is introduced to understand the practical usage as well as specific work areas of computers.

Outcomes:

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

  • Identify the computer peripherals
  • Understand Windows UI and work with it
  • Understand C Programming
  • Understand MS Word, Excel & PowerPoint & work with them
  • Understand basics of Internet and it’s functionality

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 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
7. 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
8. 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
→ PROJECT WORK
  1. Project on MS Word
  2. Project on MS Excel
  3. Project on Advance Excel
  4. Project on MS PowerPoint
  5. Project on C
  6. Project on C

Buy this course

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