Page 8 - IT-802_class_12
P. 8

Assessment Resources
                                                                                                           Inter-Disciplinary
                                                                                      1.  You have a summer vacation project on how to make biogas. You have done a lot of research, clicked pictures of biogas
                                                                                       plants and taken videos of people who use biogas. Now, you have to make a presentation before the class. What would you
                                          Objective & Subjective Questions           B.  Competency-based/Application-based questions:   Subject Enrichment
                                                                                       2.  Mr Tapas has a spreadsheet with a list of 500 items in his shop. A customer comes and asks for a particular item. How should

                                          This section contains questions              Ans.  OpenOffice Impress
                                                                                       he arrange the data so that he can find that item quickly? What would Mr Tapas do?
                                                                                       use?
                                          to assess the intellectual and                 Ans.  He can use sorting feature to arrange the data alphabetically.
             Unsolved Exercise  (Objective Type Questions)  comprehensive writing skills.   Unsolved Exercise  (Objective Type Questions)
                        Section A
                                                                                                  Section A
              1.  Self-management, also  known  as  ............................,  is  the  ability  to  effectively  control  one’s  emotions,  behaviour,  and
             A.  Choose the correct option.  ii.  Self-innovation                      A.  Choose the correct option.  ii.  LibreOffice Calc
                                                                                                    iv.  All of the above
                           iv.  None of these
                2.  ............................ includes activities for which there is no apparent reward, but one derives enjoyment and satisfaction in      1.  Which of the following is a type of spreadsheet?
               thoughts.
                                                                                        i.  Microsoft Excel
                                                                                                     ii.  Workbook
                                                                                         iii. Google Sheets
                                                                                                     iv.  None of these
                 i.  Self-control   ii.  Extrinsic motivation                             2.  A ............................... software makes our work more expressive and presentable?
               iii. Self-design
                           iv.  None of these
                                                                                         i.  Presentation
                 doing them.                                                                 3.  You can also use the keyboard to select the entire sheet by pressing ............................... .
                                                                                                     ii.   Ctrl + V
                                                                                         iii. Notebook
               i.  Intrinsic motivation
                           ii.  Extrinsic motivation
                3.  ............................ arises because of incentives or external rewards. Lack of motivation or incentives may lead to frustration.     iv.  Ctrl + Z
               iii. Both i and ii
                            iv.  None of these                                             i.   Ctrl + C
                                                                                                      iv.  All of the above
                                                                                         iii.   Ctrl + A
                 i.  Intrinsic motivation   ii.  Prepare an action plan and work hard      4.  The extension of Spreadsheet (OpenOffice) is ................................ ii.  .ods
                 iii. Both i and ii
                 4.  Which of the following is a way to become result-oriented?  iv.  All of these     i.  .xls
                                                                                          iii. .txt
                  i.  Set clear goals and make a calendar                                  5.  What would you do to select an entire worksheet in a spreadsheet?
                  iii. Use the right resources and tools   Section B                       i.  Click on the File tab and select Properties from the list
                                                                                          iii. Click on the grey rectangle in the upper left corner of the spreadsheet
                         (Subjective Type Questions)
                                                                                          register. She has entered the marks of her students in various subjects in a spreadsheet. Now, she wants to find out the total
                                                                                            ii.  Click on the grey row heading
               A.  Answer the following questions:                                           6.  Ms Kaushiki is the class teacher of Std XII and has just started using a computer spreadsheet instead of her manual marks
                                                                                          iv. Click on the grey column heading
                1.  What do you mean by ‘motivation’?
                  2.  Give some examples of result-oriented goals.  [NCERT]                            ii.  She can use + operator
                                                                                                       iv.  None of these
                  3.  What do you mean by personality?  [NCERT]                           marks for each student. What should she do?
                 6.  List the importance of positive thinking. Describe how it can help someone achieve one’s goals.
                   4.  Write a few steps to overcome a personality disorder.                i.  She can use the Sum function   ii.  Right aligned
                                                                                           iii. Both (i) and (ii)
                   5.  Describe the ways you can make positive thinking a habit in life.      7.  What is the default alignment of numbers in a cell?  iv.  Randomly aligned
                                                                                           want  anyone  else  to  look  at  and  make  changes  to  her  work.  She  can  do  this  by  protecting  her  spreadsheet  using
                                                                                             8.  Ms  Kusum  is  sharing  the  computer  with  other  teachers  and  staff.  She  may  want  to  protect  her  data.  She  may  not
                                                                                           i.  Left aligned
                   7.  Explain different types of motivation with suitable examples.  Competency based/      iii. Center aligned
                   8.  What is histrionic personality disorder? What are it`s symptoms?                ii.  track changes
                   9.  What is stress and how should you manage it?                          a ................................  iv.  None of these
                   10.  How should you set goals in daily life?                                i.  password    ICT Skills-IV  115
                   11.  What are the Big Five factors of personality development?
                                      Life Skills and Values  Activity-based question
                  1.  Deepti practises more and more sample question papers during her free time after school in order to get the Best Student
                   12.  What are the common personality disorders?
                                                                                            iii. read only
                  2.  Ravi works for a pharmaceutical company. He is a very quiet person who communicates only when required. He likes to be
                   alone and appears detached and aloof. He shows little interest in forming personal relationships and seems to be emotionally
                  award. What kind of motivation is this?
                   B.  Competency-based/Application-based questions:   This section contains fun based
                    cold. Which type of personality disorder do you see in him?  interactive task.
                    Touchpad Information Technology-XII
                  46
                                                          Practical Work                          Practical Work
                                 Life Skills & Values     This section has sample        Ans. Syntax of Alter table is:   Creativity
                                                                                          1.  Write the syntax of ALTER TABLE.
                Class Activity    [CBSE Handbook]         questions for practical        ALTER TABLE table_name   Computational Thinking
                                                                                                              Subject Enrichment
                 Qualifications, Skills, Universities and colleges where these courses are available etc.
                                   Art Integration
                Activity 1 Choose  any  4-5  Green  Careers  and  prepare  a  brochure  elaborating  all  the  aspects  like  Educational      ADD column name datatype;  Experiential Learning
                                    [NCERT]
                                                          examination.                    2.  Create a table DOCTOR with the fields – DOC_ID, DOC_NAME, DOC_DEPT, DOC_FEE.
                 Prepare posters on green jobs. (Any four jobs of your choice)
                Activity 2         Critical Thinking                                        +----------+-------------+------+-----+---------+-------+
                                                                                            | Field    | Type        | Null | Key | Default | Extra |
                      Identify an area where you can plant a sapling. Coordinate with your teacher for the kind of plant that
                Activity 3                                                                  +----------+-------------+------+-----+---------+-------+
                 Tree Plantation
                   Material required: Seeds, soil, water, gloves, etc.                     | DOC_NAME | varchar(40) | YES  |     | NULL    |       |
                    Procedure:  can thrive at the selected location. For example, there are various plants that require less water. Now,   | DOC_FEE  | int         | YES  |     | NULL    |       |
                                                                                            | DOC_ID   | varchar(10) | YES  |     | NULL    |       |
                                     [NCERT]
                    plant a suitable seed or sapling. Name it if you want. Make sure that you water the plant regularly and       Ans. The syntax for creating the given table is:
                                                                                           | DOC_DEPT | varchar(20) | YES  |     | NULL    |       |

                                                                                           +----------+-------------+------+-----+---------+-------+
                   take care of it.  Communication  Class Activity                        create table DOCTOR (DOC_ID varchar(10), DOC_NAME varchar(40), DOC_DEPT varchar
                                                                                        (20), DOC_FEE int);
                 Activity 4                                                              3.  Enter 5 records in the table created in Ques 2.
                  Group discussion
                    Green jobs
                       Every student will describe one green job that one would like to do. Each one of them will make a list
                     Form groups, depending on the number of students  present in a class.
                    Material required: Pen, paper, etc.   This section has Hands-on        | DOC_ID | DOC_NAME      | DOC_DEPT    | DOC_FEE |
                     Procedure:                                                            +--------+---------------+-------------+---------+
                                                                                            +--------+---------------+-------------+---------+
                                    Life Skills & Values                                   | 11002  | Suneel Sharma | Neurology   |    1000 |
                   Hold a group discussion on possible ways to promote Sustain the role of changing careers in propelling the idea   activities to engage   | 11004  | Sonam         | Gynaecology |     400 |
                    and share it with the rest of the class.
                                    [CBSE Handbook]
                                                                                           | 11001  | Amit Kumar    | Medicine    |     500 |
                                                                                           | 11003  | Sonia Gupta   | Surgery     |    2000 |
                  Activity 5                                                               +--------+---------------+-------------+---------+
                                                                                           | 11005  | Kanika        | Paediatrics |     600 |
                     of able Development. Do not forget to highlight Sustainability .   students for an enriched      INSERT INTO DOCTOR VALUES(11002, “Sunil Sharma”, “Neurology”, 1000);
                                              learning experience.                      INSERT INTO DOCTOR VALUES(11004, “Sonam”, “Gynaecology”, 400);
                                                                                       Ans. INSERT INTO DOCTOR VALUES(11001, “Amit Kumar”, “Medicine”, 500);
                                                                                        INSERT INTO DOCTOR VALUES(11003, “Sonia Gupta”, “Surgery”, 2000);
                                                                                      Ques 2.
                                                                                        INSERT INTO DOCTOR VALUES(11005, “Kanika”, “Paediatrics”, 600);
                                                                                       4.    Write a query to display the name and fee of the Doctor who charges the maximum fee, from the table created in
                                                                                      Ans. SELECT DOC_NAME, MAX(DOC_FEE) FROM DOCTOR;
                                                                                                        Practical Work
                                                                                                            297
                    Touchpad Information Technology-XII
                   154
                                                                                            CBSE Sample Question Paper
                        Projects   Life Skills and Values  Sample Question Paper          INFORMATION TECHNOLOGY (Subject Code–802)
                                    Creativity
                                                                                       Max. Time: 3 Hours
                                   Experiential Learning  This section contains           1. Please read the instructions carefully. Class XII (Session 2023-2024)
                                                                                       General Instructions:
                1.    Create a project which allows to enter a number in Decimal. It will convert the given number into Binary, Octal and   sample question paper.         5. All questions of a particular section must be attempted in the correct order.  Max. Marks: 60
                                                                                          2. This Question Paper consists of 24 questions in two sections – Section A & Section B.
                                                                                          3. Section A has Objective type questions whereas Section B contains Subjective type questions.
                Hexadecimal and display the result.
                  If clicked on “Create new user”, it will ask for 3 things – Name, Required Username, Password. On submit, these details
                2.  Create a project which displays 2 options:                                   ii.  There is no negative marking.
                                                                                          6. SECTION A – OBJECTIVE TYPE QUESTIONS (30 MARKS):
                                                                                        i.  This section has 06 questions.
                                                                                          4.   Out of the given (6 + 18 =) 24 questions, a candidate has to answer (6 + 11 =) 17 questions in the allotted (maximum) time of 3 hours.
                                                                                        iii. Do as per the instructions given.
                will be saved in a Database and a confirmation message will be displayed.
                    •  Create new user                                                      7. SECTION B – SUBJECTIVE TYPE QUESTIONS (30 MARKS):
                •  Login
                                                                                        iv. Marks allotted are mentioned against each question/part.
                      If clicked on “Login”, it will ask to enter username and password. If the entered details match with the stored details   Projects       i.  This section contains 18 questions.
                 3.   Consider a shop selling electronic items. It allows to add new products to the inventory and update the inventory   This is an assessment to    iv. Marks allotted are mentioned against each question/part.
                   in database, confirmation will be displayed – “Login Successful”, if details do not match, then “Login Failed” will be           ii.  A candidate has to do 11 questions.
                 when new stock is added. It allows to search for the availability of a desired product. The suggested modules can be:
                                                                                       iii. Do as per the instructions given.
                 •    Add and Update Items and Inventory: The shop can add new products to the system by entering the details of new

                displayed.
                 items and can even update the inventory and price details of existing items.
                                                                                              SECTION A: OBJECTIVE TYPE QUESTIONS
                    •    Enter sale of item: The shop can create sale record of items and simultaneously the quantity of the item will be   challenge the students to              Q 1. Answer any 4 out of the given 6 questions on Employability Skills
                                                                                       to harm you.
                 •  View current inventory: The shop can view records of current inventory in stock.
                  availability of a desired book. It allows to keep track of information such as issue date, last date to return the book and
                  decremented.
                     •  View sales made: The shop can view records of sold items.  apply the concepts learnt.       ii.  .................... is defined as the drive required to engage in goal-oriented behaviour   (1 × 4 = 4 marks)
                                                                                      i.   .................... is feeling extremely nervous and worried because you believe that other people do not like you or are trying
                      4.   Consider a library management system. It allows to add new books and update the details. It allows to search for the          iv.  .................... is NOT a component of effective communication?   1
                     •    Add and Update Books: The librarian can add new books to the system by entering the details of the books and can      Q 2.  Answer any 5 out of the given 7 questions.   1 1
                  information about applicable fine. The suggested modules can be:
                                                                                      iii. .................... symbol is displayed when the column in Calc is not wide enough to display the value.
                                                                                     vi. "Green Skills" are primarily focused on .................... .
                  •  Search option: Librarian can search for books by entering the name of the book.
                                                                                     v.   Individuals, who focus on developing solutions that benefit the society, are called .................... .
                   even update the details of existing books.
                      •    Issue Book: The librarian can issue books to the students and simultaneously the quantity of the book issued will            ii.  .................... is a special method that every Java application must have.   1 1 1
                                                                                     i.  The size of double datatype in java is .................... bit.
                   •    Calculate Fine: The librarian can view the issue and expiry date for the book issued. The system can calculate fine if
                                                                                          iii. Choose the correct MySql command to display 5% of salary as allowance  (1 × 5 = 5 marks) 1
                   be decremented.
                      •  View Issued Books: The librarian can view issued books.      iv.  They are programmers who code in high level languages.  (b)  select salary *0.5 as allowance from teacher;  1
                                                                                     (a)  select salary +0.5 as allowance from teacher;
                   the expiry date is over and inform the librarian.
                       5.   Consider a Hotel management system. It allows the hotel management to add and update details about rooms such         (c)  End users
                                                                                     (a)  Application programmers
                      as type of room, type of bed, tariff, occupancy status etc. It allows customers to check in to rooms and vacate rooms       v.  What is a byte code?      (d)  Database Administrators   1
                                                                                     (c)  select salary *0.5 rename as allowance from teacher;  (d)  select salary+salary *0.5 allowance from teacher;
                                                                                                (b)  System analysts
                   •    Add and Update Booking: Guest can make new bookings, and can also modify and cancel the bookings. As per the
                    booking, the rooms will be shown as booked on the specified dates. If the booking is cancelled by the guest, the
                                                                                     answered.
                   The suggested modules can be:
                       as per fixed schedule.                                       vi.   ....................  are  real  time  lectures,  where  users  participate  in  the  lecture,  may  ask  questions  and  get  their  queries  1 1
                                                                                                    CBSE Sample Question Paper  1
                    room will be freed.                                                                    317
                   308  Touchpad Information Technology-XII
   3   4   5   6   7   8   9   10   11   12   13