For week 13, we will focus on microsoft Excel because as a "teacher to-be" it is important to learn and to now the simple basic on how to used Microsoft Excel.
Our first task was to create our own monthly financial plan for a year using microsoft excel. Below are the process on how I did my monthly financial plan.
The step:
1. Create a column for date and also make a column of the list of what you spend the most during the month for example, food, other necessities, top-up, educational book and etc.
2. Then, we add the column for 'Total Spending' And for this column we need to create a formula to make the column for 'total spending' to calculate automatically the sum of our spending for a day.
To create a formula, first we need to set put the symbol '=' in the cell column and then we can proceed in creating the formula by clicking on the symbol *fx* and then choose the formula that we want, for example in this case, we want to add up all the total of our spending for that particular one day, so we need to choose the formula *SUM* and then click the cell that we want to include in the formula for example: (C5+D5+E5+F5). So, the overall of the formula will look like this =SUM(C5+D5+E5+F5)
Next, after we have created the formula that we want, we can scroll the formula down until it reach the position of the cell that we want.
3. Make a column for our 'Allowance' and also 'Last Month Saving' where in this section, we will focus 'money coming in' during the month.
Same as we did previously, after we have put all the data of our 'allowance' and also our 'last month saving', we also need to create a formula to calculate the total of our saving for that particular day.
When we want to total up our savings for that particular day, we also need to create a formula. For this case, we also need to use the formula 'SUM' because we want to total up all our savings from our allowance and also from our last month saving. However this is for the first column.
Then we scroll the formula down until it reach to the cell that we want.
4.Then for the finally, we need to create a column for our total saving (money going in - money going out)
The formula for this column would be *=SUM(I3-G3)* that is *money going in - total spending*
Then, after we have finished all the column, our monthly financial plan will look something like this:
Below, are the link of my monthly financial plan on google doc.
Our 2nd task for this week was to create a students grade also by using Microsoft Excel. First of all, we need to create a table for 'Student names' , 'Subjects' , 'Marks' , and the 'Grades' as below:
Then, we need to create a grade table for the student marks.The grade table will look something like this:
To add the students grade into the column, first we need to define this grade table by highlighting the Grade Table and clicking on *Insert - Name - Define* and name the grade table as Grade . Then, after we have define the Grade Table, we can proceed in adding the students grade in the *Grade* column by creating a formula.
The formula that we used for the student grade will be *=VLOOKUP(marks,grade,2) for example as the picture below:
Then we can just drag the grade column until it reach the cell that we want. Then we continue to do the same method for the rest of the subjects.
Then we can add another table for *Average* , *Standard Deviation*, *Minimum* and *Maximum* . After we have create the table, it look something like this:
Then to fill in the Average, Standard Deviation, Minimum and Maximum column, we need to define the column for all the subject marks and the subject grades.
Then, we create the formula for:
Average : * =AVERAGE(Marks_bm) *
Standard Deviatior : * =STDEV(Marks_bm)*
Minimum : * =MIN(Marks_bm) *
Maximum : * =MAX(Marks_bm) *
After we had have create all the formula, the table will look something like this:
When we have finish will all of the tables, the overall sheet will look like this:
Below are the link of my Student grade Sheet from my google doc:
