What are the examples for operating systems?
Microsoft Windows
Linux
Ubuntu
Mac OS
What are the common features of an Operating System?
Memory management
File handling
Security management
Disk space management
Task management
What are the different types of file attributes?
System
Read only
Hidden
Archive
How to manage files in an Operating System?
By grouping them inside the folders.
What is the different between file and folder?
File is a single document, Folder can hold collection of files/documents.
What is the meaning of open-source software?
Open-source softwares are freely available to use and it's source (source code) is
freely available for users.
What is the meaning of closed-source software?
Closed-sourced software which has an owner, without a permission it does not
available freely.
What is the meaning of file compression?
Reduce the file size by using a file compression software.
What are the examples for file compression softwares?
WinZip
WinRAR
7zip
What is the meaning of system restore?
System Restore is a feature in Microsoft Windows that allows the user to revert
their computer's state to that of a previous point in time, which can be used to
recover from system malfunctions or other problems.
What is the meaning of computer virus?
It is a specific computer program which makes harmful activities or malfunctioning
in a computer.
What is anti-virus software/virus guard?
It is a software which created to protect computer from harmful programs.
What are the examples for ant-virus softwares?
Avast
Kaspersky
Avira
AVG
BitDefender
Norton
How to recognize virus infection in a computer?
Slow down computer.
Unexpected computer restarting.
Malfunctioning softwares.
Unexpected hard disk filling.
CPU over heating.
System crashes.
How to avoid from computer viruses?
Use proper anti-virus software and make sure to update it.
Avoid from unsure pen drive or software installing.
Avoid from clicking spam emails or spam links.
Make sure to install legitimate softwares rather than installing pirate or cracked
softwares.
Make sure to backup your important data.
Posted by ICTT Level 4 at 8:11 AM No comments:
Email This
BlogThis!
Share to X
Share to Facebook
Share to Pinterest
Labels: modules
M02 - Perform word processing
What is word processing?
Creating documents or letters by using a word processing software.
What is the meaning of word processor?
Word processor is a software which allows to create, edit, print documents.
What are the commonly use word processing softwares?
Microsoft Word
OpenOffice Writer
Google Docs
LibreOffice Writer
What are the features of word processing software?
Creating, editing, saving and printing documents.
Copying, pasting, moving and deleting text within a document.
Formatting text, such as font type, bolding, underlining or italicizing.
Creating and editing tables.
Inserting elements from other software, such as illustrations or photographs.
What is the best way to create 100 letters with different names and addresses in an
efficiently?
Creating a mail merge document and making copies from it.
What is the way of placing an image or a clip art behind the text without making
interrupt?
Placing the image as watermark image.
What are the different types of letter cases in MS Word?
Lower case
Upper case
Sentence case
Toggle case
What are the different types of page orientations modes in MS Word?
Portrait
Landscape
How to style a document title in MS Word?
By creating it as WordArt.
How to create dummy text in word document?
By typing '=Rand()'.
Posted by ICTT Level 4 at 8:10 AM No comments:
Email This
BlogThis!
Share to X
Share to Facebook
Share to Pinterest
Labels: modules
M03 - Prepare spread sheet
What is Microsoft Excel?
Microsoft Excel is said to be a spreadsheet application or an electronic worksheet
that is helpful for storing, analyzing data, manipulating data, and organizing
reports.
Provide the different types of data formats available in Excel?
Accounting, Date, Percentage, Number, and Text are the different data formats
available in Excel.
Define Format Painter?
If you want to copy the format of a cell, text, image etc and apply on another
text, the Format painter is used.
Define cells in Excel?
The place where we store the data is called a cell.
List out the charts available in MS Excel?
Pie, Bar, Scatter, Line are some of the available charts in MS Excel, which is
useful to provide graphical representation of a report/analysis.
What is the function used to get the total of columns and rows in Excel?
To get the total of columns and rows in Excel, use the function ‘SUM’.
What is the use of ‘IF’ function in Excel?
To verify whether the conditions are true or false, the function ‘IF’ is used in
Excel.
Give the advantage of Look Up function in Excel?
To return a value for array, you can use the function Look Up
Provide the shortcut for find and replace?
Ctrl+F is the shortcut key to open the find tab and Ctrl+H is the shortcut to open
find and replace tab.
To perform auto-sum on the rows and columns, what is the shortcut?
‘ALT=’ is the shortcut to perform auto-sum on the rows and columns.
Posted by ICTT Level 4 at 8:10 AM No comments:
Email This
BlogThis!
Share to X
Share to Facebook
Share to Pinterest
Labels: modules
M04 - Prepare presentations
Which power point view works best for adding slide transition?
Slide sorter view
Which option can be used to set custom timings for slides in a presentation?
Rehearsal
What PowerPoint feature will you use to apply motion effects to different objects
of a slide?
Animation Scheme
What is the difference between Slide Design and Auto Content Wizard?
Slide Design does not provide sample content but Auto Content Wizard provides
sample content too.
In which menu can you find features like Slide Design, Slide Layout etc.?
Format Menu
Which menu provides you options like Animation Scheme, custom Animation, Slide
Transition?
Slide Show Menu
What is the short cut key to insert a new slide in current presentation?
Ctrl+M
What is the best way to create another copy of a slide?
From Insert Menu choose Duplicate Slide.
What happens if you edited an image inserted in PowerPoint?
The original file that was inserted is not changed.
In Microsoft PowerPoint, what are the two kinds of sound effects files that can be
added to the presentation?
.wave file
.mid file
What is a motion path?
A method of moving items on a slide.
What is a slide-title master pair?
A slide master and title master for a specific design template.
What is the view that displays the slides on a presentation as miniature
representations of the slides?
Slide sorter view
What is the PowerPoint view that displays only text?
Outline view
What is the shortcut key can be used to view slide show?
F5
Posted by ICTT Level 4 at 8:09 AM No comments:
Email This
BlogThis!
Share to X
Share to Facebook
Share to Pinterest
Labels: modules
M05 - Maintain databases
What is a database?
A database is an organized collection of data, generally stored and accessed
electronically from a computer system.
What is DBMS (Database Management System)?
A database management system (DBMS) is software for creating and managing
databases.
What is primary key?
Primary key is a unique identifier of a table.
What is foreign key?
Foreign key is a primary key of another table which helps to make relationships
between tables.
What is an entity?
An entity is something that exists separately from other things and has a clear
identity.
What is an attribute?
An attribute is a characteristic of an entity.
What are the three basic relationship types use in DBMS?
one-to-one
one-to-many
many-to-many
What is ERD (Entity Relationship Diagram)?
Diagram for use in database design.
What is SQL stands for?
Structured Query Language
What are the examples for DBMS?
Microsoft Access
Microsoft SQL Server
MySQL
Oracle
Posted by ICTT Level 4 at 8:09 AM No comments:
Email This
BlogThis!
Share to X
Share to Facebook
Share to Pinterest
Labels: modules
M06 - Perform internet and electronic mail operations
What is HTML stands for?
Hyper Text Markup Language.
What is static web page?
A static Web page is a page that is built using HTML.
What is dynamic web page?
A dynamic web page is a web page that displays different content each time it's
viewed.
What are languages use to create dynamic web pages?
JavaScript
DHTML
VBScript
What is W3C stands for?
World Wide Web Consortium.
How the W3C relate with the WWW (World Wide Web)?
The World Wide Web Consortium is the main international standards organization for
the World Wide Web.
What is CSS stands for?
Cascading Style Sheets.
What is hyperlink?
A link from a hypertext document to another location.
What is the rendering tool/software of HTML?
Web browser/ Web Client
What is a cookie in website?
A small text file created by a website that is stored in the user's data.
What is a website?
A website is a collection of publicly accessible, interlinked Web pages.
What is an attachment?
An attachment, or email attachment, is a file sent with an email message.
What are the Cc and Bcc in email?
Cc - Carbon Copy
Bcc - Blind Carbon Copy
How the Cc and Bcc differentiate?
The difference between Cc and Bcc is that carbon copy (CC) recipients are visible
to all other recipients whereas those who are BCCed are not visible to anyone.
What is search engine?
A web search engine is a web application that is designed to search for information
on the World Wide Web.
Posted by ICTT Level 4 at 8:08 AM No comments:
Email This
BlogThis!
Share to X
Share to Facebook
Share to Pinterest
Labels: modules
M07 - Install and configure operating system
What are the components of a computer system?
Hardware
Software
Liveware
Firmware
What are the components of CPU?
ALU (Arithmetic logic unit)
CU (Control unit)
Registers
What is FSB (Front Side Bus)?
The Front Side Bus connects the CPU to main memory.
What is BSB (Back Side Bus)?
It connects the CPU to a Level 2 cache.
What are the three types of cashe memories?
Level 1
Level 2
Level 3
What is primary memory in computer?
RAM (Main Memory)
ROM
What is a volatile memory?
RAM (Random Access Memory)
What is a non-volatile memory?
ROM (Read Only Memory)
What is the different between volatile and non-volatile?
Volatile Memory is a type of memory in which data contained in the memory is lost
whenever the power is turned off. Non-volatile memory as once the user turns off
your computer then content remains intact and will not get lost.
What is secondary memory in computer?
Hard disk
Optical drives (CD/DVD-ROM)
Flash drives (Pen drive)
What is the port which supports multiple devices?
USB port
What is hot-swappable?
Hot-swappable means that you can plug in or remove a device without first shutting
down your computer.
What is plug and play?
Computer will recognize it as soon as it is installed.
What are the four classifications of computers?
Supercomputer
Mainframe Computer
Minicomputer
Microcomputer
What are the types of operating systems?
Real time OS
Single user-single task OS
Single user-multi task OS
Multi usermulti task OS
What is BIOS (Basic Input/Output System)?
The built-in program which controls the primary functions of a computer.