Jindal Vidya Mandir, Vidyanagar
Class X – Information Technology(402)
Sample Questions for Practical Examination
LibreOffice Writer
Topics / Tasks:
1. Create a document on “Cyber Safety”.
o Apply Title, Heading 1 and Heading 2 styles
o Use a readable paragraph style
o Insert one relevant image with caption
o Add Header (School Name) and Footer (Page Number)
o Save the document as a template
o Write the steps you followed to complete this task
2. Prepare a report on “Importance of Internet”.
o Create and apply a custom paragraph style
o Insert and properly align an image
o Save the document as a template
o Write the steps you followed to complete this task
3. Create a document on “Green Energy”.
o Use Heading styles
o Insert image with caption
o Add Header and Footer
o Write the steps you followed to complete this task
4. Prepare a brochure on “Digital Payments”.
o Use styles properly
o Insert an image
o Save as template
o Write the steps you followed to complete this task
5. Write an article on “Online Education”.
o Custom paragraph style
o Image with caption
o Header and Footer
o Write the steps you followed to complete this task
6. Prepare a document on “Artificial Intelligence”.
o Apply styles correctly
o Insert centered image
o Save as template
o Write the steps you followed to complete this task
7. Prepare a report on “E-Governance”.
o Use Title and Heading styles
o Insert image with caption
o Write the steps you followed to complete this task
8. Prepare a document on “Social Media Awareness”.
o Custom paragraph style
o Header and Footer
o Save as template
o Write the steps you followed to complete this task
9. Prepare a project report on “Smart Cities”.
o Use styles
o Insert image
o Header and Footer
o Write the steps you followed to complete this task
10. Prepare an article on “Data Security”.
o Apply styles
o Insert image with caption
o Save as template
o Write the steps you followed to complete this task
LibreOffice Calc
Topics / Tasks:
1. Create a sales worksheet:
o Enter sales data with at least 10 records
o Apply Subtotals department-wise
o Use Goal Seek to calculate required sales amount for a given profit
o Write the steps you followed to complete this task
2. Create student marks data:
o Apply Subtotals class-wise
o Use Data Consolidation from two worksheets
o Write the steps you followed to complete this task
3. Create monthly expense sheets:
o Use Data Consolidation
o Apply Goal Seek to achieve a savings target
o Write the steps you followed to complete this task
4. Create sales data:
o Apply Subtotals region-wise
o Use Goal Seek to calculate selling price
o Write the steps you followed to complete this task
5. Create product sales sheets:
o Apply Data Consolidation
o Use Subtotals category-wise
o Write the steps you followed to complete this task
6. Create employee salary data:
o Apply Subtotals department-wise
o Use Goal Seek to calculate net salary
o Write the steps you followed to complete this task
7. Create marks sheets:
o Apply Subtotals subject-wise
o Consolidate term-wise marks
o Write the steps you followed to complete this task
8. Create sales records:
o Apply Subtotals city-wise
o Use Goal Seek to find target revenue
o Write the steps you followed to complete this task