week 7a (spreadsheet)

For week 7a, we have to do spreadsheet using Calc and microsoft excel. in the task of assignment 8a, we have to plan a personal finalcial management which consist of our income and our spending for one year. In this financial management spreadsheet also , i have learn a lot. We need  to use the formula in calc which we have have to calculate the balance for each month and the balanced will bring forward to the next month. after we done with spreadsheet, i had uploaded the file to Google doc as instructed by our coordinator and our lecturer. 

As for assignment 8b, I created a spreadsheet with 15 students and along with 8 subjects which are English, bahasa melayu, mathematics, science and history, geography, kemahiran hidup and agama islam for this spreadsheet, i learnt to use:



o Define name
o Fill Series
o VLOOKUP
o STDEV
o AVERAGE
o COUNTIF
o Graph
o Sort
o Filter