Download Computer nvq practice and more Schemes and Mind Maps Computer science in PDF only on Docsity!
VOCATIONAL TRAINING AUTHORITY
ICT Practical Book
CONTENTS
Windows
Word Processing
Spread Sheet
Presentation
Maintain Database
Photoshop
HTML
VB. Net
Corel Draw & Illustrator
Dear Trainees,
The Voca onal Training Authority of Sri Lanka has been conduc ng voca onal training courses
and providing N.V.Q cer ficates to school leavers and the others who are unable to follow
higher educa on.
Therefore I appreciate you for the selec on of Informa on Technology as your subject I am
proud of launching Prac cal Book for the purpose of developing in this field and making
yourself efficiently. So that I cordially request you to, maintain this book in good condi on, and
because of your off spring should use it in future.
“Skill for livelihood – Employ ability for skills”
(K. Niranjan)
Assistant Director
Voca onal Training Authority of Sri Lanka
Jaffna
Dear Trainees,
It is a great pleasure, to hand over this ICT practical book which has been designed by our ICT Instructors and sponsored by KOICA (Korea International Cooperation Agency) for the purpose of covering the whole syllabus and acquiring practical experiences to archive NVQ Certificate.
Furthermore my humble request is that this book has to be used by you without any alteration or damage to the pages as it is going to be used by the future trainees.
I also wish to extent my gratitude to the KOICA which sponsored for this book and ICT Instructors of VTA (Jaffna District) who worked hard with dedication and enthusiasm to design this book and the publishers who gave their fullest cooperation in numerous ways.
Let's Do Good, And Do It Today! Making A Better World Together! Yours Forever
(IM HYEONG JIN)
Volunteers - KOICA
K. Niranjan
District Voca onal Training Center
12/1, KKS Road,
Jaffna.
Seohan hwaseong apt. 106/1401, Beommul 2-dong, Suseong-gu, Daegu, Republic of Korea.
- Create the following folder Structure in your Name Folder
- Create a text file as My Information on Windows folder using Note pad including the following details Name :<< Your Name>> Center Name :<< Your Center Name>> Index No :<< Your Index No>>
- Apply read only attribute to My Information text file
- Search Calc.exe and copy it into Utility folder and rename it as My Calc
- Create a shortcut Winword.exe on Word folder.
- Create the following folder Structure
- Search the text files in your computer which are modified within the past month and copy it of them to OUTPUT folder
- Create the text file in LIVE-WARE folder as PERSONAL.txt including following <> <> << NIC No:………..>>
- Copy the PERSONAL file to STORAGE folder and rename the PERSONAL file as MY PERSONAL
Software
System Application Utility
Window
Linux
Mac
Word
Excel
Power point
Question No- 04 Windows
COM-SYS
SOFTWAR
E
HARDWAR LIVE_WARE
E
INPUT
OUTPUT
STORAGE
- Create the following Folder Structure.
- Create the shortcut for MS Paint & MS PowerPoint in the others folder
- Create text file and save file in the COMPUTER COMPONENTS folder including the following contents
“There are five primary computer components. There are Input devices, Output devices, CPU, Memory and Storage devices”.
- Apply read only attribute to above text file.
- Create the following BMP file with given colors in a Private folder and save it as Picture.bmp
- Create limited user account and rename it as “ICT”
- Show hidden files & folder on your computer
- Create screen saver to appear the word “ICT” with see-saw effect
- Apply Auto hide Property to Taskbar
Green
Blue Yellow
COMPUTER COMPONENTS
OUTPUT INPUT CPU MEMORY STORAGE
Question No- 09 Windows
- Create the following Folder Structure.
- Create a shortcut to “Ms Word” in the “WORD” folder
- Change the currency setting into Rs.
- Clean unused files of your PC using run Command.
- Change the number of display recent program of start menu into 05
- Create a folder “ICT” on drive C:
- Create the INFORMATION, DATA, and PROCESS sub folders on ICT folder. Create ACCURACY and TIMELINES subfolders inside the INFORMATION, and then create another subfolder inside the PROCESS folder as REALTIME.
- Search the Intro_Logo.JPG and copy it to your INDEX and PROCESS folders.
- Create a text document in REALTIME subfolder to include following and save it as Volunteer.txt. The text should you type in it as, “As a Volunteer we have to much more to be perfect”.
- Copy that Volunteer.txt file to DATA folder and rename it as ITVolunteer.txt
- Delete the Volunteer.txt file.(This should be in the recycle Bin)
- Create a bitmap image with Ms Paint as follows and save it as Jerry.bmp in ICT folder.
- Set the Jerry.bmp as the desktop background.
NCICT
OS LANGUAGE Ms OFFICE
WINDOWS
NETWORK
VB
C++
C#
WORD
EXCEL
POWERPOINT
ACCESS
Yellow
Green
Question No- 11 Windows
1111111 Windows
- Create the following folder structure on the D: drive.
- Open font folder and copy file from folder to part time sub folder.
- Search notepad.exe file and copy the file into IC3 folder.
- Create the subfolder with your name into NCICT folder.
- Change the screen server (3D Text) as “Your Index No”.
- Create a text file name Vision.txt and save file into folder ICT COURSES including the following text. “To be the leader of providing Technical, Vocational Education and Training to the Nation.”
- Apply the read only attribute to “Vision.txt file”
- Create the following folder structure in drive D:
- Create the shortcut for the calculator into the SECONDARY folder
- Create the text file as NCICT.TXT in Vocational folder using Notepad and type Course Name (Information and Communication Technology Technician), Center Name and National Identity card Number.
- Search ‘txt’ files which modified last week in the Document folder,
- Copy above searched files into the primary folder.
ICT COURSES
Full Time Part Time
NCICT NDICT
Security
IC
CCNA
IT Essential
Graphics
EDUCATION
PRIMARY SECONDARY TERTIARY
VOCATIONAL
Question No- 14 Windows
1. Create the following Folder structure in D drive [10 Marks]
2. Move Year folder in to the NCICT folder and Rename it as Year2. [05 Marks]
3. Create the following Drawing (Using Paint) and Save it in Course folder as Course with any File
extinction. [10 Marks]
4. Create the following document using Notepad and Save it in Course directory as Notepad.txt
“The operating system is a collection of system software used to manage the overall operations
of the computer. It provides the user a number of facilities to use the computer hardware
efficiently.” [10 Marks]
5. Rename Notepad.txt file with new Name test.txt and copy it in to NDICT Folder. [10 Marks]
6. Delete month folder. [05 Marks]
1. Create the following Folder structure in D drive
[15 Marks]
2. Install the Printer Driver “ HP laser jet 2200 series ” and it as the default printer.[ 10 Marks]
3. Place a Notepad short cut on the Desktop. [05 Marks]
4. Create your own “.BMP” file and apply it as a wall paper. [10 Marks]
COURSE
NCICT NDICT
MONTH YEAR
Yellow
Red Green^
Blue
WINDOWS
SYSTEM FONT TEMP
TTF ATM
1. Create the following Folder structure in D drive [10 Marks]
2. Change the currency type to Rs. And date format DD/MM/YY [05 Marks]
3. Place a shortcut to paint program on the desktop [05 Marks]
4. Open the Windows registry and show it to your examiner [05 Marks]
5. Find all .LNK files and copy them to “DTET” folder [05 Marks]
6. Rename the folder “NDICT” to “HNDICT” [05 Marks]
7. Install the any one printer driver. [10 Marks]
8. Set attribute hidden to vta folder. [05 Marks]
D:\
NCICT
NDICT
VTA
NAITA
NYSC
DTET
VTA
NAITA
Create the following Folder structure in D drive
1. Find .MP3 files in C Drive and 5 files copy them to “MP3” folder
2. Find .mpg (video) files in C Drive and 1 file copy them to “Video” folder
3. Find .BMP files in C Drive and 5files copy them to “photo” folder
4. Set Hidden Attribute to video folder
5. Open add/remove program from control panel
6. Remove adobe Photoshop Program.
7. Open font folder from control panel
8. Delete the bamini font.
9. Empty the recycle bin.
10. Install Bamii font from CD
11. Scan for virus to D Drive
12. Set Date Format YYYY-MMM-DD
13. Set the taskbar Auto hide
14. Create a Zip Folder in Photo folder
15. Turn off auto hide the task bar
16. Create a text file as “PCINFO.TXT” on Desktop and type the following information
“Regarding the PC you are working now.
(a) Computer Name (b) Workgroup Name (C) Screen refresh rate (D) DPI rate
(e) Recycle bin space reserved in C Drive.”
D:\
MP3 Video Photo
Create the following folder structure on the desktop.
1. Create a text fie as Exam.txt on Vehicle folder and including following.
i. Your Name
ii. Index Number
iii. Your Training Center Name
2. Apply Hidden attribute to VAN folder.
3. Create a shortcut for Command Prompt in Vehicle folder
4. Move Bicycle folder to 4Wheels Folder and rename as Bus
5. Delete 2 Wheels Folder.
6. Change the folder Icon to 3Wheels folder.
7. Change the desktop Background
8. Compress for Car Folder
9. Set Screen saver as 3D Text
Vehicle
4 Wheels 3 Wheels 2 Wheels
Car
Lorry
Van
Bicycle
Create the following folder structure on the D: Drive [15 Marks]
1. Create text file with your name and address and save in the “NVQ2” Folder and Name as
NCICT. [05 Marks]
2. Find two JPG file and copy it to other folder. [05 Marks]
3. Change your screen saver as “WELCOME” [05 Marks]
4. Hide your task bar [05 Marks]
5. Create any BMP File and set it on your background [05 Marks]
6. Hide the text file in NVQ 2 Folder [05 Marks]
7. Create shortcut to a Notepad on the desktop and change its Icon. [05 Marks]
D:\
Your Name
NVQ NON NVQ
ICT NCICT
DTP
CERTIFICATE
OTHER
NVQ 4
NVQ 3
NVQ 2
Creating a Spring Scene
Part 1: Draw a spring seasonal picture that makes use of all the MS Paint tools listed below.
Rectangle/Square or Rounded Rectangle/Square tool (filled or hollow) Ellipse/Circle tool (filled or hollow) Straight Line tool Curved Line tool Airbrush tool Paintbrush tool Pencil tool Polygon tool (filled or hollow) Stretch option (stretch an object in your picture) Skew option (skew an object in your picture) Flip option (vertically flip a copy of your name)
See an example of a Fall Scene drawing below.
Save your picture as Spring Scene in your Paint folder.
ICT MS WORD
International School
Result Schedule
Final Year Examination
Full Name of the Candidate
The medium in which the candidate appeared for each subject is mentioned in
the respective column. N/A denotes that medium is not applicable.
Particulars of Symbols
A ......................... Distinction Pass
B .......................... Very Good Pass
C.................................... Credit Pass
S .............................. Ordinary Pass
W ............................................. Weak
+ .............................................Absent
Date of Issue: ................... ……………………..
Director of Studies
Subject Medium Grade
<> <>
ICT MS WORD
he “Sarana” foundation is a registered Nongovernmental
Organization registered under the government of Sri Lanka,
which commenced activities in the south coast. The main
activities which are carried out by the Sarana foundation
are:
- Infrastructure a.1 Roads & Bridges b.1 Schools c.1 Environment d.1 Public places e.1 Other
- Water and Sanitation a.2 Solids waste b.2 Wells c.2 Drainage & sewage
NEEDS ASSESSMENT NEEDS FULL FILMENT
Sub
sector
Activities Direct
Beneficiaries
Estimated
cost
Contact
person
Name
Date
started
Constraints Date
Completed
M F T
- Create the given document in A4 size paper
- Add the page border
- Insert suitable word art & auto shape
- Insert two column & type the contents
- Insert drop cap option to “T” Character of the word “The”
- Create the table & add contents.
- Add outline number as shown above
T
Village Development
Fund
Infrastructure
Development
Fund
Live hood
Improvement
Fund
The Fund Flow