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.