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
   315   316   317   318   319   320   321   322   323   324   325