Week 7(b) - database

this week, we have to do a students database using OpenOffice...
below are the ways to do the students database...

Plan, create and edit a simple database for student management information using OpenOffice Base in a creative, innovative and ethical ways
 Plan the data structure for Student management information for each table (only use student name in    Student Table, but not others):
 Tables: Create table in Design view (4 separate tables
          o student table(use student ID as a Primary key)
          o parent table (use student ID as a Primary key)
          o curriculum table (use student ID as a Primary key)
          o co-curriculum table(use student ID as a Primary key)
 Tool->Relationship: Create relationships between tables by linking the student ID (That is why not to create student name for other tables except Student Table!)
 Use Wizard to Create Form:
           o Student Form
           o Parent Form
           o Curriculum Form
           o Co-curriculum Form
 Data entry using Form (Note: do not use table for data entry)
 Create several queries from the database
 Create reports based on the queries

Week 7(a) - Spreadsheet

For this week, we have to do two assignment which is 8(a) and 8(b)


for assignment 8a...

1. Plan, create and edit a simple  one year  personal financial management (income and spending)  spreadsheet using Calc .
2. Name the sheet  according to the month
3. Create a formula  to calculate  a  balance  for each month 
4. Link the formula between  the sheets.
5. Upload the file to google docs (spreadsheet) and edit it if necessary. 
6. Share with your lecturers

for assignment 8b....

we have to use the Microsoft Excel and use the function to create a student's score..

• o Define name
• o Fill Series
• o VLOOKUP
• o STDEV
• o AVERAGE
• o COUNTIF
• o Graph
• o Sort
• o Filter

Week 6 - Multimedia, Animation and Video

This week we were required to learn about the presentation skills from the link given...
below are the link that was given to me to study about the presentation skills:-

• http://www.microsoft.com/uk/atwork/work/presentation.mspx
• http://www.mindtools.com/pages/article/newCS_96.htm
• http://www.microsoft.com/atwork/skills/presentations.aspx

After that, we are needed to do a presentation using OpenOffice and PowerPoint.

After the presentation was completed, we were needed to publish a video based on our own topic...my topic was Learning About ICT...

And then, the video must be published and put it in the PowerPoint.

Week 5 - Graphic-DTP-Word Processor

We were required to into all different kind of image designing...
below are the types of the image designing

1. Learning about 2D graphic types: bitmap and vector images
2. Graphic/Image file format:
3. RGB & CYMK colour
4. Bitmap editor: Microsoft Paint / Paint Brush (no layer)
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 – use firefox or google chrome browser to open docs.google.com)
8. Vector-based drawing: OpenOffice.org Draw

Week 4 : Statistical Package for Social Science (SPSS )

On this week task, we were needed to record or analyze the data from the survey that we had done. To analyze the data, we're needed to download a software called SPSS. It's a software that can analyze or record the data from the survey easily and faster.

Below are the ways to collect data from the SPSS
1. 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.....)

2. Data Entry (for printed questionnaire) using Data View
3. In data view, Data -> Merge / import data from Online Questionnaire spreadsheet (make sure that   the variable is the same)
4. Run the analyze ->descriptive data: Frequencies
5. Output will be displayed in SPSS Viewer
6. The table and graph can be copied from SPSS Viewer to OpenOffice Writer for reporting.

Week 3(b) : Questionnaire using Survey Monkey and Google Docs spreadsheet

SURVEY MONKEY
Create a simple questionnaire with 10 questions only for a survey research on the same topic chosen in assigment 1 and 4 (use multiple choice - one answer)

Create a questionnaire (Pilot test)
1. Register – free sign-up at www.surveymonkey.com
2. Add questions (use multiple choise – one answer only)
3. Collect and analysis data online (pilot test – give the link to your coursemates)
4. Ask your classmate to comment or each question/item.

GOOGLE DOCS SPREADSHEET

Questionnaire design
1. Correct questions based on the feedback
2. Create demography and item/question in variety format – multiple choice, Checkboxes and scale (will be     used for coding purpose using SPSS)

Create Questionnaire using Google Document
1. Use gmail account
2. Open https://docs.google.com or click on documents if using gmail
3. Create New → Form
4. Add demography and item/question in variety format – multiple choice, Checkboxes and scale
5. Explore the use of function Save, open, edit form
6. Ask several coursemates to test the online questionnaire.
7. Explore the use of Spreadsheet for this online questionnaire and Download as Excel format (xls) ( this file will be imported in SPSS)
8. Correct the questions based on the feedback
9. Ask the students from other campus (IPG KS / IPG KDRI) to answer the survey.

Assignment 3 (a) : Report based on the 2nd week of class (Learning about ICT)

For this week, my pair (Suraj) and I were needed to do a report based on the topic that we do in 2nd week of class which is about the "Learning about ICT". But this time for the report, we were needed to make a report on what should be done in Malaysia based on our topic.

Firstly, we were needed to find reference for the report from Google Scholar, Google Books and 2 e-journal from UKM. After that, based on our reading and discussion from the reference, working pairs, we completed our report. The report should be done in OpenOfficeWriter.

After completing the report, I had attached it in my Yahoo Group so that my classmates can view it and maybe as a reference and knowledge for them.

You guys can check our report based on the Learning About ICT through here :
http://f1.grp.yahoofs.com/v1/gOQuThnukgBKQ5qCju1qvyKVD_7xDWA6oK2Cb0XCALjS_6EC0y_c_AiNdMowyIMy9HBh1BWeZkEQkmH22e3Qeg/report%20%28surajfadhli%29.pdf

3rd Week of Class

Course/Learning Management System (CMS/LMS)

For this week, my partner and I had done some research on CMS/LMS based on the task given. From what I understand, CMS/LMS worked as a portfolio. Besides that, the CMS/LMS is where the teachers or lecturers can monitor their students progress.

After done with the research about the CMS/LMS, we were needed to create a google document to type in the discussion that we had done earlier. After we had done editing the google doc, we're needed to attach it in our own yahoo groups. Lastly, we're needed to post it in our blog as a reflection based on the C/LMS topic.

Second Week of Class

Learning about ICT

For this week, we were needed to be in a pair to complete the assignment about the topic given by the coordinator. My pair was Surajwaran and we were given the topic about the "Learning about ICT".

       The early process of completing the task was by discussing the topic in the facebook group created by us earlier. Therefore, we begin our discussion by searching the information through the search engine and basically it's GOOGLE. As we'd googled it, we discussed our opinion and gave ideas in the facebook group.

Below is the results of our discussion about the "Learning about ICT".

Learning about ICT

1. Learning about Information and communication technologies is a way of familiarising students with the use and workings of computers. ICT demands multiple intelligence as it has been upgraded into many simulation games(example) to attract interactive learning through all senses.
2. "ICT" is used as a general term for all kinds of technologies which enable users to create, access and manipulate information. This explains that information technology and communications technology are combined to form ICT. it can be also categorised as a subject that needs to be studied or a tool that can be used to help or enhance certain work (support for traditional subject). ICT has contributed towards the elimination of language barriers. Examples of (ICT) tools are emails, instant messaging (IM), Chat rooms and social networking websites, such as Facebook and Twitter.
3. The tools of ICT such as emails, instant messaging (IM), chat rooms and social networking websites give a lot of advantages towards us. This tools enable us to connect with other friends, lecturers, and family more easier. For instance, we take Facebook as an example. In facebook, you can always post your messages anytime you want and it is limitless. All you need is internet connection or maybe by using your newly updated phone gadget. Thus, learning ICT and knowing how to use the tools gives a lot of advantages to us as students especially.
4. Furthermore, ICT is a tool for lifelong learning. As years goes by, our ICT is always developing towards a better future. As for that, you have to keep up to date with the development of the ICT so that you won't miss the newest ICT tools.

  REFERENCES:
http://en.wikipedia.org/wiki/Information_and_communication_technologies_in_education
http://www.ictlearning.com/
http://en.wikipedia.org/wiki/Information_and_communications_technology

      After a deep discussion about the learning about ICT, I could conclude that learning the function and availability of ICT is very important nowadays. From the discussion, I could list out all the ICT equipments that are very useful in the process of teaching and learning. Besides that, ICT is also important in connecting students with students and students with lecturers. Therefore, with the Facebook account that we had created, the emails and the Yahoo groups, it had enabled us to communicate with other classmates easily after the class hours. To conclude, learning about ICT is very important in our education development and it may enhance our education development faster.

First Week of Class

Activity that I needed to do

Register Official email

- create official google and yahoo account

- for each email account - put my own signature

        *my full name

        *program BEd TESL

        *Institution

- sent an ethical email to the coordinator and the lecturer of the subject

Register Official Facebook Account

-by using google or yahoo email

-add friend: -my classmates

                    -course lecturer

                    -course coordinator

-the username must be the same as the google or yahoo account

-include the facebook account into the email signature

Create facebook goup

-create facebook group with your name and set your group to close.

-invite my classmate, course lecturer and course coordinator

Join a yahoogroups

-Go to http://groups.yahoo.com/group/ge1155ipg/

  sign in using my yahoo account

-Ask to join the group and introduce myself

Create Yahoogroups for web portfolio(learning portfolio)

-Go to http://groups.yahoo.com and sign in using my yahoo official id

-name the group with matric number, my name and IPG

-set it to close group.

-invite course coordinator and course lecturer

-edit the email signature and put the group address (url)

Blog registration

-create a blog using google account

-edit email signature and put the blog address (url)

Reflection on the activity

          From my point of view, by completing the task that I had showed above, it helps me to know more on how to create emails, facebook account, yahoo groups and even this blog. Furthermore, by creating the emails and everything else, it eventually helps me on how to connect with my classmates, course lecturer and course coordinator easily without using any of my phone credit. It saved a bit on my expenditure on spending for my phone's topup.What a relieved!!!!

          To conclude, this task improve my knowledge on social networking. It really does help me spend my time more wisely!!!yeah!!!!