AS Computing

"Explain the benefits and drawbacks of team working compared to an individual working alone."

In many projects, it is important that people work together to achieve a common goal. The new design for a computer system may include people working in teams

• listen to other people's ideas.
• share your ideas with others.
• help other members of the team.
• interact with others - ask questions and generally communicate
• respect other people's ideas

Validation


Task 1

Set up the following validation in the example database (shared area 'Validation')

Firstname -    Length check -     10 characters maximum
Surname -      Presence check - Required
Data Joined - Range check -      between 01/01/09 & 31/12/10
Supervisor -  Existence check - must exist in Employee table



Task 2

Complete the design sheet for the product table


Task 3

1. Validation routines are used to improve the quality of data input. Identify three types of validation routine that might be used and explain what type of errors they are designed to trap. (6)

2. When entering your email address onto a form on a website
how does it automatically verify that you have entered a correct email address? (1)

DBMS





Task 1

Use the handout provided to make a presentation clearly describing what a DBMS is and what its functions are.

You should be able to describe the processes involved in a variety of different applications of computers in society.

A Health Service Information System

 

SLC Theory notes


Task 1


Complete the worksheet 'Theory Notes Task' in the Revision Folder


Task 2


Use the Connectives task to practice extending exam answers

Networks Hardware

Task 1

Use the above information to form the basis of a mind map covering those aspects of computer networks.
Bubble.us
 The link below takes you to the network theory mini site.
Network Theory


Task 2

Using the "Wi-fi Networks task" in the shared area - there is a link in the document to a news story. Answer the questions on the sheet.
(Networks folder)

"Describe the use made of contemporary protocols including HTTP, FTP, SMTP, VoIP and wireless communication protocols."

Task 1

Complete the following table:


Task 2

Wireless Communication Website

Describe the advantages and disadvantages of each of the following:

• Infra red
• Fibre optic
• Laser
• Bluetooth
• Wireless

Learn all of the above terms for next lesson - you will need to know them in an exam.

Handshaking is when signals are exchanged between devices to establish whether they are ready to send or recieve data. For example Bluetooth or PC to printer.

Transmission modes

Simplex	Data is transmitted in one direction only
Half duplex	Data can be transmitted in both directions but only one direction at a time
Duplex	Data can be transmitted in both directions simultaneously

An example of simplex transmission is TELETEXT where data is transmitted to the television receiver but there is no way to transfer data in the other direction.

An example of half duplex is a CB radio system where each handset can be set to send mode or receive mode.

An example of Duplex transmission is a telephone call where both users can speak and be heard at the same time.

General purpose packages, wordprocessor and desk top publisher, spreadsheets, databases and integration with other packages.

Task 1

Chapter 23 and 24 Bradley

Read the chapters thoroughly then answer the self test questions on pages 93 and 97.

Read the example exam questions and answers carefully.

Task 1

News stories research. Use the link on the worksheet in the shared area to write an essay style answer based on the points made on the worksheet.

NB there will be at least one essay style quesiton on paper CG1.

Task 2

Go to the Gone Phishing worksheet, watch the video and answer the questions.