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

