Page 320 - IT_V1.0_Class10
P. 320
Project Work
Hints for Part D
PROJECT-1 21 st
Century #Technology Literacy
Skills
Follow the given instructions to complete the project in LibreOffice Writer:
Open LibreOffice Writer and create a new document.
Write a short report or use an existing document that contains multiple headings and subheadings. Ensure
that the headings are formatted using the predefined heading styles (e.g., Heading 1, Heading 2, Heading 3).
Insert the Table of Contents (TOC) at the beginning of the document.
Customise the structure and formatting of your TOC.
Update the TOC as needed to reflect document changes.
21 st #Critical Thinking
PROJECT-2 Century #Technology Literacy
Skills
Follow the given instructions to complete the project in LibreOffice Calc:
Sunil is preparing for his Math exam and uses a spreadsheet to track his progress. He has set a goal to
achieve an average score of at least 85 across all his math tests. So far, he has taken four tests and his scores
are 78, 82, 88, and 91.
Sunil has one more test remaining and wants to know the minimum score he needs on this test to achieve
his goal of an average score of 85.
Sunil is working on a project where he needs to manage a budget for a school event. He has a total budget
of ₹10,000 and needs to allocate this budget across three categories: Food, Decorations, and Entertainment.
Sunil has set some constraints for his allocations:
o The budget for Food should be at least ₹3,000.
o The budget for Decorations should be at least ₹2,000.
o The budget for Entertainment should be at least ₹1,500.
He also wants to maximise the amount of money allocated to Entertainment after meeting the minimum
requirements for Food and Decorations.
Using Solver in a spreadsheet application, determine the optimal allocation of the budget that maximises
the amount for Entertainment while meeting all the constraints.
21 st
PROJECT-3 Century #Creativity
Skills
Follow the given instruction to complete the project in LibreOffice Calc: 10
Create a Macro that performs 'Paste Special' with Add and Subtract. 8
Create your own Macro function to return the number 10. 15
Create a Macro to sort the following data: 10, 8, 15, 6. 6
318 Information Technology Play (Ver 1.0)-X

