Introduction to spreadsheets - LibreOffice Calc. Science State Board, Class 8: lessons, tests, tasks.

1.	Introduction to LibreOffice
2.	System requirements and downloading of the main program - LibreOffice
3.	LibreOffice - Installation Procedure`
4.	Starting the LibreOffice Calc
5.	Functiion keys in LibreOffice
6.	Introduction to LibreOffice Calc
7.	LibreOffice Calc Main window
8.	Applications and advantages of Spreadsheets
9.	Worksheet and workbook
10.	Shortcut keys in LibreOffice Calc
11.	Creating a new workbook in LibreOffice Calc
12.	Opening and Closing a worksheet
13.	Saving the created worksheet
14.	Entering the contents in a worksheet
15.	Formatting Shortcut keys in LibreOffice Calc
16.	Merge Cells
17.	Generate auto numbers
18.	Functions in LibreOffice Calc
19.	Inserting statistical functions - Part I
20.	Inserting statistical functions - Part II
21.	Arithmetic Operators in LibreOffice Calc
22.	Relational Operators in LibreOffice Calc
23.	Logical operators in LibreOffice Calc
24.	Example to understand the functions and operators
25.	Sorting in LibreOffice Calc
26.	Insert a Chart in LibreOffice Calc

1.	Pick out the odd one - LibreOffice application Difficulty: easy	2
2.	Exercise on worksheet in LibreOffice Calc Difficulty: medium	2
3.	Exercise on basics of operator Difficulty: medium	2
4.	Exercise on function keys in LibreOffice Impress Difficulty: medium	2
5.	Exercise on introduction to LibreOffice Difficulty: medium	2
6.	Exercise on basics of LibreOffice Calc Difficulty: medium	2
7.	Match the formatting shortcut keys and their effects in LibreOffice Calc Difficulty: medium	6
8.	Exercise on shortcut keys in LibreOffice Calc Difficulty: medium	2
9.	Match the shortcut keys and their effects in LibreOffice Calc Difficulty: medium	6
10.	Match the types of operators in LibreOffice Calc Difficulty: medium	6
11.	Fill in the blanks with appropriate answer Difficulty: medium	4
12.	Match the functions with their result Difficulty: medium	6

1.	Training test 1 Difficulty: medium	6
2.	Training test 2 Difficulty: medium	6

1.

Methodical recommendation

Introduction to spreadsheets - LibreOffice Calc