Session 66 (4 April 2013)

byte - a collection of bits

field - a unit of data consist of one or more character (byte)

record - a collection of related fields

file - a collection of related record

Database - a structured collection of information

DBMS - a program that accesses information from a database.

Benefits of using database

• minimise data redundancy
• data integrity is assured
• allow the sharing of data / data can be shared
• information can be accessed easily

Session 65 (2 April 2013)

We have to send Lesson Plan for Area 6 before tomorrow night.

The due date for Learning Outcomes for Area 6 is 2 May 2013.

Microsoft Access - Database Program

DBMS (Database Management System)
- to process data inside the database

Data
- raw material
- not organised, little value
- text, numbers, images, audio and video

Information - organised and valuable

Information System - a set of related components that collects data, processes data and provides information.

Education

• keep track of students statistics and grades
• help teachers and students in online learning and discussing

Business

• carry out online buying and selling
• help plan the delivery of goods and services
• make room bookings and for checking the best rates

Management

• see employee records
• analyse products, services and product prices
• process customer orders, organise product

Information System Components

- data

- hardware

- software

- people

- procedure

Management Information System (MIS) - to provide regular information

Session 64 (21 March 2013)

Mr. Z want us to e-mail the visual basic assignment in .exe by 28 March 2013.

Program analysis - Review and define the problem

Program Design
- top-down design module
- pseudo code
- flow chart

The due date for Learning Outcomes is on 2 April 2013.

Session 63 (19 March 2013)

Basic elements in programming

• Constants
• Variables
• Data Types
• Operators
• Control sturctures

Pseudo Code

- text only sentences that describe the logic and program flow of a computer program

- can personalised the code

Flow chart

- terminator

- input/output

- process

- decision

- arrow

Session 62 (12 March 2013)

Today we did our multimedia presentation in class.

Session 61 (28 February 2013)

A computer program - a series of organised instructions that directs a computer to perform task

Programming - creation of a set of commands or instruction

Programming language - a set of words, symbols and codes that enables humans to communicate with computers

Examples of programming language:

• BASIC (Beginner's All Purpose Symbolic Instruction)
• Pascal
• C
• C++
• Smalltalk

Low-level programming language:

• 1st Generation
• 2nd Generation

High-level programming language:

• 3rd Generation
• 4th Generation
• 5th Generation

1st Generation (1GL)

- machine language

- written in binary code

- each statement corresponds to each other

2nd Generation (2GL)

- assembly language

- symbolic instruction codes

- assembler - a program that translate assembly language into machine language

3rd Generation (3GL)

- procedural language

- English-like words

- compiler or interpreter - translate the high-level programer into machine language

4th Generation (4GL)

- non-procedural language

- enables user to access data in a database

- examples: SQL, NOMAD, FOCUS

5th Generation (5GL)

- visual programming language

- natural language

- example: Prolog, Mercury

Object-Oriented Programming: Java, Visual, C++

Session 60 (7 February 2013)

We passed up our LO to teacher today.

Teacher also had check our scrapbook and multimedia project.