Class X Computer Applications – Practical Answers

Based on LibreOffice Writer, Calc and Base

SET 1 – Computer Applications

A. Styles – Importance of Education

Aim: Create a document and apply Title, Heading 1 and Heading 2 styles. Modify Heading 1 and save the document.

Procedure in LibreOffice Writer

1. Open LibreOffice Writer.

2. Type the following content.

Importance of Education

Introduction

Education is an essential part of human life. It gives us knowledge, skills and confidence.

Benefits of Education

Knowledge and Skills

Education helps us develop our abilities and understand the world around us.

Better Career Opportunities

Education prepares students for jobs, professions and future career growth.

Conclusion

Education helps individuals become responsible citizens and contributes to the development of society.

3. Select Importance of Education.

4. Open the Styles menu and apply Title.

5. Select Introduction, Benefits of Education and Conclusion, and apply Heading 1.

6. Select Knowledge and Skills and Better Career Opportunities, and apply Heading 2.

7. Modify Heading 1:

   • Open Styles → Manage Styles (F11).

   • Find Heading 1 in the Paragraph Styles list.

   • Right-click it and select Edit Style.

   • Change the font, size or colour in the relevant tabs.

   • Click OK.

8. Save the file as Importance_of_Education.odt using Ctrl + Shift + S.

Result: The document is formatted with the required styles, and Heading 1 has been modified.

B. Working with Images – Save Environment

Procedure

1. Open Writer and type a short document.

Save Environment

The environment provides us with air, water, food and other essential resources. We must protect nature to maintain a healthy life.

Ways to Save the Environment

• Plant more trees.

• Save water and electricity.

• Reduce plastic usage.

• Reuse and recycle waste.

• Keep our surroundings clean.

Conclusion

Every individual should contribute to protecting the environment for future generations.

2. Select the title and apply Title. Apply Heading 1 to the section heading.

3. Select Insert → Image and choose a suitable environment picture from your computer.

4. Click the image and drag a corner handle to resize it proportionally.

5. Right-click the image and select Properties or Wrap, depending on your LibreOffice version.

6. Choose a suitable wrap option, such as Parallel or Optimal, and set the image alignment to the right.

7. Move the image beside the paragraph.

8. Save as Save_Environment.odt.

Result: An image is inserted, resized, positioned on the right and wrapped with text.

C. Goal Seek – Student Marksheet

Aim: Calculate the total and percentage of five students and find the marks needed in one subject to achieve 75%.

Step 1: Create the marksheet in Calc

Enter this data into cells A1:G6.

Cell	Content
A1	Student Name
B1	English
C1	Maths
D1	Science
E1	Social Science
F1	Computer
G1	Total
H1	Percentage

Example marks:

Student Name	English	Maths	Science	Social Science	Computer
Amit	70	65	72	68	75
Riya	80	70	78	75	82
Rahul	60	55	65	62	70
Sneha	85	80	88	82	90
Neha	72	68	70	74	76

Step 2: Enter formulas

In cell G2, enter:

=SUM(B2:F2)

In cell H2, enter:

=G2/500*100

Copy both formulas down to row 6 using the fill handle.

Step 3: Use Goal Seek

For example, find the Maths marks required for Amit to achieve 75%.

1. Select cell H2.

2. Go to Tools → Goal Seek.

3. Enter the following:

   • Formula cell: $H$2

   • Target value: 75

   • Variable cell: $C$2

4. Click OK and accept the calculated result.

Amit's other four subjects total 285 marks. To achieve 75%, he needs 375 total marks out of 500.

Required Maths marks = \(375 - 285 = 90\).

Result: Amit needs 90 marks in Maths to achieve 75% overall, assuming the other four marks remain unchanged.

D. Macros – Sort Students According to Marks

Aim: Record a macro to sort students according to marks and run it.

Step 1: Enter the data

Open LibreOffice Calc and enter the following:

A	B
Student Name	Marks
Amit	65
Riya	90
Rahul	55
Sneha	85
Neha	72

Step 2: Enable macro recording

1. Go to Tools → Options → LibreOffice → Advanced.

2. Enable Enable macro recording (limited), if this option is available in your version.

3. Click OK.

Step 3: Record the macro

1. Select Tools → Macros → Record Macro.

2. Select the data range, including the headings.

3. Go to Data → Sort.

4. Select Marks as the sort key.

5. Choose Descending order.

6. Click OK.

7. Click Stop Recording.

8. Save the macro in the current document or in My Macros, give it the name SortMarks, and save it.

Step 4: Run the macro

1. Change the order of the data manually or restore the original data.

2. Go to Tools → Macros → Organize Macros → Basic.

3. Find and select SortMarks.

4. Click Run.

The expected sorted result is:

Student Name	Marks
Riya	90
Sneha	85
Neha	72
Amit	65
Rahul	55

Result: The macro sorts the students from highest to lowest marks.

Note: Macro recording availability and menu labels may vary by LibreOffice version. If the recording option is unavailable, check whether the feature is enabled and permitted in your installation.

E. DBMS & LibreOffice Base – SchoolDB

Aim: Create a database named SchoolDB and a table named Student.

Step 1: Create the database

1. Open LibreOffice Base.

2. Select Create a new database.

3. Click Next, then Finish.

4. Save the database as SchoolDB.odb.

Step 2: Create the Student table

1. Select Tables → Create Table in Design View.

2. Enter these field names and data types.

Field name	Field type	Purpose
Student_ID	Integer	Unique student ID
Name	Text (VARCHAR)	Student's name
Class	Text (VARCHAR)	Class
Division	Text (VARCHAR)	Division
Contact_No	Text (VARCHAR)	Contact number

3. Right-click the row selector beside Student_ID and choose Primary Key.

4. Save the table as Student.

Use Text for contact numbers because they may start with zero and are not used for arithmetic.

Step 3: Enter five records

Open the Student table and enter:

Student_ID	Name	Class	Division	Contact_No
1	Amit Sharma	X	A	9876543210
2	Riya Patil	X	B	9876543211
3	Rahul Verma	X	A	9876543212
4	Sneha Joshi	X	B	9876543213
5	Neha Singh	X	A	9876543214

Save the table and database.

Result: The SchoolDB database contains a Student table with five records and a primary key.

SET 2 – Computer Applications

A. Styles – Digital India

Procedure

1. Open Writer and type the following content.

Digital India

Introduction

Digital India is an initiative to improve digital services and connectivity in India.

Benefits of Digital India

Digital services help people access information, make online payments and use government services.

Digital learning makes educational resources available to students through the internet.

Conclusion

Digital India encourages technology adoption and supports a more connected society.

2. Apply Title to Digital India.

3. Apply Heading 1 to Introduction, Benefits of Digital India and Conclusion.

4. Select the two paragraphs under Benefits of Digital India.

5. Open Styles → Manage Styles (F11).

6. Select the Paragraph Styles category and choose New Style from Selection.

7. Name the style Important and click OK.

8. Apply the Important style to both paragraphs, if it has not already been applied.

9. Save as Digital_India.odt.

Result: Title and Heading styles are applied, and a custom style named Important is used on two paragraphs.

B. Advanced Writer – Benefits of Yoga

Procedure

1. Create a document with the following content.

Benefits of Yoga

Introduction

Yoga is a practice that combines physical postures, breathing techniques and relaxation.

Physical Health

Yoga improves flexibility, balance and body awareness. Regular practice can support general fitness.

Mental Well-being

Breathing and relaxation exercises may help manage everyday stress and promote calmness.

Better Concentration

Yoga encourages attention and mindfulness, which can support concentration during study and work.

Conclusion

Yoga is a useful practice for maintaining physical fitness and supporting mental well-being.

2. Apply Title to Benefits of Yoga.

3. Apply Heading 1 to Introduction, Physical Health, Mental Well-being, Better Concentration and Conclusion.

4. Place the cursor below the title and above Introduction.

5. Select Insert → Table of Contents and Index → Table of Contents, Index or Bibliography.

6. In the dialog, choose Table of Contents and confirm the settings.

7. Click OK.

8. Save as Benefits_of_Yoga.odt.

Result: An automatic Table of Contents is created from the heading styles.

C. Goal Seek – Sales Spreadsheet

Step 1: Enter the data in Calc

Product	Quantity	Price	Total Sales
Notebook	10	50	=B2*C2
Pen	20	10	=B3*C3
File	5	40	=B4*C4
Folder	8	25	=B5*C5
Bag	2	500	=B6*C6

For the first product, cell D2 contains =B2*C2. Copy the formula down to D6.

Step 2: Find the quantity required for a sales target

Suppose the target sales for Notebooks are ₹1,000 at ₹50 per notebook.

1. Select cell D2.

2. Open Tools → Goal Seek.

3. Enter:

   • Formula cell: $D$2

   • Target value: 1000

   • Variable cell: $B$2

4. Click OK.

Calculation: ₹1,000 ÷ ₹50 = 20 notebooks.

Result: The required quantity is 20 notebooks, assuming the selling price remains ₹50.

D. Macros – Sort Employee Salaries

Procedure

1. Enter employee names and salaries in Calc.

Employee	Salary
Amit	25000
Riya	35000
Rahul	22000
Sneha	40000
Neha	30000

2. Enable macro recording under Tools → Options → LibreOffice → Advanced, if available.

3. Select Tools → Macros → Record Macro.

4. Select the employee table, including the headings.

5. Choose Data → Sort.

6. Set the sort key to Salary and order to Descending.

7. Click OK, then Stop Recording.

8. Save the macro as SortSalary.

9. Run it from Tools → Macros → Organize Macros → Basic.

Expected result:

Employee	Salary
Sneha	40000
Riya	35000
Neha	30000
Amit	25000
Rahul	22000

Result: Employee salaries are sorted from highest to lowest.

E. LibreOffice Base – LibraryDB

Table structure

Create a new database and save it as LibraryDB.odb.

Create a table named Books with these fields:

Field name	Data type
Book_ID	Integer
Book_Name	Text (VARCHAR)
Author	Text (VARCHAR)
Price	Decimal or Currency
Quantity	Integer

Set Book_ID as the Primary Key and save the table.

Five sample records

Book_ID	Book_Name	Author	Price	Quantity
1	Wings of Fire	A. P. J. Abdul Kalam	250	10
2	The Alchemist	Paulo Coelho	300	8
3	Discovery of India	Jawaharlal Nehru	400	5
4	Ignited Minds	A. P. J. Abdul Kalam	220	7
5	Godan	Munshi Premchand	180	6

Enter these records in the Books table and save.

Result: LibraryDB contains a Books table with five records.

SET 3 – Computer Applications

A. Working with Images – Road Safety

Procedure in LibreOffice Writer

1. Create a document titled Road Safety.

2. Add the following content.

Road Safety

Introduction

Road safety means following traffic rules to prevent accidents and protect people on the road.

Important Road Safety Rules

• Always wear a helmet while riding a two-wheeler.

• Wear a seat belt in a car.

• Follow traffic signals and road signs.

• Never use a mobile phone while driving.

• Use a zebra crossing to cross the road.

• Follow speed limits and avoid reckless driving.

Conclusion

Road safety is everyone's responsibility. Following traffic rules can save lives.

3. Select Insert → Image and insert a road-safety picture.

4. Select the image and open its cropping controls through the image toolbar or Format → Image → Crop, depending on your version.

5. Crop unnecessary parts and resize the image proportionally.

6. Right-click the image and select a suitable Wrap option, such as Parallel.

7. Position the image beside the text.

8. Save as Road_Safety.odt.

Result: A document with a cropped, resized image and suitable text wrapping is created.

B. Advanced Writer – Annual Sports Day

Procedure

1. Open Writer and type this report.

Annual Sports Day Report

Introduction

Our school organised its Annual Sports Day to encourage physical fitness, teamwork and sportsmanship.

Inauguration

The programme began with a welcome address and the opening ceremony.

Sports Competitions

Students participated in races, relay races, long jump and other sporting events.

Prize Distribution

Winners received prizes and certificates for their achievements.

Conclusion

The event encouraged students to remain active, disciplined and confident.

2. Apply Title to the main title.

3. Apply Heading 1 to all four section headings.

4. Insert an automatic Table of Contents using Insert → Table of Contents and Index → Table of Contents, Index or Bibliography.

5. Use Insert → Image to add a suitable sports-day photograph.

6. Enable Track Changes using Edit → Track Changes → Record. In some versions, the command appears under the Track Changes submenu.

7. Edit one sentence, for example, change “The event encouraged students” to “The event inspired students”.

8. Check that the change is recorded. Save as Annual_Sports_Day.odt.

Result: The report contains heading styles, an automatic Table of Contents, an image and at least one tracked change.

C. Goal Seek – Maths Marks for 75%

Step 1: Create the marksheet

Use five subjects, each out of 100.

Student	English	Maths	Science	Social Science	Computer
Amit	70	65	72	68	75
Riya	80	70	78	75	82
Rahul	60	55	65	62	70
Sneha	85	80	88	82	90
Neha	72	68	70	74	76

Add columns F and G for Total and Percentage if your five subject columns occupy B:F.

In G2, enter:

=SUM(B2:F2)

In H2, enter:

=G2/500*100

Copy both formulas down to row 6.

Step 2: Use Goal Seek

For Amit:

1. Select H2.

2. Open Tools → Goal Seek.

3. Set Formula cell to $H$2.

4. Set Target value to 75.

5. Set Variable cell to $C$2 because Maths is in column C.

6. Click OK.

Amit needs 375 marks overall. His other four subjects total 285.

Required Maths marks = 375 − 285 = 90 marks.

Result: Amit needs 90 marks in Maths to obtain 75% overall.

D. Macros – Sort Ten Student Names Alphabetically

Step 1: Enter student names

Enter the following names in cells A1:A11.

Student Name
Rahul
Amit
Sneha
Neha
Karan
Priya
Rohan
Anjali
Varun
Pooja
Meera

Step 2: Record the macro

1. Enable macro recording under Tools → Options → LibreOffice → Advanced, if available.

2. Select Tools → Macros → Record Macro.

3. Select the name range, including the heading.

4. Choose Data → Sort.

5. Set the sort key to Student Name and select Ascending order.

6. Click OK.

7. Click Stop Recording.

8. Save the macro as SortNames.

Step 3: Run the macro

Go to Tools → Macros → Organize Macros → Basic, select SortNames and click Run.

Expected result:

Student Name
Amit
Anjali
Karan
Meera
Neha
Pooja
Priya
Rahul
Rohan
Sneha
Varun

Result: The ten student names are sorted alphabetically.

E. DBMS – HospitalDB

Step 1: Create the database

1. Open LibreOffice Base.

2. Select Create a new database.

3. Finish the wizard and save as HospitalDB.odb.

Step 2: Create the Patient table

In Tables → Create Table in Design View, enter:

Field name	Data type
Patient_ID	Integer
Patient_Name	Text (VARCHAR)
Age	Integer
Gender	Text (VARCHAR)
Disease	Text (VARCHAR)

Set Patient_ID as the Primary Key and save the table as Patient.

Step 3: Enter five records

Patient_ID	Patient_Name	Age	Gender	Disease
1	Amit Sharma	25	Male	Fever
2	Riya Patil	30	Female	Cold
3	Rahul Verma	45	Male	Diabetes
4	Sneha Joshi	28	Female	Migraine
5	Neha Singh	35	Female	Allergy

Result: HospitalDB contains a Patient table with suitable field types, a primary key and five records.

SET 4 – Computer Applications

A. Styles – Artificial Intelligence

Procedure

1. Open Writer and type the following.

Artificial Intelligence

Introduction

Artificial Intelligence (AI) is a technology that enables computers to perform tasks that normally require human intelligence.

Applications of AI

Education

AI can help students learn through personalised learning tools and educational applications.

Healthcare

AI can assist in analysing medical information and supporting healthcare professionals.

Conclusion

Artificial Intelligence is becoming important in many fields. It should be used responsibly and ethically.

2. Apply Title to Artificial Intelligence.

3. Apply Heading 1 to Introduction, Applications of AI and Conclusion.

4. Apply Heading 2 to Education and Healthcare.

5. Open Styles → Manage Styles using F11.

6. Select Paragraph Styles, then create a new style using New Style from Selection or the context menu.

7. Name the style MyCustomStyle.

8. Edit its font, size, colour or alignment and click OK.

9. Apply the custom style to a paragraph.

10. Save as Artificial_Intelligence.odt.

Result: Title, Heading 1, Heading 2 and a modified custom style are used.

B. Working with Images – Water Conservation

Procedure

1. Create a Writer document.

Water Conservation

Introduction

Water conservation means using water carefully and preventing unnecessary wastage.

Methods of Water Conservation

• Repair leaking taps and pipes.

• Turn off taps when not in use.

• Collect rainwater through rainwater harvesting.

• Reuse water where appropriate.

• Avoid polluting rivers, lakes and ponds.

Conclusion

Every drop of water matters. Saving water today helps protect the needs of future generations.

2. Apply Title and Heading styles.

3. Choose Insert → Image and insert a picture of rainwater harvesting.

4. Insert a second image showing water conservation or a clean water source.

5. Resize both images using the corner handles.

6. Right-click each image and select Wrap → Parallel or another appropriate option.

7. Position the images beside the relevant paragraphs, using the image alignment controls as needed.

8. Save as Water_Conservation.odt.

Result: The document contains two appropriately positioned images with suitable text wrapping.

C. Advanced Writer – School Exhibition

Procedure

1. Type the report.

School Exhibition Report

Introduction

Our school organised an exhibition to showcase students' creativity, knowledge and practical skills.

Science Projects

Students presented models related to renewable energy, environmental protection and scientific discoveries.

Art and Craft

The exhibition displayed paintings, handmade crafts and creative artwork prepared by students.

Participation and Learning

The event encouraged teamwork, confidence, problem-solving and practical learning.

Conclusion

The school exhibition was an educational and enjoyable experience for everyone.

2. Apply Title to the main title and Heading 1 to the section headings.

3. Place the cursor below the title and insert an automatic Table of Contents.

4. Enable Track Changes through Edit → Track Changes → Record.

5. Edit two sentences, for example:

   • Change “students' creativity” to “students' creativity and innovation”.

   • Change “The event encouraged teamwork” to “The event promoted teamwork”.

6. Confirm that both changes appear as tracked changes.

7. Save as School_Exhibition.odt.

Result: A report is created with heading styles, a Table of Contents and two recorded changes.

D. Calc – Goal Seek and Macro

Aim: Calculate profit, find a selling price for a target profit and record a sorting macro.

Step 1: Create the spreadsheet

Enter the following data:

Product	Quantity	Cost per Unit	Selling Price	Total Profit
Notebook	100	20	30	Formula
Pen	200	5	8	Formula
Bag	20	200	250	Formula
File	50	10	15	Formula
Folder	80	8	12	Formula

Assume columns A:E contain the data, with headings in row 1.

In cell E2, enter:

=B2*(D2-C2)

Copy the formula down to E6.

This calculates:

\[ \text{Total Profit}=\text{Quantity}\times(\text{Selling Price}-\text{Cost per Unit}) \]

Step 2: Use Goal Seek to find the selling price

For the Notebook product, suppose the target profit is ₹1,500.

1. Select cell E2.

2. Open Tools → Goal Seek.

3. Enter:

   • Formula cell: $E$2

   • Target value: 1500

   • Variable cell: $D$2

4. Click OK.

Calculation:

\[ 1500=100\times(\text{Selling Price}-20) \]

\[ \text{Selling Price}=20+\frac{1500}{100}=₹35 \]

Required selling price: ₹35 per notebook.

Step 3: Record a macro to sort by profit

1. Enable macro recording, if available.

2. Choose Tools → Macros → Record Macro.

3. Select the complete table, including the headings.

4. Choose Data → Sort.

5. Select Total Profit as the sort key and choose Descending order.

6. Click OK and Stop Recording.

7. Save the macro as SortProfit.

8. Run the macro through Tools → Macros → Organize Macros → Basic.

Result: The spreadsheet calculates profit, Goal Seek finds the required selling price, and the macro sorts products by profit.

E. LibreOffice Base – LibraryDB

For this task, create a new database named LibraryDB.odb with a table called Books.

Use the same structure and five initial sample records given in Set 2, Section E.

Demonstrate adding a new record

Open the Books table and add:

Book_ID	Book_Name	Author	Price	Quantity
6	Computer Fundamentals	P. K. Sinha	350	12

Save the record.

Demonstrate editing an existing record

1. Find the record with Book_ID = 2.

2. Change its Price from ₹300 to ₹320.

3. Save the record.

Result: You have demonstrated adding a new record and editing an existing record in LibreOffice Base.

SET 5 – Computer Applications

A. Writer – Importance of Computers

Procedure

1. Open LibreOffice Writer and enter the following content.

Importance of Computers

Introduction

Computers are electronic devices that process data and produce useful information. They are widely used in education, business and everyday life.

Computers in Education

Computers help students access digital books, online classes, educational videos and learning applications.

Computers in Business

Businesses use computers for accounting, record keeping, communication and data analysis.

Advantages of Computers

Computers perform calculations quickly, store large amounts of information and help people complete tasks efficiently.

Conclusion

Computers are an important part of modern life. They should be used carefully, responsibly and productively.

2. Apply Title to Importance of Computers.

3. Apply Heading 1 to the section headings.

4. Place the cursor below the title and insert an automatic Table of Contents.

5. Enable Track Changes using Edit → Track Changes → Record.

6. Edit a sentence, such as changing “Computers help students access digital books” to “Computers help students access digital books and interactive learning resources”.

7. Verify that the change is recorded.

8. Save as Importance_of_Computers.odt.

Result: A document is created with suitable styles, an automatic Table of Contents and Track Changes enabled.

B. Working with Images – Environmental Pollution

Procedure

1. Create a document with the following content.

Environmental Pollution

Introduction

Environmental pollution occurs when harmful substances contaminate air, water or land.

Types of Pollution

Air Pollution

Smoke from vehicles, industries and burning waste contributes to air pollution.

Water Pollution

Dumping waste and chemicals into water bodies harms aquatic life and affects water quality.

Land Pollution

Plastic waste and improper disposal of garbage damage the environment.

Prevention

Plant trees, reduce plastic use, segregate waste and dispose of harmful materials safely.

Conclusion

Everyone must work together to reduce pollution and protect the environment.

2. Apply Title and Heading styles.

3. Choose Insert → Image and insert a suitable environmental-pollution picture.

4. Resize the image using a corner handle.

5. Use the image crop controls to remove unnecessary portions.

6. Right-click the image and choose Wrap → Parallel or another appropriate wrapping option.

7. Position the picture beside the text.

8. Save as Environmental_Pollution.odt.

Result: A formatted document contains a cropped, resized image with suitable text wrapping.

C. Goal Seek – Marks Required for 80%

Step 1: Prepare the marksheet

Enter the following in LibreOffice Calc.

Student Name	English	Maths	Science	Social Science	Computer
Amit	70	65	72	68	75
Riya	80	70	78	75	82
Rahul	60	55	65	62	70
Sneha	85	80	88	82	90
Neha	72	68	70	74	76

Assume the five subject marks are in columns B:F.

In G2, enter:

=SUM(B2:F2)

In H2, enter:

=G2/500*100

Copy the formulas down to row 6.

Step 2: Apply Goal Seek

Find the marks required in Maths for Amit to obtain 80%.

1. Select cell H2.

2. Choose Tools → Goal Seek.

3. Enter:

   • Formula cell: $H$2

   • Target value: 80

   • Variable cell: $C$2

4. Click OK.

Calculation:

• Total marks needed = 80% of 500 = 400.

• Marks in the other four subjects = 70 + 72 + 68 + 75 = 285.

• Required Maths marks = 400 − 285 = 115 marks.

Important: Amit would need 115 marks in Maths, which is impossible if the maximum is 100. Goal Seek may still calculate this mathematical result, but the student cannot achieve 80% with the other marks unchanged.

If the practical requires a feasible result, use a different student's marks or lower the target percentage. For example, with Amit's other marks unchanged, a 75% target requires 90 marks in Maths.

Result: Goal Seek demonstrates how to find the required marks and reveals whether the target is achievable.

D. Macros – Sort Students by Marks

Procedure

1. Enter the data in Calc.

Student Name	Marks
Amit	65
Riya	90
Rahul	55
Sneha	85
Neha	72

2. Enable macro recording through Tools → Options → LibreOffice → Advanced, if available.

3. Select Tools → Macros → Record Macro.

4. Select the student table, including the headings.

5. Go to Data → Sort.

6. Select Marks as the sort key.

7. Select Descending order.

8. Click OK.

9. Stop recording and save the macro as SortStudents.

10. Run it from Tools → Macros → Organize Macros → Basic.

Expected output:

Student Name	Marks
Riya	90
Sneha	85
Neha	72
Amit	65
Rahul	55

Result: The macro sorts students from highest to lowest marks.

E. DBMS – SchoolDB with Date of Birth

Step 1: Create the database

1. Open LibreOffice Base.

2. Select Create a new database.

3. Finish the wizard.

4. Save the file as SchoolDB.odb.

Step 2: Create the Student table

Choose Tables → Create Table in Design View and enter:

Field name	Data type
Student_ID	Integer
Student_Name	Text (VARCHAR)
Class	Text (VARCHAR)
Division	Text (VARCHAR)
Date_of_Birth	Date
Contact_No	Text (VARCHAR)

Set Student_ID as the Primary Key and save the table as Student.

Step 3: Enter five records

Student_ID	Student_Name	Class	Division	Date_of_Birth	Contact_No
1	Amit Sharma	X	A	2009-01-15	9876543210
2	Riya Patil	X	B	2009-04-22	9876543211
3	Rahul Verma	X	A	2009-07-10	9876543212
4	Sneha Joshi	X	B	2009-09-05	9876543213
5	Neha Singh	X	A	2009-12-18	9876543214

Enter the dates using the date format accepted by your database, and save the records.

Result: SchoolDB contains a Student table with six fields, a primary key and five records.

Important practical examination tips

Writer

Apply Title, Heading 1 and Heading 2 styles correctly.

Save the document as an .odt file.

Insert and resize images using corner handles.

Generate the Table of Contents from heading styles.

Enable Track Changes before editing the document.

Calc

Use SUM and percentage formulas correctly.

Check the formula cell and variable cell before Goal Seek.

Include the heading row when sorting data.

Sort marks or salaries in the required order.

Save the spreadsheet as an .ods file.

Base

Create and save the correct database name.

Define the field names and data types.

Set the required Primary Key.

Enter five records without duplicate primary keys.

Save the table and database.

Useful keyboard shortcuts

Shortcut	Function
Ctrl + S	Save
Ctrl + Shift + S	Save As
F11	Open Styles
Ctrl + Z	Undo
Ctrl + C / Ctrl + V	Copy / Paste
Ctrl + A	Select all

Final advice: Practise each task directly in LibreOffice Writer, Calc and Base before the examination. Menu names can differ slightly between versions. For macros, make sure recording is enabled, and remember to save the macro before attempting to run it.

Tec_With_Amey · Learn • Practise • Create • Grow

Website: tecwithamey.online

Instagram: @tech_with_amey

Email: tecwithamey@gmail.com

Best wishes to all Class X students for their practical examination preparation!