Solved question paper

June 2011 (OLD PATTERN)

 NB: Answer all Questions

I. Fill in the blanks                                                                                             (9x1=9)

1. ALU is one of the basic units of a _ _ _ _ _ _.
2. ROM is a _ _ _ _ _ memory.
3. In DOS operating System, _ _ _ _ programs cannot run.
4. _ _ _ _ _ element is the top most element of the word screen
5. _ _ _ _ _ tool in the standard tool bar is used to check the spelling in the active work book.
6. _ _ _ _ _ function is used to return the same date and time
7. A _ _ _ _ _ is the original entry containing a chronological record of the transaction.
8. To avoid duplicate entries of the data we can set _ _ _ _  to that field in the table.
9. _ _ _ _ _  account is also called as terminal account 

Ans: 1. Central Processing Unit, 2. Non-Volatile, 3. Windows, 4. Title, 5. Spell Check, 
6. Now(), 7. Journal, 8. Primary key, 9. SHELL

II. Match  the following (9x1=9)

1. Artificial Intelligence     :      (a)Excel File
2. Plotters                           :      (b)Absolute Reference
3. COM1                            :      (c)Output Device
4. ESC Key                        :      (d) Port name
5. ‘$’                                  :      (e)Search Engine
6. Ctrl +P                           :      (f)Cancel an Entry
7. Property                         :      (g)VLSI 
8. *.xis                               :      (h)Print Option
9. Yahoo                            :       (i) Impersonal Account

Ans: 1-(g), 2-(c), 3-(d), 4-(f), 5-(b), 6-(h), 7-(i), 8-(a), 9-(e)

III. Choose the best answer                                                                                      (9x1=9)

1. _ _ _ _ _  is a device used by Engineers till 1970.

           (a)Slide Rule (b)Abacus (c)ENIAC (d)OCR

       2. Kilobyte is equal to _ _ _ _ _ _

           (a)1000 bytes (b) 1024 (c)1000bits (d) H

      

       3. _ _ _ _ _  Command is used to set the rile as read only

           (a) +H (b) R (d)+R (d)H

        4. Font size is available in _ _ _ _ _ bar.

           (a)Menu (b) std.tool (c) status (d) formatting
 
       5. _ _ _ _ _ key   is used to open a new document file.

           (a) Ctrl+V (b) Ctrl+O (c)Ctrl+N (e)Ctrl+E
 
       6. _ _ _ _ _ Key is used to select an entire row in workbook.

           (a)Ctrl+Spacebar (b) Shift +Space bar (c) Enter (d) End

       7. A company account is an example for _ _ _ _ _ _ account.

           (a) Artificial (b) natural (c)real (d)nominal

       8. A table contains records and record contains _ _ _ _ _ _

           (a) Texts (b) fields (c) memos (d) forms
   
       9. An IP address is used to identify a _ _ _ _ _ in the internet.

           (a)country (b)website (c)computer (d)browser

                                   Ans: 1-a, 2-b, 3-c, 4-d, 5-c, 6-b, 7-a, 8-b, 9-c

IV . True or False                                                                                                     (10X1=10)

1. Main frame computers are used in homes.
2. Plotter is having pens to draw figures
3. Control panel is used to change the settings of hardware only.
4. Ctrl+I  is used to change the text to Italic
5. Delete key deletes on character to left.
6. To move the cell contents, cut and paste method cannot be used.
7. Transactions are classified and posted as ledger.
8. Page Number cannot be inserted in report.
9. .com is a part of domain name used to identify commercial organizations.
10. MODEM is an external device only.

Ans: 1.False, 2.True, 3.False, 4.True, 5.False, 6.False, 7. True, 8. False, 9. True, 10. False

V. Write short  answers for any 12 questions                                                                  (12X3=36)

1. What are the main functions of a control unit?

The control unit (CU) is a component of a computer's central processing unit (CPU) that directs the operation of the processor. It tells the computer's memory, arithmetic/logic unit and input and output devices on how to respond to a program's instructions. It directs the operation of the other units by providing timing and control signals. Most computer resources are managed by the CU. It directs the flow of data between the CPU and the other devices.

2. Write a note on the contributions of Lady Ada Lovelace and John Van Neumann.

            Lady Ada Lovelace introduced many computer concepts and Ada is considered the first computer programmer. She made an influential contribution to the analytical engine. She describes an algorithm for the Analytical Engine to compute Bernoulli numbers. It is considered the first published algorithm ever specifically tailored for implementation on a computer, and ADA( in her name) is a programming language widely used in American Defence Computer.

          John Von Neumann was born on December 28, 1903. He was a Hungarian-American mathematician who made major contributions to a vast range of fields. The eldest of three brothers, von Neumann was born Neumann Janos Lajos. John was a child prodigy who showed an aptitude for languages, memorisation, and mathematics.

3. What are the capacities of floppy disk? Mention its advantages.

Capacities:

1. Minifloppy 5  DSHD =1.2MB

2. Minifloppy 5  DSDD =360KB

3. Microfloppy 3   DSHD =1.44MB

4. Microfloppy 3   DSDD =720KB

Advantages:

1. Floppy disk is portable and inexpensive
2. Data on floppy disk can be accessed randomly
3. Data on a floppy disk can be write – protected from being changed accidently
4. Floppy disk can be used to transfer data from one computer to another.

5. Write notes on OCR.

         OCR (optical character recognition) is the recognition of printed or written text characters by a computer. This involves photo scanning of the text character-by-character, analysis of the scanned-in image, and then translation of the character image into character codes, such as ASCII, commonly used in data processing. Eg: e.g. cheque, passport, invoice, bank statement and receipt.

6. What is meant by Defragmentation?

          Defragmentation is the process of locating the noncontiguous fragments of data into which a computer file may be divided as it is stored on a hard disk, and rearranging the fragments and restoring them into fewer fragments or into the whole file. Defragmentation reduces data access time and allows storage to be used more efficiently. Some operating systems automatically defragments storage periodically; others require that the user occasionally use a special utility for this purpose.

Steps:

Start ->All programs ->Accessories ->System Tools ->Disk Defragmenter

7. How can you set the paper size and orientation for a document?

Set the paper size:

• Page layout (tab) -> Page setup (group) -> click size option.
• A drop down with list of available paper size appears.
• We can select any size from the list or create any custom size.

Set the paper orientation:

• Page layout (tab) -> Page setup (group) -> click orientation option.
• Two options are available (i) Landscape (ii) Portrait

8. What is meant by mirror and gutter margins?

          Mirror margins are typically used to designate a page layout that will eventually be two-sided. You set up mirror margins by using the Page Setup dialog box. 

          Gutter margins: The gutter margins are used to leave extra space for the top margin or side margin in the documents. The gutter margin provides additional margin space to a page layout to compensate for the part of the waste paper while binding.

To set gutter margins for bound documents:

1) Open Microsoft Word document.
2) Click the 'Page Layout' tab. (The 'Page Layout' tab appears.)
3) Click the 'Margins' drop-down list and click 'Custom Margins'. (The 'Page Setup' dialog box appears.)
4) From the 'Gutter' spin box, select the appropriate size.
5) From the 'Gutter position' drop-down list, select the appropriate option.
6) Click ‘OK'.

9. What is the use of hyperlink and auto sum tool?

          A hyperlink is a word, phrase, or image that you can click on to jump to a new document or a new section within the current document.  In ms word click Insert -> Hyperlink to add a hyperlink. 

Auto sum: When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. AutoSum is in two locations: Home > AutoSum, and Formulas > AutoSum.

10. Write the steps to print the work sheet.

          For printing a worksheet, click Print option from the file menu or press ctrl+p, print dialog box opens. In the print dialog box we can select the printer, paper size, number of copies, one sided or 2 sided printing etc. 

11.Write the steps to edit the formula in a cell

• On the worksheet, click the cell in which you want to enter the formula.
• Type the = (equal sign) followed by the constants and operators that you want to use in the calculation.
• We can enter as many constants and operators in a formula as you need, up to 8192 characters.
• Instead of typing the constants into your formula, you can select the cells that contain the values that you want to use and enter the operators in between selecting cells.
• Press Enter.

12. What is a primary key?

• The PRIMARY KEY constraint uniquely identifies each record in a database table.
• Primary keys must contain UNIQUE values, and cannot contain NULL values.
• A table can have only one primary key, which may consist of single or multiple fields.

 13.Write the steps to include current date and time to a form.

• In the Navigation Pane, right-click the form or report and click Layout View on the shortcut menu.
• On the Format tab, in the Controls group, click Date and Time. 
• The Date and Time dialog box appears.
• Clear the Include Date check box if you do not want to include the date.
• If you want to include the date, click the date format that you want to use.
• Clear the Include Time check box if you do not want to include the time.
• If you want to include the time, click the time format that you want to use.
• A sample of the date and time information in the formats you have chosen appears in the Sample area of the dialog box.
• Click OK. 

                                         The date and time information is added to the form or report.

 14. Write Notes on web browser

          A web browser (commonly referred to as a browser) is a software application for retrieving, presenting and traversing information resources on the World Wide Web. Although browsers are primarily intended to use the World Wide Web, they can also be used to access information provided by web servers in private networks or files in file systems.The most popular web browsers are Google Chrome, Microsoft Edge,  Safari,  Opera  and  Firefox.

15. What is forwarding a email?

          Email forwarding generically refers to the operation of re-sending an email message delivered to one email address on to a possibly different email address. The term forwarding has no specific technical meaning. Users and administrators of email systems use the same term when speaking of both server-based and client-based forwarding. Email forwarding can also redirect mail going to one address and send it to one or several other addresses. Vice versa, email items going to several different addresses can converge via forwarding to end up in a single address in-box.

VI.Write answers in brief:

1. (a) Explain the classification of computers based on computer power

There are many classifications of computers based on their processing power (speed) and as of now, there's no standard classification. You can classify them broadly as: 

     1. Micro-computers :

                    With the lowest processing power, these are often found inside everyday consumer electronics like mobile phones (very high end phones pack processors with huge power, though) and ticketing machines. These are least powerful type of computers but are most widely used and growing in the fastest rate. In these computers hardware peripherals can be attached easily. The CPU speed is about 100kips.

     2. Desktop computers :

                    The computers we all as PCs. Processing power varies across different configurations and models. The very high end systems of this range are used for graphics-intensive work. 

     3. Mainframes:

                     A large computer system which is used by a lot of users at the same time, like the central system of a corporate office. These computers have multiple processors and very different architecture from ordinary PCs to serve a number of users at the same time. Processing power is very much greater than PCs. It is a powerful multi-user computer capable of supporting many hundreds or thousands of users simultaneously. The CPU speed of main frame computer is 1mips to 10 mips.

Eg: ISP providers use mainframe computers to process information about millions of internet users. 

      4. Supercomputers:

                    The fastest computers available at a particular period of time are generally the supercomputers. They are similar to mainframes but generally are reserved for single complex calculations (like DNA analysis) which require a HUGE amount of processing power. The architecture of supercomputers vary according to the purpose they are built for. It is an extremely fast computer that can perform hundreds of millions of instructions per second. The CPU speed of super computer is 100Mips. The CPU speed of computer is 100Mips. It is specifically used for complex applications by big organization.

Eg: NASA and ISRO uses super computers to track and control space discovery.

                                                                                (OR)

(b)What is an operating system? Explain various modes of operating system

Operating system:

          Operating system is a collection of program which controls the activities of the computer. It allows the user to use the computer resources like printer, hard disk etc., effectively. It is stored in the hard disk/ floppy disk. It is loaded in to the computer memory when the power is switch on. Without operating system no one can do any work in the computer.

Eg: DOS, UNIX, WINDOWS 7

In any modern operating system, the CPU is actually spending time in two very distinct modes:

1. Kernel Mode

In Kernel mode, the executing code has complete and unrestricted access to the underlying hardware. It can execute any CPU instruction and reference any memory address. Kernel mode is generally reserved for the lowest-level, most trusted functions of the operating system. Crashes in kernel mode are catastrophic; they will halt the entire PC.

      2. User Mode

In User mode, the executing code has no ability to directly access hardware or reference memory. Code running in user mode must delegate to system APIs to access hardware or memory. Due to the protection afforded by this sort of isolation, crashes in user mode are always recoverable. Most of the code running on your computer will execute in user mode.

2.(a) Explain any 5  functions in MS-Excel with example.

 1. SUM (Starting cell address: Ending cell address)

• Returns the sum of some continuous cell values
• Example: =SUM( C10:C20)

 2. AVERAGE (starting cell address: ending cell address)

• Returns the average of some continuous cell values
• Example: =Average( C10:C20)

3. EXP (Number)

• Returns raised to the power of number. The constant e equals to 2.718281, the base of the natural algorithm.
• Number- It is the exponent applied to the base e
• Example: =EXP(3)

4. INT (Number)

• Rounds a number down to the nearest number.
• Number- It is the exponent applied to the base e
• Example: =INT (6.2)

5. FACT(Number)

• Rounds the factorial of a number.
• Number – It is a non negative number you want the factorial of. If the number is not an integer it is then truncated.
• Example: =FACT(5)

(OR)

(b)Explain spelling and grammar tool in detail

Open the spelling and grammar checker:

• In most Office programs, click the Review tab, and then click Spelling in the Proofing group.
• A dialog box or task pane appears with the first misspelled word found by the spelling checker.

Fix each error by doing one of the following:

• To use one of the suggested words, select the word and click Change.
• To change the word yourself, edit the word directly in the document or in the Not in Dictionary box.
• To add the word to the default dictionary so that Office stops flagging it as misspelled, click Add or Add to Dictionary.
• To ignore the word and move to the next flagged word, click Ignore or Ignore Once.
• To ignore all instances of the flagged word and move on to the next one, click Ignore All.

When you see a spelling or grammatical error, right-click or press and hold the word or phrase and choose one of the options to fix the error.

  3(a). Write the steps:

(i). To create a report using report wizard

1. On the Create tab in the Reports group, click Report Wizard. The wizard starts.
2. From the Tables/Queries drop-down list, select the table (or query) to base the report on. The fields for the selected table load in the Available Fields list box.
3. Move the fields to include on the report from the Available Fields list box to the Selected Fields list box. To do so, double-click a field name to move it or highlight the field name and click >. To move all fields at once, click >>. 
4. Click Next >. 
5. To group records on the report by a particular field, highlight the field in the list box and click >. 
6. Add more grouping levels if desired. You can use the arrows to change the order of the grouping levels if needed.
7. When you finish defining how you want records grouped, click Next >. 
8. In the first drop-down list, select the field to sort records by. By default, records will be sorted in ascending order by the field you select. If you want to sort in descending order, click the Ascending button to change its label to "Descending". 
9. You can specify up to four levels of sorting. When you finish specifying sorting options, click Next >. 
10. In the Layout field, select the format of the report. Your options are "Stepped", "Block", and "Outline". (Try the options to see a preview of the report layouts.).
11. In the Orientation field, select whether to lay out the report in portrait or landscape mode.
12. If you want all fields to fit on a single page, ensure the Adjust the field width so all fields fit on a page check box is marked.
13. Click Next >. 
14. Enter a title for the report.
15. Select an option for the view you want to open the report in. Your options are:
• Preview the report (opens in Print Preview mode).
• Modify the report's design (opens in Design view).

1. Click Finish. The report loads in the view you selected. 

1. Once the wizard has done its job, future changes to the Sorting and Grouping are made in the Group, Sort, and Total area: Design > Group & Sort. You may change the order of, remove, or edit any existing items. You may also add a group and a sort as well.

(ii). To modify a report

Modify your report in Layout view

• Change column or field width
• Change row or field height
• Add a field
• Delete a field or column
• Change page setup
• Change the formatting of a field
• Bind a text box to a different field (change the control source of a control)
• Change the record source of the report
• Wrap text in a field
• Add gridlines
• Add or modify a logo or other image
• Add or edit a report title
• Add page numbers, the current date, or the current time

Change column or field width

• Drag the right or left edge of the border until the column is the width you want.

Change row or field height

• Drag the top or bottom edge of the border until the row is the height you want.

Add a field

• On the Format tab, in the Controls group, click Add Existing Fields. The list of available fields is displayed. If there are fields available in other tables, these will be displayed under Fields available in other tables:.
• Drag a field from the Field List onto the report. As you move the field, a highlighted area will indicate where the field will be placed when you release the mouse button.

Delete a field or column

• Click the field or column to be deleted, or click its label or column heading.
• Access draws a border around the item to indicate that it is selected.
• Press DELETE.

Change page setup

          Use the Page Layout group on the Page Setup tab to change size, orientation, margins, and so on.

1. Click the Page Setup tab.
2. In the Page Layout group, click Size  to select a different paper size.
3. Click Portrait  or Landscape  to change the paper orientation.
4. Click Margins  to make adjustments to the report's margins.

Change the formatting of a field

1. Select the field that you want to format.
2. On the Format tab, use the tools in the Font group to apply the formatting you want.

Wrap text in a field

1. If the property sheet is not displayed, right-click the field in which you want the text to wrap, and click Properties. Otherwise, just click the field to select it.
2. On the Format tab of the property sheet, set the CanGrow property toYes.

Add gridlines

1. Click any field in a control layout.

A border is drawn around the field to indicate that it is selected.

1. On the Format tab, in the Gridlines group, click Gridlines.
2. Select the style of gridlines you want.

Add a title to a report

• On the Format tab, in the Controls group, click Title. 

A new label is added to the report header, and the report name is entered for you as the report title.

• When the label is created, the text in the label is selected for you so that if you want to change the text, you can just begin typing the title you want.
• Press ENTER when you have finished.

Add page numbers

• On the Format tab, in the Controls group, click Page Numbers. 

The Page Numbers dialog box is displayed.

• Choose the format, position, and alignment you want for the page numbers.
• Clear the Show Number of First Page check box if you do not want a number on the first page.
• Click OK.

       The page numbers are added to the report. Switch to Print Preview to see how the numbers will look when you print the report.

Add the date or time

• On the Format tab, in the Controls group, click Date and Time. 

The Date and Time dialog box is displayed.

• Clear the Include Date check box if you do not want to include the date.
• If you want to include the date, click the date format you want.
• Clear the Include Time check box if you do not want to include the time.
• If you want to include the time, click the time format you want.

A sample of the date and time, in the formats you have chosen, appears in the Sample area of the dialog box.

• Click OK.

(OR)

(b) Write notes on the usage of internet.

1. Checking emails

          It is reported that the first thing that 90 % of Internet users do when they connected to the net is to check if they have received any emails. Internet has drastically changed the mail pattern and has made it incredibly fast.

2. Download

          It is hard to find an Internet user, who has not used it to download music and movies. Apart from it, there are lots of other things that can be downloaded using internet as well.

3. Search For Relevant Information

          If you are not sure about something, then one of the easiest way to know more about it is by searching it on internet. Internet has got a huge database of information on almost every subject and one can easily find out lots of information on any topic using internet.

4. Book Tickets

          Online booking has made things really easy. Be it a movie ticket or flight ticket, you can book just about anything using Internet. The process is very easy, convenient and super fast.

5. Shop Online

          The use of internet is not limited merely to booking tickets. With help of net, you can do a full-fledged online shopping. On popular e-stores like Ebay, Amazon etc., one can find almost anything that he needs to buy. These e-stores are reliable and you can find quality products at most competitive rates on them; and all this can be done without even stepping out of your home. 

6. Make Friends

          One of the best things about internet is that is has made communication very easy and convenient. World is a small place now and one can get connected to just about any part of the world without any problem. There are many sites and forums on net, where you can find likeminded people and make friends with them. All this is possible only due to internet.

7. Socialize

               Social networks have got really big since last decade. Facebook and Twitter are the new online hangouts of net-izens and who likes to share all the latest happening of their life on these social networks and keep their profile duly updated. Now it is possible to be in touch with all of your friends and relatives, however big they may count in numbers and all this is possible due to social networks, which acts as a very convenient and effective platform for online socialization.

8. E-Banking

               Banking was never so easy and convenient before! Right from opening an account to operating it, E-Banking has really been a big boon for everyone. Not only can one view his account activities but he can also execute online transactions from the comfort of the home.

9. Data Sharing

             Data sharing was never so easy and quick before! It doesn’t matter, if you have to send a file or song, a picture or a ebook,; with help of internet, you can send just about anything at anywhere and that too, in no time.

10. Online Freelancer

            Internet has also created great opportunities for people who are interested in working online as freelancers. Be it writing or web designing, e-commerce or entrepreneurship, now it is possible for everyone to show off his talent online and make a living out of it. Millions of freelancers make their living online and this number is increasing substantially every year.

---------------------------------