Page 7 - CA 165 ver 1.0 Class 9
P. 7

Assessment Resources



                                                                                           Inserting Comments
                                                                                          Step 1:
                                                                                          Step 2:   Place the cursor at the text and click on Insert
                                                                                           To insert a comment to be associated with a recorded change, follow these steps:
                  Solved Exercise  PART A                                                    Type the notes in the box.    Comment.
                   A.   Very short answer type questions.  Exercise
                                                                                             It will display a yellow rectangular box towards the text for which comment is to be inserted.
                     The option which fits text in a cell within the specified column width.
                     A feature that can help you in generating the series: 7, 14, 21, 28 ...., 70 quickly.
                      Identify the Calc feature.
                      1.   Cell address of the cell formed by the intersection of thirteenth row and fifth column.  This section contains Solved
                     A feature that lets the user create a list of names of his colleagues.
                      2.   In cell F11, what is the formula that computes the total amount? ii.  =SUM(F4:F10)
                                    4. Custom List
                      3.   A feature used to change the direction of text inside a cell. iv.  =SUM(D4:D10)      Exercise for practice & Unsolved
                      What is the formula to find out the item that costs the minimum out of all the items mentioned?
                        2.  4.  i.  =SUM(F4;F10)                                                  3. E13
                      5.   iii.  =COUNT(F4:F10)   2. Autofill   ii.  =MIN(E4:E10)
                      1. Wrap text
                      Ans.   5. Text Orientation  iv.  =MIN(F4:F10)  Exercise for self assessment.
                    3.
                      What is the formula to find out the most costly item in the list?
                        i.  =MIN(D4;D10)
                    B.   Fill in the blanks.  ii.  =MAX(D4;D10)                                                 2
                      Calc is a .................................... software.
                      A .................................... is a combination of multiple worksheets.
                      iii.  =MIN(D4:D10)
                       1.   A .................................... is an intersection of a row and a column. iv.  =MAX(F4;F10)  Lab Assignment ‘n Activity
                       .................................... displays the content of the active cell.
                         4.  2.   i.  =MAX(D4:D10)
                       To view the current status of an active sheet we can refer to the .................................... .
                       .................................... displays the address of the active cell.
                       3.  iii.  =MAX(F4:F10)                                                 ii.  Alpha–Numeric  ª  Create a table with following specifications.   Subject Enrichment
                                                                                        Complete the following activities and tick on the circle.
                       4.  What is the data type for the field ‘Items purchased’?  iv.  Formula  S1  S2
                       There are .................................... columns in a Calc worksheet.
                                      4. Formula bar
                         5.  5.   i.  Numeric   4. =MAX(D4:D10)
                                                                                          Section of
                        6.   iii.  Date/Time                                                       3. =MIN(D4:D10),   XII Science  Name of Compulsory subjects
                                 3. cell
                            2. workbook
                        7.   1. =PRODUCT(D4;E4)  2. =SUM(F4:F10)   7. 1024  Lab Assignment 'N Activity  English  Physics  Optional
                       1. spreadsheet
                       Ans.
                       type of data is being stored, data can be classified into numeric, alpha-numeric or text, date/time and formula.
                       Ans.   5. Name box   6. Status bar   PART B                                Chemistry  Maths
                       5. Numeric
                        What is meant by sorting data? which formulae are applied to perform mathematical operations are called

                     C.   Case Based MCQs                                                                 Hindi
                        To begin working with a Spreadsheet Package, the user has to feed or enter data in a worksheet. Based on which   ª  Add a column after the 4th period of recess.   I.P.  Phy. Ed
                       Ans.    Sorting refers to the process of arranging data in ascending or descending order based on a certain
                     A.  Short answer type questions.  ii.  Operator  This section contains   ª  Add a column before 1st period and type in the cell as ‘ Home Room’ period.
                                                                                       ª  Design the ‘Time Table’ of your class using the concept of tables in ‘Writer’.


                        The numbers or values on
                        .................................... is an expression which helps to perform arithmetical calculation and also executes non-
                          1.  1.   .................................... .  iv.  Expression  an activity to apply the   ª  Save the table and close the document.
                        State the purpose of TODAY() and NOW() functions.
                                                                                       ª  Mention required ‘Pass Marks’ as a comment for each subject.
                         criteria. Operand
                        i.

                        iii.  Function
                         Ans.  TODAY() produces the current date, it contains no argument.  MATHEMATICAL EXPRESSIONS
                                      ii.  Operand
                           2.     NOW() produces the current date and time, it contains no argument.  concepts learnt.
                         In Calc,  which data are aligned (by default) towards the left side of the cell and are generally not meant
                       2.
                         arithmetical tasks.
                                      iv.  Formula
                           Ans.    Gridlines refers to the horizontal and vertical lines in the plot area. The gridlines are inserted in the chart   Step 1:
                         i.  Numeric Data
                            What is meant by Gridlines in a chart?                   inserted in a document. To insert mathematical expressions, follow these steps:
                           3.     iii.  Expression                                     Formula window appears on the screen.
                              to enhance its readability.  ii.  Numeric              106    Select ‘Object’ from the ‘Insert’ menu and choose the option ‘Formula’ from the sub-menu.
                                                                                     In ‘Writer’, mathematical expressions (that form a part of degree or chemical formula) can also be
                         for calculation?

                          3.   What does a #REF! error indicate?  iv.  Formulae
                         Give difference between column chart and a bar chart.
                          4.  Ans.  #REF! occurs when a cell reference is not valid.  Spreadsheet  145  Touchpad Computer Applications-IX
                         i.  Date and Time
                               iii.  Alphanumeric   Bar chart
                            5.       A bar chart represents the data in horizontal
                                     The measurement of values are organized
                          A column chart represents the data over a   columns.
                          Ans.   Column chart
                          period of time in columns.
                          The measurement values are shown vertically
                                     horizontally.
                         Ans.    Charts and graphs are visual or graphical representation of data from a worksheet which is very useful for
                          What is a chart? List any three advantages of a chart.
                          as Y-axis.
                           6.   instant analysis and decision making. Three advantages of charts are:
                           ●  Charts are visually appealing and it is easy for the users to compare the information.
                           ●  Charts summarize large data set in visual form and estimate key value at a glance.
                                       Communication
                              ●  Charts help to forecast the trends on the basis of comparisons done.  Data Analysis  171
                         Viva Voce Questions                                                                   Computational Thinking
                                                                                                   Practical Work

                                                                                                                Art Integration
                                                                                                               Inter-Disciplinary
                   Ans.  A font is a graphical representation of text that may include a different typeface, point size,   Viva Voce Questions  1.  Type the following paragraph in word processor:
                     What is a font?
                    Ans.  The spacing that can be adjusted before and after paragraphs is called paragraph spacing.  questions for practical        sea, which give the country a distinct geographical entity.
                   1.                             This section has oral                    heritage. It has achieved all-round socio-economic progress since Independence. As the 7th largest
                     weight, colour, or design.

                                                                                           India is  one of the oldest civilizations  in the world with a kaleidoscopic variety and rich cultural
                     What is paragraph spacing?

                    2.
                                                                                          country in the world, India stands apart from the rest of Asia, marked off as it is by mountains and the
                                                                                           Save the document with the name ‘About India’.
                    Ans.  The identification or address of a cell in a formula is known as a ‘Cell Reference’.
                    3.   What is the keyboard shortcut for bold?                               Check Spelling of the typed content present in the document.
                    Ans.  Ctrl+B                  examination.
                      What is cell reference?
                                                                                           Find the word ‘civilization’ in the document and replace it with ‘civilisation’.
                    4.  Ans.  An operator is a symbol that performs certain mathematical or logical operations.  2.  Create the given Time Table of class IX as shown below in word processor:
                      What is an operator?
                                                                                          Period/Day
                                                                                              Compulsory Paper
                                                                                                     Optional
                                                                                                       Optional
                                                                                              1 st
                                                                                                2 nd
                      What is sorting?
                                                                                                   3 rd
                                                                                                       4 th
                     6.  5.  Ans.  Sorting refers to the process of arranging data in ascending or descending order based on a   Monday  Period  Period  Period  I  Period  II  Language Paper
                                                                                         Tuesday
                                                                                                           5 th
                     Ans.  It is that area of the chart in which the data is plotted.   Practical Work  Thursday  Period  Period
                      certain criteria.
                     Ans.  It refers to the horizontal and vertical lines in the plot area. The gridlines are inserted in the chart
                       What is Plot Area in Chart?
                                                                                                              6 th
                                                                                         Wednesday
                     7.
                     8.   What are gridlines in chart?                                  Friday
                       to enhance its readability.
                                                                                        Saturday
                       What is a watermark?
                      9.  Ans.  Watermark is a faded image of a design that is printed as a background that can be seen when   This section has sample               Insert a Column after 3rd period to make a time slot for lunch.
                      Ans.  Handouts are thumbnails of all the slides printed together.  questions for practical   3.  Create a worksheet as shown below:
                        held against light.
                      Ans.  Animation is nothing but a sequence of images that are flipped or moved at such a high speed

                        Define handout.
                      10.
                        Define ‘animation’.
                                                                                         Delete the last row of the table and then undo the action.
                      11.  Ans.  RAM  is  a  volatile  memory  i.e.  when  a  computer  is  switched  ‘OFF’  or  the  power  supply  is   examination.    2 1  A  B  C
                        that they give an effect of a motion.
                                                                                           Insert a row on the top of the table and merge all the cells. Type name of the class i.e. IX ‘A’ or IX ‘B’.
                         interrupted, all the information stored in it gets disappeared or lost.
                       Ans.  Cache Memory is a part of CPU and is used when there is swapping of information between the   5  A003  6573  1876  Qtr3  Qtr4
                         How cache memory enhances the processing speed of computer?
                                                                                              Qtr1
                       12.   Why RAM is said to be a volatile memory?                  3 4  Salesman  80009  Quartely Sales Analysis  D  E
                                                                                         A001
                                                                                                   Qtr2
                                                                                         A002
                                                                                                   1895
                                                                                              7894
                       Ans.  An antivirus is a utility software that helps the computer to be free from virus. Examples of  223  274  Touchpad Computer Applications-IX  5438  6935  6542
                                                                                                       8653
                       13.
                         How can a computer system be prevented from virus?
                         primary memory and the ALU.
                                                                                                           20008
                                                                                                       5476
                                                                                                           5482
                         antivirus software are McAfee, Quick Heal, Avast, etc.
                                         Viva Voce Questions
                       14.
                            Projects                                                            Sample Question Paper
                                    (Hints for Part D)                                    Maximum Marks: 50  COMPUTER APPLICATIONS (Subject Code-165)
                                                              Sample Question Paper       General Instructions:  Class IX
                   PROJECT-1                                  This section contains      Part-A:             Time Allowed: 2 hours
                     Pollution has rattled the natural order of our ecosystems and has brought heavy consequences
                                                                                           2.  Part A carries 20 marks while part B carries 30 marks.
                   Do the following tasks in word processor:                               1.  It consists two sections- I and II.
                                                                                            1.  This question paper contains two parts A and B. Each part is compulsory.
                       Open a document. Type the following text:
                                                                                           4.   Both Part A and Part B have choices.
                      misuse natural resources and don’t follow guidelines set by the pollution control boards across
                                                                                           3.  Part-A consists very short answer and case based MCQ Questions and Part-B is Descriptive Paper.
                      the country. Anything that causes Pollution is known as a pollutant. It can be a solid, liquid, or
                      to Earth’s inhabitants. The major reason for Pollution is the unchecked and illegal activities that   sample question paper.    1.  Question No. 16 to 20 are short answer Type (SA-I) questions of 2 mark each, Question No 21 to 25 are Short
                      even gas. No matter what state the pollutant is in, it can have devastating effects on our natural
                                                                                          out of 7 sub-parts.
                                                                                         Part-B:
                      Water pollution forms a major category of Pollution and has become an urgent crisis in many
                                                                                           2.  Section I has 13 questions of very short answer type. An examinee is to attempt any 10 out of 13 questions.
                      countries. We cannot survive without water. So, when most of the water bodies will dry up or get
                      chocked, the human population will come to an end. The next big form of Pollution is air pollution.
                                                                                           3.  Section II has two case studies. Each case study has 7 case-based sub-parts. An examinee is to attempt any 5
                      ecosystem if it is left unchecked.
                                                   Projects
                       It is mainly caused by toxic exhumes from vehicles and the burning of coal for electricity.
                                                                                          Answer Type (SA-II) questions of 3 marks each and Question No 26 is Long Answer Type question of 5 marks.
                       Soil pollution is witnessing an unexpected rise in recent times owing to the mass deforestation
                                                                                                   PART-A
                                                                                          2.  Internal choice is provided in 1 question of 2 marks, 1 question of 3 marks and 1 question of 5 marks.
                        Insert the following text after the first paragraph.  This is an assessment to   question no. 1 to 13.  Section-I
                       Pollution is noise pollution. The high decibel noises coming out from jets and airplanes contribute
                       to noise pollution. It damages our eardrums and, in extreme cases, causes deafness.
                        and illegal farming activities in tropical forests. Another significant yet largely ignored form of   challenge the students to   3.  1.  2.   the blank’ type. Fill the blank with the most appropriate answer. Attempt any 10 questions from
                                                                                         What is a Bus?
                                                                                        This section consists of 13 questions of Very short answer type. Question no. 4 to 8 are of ‘Fill in
                         Move the second paragraph to the end of the document. Using drag & drop feature.
                                                                                        Give two uses of a Firewall system.
                         Save the document as ‘Pollution’.  apply the concepts learnt.   5.  4.   The layout of the paper in which the document gets printed.   [1]
                         [Hint: Select paragraph, while pressing the left mouse button drag it to desired position]   6.   Calc is a .................................... software.   [1]
                           Now provide a heading ‘Pollution’ in 14 pt. Bold, Italics and in Arial   8.  7.   The .................................... contains thumbnails of the slides in sequence of display.   [1] [1]
                                                                                        .................................... means to keep the data secure by restricting unauthorised access.
                           Move the second paragraph in the end of the document using cut paste operations.  9.   the Internet?   [1] [1]
                           Undo the above actions.                                      Which protocol is used for secure communication over a computer network and is widely used on
                          Format the above written paragraphs and give the options as follows:
                                                                                        What holds temporary information, which gets erased as soon as the power supply is turned off? [1]
                           Now Redo the above actions.                                10.  What is meant by Sorting of Data?
                                                                                       Which software or hardware helps in keeping a network secure?
                              justified                                                                       [1]
                          Alignment   :   First Line by: 0.4”                        12.   What is filtering of data?   [1]
                             Spacing   :   1.5 Lines                                                          [1]
                         Line spacing  :
                                                                                       also enables to apply different whirling effects to animate the object?
                           Apply some border in the document.                        13.  Using which menu Rehearse Timings can be set?    [1]
                                                                                      11.  What feature enables to set timings between the display of the content or objects of the slides and
                                                                                                              [1]
                          Touchpad Computer Applications-IX                                                  [1]
                        280                                                                           Sample Question Paper  229
   2   3   4   5   6   7   8   9   10   11   12