Good morning! Nice to meet you again! =)
This week assignment is similar with the previous one as we're required to prepare two spreadsheets namely , (a) personal annual finance and management and (b) students' scores and grade analysis spreadsheets.
In the first assignment, we're required to plan and create an annual financial management of income and spendings using Open Office Calc. Honestly, I've never come anywhere close to this application so thus I've pretty confused upon my first contact with this application. Try imagine my dilemma. Even though I did have some prior knowledge regarding Microsoft Excel, but I rarely find the need to use and apply it into my academics and therefore I was pretty vague about its functions and application. What more to say me using Open Office Calc which was such a foreign subject matter to me. In fact, I had a hard time trying to apply and link the formulas required together in order to produce data. Both Rachel and I felt lost and confused, so as my other coursemates. Therefore, I took the initiative to consult Mr. Farriduddin for help and thankfully enough, he did spend an entire two hours of lecture to brief on the ways to link the formula together to create the desired data. I found the assignment easier to complete and be done of after an explanation from our course lecturer. Initially, I made the mistake of thinking that the spreadsheet was to be done in 3 months. We later got to know that we have to prepare a yearly spreadsheet. In other words, we need to come up with a financial management spreadsheet of 12 months. However, all in all, we took just half a day to complete the first half of the assignment after much guidances from Mr. Fariddudin.
Next, moving into the latter part of the assignment where we need to plan and prepare a spreadsheet about (virtual) students' scores and grade analysis. We are instructed to complete this assignment through Microsoft excel. We need to include the functions present in the spreadsheet format namely, VLOOKUP, STDEV, AVERAGE, and COUNTIF. These functions are useful and time-saving as they help us to read values of the data keyed in automatically from the given range without much problems. Truth to be told, this application is extremely useful for us as future teachers as we too have to prepare students' score inputs. We don't have to spend precious time trying to insert the data given manually which can be proven to be quite troublesome compared to using the functions available in Microsoft Excel. Although I did face many problems upon my contact on both Microsoft Excel and Open Office Calc, practise always make perfect. My attempt in trying to locate the different position of the function butons and tans is proven to be a success after a series relentless trial and error.
All in all, both applications are proven to be very useful in my future teaching profession. the fist part of the assignment could be applied in managing the annual school finance management specially those related to event planning. The latter part of the assignment is equally important too as we need to acquire such skill in order to create and prepare students' score analysis. Both applications are of much use in our not-too-distant teaching career. Honestly, this course subject, "Computer in Education" has provided me the opportunity to acquire new skills and brush up the existing knowledge to be applied into my future teaching career. So, thanks so much!
Happy Reading! =)
Link: https://docs.google.com/spreadsheet/ccckey=0Al7FDQNrqORedEJ4Ul82WlU5ekpNWGRRdmt2STlFQUE&hl=en_US
http://groups.yahoo.com/group/a135735aileentiong/files/Week%207(a)/
This week assignment is similar with the previous one as we're required to prepare two spreadsheets namely , (a) personal annual finance and management and (b) students' scores and grade analysis spreadsheets.
In the first assignment, we're required to plan and create an annual financial management of income and spendings using Open Office Calc. Honestly, I've never come anywhere close to this application so thus I've pretty confused upon my first contact with this application. Try imagine my dilemma. Even though I did have some prior knowledge regarding Microsoft Excel, but I rarely find the need to use and apply it into my academics and therefore I was pretty vague about its functions and application. What more to say me using Open Office Calc which was such a foreign subject matter to me. In fact, I had a hard time trying to apply and link the formulas required together in order to produce data. Both Rachel and I felt lost and confused, so as my other coursemates. Therefore, I took the initiative to consult Mr. Farriduddin for help and thankfully enough, he did spend an entire two hours of lecture to brief on the ways to link the formula together to create the desired data. I found the assignment easier to complete and be done of after an explanation from our course lecturer. Initially, I made the mistake of thinking that the spreadsheet was to be done in 3 months. We later got to know that we have to prepare a yearly spreadsheet. In other words, we need to come up with a financial management spreadsheet of 12 months. However, all in all, we took just half a day to complete the first half of the assignment after much guidances from Mr. Fariddudin.
Next, moving into the latter part of the assignment where we need to plan and prepare a spreadsheet about (virtual) students' scores and grade analysis. We are instructed to complete this assignment through Microsoft excel. We need to include the functions present in the spreadsheet format namely, VLOOKUP, STDEV, AVERAGE, and COUNTIF. These functions are useful and time-saving as they help us to read values of the data keyed in automatically from the given range without much problems. Truth to be told, this application is extremely useful for us as future teachers as we too have to prepare students' score inputs. We don't have to spend precious time trying to insert the data given manually which can be proven to be quite troublesome compared to using the functions available in Microsoft Excel. Although I did face many problems upon my contact on both Microsoft Excel and Open Office Calc, practise always make perfect. My attempt in trying to locate the different position of the function butons and tans is proven to be a success after a series relentless trial and error.
All in all, both applications are proven to be very useful in my future teaching profession. the fist part of the assignment could be applied in managing the annual school finance management specially those related to event planning. The latter part of the assignment is equally important too as we need to acquire such skill in order to create and prepare students' score analysis. Both applications are of much use in our not-too-distant teaching career. Honestly, this course subject, "Computer in Education" has provided me the opportunity to acquire new skills and brush up the existing knowledge to be applied into my future teaching career. So, thanks so much!
Happy Reading! =)
Link: https://docs.google.com/spreadsheet/ccckey=0Al7FDQNrqORedEJ4Ul82WlU5ekpNWGRRdmt2STlFQUE&hl=en_US
http://groups.yahoo.com/group/a135735aileentiong/files/Week%207(a)/
Aileen Tiong Ling
A135735
B. Ed TESL IPGKS - UKM
GGGE1155 Computer in Education
Faculty of Education
Telephone Num. : 013-5603522
Email Address(es) : aileenukm7@yahoo.com/ aileenanaukm7@gmail.com
Yahoo! Group Account : http://groups.yahoo.com/group/a135735aileentiong
Facebook Account : http://www.facebook.com/a135735aileentiong
Blog Address : http://aileena135735.blogspot.com
No comments:
Post a Comment