salam...
Learning excel can help us do tasks n job much easier and faster.As for our tutorial class (Feb, 2nd 2009), we ve been taught on excel.Function like formulas are for the example.
As to total up the students' marks (sum for all subjects gained by each student), function auto sum being used..
After finished with all that, a graph was constructed. The graph could define the marks in figure form.We can select what can be represented by axis x and y and also include the graph title..
And again we re assigned to do a task on excel as a reflection to the tutorial.N the mark is still in progress...=)
MARKAH DIISI DALAM JADUAL
MARKAH DLM BENTUK GRAF
Learning excel can help us do tasks n job much easier and faster.As for our tutorial class (Feb, 2nd 2009), we ve been taught on excel.Function like formulas are for the example.
- To fill up marks , students' name n subjects name being listed 1st.
- and to set the grade (for example from 80-100 = A, from 70-79 is B n so forth..), a table must be created.The table state the marks range and d grade accordingly.
- highlight the table, go to 'formulas', define name..
- Then, insert Vlookup.Fill up like this:
- Lookup value : click on mark example "58"
- Table array : type "GRED"
- col-index : type "2"
- Range-lookup : type "TRUE"
As to total up the students' marks (sum for all subjects gained by each student), function auto sum being used..
After finished with all that, a graph was constructed. The graph could define the marks in figure form.We can select what can be represented by axis x and y and also include the graph title..
And again we re assigned to do a task on excel as a reflection to the tutorial.N the mark is still in progress...=)
MARKAH DIISI DALAM JADUAL
MARKAH DLM BENTUK GRAF
iyolah. alih2 saper yg kena tlg asaimen ko...
ReplyDeletehihihi betul2x cikgi che wan kiter nie ...
ReplyDelete