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 |
Register for free to see more content