Week 15 (Reflection) 22 May 2013

          Today is our last lesson where we get to learn about form, query, report and relationship.
The form will help us save a lot of time when entering data into the table. Below are the step in producing Form:

     (a) Select the table you want to use as a form.
     (b) Choose Create - Forms - Form
     (c) Sort Field in the desired order by dragging to a specific part.
     (d) Column size can be changed at will.
     (e) Assign a name to the Form and Save.


          Query displays the results of collection of raw data before we generate the report. Below are the step in producing Query:

 

     (a) Choose Create - Query Wizard
     (b) Then select Simple Query Wizard - ok
     (c) Select fields that are involved in queries such as Title, Author, Publisher, Year Published,
           etc. to be displayed in the Query. Field also choose from different Table.
     (d) Click Next. Name Query created. Click Finish.
     (e) Query finished created for reference.

 

          The report is to display the database reports that had been produced. Below are the step in creating Report:

     (a) Select Table to be used in the Report. Choose Create - Report.
     (b) Report can be formatted according to the requirements.

Week 14 (Reflection) 15 May 2013

          Today we get to learn about the data management. Data management enable us to have a systemeatic, no duplication and easy to be access. A database management system is a program could enable computer users create and access data in the database.

DBMS   DBMS = database management system (database software) is a software system designed to allow the definition, creation, querying, update, and administration of databases.


a) advantages of DBMS
1) Warehouse of Information
2) Defining Attributes
3) Systematic Storage
4) Changes to Schema
5) No language dependence
6) Table Joins
7) Multiple Simultaneous Usage
8) Data Security
9) Privileges
10) Abstract View of Data and Easy Retrieval
11) Data Consistency

Designing Databases
The three principal logical databases models are Hierarchical, network and relational.

Hierarchical data model

Network Data Model

Relational data model

Week 13 (Reflection) 7 May 2013

        Today, Mr. Razak guide us doing the database using the Microsoft Office Access. Uisng the cataloging information we had collected through out the semester, we key-in all the information into the table.  Next, Mr. Razak teached us how to do using the Microsoft Office Access for the relationship between two tables.    

Week 12 (Reflection) 1 May 2013

       Today is a labour day and also Malaysia public holiday. Although this week we no need to attend to the lecture, but we still go on with our cataloging in UTM. We need to do so due to the we need the cataloging information to do the database.

Week 11 (Reflection) 24 April 2013

        Through the online learning, Mr. Razak had teached us how to do database and we do it hands on after the lecture given by Mr. Razak.

        A collecton of data that had been store in the computer is called as database. Database is a very useful tools where we can access and analyze easily when we need to do so. We had been told to do some hands on activity by using the SMM such as student's name, student's identification number, student's parent name and excetera.

        We also get to learn about that microsoft office access is a database application where we can run a reports with large amount of data. Mr. Razak teached us how to enter data into forms and tables, running quesries for data in order to produce report.

        Before we end our lecture, Mr. Razak remind us to do database using the cataloging we had done throughout the semester.
       

                   

Week 10 (Reflection) 17 April 2013

     In this week, we continue our learning on the cataloging topic. Summary regarding the LCC and DDC were being given by Mr. Abd Razak. We were being asked to pass up the critical writing with the topic as stated below:

Kenapa DDC digunakan di perpustakaan sekolah rendah manakala

 LCC digunakan di perpustakaan university ?

Buku-buku di perpustakaan dikelas dan dikatalogkan dengan tujuan untuk memudahkan pengguna perpustakaan mencari dan menggunakan buku-buku secara mudah. Jika dalam keadaan di mana jumlah buku adalah sikit, pengguna-pengguna buku boleh mencarinya terus di perpustakaan. Tetapi, jika bilangan buku semakin bertambah banyak, jika pengkelasan dan pengkatalogan buku tidak diadakan, ia akan menyusahkan pengguna untuk mencari buku yang berkenaan. Perkhidmatan yang cekap dapat disediakan kepada pengguna dengan adanya sistem pengelasan dan pengkatalogan ini.

Koleksi-koleksi di Perpustakaan Dato’ Jaafar Hassan menggunakan dua sistem pengkelasan nombor buku iaitu: Library of Congress Classification (LCC) yang menggunakan abjad A hingga Z; Dewey Decimal Classification (DDC) yang bermula dengan angka 000 hingga 999.

       Dari segi saiz, LCC adalah lebih besar dari segi kelas, di mana kelasnya adalah lebih luas dengan subkategori yang lebih kecil. Walaupun subkelas LCC adalah lebih kecil tetapi ia adalah lebih khusus. Dalam sistem pengkelasan DDC, 10 kelas subjek telah dipecahkan kepada 10 bahagian yang kemudiannya dipecahkan kepada 10 subdivisi.

       Manakala dari segi struktur, LCC mempunyai kelas yang terus berkembang dan dikemaskini secara bebas oleh pakar-pakar dalam bidang yang berkaitan. Manakala DDC mempunyai prinsip-prinsip yang menyeluruh dengan pembahagian perpuluhan dan catatan mnemonik dari segi struktur.

       Dari indeks relatif, DDC dapat membawa semua topik bersama-sama, manakala LCC tidak boleh membawa semua topik bersama-sama. DDC boleh dibahagikan secara konsisten dengan menggunakan kategori dan sub-klasifikasi manakala LCC tidak dibahagikan secara konsisten. Kelebihan ini telah menyebabkan DDC digunakan secara meluas di perpustakaan awam dan perpustakaan sekolah, manakala LCC digunakan di kolej dan universiti.

       Sistem pengkelasan Dewey tidak dapat membahagikan bahan-bahan bagi subjek-subjek baru. Kekangan lain ialah nombor panggilan yang panjang dan sistem perpuluhan Dewey yang menyebabkan kerumitan atau kesusahan dalam mengenalpasti sumber di perpustakaan. Bagi sistem pengkelasan LCC pula, penciptaannya adalah berdasarkan perpustakaan tunggal dan sistem surat-nombor pengenalan adalah susah.

Akhirnya, DDC adalah lebih sesuai untuk digunakan di sekolah rendah, manakala LCC adalah lebih sesuai digunakan di perpustakaan akademik universiti.

 

 

 

Bahan rujukan:

http://ipislam.edu.my/kplir/su_sin-perpustakaan/kertas%20kerja%20katalog.htm

 

http://perlis.uitm.edu.my/library/index.php?option=com_content&view=article&id=84&Itemid=79

     After that, he also asked us to do cataloging for the preparation of database. Below is the homework that had been done by me during the hands-on activity doing the cataloging in the thesis resource centre.

19)
005.133        Larry, Long
  LAR                    Pengaturcaraan basic / Larry Long ; Penterjemah Subariah Ibrahim. - Skudai:
                     UTM, 1998.

                              xii, 164p. : ill. ; 25cm.

                              mengandungi indeks.

                              ISBN 983-52-0114-5

                              1. BASIC (Computer program language)               I. Subariah Ibrahim             
                              II. Judul


20)
302.545       A Razak Bin A Karim
  ABD                   Isolasi (Pengasingan Diri) dalam kalangan pengetua sekolah menengah negeri
                    Johor / A Razak Bin A Karim .- Skudai : UTM, 2012. [Tesis tidak diterbitkan].

                              xvi, 119p. : ill. ; 30cm.

                              mengandungi bibilografi

                              Tesis Sarjana Pendidikan (Pengurusan dan Pentadbiran).

                              1. Alienation                                   I. Judul


21)
                    Chen, Kean Fah.
                              Penglibatan dalam tuisyen swasta dalam kalangan pelajar sekolah SJKC daerah
                    Kulaijaya / Chen, Kean Fah - Skudai, Johor : UTM, 2012. [Tesis tidak diterbitkan].

                              xix, 128p. : ill. ; 30cm.

                              mengandungi bibliografi

                              Tesis Sarjana Pendidikan (Pengurusan dan Pentadbiran).

                              1.                                                     I. Judul
                                  




                    

 

Week 9 (Reflection) 10 April 2013

Semester break