Practice_Set_II_X_IT_2026

 

Class X – Computer Applications Practical Examination

SET 11 to SET 20

These 10 additional sets are designed for Class 10 practical examinations using LibreOffice Writer, Calc and Base. Each set contains five practical tasks, following the format of your previous sets.

SET 11 – Computer Applications

A. Styles

Create a document on “Importance of Reading Books”. Apply Title, Heading 1 and Heading 2 styles. Modify the Heading 1 style and create a custom paragraph style named “Highlights”.

B. Working with Images

Create a document on “Plant More Trees”. Insert two suitable images, resize and crop them, position one image on the left and the other on the right, and apply appropriate text wrapping.

C. Goal Seek

Create a marksheet for five subjects: English, Mathematics, Science, Social Science and Information Technology. Calculate Total and Percentage. Use Goal Seek to find the marks required in Social Science to achieve 80% overall.

D. Macros

Create a spreadsheet containing ten student names and their total marks. Record a macro to sort students by total marks in descending order and execute the macro.

E. DBMS & LibreOffice Base

Create a database named SchoolDB and a table named ClassDetails with the following fields:

  • Class_ID

  • Class_Name

  • Class_Teacher

  • Total_Students

  • Room_No

Set Class_ID as the Primary Key and enter five records.

SET 12 – Computer Applications

A. Styles

Create a document on “Digital Learning”. Apply Title and Heading styles. Create a custom style named “ImportantText” and apply it to three paragraphs.

B. Advanced Writer

Create a report on “Importance of Physical Fitness” with at least four headings. Apply suitable heading styles and insert an automatic Table of Contents.

C. Goal Seek

Create a sales spreadsheet containing Product_Name, Quantity, Selling_Price and Total_Sales. Calculate Total Sales using formulas. Use Goal Seek to determine the quantity required to achieve total sales of ₹12,000.

D. Macros

Create a spreadsheet containing ten employees and their salaries. Record a macro to sort the salaries from lowest to highest and run the macro.

E. LibreOffice Base

Create a database named LibraryDB and a table named BookIssue with the following fields:

  • Issue_ID

  • Book_ID

  • Member_Name

  • Issue_Date

  • Return_Date

Set Issue_ID as the Primary Key and enter five records.

SET 13 – Computer Applications

A. Working with Images

Create a document on “Save Electricity”. Insert an appropriate image, resize and crop it, position it beside the text and apply suitable text wrapping.

B. Advanced Writer

Create a report on “Independence Day Celebration”. Apply heading styles, insert an image, create an automatic Table of Contents and enable Track Changes. Make at least two changes.

C. Goal Seek

Prepare a marksheet for five subjects. Calculate Total and Percentage. Use Goal Seek to determine the marks required in English to achieve 85% overall.

D. Macros

Create a spreadsheet containing ten product names and their prices. Record a macro to sort the products by price in descending order and execute it.

E. DBMS & LibreOffice Base

Create a database named HospitalDB and a table named PatientDetails with the following fields:

  • Patient_ID

  • Patient_Name

  • Age

  • Gender

  • Admission_Date

  • Contact_No

Set Patient_ID as the Primary Key and enter five records.

SET 14 – Computer Applications

A. Styles

Create a document on “Artificial Intelligence in Daily Life”. Apply Title, Heading 1 and Heading 2 styles. Modify Heading 1 and create a custom style named “TopicHighlight”.

B. Working with Images

Create a document on “Importance of Water”. Insert two images, resize and crop them, position them appropriately and apply suitable text-wrapping options.

C. Goal Seek

Create a spreadsheet containing Product, Cost Price, Selling Price and Quantity. Calculate Total Cost, Total Sales and Profit using formulas. Use Goal Seek to find the selling price required to earn a profit of ₹8,000.

D. Macros

Create a spreadsheet containing ten students and their percentages. Record a macro to sort the students by percentage in descending order and run it.

E. LibreOffice Base

Create a database named EmployeeDB and a table named Department with the following fields:

  • Department_ID

  • Department_Name

  • Department_Head

  • Number_of_Employees

  • Location

Set Department_ID as the Primary Key and enter five records.

SET 15 – Computer Applications

A. Writer – Styles and Track Changes

Create a document titled “Advantages of Online Education”. Apply suitable title and heading styles, create a Table of Contents, enable Track Changes and make two edits.

B. Working with Images

Create a document on “Road Safety Rules”. Insert a suitable image, resize and crop it, position it beside the text and apply appropriate text wrapping.

C. Goal Seek

Create a marksheet for five subjects. Calculate Total and Percentage. Use Goal Seek to determine the marks required in Mathematics to achieve 75% overall.

D. Macros

Create a spreadsheet containing ten products, their quantities and total sales. Record a macro to sort products by quantity in ascending order and execute it.

E. DBMS & LibreOffice Base

Create a database named SchoolDB and a table named StudentFees with the following fields:

  • Receipt_ID

  • Student_ID

  • Student_Name

  • Fees_Paid

  • Payment_Date

Set Receipt_ID as the Primary Key and enter five records.

SET 16 – Computer Applications

A. Styles

Create a document on “Women Empowerment”. Apply Title, Heading 1 and Heading 2 styles. Modify the Title style and create a custom style named “KeyInformation”.

B. Advanced Writer

Create a report on “Environmental Protection” with at least five headings. Apply heading styles and insert an automatic Table of Contents.

C. Goal Seek

Prepare a sales spreadsheet with Product_Name, Quantity, Cost_Price and Selling_Price. Calculate the total profit using formulas. Use Goal Seek to find the quantity required to earn a profit of ₹6,000.

D. Macros

Create a spreadsheet containing ten employee names, departments and salaries. Record a macro to sort employees alphabetically by name and run it.

E. LibreOffice Base

Create a database named TransportDB and a table named Vehicle with the following fields:

  • Vehicle_ID

  • Vehicle_Type

  • Registration_No

  • Driver_Name

  • Capacity

Set Vehicle_ID as the Primary Key and enter five records.

SET 17 – Computer Applications

A. Working with Images

Create a document on “Healthy Food Habits”. Insert two relevant images, resize and crop them, position them on opposite sides of the text and apply suitable text wrapping.

B. Advanced Writer

Create a report on “School Annual Function”. Apply heading styles, insert an image, generate a Table of Contents and enable Track Changes. Record at least two changes.

C. Goal Seek

Create a marksheet for five subjects with a maximum of 100 marks per subject. Calculate Total and Percentage. Use Goal Seek to find the marks required in Information Technology to achieve 90% overall.

D. Macros

Create a spreadsheet containing ten products with their names, quantities and prices. Record a macro to sort products by price in ascending order and execute it.

E. DBMS & LibreOffice Base

Create a database named SportsDB and a table named Player with the following fields:

  • Player_ID

  • Player_Name

  • Sport

  • Age

  • Team_Name

Set Player_ID as the Primary Key and enter five records.

SET 18 – Computer Applications

A. Styles

Create a document on “The Importance of Time Management”. Apply Title, Heading 1 and Heading 2 styles. Create a custom style named “Tips” and apply it to three important points.

B. Working with Images

Create a document on “Clean India Mission”. Insert a suitable image, crop and resize it, position it beside the text and apply suitable text wrapping.

C. Goal Seek

Create a sales spreadsheet containing Product, Quantity, Selling Price and Total Sales. Calculate Total Sales using formulas. Use Goal Seek to find the selling price required to achieve total sales of ₹20,000 for a fixed quantity.

D. Macros

Create a spreadsheet containing ten student names and their percentages. Record a macro to sort students by percentage in ascending order and execute it.

E. LibreOffice Base

Create a database named HotelDB and a table named RoomBooking with the following fields:

  • Booking_ID

  • Guest_Name

  • Room_No

  • Check_In_Date

  • Check_Out_Date

Set Booking_ID as the Primary Key and enter five records.

SET 19 – Computer Applications

A. Styles

Create a document on “Benefits of Yoga and Meditation”. Apply Title, Heading 1 and Heading 2 styles. Modify Heading 1 and create a custom style named “SpecialNote”.

B. Advanced Writer

Create a report on “Science Exhibition at School” with at least four headings. Apply heading styles, insert two images, create a Table of Contents and enable Track Changes.

C. Goal Seek

Create a marksheet for five subjects. Calculate Total, Percentage and Result using formulas. Use Goal Seek to determine the marks required in English to obtain 80% overall.

D. Macros

Create a spreadsheet containing ten employees with their names and monthly salaries. Record a macro to sort employees by salary in descending order and run it.

E. DBMS & LibreOffice Base

Create a database named ShopDB and a table named Product with the following fields:

  • Product_ID

  • Product_Name

  • Category

  • Price

  • Stock_Quantity

Set Product_ID as the Primary Key and enter five records.

SET 20 – Computer Applications

A. Writer – Styles and Track Changes

Create a document titled “Role of Computers in Modern Society”. Apply Title, Heading 1 and Heading 2 styles, modify a heading style, insert an automatic Table of Contents and enable Track Changes. Make at least two changes.

B. Working with Images

Create a document on “Global Warming”. Insert two suitable images, resize and crop them, position them appropriately and apply text-wrapping options.

C. Goal Seek

Create a marksheet for five subjects: English, Mathematics, Science, Social Science and Information Technology. Calculate Total and Percentage. Use Goal Seek to determine the marks required in Mathematics to achieve 85% overall.

D. Macros

Create a spreadsheet containing ten products with their names, prices and quantities. Record a macro to sort products by total value, calculated as Price × Quantity, in descending order and execute it.

E. DBMS & LibreOffice Base

Create a database named SchoolDB and a table named Examination with the following fields:

  • Exam_ID

  • Student_ID

  • Subject

  • Marks_Obtained

  • Exam_Date

Set Exam_ID as the Primary Key and enter five records. Demonstrate adding one new record and editing an existing record.

Comments

Post a Comment

Popular posts from this blog

Class X Computer Applications – Practical Answers

  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 Open LibreOffice Writer. 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. Select Importance of Education. Open the Styles menu and apply Title. Select Introduction, Benefits of Education and Conclusion, and apply Heading 1. Select Knowledge and ...
Read more

HTML and CSS Practical Examination_Questions_Powered_by_Tec_with_Amey

Image
  HTML and CSS Practical Examination Subject: Computer / Information Technology Total Marks: 10 per set Software: Notepad / Notepad++ Instructions: Write HTML and CSS code, save the file with the .html extension, and open it in a web browser. Use internal CSS with the <style> tag inside the <head> section. Set 1 – Introduction to HTML and CSS Create a webpage titled “My Introduction”. Display your name as a heading and write five sentences about yourself. Use CSS to set a light blue background, change the heading colour to dark blue, and centre-align the heading. Set 2 – Text Formatting Create a webpage titled “My School” with a heading and a paragraph about your school. Use CSS to change the font family, font size and text colour. Make the heading bold and underlined. Set 3 – Background Colours Create a webpage titled “Save Environment” with a heading and a paragraph about protecting trees. Use CSS to set a light green background, a green heading and a dark green pa...
Read more