Followers

Saturday 20 August 2011

Week 7b- Database

hello guys!
last assignment for the semester.yeay!!database- create a student database using openoffice base. for this assignments, i have to ask help from my classmates, since i have no idea at all how to complete it.so, thanks to wan nazira for teaching and guiding me all  over the process :))) so, 4 base objects using open office base:

1. Tables
2. Forms
3. Queries
4. Report

first of all, tables. i have created 4 tables. the pictures below tells everything.

 student table
 parent table
 curriculum table
co curriculum table

then, forms. i'll show 2 forms only. as the form is quite similar with each other.



the third one is Queries.


and the last one is report. 

overall, i find that this process isn't that difficult actually. it's simply because i don't quite understand the directions given. and one thing that i found out about openoffice base is the data saved cannot be edited. is it true? correct me if i'm wrong. so, i guess that's all. bye. thanks for reading,

Week 7a- Spreadsheet (Excel and open office Calc)

hello guys, girls.

quickly, I'll write on this week's task, two as usual:

Assignment 8a- One year personal financial management sheet.

this time, i have to do a one-year financial management sheet. take a look at the picture below:


this is my financial management sheet for the month of January.


 use formula to automatically count the total income for each month. as you can see in the picture above, the total income = B3+B4. B refers to the column, and the number 3 and 4 refer to the rows.


total expenditure= E4+E5+E6+E7+E8+E9+E10.


total balance= B7-E12. 

done for assignment 8a.now proceed to assignment 8b. creating a spreadsheet using Microsoft office excel 2007. for this task, i have to create a spreadsheet on students' score and grade analysis. the elements below have to be used in this spreadsheet.

1. define name
2. fill series.
3. VLOOKUP
4.STDEV
5.AVERAGE
6.COUNTIF
7.Graph
8.Sort
9.Filter

that's all for this week. thank you!

Week 6 - Creative Multimedia Production

hello again!

two task for week 6:

Assignment 7a
For this assignment, me and my partner are require to produce a presentation kit using open office impress. this presentation kit was based on our Mini Research Journal,and that was in week 4 i think. OK, let's proceed to the process of making a presentation kit using impress, which i bet that most of us are not very familiar with. open office impress is quite the same like Microsoft office PowerPoint. but it seems like it's more complicated to use rather than PowerPoint, and that's maybe because this is my first time using that. as i stated before, the presentation kit is based on mini research journal. so, the content of the presentation kit is all about our findings from our survey before. the principles of CASPER is used in the making of this presentation. this is important to ensure that we produce an effective presentation. for your information, CASPER stands for C-Contrast, A-Alignment, S- Simplicity, P-Proximity, E-Emphasis, and R- Repetition. as usual, you can visit my yahoo group to see the presentation kit. ah, and we are required to upload this presentation to google docs, which i'll be doing very soon.thank you.


Assignment 7b
Second Assignment for week 6. this time, to develop our own multimedia courseware, individually. this assignment requires me to use a few types of media, like video, audio, an etc. well, it's quite hard for me though because I'm born not to be creative =p KIDDING. haha. actually, i thought that this is a pair work, as other assignments before, but i was wrong, it's actually an individual work. now i'm still in the process of completing this task. i got a bit problem with my laptop before, virus attack! the whole system corrupts. anyhow, i'll try my best to complete this task as soon as possible, at least before final examination.

OK, i think that's all for now. thanks for reading.

Saturday 13 August 2011

Week 5- Multimedia in Education

Assalamualaikum and hye to readers, as usual. task for week 5 is to produce a brochure using Microsoft office publisher, and also a booklet using Microsoft office word.

to simplify, the task for week 5 is:
1. Learning about 2D graphic types: bitmap and vector images
2. Graphic/Image file format.
3. RGB and CYMK colour.
4. Use bitmap editor (Microsoft  Paint)
5. Use drawing facilities (Shapes / SmartArt) in Powerpoint (vector graphics in PowerPoint, but saved as
     bitmap graphic - jpg, bmp.
6. Photoshop look alike with layers: GIMP
7. Google draw (vector graphics for online collaborative graphic editor
8. Vector-based drawing: OpenOffice.org Draw.

then, we have to use all the softwares and images format to create a brochure and also a booklet. so, here, me and my partner use the office 2007 version. the brochure and the booklet are all completed, and you can take a look at my yahoo group for the brochure and booklet.

Thursday 11 August 2011

Week 4 Part 1- Mini Research Journal Report.

Assalamualaikum and hye to readers.

Few days back, I've wrote a post on SPSS, which you can read here. so, this post is a continuum from the last one, where in this post I'll reflect on writing a mini research journal report, based on the data from SPSS. what we have to do? me and my partner, helmi have to write a journal report based on our finding before. the survey i mean, the one that we carried out using google docs (form). that journal report should contain the abstract, introduction, literature review, research approach, findings, discussion, recommendation and conclusion, and lastly references. please take a look at part of our complete journal below:

1.0 ABSTRACT

The research was done to identify the level of 21st century skills in the respondents from TESL UKM- IPG. 19 students from TESL UKM-IPG responded to the survey. The survey was conducted by Salina Sayang binti Kamal Arifin and Mohd Helmi Syazwan bin Mohd Zaki. The skills involved in the research are the skills in 21st century skills, which also can mean the skills needed to remain knowledgeable in the 21st century. For examples, critical thinking skills and communication skills. From the survey conducted, a few recommendations had been made to enhance the skills in the students.

2.0 INTRODUCTION


21st century skills are the skills that increasingly demand creativity, perseverance, and problem solving combined with performing well as part of a team. 21st century skills do not only includes ICT skills, but also other soft skills like communication skills and critical thinking skills. 21st century skills can be divided into four categories; ways of thinking (creativity, critical thinking, problem-solving, decision-making and learning), ways of working (communication and collaboration), tools for working (ICT and information literacy), and skills for living in the world (citizenship, life and career, and personal and social responsibility).

3.0 LITERATURE REVIEW

21st century skills are not unknown terminology to talk among people all around the world. It vibrates and propagates through all regions and makes it
very important to acquire these skills. Community in the academic field, students and teachers especially, should master these skills. Classroom teachers need to be familiar with these skills and integrate them throughout the curriculum. What are 21st century skills? Based on the U.S Secretary of Education Arne Duncan (2009) referred to 21st century skills as "skills that increasingly demand creativity, perseverance, and problem solving combined with performing well as part of a team." As to wrap up, 21st century skills means, how well students can do with knowledge and applying what they learn in authentic contexts. Their choicest or most essential , vital part of some idea or experience involves strong communication and collaboration skills, expertise in technology, innovative and creative thinking skills, and an ability to solve problems.
In applying these skills to the youngsters, some difficulties are emerging and creating a barrier in achieving it. Especially in Malaysia, we are focusing more on the exam result rather than acquiring these skills. The problem arises by the critics, they argue by saying, “21st century skills as a meaningless term and distraction from the more important work of teaching core context and these types of higher-order skills cannot be measured in reliable, cost-effective, or scalable ways”. (Elena Silva, The Phi Delta Kappan, Vol. 90, No. 9, May, 2009). Not to forget, Malaysian now live among the first class mentality people, so, they will see these problem as a global one and they tend to criticize it when these skills is implemented in Malaysia. How to solve this particular problem? In resolving this, government should convince and win the citizens hearts. We have to open our eyes widely as we are living among the first class mentality people and it is hard for them to accept anything or almost everything when it comes to something that is not reliable and ambiguous. They will not accept these skills easily when they are not seeing the result and consequences after these skills being implemented.
Government should really convincing the citizens and disseminating the „21st century skills‟ ideas so that it can be accepted by our citizens.
The implementation also can be really unmanageable when the teachers are not trained well by the professional in carrying these skills. Once these skills is running on track, it will be obstructed when the teachers could not deliver the teaching lessons and make the students master these skills and as the consequence, watering down the objective of the 21st century skills. To make matters worse, students are leaving schools without mastering one of these skills neither communication skills nor expertise in technology. So, this problem has to be fixed. Teachers should be sent to some courses and trained well by the expertise and professional so that they will be running straight right on the track. This should be done before these 21st century skills are implemented in schools. Students have to be trained well by the teachers because “skills for the future also were recommended long ago by John Dewey, who proposed an education "grounded in experience," in which students interact with the ever-changing world”(Gohnson and Reed 2008, 1 3).
Last but not least, another problem is the lacking of programs in 21st skills is the lacking of programs of introducing and educating the students about 21st century skills. As a result, students, especially in the rural area are not aware of these skills, and can not master them. For now, one program known for developing 21st skills is the establishment of “Smart Schools”. Smart school is a learning institution that has been systematically reinvented in terms of teaching-learning practices and school management in order to prepare the children for the Information Age (Yassim, 2010). Basically, smart schools are introduced to prepare the students with enough knowledge and skills to confront with the Information Age, a time where nothing else is valuable except knowledge. There is a phase in the implementation of smart schools, known as “making all schools smart” phase. This phase is a continuous process to acculturate the use of technology in education to ensure quality teaching & learning, effectiveness of school administration and management and teachers‟ ICT competency (Yassim, 2010). In this phase, all schools in
Malaysia will gradually undergo revolutions and change is smart schools. There are four primary objectives of this phase. They are:
1. To produce a knowledge society that is critical, creative, and innovative.
2. To produce technology savvy individuals for the Information Age.
3. To bridge the digital divide.
4. To cultivate life-long learning based on ICT.
From all of the above objectives, we can conclude that all of them are more towards benefiting technology as 21st century tools. Besides, there are no specific criteria for the students to enter those smart schools. There are no limitations on which students have the right to enroll in those schools. In my opinion, there should be continuity for such programs. If providing another program is quite costly, maybe Ministry of Education can provide a new curriculum which contains the same elements as the smart schools‟ curriculum.
To conclude, all of the problems above should be solved by all parties which include government, students, teachers, and society as well. This is very important to produce a better generation with vast knowledge and critical thinking. In Vision 2020, it is stated that “The challenge of establishing a scientific and progressive society, a society that is innovative and forward looking, one that is not only a consumer of technology but also a contributor to the scientific and technological civilization.” This means that Malaysia also is very committed in producing knowledgeable citizens, those who can contribute more to the country.

4.0 RESEARCH APPROACH

For the research to be completed, a spreadsheet survey on 21st century skills was created using Google docs. The survey, which consists of 10 questions were sent to 38 trainee teachers from IPG Dato‟ Razali Ismail and IPG Sarawak via their official Gmail account. But only 19 trainee teachers respond to the survey. The survey mainly focused on two aspects; the respondents‟ opinions on 21st century skills, and the respondents‟ self 21st century skills. For the respondents self 21st century skills, they were asked to rate their own skills. Four scales were given; 1- poor, 2-moderate, 3-good, 4- excellent. From the respondents self-rating, we can conclude on how they think about the soft skills in themselves. All the data gained from the survey was analysed in frequencies using Statistical Package for the Social Sciences (SPSS) 19.

you can read more on this link.

what i have gain from this week's assignment?

1) how to write a journal. i mean, the exact way to write the journal, the formats, the fonts, spacing, margins and etc. all have to be right.

2) how to discuss about something.in this journal report, i have to discuss on the findings(data). they all have to be analysed one by one, without making any single mistakes. because one mistakes may affect the whole report. so, i've to try my best not to do any mistakes when discussing on the data.

3) teamwork. still the best. you can't work alone. this assignment requires  a lot of attention and i cant make it alone. that's why i need my partner. thanks alot to mr helmi syazwan. :))

that's all for this update. will update on other assignments later. till then, bye. and have a nice day ahead. thanks for reading!


Monday 8 August 2011

Week 4 Part 1- SPSS

this time, we are required to analyse the data from the previous survey conducted by me and pair,Helmi.before this, I've stated that we had to conduct surveys using two different platforms; surveymonkey and googledocs. but for this data analysis, we were told to only use the data from google doc, as the survey by surveymonkey will only be used as a pilot test.

the task:


SPSS:
1. From the printed questionnaire, use pencil for giving code for the variable of each item. Example 
  • Form ID: (give values 1 to 10, 10 -20) 
  • Gender: 
            1. Female  
            2. Male  
  • Scale:
1. Strongly disagree
2. Disagree
3. Less agree
4. Agree
5. Strongly Agree
2. Open SPSS and start naming the variable using Variable View .. Example 
  • Name: Form ID ; type: Numeric:; width : 8; decimals: 0; Label: Form Identification; values: none  
  • Name: Gender; type: numeric; width: 8; decimals: 0; Label Value (1, Male.....)
3. Data Entry (for printed questionnaire) using Data View
4. In data view, Data -> Merge / import data from Online Questionnaire spreadsheet (make sure that the variable is the same)
5. Run the analyze ->descriptive data: Frequencies
6. Output will be displayed in SPSS Viewer
7. The table and graph can be copied from SPSS Viewer to OpenOffice Writer for reporting.
(Exclude the data from surveymonkey – it is just a pilot test)
Based on the online discussion (Qualitative data), analyze the data by create the thema for the discussion about certain issues.


the data was analysed using IBM SPSS 19 and, the data will be used as the input for assignment 5 (mini research). 

what is SPSS??



 "Statistical Package for the Social Sciences (SPSS) is computer program used for survey authoring and deployment, data mining, text analytics, statistical analysis, and collaboration and deployment "- Wikipedia.


 Reflection:

so, SPSS is indeed a complicated thing i think. ehem. we have to key-in the data from google docs to this analysing software, one by one. it's such an eyesore to see those numbers.allergic.KIDDING. overall, this SPSS is indeed a new thing for me. the steps, sometimes quite easy, sometimes can be quite a mess. but, once you've get used to it, it wouldn't be a problem anymore. data analysing -- it's quite hard actually for me as I'm the one who can easily get confused if the data is repeated. why do i said so? because most of the respondents have the same answer. for example, if the question is about gender. let's say the value '1' is for male, and '2' for female. the sequence will be like "1,1,1,1,1,1,1,1,2,1,1,1,2"continuous 1, and it's order horizontally.  isn't that confusing enough? sometimes, i mistakenly put the value as '2' where it actually should be '1'. fortunately, i have my partner, Helmi, to correct the data if i make mistakes in keying in the data. :)) the best part when using this SPSS is when I have to wait for the data to be analysed automatically by SPSS system. why? because that means I have successfully overcome all the confuse-ness and able to analyse the data. and, the worst part is when I finally realised that i've mistakenly key-in the data.haha. I've to key-in the data for several times to get the exact analysis. but never mind, that's called learning from mistakes.nobody's perfect. and i am certain that others sure do have the same problem as mine. i think that's all for this week, I'll be back with the update on mini research, which is based on the data analysed using this SPSS. sorry for the broken english, hopefully you can get the points that i'm trying to convey. thanks for reading.

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Top Web Hosting | manhattan lasik | websites for accountants