Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
Operating knowledge of computer and other peripherals
Time: 1 Equipment :computer system
Job No.: 1
Ex 1 Start computer. Ex 2 Start the computer in safe mode. Ex 3 Restart the computer. Row Material :
Ex 4 Stand by the computer. Ex 5 Turn off the computer. Ex 6 Identify the basic parts of the computer connect them with PC.
What is monitor?
What is cabinet?
Skill :
1 2 3
identification use Computer system connection
No. A B C D
Marking System
identification use system connection question
Marks
25 25 25 25
E Total F.I. S.I.
100
Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
Time: Equipment :computer system
Job No.:
What is mouse?
What is keyboard?
Row Material :
What is scanner?
What is printer? Skill :
No.
F.I. S.I.
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job: Process
on file and folders
Time: Equipment :
Job No.: 2
Ex 1 Do the following operation on windows. Open Move Minimize Maximize Close Ex 2 Do the various operation on file and folder New Copy Cut Paste Delete Rename Properties Ex 3 study various menu option in menu bar
Row Material :
Skill :
1 2 3
Windows explorer File and folder Menu bar
Ex 4 Do the following operations
No. A B C D
Marking System
Windows explorer File and folder menubar Question
Marks
15 35 25 25
E Total F.I. S.I.
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job: change display, date-time, mouse from control panel
Time: 2 Equipment :
Job No.: 3
Ex 1 Do as directed in display change the theme set the desktop background set the screen resolution 1366 by 768 pixels set the screen saver Row Material :
Ex 2 Do as directed in mouse setting change the mouse speed. switch primary and secondary switch.
Ex 3 Do as directed in date time setting reset the current date and time. Skill :
1 2 3
Display setting Mouse setting Date and time
No. A B C D
Marking System
Display setting Mouse setting Date and time Question
Marks
25 25 25 25
E Total F.I. S.I.
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
MS paint- draw temple, house in MS paint and decorate it.
Time: 0 Equipment :
Job No.: 4
Row Material :
Skill :
1 2 3
drawing Color combination Vision and creativity
Draw the temple and home as per your vision. No. A B C D
Marking System
drawing Color combination Vision and creativity question
Marks
25 25 25 25
E Total S.I.
F.I.
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
BIOS-Viewing the BIOS and changing the Boot order.
Time: Equipment :computer system
Job No.: 5
Q - 1 Open boot menu (F12) Q – 2 2 Open Setup or BIOS (del) Q – 3 3 Change the boot order set hard disk for first boot device , cd - dvd second boot device ,USB CD-DVD third boot device , USB Hard Disk fourth boot device , USB SanDisk fifth boot device.
Row Material :
Skill :
1 2 3
Boot menu Bios Boot order
No. A B C
Marking System
Boot menu Bios Boot order
Marks
25 25 50
D E Total F.I. S.I.
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
Installation of OS and software
Time: Equipment :computer system
Job No.: 6
Ex 1 Install Winrar using setup file or CD. Row Material :
Ex 2 Remove Winrar using program manager. Ex 3 Format C drive drive and Install Windows7 OS
Skill :
1 2 3
Installation software Uninstall software Format install operating system
4
No.
Marking System
Marks
A
Installation software Uninstall software Format install Operating System
25
B C D
25 25 25
E Total F.I. S.I.
100
Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
DOS Internal Commands
Time: Equipment :
Job No.: 7
Computer system
Ex 1 Create following directory structure using command Sem1.txt COPA
Sem2.txt
Row Material :
ITI MD
Sem1.txt Sem2.txt Skill :
Ex 2 Create file named Attendance.txt in Sem1, Sem2 of COPA and MD students and insert their attendance data in it .
1 2 3
Command Syntax Use
Ex 3 Display the system date in following format mm/dd/yy HH:MM:SS Ex 4 Copy content of Sem1.txt of COPA in backup.txt file. No.
Ex 5 change the password of your PC.
A B C
Marking System
Command Syntax Use
50 25 25
Total F.I. S.I.
Marks
100
Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
LINUX commands
Time: Equipment :
Job No.: 9
Ex 1 Create following directory structure using command Sem1.txt COPA
Row Material :
Sem2.txt
ITI MD
Sem1.txt Sem2.txt
Ex 2 Create file named Attendance.txt in Sem1, Sem2 of COPA and MD students and insert their attendance data in it .
Skill :
1 2 3
Command Syntax Use
Ex 3 Display the system date in following format mm/dd/yy HH:MM:SS Ex 4 Copy content of Sem1.txt of COPA in backup.txt file.
No. A
Ex 5 change the password of your PC.
B C
Marking System
Command Syntax Question
Marks
50 25 25
D E Total F.I.
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
DOS External Command Practice
Time: Equipment :computer system
Job No.: 8
Use of External Commands 1) Label 2) Find 3) Sort
Row Material :
4) Tree 5) More 6) Attrib 7) Format 8) Backup 9) CHKDSK
Skill :
10) Scandisk
1 2 3
Command Syntax Use
No. A B C
Marking System
Command Syntax Question
Marks
50 25 25
D E Total
100
Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
Basic word processing
Time: Equipment :
Job No.: 10
Prepare the following in Word Document: On the Shoulders of Giants
Three centuries and an ocean away , a woman of land and privilege didn’t know that what she saw in the eyes of her child was the dawn of the capacity to grasp and synthesize the essence of Classical, Renaissance, and Enlightenment thinking---and reinvent the notion of personal liberty for centuries to come.
Row Material :
Few of us may claim to be geniuses, but almost every parent will tell you of the spark of genius they saw the first moment they looked into their new baby’s eyes. Your mother saw it too. And although she may not have realized it, the newborn brain she saw at work shared the same miraculous potential as the infant minds that would one day achieve the greatness described above. * Set the paper A4 size. * Save the document give the name “Shoulders of Giants”. * Save the document as “Backup_SOG”.
Skill :
No. A B C D E F.I.
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
Time: Equipment :
Job No.: 10 Ex 2 Write the following text within your document:
Virtual memory is the part of the Hard Disk which is non Dos portion space. It is used only for the purpose of storing the Data in Buffer Memory. To increase the size: First we have to go to My Computer then Properties and then Click Advance then Performance (Settings) then again Advance then go to Virtual Memory and click Change. Kernel & Shell Concept – Kernel Kernel is the part of Core Operating System (Machine Language to User friendly Language). Whenever the Machine Language is converted to operating Language – Kernel Kernel is doing the job.
Row Material :
Shell is the part of the Kernel. Basically whenever we operate the system, there should be a link between user O.S. and Machine – Machine – Shell Shell is doing the job. I’m student of COPA. OCR ( Optical Mark Reader ) USB ( Universal Serial Bus ) VGA ( Visual Graphics Adapter ) * Give a heading as “VIRTUAL MEMORY” at the beginning of the document. * Select the entire text without heading and give the following following formatting effects: i. Font Face : Arial ii. Font Size : 15 points iii. Font Color : Pink iv. Character Spacing : Expanded by 2 points * Select the heading “VIRTUAL MEMORY” and give the following following formatting effects: i. Font Face : Monotype Corsiva ii. Font Size : 18 points iii. Font Color : Blue iv. Font Style : Bold and Underline * Give Justify alignment to 1 st paragraph and Center alignment to Title. * Find the text “Kernel” and give shadow and Text effect as “Sparkle”. * Select Last 4 Lines and give a Numbering effect. * Save the document b y giving name “Virtual_Memory” * Find the word OCR and Replace it with OMR.
Skill :
No. A B C
Marking System
Writing Text Saving Options Finding & Replacing
Marks
40 30 30
D E 100 F.I.
Industrial Training Institute, Amreli Graded Exercise Name of Job: Creating A Table
Week No.:
Time: Equipment :
Job No.: 12
Prepare the following table in Word Document:
Follow these steps to create a five-column and four-row table: Click on Table, which is located on the menu bar.
Row Material :
Select Insert.
Click Table on the sub-menu
of columns. Type 4 in the Number of columns
of Rows field. Type 5 in the Number of Rows
Click OK.
Sr. No.
1 2 3 4
Skill : I tem
Music system Computer Printer CDs
Quantity Quantity
1 3 2 10
Amount (in Rs.)
17000 52000 8000 200
* Format the Word Art.(Fill, border, shadow effect, 3-D effect, change shape etc.) th *Insert the following row at the 4 position. 2A Monitor 4 10000 * Apply different borders and shading to the table and page also. * Set any border and shading to Title
1 2 3
Format font , color etc Numbering using Bullets Text Effect Table
4 5
No. A B C D
Marking System
Format font font , color color etc Numbering using Bullets Text Effect Table
Marks
20 20 20 40
E 100 S.I.
F.I.
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job: Practice Of Inserting
Time: Equipment :
Job No.: 11
1. insert ClipArt of computer. 2. Open Paint without closing Word and Draw a PEPSI LOGO. Save the file and close Paint. Import the PEPSI LOGO at the end of Word Document. 3. Prepare the following Flow Chart:
Row Material :
Skill :
1 2 3
Inserting clipart Inserting Object Flow chart
4 5
No. A B C
Marking System
Inserting Clipart Inserting Picture Draw Flow Chart
Marks
40 30 30
D E Total S.I.
F.I.
100
Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
Macro, Mail merge, page & Printing setup
Time: Equipment :
Job No.: 12
Type the following letter in Gujarati.
એન.એ.વા ુ ુ.ઇ. કોા આઇ.ટ.આઇ. ઉના તા: પત આચાય ી ી આઇ.ટ.આઇ ઉના.
Row Material :
વષય: તાલમાથઓના નામકમી કરવા બાબત. બી માનનીય સાહ બી , ુ ુ ક ુ ુસં ુ ુ ક કોા છે તથા તાલમાથઓની હાજર સવનય સાથ જણાવવા ક ઉરોત ઉરોત વષય અ સધાને ધ ં ાને જણાવવા જણાવવા કોા ડમાં ડમાં નીચે નીચે જણાવે જણાવે તાલમાથઓ સતત ગેરહાજર રહાજર રહ હાજર Oct-2014 ના તે 50% થી ઓછ છે તો તેમના મના નામકમી કરવા વનંતી તી. Roll no
Batch
Percentage Of Attendance
BAMBHANIYA VAISHALI NATHUBHAI
72-A
44%
10
PANDYA NEHA RAJUBHAI
72-A
45%
15
BAMBHANIYA SANJAY PANCHABHAI
72-A
48%
5
આભાર સહ
Name
Skill :
remarks
ી. આનો વશા ુ ુ,
Give the page border 3-D effect and set border color blue. Give shading effect fill color – color – pink and style 5% and color white in heading Create a heading as “COPA – I.T.I.” – I.T.I.” Create a footer as “Page :
” Keep page number at bottom of every page with center alignment. Set the A4 size of paper and orientation port trait Set left margin 2” and top,bottom and right margin 1”
No.
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
Time: Equipment :
Job No.:
Ex2 make a list of ten friends appling for the job Write Write the following template letter and use mail merge merge
<> <> <> <> <> << pincode>>
Work shop manager, Welspun Industries, Varsamedi gam , Ta-Anjar, Kutch Sub :- Application for post of a Fitter . Dear Sir, I have known from a reliable source that there are some vacancies of experi ence fitters in your company If so I take this chance to apply for one of the vacant posts. Althogh you will know all the details of mine from the the bio-data sheet appended here to, I may tell you, sir , that I am an experi enced, skilled and innovating fitter of the very type you may need for your your expansion programmer. Should you be kind enough to select me, I hope to extend my enriched and bright skills to your esteemed manufacturing unit and help you to achieve more success and wide fame .Awaiting your sympathetic decision Yours Faithfully <>
Row Material :
Skill :
1 2 3 4 5
No.
Marking System
A B C D E Total S.I.
F.I.
Marks
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
Time: Equipment :
Job No.: 12
Ex 3 Create the following envelop for above letter
Row Material :
Skill :
1 2 3
Page Setup Format of letter Mail merge
4 5
No. A B C D
Marking System
Page Setup format envelop Letter merge Typing Speed
Marks
30 15 40 15
E Total S.I.
F.I.
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job: Practice of typing and shortcut shortcut keys
Time: Equipment :
Job No.: 10
Ex 1 Use following short cut keys in word word Ctrl + 0
Adds or removes 6pts of spacing before a paragraph.
Ctrl + A
Select all contents of the page.
Ctrl + B
Bold highlighted selection.
Ctrl + C
Copy selected text.
Ctrl + D
Open the font preferences window.
Ctrl + E
Aligns the line or selected text to the center of the screen.
Ctrl + F
Open find box.
Ctrl + I
Italic highlighted selection.
Ctrl + J
Aligns the selected text or line to justify the screen.
Ctrl + K
Insert link.
Ctrl + L
Aligns the line or selected text to the left of the screen.
Ctrl + M
Indent the paragraph.
Ctrl + P
Open the print window.
Ctrl + R
Aligns the line or selected text to the right of the screen.
Ctrl + S
Save the open document. Just like Shift + F12.
Ctrl + T
Create a hanging indent.
Ctrl + U
Underline the selected text.
Ctrl + V
Paste.
Ctrl + X
Cut selected text.
Ctrl + Y
Redo the last action performed.
Ctrl + Z
Undo last action..
Row Material :
Skill :
1 2 3 4 5
No.
Marking System
Marks
A B C D E Total
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
Time: Equipment :
Job No.:
Ctrl + Shift + > Ctrl + Shift + < Ctrl + End Ctrl + Home F1 F4 F5 F7 F12
Increase selected font +1pts up to 12pt and then increase font +2pts. Decrease selected font -1pts if 12pt or lower; if above 12, decreases font by +2pt. Moves the cursor to the end of the document. Moves the cursor to the beginning of the document. Open Help. Repeat the last action performed (Word 2000+) Open the Find, Replace, and Go To window in Microsoft Word. Spellcheck and grammar check selected text or document. Save As.
Create a Bio Data.
Row Material :
Skill :
1 2 3
SHORT CUT KEYS TYPING SPEED
4 5
No. A B
Marking System
Use of short cut keys Typing speed
Marks
50 50
C D E Total S.I.
F.I.
100
Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
Basic of Excel
Time: Equipment :
Job No.: 13
1) create a new workbook in ms excel 2) create 12 worksheet for 12 months 3) create a table as follows for all months. No
Detail
amount
Date of payment
1 2 3 4 5 6 7 8 9
Row Material :
Skill :
1 2 3 4 5
total No.
4) save the workbook giving name monthly_expenditure.xls 5) format the first column using number category , second using text , third using currency ,fourth using date category 6) create a time table as follows
A B C D E F.I.
S.I.
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Name of Job: Merging & Formatting
Week No.:
Time: Equipment :
Job No.: 13
TIME TABLE INDUSTRIAL TRAINING INSTITUTE, Amreli SHIFT SESSION
TIME
:
NAME OF INSTRUCTOR
: AUG 2014 TO JULY 2015
MONDAY
TUESDAY
WEDNESDAY
THURDAY
TRADE
:
ROOM NO
:
FRIDAY
SATURDA Y
:
Row Material :
REMARK
Skill :
1 2 3
RECESS
Cell worksheet Formatting
4 5
T
IN EXTRA ACTIVITIES PERIOD PREPARE TEACHING AIDS AND OTHER PROGRESSIVE ACTIVITY OF TRAINING M = WORKSHOP CALCULATION AND = THEORY L = LIBRARY SCIENCE
TR = THEORY REVISION P
= PRACTICAL
No. A B
D = ENGINEERING DRAWING
C
ES = EMPLOYBILITY SKILL
D
Marking System
Cell ,merge worksheet formatting Page setup
Marks
25 25 30 20
E
C.I
F.I
Principal S.I.
Total F.I.
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job: Excel functions
Time: Equipment :
Job No.: 14
1
Ms excel
2
Pc
(1) Create a marksheet as s hown below: MARK SHEET NO .
Row Material :
THEORY
PRACTI
ES
1
Babariya Sonalben N.
45
55
52
PERCEN
RESULT
GRADE
152
50.66667
pass
b
2
Chavda Aarti M.
55
65
3
Chavda Ekta R.
65
75
53
173
57.66667
pass
b
82
222
74
pass
a
4
Chavda Punam B.
45
5
Dobariya Ekta V.
85
85
43
173
57.66667
pass
b
55
64
204
68
pass
a
Skill :
6
Dodhiya Nagma I.
85
30
63
178
fail
fail
Fanat Kokilaben R.
35
55
54
144
fail
fail
8
Jethva Vandana S.
30
65
36
131
fail
fail
1 2 3
7 9
Khorasiya Rikita V.
30
65
65
160
fail
fail
Kukadiya Prinsi V.
55
63
57
175
pass
b
10
NAME
TOTAL
58.33333
4 5
No.
1) Use auto fill for NO column
A
2) Use sum function for TOTAL
B
3) Make equation for percentage
C
4) Use expression with if condition for result
D
5) Use expression with if condition for grade
E F.I.
S.I.
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
Time: Equipment :
Job No.: 14
Perform various practices on functions containing following groups. Math
(abs,fact,int,mod,product,sum,sqrt) Row Material :
Statistical
(average,count,min,max)
Logical
(and,or,not)
Date
(now,today,datevalue,day,month,year) Skill :
Text
(concatenate,exact,find,left,right,lower,upper,substitute)
1 2 3
What is Formula What is Faction Syntax
4 5
No. A B C
Marking System
Writing Formula Use of Function Syntax
Marks
40 40 20
D E Total S.I.
F.I.
100
Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
Sorting, filtering, charts, import-export data
Time: Equipment :
Job No.: 15
(1) Create a chart that compares result of student using column , line , bar ,pie , area
1
Ms excel
2
Pc
RESULT NO.
NAME
PERCEN
1
Babariya Sonalben N.
78
2
Chavda Aarti M.
80
3
Chavda Ekta R.
10
4
Chavda Punam B.
5
Dobariya Ekta V.
45
6
Dodhiya Nagma I.
50
7
Fanat Kokilaben R.
30
8
Jethva Vandana S.
88
9 10
Khorasiya Rikita V. Kukadiya Prinsi V.
75 70
Row Material :
100
Skill :
1 2 3 4 5
No. A B C D E
F.I.
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
Sorting, filtering, charts, import-export data
Time: Equipment :
Job No.: 15
120 100 80 60 40 20 0
Series1
Row Material :
Skill :
80
1 2 3
60
4
40
5
120 100
20 0
Series1
No. A B C D E
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
Time: Equipment :
Job No.: 15
120 100 80 60
Row Material :
40 20 0
Series1
Skill :
1 2 3 4 5
No. A B C D E
F.I.
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Name of Job:
Week No.:
Time: Equipment :
Job No.: 15
(2) Create a chart that compares run score of two cricket team and wickets of two teams
RUN BOARDS Over
India
350
Pakistan
300
10
50
49
20
109
102
30
140
160
40
250
210
150
50
308
256
100
250
Row Material :
200
India Pakistan
50 0 10
20
30
40
Skill :
50
1 2 3
350 50
300 250
4
40
200
5
India
150
Pakistan
100
Pakistan
30
India 20
50 0
A B
10 10
20
30
40
No.
50
C 0
10 0
20 0
30 0
40 0
D E
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
Time: Equipment :
Job No.: 15
Ex3 (1)Add a column column city in above above table Using filter, display display such students students those live in Amreli Row Material :
(2) Using filter, display such students whose percentage is greater than 80 (3) Using filter, display display such students whose whose percentage percentage is greater than than 80 and also also live in Amreli (4) Using sorting, give the rank to the students. Skill :
1 2 3
Ex4 (1) Export mark sheet sheet of excel to a text file
4 5
(2) Import data a text file that contains name and marks of student student to excel file No. A B C D E F.I. S.I.
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job:
Simple project using excel and word
Time: Equipment :
Job No.: 15
Ex 1 Create trainee muster using Excel as shown below
1
Ms excel
2
pc
Row Material :
Skill :
1 2 3 4 5
No. A B C D E S.I.
F.I.
Marking System
Marks
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job: Image editing software
Time: Equipment :
Job No.: 16
Ex 1 Take a picture and and Crop the picture
1
Image editing sw
2
pc
Ex 2 Set brightness and Contrast for the picture Ex 3 Rotate the picture and save it with a different name
Row Material :
Ex 4 Compress the picture to reduce it’s size
Skill :
1 2 3
Crop Brightness Rotate Compressing
4 5
No. A B C D
Marking System
Crop Brightness Rotate Compressing
Marks
25 25 25 25
E total S.I.
F.I.
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job: Creating slide show
Time: Equipment :
Job No.: 17
Ex 1 Create a presentation on topic of memory devices
1
Power point
2
pc
Row Material :
Skill :
1 2 3
Formatting Animation Use of pictures Content
4 5
No. A B C D
Marking System
Formatting Animation Use of pictures Content
Marks
25 25 25 25
E total S.I.
F.I.
100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job: Creating tables
Time: Equipment :
Job No.: 18
1) Create a database of name student .Create a table Student_information Student_information 2)
That has following fields No, First Name , Last Name , Middle Name , City , Mobile no.
3) Display the student who live in city Rajkot using select. 4) Dislpay the student whose last name is vaghela vaghela 5) Create a table of marksheet that has following field No , Name , Guj , Eng , Maths , Science ,SS ,Total ,Percent
Row Material :
,Grade ,result.
Skill :
1 2 3
Create database Creating Table Different Views
4 5
No. A B C
Marking System
Create database Creating Table Different Views
Marks
20 40 40
D E 100
Industrial Training Institute, Amreli Graded Exercise Week No.:
Name of Job: Creating
queries & Form
Time: Equipment :
Job No.: 19
QUERY : 1) display only name and percentage from the mark sheet table 2) display students who are failed 3) display the total number of students who passed. 4) Delete the students who are living in gondal
Row Material :
5) Update city of all students Rajkot who are living in baroda 6) Display the name of students who ranked in top ten. 7) Insert data in both tables using insert query.
FORM 1) Create Form Using Design View
Skill :
2) Create From using Data sheet View
1 2 3
Select & Update Query Delete query Insert query
4
Creating Form Using Different Views
3) Create Form using Wizard
5
No.
Marking System
Marks
20
C
Select & Update Query Delete query Insert query
D
Creating Form
40
A B
20 20
E Total S.I.
F.I.
100
