CLASS – X Information Technology (Code 402) Practical File Assignment Instructions: 1. Front page should be as per given format. 2. Index should be properly maintained with S.No., Content, Page No. and Teacher’s Sign. 3. Each page should be given a page number. 4. Screenshots are required in all the questions. 5. Pasting of screenshots to be done neatly. 6. File should be covered with laminated brown paper.
Q1. List the types of Styles in Libre Office Writer. Apply the following style to your answer in Libre Office Writer: Headings: Font name: Times New Roman, Size: 24, Colour: Red. Give the style name: MyHeading. Paragraph: Apply Style Text Body from the Style Gallery.
Q2. Draw the given flow chart using Drawing tools of Writer.
Q3. Create a document in writer and do as given below:
1. Prepare a template for the leave application writing format. 2. Apply formatting as required. 3. Set this template as a default template. 4. Change the default template to custom template. Change the formatting as you wish. Q4. Rajnikant has created a detailed report on Education in India using the LibreOffice Writer tool. He has styled the document well by inserting proper paragraph and section headings. His colleague Murugan advised him to insert a Table of Contents that will give a complete glimpse of his report. Help Rajnikant to insert a ToC with a green background.
Q5. Venkat has created a document on India’s Trade Review. He wants two of his friends, Rinky and Sujoy to review his document and if required, add comments to it. But none of them know how to use the Track Changes feature of Writer. Help them to complete the task. Venkat has received the reviewed file with modifications and comments. What steps will he follow now to accept or reject the changes done by his friends.
Q6. Raman has two branches of his shop namely ABC and XYZ. He has the Sales records for the month of January and February of both the branches in two different sheets named ABC_Branch and XYZ_Branch. Now he has to consolidate these two sheets to get the sum of both the sheets monthly to get the insight about the sale as per product and branch. Help him in designing a consolidated sheet “Sales”.
Q7. Prepare the below given worksheet, that store marks in various subjects by students of Class X. Using subtotal tool take out the averages scored in all the subjects Section-wise.
Q8. Create Scenarios of different banks and Calculate the EMI and Total Interest paid for different loan amount (Principal) taken for a fixed Rate of Interest for a number of time period. Q9. A student has received below given marks in 4 subjects. He has to appear for the 5th subject “Social Science” and plans an aggregate as 70. Use goal seek tool to check how many marks he has to score in the 5th subject to get the required percentage.
Q10. Record a macro named “Custom_Format” to apply the following style to the Heading “Data Analysis” in the cell A1. • The font style should be “Times New Roman” • The font size should be “14” • The font colour should be “Blue” • Cells from A1 to G1 should be merged and centred
Q11. Ananthu wants to create a directory containing data – Serial No, Name, Mobile Number, Email id, Date of birth of his friends. Create a table using LibreOffice Base. Make Serial No as primary key. Enter minimum 5 records in the table. Sort the table in alphabetical order of name.
Q12. Prakasan lives in Happy Home Society. Create the following tables in his database so as to store and manage the maintenance dues received from flat owners of the society.
Q13. Create a query to display the following information
Flat No Owner Receipt Number Date Amount
Q14. Create a form for data entry of Resident Details and Maintenance Dues table.
Q15. Create a report based on the query created above.
