Vlookup Function
The vlookup stands for Vertical lookup and it allows you to determine the information of a specific data from a set of data or database. It returns a value from any cell of a range of cells.
The following steps will teach you how to calculate the
grades of your students using the “vlookup” function as well as some
additional ways of assessing the grades of your students. We will be using this data as our guide.
Step 1. Compute the Average
- As you open your OpenOffice Calc, on Sheet1, enter the Name of your students, their grades for three terms (e.g. T1G for the first term), Average and the last column for the Final Grade. To get the Average:
- Click cell E2, type =AVERAGE(B2:D2), then press ENTER.
- To minimize the time for calculating the average for each student, activate the Cross by double clicking the small box at the bottom-right of the cell or drag it down to the last cell.
- There are many ways of computing the average, one is the command that we used above if you know the correct function. Another is by clicking the Insert, then Function(Ctrl +F2). The Function Wizard will appear showing the different functions. From the Category drop down list click Statistical, then double click Average from the Function list. The Function Wizard dialog box will change like the image below, click “select” to select the range of cells to be calculated or simply write them (e.g. B3:D3). Then click “shrink” then click OK.
- For faster references, you may keep the Function pane by clicking again Insert, then Function list. A function pane will appear on the right side of the screen showing the recent functions that you used. To remove it, click “hide”.
