PDF chapter test TRY NOW
Methodical recommendation:
Theory
| Number | Name | Description |
|---|---|---|
| Number 1. | Name Introduction to LibreOffice | Description Describes the basics of LibreOffice |
| Number 2. | Name System requirements and downloading of the main program - LibreOffice | Description Explains the system requirements and step-by-step procedure to download the LibreOffice main program. |
| Number 3. | Name LibreOffice - Installation Procedure` | Description Explains the step-by-step procedure to install the LibreOffice. |
| Number 4. | Name Starting the LibreOffice Calc | Description Describes how to start the LibreOffice Calc. |
| Number 5. | Name Functiion keys in LibreOffice | Description Provides the information about the function keys in LibreOffice. |
| Number 6. | Name Introduction to LibreOffice Calc | Description Explains the basics of spreadsheet. |
| Number 7. | Name LibreOffice Calc Main window | Description Describes the parts of the LibreOffice Calc Main window. |
| Number 8. | Name Applications and advantages of Spreadsheets | Description Explains the different applications and advantages of Spreadsheets / Worksheets. |
| Number 9. | Name Worksheet and workbook | Description Describes the Worksheet amd Workbook in LibreOffice Calc. |
| Number 10. | Name Shortcut keys in LibreOffice Calc | Description Depicts the shortcut keys in LibreOffice Calc. |
| Number 11. | Name Creating a new workbook in LibreOffice Calc | Description Explains the steps to create a new workbook in LibreOffice Calc. |
| Number 12. | Name Opening and Closing a worksheet | Description Explains the steps to open the existing worksheet and closing a worksheet. |
| Number 13. | Name Saving the created worksheet | Description Explains the steps to Save the created worksheet. |
| Number 14. | Name Entering the contents in a worksheet | Description Explains the steps to enter the content in the LibreOffice Calc Spreadsheet. |
| Number 15. | Name Formatting Shortcut keys in LibreOffice Calc | Description Depicts the formatting shortcut keys in LibreOffice Calc. |
| Number 16. | Name Merge Cells | Description Describes how to merge the cells in LibreOffice Calc. |
| Number 17. | Name Generate auto numbers | Description Explains the steps to generate the auto numbers in LibreOffice Calc. |
| Number 18. | Name Functions in LibreOffice Calc | Description Explains the functions in LibreOffice Calc. |
| Number 19. | Name Inserting statistical functions - Part I | Description Explains the procedure to insert a statistical function in LibreOffice Calc. |
| Number 20. | Name Inserting statistical functions - Part II | Description Explains the procedure to insert a statistical function in LibreOffice Calc. |
| Number 21. | Name Arithmetic Operators in LibreOffice Calc | Description Describes the arithmetic operators in LibreOffice Calc. |
| Number 22. | Name Relational Operators in LibreOffice Calc | Description Describes the relational operators in LibreOffice Calc. |
| Number 23. | Name Logical operators in LibreOffice Calc | Description Expalins the logical operators used in LibreOffice Calc. |
| Number 24. | Name Example to understand the functions and operators | Description Demonstrates the usage of functions and operators in LibreOffice Calc. |
| Number 25. | Name Sorting in LibreOffice Calc | Description Explains the sorting in LibreOffice Calc. |
| Number 26. | Name Insert a Chart in LibreOffice Calc | Description Explains the procedure to insert a chart in LibreOffice Calc. |
Practice Questions
| Number | Name | Type | Difficulty | Marks | Description |
|---|---|---|---|---|---|
| Number 1. | Name Pick out the odd one - LibreOffice application | Type 1st type - receptive | Difficulty easy | Marks 2 m. | Description Test the ability to identify the LibreOffice applications. |
| Number 2. | Name Exercise on worksheet in LibreOffice Calc | Type 1st type - receptive | Difficulty medium | Marks 2 m. | Description Practice a exercise to recall the basics of worksheet in LibreOffice Calc. |
| Number 3. | Name Exercise on basics of operator | Type 1st type - receptive | Difficulty medium | Marks 2 m. | Description Recall the basics of operators used in LibreOffice Calc. |
| Number 4. | Name Exercise on function keys in LibreOffice Impress | Type 2nd type - interpretation | Difficulty medium | Marks 2 m. | Description Practice a exercise to understands the function keys in LibreOffice Impress. |
| Number 5. | Name Exercise on introduction to LibreOffice | Type 2nd type - interpretation | Difficulty medium | Marks 2 m. | Description Exercise to understand the basics of LibreOffice. |
| Number 6. | Name Exercise on basics of LibreOffice Calc | Type 2nd type - interpretation | Difficulty medium | Marks 2 m. | Description Practice a exercise to understand basics of LibreOffice Calc. |
| Number 7. | Name Match the formatting shortcut keys and their effects in LibreOffice Calc | Type 2nd type - interpretation | Difficulty medium | Marks 6 m. | Description Exercise to recall the formatting shortcut keys in LibreOffice Calc. |
| Number 8. | Name Exercise on shortcut keys in LibreOffice Calc | Type 2nd type - interpretation | Difficulty medium | Marks 2 m. | Description Practice a exercise to understand the shortcut keys in LibreOffice Calc. |
| Number 9. | Name Match the shortcut keys and their effects in LibreOffice Calc | Type 2nd type - interpretation | Difficulty medium | Marks 6 m. | Description Exercise to recall the shortcut keys in LibreOffice Calc. |
| Number 10. | Name Match the types of operators in LibreOffice Calc | Type 2nd type - interpretation | Difficulty medium | Marks 6 m. | Description Exercise to recall the shortcut keys in LibreOffice Calc. |
| Number 11. | Name Fill in the blanks with appropriate answer | Type 2nd type - interpretation | Difficulty medium | Marks 4 m. | Description Exercise to understand the different tools in LibreOffice Calc. |
| Number 12. | Name Match the functions with their result | Type 3rd type - analysis | Difficulty medium | Marks 6 m. | Description Practice a exercise to recall the different functions used in LibreOffice Calc. |
Questions for Teacher Use
| Number | Name | Type | Difficulty | Marks | Description |
|---|---|---|---|---|---|
| Number 1. | Name Exercise on insert a chart in LibreOffice Calc Spreadsheet | Type Other | Difficulty medium | Marks 8 m. | Description Activity to understand how to insert a chart in LibreOffice Calc Spreadsheet. |
| Number 2. | Name Exercise on LibreOffice Impress Installation. | Type Other | Difficulty medium | Marks 6 m. | Description Activity to understand the procedure to install the LibreOffice Impress. |
| Number 3. | Name Exercise on opening and closing a LibreOffice Calc Spreadsheet | Type Other | Difficulty medium | Marks 6 m. | Description Activity to understand opening and closing a LibreOffice Calc Spreadsheet. |
| Number 4. | Name Exercise on functions and operators in LibreOffice Calc Spreadsheet | Type Other | Difficulty hard | Marks 10 m. | Description Activity to understand functions and operators in LibreOffice Calc Spreadsheet. |
| Number 5. | Name Activity to understand merging the cells in LibreOffice Calc | Type Other | Difficulty hard | Marks 8 m. | Description Describes how to merge the cells in LibreOffice Calc. |
| Number 6. | Name Exercise on sorting in LibreOffice Calc Spreadsheet | Type Other | Difficulty hard | Marks 10 m. | Description Activity to understand the sorting in LibreOffice Calc Spreadsheet. |
| Number 7. | Name The functions in LibreOffice Calc | Type Other | Difficulty medium | Marks 1 m. | Description Practice a exercise to solve the book back very short answer questions. |
| Number 8. | Name Relational operator | Type Other | Difficulty medium | Marks 1 m. | Description Practice a exercise to solve the book back very short answer questions. |
Tests
| Number | Name | Recomended time: | Difficulty | Marks | Description |
|---|---|---|---|---|---|
| Number 1. | Name Training test 1 | Recomended time: 00:25:00 | Difficulty medium | Marks 6 m. | Description |
| Number 2. | Name Training test 2 | Recomended time: 00:25:00 | Difficulty medium | Marks 6 m. | Description |
Periodic assessments
| Number | Name | Recomended time: | Difficulty | Marks | Description |
|---|---|---|---|---|---|
| Number 1. | Name Homework 1 | Recomended time: 00:30:00 | Difficulty medium | Marks 12 m. | Description |
| Number 2. | Name Homework 2 | Recomended time: 00:30:00 | Difficulty medium | Marks 12 m. | Description |
| Number 3. | Name Homework 3 | Recomended time: 00:30:00 | Difficulty hard | Marks 16 m. | Description |
| Number 4. | Name Progress test 1 | Recomended time: 00:40:00 | Difficulty hard | Marks 24 m. | Description |
| Number 5. | Name Progress test 2 | Recomended time: 00:40:00 | Difficulty hard | Marks 18 m. | Description |
| Number 6. | Name Periodic Assessment - 3 | Recomended time: 00:10:00 | Difficulty medium | Marks 4 m. | Description PA 3 |
Register for free to see more content