Foundation of Information Technology - II

Foundation of Information Technology

Summative Assessment - II

Class- IX^th

^{code -165}

^{Time- 3hours                                                                                                                                                                                                     MM-90}

^{Part -A Fill in the blanks -                                                                                                                                                      10*1=10}

       ^{1- A _________ is a 'see through' picture or image more transparent than a than a} 

          ^Background.

       ^{2- The slide master is used to you make changes on ____________.}

       ^{3- ___________ view is an exclusive view of your slides in thumbnail from.}

   ^{4- ____________view is the main editing view of Power Point.}

   ^{5- A layout generally consists of ___________for different types of objects}

          ^{Or text.} 

       ^{6- Microsoft PowerPoint has _______main views.}

   ^{7- The blank space around the edges of the page are called ______ margins.}

   ^{8- _________ option are used in combination to copy text.}

   ^{9- _________ option are used in combination to move text.}

  ^{10- The ________option helps in canceling the previous changes made in document.}

^{Part-B Complete the Sentences -                                                                                                                              10*1=10              1- Formatting commands include fonts, _________}

   ^{2- Alignment is adjusting the text to fit with respect to the ______________.}

   ^{3-The alignment available are: ____________________________.}

   ^{4- Charts are a pictorial or graphical representation of number information on the}

      ^{_______________.}

   ^{5- A file in MS excel is called as a workbook by default named as ____________.}

   ^{6- A workbook is made up of many worksheets by default named as ___________ etc.}

       ^{7- The facility where excel will automatically fill contiguous cells values is called __________.}

       ^{8- The three basic forms of data that excel recognizes are: _____________.}

       ^{9- Performing addition of all numbers in a range without using a formula- _________.}

      ^{10- Breaking up of a single cell in a table into multiple cells is called __________-.}

^{Part-C Short answer type question--                                                                                                                    10*3=30}

      ^{1- How many types of indents. Give the name.}

  ^{2- Write the component name of MS Excel window.}

  ^{3- What is Spreadsheet?}

  ^{4- What is Merge Cells?}

  ^{5- What are Auto shapes?}

  ^{6- What are number formats in MS Excel?}

  ^{7- What are the different Paragraph Alignment possible in MS Word?} 

  ^{8- Explain some font styles available in MS Word.}

  ^{9- What is Presentation Software?} 

 ^{10- Explain the terms Cell, Cell Address, Cell pointer.}

^{Part- D Differentiate between-                                                                                                                                    5*2=10}

      ^{1- Workbook and Worksheet}

      ^{2- Splitting and merging of cells in a table}

      ^{3- Super script and Sub script}

      ^{4- Print layout and reading layout}

      ^{5- Header and Footer}

^{Part- E Name the menu in which the following sub menus found -                                                           5*1=5}

      ^{1- ________--- Picture --Auto shapes}

      ^{2- ________ --- Track changes}

      ^{3- ________--- spelling and grammar}

  ^{4- _________ --- Paragraph -- indents and spacing}

  ^{5- _________--- row - height}

^{Part- F Long Answer Type Question-                                                                                                                           5*3=15}

      ^{1- How many types of document view buttons and scroll bar.}

      ^{2- Cell A1 contains the number 20 and B1 contains 3 what will be the contents of cell C1 if the}

         ^{Formula=A1+B1*2 is entered in cell C1?}

      ^{3- How many types of Chart .Give the names.}

      ^{4- Write the components name of Chart.}

      ^{5- Describe a few features of MS Excel.}

^{Part- G Multiple choice Type Questions (Tick the correct option)                                    10*1=10}

       ^{1- Power point can be started from____________.}

  ^{A) Start menu           B) task bar                   C) recycle bin}

       ^{2- In how many different major views can you see your presentation?}

          ^{A) 1                                B) 3                              C) 6                             D) none of these}

       ^{3- _________ displays the name of the presentation.}

          ^{A) Status bar                  B) menu bar     C) tool bar        D) title bar}

       ^{4- ________ is used to create charts and graphs.}

  ^{A) Chart wizard        B) pivot table     C) pie chart   D) bar chart}

       ^{5- _____ are built in formula that do some specific operations.}

          ^{A) Formula                     B) function                   C) formatting    D) range}

       ^{6- Formulae start with ______ sign.}

          ^{A) equal sign(=)             B) /                               C) +}

       ^{7- A cursor in excel that indicates the current cell is}

      ^{A) Cell pointer                         B) cell reference          C) cell border}

   ^{8- In excel 2007 workbook are given _______ extension.}

      ^{A) .doc                                    B) . xls                                     C) .xlsx                                    D) .exlx} 

   ^{9- IN excel A to Z are used to number ______.}

      ^{A) Cells                                   B) rows                                    C) columns}

  ^{10- You can perform ________ using tables.}

      ^{A) Merging                  B) splitting                    C) insert rows D) All of these}

SAMPLE PAPER IX SA2

Foundation of Information Technology --- topics

1.WHAT is merge cell?
2. write use of mail merge?
3.how many menu in m.s. word?
4. what is superscript?
5.spell check
6.application of word processor
7.component of m.s. word, excel, powerpoint
8.what is indent
9.alignment
10.symbol.
11.change case
12presentation software
13.textwrapping
14.spelling check
15.table
16.m.s. excel basic
17.auto fill feature
18.formatting numbers
19.chart
20.animation


.

SECTION B (MCQ)

SECTION B (MCQ)

30.      

31.      

32.      

33.      

34.      

35.      

36.      

37.      

38.      

39.      

40.     Great Bazaar has employed Yunus Kumar to manage and maintain their networking architecture and wide area connectivity. Which of these best describes his job profile

a)   Networking Engineer

b)   Database Analyst

c)    Web Designer

d)   Programmer

41.     Sumriddhi is logging in to her gmail account and one of her friends is trying to peep in and figure out her password. Which of the following issues is being infringed?

a.   Plagiarism

b.   Privacy

c.    Intellectual Rights

d.   None of the above

42.     The double arrow    at the right end of a toolbar means _____.

a)   You can drag the toolbar from here to make it float

b)   The Help button is hidden to the right

c)    The toolbar is floating.

d)   There are hidden buttons.

43.     In a presentation, Sachin has to change all occurrences of the word ‘Calcutta’ with ‘Kolkata’. Which one of the following options is most appropriate to do the task:

a)   Copy & Paste

b)   Find & Replace

c)    Cut & paste

d)   All of the above

44.     Members of ‘Nibbles & Bytes’, the computer club of a school wants to prepare and print Participation Certificate for all the participants in their annual interschool symposium using a spreadsheet, where the details of the participating students along with the events and schools are entered. Which of the following office techniques is most appropriate to get the desired results:

a)   Copy & Paste

b)   Find & Replace

c)    Mail Merge

d)   Cut & Paste

45.     Rehman is making his Science Project Presentation on ‘Force and Motion’ using a presentation software. He wants to add the phrase ‘Force and Motion Presentation’ at the bottom of each page. Which option should he use:

a)   Footer

b)   Header

c)    Watermark

d)   Bullets

                      

46.     A student wants to create a ‘Digital Story Teller’ on the famous storyline ‘Rabbit & the Tortoise’. He has downloaded some images of Rabbit, Tortoise and forest. He wants to add background music, voice over and animation. Which one of the office tool he should use:

a)       Word Processing Software

b)       Presentation Software

c)        Spreadsheet Software

d)       Database Management System

47.     Spell Check will find errors in which of the following?

a)       It in a beautiful, sunny day.

b)       It is a beautiful sunny.

c)        It isa beautiful, sunny day.

d)       Is a beautiful sunny day.

48.     Ananya wants to create a new slide show with the current slides but presented in a different order. Which feature can she use to achieve the same.

a)       Rehearsal

b)       Custom Slide show

c)        Slide Show Setup

d)       Slide Show View

49.     Vanya has made a presentation on ‘Global Warming’. She wants to progress her slide show automatically while she speaks on the topic in the class. Which of the following features should she use to deliver her presentation:

a)   Custom Animation

b)   Rehearse Timing

c)    Slide Transition

d)   Either (a) or (b)

50.     Computer Teacher of ‘Shanti Education School’ wants to graphically analyze the performance of her students over the last three Computer Tests. Which one of the following office tools she should use to get graphical report in most effective manner with minimum effort:

a)   Word Processing Software

b)   Presentation Software

c)    Spreadsheet Software

d)   Database Management System

51.     Why does the SUM function in B6 show an error?

               (i)        Manual calculation is turned on and the cell has not been re-calculated. 

             (ii)        Someone has keyed the number 0 into B7. 

           (iii)        The function contains a circular reference. 

            (iv)        The function is still being edited so hasn't calculated a result yet. 

52.     In a Spreadsheet, the following reference changes rows and columns automatically when it is copied to a new cell:

              (v)        Relative Reference

            (vi)        Absolute Reference

          (vii)        Mixed Reference

         (viii)        All of the above

53.     Numbers entered into a cell are automatically _____

a)   Left-aligned.

b)   Right-aligned.

c)    Center-aligned.

d)   Justified.

54.     Chhaya writes a really good essay on ‘Global Warming’ for her class. Her teacher encourages her to submit it to a journal for publication and it gets accepted. Who would own the copyright?

a)   Teacher

b)   School

c)    Chhaya

d)   The Publication that printed her essay

55.     Sam Niza, who was born in 1995, is thinking of a password for her online bank account. Which one of the following you would suggest for strengthening the security of her account:

a)   sam95

b)   a99p54c66

c)    samniza1995

d)    sam1995

56.     Which of the following is not a transition effect

a)   Box in

b)   Venetian Blinds

c)    Cover down

d)    Slide sorter

57.     If A1:A5 contain the numbers 16,10,3,25 and 6 then =Average(A1:A5;60) will display

a)   16

b)   25

c)    20

d)   18