0417_w16_qp_12
A paper of Information and Communication Technology, 0417
Questions:
17
Year:
2016
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
There are a number of different network devices associated with computers. Give the most appropriate type of communication device that fits the following descriptions. This device connects a LAN to the internet. This device transmits data to specific computers in a network. This device broadcasts data to all computers in a network. This device connects one LAN to another LAN that uses the same protocol.
4. Networks and the effects of using them  →  4.1. Networks
4. Networks and the effects of using them  →  4.2. Network issues and communication
Open
5
The directors of a multi-national car company need to communicate with each other. They have decided that the best way to do this is through web-conferencing. Describe web-conferencing and how it could be used in this scenario. The directors wish to have a conference with their managers in other countries and are considering the use of video-conferencing. Name three pieces of hardware that would be needed in order to hold a video-conference. Describe three drawbacks of setting up and using video-conferencing.
4. Networks and the effects of using them  →  4.2. Network issues and communication
6. ICT applications  →  6.1. Communication
Open
7
A teacher has produced a piece of software and uses it to record exam marks. Each exam has a total of 100 marks available. If a student does not take the examination then the mark awarded is 0. A B C D Name of Student Examination Mark Pass or Fail Candidate A Candidate B Candidate C Write a formula that would be entered in cell C3 to display the word pass if the value in B3 is more than 75 marks or the word fail if it is not. The teacher wishes to test a formula on the spreadsheet and uses normal, abnormal and extreme test data. Describe each of the following terms. Normal Test Data Abnormal Test Data Extreme Test Data
7. The systems life cycle  →  7.3. Development and testing
20. Spreadsheets  →  20.1. Create a data model
Open
10
Members of a US Conservation Unit recently discovered a species of frog new to New York. They identified the frog using an expert system called ARK. Describe how an expert system can be used to help identify a newly discovered type of animal. Identify two other applications which make use of expert systems. A developer has created a plan for a new database. Field Name Data Type Length of Field Comment Animal_ID Text 2 letters followed by a 3 digit number Name_of_animal Text Animal_endangered? Boolean Years_on_register Numeric For each named field, give an appropriate validation check the developer should use. Field Name Validation Check Animal_ID Name_of_animal Animal_endangered? Years_on_register A report is generated from the results. The report contains headers and footers. Explain, using examples, why headers and footers are used.
6. ICT applications  →  6.8. Expert systems
7. The systems life cycle  →  7.2. Design
Open
11
A manager of a computer store has created a relational database to keep track of its orders. She has created two tables that are linked together. Table A stores the products. Table B stores the order details. The following data shows some records from the database. Table A: products Product_ID Product_name Unit_price PC Base unit $300 Monitor TFT $250 Mouse $9 Keyboard $9 Laser printer $250 Table B: order details Order_ID Product_ordered Quantity Name the most suitable primary key in the products table. Name a suitable foreign key in the order details table. On the data shown in the tables above, the following search is to be carried out: (Unit_price>$250) Write down the Order_ID resulting from this search. On the data shown in the tables at the start of question 11, the following search is to be carried out: (Product_ID>2000) AND (Quantity The store has created a report with a new field called total_price to be calculated at run time. This field will contain the number of units ordered multiplied by the price of each unit. Write an expression to produce this result.
20. Spreadsheets  →  20.1. Create a data model
18. Databases  →  18.1. Create a database structure
Open