Computer - Cycle Test 1 - ITKT

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.