Note :- Cycle Test 1 Syllabus - Chapter 1 & 2
Chapter 1
Computer
Software
Que
1 Fill in the blanks.
1)
“C”
language was developed for UNIX.
2)
“C” is the base of programming languages like C#,
C++, Java etc.
3)
Visual Basic became very popular for creating
quick interface to databases.
4)
Java is currently the world’s most popular
programming language.
5)
WordPerfect is a word processing
software.
6)
CorelDraw, GIMP , Adobe Photoshop are the
examples of Graphic Designing software.
7)
Google Docs is one example of an online office suite.
8)
Ubuntu
is an example of open source
Operating System.
9)
Special permanent programs stored in Rom chips
at the time of manufacturing of the device are called Firmware.
10)
A is
used to write a set of instructions to develop applications or programs for a computer to execute.
11)
Applications
such as Google Docs that can be globally accessed on the internet through a high
speed broadband link are called hosted applications.
12)
A
compiler converts a high level language into the machine language
at one go and generates the object code.
13)
GIMP
is an example of Open Source Software application software.
Que
2 Define the following terms.
1)
Software
A set if instruction given to a computer
to perform a task is known as program and a collection of such programs is
called softwre.
Or
Software can be
defined as a group of programs which directs a computer to perform various
tasks.
2)
Application
Software
It is a set of one or more programs used
to accomplish a specific task using computer.
For ex –to create word document we have
MS Word.
Que
3 Answer the Following Qusestions.
Que
1 What is software? Name types of software.
Ans. A set if instruction given to a computer to
perform a task is known as program and a collection of
such programs is called softwre.
There are three
types of software.
1.
Application
Software
2.
System
Software
3.
Utility
Programs
Que
2 What is System Software? Name types of System
software.
Ø It is
responsible for managing and controlling the hardware resources so that other
software and user can use the hardware effectively.
There
are three types of system software :
1.
Operating
System
2.
Language
Processor
3.
Utility
Programs.
Que
3 Explain Operating System(OS) in Brief.
An Operating
System is one of the most important and basic set of software required for the
computer to function.
It provides-
Ø An interface
between the users and the hardware.
Ø Common services
to application software and users.
Ø A platform for
using other software.
Must
for all computers to install and run other programs
Basic
Tasks of an Operating System are:
1)
Recognise
the input from input devices and send the output to the output devices.
2)
Keep
track of files and directories on the disk.
3)
Allocate
memory to various programs.
4)
Ensures
security by specifying user access rights.
We can
communicate with an opratting system through a set of commands.
For ex – In Disk
Operting System (DOS) to copy a file COPY command is used.
Some examples of
OS are – DOS, UNIX, Windows, LINUX, and Mac OS X. Android and iOS are
examples of
mobile OS.
Que 4.What is helping a machine(Computer)
to understand our language and how?
Or
Explain Language Processor in detail.
Ans. A Language Processor is converting high
level language(English like language) into machine level
language (1 and 0) which
is being run on a computer.
There are two types of Language Processors
1)
Compiler
·
Converts
all instructions of high level language program(source code) into the machine
language at one go and generates the corrosponding machine language code(object
code) .
·
If
the source code has an error it cannot be converted into object code.
·
Language
like “C” or “C++” which is first compiled to generate an object code and then
be executed or run.
2) Interpreter
·
An
Interpreter converts one statement of source code at a time and executes this
statement before
Converting next statement.(Line by line)
·
If
there is an error in the statement, the interpreter stops working and displays
an error message
Advantage- The programmer can find and
correct the error immediately during programm development.
Disadvantage – it doesn’t produce and
object code, so source code has to be translated each time it is executed so it
is not efficient.
·
Visual
Basic uses an interpreter.
Que 4 What are Utility Programs?
Ans. Utility Programs are software which is used for day to
day maintainance and efficient
running of
the computer infrastructure.
They can be put
into different categories depending on their function.
·
Antivirus
utilities scan files for computer viruses and remove them.
For ex - Norton Antivirus antivirus
software.
BullGuard Security tool.
·
Backup
utilities are used to make a copy of all
information stored on a disk so that it can be restored in case of a disk
failure.
·
Data
compression utilities are used to compress files into smaller size.
For ex- WinZip and WinRar Compression
Utilities.
·
Disk
cleaners remove unnecessary or duplicate files by freeing up memory space.
For ex – Ccleaner and Disk Cleanup romoving unwanted files from computer.
·
Disk
defragmenters move fragments of files stored at several locations to a single
location to increase efficiency.
For ex – Defrag and PerfectDisk –defragmentation
tool.
Que 5 Give the differences
between General Purpose (packaged)
Software and Tailored(bespoke)
software.
|
General
Purpose Software
|
Tailored
Software
|
|
Aims
to solve common problems such as formatting text, creating charts etc.
|
Applications
developed specially to solve or automate a particular task for an individual organisation.
|
|
Devaloped
to solve general problems.
|
Specially
developed to solve specific problem.
|
|
Adobe
Creative Suite, Open Office suite, CorelDraw etc. are ex of such software.
|
Inventory
management, Human Resource management, Pay roll System are ex. of such
software.
|
|
Easily
available from most computer shops with guides for the user support.
|
Special
team is hired to develop such software.
|
Que
6 What is Firmware?
Ans. It is software that is very closely tied to specific hardware, and unlikely to need frequent updates.
Firmware is the special permanent programs
stored in Rom
Chips at the time of manufacturing of the
device.
Used
to provide the control program for a computer or other devices such as embedded
systems, smart phones etc.
Que 7
What is Hosted Application?
Ans.
Hosted Applications are globally accessed through the internet. Google Docs is one example of an online
office suite, which includes word processing, spreadsheet and presentation
applications, but can be used only whre constant broadband link is available.
Que 8
What is Open Source Software?
Ans. Open Source includes all software whose
source code is available freely, which are developed by volunteers with the
purpose of making it free to use and modify according to the user’s
requirements.
Some
ex of Open Source Software are:
1) Open Office Suite --Word processing,
Spreadsheet and Presentation applications
2) GIMP -- Image editing application
3) MYSQL -- Database system
4) KDE Linux -- Desktop environment
5) Ubuntu -- Operating System
Que 9 Match the
following.
|
a.
The basic software that is required for the
computer to work.
|
i.
Bespoke software
|
|
b.
Software that is used to do a specific task such
as creating catalogues and brochures
|
ii.
Open source software
|
|
c.
Software that is available to download free of
charge.
|
iii.
System software
|
|
d.
Software that is specially developed for company
|
iv.
Application software
|
Ans. (a – iii) (b
– iv) (c – ii) (d – i)
Que
10 State whether the following statements are true or false. Correct the statements
which are false.
i)
Norton Antivirus is an example of Utility
software.
Ans.
True
ii)
Android is an example of gaming software.
Ans.
False. Android is an example of an operating system for mobile devices.
iii)
Application software interacts directly with
the hardware.
Ans.
False. System software interacts directly with the hardware.
Que
11 Anita has written a program in C to print a pattern using special
characters. What will she require to do to execute that program ?
Ans.
She will require a compiler (language processor) which will convert her program
into the machine language program. This program can then be executed to see the
results.
Que
12 Given below is a list of software. Classify the software in its correct
category.
LINUX,
C, MySQL, Java, Inventory Management System, Python, MS Access, DOS, Disk
Defragmenter
|
Operating System
|
LINUX, DOS
|
|
Utility
Program
|
Disk
Defragmenter
|
|
Programming
Language
|
Java,
C, Python
|
|
Database
Application
|
MySQL,
MS Access
|
|
Bespoke
Application
|
Inventory
Management System
|
Chapter 2
Advanced features of MS Excel 2007
Que
1 Fill in the blanks
1)
Functions are pre-defined formulas that can be
used directly to perform different operations.
2)
LEN
function finds the length of a string.
3)
To
arrange data in the ascending or descending order is called sorting.
4)
IF(
) is an example of Logical function.
5)
Data
can be viewed selectively by using Filter
option in Excel.
Que
2 Choose the correct option.
1)
In
MS Excel, you can sort data in
a)
Descending
order c) Ascending order
b)
Both ascending and
Descending order d)
None of the above
2)
The
function used in a spread sheet to find the result of a number raised to a power.
a)
GCD() c)LCM()
b)
POWER() d) ROUND()
3)
If
you type = 15 + 5 in a cell and press the Enter key, MS Excel will display:
a)
20 c)
A to Z
b)
#REF d)
#DIV/0!
4)
The
function used to display the current date
a)
Date() c)
Today()
b)
Time() d)
NOW()
5)
=ROUND(57.8887,
3) will give
a)
57.888 c)
57.889
b)
58.000 d)
57.887
6) The function to
find the length of a text string.
a) UPPER( ) c) LEN( )
b) CONCATENATE( ) d) None of the above
Que
3 Write the output following formulas
1)
CONCATENATE
(“Play”,”ground”) – Playground
2)
UPPER(“player”)
– PLAYER
3)
POWER(3,3)
– 27
4)
PRODUCT(1,6,8)
– 48
Que
4 Answer the following
1)
What
are functions? Explain all functions in brief.
Functions
are pre – defined formulas that can be used directly to perform mathematical
calculations.
There
are four types of functions.
i)
Math
functions
a)
ROUND()
– rounds a number to a specified number of digits.
For
ex - =ROUND(56.666666667,2) returns 56.67
b)
PROCUCT()
– calculates the product of the numbers given inside the brackets.
For
ex - =PRODUCT(2,3) returns 6
c)
POWER()
– finds the result of a number raised to a power.
For
ex - = POWER(4,2) returns 16
d)
LCM()
– Finds the least common multiple of given numbers.
For
ex - = LCM(24,36) returns 72
e)
GCD()
– Finds the greatest common divisor of given numbers.
For
ex - =GCD(24,3) returns 3
ii)
Text
functions
a)
LEN()
– Finds the length of a text string.
For
ex - =LEN(“SCIENCE”) returns 7
b)
UPPER()
– Converts a text string to uppercase.
For
ex - = UPPER(“arjun”) returns ARJUN
c)
LOWER()
– Converts a text string to lowercase.
For
ex - =LOWER(“SHAHID”) returns shahid
d)
CONCATENATE
– Combines two or more text strings to form a single text string.
For
ex – CONCATENATE(“Amir”,” “, “Khan”) returns Amir
Khan
iii)
Date
and Time functions
a)
Date()
– Displays the entered day, month and year in the date format.
For
ex - =LDATE(1980,1,23) returns 1/23/1980
b)
Time()
– Converts the entered hours, minutes and seconds in 24 hour to time value.
For
ex - =TIME(5,30,22) returns 5:30 AM
c)
Today()
– Displays the current date.
For
ex – TODAY () returns the current system date, 8/27/2015
d)
Now()
– displays the current date and time.
For
ex – NOW() returns 8/27/2015 5:30
iv)
Logical
functions
If()
– First evaluates the condition you specify and returns one value if the
condition evaluates to TRUE. It returns another value if the condition evaluates
to FALSE.
Syntax
– IF(logical_test, value_if_true, value_if_false)
2) When can you
use IF() function?
Whenever we find conditional and
logical comparision of multiple data at that time if() function is used.
3) Explain types of
errors with reason.
|
Error
Type
|
When
does it occur?
|
|
#
VALUE!
|
When
a text value is given to a function which accepts numbers.
|
|
#NAME
|
When
a function name or the cell range inside a function is misspelled.
|
|
#DIV/0!
|
When
you divide a number by 0
|
|
#REF!
|
When
a cell reference in a formula is invalid or has been deleted.
|
4) What is
sorting? Which option of Excel is used to sort data?
Which sorting options are
available in Sort & Filter ?
Sorting is a part of data
analysis, which helps us to visualize, understand and organize data quickly and
easily find useful information from the original data.
Sort & Filter option of
Editing group from Home tab option is used to sort data.
MS Excel lets you sort data
in ascending or descending order.
|
What Can I Sort
|
How Can I Sort?
|
|
Text
|
A to Z
Z to A
|
|
Number
|
1 to 10
10 to 1
|
|
Date & Time
|
Oldest to Newest
Newest to Oldest
|
5) What is
filtering of data? Give any one example where you can use filtering.
Filtering is a way to selectively view data that satisfies a given condition.For ex: If we want the list of students who have scored 60% and
above marks in the entire class we can filter that data and can get the list.
6) What is Cell
Border? How to add it?
Boders around cells help you
to improve readablity and draw attention to important section of your
worksheet. By using predefined border styles in Home Tab, we can easily add a
border around a cell or a range of
cells.
7) Name the
error displayed for the following formulas/functions.
i. =AVRAGE(45, 50)
Ans. #NAME?
ii.
=SUM("a",12)
Ans. #VALUE!
iii. =A1/0
Ans. #DIV/0!
8)
Differentiate between the following:
i.
Sorting and Filtering
|
Sorting
|
Filtering
|
|
Sorting
is done to arrange the data in either ascending or descending order. We can
sort text, numbers and date & time values.
|
Filtering
is done to view only that data which satisfies certain conditions. For
example, viewing marks which are more than 60
|
ii.
PRODUCT( ) and POWER( ) functions
|
PRODUCT(
)
|
POWER(
)
|
|
1)
This function is used to find the result by multiplying the numeric values
given inside the brackets.
|
1)
This function is used to find the result of the first number raised to the
power specified by the second number inside the brackets.
|
9)
Explain the use of Conditional Formatting in Excel with an example.
Ans. Conditional formatting is used to display
data in different formats depending on certain conditions. For example, in a
worksheet containing the marks of students, we can highlight all marks which
are less than 40 by displaying them in red colour. This allows us to easily
locate specific data values.
10)
Given below is sample data in Excel. You want to view the data by arranging the
names of computer parts in alphabetical order. Fill in the missing steps for
doing the same.
Ans.
1) Select the cells containing names
of computer parts.
2)
Click the Home tab.
3)
_ Click the Sort & Filter option in the Editing group.
4)
_ Select the option ‘Sort A to Z’. A Sort Warning dialog box appears. A Sort
Warning
dialog box appears.
5)
_ Select the option ‘Expand the selection’ and click Sort button.
