Be Familiar with LibreOffice Calc: A Tutorial

This tutorial will discuss computing grades on LibreOffice Calc using the 'VLOOKUP' function. This also teaches the basics of creating charts or graphs in this LibreOffice tool.

1. Computing for the index grade. Considering that you already have the average grades of your student, you can compute for the index grade by using the 'VLOOKUP' function. But first, you should have a table of legend (see table at the right) that will be the basis of your index grade.
• You will be the one to set the highest attainable score as well as the passing score.
• The increment is computed as (highest - passing) / 9
• The difference is divided by 9 since there will be 9 ranges to consider from grade of 1 to 3.
• For the grade of 1, that is the highest less increment. For the grade of 1.25, that is the increment lesser than the grade of 1. And so on, and so forth.
• In computing the index grade, go to insert then function and use for VLOOKUP, then click next. A window will appear that will demand you to key in the search criterion, array, index, and sort order.
• The search criterion is the grade average you want to have an index grade with. In the array, you have to highlight the whole table range. The index is 2 and the sort order is 1.
• The index is 2 since the index grade is in column 2; while the sort order is 1 since the grade in the legend is arranged in ascending order. Use referencing by adding dollar signs ($) in order to just the formula cell for the other cells.
• In determining the remarks, the same process above is done, it's just that, the index now is 3, since the remarks are in the third column of the table.
2. Counting using the 'COUNTIF' function. The COUNTIF function allows you to count the number of cells that meet the criterion. In using the COUNTIF function, go to insert then function and look for COUNTIF and then click next. A window will appear demanding you to determine the range and the criteria.
• In the range, you need to highlight the whole column or group of columns where the criterion will be counted.
• In the criteria, you input the one you want to count.
• Example: You want to determine the number of times the grade 1.25 appears in the index grade column. You can do that through the COUNTIF function.
3. Making a pie chart.  A pie chart is used to show percentage or proportional data. In making a pie chart. Select or highlight first the data you want to make a pie chart with. Then go to insert, then click the chart and choose for the pie type of chart. You are free to choose other designs for your pie chart.
   
4. Making line chart. Line charts are used to show time series data that shows the behavior of variables over a period of time. In making a pie chart. Select or highlight first the data you want to make a line chart with. Then go to insert, then click chart and choose for the line type of chart. You are free to choose other designs for your line chart.
   
   
   
5. Making a bar chart. Bar charts are used to display and compare numbers, frequency or other measures. In making a bar chart. Select or highlight first the data you want to make a bar chart with. Then go to insert, then click the chart and choose for the bar type of chart. You are free to choose other designs for your bar chart.