Week 7a (Spreadsheet)

This week assignment required us to do a simple one year personal financial management spreadsheet using Calc from the Open Office software. If i were to do it solely based on the instruction provided in our task question, i can say that it's really complicated for me. Furthermore, as i've said many times before, i am quite new with this open office software thus making me quite not confidence in using it. Surprisingly, it's not that hard from what i've thought! To be honest, i think that using Calc is much more easier from using Excel! Here are some of new things that i've learnt from this week assignment. First thing that you have to do is to fill in all of your details for your monthly spending. This includes to rename your sheet with each month. As soon as you have fill in with all of the details required, it is time for you to insert the formula for each of the total needed. 

click picture to enlarge

You need to identify the coordinate of the row and column as it'll be used when you want to create the formula. Below are the example of how you can create the formula:

click to enlarge

As the task need us to create a formula of calculating the balance of previous month and to link the formula between each sheet, we come up with a formula: Selecting the "Balance of the previous month", goes to the previous month balance, and simply "enter" the column. It will then automatically appear in the next month balance that we had selected earlier. Just to make it clear, here's a picture of it =)

Step 1

Step 2

The rest, you just have to copy all the data from the previous month and paste it at the sheet of the new month. You just have to edit the amount of money you've spend in each of your expenditure session. Simple, isn't it? =)

Excel

Using excel this time with all of the formulas needed is quite confusing. And this is totally not my favourite assignment so far. However, shall we have a look on what i've learn for using excel in creating the spreadsheet for students grade and score?

VLOOKUP: used to fill the grade of the students automatically. You can fill the data based on the respective colours that i've given. Click on the fx button and look for a function of VLOOKUP.

click picture to enlarge

STDEV: standard deviation. Again, click on the fx button and search for a function of STDEV. Highlight and drag the whole column to be inserted in the box number1. It will automatically calculate the STDEV.

click picture to enlarge

AVERAGE: The average score for each students. Use the same steps as STDEV. However, instead of choosing the function of STDEV, select the function of AVERAGE.

COUNTIF: used to calculate the number of students for each of the grade. Choose the function of COUNTIF. Highlight and drag the "score" column to be inserted to the range of data. Select the grade that you want to count in the criteria box. ex; "A".

click piture to enlarge

GRAPH: choose data that you want to convert to a graph.

Click picture to enlarge

That's all for this week task. To conclude, I think that knowing all this basic stuff using excel is very useful to me as i know that i'll be using it in future for me to key in and analyze my students performance. Although it is quite confusing and not to mention several mistakes that i've done while i'm completing this task, once i've got used to it, it will be as easy as ABC. I think that's all for now. We'll meet again in my next entry. Have a nice day!