This week, we explored the usages of spreadsheet software. We found out what a spreadsheet software is and we can do with spreadsheet software. We learned about many functions and formulas that we can use in spreadsheet software to help us solve many real-life problems.
Spreadsheet Software
A spreadsheet is an interactive computer application for the organization, analysis, and storage of data in tabular form. Spreadsheets developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. For example, you can use it to analyze your transcript or keep your budget and etc.

Different functions in a spreadsheet software
In class, we used Zoho spreadsheet to practice the different function in a spreadsheet.
Firstly, we wrote down the subjects that we are taking and set the mark we get by using the RANDBETWEEN (bottom; top) function. An integer random number between integers bottom and top can be generated by this function.

Then, we wanted to calculate how many marks I got in total, so we used the SUM function. This function can calculate the sum of a range of numbers that you select. It ignores any text or empty cell within the range.

We also wanted to know how many subjects there were in total, so we used the COUNT function which can count the number of the non-empty cells. So what if you want to know the number of the empty cells? You can use COUNTBLANK function which can count the number of the empty cells. What if you want to know the number of cells that contain a certain value such as how many 100 you got? You can use COUNTIF function which can count the number of the values that satisfy a certain condition.

Now we had both the total marks and the total subject numbers, we could know the average marks I got. We could divide the SUM number by the COUNT number to get the average marks. However, there is another smarter way to calculate the average. We used the AVERAGE function to do that! We could just select all the cells that contain the marks, and the spreadsheet software can calculate the average marks for you!

The average mark may have a lot of decimal places, and you may not want to see that much decimal places on your transcript. So what can you do? You can use the ROUND function, ROUNDDOWN function, and ROUNDUP function. The ROUND function can round a number to a certain precision. ROUNDDOWN function can round a number down, toward zero, to a certain precision. ROUNDUP function can round a number up, away from zero, to a certain precision. Like this:

Do you want to know which subject is your strongest subject and which one is the weakest? Use MAX and MIN function! These functions can tell you the maximum/minimum of a list of numbers.

Now, do you want to know how you perform on a certain subject compare to on other subjects? For example, how I perform on CS compare to on other subjects. You can use the RANK function which can tell you the rank of a number in a list of numbers, like this:

So then we know that CS is my strongest subject (not true!) Using IF and AND functions, we can even know whether I pass my CS or not and how much I get when I convert my CS marks to IB standards.

Now let’s talk about something other than grades! We can use the ABS function to know the absolute value of a certain number. For example, we can use ABS when we are recording our spending which is always negative.
IFERROR function is able to return one of the two values, depending on the first value. It can be used to check if a certain value has got a correct formula to derive it.
Finally, we used CONCATENATE function to write a very interesting story by the whole class! Each of us wrote a little part of the story, and we combined everyone’s parts by using this function.

Conclusion
These are the functions that I learned in this week’s class. Aren’t they incredibly useful? Now we can do so many things with spreadsheet software!




















































