Syllabus -  Course in Computer Application 

Duration – 1 year 

Sr. No. Modules 

1  IT Foundation and Digital Tools 

2 Basics of Web Page Designing 

3 Foundations of Programming and SQL Database Management 

(OOPs & SQL Concepts) 

4 

Employability Skills DGT (30 hrs.) 

5 OJT/Project & Viva (30 hrs.) 

Module - 1 IT Foundation and Digital Tools 

1. Computer Fundamentals & Operating System 

• What is a Computer  

• Characteristics of a Computer 

• Basic Applications of Computer 

• Advantages and Disadvantages of a Computer 

• History of Computer 

• Generation of Computer 

• Classification of Computers 

• Components of computer (Input unit, Arithmetic and logic unit, Control unit, 

Storage /Memory unit, Output unit) 

• Computer Memory ( What is computer memory, Types of memory, Difference 

between Primary memory & Secondary memory) 

• Concepts of Hardware and Software (Definition of Hardware and Software, 

Input devices, Secondary Storage devices, Output devices, Mother board, 

Power supply, System software, Application Software) 

• Languages (Machine Language, Assembly Language, High Level Language) 

• Concepts of data and information  

• Number System (Base conversion, binary, decimal, hexadecimal, and octal 

systems, conversion from one system to the other) 

• Binary Arithmetic( Addition, subtraction and multiplication) 

• IECT (Information Electronics and Communication Technology) and its 

applications of IECT  

o E-governance 

o Multimedia and Entertainment 

2. Knowing GUI based Operating System and basic troubleshooting 

• Operating System and types of operating systems 

• Functions of Operating System.  

• GUI Operating Systems. 

• Types of GUI Operating System (Window, Linux, Android, Apple IOS, MAC OS) 

• Elements of GUI Operating System(Desktop, Windows, Title Bar, Task Bar, 

Start Menu/ Launcher, Icon, Button, Menu, Dialogue Box, Tab, Toolbar, 

Ribbon) 

• How Graphical User Interface Works? 

• Advantages and Disadvantages of GUI 

• Difference between GUI and CUI Operating System 

• Window Operating System 

• Managing files and folders in Window Operating System 

• Control Panel 

• Connecting keyboard, mouse, monitor, printer and projector to CPU 

• Basic Troubleshooting for common computer issues (power Supply), Handling 

issues related to printer (paper jam, printer isn’t printing, paper size

mismatch, Printer error etc.), Handling issues related to scanner (paper jam, 

poor image quality etc.) 

3. Introduction to Word Processing 

• Opening Word Processing Package 

• Menu Bar 

• Creating, opening and saving document 

• Entering and editing text 

• paragraph creation 

• Moving text (Cut, Copy & Paste) 

• Undo, Redo, Using Shortcuts  

• Formatting Documents ( Setting font styles, size, color, Typeface (Bold, Italic, 

Underline), Font effects, Change case, Highlighting, paragraph indenting , 

Alignments, Line Spacing, Drop cap, Bullets & Numberings, Borders & 

shadings, Header & Footer, Footnote & Endnote, Inserting Page break, Page 

numbering, Date & Time, Line Break, Word Wrap, Creating Cover page, Page 

Border, Table of Contents, Using Page Themes & Color, Inserting Watermarks) 

• Working with Tables (Creating tables, Table Styles, Borders & Shadings, Cell 

Alignment, Inserting & Deleting rows or columns, Merging, Splitting, Sorting, 

Using formula. Converting table into graphs) 

• Inserting Objects- Inserting Pictures, Formatting & editing pictures, picture 

styles, Picture borders, effects & layouts, Positioning, grouping & ordering, 

rotating and cropping, Adding and Editing Textbox, Shapes & SmartArt, 

Inserting Various types of charts, Charts layout and formatting. 

• Page Layout & Printing- Page Orientation, Setting page margins, Page size, 

Columns, Page Setup & Printing. 

• Features & Tools- Find and Replace, Auto Correct, Bookmarks, Hyperlinks, 

Spell Check, Thesaurus, Mail Merge. 

• Converting document into pdf 

4. Typing Skills 

• Keyboard basics 

• Correct way of typing 

• Alphabet Placement and Positioning 

• Typing with Various keys 

• Speed typing 

• Using shortcut keys.  

5. Introduction to Spreadsheet 

• Opening, creating and saving Spreadsheet. 

• Entering & editing data, Selecting Range 

• Cell Addressing 

• Creating text, number and date series. 

• Inserting, Deleting or Hiding a Row & Column. 

• Changing Cell Height & Width. 

• Formulas & Functions  

• Cell Referencing (Absolute, Relative & Mixed) 

•  HLookup & VLookup. 

• Conditional Formatting. 

• Data Sorting & Filtering, Creating Data List, Data Validation 

• Consolidation, What-if Analysis. 

• Creating Charts and Graphs- Adding different types of Charts, Charts layout 

and formatting. 

• Find & Replace, Spell Check, Thesaurus 

• Page Setup & Printing. 

6. Introduction to Digital Presentation 

• Creating a Presentation using Template 

• Creating a Blank Presentation 

• Opening and saving a Presentation 

• Entering and Editing Text  

• Inserting and Deleting Slides in a Presentation 

• Applying Themes & Background 

• Adding Pictures, Textbox, Tables, Charts, Shapes, Word Tables or Excel 

Worksheets 

• Adding Text to Shapes, Group/Ungroup Objects 

• Adding Header & Footer, Using Slide Master.  

• Setting Animation & Transition effects, Adding Audio & Video. 

• Running a slide show 

• Save as PDF, Image or Video file, PowerPoint Views, Printing handouts and 

slides. 

7. Secure Web Access and communication  

• Concept of Internet (What is Network, Types of networks, Concept of Client and 

Server, Network Topologies, Network communication media, Concept of Internet 

and its applications, Advantages and disadvantages of internet, Internet protocol, 

Domain Name System, IP Address, URL, Internet Connectivity, Using WiFi & 

Bluetooth on digital devices, WWW and Web browsers, Popular Search Engines, 

Navigating through web, Uploading & Downloading,  Services on web,  Using 

Online Services (Banking, Using e- governance websites, Shopping, Streaming, 

social networking sites)) 

• Introduction to  E-mail (History of Email, E-mail addressing, Creating new 

email account, Composing & sending email without and with attachments, Email 

Drafts and Scheduled sending, Replying & forwarding, Sorting & searching email, 

Sending email to multiple users, CC and BCC, Email protocol, Signatures 

(appended to the end of outgoing messages) 

• Basic Internet Security Concepts (Need of Security over internet, security 

threats, viruses and malwares, e-mail spam, security and privacy issues related 

to online shopping and social networking sites, safety measures- choosing strong 

password, Antivirus, Firewalls, safe browsing) 

8. Cloud Storage and Online Collaboration 

• What is cloud and cloud storage 

• Types of cloud storage (Public, private, hybrid and community cloud) 

• Cloud Storage Service Providers(Google Drive, OneDrive, Dropbox) 

• Benefits of online storage over local storage and portable storage 

• Creating and Managing Files on the Cloud 

• Sharing and Collaborating on Documents 

• Syncing Files Across Devices 

• Introduction to Online Collaboration Tools (Google Workspace, Microsoft Office 

365) 

Module 2: Basics of Web Page Designing 

1. HTML 

• Introduction to HTML 

• HTML elements 

• Tags and Attributes 

• Creating HTML Page 

• Closed and unclosed tags 

• Text formatting tags 

• HTML links 

• Lists & types of Lists 

• Creating HTML tables 

• Adding pictures & images 

• Adding audio & video 

• Working with Forms 

• HTML 5 new tags (new elements, Input Types, Form Elements, Form Attributes, 

Canvas, SVG, Video, Audio). 

2. CSS 

• What is CSS 

• Types of CSS(Inline, Internal & External) 

• CSS2 (Backgrounds, Margins, Padding, Border, Positioning, Float, Z-index, Links, 

Text, Outline) 

• CSS3 (Selectors, Border, Background, Text, Text effects, Box Shadow, 2D & 3D 

Transforms, Transition, Animation) 

3. JavaScript 

• Introduction to Client Side Scripting 

• Introduction to JavaScript 

• Application of JavaScript 

• External JavaScript 

• Variables, Data Types & Operators 

• Conditional Statements & Loops 

• JavaScript Popup Boxes(Alert, Prompt, Confirm) 

• JavaScript Functions and Events 

• JavaScript Objects and Browser Object Model (BOM) 

• Introduction to DOM & Document Object 

• getElementById, getElementsByName, getElementsByTagName 

• innerHTML, innerText property 

• JavaScript Forms and Validations. 

Module 3: Foundations of Programming and SQL Database Management (OOPs & 

SQL Concepts) 

1. Database Management with SQL  

Database Concept 

• What is Data 

• Database & Database Management System 

• Characteristics of Database Management System 

• Advantages & Disadvantages of Database Management System 

• Components of DBMS 

• Database Architecture 

• Types of Database Model 

• DBMS - ER MODEL 

• Codd's Rule for Relational DBMS 

• Basic Relational DBMS Concepts(Table, Tuple, Attribute, Relation Scheme, 

relation Key, Relational Integrity Constraints.) 

• What is Relational Algebra, Relational Calculus 

• ER Model to Relational Model 

• Types of Database Key 

• Database Normalization 

SQL Concept 

• Introduction to SQL 

• Data types in SQL 

• SQL Command (DDL: Data Definition Language, DML: Data Manipulation 

Language, TCL: Transaction Control Language, DCL: Data Control Language, 

DQL: Data Query Language) 

• DDL COMMAND (Create query, Alter query, Truncate, Drop and Rename query) 

• DML COMMAND (Insert, Update, Delete Command) 

• TCL COMMAND (Commit, Rollback and Savepoint Command) 

• DCL COMMAND (Select query, where clause, Like clause, order by clause, order 

by clause, group by clause, having clause, Distinct keyword, AND & OR Operator). 

• SQL Keys (Unique, Primary, Foreign, Composite, Alternate keys) 

• Join and set operations 

• Views and subquery 

• Triggers 

• Stored Procedure 

2. Introduction to Programming Techniques 

• Introduction to program & programming history 

• objective of program design 

• programming languages (machine language, assembly language, high level 

language) 

• Translators (compiler & assembler) 

• Algorithm and flow chart (What is an Algorithm?, Characteristics of a Good 

Algorithm, Role of Algorithms in Computer Science, Basic Concepts: Input, 

Output, Processing, Writing Simple Algorithms,  What is a Flowchart, Flowchart 

Symbols and Conventions, Steps in Creating a Flowchart, Flowchart Examples: 

Basic Mathematical Operations (e.g., Area of a Circle)) 

• Various programming techniques (Unstructured Programming, Procedural 

Programming, Modular Programming, Object-oriented Programming). 

3. Introduction to C 

• C Basics (What is C Language, History of C Language, Features of C Language, 

First C Program, Preprocessors Directives, Header Files, Input/ Output 

Statements, Escape Sequences, Character set and identifiers, Data Types, 

Constants and Variables, Operators) 

• Conditional statements and loops(Conditional Statements, Switch Statement, 

Looping Statements, break, continue and goto, Type Casting) 

• Functions (What is function, Types of Functions, Declaration, Definition and 

Calling a Function, Function Arguments, Return Value, Passing Array to 

Function, Call by Value and Call by Reference, Recursion, Storage Classes) 

• Arrays (One dimensional arrays: Array manipulation, searching, insertion, 

deletion of an element from an array, finding the largest/smallest element in an 

array, Two dimensional arrays: Addition, multiplication of two matrices,  

transpose of a square matrix) 

• Strings (What is String, gets() and puts(), String Functions) 

• Structure and Union (What is Structure, Difference between Structure and Arrays, 

Defining a Structure, Accessing Structure Elements, Array of Structure, Nested 

Structure, Union) 

• Pointers (Introduction to Pointers, Declaring and Initializing Pointer, Pointer to 

Pointer, Pointer to Array, Pointer to Structure, Pointer Arithmetic, Pointer with 

Functions) 

• File Handling (Concept of Files, File opening in various modes, File closing, 

Reading from file, Writing to a file, Counting Characters, Tabs, Spaces, File copy, 

String I/O in Files) 

4. Introduction to 'C++' with OOPS 

• 'C++' Basics (What is C++ Language, History of C++ Language, Features of C++ 

Language, Differences between C and C++, Introduction to OOP concepts: Classes, 

objects, encapsulation, First C++ Program, Header files in C++, Input/output in 

C++: cin, cout, getline()) 

• Objects and Classes (OOPS Concepts, Defining class and object, Class members, 

‘Accessing the Data members, Constructors and types of Constructors, 

Destructors, This Pointer, Static, Inline function, Friend Function) 

• Inheritance (What is Inheritance, Types of Inheritance, Aggregation) 

• Polymorphism (What is Polymorphism, Types of Polymorphism, Function 

overloading, Operator overloading, Function Overriding, Virtual Function, 

Abstraction, Abstract Classes, Interface) 

• Pointers, References, and Dynamic Memory in C++( Pointers and references in 

C++, new and delete operators for dynamic memory management, Copy 

constructors and assignment operators) 

• Exception Handling (Try, catch, throw) 

• File Handling (Concept of Files, File opening in various modes, File closing, File 

pointers and manipulation, Text File and operations on Text Files, Binary File and 

operations on Binary Files) 

5. Programming with VB.NET 

• Introduction to .NET Framework (What is VB.NET, Features of VB.NET, 

Advantages & Disadvantages of VB.NET, What is .NET Framework, Components of 

.NET Framework(CLR- Common Language Runtime, CTS-Common Type System, 

BCL- Base Class Library, CLS -Common Language Specification, FCL-Framework 

Class Library,.NET Assemblies, XML Web Services, Window Services)) 

• Visual Basic .NET Basics (Download and Install Visual Studio,  Understanding 

Visual Studio IDE, Creating projects and solutions, Variables, data types, and 

operators, Control structures (loops, conditions), Procedures and Functions, 

Exception handling) 

• Object-Oriented Programming in VB.NET (Classes and Objects, Encapsulation, 

Inheritance, Polymorphism, Interfaces and Abstract classes, Properties and 

Indexers, Namespaces and Assemblies) 

• Working with Controls and Forms (Introduction to Windows Forms, Designing UI 

using WinForms controls, Event-driven programming, Handling user input and 

validation) 

• File Handling and Input/Output Operations (Reading from and writing to files, 

Streams and readers/writers, working with directories and file manipulation) 

• Database Connectivity (ADO.NET basics, Connecting to databases, Data retrieval 

and manipulation using SQL, Data binding and datasets) 

Module 4 – Employability Skills (DGT 30 hrs.)