ગાાંધીિગર

ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F:TRG :

05

રીસ્ટ ઒પ રેળન
Trade- C OP A સુ.ઇ.નું નાભ-
વેભેસ્ટય નંફય- 1 વીરેફવનુ લ઴ૅ-2017

રેળન પા લે ર વીરેફવન લીઔ ળીકલલાન૊

રેળનનું નાભ
નંફય વભમ નંફય લીઔ નંફય

1 Admission And Trainees Introduction 60

2 History of Computer 60
3 Fundamentals of Computer 60 1
4 Generation of Computer 60 1-2
5 Functions of Computer 60
6 Application of Motherboard 60
7 Source data input devices 60 2
8 Output device 60
9 Computer Hardware and Antivirus 60
10 Memory device and flash Memories. 60 3 3
Secondary memory device; Hard disk
11 60
(removable/fixed),
Introduction to basic DOS Internal and External
12 Commands. 60
4
13 Introduction to Open Source Software. 60 4-5
Introduction to Linux Operating System features,
14 60
structure, files and processes. 5
15 Basic Linux commands. 60
16 Introduction to the various applications in office. 60
Introduction to Word features, Office button, 6
17 60
toolbars.
Creating, saving and formatting and printing 6-8
18 60 7
documentsusing Word.
Working with inserting objects, macro, mail
19 60
merge, templates and other tools in Word. 8
20 Page setup and Printing Documents using word. 60
21 Introduction to Excel features and Data Types. 60 9
Cell referencing. Use of functions of various
22 60 10
categories, linking Sheets.
Concepts of Sorting, Filtering and Validating 9-11
23 60
Data.
11
Analyzing data using charts, data tables, pivot
24 60
tables, goalseekingand scenarios.

1
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F:TRG :
05

રીસ્ટ ઒પ રેળન
રેડ- COPA સુ.ઇ.નું નાભ-
વેભેસ્ટય નંફય- 1 વીરેફવનુ લ઴ૅ-2017

રેળન પા઱લેર વીરેફવન૊લીઔ ળીકલલાન૊

રેળનનું નાભ
નંફય વભમ નંફય લીઔ નંફય

25 Introduction to open office and power point. 60

Creating Slide Show, fine tuning the presentation 12 12
26 60
and good presentation practice.
27 Concepts of Data, Information and Databases 60
Overview of popular databases, RDBMS, OODB 13
28 60
and MYSQL.
Rules for designing good tables. Integrity rules 13-15
29 60
and constraints in a table. 14
Introduction to various types of Queries and their
30 60
uses.
31 Designing Access Reports and Forms. 60 15
Networks of Computers,Introduction to LAN,
32 60
WAN and MAN.
Network components, viz. Modem, Hub, Switch, 16
33 Router, Bridge, Gateway etc and Network 60
Cables,Wireless networks and Blue Tooth
technology. 16-17
34 Concept of ISO - OSI 7 Layer Model. 60
Overview of various Network protocols,Logical
35 60 17
and Physical Addresses, Classes of Networks
Network Security,firewall and DHCP Server
36 60
concepts.
37 Internet Concept. 60 18 18
38 Concept of sites & pages 60 19
39 Introduction to HTML and various tags in HTML. 60 20
40 Creating Forms with controls using HTML. 60 19-21
Introduction to open source CMS viz,. Joomla, 21
41 Wordpress etc. and Web authoring tools viz. 60
Kompozer,FrontPageetc.
Revision , Project work and Exam 22-25 22-25

2
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા લે ર વભમ :60 તભતનટ
રેળન નંફય : 1 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Admission and Trainees introduction

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. ITI introdution
2. courses
3. Advantages
4. Rules and Ragulation
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 05 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● To get information of students
● To know education of students
● Aim of student
2..2 અણબપ્રેયણા :
● Oportunity of jobs
● Provide technical manpower to industries

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 30 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Introduction to What is ITI? Industrial Training Institute(ITI)
ITI ● To prepare best worker for
Which courses different skill of Industrial.
available in ITI? ● To provide practical
knowledge of industrial
work

● Labour and Employment

2. Department
Department, Gujarat
● Engineering/Non
3. Different Trade Engineering Trade
(1year / 2year)
● Different courses like
Turner, Fitter, Auto mobile,
Electrician, CNC, COE,
PPO, Chemical
● District wise ITI
● Industrial wise ITI

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ

3
4. Training How many ● GCVT
Schemes schemes in ITI? ● NCVT
● ATS
● CTS
● MES
● Computer Operator and
5. Importance of Which Programming Assistant
COPA Trade Technology used ● Used in Modern
in COPA? Technology
● Fundamental of Computer
6. Technology of ● MS-Office
COPA ● linux
● Computer network
● HTML
● Javascript & VB script
● Tally
● E-Commerce

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● To prepare best worker for different skill of Industrial.

● To provide practical knowledge of industrial work

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is ITI?
2. Which courses available in ITI?
3. Which schemes are running in ITI?

6. શલે ઩છીન૊ ઩ાઠ : પાલેર વભમ : 05 તભતનટ

History of Computer

4
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 2 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : History of Computers

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેતુ઒ / રેળનના અંતે તારીભાથી :
▪ Blasé Pascal and his Mechanical calculator
▪ Charles Babbage: differential engine

1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer operator & programming assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ :05 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
▪ Abacas seem to with the earliest calculation machine, which was developed by Chinese 3000
years ago.

2..2 અણબપ્રેયણા :
▪ Think how ancestors are used to calculate and manipulate numbers.
▪ The very basic need of coming revolution in the rapid developing world.
▪ The basic fundamental qualification for each and every field.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 30 તભતનટ

અ.ન.ં શેતુ઒ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
Pascal's 1. Who is Charles Pascal machine could perform Look back on
1. Mechanical Babbage? additions. It was later improved upper history, we had less
calculator by leaning, a German mathematical of any counting
and whose machine could perform devices known to
multiplication and division as well. us today except we
see graphite slates
2. differential 2. What is
Charles Babbage, English having abacus ring
engine analytical engine?
mathematical developed mechanical balls pierced in
calculating devices called difference steel rods as if it is
engine for automatic compo ration of some playing object
mathematical tables around 1830. for babies but can‘t
Babbage was also involved in the signify the
design of another calculating machine. importance of its.
which could perform many general
function in an automatically after much
afford, he invented a machine called
analytical engine.
This machine had a memory device
and arithmetical device, a punch card
input system and an extended memory
store. Thus Babbage analytical engine
had many of the same fundamental
jealous as the modern computers.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

5
 ▪ Babbage in conceded one of the great performs in the trade of compaction for this foresight to
design the analytical engine.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. List the special features of Babbage Analytical engine.

2. How do you they compare with the modern computers?
3. Give the full form of following:
1. ENIAC 2. EDVAC 3. IBM 4. EDSC

6. શલે ઩
છીન૊઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Fundamentals of computer

6
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 3 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Fundamental of Computer

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. To make the trainees understand the basics of computers from scratch
2. Characteristics of a computer.
3. Comparison with human being and understanding
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1.
.3 વંદબય વક્રશત્મ : Computer operator & programming assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પાલેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● We Know about History of computer
● When and where developed Computer
2..2 અણબપ્રેયણા :
● Think how ancestors are used to calculate and manipulate numbers.
● The very basic need of coming revolution in the rapid developing world.
● The basic fundamental qualification for each and every field.
● Computer being a man made machine can you compare the organs of our body with the computer
block diagram block or the related peripherals.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Computer What is Needs led to the development of the Asking the trainees to
Fundamental a Computer in brief i.e. Calculation and calculate a given
- What computer? its Storage. example as follows 2 x
is 2 x 2 x 2 x 2 x 2 x 2.
Basic Computer what it is, computers
computer? Calculating it and
represents a symbol of processing
answering the
(Calculation and Storage) at a high
question the speed
speed and its wide application. from trainee to trainee
will vary.
2.
Comparison of Computer Practical example given
Comparison of with human being as will be if I say 2 + 2
computer with Brain = Microprocessor IC trainees will listen to it by
human being. Memory = Memory ICs their ears and process it
Eyes = Input device as scanner. in their brains and will
Ear = Input device as microphone give an result as 4 with
and the basic keyboard. their mouth the same can
Hands = Output device as Printer be compared as input
given to computer by
gives a hard copy
keyboard and result is
Mouth = Output device as Speaker displayed on monitor or
Monitor = Output device which gives declared by the speaker.
the soft copy on the screen.

7
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ

3. Characteristics Characteristics of Computers :-

of Computers speed, accuracy, promptness,
storage, manipulation to large
extent, cost effective and efficient by
all means of human resource
expenses.Versatile ,reliable
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● The computer can process data very fast, at the rate of millions of instructions per second.
● Computer provides a high degree of accuracy.
● When used for a longer period of time, the computer does not get tired or fatigued.
● Large volumes of data and information can be stored in the computer and also retrieved whenever
required.
● Computer is versatile in nature. It can perform different types of tasks with the same ease.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is a computer?
2. Compare computer with human.
3. Define characteristics of computer.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Generation of Computer

8
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 4 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Generation of Computer

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. First Generation
2. Second Generation
3. Third Generation
4. Forth Generation
5. Fifth Generation
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :

● To get the basic idea of comparison of a computers with human being.

2. .2 અણબપ્રેયણા :
● They represented improvement in speed memory (storage) systems input and output devices and
programming technique they also showed a cont. Reduction in physical size and cost.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Define Computer developed after ENIAC
generation of have been classified into the
computer. following for generation
First Generation –1946 to 1955
Second Generation -1956 to 1965
Third Generation - 1966 to 1975
Four Generation - 1976 to 1984 From 1946
Fifth Generation – 1984 to today each decade
has contributed
1 First Generation The 1st Generation computer those one generation
that in vacuum tubes are used. of computer.
Magnetic tape drive and magnetic
core memory were developed
during this period.

2 Second Generation
The 2nd generation computers were
market by the use of the Solid State
device called the transistor in the
place of vacuum tube. All in more
reliable than earlier counter parts.

9
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
3 Third Generation 1. What is the Along with the third generation
main difference computers never and faster
between different equipments where introduce for
generation handling storage and input output
computers? continued efforts towards
miniaturization led to
the development of
the large scale in integration (LSI)
technology.
4 Forth Generation The latest child of the computer
family that uses LSI chips has been
named the 4th Generation
computers, which marks increased
user computers integration and
speed.

5 Fifth Generation Japan and many other country are

working on systems What are
known as export system which will
considerably improve the main
machine instruction

4. વાયાંળ / ઩ુનયાલતયન : પા઱

લેર વભમ : 10 તભતનટ

● Such system would integrate the advantage in the both hardware and software technology and
would facility computer added problems slowing with the help of organized information many
specialize area.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱

લેર વભમ : 10 તભતનટ

1. Classify the generation of computers.

2. Define generation timing of computer.
3. What is the main difference between different generation computers?

6. શલે ઩છીન૊ ઩ાઠ : પા઱

લેર વભમ : 05 તભતનટ

Function Of Computer

10
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 5 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Function Of Computer.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેતુ઒ / રેળનના અંતે તારીભાથી :
1. Input unit 2. Memory unit
3. ALU 4. Control unit
5. Output unit

1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 05 તભતનટ

2..1 વભીક્ષા / યીવ્યુ
● Generation of computer would integrate the advantage in the both hardware and software
technology and would facility computer added problems solving with the help of organized
information many specialize area.

2..2 અણબપ્રેયણા :
● In industry and commercial. co, complain are becoming as accepted valuable food for everyday
use but they still lend to be sugar did as exotic luxuries.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેતુ઒ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્ટ શીન્ટ
1 Input unit 1. Give the Input unit: The purpose of the input BLOCK DIAGRAM OF
name of Input unit is to accept the input data which COMPUTER
device. is required to store the problems

2 Memory unit 2. Give the Memory unit: the memory unit

name of retains the slips for solution and
Output initial input –data, the intermediate
device. and final results.

3 ALU Arithmetic unit: the arithmetic unit

per forms all mathematical
computation upon receiving
instruction from control unit.
4 Control unit
Control unit: This unit performs the
most vital function in the computer. It
actual all this unit and controls the
data flow between them to solve the
problem.
5 Output unit Output units: The output unit
accepts the final result and
translates them from machine code
to the readable from.

11
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● The complain does everything as per the instructions given by the programmer in his programmer.
It cannot think of its own like human being.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Study the function of each unit of computer.

2. Give the name of Input device.
3. Give the name of Output device.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 10 તભતનટ

Functions of Motherboard

12
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 6 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Functions of Motherboard

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
● Components of Motherboard
● RAM and ROM Slots in Motherboard

1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 05 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● The motherboard is a printed circuit that is the foundation of a computer and allows
the CPU,RAM, and all other computer hardware components to function with each
other.

2. .2 અણબપ્રેયણા :
● The motherboard is the primary component of the entire system.A mother board is a
large board containing a number of tiny electronic circuits and other components are
visible. All peripheral devices are connected to the motherboard.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 30 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
The
components of the
motherboard are:

The floppy drive connects to the RAM has been

1. Floppy Port Explain Floppy computer via a packaged in
port. 34-pin ribbon cable, which in many different
turn connects to the ways:
motherboard. 1) SIMM-
Single inline
2. RAM slots describe RAM Random-Access Memory (RAM) memory
slots stores programs and module -32 or
data currently being used by the 72 Pin
CPU. 2) DIMM- Dual
3. ROM BIOS Chip Give full form of Inline Memory
ROM and BIOS On PCs, the BIOS module -168
contains all the code required to pin.
control the keyboard, display
screen, disk drives,
serialcommunications, and a
number of
miscellaneous functions.

13
 The BIOS is typically placed in a
ROM chip
4. What is the use of Most CMOS
CMOS battery? CMOS (Complementary Metal- batteries will
CMOS Battery
Oxide- last the
Semiconductor) is the term lifetime of a
usually used motherboard
to describe the small amount of (up to 10
memory on a computer years in most
motherboard cases) but will
that stores the BIOS settings. sometimes
5. what is an ISA
need to be
ISA slot Slot? (Industry Standard replaced.
Architecture) It is the standard
architecture of the Expansion
bus.
Motherboard may contain some
slots to
6. Where is connect connect ISA compatible cards. PC
PCI slot motherboards
PCI slot?
The PCI bus is used to connect have one PCI
I/O devices to the main logic of slot
the computer. PCI(Peripheral but generally
Component Interconnect) bus more than
has replaced the ISA one.
Give full form of bus.
AGP?
7. The Accelerates Graphics
Port (AGP) is a highspeed point-
AGP slot to-point
channel for attaching a video
card to a
computer's motherboard.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● The motherboard is the primary component of the entire system.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Explain components of motherboard.

2. Give Full Form of following:
1. PCI
2. AGP
3. ISA
4. CMOS

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Source data input devices

14
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 7 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Source Data Input Devices

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Point of sale terminal
2. Laser Beam scanners
3. Optical Characters Readers(OCR)
4. Magnetic Ink Character Recognition(MICR)
5. Optical Mark Reader(OMR)
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1.
.3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Data is converted into machine code & then temp stores & waited for processing on an
input media.
2. .2 અણબપ્રેયણા :
● Back in the old days, when mainframe computers ruled and a single disk drive was around
the size of a refrigerator, an input device was something used to transfer data to a
computer, such as a card reader or a paper tape reader.
● An offline input device was something (usually a specialized mini-computer) like an optical
character reader which would create machine readable media (such as magnetic tape)
which could be carried to the computer to be processed.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Point of Sale What is Input Point of sale terminal processes These are
Terminal Device? transactions that occur over and over devices used
again. to enter data
data directly
Laser Beam Explain uses of Laser beam scanning is used most often from its source
2. Scanners Laser by far in confocal microscopes. There are without the
BeamScanners. many ways by which a laser beam need for key
can be scanned across the back focal entry methods.
plane of an objective lens, but in general, This saves
the most popular ways utilise a tube lens time and
Write diference
and a scan lens. A beam scanning eliminates
between OCR and
arrangement is placed in back focal errors.
OMR.
plane of the scan lens, generally
consisting of at least one mirror mounted
on a galvanometer driver. As the mirror
rotates, the angle of incidence of the
resulting collimated beam varies at the

15
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
back focal plane and this causes a
diffraction-limited spot to move in the
objective‘s focal plane

3. OCR Optical Character Reader examines each

character one by one, whatever be the
style-hand written or printed. The pattern
detected by the OCR reader is matched
against a set of patterns stored in the
computer.

4. MICR The concept behind MICR is that human

readable characters are printed on
documents in a magnetisable ink. This
enables magnetic ink reader to recognize
the characters for input to the computer.

5. OMR Optical Mark Recognition is the process

of gathering data with an optical scanner
by measuring the reflectively of light at
predetermined positions on a surface.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ
● While MICR is mainly limited to finance industry, particularly banks to prevent frauds through use of
counterfeit checks and demand drafts, OCR has much wider application and is used in many
industries.
● OCR is today being used in schools, government institutions and other businesses.
● OMR devices work with a dedicated scanner device that shines a beam of light onto the form
paper.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Give the full form of following

1. OCR 2. OMR 3. MICR
2. What is the difference between OCR and OMR?
3. Write the uses of OMR, OCR, and MICR.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Output Device

16
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 8 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Output devices

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
● Types of Output devices:
1. Hard copy device
2. Soft copy device
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer operator & programming assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● MICR is mainly limited to finance industry, particularly banks to prevent frauds through use of
counterfeit checks and demand drafts; OCR has much wider application and is used in many
industries.

2. .2 અણબપ્રેયણા :
● The communication between an information processing system (such as a computer), and the
outside world.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1 Hard copy 1. Define output Printers are used for producing
device: device. output on paper.
There are large variety of printing
devices which can be classified
according to the print quality and The speeds
2. Types of Output the printing speeds.
devices. range from 40
Following are the mostly used characters per
printers. second (CPS) to
Dot matrix about 1,000 cps.
printer Dot-matrix printer: This uses a
print head containing banks of The typical
wires moving at high speeds speeds range
against linked ribbon and paper. from 50 cps to
Characters are produced in matrix above 300 cps
format. and well used
inkjet printer
for production of
Inkjet printer: These print by color printing.
spraying a controlled stream of tiny
droplets accurately on the paper
forming either dot matrix or solid
character. This is relatively silent
high quality printer.

17
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
laser printer This is a high quality, high speed Speeds can
and high volume technology. range from 10
Printing is achieved by defecting pages a minute
laser beam on to the photo to about 200
sensitive surface of a drum and pages per
the latent image attracts the toner minute.
to the image area.
The toner is then electrically
transferred to the paper and fixed
into a permanent image.

plotter output Besides printer, special plotters

have been designed to produce
good quality drawing and graphs.
There are two types of plotters :

Drum plotters: The paper on

which the graph is to be drawn is
mounted on a rotating drum. A pen
which can move linearly.

Flat bed plotter: It has a

stationary horizontal plotting
Monitor surface on which paper is fixed.
The pen is mounted on a carriage
which can move in either X or Y
direction.

Types of monitor CRT,LED,LCD

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● There are large variety of printing devices which can be classified according to the print quality and
the printing speeds.
● Laser printer is a high quality, high speed and high volume technology.
● Special plotters have been designed to produce good quality drawing and graphs.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Define output device.

2. Define types of Output devices.
3. Define types of printer.
4. Define types of plotter.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 55 તભતનટ

Computer hardware & Input Devices and Antivirus

18
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 9 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Computer software hardware & Input Devices and Antivirus

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Computer Hardware
2. Different Types of Input Devices
3. Antivirus

1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :

● Program can be written and understood easily in Higher Level Language, but Computer
understands only Machine language. ThereforeTranslator is required for particular Higher Level
Language.
2. .2 અણબપ્રેયણા :
● Physical objects that you can actually touch and seen.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Computer What is Computer hardware is the collection Physical objects that
Hardware hardware? of physical elements that constitute a you can actually
And software computer System. Computer touch.
hardware refers to the physical parts
or components of a computer such
as monitor, keyboard, Computer data
storage, hard drive disk, mouse,
CPU.

What is Type of software

software? 1). Application software
system software

2. Input Devices Explain Input Three Types of input devices.

devices with 1. Online input devices
example. 2. offline input devices
3. Source data input devices

Online input devices are used for a

3. Online Input system of real time applications. The
Devices data entered could be processed
immediately and the output is shown
to user.

19
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
4. Dumb Terminal These consist of a keyboard and a
display unit. They can't store any
information.

5. Voice Voice Recognition Device is used for

Recognition recognize the human speech. It For eg. ATM centres
Device consists of a microphone or , where in a user can
telephone that converts the human withdraw cash from a
speech into electrical signals. bank a/c.
Advantage of Voice recognition
System is lower data entry costs and
higher accuracy. Perform operations
6. like locating, copying,
Touch tone
Through a touch tone terimnals, the or moving files .
terminals
user interacts with the system by
touching the screen /monitors itself.

Mouse is a pointing device which can

7. Mouse be used very effectively on GUIs like
windows.
Different Types of mouse:-
1. serial mouse
8 2. PS/2 mouse
3. Bus mouse

Antivirus Give examples Antivirus ensures protection of your

of antivirus computer against known and new
threats.
Antivirus software was originally
developed to detect and remove
computer viruses, hence the name.
modern antivirus software can
protect from: malicious browser
helper objects (BHOs), browser
hijackers, ransomware, keyloggers,
backdoors, rootkits, trojan horses,
worms, malicious LSPs, dialers,
fraudtools, adware and spyware
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Hardware is a comprehensive term for all of the physical parts of a computer, as distinguished from
the data it contains or operates on, and the software that provides instructions for the hardware to
acoomplish tasks.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is Input Device?
2. Define computer hardware.
3. Explain Voice recognize Device.
4. Define Touch tone terminals.
5. Expalin Antivirus software.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 55 તભતનટ

Memory device and flash Memories.

20
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 10 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Memory device and flash Memories.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Memory
2. Memory Device
3. Flash memory

1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● The invention of semiconductor technology it underwent many modifications and ultimately a chip
containing whole CPU and control timing unit was made. This chip is known as microprocessor and
the computer using a microprocessor is called microcomputer.

2. .2 અણબપ્રેયણા :
● Computer data storage, often called storage or memory, is a technology consisting of computer
components and recording media used to retain digital data. It is a core function and fundamental
component of computers.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1 Memory 1. Define term of Memory or storage refers to
memory? the area within a computer
used for storage data.
2. What is the
Types of Memory function of 1. Primary Memory: The CPU
memory? accesses the memory directly
without the help of any other
device.

2. Secondary Memory: The

CPU takes the help of some
device called as controllers
Primary memory which are special circuitry built
device: in the motherboard.

1. RAM: random access

2 memory (r/w memory).
This memory is volatile, thus
losing stored data when power
is turned off.

21
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
There are two types of RAM.
A. Dynamic RAM: it uses
capacitor to store the
information as a change it has
high density and speed.
Than other memory but the
main drawback of it is that the
charge up spread out after
every millisecond, we have to
rewrite the information after
some period of time.
It is called refreshing the
memory & needs extra circuit
for it.

B.Static RAM: This memory is

made up of flip-flop and store
the information as voltage.

2. ROM: Read only memory.

Rom is a non volatile memory.
We cannot change
the information stored in
3 Flash memory ROM. But can only read.

3. PROM: Programmable read

only memory.
We can write the information in
this ROM but once you gave
written any information in it
you can‘t change it but we can
only read it.

4. EPROM: Erasable
programmable read only
memory.
In this type of ROM we can
read the information, & change
the unnecessary information.

5. EPROM: Electrically
erasable prom.

Flash memory is a memory

storage device for computers
and electronics. It is most often
used in devices like digital
cameras,USB flash drives, and
video games. Flash memory is
much slower than RAM or
hard drives.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Memory or storage refers to the area within a computer used for storage data.
● Primary Memory, The CPU accesses the memory directly without the help of any other device.
● Secondary Memory, The CPU takes the help of some device called as controllers which are
special circuitry built in the motherboard.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

22
 1. Define term of memory
2. What is the function of memory?
3. What do you mean by the term ‗volatile‘?
4. Which component is used in semi conductor memory?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Secondary memory device

23
24
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 11 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Secondary memory device.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Floppy Disk 2. Hard Disk 3. CD – ROM
4. DVD Writer 5. Blu-ray Writer 6. Pen drive

1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Memory or storage refers to the area within a computer used for storage data.
2..2 અણબપ્રેયણા :
● A data storage device is a device for recording (storing) information (data). Recording can be done
using virtually any form of energy, spanning from manual muscle power in handwriting, to acoustic
vibrations in phonographic recording, to electromagnetic energy modulating magnetic tape and
optical discs.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
Secondary 1. What is a Data stored in internal (primary)
storage device secondary device? memory of computer is lost when
we switch of the computer. So, for
permanent storage of data we have
There are three
to use secondary storage devices,
types of floppy
also called external storage
disk.
1 Floppy Disk 2. Why we need (1) 8‖
secondary Floppy disk is a circular plate
(2) 5.25‖
devices? coated with magnetic material. It is
(3) 3.5‖
enclosed in a jacket with is made of
Storage capacity
a special fiber that allowed for the
of floppy disk
air to cushion the disk when it is
Hard Disk The storage
2 rotating at high speed and avoid
capacity of the
wear and tear to the disk.
hard disks is
Many times more
A hard disk is fixed inside the
than the floppy
cabinet of CPU. It is made up of
disks.
many rigid metal platters coated to
store data magnetically. The hard
disk Rotates while recording data.
This rotation speed is measured in
the unit of revolutions per minute
(rpm)

25
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
3 CD - ROM 3. List different Now a day‘s CD ROM is most
name popular and used secondary
of storage. CD Rom means compact
secondary disk like hard disk we can store
devices? information in CD Rom and
whenever we needed can retrieve
DVD writer it. We can transfer it from one place
to another very easily.
4
Digital video disc or digital versatile
disc is the next generation of optical
disc storage technology. It‘s a
bigger, faster CD that can hold
Blu-ray Writer cinema- like video, better-than-CD
audio, and computer data.
5
The introduction of Blu-ray Discs
(BD) in 2006. With their high
storage capacity, Blu-ray discs can
hold and play back large quantities
Pen drive
of high-definition video and audio,
6 as well as photos, data and other
digital content.

A pen drive is storage media almost

like a CD but it is inserted in the
drive in your CPU.
You can use it in a laptop as well as
a car.
USB pen drive is the best among
the removable storage devices for
its portable and easy to use
features.
Advantages Flash drives are small but solid
devices as they come in highly
of secondary durable designs nowadays.
storage device

1. Secondary storage device are

non-volatile in nature.
2. They have large data /
information storage capacity.
3. These are removable disks,
Limitation easily portable, and thus are
suitable for archival storage.
of secondary 4. Mass replication is inexpensive
storage device and fast.

1. Access time is higher in case of

secondary storage device.
2. CPU cannot access these
devices directly. It takes help of
detrain controller which require
extra circuitry.

26
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● All information given to the computer stored in ram but this information is lost when we switch off
the computer. So we need an external media in which we can store data permanently floppy disk,
hard disk, magnetic tape, CD ROM are devices used as an external storage.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is a secondary device?

2. Why we need secondary devices?
3. List different name of secondary devices?
4. What is CD ROM?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to basic DOS Internal and External Commands.

27
28
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 12 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Introduction to basic DOS Internal and External Commands.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. DOS
2. Internal Commands
3. External Commands
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● The computer does everything as per the instructions given by the programmer in his program. It
cannot think of its own like human being.

2. .2 અણબપ્રેયણા :
● An Operating System is a set of programs that controls and coordinates the use of computer
hardware among various application programs. It provides an environment within which user can
execute programs.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. DOS MSDOS:- Micro Soft Disk Handling Error
Operating System. MSDOS is an when they
operating system. It has two occur
types of command
How can you make
(1) internal command or and using
your file read only?
resident command corrective
(2) external command or routings which
nonresident command are possible.
2. Internal command What is
internal Internal command are built in
command? command which are stored up as
command .com & and hidden
files.
ex. IBM or ms dos .sys & bios
.sys the internal command are
1. cls – clear the screen
2. date- to edit or to see the
system date
3. time – to edit or to see the
system time
4. dir – list the directory of the disk

29
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
5. copy – to copy‘ one file into
another file or disk Erase or
del- to delete files.
6. Prompt- to change the dos
prompt.
7. Ren – to change the name of
a file.
8. Rename - Renames a
file/directory or files
/directories.
9. Ver- to see the version of the
dos.
10.
ol – to see the volume label of
the disk
11.md – to make subdirectory
12.cd – to change
the subdirectory
3 External What is external 13.rd - remove the subdirectory
Commands command? 14.Path – to set or see the path
for bat,exe or com files.
Type – to see the contents of file
on the screen.

External commands or
nonresident command s can be
executed when their particular
files are present on the disk.
Otherwise it cannot be executed
their files gave an extension of
.com or .exe.

Some external commands are as

follows :
1. Attrib – security of files can be
maintained to read only.
2. Chkdsk – specifies the
information of disk drive or a
floppy diskette
3. Comp – compares the two files.
4. Disk copy – copies the whole
diskette from source drive to
target drive.
5. Label – to change the volume
label of diskette
6. Format – make a market‘s
newly available disk to work. On
computer by formatting or
sketching virtual cylinder (tracks &
sector) on the magnetic material.
This command is also useful to
make a disk bootable.
7. Tree: - it shows the tree of files
& subdirectory of the disk.
8. Edit: - by edit file you can edit a
file line wise & you can also
creating a new file.
9. Sys: - this command is use full
to copy system file (hidden file of
dos) to another disk.
10. Disk comp: - compare one
diskette with another diskette.

30
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ
● MSDOS means Microsoft disk operating system it is one type of operating system. It is mainly use
for micro computer
● External command is nonresident commands. And each external command need their particular
files (which have extension exe pr.com) when they are executed.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is internal command?

2. What is external command?
3. What is the function of format command?
4. Explain the use of edit command?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to Open Source Software

31
32
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 13 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Introduction to Open Source Software.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Open Source Software
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● With the many business and government organizations that now use open source software such as
Linux, it's becoming increasingly clear that price is not the only advantage such software holds.

2. .2 અણબપ્રેયણા :
● Open source software (OSS) is an important part of mainstream software development
organizations. Active OSS use in development can drive down costs, speed time to market and
increase software functionality, all without adding to the bottom line.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Open What is Open source refers to a program
open or software in which the source
Source Software source software? code (the form of the program
when a programmer writes a
program in a particular
programming language) is
available to the general public for
How to use OSS? use and/or modification from its
original design free of charge.

Open source code is typically

created as a collaborative effort in
which programmers improve
upon the code and share the
changes within the community.

Open-source software (OSS) is

computer software with its source
code made available with a
license in which the copyright
holder provides the rights to
study, change, and distribute the
software to anyone and for any
purpose.
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ

33
 Benefits of Using Benefits of OSS. ● Reliability
Open Source ● Stability
Software ● Auditabilty
● Cost
● Flexibility and freedom
● Support and
accountability

Characteristics
Five characteristics 1. Fostering a culture of
of an open source citizen participation
of an OSS.
city 2. Having an effective open
government policy
3. Having an effective open
data initiative
4. Promoting open source
user groups and
conferences
5. Being a hub for
innovation and open
Disadvantages of source businesses
open source
software 1. Most open source
software applications are
not reliable
2. No support exists for
open source software
3. Higher installation costs
4. No guarantee of updates

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Open source software can be modified by anybody and then redistributed because its code is
supposed to be freely available, unlike the commercial software applications that you cannot alter
and redistribute.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is open source software?

2. How to use OSS?
3. Benefits of OSS.
4. Characteristics of an OSS.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to Linux Operating System features, structure, files and processes.

34
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 14 સ.ુ ઇ.નું નાભ :
રેળનનુનાં ભ : Introduction to Linux Operating System features, structure, files and
processes

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Linux Operating System
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● The operating system is the most important program that runs on a computer. Every general-
purpose computer must have an operating system to run other programs and applications.
2. .2 અણબપ્રેયણા :
● Linux is one of popular version of UNIX operating System. It is open source as its source code is
freely available. It is free to use. Linux was designed considering UNIX compatibility. Its
functionality list is quite similar to that of UNIX.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Linux What is operating Linux Operating System has primarily
system? three components
Operating System
Kernel - Kernel is the core part of
Linux. It is responsible for all major
activities of this operating system. It
What is
is consists of various modules and it
Linux
interacts directly with the underlying
Operating
hardware. Kernel provides the
System?
required abstraction to hide low level
hardware details to system or
application programs.

System Library - System libraries

are special functions or programs
using which application programs or
system utilities accesses Kernel's
features. These libraries implements
most of the functionalities of the
operating system and do not requires
kernel module's code access rights.
System Utility - System Utility
programs are responsible to do
specialized, individual level tasks.

35
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
structure Define structure of
Linux OS.

Basic feature of
Linux OS.

Basic Features
Following are some of the important
features of Linux Operating System.

● Portable
● Open Source
● Multi-User
● Multiprogramming
Files types ● Hierarchical File System
● Shell
● Security
Symbol Meaning
- Regular file
d Directory
l Link
c Special file
s Socket
p Named pipe
b Block device

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Linux is, in simplest terms, an operating system. It is the software on a computer that enables
applications and the computer operator to access the devices on the computer to perform desired
functions.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is operating system?

2. What is Linux Operating System?
3. Define structure of Linux OS.
4. Basic feature of Linux OS.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Basic Linux commands.

36
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 15 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Basic Linux commands.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Linux commands
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● To some, the first thing that comes in mind when asked this question is "Linux is an operating
system." That's not completely false, but neither accurately true. Linux per se is only the kernel of
the operating system, the central part of it.
2. .2 અણબપ્રેયણા :
● Linux is one of popular version of UNIX operating System. It is open source as its source code is
freely available. It is free to use. Linux was designed considering UNIX compatibility. Its
functionality list is quite similar to that of UNIX.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Linux commands What is the use of date - print or set the system date
at command in and time
Linux? syntax - date[option] [+ format]

echo - Display text on the screen. For example:

Mostly useful when writing shell echo ―Hello
scripts. World‖
syntax – echo [option][string]

who - Show who is logged on

and what they are doing.
Syntax – who [option]

Give me 15 is - List all files in the current

commands which directory, in column format.
you use frequently Syntax- is [option] file/directory

cp - Copies a file from one Example: cp

location to another. mp3files.txt /tmp
Syntax - cp source file destination
file

rm - Delete a file. Example: rm

Syntax- rm [option] /tmp/mp3files.txt
[file]

37
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
mv- Moves a file to a new For example:
location, or renames it. mv mp3files.txt
Syntax- mv old_filename /tmp
new_filename

cd - Use cd to change
directories. Syntax- cd
Directory_name
mkdir- Make Directory Example: mkdir
syntax - mkdir directory_name /tmp/myfiles/

rmdir- Remove Directory. Example: rmdir

Syntax – rmdir Directory_name /tmp/myfiles/

chmod- change file access

permissions.
Syntax- chmod code filename

sort - Sort a file or program Example: sort

output. mp3files.txt
Syntax- sort [option] filename

grep- Search for a pattern in a

file or program output.
Syntax- grep [option]
string file_name

Passwd- The passwd command

changes passwords
for user accounts.
Synrax- passwd [option]

pwd- ―Print Working Directory‖.

Shows the current location in the
directory tree.

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Here is a list of basic linux commands. This list of linux commands is not complete as there are
many more linux commands available. However, it should make a good start for a beginner or
intermediate linux administrator / linux user.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. How to check current run level of a Linux server?

2. Give me 15 commands which you use frequently
3. What is the purpose of strings command?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to the various applications in office.

38
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 16 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Introduction to the various applications in office.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Applications in office

1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Office gives you the freedom to get work done virtually anytime, anywhere, and on any device.

2. .2 અણબપ્રેયણા :
● Microsoft Office is a set of interrelated desktop applications, servers and services, collectively
referred to as an office suite, for the Microsoft Windows and Mac OS X operating systems.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Word Which file starts MS Microsoft Word is a word
Word? processor and was previously
considered the main program in
Office.
Its proprietary DOC format is
considered a de facto standard,
although Word 2007 can also use
a new XML-based.
Microsoft Office-optimized format
called .DOCX, which has been
How do I obtain a standardized by Ecma
back-up copy of my International as Office Open XML.
Excel Office product?

Microsoft Excel is
a spreadsheet program that
originally competed with the
dominant Lotus 1-2-3, and
eventually outsold it.
It is available for the Windows
and OS X platforms.

39
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
PowerPoint Which file Microsoft PowerPoint is
starts a presentation program
PowerPoint? for Windows and OS X.

It is used to create slideshows,

composed of text, graphics, and
other objects, which can be
displayed on-screen and shown
by the presenter or printed out
on transparencies or slides.

Microsoft Access is a database

Access management system for Windows
that combines the relational
Microsoft Jet Database Engine
with a graphical user interface
and software-development tools.
Microsoft Access stores data in its
own format based on the Access
Jet Database Engine.

Outlook Microsoft Outlook is a personal

information manager.

The replacement for Windows

Messaging, Microsoft Mail, and
Schedule starting in Office 97, it
includes an e-mail client,
calendar, task manager and
address book.

OneNote Microsoft OneNote

is a freeware
note taking program.
It gathers notes (handwritten or
typed), drawings,
screen clippings and
audio
commentaries.
Notes can be shared with other
OneNote users over the Internet
or a network. OneNote was
initially introduced as a
standalone app that was not
included in any of Microsoft Office
2003 editions.

● Microsoft Publisher
Other desktop ● Microsoft Project
applications ● Microsoft Visio
● Microsoft SharePoint
Designer

● Office Online
Web services ● Sway
● Microsoft Office website
● Microsoft Update
● Microsoft Office 365

40
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Microsoft Office is an office suite of desktop applications, servers and services for Microsoft
Windows and OS X operating systems. It was first announced by Bill Gates of Microsoft on 1
August 1988 at COMDEX in Las Vegas.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Which file starts MS Word?

2. Which file starts PowerPoint?
3. How do I install Office?
4. How do I uninstall Office?
5. What mobile apps are available for Office?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to Word features, Office button, toolbars.

41
42
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 17 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Introduction to Word features, Office button, toolbars.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Word features
2. Office button
3. toolbars
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Office gives you the freedom to get work done virtually anytime, anywhere, and on any device.

2..2 અણબપ્રેયણા :

● A full-featured word processing program for Windows and Mac OS X from Microsoft. Available
stand-alone or as part of the Microsoft Office suite, Word contains rudimentary desktop publishing
capabilities and is the most widely used word processing program on the market.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Word ● Open File
features ● Bold, Underline, and Italicize
● Highlighting Text
● Changing Font Color
● Cut and Paste
● Cutting and Pasting by Using the
Standard Toolbar
● Cutting by Using the Icon
● Coping by Using the Icon
● Pasting by Using the Icon
● Using AutoText Cut and Copy
Office button ● Inserting Text
● To change to the Insert mode
● To Overtype

The user interface has been significantly

2. redesigned in the following 2007 Microsoft
Office system programs: Word, Excel,
PowerPoint, Access, and Outlook (in the
composing and reading windows).
.

43
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ

The Office Button replaces

theFile menu

When you click the Office Button ,

you see the same basic commands
available on the File menu in earlier
Which bar is
releases of Microsoft Office to open, save,
usually located
and print your file.
below that Title
Bar that
3 Toolbars: provides
categorized
options?

File Menu
In file menu following item see:
New, Open, Close, Save, Save as, Save
as web page, Version, Page preview,
Edit Menu page setup, print preview, exit

In edit menu following option is available:

Can't Undo, Repeat typing, Cut, Copy,
View Menu Paste, Paste Special, Paste as hyperlink,
Clear, Select all, find, Replace all, Go to,
Which menu in Link, Object
MSWord
In view menu following option is available:
can Normal, web layout, Print layout, out line,
Insert Menu be used Tool bar, Ruler, Document Map, Header
to change & Footer, Footnote, Comment, Full
character size screen, Zoom
and typeface?
Format Menu In Insert menu following item see:
Break, Page numbers, Date & time,
Symbols, comments, footnote, picture,
auto text, text box, file, object

In Format menu following item see:

Tool Menu Font, Paragraph, Bullets &numbering,
border &shading, columns, Tabs, Drop
cap, Tax direction, Change Case, Back
ground, Theme, frame, auto format, style,
object

In Tool menu following item see:

Spelling & Grammar, language, word
count, auto summaries, auto correct, look
up & reference, Track change, Merge

44
 document, Protect document, On line
coloration, Mail merge, Envelop & tabs,
Letter wizard, Macro, Template,
Table menu Customize

In Table menu following item see:

Creating a table, sorting, Delete, Select,
Merge cells, Split cells, split Table, Table
auto format, AutoFit, Converts

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Microsoft Word has been part of the Office Suite since its inception and today remains the world‘s
most popular word processing program.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. MS OFFICE Is Application Software?

2. The minimum number of rows and columns in MS Word document is
3. How many columns can you insert in a word document in maximum?
4. What is the smallest and largest font size available in Font Size tool on formatting toolbar?
5. By default, on which page the header or the footer is printed?
6. In Microsoft Word shortcut key CTRL+W is used for.
7. Which shortcut key is used to spell check in MS-Word.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Creating, saving and formatting and printing documents using Word.

45
46
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 18 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Creating, saving and formatting and printing documents using Word

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Creating a new documents 2. Formatting the document
3. Save the documents 4. Printing the documents
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Office gives you the freedom to get work done virtually anytime, anywhere, and on any device
2..2 અણબપ્રેયણા :
● Microsoft Word is a word processor and was previously considered the main program in Office.
● When you want to format text in Microsoft Word, you can do it manually, by selecting font, size,
color, alignment and other attributes, but you‘ll often find it easier to apply formatting with styles.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Creating a new How to create 1. Click the File tab.
documents new 2. Click New.
document? 3. Double-click
Blank document.

Start a document from

a template

1. Click the File tab.

2. Click New.
3. Under Available
Templates, do one of
the following:
- Click Sample
Templates to select
a template that is
available on your
computer.
- Click
Sample Templates to
select a template that is
available on your
computer.
4. Double-click the template
that you want.

47
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
2. Save How to save Save a document for the first
document in time
the documents word? 1. On the Quick Access
Toolbar, click Save ,
or press CTRL+S.
2. Type a name for
the document, and then
click Save. Save an existing
document as a new document
(Save As)
1. Open the document that you
want to use as the basis for the
new document.
2. Click the Microsoft Office

Button , and then

click Save As.
3. Type a name for the
document, and then click Save.
4. Edit the document the way
that you want.

In Word, every document is

comprised of three basic levels:
3. Formatting ● Sections. Every Word
document has one or
the document more sections.
● Paragraphs. Every
section has one or more
paragraphs.
● Characters. Every
paragraph has one or
more characters.
There are several advantages to
using styles in Word:
● Consistency.
● Speed
● Navigation.
● Tables of Contents.

Open the document you wish

to print. Choose one of the
options below, unless the
document you wish to print is
Printing the already open.
4.
documents In Word 2003, select Open from
the File menu, or click the Open
toolbar button.
In Word 2007, click the Office
button in the upper left and
select Open from the File menu.
In Word 2010, click the File tab
and select Open.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Microsoft Word is part of the Microsoft Office package, which is a document processing application
developed by Microsoft. There are other applications quite similar with Word‘s interface and
application, but nowhere mainstream status that Microsoft Word has achieved. In result, Microsoft
Word stands out on top of the popularity contest compared to other applications.

48
5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. How to create new document?

2. How to save document in word?
3. How to format sections, paragraphs and characters?
4. How to Print pages in word?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Working with inserting objects, macro, mail merge, templates and other tools in Word.

49
50
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 19 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Working with inserting objects, macro, mail merge, templates and other tools in
Word.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Inserting objects in word 2. macro
3. Mail merge 4. Templates
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Mail Merge is a powerful tool for writing and sending a personalized letter or e-mail to many
different people at the same time.
2. .2 અણબપ્રેયણા :
● Mail Merge is a feature designed for creating mass mailing and emails, as well as envelopes and
labels with different information on each one. You can load a database of recipients or manually
enter them, and then use placeholders, or "Fields", to automatically fill in each recipient's
information in their own copy. This allows you to create one document that you can send to
hundreds or even thousands of people.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. inserting 1. Place the mouse cursor where you
objects in want to create the object.
word 2. From the Ribbon, under the
tab Insert, within the group Text, click
Object. The object dialog box appears.
3. Select an object to create from the
Object Type list.
4. Select the Display as icon check
box.
5. Word creates an icon of the selected
Program at the cursor position and opens
the program to create a new file.

See Figure 19.3.1

51
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
2. macro How to use To save time on tasks you do often,
mail-merge? bundle the steps into a macro. First, you
record the macro. Then you can run the
macro by clicking a button on the Quick
Access Toolbar or pressing a combination
of keys. It depends on how you set it up.

Click View > Macros > Record Macro.

3. mail merge The mail merge process entails the

following overall steps:
1. Set up the main document.
2. Connect the document to a data source.
3. Refine the list of recipients or items.
4. Add placeholders, called mail merge fields,
to the document.
5. Preview and complete the merge.

Set up the main document

1. Start Word.
2. On the Mailings tab, in the Start Mail
Merge group, click Start Mail Merge.

Templates 3. Click Letters.

You can also use mail merge to create:

● Directory
● Envelopes
● Labels
4. ● E-mail messages

Start with a blank template

1. Click the File tab, and then click New.
2. Click Blank document, and then
click Create.
3. Make the changes that you want to the
margin settings, page size and orientation,
styles, and other formats.
4. Click the File tab, and then
click SaveAs.
5. In the Save As dialog box, do one
of the following:
● On a computer that is running
Windows 7, scroll to the top of the
folder list, and under Microsoft
Wordclick Templates.
● On a computer that is running
Windows Vista, under Favorite
Links, click Templates.
● On a computer that is running
Windows XP, under Save in,
click Trusted Templates.

6. Give the new template a file name,

select Word Template in the Save as
type list, and then click Save.
7. Close the template.

52
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ
● If you plan to use custom contact fields with the Contacts list in Microsoft Outlook or if you plan to
use a Public Folders Contacts folder, you must begin the mail merge process in Outlook.
5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ
1. How to insert objects in word document?
2. How to use mail-merge?
3. How do you create and print form letters?
4. How do you perform a mail merge to labels?
5. How to add a button to Word 2010 for a macro at document level ?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Page setup and Printing Documents using word.

Figure 19.3.1

53
54
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 20 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Page setup and Printing Documents using word.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Page setup
2. Printing Documents
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● The Page Setup command in the File menu invokes the Page Setup dialog box. You can use this
dialog box to adjust the printing as per your requirement.
2. .2 અણબપ્રેયણા :

● You can print all your document by pressing on the button. However, Word offers you
also several options for the printing.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Page setup The Page Setup command in the
File menu invokes the Page Setup
dialog box. You can use this dialog
box to adjust the printing as per
your requirement.
The Margins tab on the Page
Setup dialog box is used to specify
the top, bottom, left, and right
margins of the page.
In a document with two-sided
pages, you can apply the gutter
margin using the Gutter spin-box. A
gutter margin adds extra space to
the side or top margin of a
document you plan to bind and
ensures that the binding does not
obscure text.
Also, you can change the
orientation of the printing using the
Orientation area. The Portrait
option prints the document so that
the short edge of the paper is the
top of the page. The Landscape

55
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
What is option prints the document so that
gutter the long edge of the paper is the Margins-used
margin? top of the page. to adjust
spacing
See Figure 20.3.1.1 Gutter- Allows
space for
binding
Page Setup Orientation -
1. Click the File Menu and choose used to
Page Setup change
2. Choose from the tabs at the top direction of
to see different choices paper

Printing Preview the document

2 Preview –
Documents Watch it as
1. Click File, and then click Print.
you make
2. To preview the next and changes
previous pages, at the bottom of
the Print Preview window,
click Next Page and Previous
Page.

Set printing options

1. To change the printer, click the

drop-down box under Printer, and
select the printer that you want.
Keyboard
2. To make page setup changes, shortcut -
including changing page CTRL+P.
orientation, paper size, and page
margins, select the options that NOTE: The
you want under Settings. preview
window
3. To fit more than one page of
displays black
your document on a single printed
and white,
page, under Settings, click the
regardless of
option that you want in the scale
whether your
options drop-down box.
document
See Figure 20.3.2.1 includes color,
unless you are
using a printer
that can print
color.

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Once you‘ve finished drafting, editing and formatting your document, you most likely will want to
print a hard copy. Word allows you to print a selection, the current page, a range of pages, or the
entire document, depending on your requirements. You can print one or more copies, document
properties, odd or even pages, or even several pages per sheet.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

56
1. What is gutter margin?
2. How do I change the page orientation to landscape?
3. How to change page orientation?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to Excel features and Data Types.

Figure 20.3.1.1 Figure 20.3.2.1

57
58
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 21 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Introduction to Excel features and Data Types.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Excel features
2. Data Types
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Excel is useful for filtration of different types of query .It is very useful in many areas.
2..2 અણબપ્રેયણા :
● Excel allows us to perform calculations (like a calculator) and manipulate text (like a word
processor). Microsoft Excel has the basic features of all spreadsheets, using a grid
of cells arranged in numbered rows and letter-named columns to organize data manipulations like
arithmetic operations.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Excel features 1. Pivot Tables
PivotTables summaries large
amounts of Excel data from a
database that is formatted where
the first row contains headings
and the other rows contain
categories or values.

2. Conditional Formatting
Conditional formatting helps users
to quickly focus on important
aspects of a spreadsheet or to
highlight errors and to identify
important patterns in data.
3. Sorting and Filtering
Excel spreadsheets help us make
sense of large amounts of data.
To make it easier to find what you
need, you can reorder the data or
pick out just the data you need,
based on parameters you set
within Excel.

59
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
4. Basic Math
At the heart of any Excel
Spreadsheet is the numbers
within the data. Using basic math
functions to manipulate those
numbers is one of the features
that make Excel so powerful.

5. Mixed Type Charts

Mixed type or combo
(combination) charts combine two
styles of charts, such as Excel‘s
column chart and line chart. This
format can be helpful for
displaying two different types of
information or a range of values For example:
2. Data Types 1. Define the that varies greatly The statement
logical data types. "1 is less than
The Logical Data Type 2" is
● Logical values are either recognizable
TRUE or FALSE. as a true
● In most cases, logical statement.
values will be present as Another way to
the result of the put that is:
evaluation of an 1 < 2 = TRUE
expression or function.
Essentially, a logical
value represents the
resolution of an
expression indicating
whether certain
conditions have been
met.
2. Define The Number Data Type
the numeric ● Numerical values are, of
data types. course, numbers. This is
more complex than it first
appears, however. First
of all, Excel stores all
numbers as Double-
Precision Floating
Point values.

The Text Data Type

3. Define the text
data types. ● Microsoft Excel regards
test as strings of
characters. The letters of
the alphabet, numerical
characters, symbols such
as % and $, as well as
spaces and tabs are all
valid text. For example,
● In cases where Excel division by zero
cannot distinguish a value is
as either a number type, mathematically
a logical type, or an error undefined, and
type, the value will be the machine
treated as text. cannot, by
itself, resolve
this error.
The Error Data Type

60
4. Define the error

61
 data type. ● There are instances in
which errors will occur
when Excel evaluates the
contents of a cell.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Excel will recognize a text string of up to 32,768 characters. However, only 1024 can be displayed
in a cell.
● At the most basic level, Excel allows us to perform calculations (like a calculator) and manipulate
text (like a word processor). Its power comes from being able to do multiple related calculations,
based on its grid structure. So while with a calculator or on paper we can do simple sums, in Excel
we can do the same sum many, many times.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Define the feature of excels in brief.

2. Give the name of excel‘s features.
3. Define the logical data types.
4. Define the numeric data types.
5. Define the text data types.
6. Define the error data type.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Cell referencing. Use of functions of various categories, linking Sheets.

62
63
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 22 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Cell referencing. Use of functions of various categories, linking Sheets.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Cell referencing 2. Functions of excel
3. linking Sheets
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Cell references in Excel are very important. Understand the difference between relative, absolute
and mixed reference, and you are on your way to success.
2. .2 અણબપ્રેયણા :
● A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so
that Microsoft Office Excel can find the values or data that you want that formula to calculate.
● Microsoft Excel provides the ability for one worksheet to link to data in another worksheet. As you
will see in a moment, this is a great productivity tool.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Cell Describe cell Relative Reference
referencing reference. By default, Excel uses relative reference.
See the formula in cell D2 below. Cell D2
references (points to) cell B2 and cell C2. See Figure
Both references are relative. 22.3.1.2

Absolute Reference
See the formula in cell E3 below.
1. To create an absolute reference to cell H3,
place a $ symbol in front of the column letter
and row number of cell H3 ($H$3) in the
formula of cell E3.

See Figure 22.3.1.1

64
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
Describe Mixed Reference
function of See Figure
s excel Sometimes we need a combination of 22.3.1.3
relative and absolute reference (mixed
reference).
1. See the formula in cell F2 below.

● Compatibility functions Tip: Before

2 Functions of ● Cube functions creating the
excel ● Database functions link, format
● Date and time functions the cell
● Engineering functions containing the link
● Financial functions Information formula in the
functions destination
● Logical functions worksheet to
● Lookup and reference functions equal the format
How to lin ● Math and trigonometry functions of the source
sheets k ● Statistical functions data.
excel? i ● Text functions
n ● User defined functions that
are installed with add-ins

Microsoft Excel provides the ability for one

3 linking worksheet to link to data in another
Sheets worksheet. As you will see in a moment, this
is a great productivity tool.

In Excel, a link is a formula that dynamically

pulls in data from a cell in another worksheet.
The worksheet can be in the same workbook
or a different workbook.
The destination worksheet contains the link
formula, and it receives data from a cell in
the source worksheet.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● In Excel, a link is a formula that dynamically pulls in data from a cell in another worksheet. The
worksheet can be in the same workbook or a different workbook.
● The destination worksheet contains the link formula, and it receives data from a cell in
the source worksheet.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Describe cell reference with example.

2. Describe functions of excel.
3. How to link sheets in excel?
4. Give one example of sheets linking.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Concepts of Sorting, Filtering and Validating Data.

65
Figure 22.3.1.1

Figure 22.3.1.2

Figure 22.3.1.3

66
67
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 23 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Concepts of Sorting, Filtering and Validating Data.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Sorting 2. Filtering
3. Validating Data
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● Sorting and Filtering allow you to manipulate data in a worksheet based on given set of criteria.
2..2 અણબપ્રેયણા :
● Sort the data in a spreadsheet.
● Describe the impact sorting data can have on a formula.
● Explain the difference between sorting and filtering.
● Filter the data in a spreadsheet.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Sorting Data Describe sorting in
To sort a list of data:
excel in detail.
1. Select a single cell in the column
containing the data you want to sort.
2. Select the Home tab.
3. Under the Editing group, press
the Sort and Filtering button and
select the order you want your data
to be sorted.

1. Contiguous Data
2. A to Z Button
3. Sort by 64 Columns
4. Sort Left to Right
5. Sort by Color
6. Sort By Custom List

See Figure 23.3.1.1

68
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
2 Filtering Data Filtering is a way that you can use
Excel to quickly extract certain data
from your spreadsheet.

Key Points Concerning

The AutoFilter Command:
1. Contiguous Data
2. Filter by Multiple Columns
3. Removing Filters
4. Filters are Additive
5. Three Types of Filters
6. Filters Enabled
7. Filter Applied
8. Filter Spanning
9. This Year vs. Year-to-Date
10. Filtering Dates
11. Filtering By Days of Week
12. Top & Bottom Filtering
13. Above & Below Average
Filtering
14. Filtering By Color
15. Filter by Selection
16. Refreshing Filters
3 Validating Data Data validation is an Excel feature
that you can use to define restrictions
on what data can or should be
entered in a cell. You can configure
data validation to prevent users from
entering data that is not valid. If you
prefer, you can allow users to enter
invalid data but warn them when they
try to type it in the cell.
For example, in a marketing
workbook, you can set up a cell to
allow only account numbers that are
exactly three characters long. When
users select the cell, you can show
them a message such as this one:

If users ignore this message and type

invalid data in the cell, such as a two-
digit or five-digit number, you can
show them an actual error message.

69
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Sorting arranges data in your worksheet numerically, alphabetically or chronologically.

● Filtering removes data from your work sheet that you don‘t need or want to see.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Describe the sort data in spreadsheet.

2. How to short data in spreadsheet?
3. How to filter data in spreadsheet?
4. Describe data validation in excel.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Analyzing data using charts, data tables, pivot tables, goal seeking and scenarios.

Figure 23.3.1.1

70
71
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 24 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Analyzing data using charts, data tables, pivot tables, goal seeking and scenarios.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Chart 2. Data tables 3. pivot tables
4. goal seeking
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● A chart is a technique of displaying data using pictures and graphical representations instead of
numbers or simple words.
2. .2 અણબપ્રેયણા :
● A chart works by drawing figures that would represent numbers, adding colors and shapes to the
information presented.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Chart What is the use of Charts: A simple Excel chart can
chart? say more than a sheet full of
numbers. As you'll see, creating
charts is very easy.

How to create a The information used to create a

chart? chart usually comes from two or
more cells of a worksheet. Before
creating a chart, you should
prepare it so it can be easily
recognizable.
Data used on a chart can be
made of natural numbers or
percentage values. You can also
present a series of repeating
How to create words and let the chart engine
table? count the occurrences of such
words before using them as
numbers.
2. Data tables
Tables: Tables allow you to
analyze your data in Excel quickly
and easily.

72
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
Instead of creating different
scenarios you can create a data
table to quickly try out different
How to create pivot values for formulas.
table?
pivot tables You can create a
● one variable data table
● Two variable data table.
What is goal seek?
Pivot Tables: Pivot tables are
one of Excel's most powerful
goal seeking features. A pivot table allows you
to extract the significance from a
large, detailed data set.

Excel's Goal Seek feature allows

you to alter the data used in a
formula in order to find out what
the results will be.
The different results can then be
compared to find out which one
best suits your requirements.

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Instead of creating different scenarios you can create a data table to quickly try out different values
for formulas. You can create a one variable data table or a two variable data table.
● Goal Seek is used to get a particular result when you're not too sure of the starting value.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is the use of chart?

2. How to create a chart?
3. How to create table?
4. How to create pivot table?
5. Write a use of goal seeks in excels.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to open office and power point.

73
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 25 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Introduction to open office and power point.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Open office 2. power point
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI s

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● OpenOffice.org originated as Star Office, a proprietary office suite developed by German company
StarDivision from 1985 on.
2. .2 અણબપ્રેયણા :
● Open Office is the result of over twenty years' software engineering. Designed from the start as a
single piece of software, it has a consistency other products cannot match. A completely open
development process means that anyone can report bugs, request new features, or enhance the
software.
● Microsoft PowerPoint is a slide show presentation program developed by Microsoft.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Open office Why should I use Apache Open Office is the
open office? leading open-source office
software suite for word
processing, spread
sheets, presentation, graphics,
database and more.
It is available in many
languages and works on
all common computers.
It stores all your data in
an international open standard
format and can also read and
How to start the write files from other common
PowerPoint? office software packages.
It can be downloaded and used
completely free of charge for any
purpose.
power point Start->
2. PowerPoint presentations consist Program->
of a number of individual pages or Microsoft
"slides". The "slide" analogy is a office->
reference to the slide projector. PowerPoint

74
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
Give the Advantages of PowerPoint:
advantages
Design:
● Quick and Easy
of PowerPoint.
● Simple bullet points
● Easy to create coloutful,
attractive design

Delivery

● Audience Size
● Easy to present
● No need for Handouts

File Menu:
New, Open, Close, Save, save
as, Save as web page, page
setup, print
Edit Menu:
Undo, Redo, Cut, copy, paste,
clear, duplicate, duplicate slide
View Menu:
Normal, Slide Sorter, Notes Page,
Slide Show, Master, Toolbar,
Ruler, Header & Footer, Zoom
Insert Menu:
New slide, Duplicate Slide, Slide
Number, Symbol, Comment, Slide
From Files, Slide From Outline,
textbox, Chart, Table
Slide Show Menu:
View Show, Rehearse Timing,
Set up show, Custom Animation,
Slide Transition

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● PowerPoint presentations consist of a number of individual pages or "slides".

● The "slide" analogy is a reference to the slide projector.
● PowerPoint provides numerous features that offer flexibility and the ability to create a professional
presentation.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Why should I use open office?

2. How to start the PowerPoint?
3. Benefits of PowerPoint.
4. Describe menus of PowerPoint in derails.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Creating Slide Show, fine tuning the presentation and good presentation practice

75
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 26 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Creating Slide Show, fine tuning the presentation and good presentation practice.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Creating Slide Show
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● A PowerPoint presentation can help you communicate an idea to an audience. Learn the basics
before proceeding.
2. .2 અણબપ્રેયણા :
● A slide show is a presentation of a series of still images on a projection screen or electronic
display device, typically in a prearranged sequence. Each image is usually displayed for at
least a few seconds, and sometimes for several minutes, before it is replaced by the next
image.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Slide Show 1. How to create 1. Open PowerPoint. You will see a blank
slide show? screen with two boxes in the middle of the
screen. One of the boxes says "Click to
add title," the other says "Click to add
subtitle."

2. On the tab at the upper left side of your

screen, hit the "File" tab.

See Figure 26.3.1.1

76
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
3. On the vertical toolbar to the left, hit the
"New" tab.
See Figure 26.3.1.2

4. If you wish to use a template, click on

2.Create one the "Sample templates" box.
short presentation See Figure 26.3.1.3
in.
5. If you wish to use a theme, click on the
"Themes" box in the "New" tab.

See Figure 26.3.1.4

6. Once your theme is loaded, click on the

"Click to add title" and "Click to add
subtitle" boxes and add the title and
subtitle (if necessary) of your own
presentation.

7. After deciding on a title, click on the

"New Slide" button in the "Slides" tab up
top,
8. Continue adding information and
pictures as you see fit. In PowerPoint,
however, less is often more
9. Once you are finished with your
PowerPoint presentation, go to "File >
Save As" and save your file so that you
can retrieve it later.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● A presentation program is a software package used to display information in the form of a slide
show. It has three major functions: an editor that allows text to be inserted and formatted, a method
for inserting and manipulating graphic images, and a slide-show system to display the content.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is the use of slide show?

2. How to create slide show?
3. Give one short presentation using PowerPoint.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Concepts of Data, Information and Databases

77
Figure 26.3.1.1

Figure 26.3.1.2

78
Figure 26.3.1.3

Figure 26.3.1.4

79
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 27 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Concepts of Data, Information and Databases

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Data 2. Information
3.Database
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Data can be useful for developing particular report. For developing information data can be useful
as a raw material. And these all data and information are stored in the database.
2. .2 અણબપ્રેયણા :
● Data is collected and analyzed to create information suitable for making decisions
while knowledge is derived from extensive amounts of experience dealing with information on a
subject.
૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Data What is Data? Data is a set of value of Ex.:
qualitative and quantitative Static, Number,
variable, restated pieces of data Character,
are individual piece of information. Images

Raw data: unprocessed data

refers to a collection
of numbers, characters and is a
relative term; data processing
commonly occurs by stages, and
the "processed data" from one
stage may be considered the "raw
data" of the next.

Field data refers to raw data that

is collected in an uncontrolled in
situ environment.

Experimental data refers to data

that is generated within the
context of a scientific investigation
by observation and recording.

80
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
2. Information What is The English word was apparently Ex.: Reports,
information? derived from the Latin stem Knowledge
informare. its means "to give form
to the mind"

Databases A database is an organized

collection of data.
What is database? The data is typically organized to
model aspects of reality in a way
that supports processes requiring
information, such as modeling the
availability of rooms in hotels in a
way that supports finding a hotel
with vacancies.
USE A DATABASE IF…
-> The information is a large
amount that would become
unmanageable in spreadsheet
form and is related to a particular
subject.
-> You want to maintain records
for ongoing use.
-> The information is subject to
many changes (change of
address, pricing changes, etc.).
-> You want to generate reports
based on the information.

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● A database is a tool for collecting and organizing information. Databases can store information
about people, products, orders, or anything else.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is Data?
2. Define use of data.
3. What is information?
4. What is database?
5. Why do you need database?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Overview of popular databases, RDBMS, OODB and MYSQL

81
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 28 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Overview of popular databases, RDBMS, OODB and MYSQL.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Database 2. RDBMS
3. OODB 4. MYSQL
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● Databases are used to support internal operations of organizations and to underpin online
interactions with customers and suppliers.
2. .2 અણબપ્રેયણા :
● RDBMS stands for Relational Database Management System.
● Examples of database applications include computerized library systems, flight reservation
systems and computerized parts inventory systems.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Databases What is database? The data is typically organized to
model aspects of reality in a way
that supports processes requiring
information, such as modeling the
availability of rooms in hotels in a
way that supports finding a hotel
What is RDBMS? with vacancies.

RDBMS A relational

database management system

(RDBMS) is a database
management system (DBMS) that
is based on the relational model
as invented by E. F. Codd, of
IBM's San Jose Research
Laboratory. Many popular
databases currently in use are
based on the relational database
model.

RDBMSs are a common choice

for the storage of information in
new databases used for financial
records, manufacturing and
logistical information, personnel
data, and other applications.

82
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
The data in RDBMS is stored in
database objects called tables.
The table is a collection of related
data entries and it consists of
What is an Object- columns and rows.
Oriented
OODB Database? An object database (also
object- oriented database
management system) is a
database management system in
which information is represented
in the form of objects as used in
object- oriented programming.

 Object-Oriented Database
Features:
What is MYSQL? -persistence
-support of transactions
-simple querying of bulk data
-concurrent access
-resilience
-security

MYSQL MySQL is a relational database

management system (RDBMS),
and ships with no GUI tools to
administer MySQL databases or
manage data contained within the
databases.
The official MySQL Workbench is
a free integrated environment
developed by MySQL AB, that
enables users to graphically
administer MySQL databases and
visually design database
structures.

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● MySQL is offered under two different editions: the open source MySQL Community Server and the
proprietary Enterprise Server
● Object databases are different from relational databases which are table-oriented. Object-relational
databases are a hybrid of both approaches.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is database?
2. Why do you need database?
3. What is RDBMS?
4. What is an Object-Oriented Database?
5. What is MYSQL?
6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Rules for designing good tables. Integrity rules and constraints in a table.

83
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 29 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Rules for designing good tables. Integrity rules and constraints in a table.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Table 2. Integrity rules
3. constraints
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● When you use a database, you store your data in tables — subject-based lists that contain data
arranged in records.

2. .2 અણબપ્રેયણા :
● Tables are commonly used in collecting and organizing raw data during an experiment and also for
representing final data to be included in a paper or report.
૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Tables TABLES – data stored in a
database are divided on
informational units (subjects they
refer to), each represented by a
separate table.
Then the information can be
retrieved in a fast and correct
way.
Data in tables is divided in
elementary units standing for
fields.
Well-designed tables have the
following features:
-values in
Use table level properties to
a key
increase efficiency
field
Name fields appropriately are
neither
Don't use spaces in field names duplicated nor
Don't waste data type effort null,
-a Byte field
Use the most appropriate field accepts values
size 0 through 255
Choose indexes carefullyBeware
of AutoNumber limitations

84
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ

Change the starting value of an

AutoNumber field
Use analysis tools
Don't forget table
Give the rules of
integrity. properties Be aware of the

2 Integrity rules limits

Data integrity refers to

maintaining and assuring the
accuracy and consistency
of data over its entire life-
cycle, and is a critical aspect to
the design, implementation and
usage of any system which
stores, processes, or retrieves
data.

Data integrity can be roughly

divided into two overlapping
categories:

● Physical integrity
What is constraint? ● Logical integrity

3. constraints
Data integrity refers to each
occurrence of a column having a
correct data value.

Referential integrity indicates that

the relationships between tables
have been properly maintained.

● Cascade update
● Cascade delete

Objects used to maintain both

types of integrity include:
● Constraints
● Rules
● Defaults
● Triggers
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ
● The term data integrity is broad in scope and may have widely different meanings depending on
the specific context – even under the same general umbrella of computing.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is the purpose of your database?
2. Describe Rules for designing good tables.
3. Give one example of table.
4. What is foreign key?
6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to various types of Queries and their uses.

85
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 30 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Introduction to various types of Queries and their uses.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Queries
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● Query languages are computer languages used to make queries in databases and information
systems.
2. .2 અણબપ્રેયણા :
● A query is an inquiry into the database using the SELECT statement. A query is used to extract
data from the database in a readable format according to the user's request.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Queries What is a database A query project is a detailed
query? instruction defining what and how
some data should be retrieved e.g. sum,
and/or processed. count,
After execution of the most average,
queries, the retrieved data is maximum,
stored in so called dynamic result minimum
set

Selecting queries – the most

common – they are employed for
selecting and retrieving data from
tables, when there is any need to
get from the database data
fulfilling some conditions, analyze
or sort some data, group some
records, perform calculations on
such groups

Cross queries – they present data

in a clear form simplifying it
comparison and enable trend
matching (in a form similar to MS
Excel worksheet), display
different values from a single
fields.

86
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
Creator queries – the search for
the data duplicates (or matching
records) and data that does not
match their counterparts in
Describe use another table.
of
queries. Functional queries – they
Uses perform operations changing the
database state,

Example:

• deleting a group of record from

one or more tables,

• updating a group of record in

one or more tables,

• inserting a group of records

from one or more tables at the
end of another table or tables,

• creating a table basing on data

from all or selected data in one or
more tables, useful when creating
tables meant for export to another
MS Access database, data
access pages, creating copies or
backups of tables.

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● A database query can be either a select query or an action query. A select query is simply a data
retrieval query. An action query can ask for additional operations on the data, such as insertion,
updating or deletion.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What a database query is?

2. Describe use of queries.
3. How to use the SELECT statement?
4. Adding conditions to queries using the WHERE clause.
5. Selecting data from another user's table

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Designing Access Reports and Forms.

87
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન

વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1

રેડ : Computer Operator and Programming Assistant તલ઴મ : રે
થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ
:60
તભતનટ
રેળન નંફય : 31 સ.ુ ઇ.નું નાભ :

રેળનનું નાભ : Designing Access Reports and Forms.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Reports 2. Forms
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● The basic forms and reports the access creates automatically make a good starting point for
your database projects.
2. .2 અણબપ્રેયણા :
● Reports are used in a database to present information in a neat and organized format that is
ready for printing.
● The Form design tools in Access are very flexible and allow you to customize a form with many
features to make it easy to use.
૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Reports What is the use of Creating a report with a
Reports in wizard
MSACCESS? 1. On the Ribbon, click
Create Report Wizard. You
can choose columnar or Note Microsoft Access
tabular on the pop-up uses this table or
window. query as the default
2. Click the Table or Query record source for the
that contains the data you report. However, you
want to base your report on. can change the record
source in the wizard
Click Next and follow the and select fields from
instructions on the screen other tables/ queries.
What is the use of step by step.
form in access? Note: If you want to
3. Choose layout and style create a form that uses
2. Form for the new report. data from more than
4. Enter the name for the one table, base your
new report and click Finish. form on a query that
includes the tables you
Creating a form with a
wizard
1. Choose CreateMore

88
 FormsForm Wizard on the
Ribbon, you will see Fig. 1.
2.Click on the name of the
Table or Query that
includes

અ.ન.ં શેત઒ુ પ્રશ્ન૊ સ્઩૊ટ શીન્ટ

the data you want to base want to include
your form on (in the left
column)

3. Then choose the Layout

that you want your forms to
follow. You can experiment
with

Columnar, Tabular,
Datasheet and Justified to
find the most suitable layout
for you.

4. Next, choose the Style

that you would like for your
Form.
5. Give a title to your Form.
You can now either go and
open your form or modify
the design in
Design view.
6. Click on Finish.
Creating a form without a
wizard
1. Click the name of the
table or query that includes
the data you want to base
your form on. If the form
doesn‘t contain data (for
example, if you want to
create a form to use as a
switchboard to open other
forms or reports, or if you
want to create a custom
dialog box), don't select
anything from this list.
2. On the Ribbon, click
Create Form Design.
3. With this option you can
TOTALLY customize and
control everything you would
like to have and see in your
forms.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ
● Reports are used in a database to present information in a neat and organized format that is
ready for printing.
● The forms provide an intuitive, graphical environment that is easily navigated by anyone familiar
with standard computer techniques.
● Forms also allow users a method of navigating through the system. Perhaps you may want to
create a form where a user can select from either an input form to load data or a report to run.
5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ
1. What is the use of Reports in MSACCESS?
2. What is the use of form in access?

89
3. How to create form in access with wizard?
4. How to create form in access without wizard.
5. Create a one form with example.
6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ
Networks of Computers, Introduction to LAN, WAN and MAN.

90
91
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમય
લીઔ નંફય : 1 પા઱લેર વભમ 60
તભતનટ
રેળન નંફય : 32 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Networks of Computers, Introduction to LAN, WAN and MAN.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Computer Network

1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Computer is used in any type of commercial or personal use.
2..2 અણબપ્રેયણા :
● It is more useful us to support applications such as access to the World Wide Web, shared use of
application and storage servers, printers, and fax machines, and use of email and instant
messaging applications.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Network What is network? When no. of activities is enter
connected to each other then it Advantages of
is called as network. Comp. n/w

Network means it is not only 1. Share the

inter connected but then share memory
Give the different activities of each other. 2. Works
types of network. become faster
LAN LAN- Local area network
A local area network, or LAN,
consists of a computer network
at a single site, typically an
individual office building.
A LAN is very useful for sharing
resources, such as data storage
and printers.
LANs can be built with relatively
inexpensive hardware, such as
hubs, network adapters and
Ethernet cables.
The smallest LAN may only use two
computers, while larger LANs can
accommodate thousands of
computers.

92
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
WAN What is the WAN-Wide Area Network
different between
LAN and WAN? A wide area network, or WAN,
occupies a very large area, such
as an entire country or the entire
world.
A WAN can contain multiple
smaller networks, such as LANs
or MANs.
The Internet is the best-known
example of a public WAN.

MAN MAN -Metropolitan area

network

A metropolitan area network,

or MAN, consists of a computer
network across an entire city,
college campus or small region.

A MAN is larger than a LAN,

which is typically limited to a
single building or site.

A MAN is larger than a LAN,

which is typically limited to a
single building or site.

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● LAN, this could be connected using point to point cables.

● WAN, this is network of computers worldwide.
● SWAN is one of the core infrastructure components under the National e-Governance Plan of the
Government of India

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is network?
2. Give the different types of network.
3. What is the different between LAN and WAN?
4. What is the different between LAN and MAN?
5. What is the different between WAN and MAN?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Network components, viz. Modem, Hub, Switch, Router, Bridge, Gateway etc and Network Cables,
Wireless networks and Blue Tooth technology.

93
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 33 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Network components, viz. Modem, Hub, Switch, Router, Bridge, Gateway etc and
Network Cables, Wireless networks and Blue Tooth technology.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Network Component
2. Network Cables
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● Computer networks help users on the network to share the resources and in communication.
2..2 અણબપ્રેયણા :
● These hardware components include cable, Hub, Switch, NIC (network interface
card), modem and router. Depending on the type of network you are going to install, some of the
parts can be eliminated.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Network Give the name of Computer network
Component network components include the major
component. parts that are needed to install a
network both at the office and
home level.
Computer network requires the
following devices:
Modem What is modem
and hub? A modem enables you to connect
your computer to the available
internet connection over the
existing telephone line.
A modem is not necessary for
LAN, but required for internet
Hub connection such as dial-up and
DSL.
What is switch and
router? Hub is a device that splits a
Switch network connection into multiple
computers. It is like a distribution
center.

Switch is a telecommunication
device grouped as one of

94
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
computer network components.
Switch is like a Hub but built in
with advanced features. It uses
physical device addresses in
each incoming messages so that
it can deliver the message to the
Router right destination or port.

When we talk about computer

network components, the other
device that used to connect a
LAN with an internet
connection is called Router.
When you have two distinct
networks (LANs) or want to
share a single internet
connection to multiple
Bridge computers, we use a Router.

Bridges are networking devices

that connect networks.
Sometimes it is necessary to
divide networks into subnets to
reduce the amount of traffic on
each larger subnet or for security
reasons.

Once divided, the bridge connects

the two subnets and manages the
traffic flow between them. Today,
network switches have largely
Gateway replaced bridges.
Describe computer
network cable. The term gateway is applied to
any device, system, or software
application that can perform the
function of translating data from
one format to another.

The key feature of a gateway is

that it converts the format of the
Network Cables data, not the data itself.

Networking cables are used to

connect one network device to
other network devices or to
connect two or more computers to
Describe wireless share printer, scanner etc.
network
technology.
Types of cable:
● Coaxial Cables
● Twisted Pair Cables
● Fiber Optics
● USB Cables
Wireless ● Serial and Parallel Cables
networks ● Crossover Cables

A wireless network is any type

of computer network that uses
Blue Tooth wireless data connections for

95
 technology connecting network nodes.

Bluetooth is
a wireless technology standard
for exchanging data over short
distances.

To use Bluetooth wireless

technology, a device must be able
to interpret certain Bluetooth
profiles, which are definitions of
possible applications and specify
general behaviors that Bluetooth-
enabled devices use to
communicate with other Bluetooth
devices.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Whether you want to install a network at your office or home, these are the required computer
network components you need. Though, depends on your situation some of the devices can be
disregarded.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Give the name of network component.

2. What is modem and hub?
3. What is switch and router?
4. What is bridge and gateway?
5. Describe computer network cable.
6. Describe wireless network technology.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Concept of ISO - OSI 7 Layer Model.

96
97
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 તભતનટ
રેળન નંફય : 34 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Concept of ISO - OSI 7 Layer Model.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. ISO - OSI 7 Layer Model
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● The International Organization for Standardization (ISO) is a worldwide federation of national
standards bodies from some 130 countries, one from each country.
2. .2 અણબપ્રેયણા :
● The OSI, or Open System Interconnection, model defines a networking framework to implement
protocols in seven layers.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. ISO - OSI 7 Give the Full Seven layers:
The Open System Interconnection
Layer Model form of ISO. ● Physical
(OSI) model defines a networking
● Data Link
framework to implement protocols in
● Network
seven layers.
● Transport
Use this handy guide to compare the ● Session
different layers of the OSI model and ● Presentati
understand how they interact with on
each other. ● Applicatio
See Figure 34.3.1.1 n

Physical (Layer 1)
Describe the This layer conveys the bit stream -
use of physical electrical impulse, light or radio signal - Fast
layers in ISO - through the network at the electrical Ethernet, RS232,
OSI Model. and mechanical level. and ATM are prot
ocols with
It provides the hardware means of physical layer
sending and receiving data on a components.
carrier, including defining cables, cards
and physical aspects

98
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ

Data Link (Layer 2)

Layer 2 Data Link
At this layer, data packets examples include
are encoded and decoded into bits. It PPP, FDDI, ATM,
furnishes transmission protocol IEEE 802.5/
Describe the knowledge and management and 802.2, IEEE
use of data link handles errors in the physical layer, 802.3/802.2,
layers in ISO - flow control and frame synchronization HDLC and Frame
OSI Model. Relay.
The data link layer is divided into two
sub layers: The Media Access Control
(MAC) layer and the Logical Link
Control (LLC) layer.

Network (Layer 3)

This layer provides switching and Layer 3 Network

routing technologies, creating logical examples include
paths, known as virtual circuits, for AppleTalk DDP,
transmitting data from node to node. IP, IPX.
Routing and forwarding are functions
Describe the
of this layer, as well as addressing,
use of network
internet working, error handling,
layers in ISO -
congestion control and packet
OSI Model.
sequencing.
Transport (Layer 4)
Layer 4
This layer provides transparent
Transport
transfer of data between end systems,
examples include
or hosts, and is responsible for end-
SPX, TCP, UDP.
to-end error recovery and flow control.
Describe the It ensures complete data transfer
use of physical
layers in ISO -
OSI Model. Session (Layer 5)

This layer establishes, manages and Layer 5 Session

terminates connections between examples include
applications. The session layer sets NFS, NetBios
up, coordinates, and terminates names, RPC,
Describe the conversations, exchanges, and SQL
use of physical dialogues between the applications at
layers in ISO - each end. It deals with session and
OSI Model. connection coordination.

Presentation (Layer 6)

This layer provides independence

from differences in data representation
(e.g., encryption) by translating from
Layer 6
application to network format, and vice
Presentation
versa.
examples include
The presentation layer works to
encryption, ASCII,
transform data into the form that the
Describe the EBCDIC, TIFF,
application layer can accept.
use of physical GIF, PICT, JPEG,
layers in ISO - MPEG, MIDI.
OSI Model.
Application (Layer 7)
This layer supports application and

99
 end-user processes. Communication
partners are identified, quality of
service is identified, user Layer 7
authentication and privacy are Application
considered, and any constraints on examples include
data syntax are identified. WWW browsers,
Describe the Everything at this layer is application- NFS, SNMP,
use of physical specific. This layer provides Telnet, HTTP,
layers in ISO - application services for file transfers, FTP
OSI Model. e-mail, and other network software
services.
Telnet and FTP are applications that
exist entirely in the application level.
Tiered application architectures are
part of this layer.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● OSI (Open Systems Interconnection) is reference model for how applications can communicate
over a network. A reference model is a conceptual framework for understanding relationships.
5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. Fullform of ISO.
2. Full form of OSI.
3. Which are the seven layers of ISO - OSI 7 Layer Model?
4. Describe all layers in brief.
6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Overview of various Network protocols, Logical and Physical Addresses, Classes of Networks.

Figure 34.3.1.1

100
101
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 35 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Overview of various Network protocols, Logical and Physical Addresses, Classes of
Networks.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Network protocols
2. Logical and Physical Addresses
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● Computer is used in any type of commercial or personal use.

2. .2 અણબપ્રેયણા :
● Network Protocol is a set of rules that governs the communications between computers on a
network.
● All networks in practical use have different sizes.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Network What is a Rules of Network Protocol include
protocols Network guidelines that regulate the following
Protocol? characteristics of a network: access
method, allowed physical topologies,
types of cabling, and speed of data
transfer.

Types of Network Protocols

The most common network protocols
are:

● Ethernet
● Local Talk
● Token Ring
● FDDI
● ATM

The followings are some commonly

used network symbols to draw different
kinds of network protocols.

102
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ

What are logical

and physical
address Figure 35.3.1.2
spaces?

Logical In computing, a logical address is the

addresses address at which an item (memory cell,
storage element, and network host)
What are appears to reside from the perspective
physical of an executing application program.
address
spaces? In computing, a
physical address (also real address,
Physical or binary address), is a memory
Addresses address that is represented in the form
of a binary number on the address bus
circuitry in order to enable the data
bus to access a particular storage cell
of main memory, or a register of
Classes memory mapped I/O device.

of Networks
All networks in practical use have
different sizes.
This is the main reason that engineers
decided that IP address space should
be divided in different classes in order
to meet different requirements.
The following classes were created;
each class fixes a boundary between
the network prefix and the host within
the 32-bit address:

See Figure 35.3.1.2

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● The OSI model is a good place to start to learn more about the differences between physical and
logical addressing.
● All networks in practical use have different sizes.
● For example, a company that will have 50 computers, will not need a network of 5000 computers,
And on the contrary, a company that needs 5000 computers does not need a network that can only
hold 50 computers.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

103
1. What is a Network Protocol?
2. What are logical and physical address spaces?
3. What are the differences between physical and logical addressing?
4. What is IP (Internet Protocol)?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Network Security, firewall and DHCP Server concepts.

Figure 35.3.1.2

104
105
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 36 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Network Security, firewall and DHCP Server concepts.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Network Security
2. Firewall and DHCP Server
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.
1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● Network security starts with authenticating, commonly with a username and a password.
2..2 અણબપ્રેયણા :
● Network security covers a variety of computer networks, both public and private, that are used in
everyday jobs conducting transactions and communications among businesses, government
agencies and individuals.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Network What is Network security consists of the ->The most
Security network provisions and policies adopted common and
security? by a network administrator to simple way of
prevent and monitor unauthorized protecting
access, misuse, modification, or a
denial of a computer network network
and network-accessible resource is by
resources. assigning it a
unique name
Network security involves the and
authorization of access to data in a
a network, which is controlled by corresponding
the network administrator. password.

Users choose or are assigned an

What is Firewall? ID and password or other
authenticating information that
allows them access to information
and programs within their
authority.

2. Firewall A firewall is a software program

or piece of hardware that helps
screen out hackers, viruses, and
worms that try to reach your e.g., the
computer over the Internet. Internet

106
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
How firewall Works A firewall is a
is? network security system that
controls the incoming and
outgoing network traffic based on
an applied rule set.
A firewall establishes a barrier
between a trusted, secure internal
network and another network that
is assumed not to be secure and
Give the full form of trusted.
IP.
DHCP Server The Dynamic Host
Configuration Protocol (DHCP)
is a standardized network
protocol used on
Internet Protocol (IP) networks
Give the full form of for dynamically distributing
DHCP. network configuration parameters,
such as IP addresses for
interfaces and services.

DHCP is very common in all

modern networks ranging in size
from home networks
to
large campus networks
and regional Internet service
provider networks.

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● Communication between two hosts using a network may be encrypted to maintain privacy.
● Networks can be private, such as within a company, and others which might be open to public
access. Network security is involved in organizations, enterprises, and other types of institutions.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What Is Network Security?

2. What is Firewall?
3. How firewall Works is?
4. Give the full form of IP.
5. Give the full form of DHCP.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Internet Concept.

તૈમાય ઔયાલનાય – થંઔ ટં ઔ ઔભીટી , અભદાલાદ તલબાખ

107
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 37 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Internet Concept.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Internet

1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● The series of interconnected network allowing communication of data surrounded by millions of
computers worldwide.
2. .2 અણબપ્રેયણા :
● A global communication network that allows computers worldwide to connect and exchange
information.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Internet What is internet? A worldwide system of computer
network, a network of networks in
which users at any one computer
can get information from any
other computer.

The web is a software application

or services that run on the
internet. It is a collection of
documents and resources. It is
one of the fastest growing parts of
the internet. It provides easy
access to a huge range of
What is Web site? information that is stored on
computers around the world.

What is Web site?

Web site contains one to millions
of inter connected pages, has
hyperlinks to connect and help to
find your way around the web
site. You can find different kinds
of information on the web- like
games, health matters, holiday
destination, train timetables,
weather forecast and many more.

108
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
Give the features of
internet. Features of Internet
● Geographic Sharing
● Architecture
● Universal Access

Benefits of Internet
● The internet is data and
information loaded,
including a range of
medium.
● The Search engines that
are available online are,
fast and powerful.
● The internet is easy to
use.
● We can become
researchers because of
easier access to data.
● People are motivated to
share their work online
with the world.
● The internet appeals to
different learning styles.
● Unlike paper the web can
present dynamic data
sources which change
over time.
● The characters in an e-
Mail don't get transposed
or mixed up when they
are sent over long
distances.
● We can access libraries
around the world.
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● The word ―Internet‖ exactly means ―network of networks‖. The Internet consists of thousands of
smaller regional networks spread throughout the world.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is internet?
2. What is Web site?
3. Give the full form of WWW.
4. Give the features of internet.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Concept of sites & pages.

તૈમાય ઔયાલનાય – થંઔ ટં ઔ ઔભીટી , અભદાલાદ તલબાખ

109
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 38 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Concept of sites & pages

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. Web sites
2. Web pages
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● A Web site is a related collection of World Wide Web (WWW) files that includes a beginning file
called a home page.
2. .2 અણબપ્રેયણા :
● Websites have many functions and can be used in various fashions; a website can be a personal
website, a commercial website, a government website or a non-profit organization website.
● A web page, as an information set, can contain numerous types of information, which is able to be
seen, heard or interacted with by the end user.

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Web sites What is websites? A website, also written as web For example
site, or simply site, is a set of
related web pages The Web site
typically served from a single web for IBM has the
Where to domain. home page
use address
websites? A website is hosted on at least of
one web server, accessible via a http://
network such as the Internet or a www.ibm.com
private local area network through
an Internet address known as
a uniform resource locator (URL)

Types of websites. Two types of websites:

● Static websites
● Dynamic websites

A static website is one that has

web pages stored on the server
in the format that is sent to a
client web browser.
A dynamic website is one that
changes or customizes itself
frequently and automatically.

110
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
Web pages What are A web page (or webpage) is
web a web document that is suitable
pages? for the World Wide Web and
the web browser.

A web browser displays a web

page on a monitor or mobile
device. The web page is what
displays, but the term also refers
to a computer file, usually written
in HTML or comparable markup
How to use Web language.
Pages in websites?
A web browser can have
a Graphical User Interface,
like Internet Explorer, Mozilla
Firefox, Chrome and Opera, or
can be text-
based, like Lynx or Links.

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● In the other words sites pages are nothing but customized page are stored in content, while
application pages are generic pages which will be used by all the sites site collection.
● Web pages are what make up the World Wide Web. These documents are written in HTML
(hypertext markup language) and are translated by your Web browser.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is websites?
2. Where we have to use websites?
3. Types of websites.
4. What are web pages?
5. How to use WebPages in websites?

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to HTML and various tags in HTML.

તૈમાય ઔયાલનાય – થંઔ ટં ઔ ઔભીટી , અભદાલાદ તલબાખ

111
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 39 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Introduction to HTML and various tags in HTML

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. HTML
2. Tags in HTML
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :
● A web site is a collection of web pages.

2. .2 અણબપ્રેયણા :
● The Web is fundamentally designed to work for all people, whatever their hardware, software,
language, culture, location, or physical or mental ability. When the Web meets this goal, it is
accessible to people with a diverse range of hearing, movement, sight, and cognitive ability

૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. HTML Full form HTML is a language for describing <html>
of HTML. web pages. <body>

● HTML stands for Hyper Text <h1>My First

Markup Language Heading</h1>
● HTML is a markup language
Define ● A markup language is a set <p>My first
of markup tags paragraph.</p>
HTML TAG. ● The tags describe document
content </body>
● HTML documents </html>
contain HTML tags
and plain text
Define ● HTML documents are also
called web pages
HTML structure.
Using HTML almost anyone with a
text editor and an internet site can
build visually interesting pages that
organize and present information in a
way seldom seen in other online
venues.

112
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
In fact, web sites are said to be
composed of pages because the
information on them looks more like
magazine pages than traditional
computer screens.
Give one Example
of HTML.
Heading Tags
2 Tags in HTML Formatting Tags
Paragraph Tag
Line Break Tag
Centering
Content
Horizontal Lines
Preserve Formatting
Nonbreaking
Spaces

List of tags:
a, abbr, address, area, b, base, big,
blockquote, body, br, button, caption,
cite, code,col,
colgroup,dd,del,dfn,div,dl
DOCTYPE,dt,em,fieldset,form
h1, h2, h3, h4, h5, and h6
head,html,hr,i,img,input,ins
kbd,label,legend,li,link,map,
meta,noscript,object,ol,optgroup
option,p,param,pre,q,samp,script
select,small,span,strong,style
sub,sup,table,tbody,td,textarea
tfoot,th,thead,title,tr,tt,ul,var,Com
4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

⮚ XML and HTML were designed with different goals:

● XML was designed to transport and store data, with focus on what data is
● HTML was designed to display data, with focus on how data looks
● HTML is about displaying information, while XML is about carrying information.
5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What is the difference between HTML and XML?

2. Give the full Form of HTML?
3. Give one Example of HTML.
6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Creating Forms with controls using HTML

તૈમાય ઔયાલનાય – થંઔ ટં ઔ ઔભીટી , અભદાલાદ તલબાખ

113
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 40 સ.ુ ઇ.નું નાભ :
રેળનનુંનાભ : Creating Forms with controls using HTML

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેતુ઒ / રેળનના અંતે તારીભાથી :
1. Forms
2. controls
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱લેર વભમ : 10 તભતનટ

2..1 વભીક્ષા / યીવ્યુ :
● We refer to elements and objects whose primary purpose is to provide interactivity as controls.
2..2 અણબપ્રેયણા :
● The objective of this technique is to use standard HTML form controls and link elements to provide
keyboard operation and assistive technology interoperability of interactive user interface elements.
૩. તલ઴મ યજુઆત : પા઱લેર વભમ : 25 તભતનટ
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. Form What is a form? An HTML form is a section of a e.g.:
document containing normal <Form>
content, markup, special elements .
called controls (checkboxes, radio Form elements
buttons, menus, etc.), and labels .
on those controls. Users generally </form>
"complete" a form by modifying its
How to Create controls (entering text, selecting
HTML Forms? menu items, etc.), before
controls submitting the form to an agent for
processing (e.g., to a Web server,
to a mail server, etc.)
What is
the Users interact with forms
control? through named
controls.

A control's "control name" is given

by its name attribute. The scope of
the name attribute for a control
within a FORM element is
the FORM element.
Each control has both an initial
value and a current value, both of
which are character strings.
The control's "current value" is first
set to the initial value. Thereafter,
the control's current

114
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
value may be modified through
user interaction and scripts.

Adding an HTML control

To add an HTML control, just add

the control's HTML to your page,
like you would for a typical web
page. This example creates
Describe different a button:
types of controls in
details. <button id="button1">An HTML
Button</button>

Control types HTML defines the following control

types:

● Buttons

● Checkboxes

● radio buttons

● menus

● text input

● file select

● hidden controls

● object controls

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● An HTML form is a section of document that contains interactive controls that enable a user to
submit information to a web server.
● In many application programming models, you need a control to display or interact with content.
Because most HTML elements are capable of displaying content and responding to a variety of
events, the distinction between a control and an element isn't always clear for Windows Runtime
apps using JavaScript.
5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ
1. What is a form?
2. How to Create HTML Forms?
3. Create a Form Using HTML Tables.
4. What is the control?
5. Which types of controls is use in HTML?
6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

Introduction to open source CMS viz,. Joomla, Wordpress etc. and Web authoring tools viz.
Kompozer, FrontPage etc.

તૈમાય ઔયાલનાય – થંઔ ટં ઔ ઔભીટી , અભદાલાદ તલબાખ

115
 ઓધ૊ણખઔ તારીભ વંસ્થા .......................... F: TRG : 06
રેળન ્રાન
વીરેફવનુ લ઴ૅ : 2017 વેભેસ્ટય નંફય : 1
રેડ : Computer Operator and Programming Assistant તલ઴મ : રેડ થીમયી
લીઔ નંફય : 1 પા઱લેર વભમ :60 ત ભત નટ
રેળન નંફય : 41 સ.ુ ઇ.નું નાભ :
રેળનનું નાભ : Introduction to open source CMS viz,. Joomla, Wordpress etc. and Web authoring
tools viz. Kompozer, FrontPage etc.

1. ઩લૂ ય તૈમાયી :
1..1 રેળનના શેત઒ુ / રેળનના અંતે તારીભાથી :
1. CMS
2. Web authoring tools
1..2 વાધન૊ : Chalk, Duster, Black Board, Pointer.

1..3 વંદબય વક્રશત્મ : Computer Operator & Programming Assistant - NIMI

2. પ્રસ્તાલના / ઩લૂ ાયનુવંધાન : પા઱

લેર વભમ : 10 તભતનટ
2..1 વભીક્ષા / યીવ્યુ :

● Most Content Management Systems comes with ready-to-use templates, which are pre-tested and
can be directly applied on any site.

2. .2 અણબપ્રેયણા :

● A content management system (CMS) is a computer application that allows publishing,

editing and modifying content, organizing, deleting as well as maintenance from a central
interface.

૩. તલ઴મ યજુઆ ત : પા઱લેર વભમ : 25 તભતનટ

અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ
1. CMS What does CMS CMS - Content Management
stand for? System
Content Management System is a
Computer Program/Software that
allows publishing and maintaining
contents on the World Wide Web
(WWW).

They make the task of creating a

Website or a blog, as simple as it
could be.

Most Content Management

Systems comes with ready-to-use
templates, which are pre-tested
and can be directly applied on any
site.

116
અ.ન.ં શેત઒ુ પ્રશ્ન૊ ચાલીરુ઩ ભાક્રશતી સ્઩૊ટ શીન્ટ

The most common and widely

used Content Management
Systems are:

Wordpress
Joomla
Drupal
ExpressionEngine
What is web
authoring DotNetNuke
tool? Mambo

"Authoring tools"
2. Web authoring
covers any software is used to write
tools
the web, from enterprise content
management systems (CMSs)
through to micro blogging mobile
apps, whether web-based, non-web-
based or a combination.

Examples:
● First Page
● FrontPage
● HTML-Kit
● Komodo Edit
● First Page
● Advanced Image Editor

4. વાયાંળ / ઩ુનયાલતયન : પા઱લેર વભમ : 10 તભતનટ

● The function and use of content management systems is to store and organize files, and
provide version-controlled access to their data. CMS features vary widely.
● Any software, or collection of software components, that authors can use to create or modify web
content for use by other people, is an Authoring Tool.

5. અભરીઔયણ અને સ્લાધ્મામ : પા઱લેર વભમ : 10 તભતનટ

1. What does CMS stand for?

2. Describe CMS with example.
3. What is web authoring tool?
4. Describe web authoring tools with example.

6. શલે ઩છીન૊ ઩ાઠ : પા઱લેર વભમ : 05 તભતનટ

તૈમાય ઔયાલનાય – થંઔ ટં ઔ ઔભીટી , અભદાલાદ તલબાખ

117