Search this site

    SPM COUNTDOWN

    192days until
    SPM 2014

    Meet Your Teacher

    STUDENTS' PRODUCT

    ICT QUESTIONNAIRE

    PENDAFTARAN AHLI

    COUNTER

    COURSEWORK ASSESSMENT F5

    LA6.S13.1 Find Out Current Developments In Computer Information Systems.

    posted Feb 2, 2012, 4:39 PM by ict smkbkk   [ updated Feb 2, 2012, 4:49 PM ]



    Criteria:
    1. Define web-based application.
    2. Give an example of web-based application.
    3. State the function of the application.
    4. Name a programming language used to develop web-based application.
    5. Name a DBMS used in web-based application.
    6. State an advantage of web-based application compared to non web-based application.
    7. State a vulnerability of web-based application.
    8. State source of reference.

    LA6.S12.1 Develop A Database Project

    posted Jul 21, 2011, 6:15 PM by ict smkbkk


    Criteria:
    1. State the project title and the objective(s) of the project.
    2. Create all the required tables.
    a. Name each table.
    b. State the field names for each table.
    c. State the primary key(s).
    d. Relate the tables.
    Draw a line to show the relationship.
    3. Create a form for each table.
    4. Enter data into the tables.
    5. Create a query from two tables.
    6. Create a report based on the query created.
    7. Submit the report form and
    a soft copy of the developed database project.

    Sample Questions LA6.S12.1

    SITUATION 1
    Pn. Saripah has problem in preparing a list of students who are taking part in the sports day events based on their houses and age categories. As an ICT student, you are asked by Pn. Saripah to develop an Annual Sports Day Information System (ASDIS) to assist her in preparing the list.
    In the system, you are required to:
    (a) create a database that consist of two tables, namely table STUDENT and table SPORTS_HOUSE. The database should store student ID, name, gender, sports house and age category.
    (b) enter at least four sports houses into the HOUSE table.
    (c) enter at least two participants’ data for each age category of different houses.
    (d) create a query that links the two tables.
    (e) create a form based on the query in (d). The form must show the title given and descriptive labels.
    (f) create a report based on the query in (d). The report must show the participants for each category of different sports houses.
    Complete the RF.CW.LA6.S12.1 form. Submit the RF.CW.LA6.S12.1 form and the soft copy of the information system to your teacher at the end of the assessment session.

    SITUATION 2
    The form teachers of your school are required to submit a report on the monthly test results of each student to the school administration. As an ICT student, you are asked to develop a Test Marks Information System (TMIS) to assist the teachers in recording the subject marks obtained by each student. TIMS should generate a report to show the subject marks, total marks and average marks of the students from each class.
    In the system, you are required to:
    (a) create a database that consist of two tables, namely table STUDENT and table CLASS. The database should store student ID, name, class, form teacher and marks for each subject taken.
    (b) enter at least four classes into the CLASS table.
    (c) enter at least two students’ data for each class.
    (d) create a query that links the two tables. The query should be able to calculate the total marks and average marks for each student automatically.
    (e) create a form based on the query in (d). The form must show the title given and descriptive labels.
    (f) create a report based on the query in (d). The report must show the subject marks, total marks and average marks of the students from each class.
    Complete the RF.CW.LA6.S12.1 form. Submit the RF.CW.LA6.S12.1 form and the soft copy of the information system to your teacher at the end of the assessment session.

    SITUATION 3
    Bestari Computer Center (BCC) deals with computer sales and services. The BCC owner faces difficulties in tracking its business services. You are asked to help the owner to develop a computerized management system called Bestari Information System (BIS).
    In the system, you are required to:
    (a) create a database that consist of two tables, namely table CUSTOMER and table SERVICE The database should store customer ID, customer name, customer address, customer telephone number, date of service, description of service.
    (b) enter at least four records into the CUSTOMER table.
    (c) enter at least six records into the SERVICE table.
    (d) create a query that links the two tables.
    (e) create a form based on the query in (d). The form must show the title given and descriptive labels.
    (f) create a report based on the query in (d). The report must show the service record for each customer.
    Complete the RF.CW.LA6.S12.1 form. Submit the RF.CW.LA6.S12.1 form and the soft copy of the information system to your teacher at the end of the assessment session.

    LA5.S11.1 Find Out The Latest Programming Languages

    posted Jul 21, 2011, 6:09 PM by ict smkbkk




    Criteria:
    1. Identify and name the two latest programming languages
    2. Identify and state
    a. the developer
    b. when it was developed
    c. purpose (why it was introduced)/application
    d. platform
    e. approach (structured/ objectoriented/ etc)
    f. translator used
    3. State the source of reference.

    LA5.S10.1 Apply Program Development Phases To Develop A Problem-Solving Program

    posted Jul 21, 2011, 5:47 PM by ict smkbkk   [ updated Jul 21, 2011, 6:07 PM ]

        

    Criteria:
    1.  Problem Analysis
        a. write problem statement
        b. List all required input items
        c.  Write the expected output
        d. Write the formula to be used
    2.  Program Design
        a. Write the pseudocode OR Draw the flowchart
        b. Sketch the user interface design for input
        c. Sketch the user interface design for output 
    3.  Coding
        a. Develop interface based on the design in 2(b) and 2(c)
        b. Submit a softcopy of the program. Write the name and location of saved program.
    4.  Testing and Debugging
        a. State the test data used for each input item listed in 1(b)
        b. Write the output based on 4(a)
        c. Compile the program. Write down the name of executable file.
    5. Documentation
        - submit report (RF.CW.LA5.S10.1)

    Sample Questions LA5.S10.1
    1. Indra Sdn. Bhd. is a company that manages the parking lots at Bukit Puteri Resort. Vehicles parked are charged based on the following :
    a. 1st half hour : RM0.20
    b. 2nd half hour : RM0.50
    c. subsequent half hour : RM0.80
    To improve the efficiency at the payment counters, you are asked by Indra Sdn Bhd to develop a program to calculate the total parking charges based on the time of entry and time of departure of each vehicle.

    2. Happy Supermarket will be holding an annual sale in two-month time. Discount will be given to customers based on the amount they spent. The discount is as given in the following table.
    Amount Spent (RM)           Entitled Discount
    100 to 200                                   5 %
    More than 200 to 400                  10 %
    More than 400                            15 %
    Your task is to build a program to calculate the amount of money the customer has to pay after discount. The program will display the amount spent by the customer, percentage discount given, the actual discount and the amount to be paid.

    3. A book salesman at Syarikat Blue East will receive a basic pay of RM500.00 per month. Based on the sale, they will get commission on number of books sold. The commission is based on Table 2:
    Number of books sold         Commission (RM) per book
    200 and below
     First 100 books                        0.20       
     Subsequent 100 books             0.30
    More than 200                             0.35
    According to the number of book sold, you are request to develop a program to calculate the salary for each salesman.

    4. Write a simple program to calculate the area of a triangle. Your program should allow the user to key in the length and height of the triangle. Use a formula to calculate and display the area of the triangle.

    5. Write a simple program to calculate the area of a circle. Your program should allow the user to key in the radius of the circle. Use a formula to calculate and display the area of the circle.

    6. Write a simple program to calculate the area of a rectangle. Your program should allow the user to key in the length and width of the rectangle. Use a formula to calculate and display the area of the rectangle.

    7. Write a simple program to calculate the volume of a pyramid. Your program should allow the user to key in the length, width and height of the pyramid. Use a formula to calculate and display the volume of the pyramid.

    8. Write a simple program to calculate the volume of a sphere. Your program should allow the user to key in the radius of the sphere. Use a formula to calculate and display the volume of the sphere.

    9. Write a simple program to calculate the volume of a cuboids. Your program should allow the user to key in the length, width and height of the cuboids. Use a formula to calculate and display the volume of the cuboids.

    10. Write a program to find the total and average of three numbers.

    11. Write a program to find the total, difference and average of two numbers.

    12. Write a program to calculate the price of an item after discount. The user will key in the price and percentage discount. The program will calculate and display the discount given and the actual amount to be paid.

    13. Write a program to calculate the price of an item after discount. The user will key in the price and percentage discount. The program will calculate and display the actual amount to be paid.

    14. Write a program to calculate the body mass index (BMI). The user will key in the weight and height of a person. The program will display the BMI and whether the person is underweight, normal, overweight or obese.

    15. Write a program to calculate the body mass index (BMI). The user will key in the weight and height of a person. The program will display the BMI.

    16. Write a program to allow a user to guess a hidden number by entering any number. The program will inform the user if the number entered is greater than, less than or equals to the hidden number.

    LA4.S09.1 Gather Examples of Immersive Multimedia In Education, Business or Entertainment

    posted Jul 21, 2011, 5:30 PM by ict smkbkk   [ updated Mar 2, 2012, 6:27 AM ]

    CRITERIA:

    1. Front cover includes
        a. topic
        b. name of candidate
    2. Scrapbook contains at least SIX pages excluding front and back covers.
    3. Collections are relevant to the topic chosen.
    4. State source and/or date in the scrapbook.
    5. Submit RF.CW.LA4.S09.1


    Candidate compiles articles, pictures, drawings from different types of sources such as newspapers, magazines, internet. etc into a scrapbook based on any of the following:
     Immersive Multimedia in Education
     Immersive Multimedia in Business
     Immersive Multimedia in Entertainment
    Scrapbook must be done individually.


    Examples:
    Immersive Multimedia In Entertainment




    Augmented Reality (AR) is a growing area in virtual reality research as it can generate a composite view for the user. It is a combination of the real scene viewed by the user and a virtual scene generated by the computer that augments the scene with additional information. Although the similarities with traditional VR practices remain the same, the way users interact within an Augmented Virtual Environment alters. Several applications (including surgery, robotics, engineering and design, Entertainment, mechanical maintenance and repair, collaborative planning, etc.) have aroused. 

    LA4.S08.1 Apply All The Phases Of Multimedia Production To Produce An Interactive Educational Multimedia Project.

    posted Jul 21, 2011, 5:14 PM by ict smkbkk   [ updated Mar 7, 2012, 7:17 AM ]



      


    CRITERIA:
    1. Analysis Phase 
    Write the project title, objective(s) and target audience.
    2. Design Phase
    Sketch storyboard.
    3. Implementation Phase
    Develop a multimedia project based on the storyboard using an authoring tool, web editor or presentation software.
    Write the name of the tools used.
    4. Testing Phase
    Test the developed multimedia product.
    Complete the checklist.

    The multimedia product must be interactive, educational and include all five multimedia elements. Choose any topic from any subjects taught in school: 
     ICT
     Bahasa Malaysia
     Bahasa Inggeris
     Mathematics
     Science, etc

    1-6 of 6