After an enjoyable week of multimedia, we're moving on to something serious this week.
It's SPREADSHEET!
So, what's a spreadsheet?
A spreadsheet is a table of values arranged in rows and columns. Spreadsheet applications are computer programs that let you create and manipulate spreadsheets electronically. In a spreadsheet application, each value sits in a cell. You can define what type of data is in each cell and how different cells depend on one another. The relationships between cells are called formulas, and the names of the cells are called labels. (Source: Webopedia) Basically, there are numerous spreadsheet application available on the Net and most widely used is Microsoft Excel. OpenOffice Calc is also another application that can be used for spreadsheet.
What did I do this week?
We had to come up with a personal financial management on income and spending. May sounds easy but let's move on to the next instruction. To link the formula between the sheets. I looked up on Google how to link the formula between the sheets since I had little experience in doing spreadsheets. Azrul was the saviour of the day for stumbling into steps on how to link the formula. He showed me on his laptop and more or less, I can comprehend on how to link the formula. The balance from the first month was able to be added to the balance of the next month and consecutively. We created one spreadsheet, ranging from January until December. The balance (income minus spending) of January was added to February and the subsequent months. I am very grateful that we managed to complete the spreadsheet successfully without much hassle. Objective accomplished!
Apart from creating a personal financial management, we also had to plan, create and edit a spreadsheet of
students score and grade analysis. Among the functions we had to utilise is VLOOKUP, STDEV, AVERAGE and COUNTIF. These functions are useful as it allows values of data to be read automatically from the given range. Knowing how to use spreadsheet is valuable because we are going to use them in the future for students' score input. There is no longer a need to insert score and grade manually to the spreadsheet as it can be calculated easily using the functions. Honestly, using Microsoft Excel is so much easier if compared to OpenOffice Calc. The functions button are easily accessible in the navigation bar and a drop down box will appear. One can select whatever functions applicable to calculate certain data.
I've learned so much again this week from spreadsheet. Spreadsheet is not something I'm familiar with since I rarely use it on daily basis. This course has provided me an opportunity to learn something new and thus, I can use these skills in the future. At least next time I encounter spreadsheet, I will not be lost and use the techniques learned wisely.
Links to our spreadsheet:
A spreadsheet is a table of values arranged in rows and columns. Spreadsheet applications are computer programs that let you create and manipulate spreadsheets electronically. In a spreadsheet application, each value sits in a cell. You can define what type of data is in each cell and how different cells depend on one another. The relationships between cells are called formulas, and the names of the cells are called labels. (Source: Webopedia) Basically, there are numerous spreadsheet application available on the Net and most widely used is Microsoft Excel. OpenOffice Calc is also another application that can be used for spreadsheet.
What did I do this week?
We had to come up with a personal financial management on income and spending. May sounds easy but let's move on to the next instruction. To link the formula between the sheets. I looked up on Google how to link the formula between the sheets since I had little experience in doing spreadsheets. Azrul was the saviour of the day for stumbling into steps on how to link the formula. He showed me on his laptop and more or less, I can comprehend on how to link the formula. The balance from the first month was able to be added to the balance of the next month and consecutively. We created one spreadsheet, ranging from January until December. The balance (income minus spending) of January was added to February and the subsequent months. I am very grateful that we managed to complete the spreadsheet successfully without much hassle. Objective accomplished!
Apart from creating a personal financial management, we also had to plan, create and edit a spreadsheet of
students score and grade analysis. Among the functions we had to utilise is VLOOKUP, STDEV, AVERAGE and COUNTIF. These functions are useful as it allows values of data to be read automatically from the given range. Knowing how to use spreadsheet is valuable because we are going to use them in the future for students' score input. There is no longer a need to insert score and grade manually to the spreadsheet as it can be calculated easily using the functions. Honestly, using Microsoft Excel is so much easier if compared to OpenOffice Calc. The functions button are easily accessible in the navigation bar and a drop down box will appear. One can select whatever functions applicable to calculate certain data.
I've learned so much again this week from spreadsheet. Spreadsheet is not something I'm familiar with since I rarely use it on daily basis. This course has provided me an opportunity to learn something new and thus, I can use these skills in the future. At least next time I encounter spreadsheet, I will not be lost and use the techniques learned wisely.
Happy Spreadsheet-ing!
Links to our spreadsheet:
- http://bit.ly/noX4MX
- http://bit.ly/q7N3KQ
B. Ed TESL IPGKS-UKM
IPG Kampus Sarawak
Jalan Bakam 98009
Miri
E-mail: barbarakath108@gmail.com
http://groups.yahoo.com/group/barbara_kath
http://www.facebook.com/barbarakath
No comments:
Post a Comment