Final Demostration Plan

(1)

INDUSTRIAL TRAINING INSTITUTE DEMONSTRATION PLAN

Trade : Computer Operator & Programming Assistant Week : 1 Date : Lesson No. : Name : Demo No. : 1

Skill : Understand the components Desktop computer

1. Identification Cpu , keyboard, mouse, scanner, monitor, printer, Speaker etc

Objectives : Trainees must be able to identify the basic components of the computers and Disassembling and Reassembling a Desktop computer

Aids : Computer System and its Accessories (Computer Parts,Printer,Scanner etc) Preparation :

(a) Material :

(b) Tools & Equipments : Computer System and Accessories (c) Other Requirements : Power Supply 230 volts

Motivation : Does any man live without breathing air (oxygen)? Of course not! Similar is the case with any electronic device to make it working it needs proper electricity and specified power (voltage) in terms of AC or DC with proper connections to the device. Presentation Procedure (Do) Questions (Ask) Application: For trainees attempting to start and learn computers on the first opportunity. Summary: A full computer system needs mouse, cpu, moniter and a keyboard.

TEST:. Which parts of computers are used for which purpose? Assignment : Practical 1 and 2

(2)

Trade : Computer Operator & Programming Assistant Week : 2 Date : Lesson No. : Name : NILESH KABARIA Demo No. : 2

Skill : Managing files and folders

Objectives : : Trainees must be able to Managing files and folders in Computer Aids : Computer System and Accessories

Preparation :

(a) Material :

Review : desktop, using icons, buttons and customizing the desktop Link : Motivation : Presentation Procedure (Do) Questions (Ask) 1) Open Window Explorer and Explain about file

and Folder

2) Explain file’s, Folder’s and Drive’s Properties, size 3) Different style to arrange file and Directories

4) Explain Cut, copy, move, paste, rename file and folders

Which style to arrange file and folder?

2.How to Rename file and Folder 3.Which shortcut key used cut, copy, paste, rename file

Application:.

Summary: Arrange and Manage file and folders in Computer Drive TEST:. 1)create file and folder and move it other location and rename it Assignment : Give Practical about file and folder

Next Demonstration: Working with MS-Paint

(3)

DEMONSTRATION PLAN

Trade : Computer Operator & Programming Assistant Week : 2 Date : Lesson No. : Name : Demo No. : 3 Skill : Working with MS-Paint

1 MS-Paint Screen introduction 2 Using Toolbox

3 Creating a Picture

Objectives : Trainees must be able to identify the basic components of the computers and identify it’s connection with wiring details.

Aids : Computer System and its Accessories ( Mains cords, Printer cords) Preparation :

(d) Material :

(e) Tools & Equipments : Computer System and Accessories (f) Other Requirements : Power Supply 230 volts

Review : Basics of computers, it features to have the fundamentals of computers with its features being cleared.

Link : Computer System is similar to any other electronic device in terms of electricity requirement and its connections to the mains.

Motivation : Use of graphics is the main trend now a days in each and every field. So creating pictures makes every work very attractive.

Presentation Procedure

(Do)

Questions (Ask) 1. Start->all programs->accessories->Microsoft paint

2. Screen introduction

3. Use all the tools viewed in toolbox 4. Create any natural picture

5. Use cut, copy, paste command

6. save picture with different extensions in your folder

1. How to start ms paint? 2. How to add text in picture? 3. How to save picture? 4. How to open saved picture? 5. How to crop any picture?

Application: MS-Paint is used to create picture files.

Summary: Trainees should always use ms paint to create any picture file. They also can edit pictures in ms paint.

Test: Trainees should create one picture using all the tools with different colors. Assignment : Practical 2 and 3

Next Demonstration: BIOS setting & Loading O.S.

(4)

Skill : BIOS setting & Loading O.S. 1 Viewing the BIOS 2 Changing the Boot order 3 Loading O.S.

Objectives : Trainees must be able to identify the basic components of the computers and identify it’s connection with wiring details.

(g) Material :

(h) Tools & Equipments : Computer System and Accessories (i) Other Requirements : Power Supply 230 volts

Review : Basics of computers, it features to have the fundamentals of computers with its features being cleared.

Motivation : To change the computer system’s setting you must have knowledge of the BIOS(Basic Input Output System)

(Do)

Questions (Ask) 1 Start the PC and press f2 or delete key instantly to

view the BIOS

2 Blue screen shows the BIOS. You can see many tab for changing settings of BIOS

3 Goto Boot tab for changing boot order. You can set optical drive,HDD or usb as booting order.

4 To load any O.S. enter the CD/DVD in computer and restart the PC. When you got press any key to use CD/DVD press any key then your O.S. will be loaded in computer

1.What is use of BIOS? 2.How to start BIOS?

3.List variant settings list that can be done in BIOS?

4.How to load any O.S. in computer using CD/DVD?

Application: Using BIOS you can make such settings that will affect your startup of computer Summary: Trainees should always check the BIOS setting when way loading of O.S. changes. Test: Trainees should change the boot order and start computer each time.

Assignment : Practical 3 and 4

Next Demonstration: Dos Command1 (internal)

(5)

Skill : DOS Commands1 (Internal) 1. Knowledge of DOS

2 Awareness of Command Prompt

Objectives : Trainees must be efficiently able to perform the operation on Disk Operating System.

(j) Material :

(k) Tools & Equipment’s : Computer System and Accessories (l) Other Requirements : Power Supply 230 volts

Review : DOS commands for which the specifications are available in Shell

(Command.com) are called internal commands. These are frequently used commands, and are called resident commands.

Link : An internal command is an MS-DOS command that is stored in the system memory and loaded from the command.com.

Motivation : The category Internal DOS commands deals with articles about DOS commands built into the command processor(COMMAND.COM, 4DOS.COM) rather than available through separate executable files.

(Do)

Questions (Ask) 1. Some commands are internal — built into

COMMAND.COM

2. When the user types a line of text at the operating system command prompt,COMMAND.COM will parse the line and attempt to match a command name to a built-in command or to the name of an executable program file or batch file on disk. If no match is found, an error message is printed, and the command prompt is refreshed.

1. What is the use of DOS?

2. What is DOS Internal Commands? 3.What is COMMAND.COM? 4.What is the use of Internal Commands?

5. Give Examples of Internal Commands.

Application: For trainees attempting to start Command Prompt and run Internal Commands. Summary: An internal command is an MS-DOS command that is stored in the system memory

and loaded from the command.com. Test: Run Internal Commands:

Assignment : Practical

Next Demonstration: DOS Commands.2 (External)

(6)

Skill : DOS Commands2 (External) 1. Knowledge of DOS

2. Awareness of Command Prompt

Objectives : Trainees must be efficiently able to perform the operation on Disk Operating System.

(m) Material :

(n) Tools & Equipments : Computer System and Accessories (o) Other Requirements : Power Supply 230 volts

Review : An external command is an MS-DOS command that is not included in

command.com. External commands are commonly external either because they require large requirements or are not commonly used commands.

Link : each of the external commands are their own separate files. However, the internal commands are all included in the command.com file.

Motivation : The category External DOS commands deals with articles about DOS

commands not built right into the command

processor(COMMAND.COM, 4DOS.COM) but available through separate executable files. Presentation Procedure (Do) Questions (Ask) 1. External commands were too large to keep in the

command processor, or were less frequently used. Such utility programs would be stored on disk and loaded just like regular application programs but were distributed with the operating system. Copies of these utility command programs had to be on an accessible disk, either on the current drive or on the command path set in the command interpreter.

2.

1. What is the use of Internal Commands?

2. What is the Work of Command Prompt?

3. Give Examples of External Commands.

Application: For trainees attempting to start Command Prompt and run External Commands. Summary: An external command is an MS-DOS command that is not included in command.com.

External commands are commonly external either because they require large requirements or are not commonly used commands.

Test: Run External Commands:

Next Demonstration: LINUX Commands1

(7)

Skill : Linux Commands1

1. Knowledge of Linux Operating System 2. Awareness of Linux Commands

Objectives : Trainees must be efficiently able to perform the operation on Linux Operating System.

(p) Material :

(q) Tools & Equipments : Computer System and Accessories (r) Other Requirements : Power Supply 230 volts

Review : Developed by Linus Torvalds and further elaborated by a number of developers throughout the world, Linux is a freely available multitasking and multiuser operating system

Link : Linux was placed under General Public License (GPL). The system can be

distributed, used, and expanded free of charge. In this way, developers have access to all the source codes, thus being able to integrate new functions or to find and eliminate programming bugs quickly. Thereby drivers for new adapters

(SCSI controller, graphics cards, etc.) can be integrated very rapidly.

Motivation: Linux is a free and open-source operating system developed by Linus Torvalds and friends and was first announced by Linus in a post he made August 25, 1991. The Linux kernel runs on numerous different platforms including the Intel and Alpha platform and is available under the GNU General Public License.

(Do)

Questions (Ask) 1. Linux may be obtained in two different ways. All the

necessary components can be downloaded free of charge from the Internet. This means that an individual operating system can be assembled for almost nothing. An alternative is to use a so-called Distribution, offered by various companies and including a wide range of applications and installation programs that significantly simplify the installation of Linux.

2. Presently, Linux is successfully being used by several millions of users worldwide. The composition of user groups varies from private users, training companies, universities, research centers right through to commercial users and companies, who view Linux as a real alternative to other operating systems.

1. What is the Linux?

2. Why the Linux is Open Source operating system?

3. What is the use of Linux? 4. List out Linux Commands and explain it with example.

Application: For trainees attempting to start Linux and run Linux commands. Summary: Linux is a free and open-source operating system.

Next Demonstration: Linux Command2

(8)

Skill : Linux Commands1

1. Knowledge of Linux Operating System 2. Awareness of Linux Commands

Objectives : Trainees must be efficiently able to perform the operation on Linux Operating System.

(s) Material :

(t) Tools & Equipments : Computer System and Accessories (u) Other Requirements : Power Supply 230 volts

Review : Developed by Linus Torvalds and further elaborated by a number of developers throughout the world, Linux is a freely available multitasking and multiuser operating system

Link : Linux was placed under General Public License (GPL). The system can be

distributed, used, and expanded free of charge. In this way, developers have access to all the source codes, thus being able to integrate new functions or to find and eliminate programming bugs quickly. Thereby drivers for new adapters

(SCSI controller, graphics cards, etc.) can be integrated very rapidly.

Motivation: Linux is a free and open-source operating system developed by Linus Torvalds and friends and was first announced by Linus in a post he made August 25, 1991. The Linux kernel runs on numerous different platforms including the Intel and Alpha platform and is available under the GNU General Public License.

(Do)

Questions (Ask) 1. Linux may be obtained in two different ways. All the

necessary components can be downloaded free of charge from the Internet. This means that an individual operating system can be assembled for almost nothing. An alternative is to use a so-called Distribution, offered by various companies and including a wide range of applications and installation programs that significantly simplify the installation of Linux.

2. Presently, Linux is successfully being used by several millions of users worldwide. The composition of user groups varies from private users, training companies, universities, research centers right through to commercial users and companies, who view Linux as a real alternative to other operating systems.

1. What is the Linux?

2. Why the Linux is Open Source operating system?

3. What is the use of Linux? 4. List out Linux Commands and explain it with example.

Application: For trainees attempting to start Linux and run Linux commands. Test: Run Linux Commands:

Next Demonstration: Creating, Saving & editing ms-word document INDUSTRIAL TRAINING INSTITUTE

(9)

Trade : Computer Operator & Programming Assistant Week : 7 Date : Lesson No. : Name : JAYESH G. CHAUDHARI Demo No. : 09

Skill : Creating , Saving & editing ms-word document

Objectives : Trainees must be efficient able to Create Windows based Text files using word.

Aids : Computer System Preparation :

(a) Material :

(b) Tools & Equipment’s : Computer System and Micro soft Office Review : Windows will provide application to create text base file.

Link : Computer is used to store information and we are use text base document.

Motivation : Previously to this process of word pad, typewriter and its greater version were used for word processing.

Presentation

Procedure (Do)

Questions (Ask) 1. Boot the process

2. Go to Start-->All Programs-->MS Office-->Click on MsWord

 Title Bar  Control Buttons  Menubar

3. File Menu Commands  New Open…  Save  Save As…  Close  Page Setup…  Print…  Exit

1. What is the Ms Word? 2. What is Control Buttons 3. Use of Page Setup… 4. Use of Print Command

Application: For trainees attempting to start and learn computers on Ms Word. Summary: Trainees should formatting letter in Ms word.

Test: Describe Word Menus. Assignment : Practical 6

(10)

Skill : Insert And Format tables & other Tools

Objectives : Trainees must be efficient able to Formatting, table in Letter files using word.

Aids : Computer System, MS WORD. Preparation :

(a) Material :

(b) Tools & equipment : Computer System and Micro soft Office Review : Windows will provide application to create Document file.

Motivation : Previosly to this process of wordpad,typewriter and its greater version were used for word processing.

(Do)

2. Go to Start-->All Programs-->MS Office-->Click on Ms Word

3. Format Menu --> Font... --> Paragraph...

--> Bullet & Numbering --> Back ground

--> Auto Format 4. Tools Menu

--> Spelling & Grammar... --> Word Count --> Auto Correct --> Mail Merge 5 Table Menu --> Insert --> Delete --> Select --> Merge Cell --> Split Cell

--> Table Auto Format --> Sort

-->What is the tool menu? -->What is the table ?

-->Explain Paragraph Formatting. --> What is the use of Spelling & Grammar Command?

--> How to create Table.

Application: For trainees attempting to start and learn computers on Ms Word. Summary: Trainees should formatting, letter letter in Ms word.

Test: Describe table Menus. Assignment : Practical 8

(11)

Skill : Working with page layout setting & printing document.

Objectives : Trainees must be efficient able to Create Windows based Text files using word.

Aids : Computer System Preparation :

(a) Material :

(b) Tools & Equipment’s : Computer System and Micro soft Office Review : Windows will provide application to create text base file.

Motivation : Previously to this process of word pad, typewriter and its greater version were used for word processing.

(Do)

2. Go to Start-->All Programs-->MS Office-->Click on MsWord

3. Edit Menu Commands  Undo  Cut  Copy  Paste  Paste Special  Select All  Find  Replace 4. View Menu --> Normal --> Web Layout --> Print Layout --> Toolbars

--> Header & Footer 5. Insert

--> Break... --> Page Number... --> Date & Time.. --> Comment --> Symbol --> Picture --> Textbox --> File --> Object

--> What is different between cut & Paste?

--> How to select all document. --> How to find word in document --> How to change different views. --> How to insert picture, object & Clipart.

Application: For trainees attempting to start and learn computers on Ms Word. Summary: Trainees should formatting letter in Ms word.

Test: Describe Word Menus. Assignment : Practical 6

(12)

Trade : Computer Operator & Programming Assistant Week : 11 Date : Lesson No.: Name : Demo No. : 12

Skill : Creating , Saving & formatting excell Sheet 1. Better Storage and Modification of Information 2. Create Electronic Spread Sheet

3. Organize Data, Create Chart and Perform Calculation

Objectives : Trainees must be able to Create Electronic spread sheet and organize data in it. Aids : Computer System and its Accessories ( Mains cords, Printer cords)

Preparation :

(v) Material :

(w) Tools & equipment’s : Computer System and Accessories (x) Other Requirements : Power Supply 230 volts

Review : Basics of Excel, its terminology and how to start MS-Excel Program and create worksheet.

Link : Microsoft Excel operates like other Microsoft office programs and has many of the same functions and shortcuts of other MS programs.

Motivation :. Excel is great for working with numbers and math. After picking up the techniques in this course, you’ll be able to put your calculator away for Good. Presentation Procedure (Do) Questions (Ask) 1.Start with introduction of MS-Excel and its terminology.

2.Starting of MS-Excel program. 3.Work with file menu.

4.Create one of the Worksheet, Entering data and save it by giving extension .XLS.

5.Open one of the existing Excel file and do modification within it.

6.Page Setup.. 7.Printing

8.Close MS-Excel program.

1. What is the basic need of MS-Excel?

2. What is the Extension of MS-Excel File?

3. Which command is used for creating blank excel file? 4. Which command is used for closing current file?

Application: To mange name list of data records

Summary: Thus, Microsoft excel is very useful for create worksheet, Organize Data and provide better way to Storage and Modification of Information

Test:

Assignment : Practical in Excel

(13)

Trade : Computer Operator & Programming Assistant Week : 12 Date : Lesson No.: Name :. Demo No. : 13

Skill : Using Excell Function

1. Copy, Cut and Paste text and formulas

2. Perform basic mathematical operations in a spreadsheet 3. Work with the buttons on the toolbar

Objectives : Trainees must be able to Perform cut, copy, paste operation, perform basic mathematical operations, and Use the zoom feature to adjust the display size on the screen.

(a) Material :

Review :

Motivation : In a computer , when you work with arithmetic or numerical data it is very necessary that it looks like anybody can understand it easily and must be in proper sequence and format. It is also necessary that the data will be error free and provides user friendly environment

(Do)

Questions (Ask) 1. Starting of MS-Excel program.

2. Work with view menu. --> Toolbars

--> Header and Footer --> Formula bar --> Status Bar --> Full Screen

3. Work with Insert menu --> Rows --> Columns --> Worksheet --> Function --> Page Break --> Chart --> Symbol

1. How is data organized in a spreadsheet?

2. what is Shortcut key for Undo? 3. To move to the previous worksheet and to next sheet, what keys will you press?

Application: To perform mathematical calculation easily in daily business. Summary: Thus, Microsoft excel is very useful software for calculations on data. Test:

(14)

Trade : Computer Operator & Programming Assistant Week : 13 Date : Lesson No.: Name :. Demo No. : 14

Skill : Sorting and Filtering data in ms excell 1. Check Spelling in the worksheet 2. Use the filter and sorting feature

Objectives : Trainees must be able to format data in worksheet , perform sort, filter operation and also perform validation on data

(a) Material :

Review :

Motivation : Create database program like Result sheet and Accounting Database. Presentation

Procedure (Do)

Questions (Ask) 1. Starting of MS-Excel program.

2. Work with Format menu. --> Cell…

--> Row --> Column --> Auto Format --> Sheet

3. Work with Tools menu. --> Spelling…

--> Error Checking --> Auto Correction… 4. Work with Data menu --> Sort

--> Filter --> Validation

1. How can you set row height and column width?

2. How can you set Auto format of sheet in excel?

3. How we can protect our sheet? 4. How can you arrange data in particular order ?

Application: To create mark sheet etc.

Summary: It is very easy to arrange, format and represent data and save our time and energy. Assignment : Practical in Excel

(15)

Trade : Computer Operator & Programming Assistant Week : 11 Date : Lesson No.: Name : Demo No. : 15

Skill : Modifying excel page format for printing 1. Better Storage and Modification of Information

Objectives : Trainees must be able to Create Electronic spread sheet and organize data in it. Aids : Computer System and its Accessories ( Mains cords, Printer cords)

Preparation :

(y) Material :

(z) Tools & equipment’s : Computer System and Accessories (aa) Other Requirements : Power Supply 230 volts

Review : Basics of Excel, its terminology and how to start MS-Excel Program and create worksheet.

Motivation :. Excel is great for working with numbers and math. After picking up the techniques in this course, you’ll be able to put your calculator away for Good. Presentation Procedure (Do) Questions (Ask) 9.Start with introduction of MS-Excel and its terminology.

10. Starting of MS-Excel program.

11. Open one of the existing Excel file and do modification within it.

12. Page Setup.. 13. Printing

14. Close MS-Excel program.

1. What is the basic need of MS-Excel?

2. What is the Extension of MS-Excel File?

3. Which command is used for creating blank excel file? 4. Which command is used for closing current file?

Application: To mange name list of data records

Summary: Thus, Microsoft excel is very useful for create worksheet, Organize Data and provide better way to Storage and Modification of Information

Test:

(16)

Skill : Understand concept of slide & presentation in ms power point. 1. Basic knowledge of MS-PowerPoint.

2. Creating an attractive and Effective Presentation.

Objectives : Trainees should be able to work with the M.S.PowerPoint and understood the use of their menus and sub menus.

Aids : Computer System and M.S.Office – 2007 Preparation :

(a) Material :

(b) Tools & Equipments : Computer System With M.S.Office (c) Other Requirements :

Review : Basic knowledge of creating slide shows , use of animation and different effects of them.

Motivation : Knowledge is the best Friends of People, so that is create some kind of Presentation Skills in different ways and it’s use makes different identity of people. Presentation Procedure (Do) Questions (Ask) 1. IDE of Microsoft PowerPoint.

2. Menu Bar. --> File -->Edit -->View -->Insert -->Slide Show

3. Custom Set-up of Slide Show.

1. How to create Slide using wizard. 2. How to assign Animation scheme into different Slide.

3. What is short-cut key of Slide Show.

Application: For Creating attractive presentations of any given topic.

Summary: Add only necessary Sound, Animation in presentation, if we added more Sound, Colors & Animations into Slide then people get more attract towards Them not towards your data and so that it should be possible that you will be Fill in your Aim.

Test: The design of animation must be an proper format or not & Trainee maintained the Sequqntions of data, Animation scheme & Slide Transitions.

Assignment : 1. Create presentation about your ITI 2. Prepare different Slide of your Trades. Next Demonstration: Animated power point slide

(17)

Skill : Animated power point slide

1. Required knowledge of Effects and Animation. 2. Creating an attractive and Effective Presentation.

Objectives : Trainees should be able to work with the M.S.PowerPoint and understood the use of their menus and sub menus.

Aids : Computer System and M.S.Office – 2007 Preparation :

(a) Material :

(b) Tools & Equipments : Computer System With M.S.Office (c) Other Requirements :

Review : Basic knowledge of creating slide shows , use of animation and different effects of them.

Motivation : Knowledge is the best Friends of People, so that is create some kind of Presentation Skills in different ways and it’s use makes different identity of people. Presentation Procedure (Do) Questions (Ask) 1. Menu Bar. --> File -->Edit -->View -->Insert -->Slide Show

2. Custom Set-up of Slide Show. 3. Custom Animation schemes. 4. Slide Transaction.

1. How to create Slide using wizard. 2. How to assign Animation scheme into different Slide.

3. What is short-cut key of Slide Show.

Application: For Creating attractive presentations of any given topic.

Summary: Add only necessary Sound, Animation in presentation, if we added more Sound, Colors & Animations into Slide then people get more attract towards Them not towards your data and so that it should be possible that you will be Fill in your Aim.

Test: The design of animation must be an proper format or not & Trainee maintained the Sequqntions of data, Animation scheme & Slide Transitions.

Assignment : 1. Create presentation about your ITI 2. Prepare different Slide of your Trades.

(18)

Skill : Creating database & designing simple Table 1. Basic knowledge of M.S.Access

2. Creating a table

Objectives : Trainees should be able to learn that how to create table and entering data into particular fields of a table.

Aids : M.S.Access Package Preparation :

(a) Material :

(b) Tools & Equipments : Computer System (c) Other Requirements : M.S.Office.

Review : Basic of creating a table & entering data into them and assign relationship of different table.

Link : Data table is similar to our physical table in which we arrange our different items in a drawer same as arrange the data of same type in a column of our database or table.

Motivation : You can make different kinds of database like industrial database , school/college database , employees database and more...

(Do)

Questions (Ask) 1. IDE of Microsoft Access

2. Create Table in Design View. 3.Create Table by using Wizard 4. Create Table by entering a data.

1. How to create table and explain different method.

2. How can you create Queries? 3. Give the another name of Row. 4. Give the another name of Column.

Application: Use to create table and store data and arrange the data in a particular format.

Summary: Using access we can performs database and its related task very quickly. It Is necessary that the data should not be redundant otherwise its occupies Unnecessary space in to disk.

Test: The design of table should be in predefined format and checked that the Data type is assign proper format or not…

Assignment : 1. Create table of trainee attendance sheet. 2. Create table for trainee mark sheet. Next Demonstration: Creating Query & Forms.

(19)

Skill : Creating Table & Assign primary key 2. Creating a table and assign relationship.

Objectives : Trainees should be able to learn that how to create table and entering data into particular fields of a table.

Aids : M.S.Access Package Preparation :

(a) Material :

(b) Tools & Equipments : Computer System (c) Other Requirements : M.S.Office.

Review : Basic of creating a table & entering data into them and assign relationship of different table.

Link : Data table is similar to our physical table in which we arrange our different items in a drawer same as arrange the data of same type in a column of our database or table.

Motivation : You can make different kinds of database like industrial database , school/college database , employees database and more...

(Do)

Questions (Ask) 2. Create Table in Design View.

3.Create Table by using Wizard 4. Create Table by entering a data. 6. Assign primary key

1. How to create table and explain different method.

2. How can you create Queries? 3. Give the another name of Row. 4. Give the another name of Column.

Application: Use to create table and store data and arrange the data in a particular format.

Summary: Using access we can performs database and its related task very quickly. It Is necessary that the data should not be redundant otherwise its occupies Unnecessary space in to disk.

Test: The design of table should be in predefined format and checked that the Data type is assign proper format or not…

Assignment : 1. Create table of trainee attendance sheet. 2. Create table for trainee mark sheet.

Next Demonstration: Viewing network connection & connect comp. in n/w & share fle,folder, device

(20)

Skill : Connecting a computer to a network and sharing of Devices, files and Folders. Objectives : Trainees must be able to connect computer and enables sharing of devices, files

and folders

Aids : Computer System and with Networking tools and Accessories ( Mains cords, Printer cords, LAN Cable and Networking connectors) Preparation :

(ab) Material :

(ac)Tools & Equipments : Computer System and Networking Accessories (ad) Other Requirements : Power Supply 230 volts

Review : Basics of Networking fundamentals, Sharing information using devices, files and folder

Link : A computer network is mechanism through which we can share information as well as devices

Motivation : With the help of computer network trainee can implement networking as well as can understand sharing of devices, files and folders

(Do)

Questions (Ask)  Connecting a computer to a Network :

 Sharing of Device, File and Folder :

What is computer network?

2. What is advantages and application of computer network

Application: For trainees attempting to create Network of computers

Summary: Trainees should have already knowledge of connection ports and cable Test: Trainees should be tested on to check with proper computer network

Assignment : Practical 21

(21)

Skill : Peer to peer Setting & Proxy Server

Objectives : Trainees must be able to configuring LAN and Proxy server Aids : Computer System and with Networking tools and Accessories

( Mains cords, Printer cords, LAN Cable and Networking connectors) Preparation :

(ae)Material :

(af) Tools & Equipments : Computer System and Networking Accessories (ag) Other Requirements : Power Supply 230 volts

Review : Basics of Networking fundamentals, information regarding LAN and creating Proxy server

Link : A computer network is mechanism through which we can share information as well as devices

Motivation : With the help of LAN and Proxy server trainee can implement networking as well as can understand sharing of devices, files and folders

(Do)

Questions (Ask)  Setting up and Configuring LAN in a Computer

Lab :

--> Start --> Control

 Setting up a Proxy Server with Firewall :

1. What is LAN ?

2. What is Proxy Server ?

Application: For trainees attempting to create LAN and Proxy Server Summary: Trainees should have already knowledge of Computer Network Test: Trainees should be tested on to check with proper computer network Assignment : Practical 22

(22)

Skill : Browsing the Internet for information about computer Objectives : Trainees must be able acquire information from internet,

Aids : Computer System and with Networking tools and Accessories and active internet connection ( Mains cords, Printer cords, LAN Cable and

Networking connectors, MODEM) Preparation :

(a) Material :

(b) Tools & Equipments : Computer System and Networking Accessories, MODEM (c) Other Requirements : Power Supply 230 volts

Review : Basics of Internet skills as well as communication using E-mail

Link : Internet is network of network and number of users are attached with it. E-mail is used to communicate with other user as we are communicating with simple POSTAL SERVICES

Motivation : With the help of Internet and E-mail we can acquire information and can communicate users with the help of E-mail.

(Do)

Questions (Ask)  Browsing the Internet for information :

Collect information about computer

1. What is Internet ? 3. What is Browser?

Application: For trainees attempting to acquire information and communicating with users using E-mail

Summary: Trainees should have already knowledge of Internet Test: Trainees should be tested on to check with E-mail and Internet Assignment : Practical 23

(23)

Skill : : create email id & communicate using text & audio 1. Knowledge of Communication basics.

2. Knowledge of current chatting sites(social networking sites). 3. Basic knowledge of communication terms.

Objectives : Trainees must be able to communicate with current chatting sites(Social networking sites).

Aids : Computer System and its Accessories ( With Network) Preparation :

(ah) Material :

(ai) Tools & Equipments : Computer System and Accessories

(aj) Other Requirements : Power Supply 230 volts, A network(Internet)

Review : Basics of communications, it features to have the fundamentals of communications with its features being cleared.

Link : Communication (from Latin commūnicāre, meaning "to share" ) is the activity of conveying information through the exchange of ideas, feelings, intentions, attitudes, expectations, perceptions or commands, as by speech, non-verbal gestures, writings, behavior and possibly by other means such as electromagnetic, chemical or physical phenomena and smell. It is the meaningful exchange of information between two or more participants (machines, organisms or their parts) Motivation : Does any man live without breathing air (oxygen)? Of course not! Similar is the

case with any computer or person to make and feel it alive,it has to communicate via any media.Nowadays use of social networking site is must.In order to convey your ideas and views social networking is used more n more.

(Do)

Questions (Ask) 1. Computer i.e. CPU, Monitor, Keyboard, Mouse & a

Network cable all dismantled

2. Computer Accessories i.e. all mains cords & related cords and network cable attached to the device

3. Start with starting any social networking site like facebook.

 Configure Skype & Video Calling :

1. What is the basic need to have a communication?

2. What is the basic ingredient of communication system?

3. Significance of any social networking site like FB.

4. Significance of Text as well as Video chat.

4 What would you do if a communication fails?

Application: For trainees attempting to start and learn communication via internet on the first opportunity.

(24)

Summary: Trainees should always check the network connectivity in order to start net communication.After checking that communication can be begun.

Test: Trainees should be tested with identification of networking needs.And after that he/she should be tested on making a social networking ID.

Assignment : Practical 24

(25)

Trade : Typing Practice in Regional Language & Cyber Crimes Week : 24 Date : Lesson No. : Name : Demo No. : 24 Skill : use antivirus for protecting network & internet surfing.

1. Computer typing knowledge.

2. Knowledge about internet & computer security.

Objectives : Trainees must be able to type in regional language and gain knowledge about cyber world.

Aids : Computer System with internet connection and software for regional language. Preparation :

(a) Material : PPTs about cyber crime and cyber law. (b) Tools & Equipments : Computer System

(c) Other Requirements : Typing software Review :

Link : Typing in regional language is like normal typing and cyber laws & crimes are similar to real world laws and crimes.

Motivation : Typing in regional language is no wonder. It’s same like normal typing. Cyber world also reflects the image of our routine world.

(Do)

Questions (Ask) 1. Computer i.e. Internet connection and software for

shruti fonts.

2. Start with typing demo

3. Practice typing in regional language

4. Start with initial information about cyber world. 5. Knowledge about IT act & its chapters.

-->What is the basic need to for regional language?

-->What is cyber crime and cyber act?

-->What are the main reasons for the cyber crimes?

-->Significance of acts against cyber crime?

Application: For students to start practicing in regional languages.

Summary: Students must have knowledge about regional language. Also they must be aware about cyber world and its advantage and disadvantage.

Test: Trainees should be tested on the typing software for regional language. Assignment :

(26)

Skill : Designing Simple Web Pages (using Possible tags) 1. Knowledge of web page.

Objectives : Trainees must be able to make simple web page using HTML. Aids : Computer System and its Accessories.

Preparation :

(ak) Material :

(al) Tools & Equipments : Computer System and Accessories

(c)Other Requirements : Power Supply 230 volts, A text editing program such as Notepad (for Windows) or Textedit (for Mac), A browser such as Mozilla Firefox or Safari, Computer with an internet connection, File manager of some sort such as Windows Explorer (optional), An image host site such as Photobucket or Flickr

Review : Basics of HTML, it features to have the fundamentals of making web pages with its features being cleared.

Link : HTML or Hyper Text Markup Language is the standard markup language used to create web pages.

Motivation : Creativity is the main path of success.In order to be creative one must learn HTML. HTML or Hyper Text Markup Language is the standard markup language used to create web pages.

(Do)

Questions (Ask) 1.Understand what HTML is. HTML is the coding

language that makes web-pages. To see what it looks like, go into Internet Explorer and right-click to choose "View Source".You will see a page of code, and that is HTML. That code is what your browser sees and then interprets it into as that web-page

In Google Chrome press F12.

In Mozilla Firefox, press Ctrl + U to view the page's source code.

In Safari, select View→View Source (or Option + Command + U).

In Internet Explorer, the VIEW menu option is "source". 2. Make your initial web page as simple as possible. If you don't, you'll likely get overwhelmed by the syntax and the script languages.

It's important to remember that you'll be writing your information between an opening HTML tag and a closing HTML tag. An opening tag looks like this: <___>

5 What is the basic need to have a webpage?

6 Which language is used to make a simple web page?

7 Significance of HTML 8 How to make a web page?

(27)

. A closing tag looks like this: </___> . Eventually, the ___ is replaced with a code.

3.Go to Start, then "Programs" and then "Accessories." Click "Notepad."

4. Give your page a title. A title is important because it gives your users an idea what the page is about. Also, when users bookmark your site, that title is all they will see in their bookmark list. The title for HTML code is <title>. Close it off at the end of your title by writing </title> The title is going to show on the tab don't expect it to be the title of the actual website.

5. Work on the body of the page. Type <body> to open the body tag. Then close the body tag by typing </body>. The bulk of the information for your web-page goes between <body> and </body>.

To give your web-page a background color, you can add a style to the body. Instead of simply writing , write <body style="background-color:silver">. You can try a different color or even a hex code. The words in the quotation marks are known as "attributes." They must be surrounded by quotation marks!

8. Write some text between the body tags.

To make the text go to the next line (like pressing "Enter" on your keyboard), write <br>.

Want to add a marquee, otherwise known as a word that moves across a screen? Simply type

<marquee>TEXT GOES HERE</marquee>.

9. Add some pictures. If you want to put a picture from the Internet onto your web page, the HTML code for pictures is <img src="URL"> . The closing tag is: . However, the closing tag is optional.

6.What does a body tag contains?

Application: For trainees attempting to start and learn making web pages on the first opportunity.

Summary: Trainees should always care for HTML tag attributes and its syntax.HTML totally depends on its tags and attributes.

Test: Trainees should be tested with giving a web page to be done with proper time limits. Assignment : Practical 25

(28)

Skill : Designing Simple Web Pages (using form & form control) 1. Knowledge of web page.

Objectives : Trainees must be able to make simple web page using HTML. Aids : Computer System and its Accessories.

Preparation :

(am) Material :

(an) Tools & Equipments : Computer System and Accessories

(Do)

Questions (Ask)

1.Go to Start, then "Programs" and then "Accessories." Click "Notepad." It is a lot easier if you use Notepad++ (you can download it for free on the internet) - once you choose the HTML language, everything you write will be automatically connected with different colors - that way it will be a lot easier to correct possible mistakes.

2. Tell the browser what language you are using. Type <html>. It is the first tag you write that tells the computer you're starting a web-page. It will also be closed last, so at the end of the document, close it off by typing this: <>. This ends the web page.

3. Add the heading of the page

4. Give your page a title. A title is important because it gives your users an idea what the page is about. Also, when users bookmark your site, that title is all they will see in their bookmark list. The title for HTML code is <title>. Close it off at the end of your title by writing </title> The title is going to show on the tab don't expect it to be the title of the actual website.

9 What is the basic need to have a webpage? 10 Which language is used

to make a simple web page?

11 Significance of HTML 12 How to make a web

page?

5.How to add a title to a web page?

(29)

5. Work on the body of the page. Type <body> to open the body tag. Then close the body tag by typing </body>. The bulk of the information for your web-page goes between <body> and </body>.

To give your web-page a background color, you can add a style to the body. Instead of simply writing , write <body

style="background-color:silver">. You can try a different color or even a hex code. The words in the quotation marks are known as "attributes." They must be surrounded by quotation marks! 6. Write some text between the body tags.

To make the text go to the next line (like pressing "Enter" on your keyboard), write <br>.

Want to add a marquee, otherwise known as a word that moves across a screen? Simply type <marquee>TEXT GOES HERE</marquee>.

7. Add some pictures. If you want to put a picture from the Internet onto your web page, the HTML code for pictures is <img src="URL"> . The closing tag is: . However, the closing tag is optional.

8. Check to make sure all of your tags are closed. Your webpage should look something like this:

<title>MyWeb-page</title> <bgcolor="yellow"> Ilovekukavavbecause <marquee>It'sthebest</marquee> <img src="http://www.itikukavav.com/skins/common/images/itilogo5.gi f">

9. Save your work. Go to "save as", put a filename with an .html extension (such as "testfile.html") and choose "all files" or "text" under file type. It won't work if both are not done. Go find the page wherever you saved it, double click it, and your default web browser should open up your very own web-page.

6.What does a body tag contains?

7.What does a marquee tag do?

8.What does a img tag do?

Application: For trainees attempting to start and learn making web pages on the first opportunity.

Summary: Trainees should always care for HTML tag attributes and its syntax.HTML totally depends on its tags and attributes.

(30)

Skill : Using css concept

Objectives : Trainees must be able to make simple web page using css concept. Aids : Computer System and its Accessories.

Preparation :

(ao) Material :

(ap) Tools & Equipments : Computer System and Accessories

(Do)

Questions (Ask)

Used css cocept with attribute

Application: For trainees attempting to start and learn making web pages with css concept Summary: Trainees should always care for HTML tag attributes and its syntax.HTML totally

depends on its tags and attributes.

(31)

Trade : Computer Operator & Programming Assistant Week : 22

Date : Lesson No. :

Name : Demo No. : 28

Skill : Introduction to web design tools and edit web pages.. 1. Knowledge about website design.

2. Knowledge different parameters for website design.

Objectives : Trainees must be able to work on WYSIWYG web design tool like front page after this demo.

Aids : Computer System with WYSIWYG web design tool. Preparation :

(a) Material :

(b) Tools & Equipments : Computer

(c) Other Requirements : WYSIWYG web design tool Review :

Link : Work with this tool is same like other web design tools.

Motivation : With some initial knowledge about web design we can use this tool for web designing. Presentation Procedure (Do) Questions (Ask) 1. Computer i.e. With WYSIWYG web design tool

2. Start with initial introduction about this tool. 3. Start using tools and its features.

4. Practice simple website design using this tool.

-->What is the basic need to for website design?

-->Which types of tools we use for website design?

-->What are the advantages of using this tool for website design?

-->What is the difference between this tools and other website designing tools.

Application: For students to start practicing in WYSIWYG web design tool

Summary: Students must be able to work with WYSIWYG tool and develop a simple website using this tool.

Test: Student must be tested for the tool for web designing. Assignment : Simple website for ITI