Information Technology (Code: 402)
Class X Project/Report File
As per CBSE guidelines, you are required to submit Practical/Project file as a part of CBSE practical
examination.
Note:
Take printouts and assemble in a file properly. Font Style and size should be Times
New Roman and 12 respectively.
Last Date of Submission : 13-01-25
PROJECT
Summarized data reports of same can be presented in Base. Input should be taken using Forms and
output should be done using Reports in Base.
1. Consider the following table Bike Brand Table with details. (05 MARKS)
ICODE BIKENAME PRICE BRANDNAME
G101 Power Fit Exerciser 20000 Power Gymea
G102 Aquafit Hand Grip 1800 Reliable
G103 Cycle Bike 14000 Ecobike
G104 Protoner Extreme Gym 30000 Coscore
G105 Message Belt 5000 Message Expert
G106 Cross Trainer 13000 GTC Fitness
i. To create the above table using design view.
ii. To insert the shown records in the table.
iii. To display the names of all the items whose name starts with “A”.
iv. To display ICODEs and INAMEs of all items, whose Brandname is ‘Reliable’ or
‘Coscore’.
v. To display the Brandname of the item, whose ICODE as “G101”.
2. Consider the following table SOFTDRINK with details. (05 MARKS)
DRINKCODE DNAME PRICE CALORIES
101 Lime and Lemon 20.00 120
102 Apple Drink 18.00 120
103 Nature Drink 15.00 115
104 Green Mango 15.00 140
105 Aam Panna 20.00 135
106 Mango Juice Bahaar 12.00 150
i. Identify the data type of each field and also mention primary key.
ii. To display drink codes, names and calories of all drinks in descending order
of calories. Using Query in design view.
iii. To display names and price of drinks that have price in the range greater than
18(including 18).
iv. Design a query for using design view to calculate the total price and counts of drink available.
v. Also suggest the Primary key, candidate and alternate keys in the above table.
PORTFOLIO/PRACTICAL FILE (10
MARKS)
3. Perform all the questions using Libre office writer.
a. Difference between primary and foreign key with example.
b. Give example of each of the type of Relationships with appropriate table structures (fields).
c. Explain all the data types of BASE database with example.
d. Write the steps using design view to create a table “Employee” having the following fields:
EmpID (employee id), AadhaarNo (Aadhaar number), Ename (Employee Name), deptt
(Department), Age, Address, Contact_no.Choose the appropriate ‘field’ type for each field.
e. Write a paragraph on the “Role of AI in the Education Sector”. Insert appropriate image
according the topic. Make use of different filters to enhance the image. Write steps also.
4. Perform all the questions using Spreadsheet.
a. Enter the following data in a spreadsheet and perform the Goal Seek operation to know
how much marks are needed in the third semester to score the 70% marks.
b. Anjali wants to summarise and compare the total expenditure of her household for the months of
October, November and December. She has maintained this data in three worksheets as shown
below:
Help Anjali to summarise the total expenditure item-wise in another workbook.
c. Create a macro as a function to calculate the SUM of two numbers by passing arguments.
d. Create a link in your spreadsheet with “[Link]”
e. Write the steps to consolidate data of two sheets given below in third sheet of open office Calc.
Name June Pocket Money
Amit 1200
Sumit 1000
Naina 1500
Suman 1300
Kamal 1400
Name June Pocket Money
Amit 900
Sumit 1100
Naina 1300
Suman 1200
Kamal 1250