Safe working practices

Electrical safety
• explain how to rescue a person who is in contact with a live wire.
Safe working practices
Safety practice - fire extinguishers
• explain how to rescue a person who is in contact with a live wire
• distinguish the different types of fire extinguishers
• determine the correct type of fire extinguisher to be used based on the class of fire
• describe the general procedure to be adopted in the event of a fire.
Practice on fire extinguishers
• state about the selection of the fire extinguishers according to the type of fire
• state the method of operation of the fire extinguisher
• explain how to extinguish the fire.
Assemble a Desktop PC
Introduction to computers
• define and classify computers
• list the advantages and limitations of computers
• list the applications of computer
• describe the voltages and currents in the computer.
Using Windows Operating Systems
Introduction to CPU architecture and motherboard
• state what is hardware and test the internal and external hardware
• brief the listed hardware
• state what is partitions and their types
• explain the booting and its procedures.
Computer Basics & Software Installation
View the BIOS settings and their modifications
• list out the windows versions and features.
Computer Basics & Software Installation
Install Windows operating system
• describe the functions of BIOS and CMOS
• describe the method of viewing and changing BIOS settings
• describe the meaning of partitioning and formatting
• describe the process of installing Windows operating system.
Computer Basics & Software Installation
Format hard disk and create partition
• describe the functions of BIOS and CMOS
• describe the method of viewing and changing BIOS settings
• describe the meaning of partitioning and formatting
• describe the process of installing Windows operating system.
 Computer Basics & Software Installation
Identify and rectify common hardware and software issues during OS
installation
• state the basic steps involved in troubleshooting a PC
• explain the basic approach to solve a problem
• list the probable defects and symptoms in a faulty Computer
• analyse the causes for the complaints
• state the shortest path for servicing the defects.
• list the probable defect and symptoms in the faulty Computer
• analyse the causes for the complaint “When windows is started, system runs surface test and
goes to safemode” with the help of a Problem Tree and TSC.
Computer Basics & Software Installation
Install necessary application software for Windows i.e. Office
Package, PDF Reader, Media Player etc
• describe various software types.

Computer Basics & Software Installation

Configure Bluetooth and Wi-Fi settings
• describe the meaning of Bluetooth
• describe the method of using Bluetooth
• list the major applications of Bluetooth.

Computer Basics & Software Installation

DVDs, CDs and burning DVDs
• describe the features of CDs & DVDS
• describe the main formats of DVDs
• describe DVD burning
• describe the features of CDs.

DOS Command Line Interface

Use basic DOS commands for directory listing
• describe the hierarchical directory system in DOS
• use dos commands to create directories and subdirectories
• use dos commands to change and list directory
• use dos commands to access specific files.
DOS Command Line Interface
Manage files and folders using DOS commands
• use DOS commands to display the contents of a text file
• use DOS commands to copy,rename,delete and undelete files.
Install Ubuntu Linux operating system and execute basic Linux
commands
Introduction to Linux operating system
• overview of linux
• define futures of linux
• explain application area of linux
• describe about kernel.
Introduction to Open source software
• definition of OSS
• history of OSS
• open source initiative
• examples of OSS.
Install Ubuntu Linux operating system and execute basic Linux
commands
Handling commands and various editors
• know about terminal
• explain the command shell
• list out the directory layout of linux
• define the linux commands
• list out the special characters of linux OS
• explain various editors in linux OS.
Managing files and directories
• define manipulating files and directories
• define basic file commands
• explain other file commands
• define additional useful commands in linux OS.
Using Word Processing Software
MS WORD 2010 THEORY
• state what is MS Office
• brief what is MS Word and starting steps
• explain various screen blocks of MS Word
• explain procedures to create, save, print a documentl.
Creating a file, save and other options

Shortcut keys in Word 2010

Objectives: At the end of the lesson you shall be able to
• Learn the shortcut keys in MS Word.
Format documents
Insert, format text and paragraphs, Create and configure document
sections
• insert Text in MS Word
• format text
• add a section break.
Manage tables and lists
Create, modify tables
• create tables
• convert text to a table
• split a table.
Create and Manage References
Create and manage reference elements and tables
• manage reference elements
• customize tables of contents.
Manage Graphic Elements
Insert, format illustrations and text boxes
• text box
• add text to graphic elements.
A text box is an object you can add to your document that lets you put and type text
anywhere in your file. Text boxes can be useful for drawing attention to specific text and can
also be helpful when you need to move text around in your document.
Go to Insert > Text Box, and then select one of the pre-formatted text boxes from the list, select
More Text Boxes from Office.com, or select Draw Text Box.
Manage Document Collaboration
Manage comments change tracking and mailings
• collaborate in Word
• co-edit a document
• track Changes on and off
Manage Mailings
Perform mail merge
• insert objects
• mail merge
• templates.
Spread Sheet Application Manage Worksheets and Workbooks
Open files in MS Excel
• introduction to excel
• cell Reference & linking sheet
• set or clear a print area on a worksheet.
Manage data cells and ranges
Manipulate data
• manipulate data
• cell range.
Manage tables and table data
Create and format tables
• create and format table
• sort & Filter
• convert a table to text.
Perform operations using formulas and functions
Functions and formulas in MS-Excel 2010
• features & Functions of Microsoft Excel
• formulas and Functions
• move Around in Excel 2010
• conditional Formatting
• link Excel Spreadsheet Data
Manage Mailings
Manage Charts
• create charts
• modify charts
• format charts.
Manage Pivot Tables
Create Pivot Tables
• pivot table
• pivot table work
• group data.
Power Point Presentations
Open files in MS PowerPoint Presentations
• introduction to MS Power Point Presentation
• apply and edit picture effects.
Format Presentations
Insert, Format text and paragraphs
• apply text alignment .
Manage tables and bulleted text
Create tables, modify tables, modify bulleted text
• modify or format table
• apply bulleted and numbered list.
Manage Graphic Elements
Insert illustrations, Format illustrations and text boxes
• add text to a slide
• change layout color or style
• format smart art.
Manage Audio & Video Elements
Audio & Video Elements
• add or delete audio in PPP
• record Audio
• change playback options.
Manage Transitions and Animations
Add slide transitions & animations
• set slide transition sound
• apply slide transition effects
• apply a custom animation effect.
 Manage collaboration
Add and manage comments
• add a command
• show or Hide command
• edit & Delete a command.
Demonstrate on MySQL
Install, Troubleshoot, Create and Use of database in MySQL
• concept of DBMS & RDBMS
• difference of DBMS & RDBMS
• define data models
• concept of DBA
• define database Users
• define database schema.
Demonstrate on MySQL
Designing database using normalization rules,various datatypes,data
integrity,DDL,DML&DCL Statements Enforcing Primary key and
Foreign key
• database Normalization in MySQL
• various datatypes
• data integrity
• DDL,DML&DCL Statements Database Normalization in MySQL
• enforcing Primary key and Foreign key
• adding Indices.
Insert and delete queries Update queries
• simple select queries.
Demonstrate on Functions
Using the Number, Date and Character functions, group by having,
sub query
• state the sub query.
Set-up & Configure a Computer Network
Connect a computer to a network and share Devices i.e. Printers,
files, folders and drives
• local Networks.
• communicating on a local network:
• principles of Communications.
Communicating in a connected world Local Networks.
Ethernet networks
• define Ethernet
• how to work Ethernet
• define network built.
End-User Devices and local networks
• define communicate network
• types of Node Devices in a Computer Network
• functions of End Devices.
Create simple static web pages using HTML tags
Web designing
• explain web sites and web pages
• explain static and dynamic web pages
• explain HTML, DHTML and XML
• explain the concept of web hosting, web server, application server and database server.
Create simple static web pages using
Introduction to CMS and web authoring tools
• explain the meaning of content management System.
• list some of the popular CMSes.
• explain the use and main features of kompozer web authoring tool.
JavaScript Embed JavaScript in HTML Pages
Understanding JavaScript
• define programming and scripting languages
• know what is JavaScript and history of Java Script
• explain how to run JavaScript
• list out tools you need to run JavaScript
• view sample JavaScript Program
• know features of JavaScript
• describe advantages and disadvantages of JavaScript
• explain JavaScript Versions.
.
Introduction to Web servers and External JavaScript files
• explain Web servers and their features
• explain external JavaScript files.

JavaScript Embed JavaScript in HTML Pages

Using JavaScript Variable and data types
• explain variables in JavaScript
• explain various data types in JavaScript.
Using JavaScript Constants and Operators
• explain constants in JavaScript
• explain operators in JavaScript.
JavaScript Embed JavaScript in HTML Pages
Control statements, Loops and Popup boxes in JavaScript
• explain control statements
• discuss about various Loops
• explain the uses of Popup boxes.
 JavaScript Embed JavaScript in HTML Pages
Arrays in JavaScript
• define Array
• explain concepts of Array
• describe array methods
• know sorting of Array.
Concepts of Animation and Multimedia files in JavaScript
• know animation settings in JavaScript
• explain multimedia in JavaScript.
JavaScript Embed JavaScript in HTML Pages
Develop dynamic HTML pages using JavaScript
• define function
• explain working of function
• explain the benifit of using function
• explain scope of variables.
String and number methods in JavaScript
• explain string
• explain different string methods.
Math objects in JavaScript
• explain Math objects in Java Script.
JavaScript Dates
• explain JavaScript Date Objects
• explain JavaScript Date Formats
• explain JavaScript Date get methods
• explain JavaScript Date set methods.
JavaScript Embed JavaScript in HTML Pages
Deploy web project using IIS
• define DOM
• explain DOM methods
• explain DOM documents
• describe HTML DOM elements
• explain HTML DOM events
• know Open Source Software
Data Visualization or analysis using Excel
Create advanced formulas and macros
• types of references
• custom number format
Browse e-Commerce Sites to Identify Products & Services
E-commerce scope and benefits
• define E-commerce
• explain difference between traditional commerce and E-commerce
• explain type, scope and benefit of E-commerce.
Browse e-Commerce Sites to Identify Products & Services
Undertake transactions on an e-commerce site
• explain different E-commerce sites
• explain online catalogues, shopping carts and check out pages
• explain payment, order processing and authorization, charge back
• explain other payment options.
Browse e-Commerce Sites to Identify Products & Services
E Commerce Security issues and Payment Gateways
• explain E-commerce security issue
• explain payment gateway.
Protect Information, Computers and Networks from Viruses,
Spyware and other Malicious Code
Overview of information security and threats
• describe information security and its basic principles
• describe the relation between information security and cybersecurity
• describe the key challenges in information security
• describe the benefits of information security
• explain the methods of implementing information security.
Overview of security threats
• describe security threat and its types
• describe the methods of identifying threats
• explain how threats affect a system
• describe the sources of threats
• describe the best practices to identify and mitigate threats.
Information security vulnerabilities and Risk Management
• describe security vulnerability
• describe the types of vulnerabilities
• explain how threats affect a system
• describe the vulnerability assessment tools and techniques
• describe the best practices to mitigate security vulnerabilities
• describe the relation between threat, vulnerability and risk
• describe the various threat agents
• describe the purpose of risk management
• describe the types of risk management
• explain the risks to ICT supply chain management.
Directory services
• describe directory and directory service
• describe the benefits of directory services
• mention the various implementations of directory services
• describe the logical and physical structure of active directory
• describe global catalog and group policy.
Access Control, Audit and testing
• describe the purpose and steps in access control
• describe the various layers in access control
• describe the access control mechanisms
• classify information for security
• list the access control protocols
• describe security audit
• describe the important of security audits
• describe the process of performing audit security
• describe vulnerability assessment and penetration testing
• mention the various types of security audit tools.
Protect Information, Computers and Networks from Viruses,
Spyware and other Malicious Code
Privacy Protection and IT Act
• describe information privacy
• describe the method of protecting privacy in information systems
• describe the best online privacy practices
• explain about what is IT Act
• describe about cyber crimes.
Working with Cloud Services
• introduction to Cloud computing
• types of cloud computing
• disadvantages and benefits of cloudcomputing.
Identify Phases of the Application Development Life Cycle
• identify phases of the application development life cycle
• benefits of SDLC.
Programming language (Python) Use Python from command line
• introduction to Python
• features of Python
• comments of Python
• variable.

Perform Operations using Data Types and Operators

• data types , Operators in Python.
Control Flow with Decisions and Loops
• if, if-else, if-elif-ese.

Loop Statements in Python

• while loop, for loop.
Document and Structure Code
•
Tuple Sequence in Python
• tuple
• indexing:
• Tuple Operators
• How to add or remove elements to a list?
• Tuple Functions.
Set Sequence in Python
• creating a set
• set Operators
• set Functions.
Dictionary Sequence in Python
• accessing the dictionary values
• updating dictionary values
• deleting dictionary values
• accessing the dictionary values using loops
• dictionary Functions.

Python Arrays
• elements of an Array.
Perform Operations Using Modules and Tools
• creating module
• loading module
• rename module.
Python Iterators
• looping Through an Iterator " create an Iterator" stopIteration.