Diploma In Computer Application(DCA)
Introduction Of MsExcel
Diploma In Computer Application(DCA)
0% Completed
SECTION 01 – Computer Fundamentals
Introduction to Computer
History and Generations of Computer
Characteristics of Computer
Types of Computers
Input Devices
Output Devices
CPU – Central Processing Unit
Memory – RAM, ROM and Cache
Primary and Secondary Storage
Hardware and Software
Types of Software
Operating System Introduction
Number System – Binary, Decimal, Octal, Hexadecimal
Computer Languages
Computer Shortcut Keys
Important Computer Full Forms
Practical Assignment – Computer Hardware Identification
Module 1 MCQ Test
Introduction to Typing
Keyboard Layout and Finger Position
Home Row Keys
Upper Row and Bottom Row
English Typing Practice
Hindi Typing Introduction
Unicode and Hindi Typing
DevLys and Kruti Dev Introduction
Typing Speed and Accuracy
Data Entry Practice
Practical Assignment – English and Hindi Typing
Introduction to MS Word
Create, Open and Save Documents
Font Formatting
Paragraph Formatting
Alignment and Line Spacing
Bullets and Numbering
Page Setup and Margins
Page Border and Page Color
Header and Footer
Page Numbering
Insert Tables
Table Formatting
Insert Pictures and Shapes
SmartArt and WordArt
Find and Replace
Spelling and Grammar
Hyperlinks and Bookmarks
Mail Merge
Resume Creation
Application and Letter Writing
Certificate and Notice Designing
Practical Assignment – Office Documents
Module 4 MCQ Test
Introduction to MS Excel
Workbook, Worksheet, Rows and Columns
Cell Address and Range
Data Entry and Editing
Formatting Cells
Number, Date and Currency Formatting
AutoFill and Flash Fill
Basic Formulas
SUM, AVERAGE, MIN and MAX
COUNT, COUNTA and COUNTBLANK
IF Function
AND and OR Functions
SUMIF and COUNTIF
VLOOKUP and HLOOKUP
XLOOKUP Introduction
CONCAT and TEXT Functions
LEFT, RIGHT and MID
Sort and Filter
Conditional Formatting
Data Validation
Remove Duplicates
Charts and Graphs
Pivot Table Introduction
Page Layout and Printing
Sheet Protection
Salary Sheet Practical
Student Result Sheet Practical
Invoice and Billing Practical
Practical Assignment – Excel Project
Module 5 MCQ Test
Introduction to PowerPoint
Create and Save Presentation
Slide Layout and Design
Themes and Templates
Insert Images and Shapes
SmartArt and Charts
Animation Effects
Slide Transitions
Audio and Video Insertion
Slide Show and Presentation Settings
Professional Presentation Designing
Practical Assignment – B
Introduction to Database
DBMS and RDBMS
Introduction to MS Access
Tables and Fields
Data Types
Primary Key and Foreign Key
Create and Manage Tables
Queries
Forms
Reports
Relationships
Practical Assignment – Student Database
Module 7 MCQ Test
Internet, Email & Networking
Introduction to Internet
WWW and Web Browsers
Search Engines
Website and URL
Download and Upload
Email Account Creation
Compose and Send Email
CC and BCC
Email Attachments
Google Drive
Google Docs and Sheets
Google Forms
Introduction to Computer Networks
LAN, MAN and WAN
Wi-Fi and Internet Connectivity
Practical Assignment – Email and Online Services
Module 8 MCQ Test