Page 7 - IT 402 v2.0 class 10
P. 7

Assessment Resources



                                              ecti e and Su  ecti e  ue ions           Sneak Peek
                                           This section contains questions              To Create a New Style in Microsoft Word:
             Solved Exercise  (Objective Type Questions)  to assess the intellectual and   2.  The ‘Styles’ task pane will appear. Select the ‘New Style’ button from the bottom of the task
                                                                                         pane.
                                                                                        1.  Click on the arrow in the bottom-right corner of the ‘Styles’ group.
                         Section A
                                                                                        formatting.
              1.  Which feature of Calc helps to see the changes made in the shared worksheet?
             A.  Multiple choice questions:  ii.  Solver  comprehensive writing skills.   4.  Click on ‘OK’ button.
                           iv. None of these
                                                                                        3.  A dialog box will appear on the screen. Type a name for the style and choose the desired text
                  i.  Record Changes   ii.  File > Changes > Comments
                                                                                       5.  The new style will appear in the 'Styles' group.
                2.  We can add a comment regarding any changes made in shared worksheet by:
                           iv. None of these
                 iii. Subtotal

                   i.  Edit > Changes > Comments
                 iii. View > Changes > Comments
                 3.  Worksheets can be merged from ............................. menu.  ii.  File  Lab  Assignment  ‘n  Activity
                            iv. Tools
                                                                                     Complete the following activities and tick on the circle.
                 i.  Edit
                            ii.  Repetitive
                 4.  Which types of tasks can be easily performed using Macros?
                to go through the worksheet and update their address and phone number, if required. He also would like to
                   iii. View    iv. All of these                                          Create a new style with mentioned formatting options such as font style "Baskerville Old
                 5.    Raj has created a worksheet where he has added all the information of his employees. He wants every employee   Face", font colour "blue", text highlight colour as "red", and font size as "18". Text should be
                 i.  Rare
                                                                                      written in "bold". Save this style as ‘My list’.
                   iii. Decision making   [CBSE Sample Paper, 2022]
                  know the changes done by his employees. Which feature of spreadsheet he should enable to see the changes   Updating Styles from Selections
                             ii.  Link Workbook                                     To update a 'Style':
                             iv. Track Changes
                made by his employees?
                  i.   Macro                         Lab Assignment 'N Activity    Step 2:  Select the text.
                    iii.   Change Worksheet    5. iv                               Step 3:  Select Text style formatting
                      3. i   4. ii
                  1.  ............................. feature is used to track every edited call by highlighting with coloured border.
                                                                                    Step 1:  Press ‘F11’ function key from the keyboard. ‘Styles and Formatting’ window appears on the screen.
                Ans.  1. i   2. i                    This section contains
                  2.  ............................. option helps to display the comment permanently.
                B.  Fill in the blanks.   3. colors   4. comment.  an activity to apply the   2
                    .   he comments of different author appear in different ............................. .
                   4.  Calc automatically adds a ............................. to any record changes.
                 Ans.  1. Record changes    2. Show comment   concepts learnt.
                            Section B
                          (Subjective Type Questions)
                 Ans.    The Record Changes feature is used to track the editing process of any cell by highlighting it with a coloured
                   1.  What do you mean by ‘Record Changes’? List the steps to start recording changes.
                   border. On selecting the edited cell  the details of the changes made by different authors will appear.  he steps to
                 A.  Answer the following questions:                                                       3
                       Now start making the changes in the document. Changes get highlighted by a border around the cells.
                     Open the document to be edited.
                     Click the Edit menu and Select Changes.
                     start Record Changes are:   231
                       Select Record option.   More About Spreadsheet

                                                                                               Advanced Features of Word Processor
                                                                                                          109
                 9.  Mention any two operations that can be performed using Macros in a spreadsheet.   [CBSE Sample Paper 2023]
                 7.  Write the complete procedure to use solver in OO Calc.  [CBSE Sample Paper 2023]  Practical Work  Practical Work
                  .  hat do you mean by  yperlinks in Spreadsheets   ive the two different types of  yperlinks that can be used in
                  .   hat is difference between relative and absolute hyperlink
                                   [CBSE Sample Paper 2023]
                              ii.  Goal Seek
                Spreadsheets.
                              iv.  Subtotal
                                     Cr itical   T h ink ing
                                                                                                            Cr itical   T h ink ing
                                                                                              Name
                    i.  Scenarios
                    11. Anshita is preparing spreadsheet notes for her Term Exam. Help her to write short note on the following:  This  section has  sample    .   onsolidate data of two sheets given below in third sheet of OpenO ce  alc.  S ub j e ct  E nr ich me nt
                                                                                             Amit
                  1.  Enter following data into worksheet and compute strike rate of batsman:
                    iii. Solver
                                                                                                  June Pocket Money
                                                                                            Sumit
                B.  Application based questions:  103.90   ue ions   for   practical        Kamal  1300 1200
                                80
                                                                                            Naina
                                 77
                                                                                                    1000
                                                                                            Suman
                     Runs Scored
                                                        examination.
                                                                                                    1500
                     Balls Faced
                     Now find out the strike rate for following data and give them proper names and comments.  Amit Name  Sheet 1  1400
                     Strike Rate
                     The formula for strike rate is: =(cell1 / cell2) * 100
                  i.  When score is 55 and balls faced are 40.
                   2.    Sunita is making a project in spreadsheets. She wants to rename a spreadsheet as it will help her identify the   Suman  1300 900
                                                                                                 July Pocket Money
                  ii. When score is 78 and balls faced are 80.
                                                                                           Sumit
                                                                                           Naina
                  iii. When score is 95 and balls faced are 77.
                  worksheet data easily.  hich option should she use to solved her problem
                                                                                                   1100
                                                                                           Kamal
                                                                                                  1200
                    1.  A colored border, with ............................., appears around a cell where changes are made in a shared worksheet.
                 Previous Years’ Questions  (b)  a dot in the lower left-hand corner  [2023]  2.  Consider the given table mentioning student's details and perform the following:
                                                                                                  1250
                                                                                                Sheet 2
                              (d)  a cross in the upper right-hand corner
                                                                                           Rollno
                                                                                              Class
                     (a)  a dot in the upper left-hand corner

                     (c)   a cross in the upper left-hand corner
                                                                                                    Phone_no
                                                                                                Sumit
                      2.  ............................. feature adds data arranged in a group of cells in Calc, with labels for columns and/or rows. [2023]  3 1 2  XII X  Amit Name  1234565
                               (b)  Subtotal                                                  X  Anuj  3564583
                  Ans.  (a)    (d)  Solver  [2023]  Pre ious  ears   ue ions         •  isplay all the records of table Student.  XI  Mini  1236589
                                                                                           4
                     (a)  Average
                     (c)   Goal Seek
                      3.  A ............................. refers to a cell or range of cells on a worksheet whose data values can be used in a formula.    • Insert one record of your choice.  5869542
                                                   his  section  has   ue ions      •  isplay record of student whose roll number is  .
                   Ans.  (b)   (b)  cell                                            •  isplay record of students who are in class    .
                                (d)  cell data  [2023]                              •  isplay the record of   nu
                      (c)   cell reference
                        (a)  sheet                with answers that were
                                (b)  Goal Seek
                      4. ............................. feature of Calc is used to test ‘what-if’ questions.     • Save the letter
                   Ans.  (c)    (d)  Styles
                                                  asked in CBSE examinations.       •  xit OpenO ce  riter
                                                                                  3.  Write a letter to your father telling him about your Annual Day using Mail Merge.
                        (a)  Solver
                      (c)   Scenario

                    Ans.  (c)
                       Touchpad Information Technology-X
                    200                                                                              Practical Work  415
                       Model Test Paper  M ax . M arks: 5 0
                M ax . T ime: 2 H ours         Model Te  Pa er                               Projects
                2.   T his  Q ues tion P aper cons is ts  of 21  q uestions in two s ections : Section A &  Section B .
                4.     Out of the giv en ( 5  +  1 6  = )  21  q uestions,  a candidate has to answer ( 5  +  1 0 = )  1 5  q uestions in the allotted ( max imum)  time
                3.   Section A has  Ob jectiv e type q ues tions  whereas  Section B  contains  Sub jectiv e type q ues tions .
                G eneral Instructions:         This section has                                       Hints for Part D
                1.   P leas e read the ins tructions  carefully.
                 5.   All q ues tions  of a particular s ection mus t b e attempted in the correct order.   CBSE based model   PROJECT-1
                 of 2 hours.
                 6 .   SECT ION  A  -  OB J ECT IVE T Y PE Q U EST ION S ( 24 M A R K S) :
                                                                                   Follo  t e gi en instruction to com lete t e  ro ect in   en  ce:
                                                                                    graduation, end of school or Memorial Day party. You can pick any event. Your letter will serve as your form
                  ii.  M ark s  allotted are mentioned agains t each q ues tion/ part.
                    i.   T his  s ection has  05 q ues tions .   te  paper.           Type a letter inviting friends and/or family to a party you are hosting. For example, you can host a birthday,
                    iii. T here is  no negativ e mark ing.
                 7 .   SECT ION  B  –  SU B J ECT IVE T Y PE Q U EST ION S ( 26  M A R K S) :    Format the letter as 'left' aligned (block letter) with '0.5' or '1' margins depending on the length.
                    iv . Do as  per the ins tructions  giv en.                      letter. Save your letter as Mail Merge Letter.

                  ii.  A candidate has  to do 10 q ues tions .
                    i.   T his  s ection has  16 q ues tions .   Projects             Make sure your address is listed at the top of the document. Example of address: Address 1 Address 2 City,
                                                                                     letters.  reate fields such as title  first name  last name  address    address    city  state  and  I .  ou can
                       If y ou don’ t solv e Practice Papers before an ex am,  y ou might be surprised at
                    iii. Do as  per the ins tructions  giv en.
                         how difficult it is to write q uickly  and legibly  during the ex am.
                     iv . M ark s  allotted are mentioned agains t each q ues tion/ part.    reate a data source with the names and addresses of at least five families in which you wish to mail the
                                                                                     State, ZIP
                          SECT ION  A  -  OB J ECT IVE T Y PE Q U EST ION S  ( 1  x  4 =  4 marks)  This is an assessment to   make appropriate field names of your choice but make sure you include the address information.
                    i.    A Student completes  his  work  only when his  parents  remind and driv e him do. T he s tudent is  facing lack  of … .......… … … … … … …  .   1
                  Q 1 .  A nswer any  4 out of the giv en 6  q uestions on Employ ability  Skills    1  challenge the  udents to    Print invitation letter and label for each recipients.
                                b .  Self-Awarenes s
                                                                                       reate a  ro ect on  onsum tion of  air  Products in  e   el i in  alc:
                       a.  Self-Dis cipline    d.  Self-R egulation
                      ii.  … .......… … … … … … …   s tres s  mak es  a pers on worris ome, les s  productiv e and may lead to v arious  dis orders .    PROJECT-2
                      c.  Self-M otiv ation
                                b .  P os itiv e
                                d.  None of thes e  1     apply the concepts learnt.    This sheet can be shared with Dairy Companies who are supplying their dairy products in New Delhi.
                      iii.    Neha is  receiv ing s ev eral mails  from companies  who are adv ertis ing a product or trying to attract her to their web s ites .
                      a.   Negativ e
                        c.   B oth of the ab ov e
                      Such type of mails  are called … .......… … … … … … …  .    b .  B ulk  mails    1
                                 d.  L ab elled mails
                        a.  Adv ertis ing mails    b .  Infect printer   1
                       c.  Spam mails
                       iv .  W hat can a computer v irus  NOT  do?     d.  M ak e the computer s low
                         a.   Infect files
                                 b .  P lanning
                       v .  E ntrepreneurs hip has  a crucial role in the … .......… … … … … … …  of the s ociety.   1
                       c.   Corrupt files
                                 d.  None of thes e  …
                       v i.  An indiv idual who initiates , creates  and manages  a new b us ines s  can b e called  .......… … … … … … …  .
                        a.   E v olution
                         c.   F unctioning    b .  A manager
                                  d.  A profes s ional  427
                         a.   A leader    Model Test Paper                               Consider your 3 friends as representatives of Company A, B and C, respectively. Share the worksheet with
                          c.   An entrepreneur                                          your friends to update the selling data of Dairy Products in New Delhi by their company.

                                                                                           Touchpad Information Technology-X
                                                                                        420
   2   3   4   5   6   7   8   9   10   11   12