Tuesday 23 August 2011

database

this week assignment is to plan, create and edit a simple database for students management information using openoffice base.


it was really fun. !

spreadsheet

this week we were required to plan, create and edit a simple one year personal financial management (income and spending) spreadsheet using calc.

then we were needed to name the sheet according to the month ie Aug11, Sept11, ... July11

after that, create a formula to calculate the a balance for each month. balance of August for example will be added to the next month.

again, the file is to be uploaded to google doc.


after that, we are needed to do a second task which is to plan, create and edit spreadsheet of students score and grade analysis.

i've learnt a  lot of new things in this assignment as we were needed to use;


  • define name
  • fill series
  • VLOOKUP
  • STDEV
  • AVERAGE 
  • COUNTIF
  • graph
  • sort
  • filter
those stated above are the formula use in the spreadsheet.
after that, base on the data collected, we were needed to create graph to represent the data.
being as a teacher in the making, this knowledge is very useful to be use in the future.




Tuesday 16 August 2011

Open Office Impress and Movie Maker

this week we were required to create a presentation kit using IMPRESS.
the content must be based on the assignment 5 (mini research)
the presentation must follow the guideline of a good presentation skills.


do check out our yahoogroup. it was fun !

Brochure and Booklet

this week assignment is to plan, design and create a BROCHURE and BOOKFOLD using Microsoft Publisher and Microsoft Words respectively.
again, the content must be related with the topic for assignment 1,4 and 5.
for this very assignment, we have to use graphic / images created using any graphic editors as stated below:

  • 2D graphic types: bitmap and vector images
  • JPEG/GIFF/TIFF/BMP/PNG/WMF
  • RGB/CMK
  • Microsoft paint
  • smart art power point
  • GIMP (OSS)
  • Online - google draw
  • OpenOffice draw 
those are our brochure and bookfold. 
as what my partner, Wan Nazira Che Nor wrote in her recent entry, yes we do love simplicity  =) 

BROCHURE 


BOOKFOLD 

cover page
content 1
content 2

last page

I have never created any booklet or bookfold before. Assigning to do this assignment was a troublesome for me in the first place.
After figuring out what it is actually and how does to get this bookfold done, I found that this assignment is quite simple and interesting actually. We both enjoyed doing it.
Bookfold and brochure are one of the interesting way of reading. The content is much simple and precise. People usually use points and simple language to describe about their products.
Our topic is Operating System. Again, for this assignment, we compared between Windows and Ubuntu. Our objectives is to expose or reveal the fact about their existing Operating System they might not know.
With the graphics and images provide in the brochure and bookfold, we hope that now friends are gaining a better understanding with what we are trying to conveyed here

till then,
buhbye.


Thursday 11 August 2011

SPSS and reporting

hye ! this week we were required to make an analysis based on the qualitative data we have collected by create the theme for the discussion about the certain issue. 

the report must be in journal article format complete with reference as stated below; 
  • title
  • abstract
  • introduction
  • literature review
  • research approach
  • finding 
  • discussion 
  • recommendation and conclusion 
as usual working with my loyal partner, Wan Nazira Che Nor and I had decided to to divide the task equally so that it will be more organized, easier and save time ! 
as what has been mentioned in the previous entry, our online survey was a bout operating system which is Windows versus Ubuntu. 

we chose Ubuntu because it is different from the Windows and also one of the well known operating system that can be easily downloaded from the internet. What makes it different from the Windows is that Ubuntu is a   cost-no-money operating system. based on our readings, there are thousands of users all over the world are using Ubuntu compared to Windows. they are saying that, to be compared with Windows, Ubuntu is easier, simpler, fast, and secured operating system. but the subject matter is, in Malaysia, most of the computer users are using Windows as their operating system. so we tried to investigate what is the main factor as to why people use different kind of operating system. price seems to be the reason why. but the data collected based on the survey we have done before, only 3 out of 20 students are using other than Windows. 

based on the data collected, we have found that most of the respondents or students to be specific, are lack of knowledge about the operating system. 
when we first introduced Ubuntu to them, majority of them were saying that it was their first time hearing about it. The data collected shows that they are interested to know about Ubuntu. 
so teachers have to play their role in educating the students more on Information Technology (IT). it is undeniably true that we can see most of the peoples these days are using computers as one of the medium for their education, career, and social networkings. take Facebook for an example. there are millions of users are connecting across the world using computers, mobile and many other electrical devices. 

connected to internet through the browser, an operating system can actually gives a big effect on their computer system such as speed and security. if the operating system used is not compatible with the computer software, the system can be easily invaded with viruses and sometimes some of the application such as games, cannot be performed well. 

there are loads of things i have learned from this very assignment. well i have to admit that it is also my first experience conducting an online survey and learning about Ubuntu. 

**our report has successfully uploaded to yahoogroup. feel free to check it out :)
till then
buhbye