PDF chapter test TRY NOW

Methodical recommendation:

Theory

Number Name Description
1. Introduction to LibreOffice Describes the basics of LibreOffice
2. System requirements and downloading of the main program - LibreOffice Explains the system requirements and step-by-step procedure to download the LibreOffice main program.
3. LibreOffice - Installation Procedure` Explains the step-by-step procedure to install the LibreOffice.
4. Starting the LibreOffice Calc Describes how to start the LibreOffice Calc.
5. Functiion keys in LibreOffice Provides the information about the function keys in LibreOffice.
6. Introduction to LibreOffice Calc Explains the basics of spreadsheet.
7. LibreOffice Calc Main window Describes the parts of the LibreOffice Calc Main window.
8. Applications and advantages of Spreadsheets Explains the different applications and advantages of Spreadsheets / Worksheets.
9. Worksheet and workbook Describes the Worksheet amd Workbook in LibreOffice Calc.
10. Shortcut keys in LibreOffice Calc Depicts the shortcut keys in LibreOffice Calc.
11. Creating a new workbook in LibreOffice Calc Explains the steps to create a new workbook in LibreOffice Calc.
12. Opening and Closing a worksheet Explains the steps to open the existing worksheet and closing a worksheet.
13. Saving the created worksheet Explains the steps to Save the created worksheet.
14. Entering the contents in a worksheet Explains the steps to enter the content in the LibreOffice Calc Spreadsheet.
15. Formatting Shortcut keys in LibreOffice Calc Depicts the formatting shortcut keys in LibreOffice Calc.
16. Merge Cells Describes how to merge the cells in LibreOffice Calc.
17. Generate auto numbers Explains the steps to generate the auto numbers in LibreOffice Calc.
18. Functions in LibreOffice Calc Explains the functions in LibreOffice Calc.
19. Inserting statistical functions - Part I Explains the procedure to insert a statistical function in LibreOffice Calc.
20. Inserting statistical functions - Part II Explains the procedure to insert a statistical function in LibreOffice Calc.
21. Arithmetic Operators in LibreOffice Calc Describes the arithmetic operators in LibreOffice Calc.
22. Relational Operators in LibreOffice Calc Describes the relational operators in LibreOffice Calc.
23. Logical operators in LibreOffice Calc Expalins the logical operators used in LibreOffice Calc.
24. Example to understand the functions and operators Demonstrates the usage of functions and operators in LibreOffice Calc.
25. Sorting in LibreOffice Calc Explains the sorting in LibreOffice Calc.
26. Insert a Chart in LibreOffice Calc Explains the procedure to insert a chart in LibreOffice Calc.

Practice Questions

Number Name Type Difficulty Marks Description
1. Pick out the odd one - LibreOffice application 1st type - receptive easy 2 m. Test the ability to identify the LibreOffice applications.
2. Exercise on worksheet in LibreOffice Calc 1st type - receptive medium 2 m. Practice a exercise to recall the basics of worksheet in LibreOffice Calc.
3. Exercise on basics of operator 1st type - receptive medium 2 m. Recall the basics of operators used in LibreOffice Calc.
4. Exercise on function keys in LibreOffice Impress 2nd type - interpretation medium 2 m. Practice a exercise to understands the function keys in LibreOffice Impress.
5. Exercise on introduction to LibreOffice 2nd type - interpretation medium 2 m. Exercise to understand the basics of LibreOffice.
6. Exercise on basics of LibreOffice Calc 2nd type - interpretation medium 2 m. Practice a exercise to understand basics of LibreOffice Calc.
7. Match the formatting shortcut keys and their effects in LibreOffice Calc 2nd type - interpretation medium 6 m. Exercise to recall the formatting shortcut keys in LibreOffice Calc.
8. Exercise on shortcut keys in LibreOffice Calc 2nd type - interpretation medium 2 m. Practice a exercise to understand the shortcut keys in LibreOffice Calc.
9. Match the shortcut keys and their effects in LibreOffice Calc 2nd type - interpretation medium 6 m. Exercise to recall the shortcut keys in LibreOffice Calc.
10. Match the types of operators in LibreOffice Calc 2nd type - interpretation medium 6 m. Exercise to recall the shortcut keys in LibreOffice Calc.
11. Fill in the blanks with appropriate answer 2nd type - interpretation medium 4 m. Exercise to understand the different tools in LibreOffice Calc.
12. Match the functions with their result 3rd type - analysis medium 6 m. Practice a exercise to recall the different functions used in LibreOffice Calc.

Questions for Teacher Use

Number Name Type Difficulty Marks Description
1. Exercise on insert a chart in LibreOffice Calc Spreadsheet Other medium 8 m. Activity to understand how to insert a chart in LibreOffice Calc Spreadsheet.
2. Exercise on LibreOffice Impress Installation. Other medium 6 m. Activity to understand the procedure to install the LibreOffice Impress.
3. Exercise on opening and closing a LibreOffice Calc Spreadsheet Other medium 6 m. Activity to understand opening and closing a LibreOffice Calc Spreadsheet.
4. Exercise on functions and operators in LibreOffice Calc Spreadsheet Other hard 10 m. Activity to understand functions and operators in LibreOffice Calc Spreadsheet.
5. Activity to understand merging the cells in LibreOffice Calc Other hard 8 m. Describes how to merge the cells in LibreOffice Calc.
6. Exercise on sorting in LibreOffice Calc Spreadsheet Other hard 10 m. Activity to understand the sorting in LibreOffice Calc Spreadsheet.
7. The functions in LibreOffice Calc Other medium 1 m. Practice a exercise to solve the book back very short answer questions.
8. Relational operator Other medium 1 m. Practice a exercise to solve the book back very short answer questions.

Tests

Number Name Recomended time: Difficulty Marks Description
1. Training test 1 00:25:00 medium 6 m.
2. Training test 2 00:25:00 medium 6 m.

Periodic assessments

Number Name Recomended time: Difficulty Marks Description
1. Homework 1 00:30:00 medium 12 m.
2. Homework 2 00:30:00 medium 12 m.
3. Homework 3 00:30:00 hard 16 m.
4. Progress test 1 00:40:00 hard 24 m.
5. Progress test 2 00:40:00 hard 18 m.
6. Periodic Assessment - 3 00:10:00 medium 4 m. PA 3