Kerala Syllabus Class 7 Information and Communications Technology (ICT): Chapter 01 Information Analysis - Questions and Answers

Study Notes for Class 7th Information and Communications Technology (ICT) - വിവരവിശകലനം | Text Books Solution ICT (English Medium) Chapter 1 Information Analysis. ഈ യൂണിറ്റിന്റെ Teachers Handbook ലിങ്ക് ഈ പേജിന്റെ അവസാന ഭാഗത്തു നൽകിയിട്ടുണ്ട്. 
പഠന സഹായികൾ അയക്കാൻ താല്പര്യമുള്ളവർ ഈ നമ്പറിൽ വാട്സാപ്പ് ചെയ്യുക: 9497346250. പുതിയ അപ്‌ഡേറ്റുകൾക്കായി ഞങ്ങളുടെ Telegram Channel ൽ ജോയിൻ ചെയ്യുക.

ഈ ബ്ലോഗ് അഡ്‌മിൻറെ രേഖാമൂലമുള്ള അനുമതിയില്ലാതെ ഈ ബ്ലോഗിൽ നൽകിയിരിക്കുന്ന ചോദ്യോത്തരങ്ങൾ, ഇതേരീതിയിലോ പി.ഡി.എഫ് രൂപത്തിലോ, മറ്റേതെങ്കിലും ഡിജിറ്റലോ, പ്രിന്റഡ് ഉൾപ്പെടെയുള്ള ഏതെങ്കിലും രൂപങ്ങളിലേക്കോ മാറ്റി മറ്റൊരു വെബ്സൈറ്റിലോ, ബ്ലോഗിലോ, യുട്യൂബ്, സോഷ്യൽ മീഡിയാ ഗ്രൂപ്പുകളിലോ ഉൾപ്പെടെ ഒരിടത്തും പ്രചരിപ്പിക്കാൻ പാടില്ലാത്തതാകുന്നു.

Std 7: ICT Chapter 01: Information Analysis - Questions and Answers
♦ LibreOffice Calc
LibreOffice Calc is a Spreadsheet software. It is used for
• Tabulating data
• Arranging the tabulated data in different formats
• Enabling the analysis, comparison and consolidation of the data.
• Arranging the data in graphic forms (charts) to make analysis easier.

♦ To open LibreOffice Calc
To open LibreOffice Calc - Applications → Office → LibreOffice Calc
In the screen, we can see a worksheet of columns and rows.
Columns are labelled A, B, C … and rows 1, 2, 3 … The squares you fill in with data are called cells.

♦ Recording Data in Calc
• Collect data
• Click the mouse in the cell
• Type in data with the keyboard
• Name the file appropriately and save it.

♦ To Change the Size of Columns and Rows
Click on the point where the header of the column we want to change and the next column’s header joins. When the arrow marks appear, drag them to get the size we want. In the same way, we can change the size of the rows. 

♦ Finding the ‘Sum’ in the Cells
• Click in the cell where we want to display the sum.
• Click on the symbol ∑ to the left of the cell address.
• Press the Enter key to get the sum in the cell into which we typed.
• Save the file after those changes. 

♦ Sorting the Tables in the Calc Sheet
• Select the table to be sorted.
• Click on Data on the Menu bar and select Sort.
• Select the header of the column you want to sort to put it in Sort Key 1.
• Select Descending from Ascending/Descending options against Sort Key 1
• Press ‘OK’ 

♦ Graphs for Comparative Study.
To prepare a graph
• Select the portion for the graph
• Choose the chart option from the insert menu of the calc sheet.
• On the left of the window, we can see the Chart Type selected.
• Go to Choose a Chart Type; we can see Column selected. 
• Click the finish button

♦ Assessment
♦ The name of the spreadsheet software in LibreOffice
a. Writer                                       
b. Impress
c. Calc                                          
d. Calligra Sheets
Answer: c. Calc      

♦ What is the aim of Sort Ascending option in LibreOffice Calc?
a. To arrange data in ascending order     
b. To arrange data in descending order
c. To shuffle data randomly                    
d. To erase the selected data
Answer: a. To arrange data in ascending order    

♦ To calculate the ----- of the numbers in cells A1 to A5, we can use = SUM (A1:A5).
Answer: Sum (Total)

Which spreadsheet software is included in IT@School GNU-Linux?
Answer: LibreOffice Calc

Name two other spreadsheet programmes apart from LibreOffice Calc.
Answer: Microsoft Excel and Gnumeric

What do you see when you open LibreOffice Calc?
Answer: A worksheet made up of columns and rows.

How are columns labelled in Calc?
Answer: Columns are labelled with letters (A, B, C …).

How are rows labelled in Calc?
Answer: Rows are labelled with numbers (1, 2, 3 …).

What are the small squares in a worksheet called?
Answer: Cells.

Give two examples of cell names from column A.
Answer: A1, A2.

Give two examples of cell names from row 1.
Answer: A1, B1.