0417_s17_qp_13
A paper of Information and Communication Technology, 0417
Questions:
14
Year:
2017
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
4
Different terms are used in document production. Complete the following sentences. The unit used to measure the size of a font is called A page can be portrait or landscape. This is called The special margin that is placed at the top or edge to clear the text from the fold in a page is called the When the first line of a paragraph appears as the last line of a page this is called [Turn over 1 1
13. Layout  →  13.3. Headers and footers
17. Document production  →  17.1. Document layout
14. Styles  →  14.1. Style management
Open
5
People can manage their bank accounts in different ways. One way is telephone banking. A person wishes to use telephone banking without speaking to an operator to transfer money from one bank account to another. Describe the steps needed to do this. When a debit card is read by computer, data on the card can be used for transactions. List four items of data found on a debit card which can be read by computer. 1 1
6. ICT applications  →  6.6. Banking applications
8. Safety and security  →  8.3. Security of data
Open
6
Midwest School library has a database system. Students who borrow books present their library cards containing their details. The librarian wishes to improve security by introducing biometric methods. Name two direct input methods the cards could use. Give two examples of biometric input. Name and describe in detail the files the library database system would use. [Turn over 1 1 The fields date_borrowed and date_due_back are contained in the database. The date_due_back field is calculated from the date_borrowed field. The student can borrow a book for 14 days. Write a formula for the calculated field date_due_back.
8. Safety and security  →  8.3. Security of data
6. ICT applications  →  6.10. Recognition systems
Open
7
A school is creating a spreadsheet as a method of recording academic performance of students in IGCSE Geography. The spreadsheet lists each student’s name and their target level. The levels range from 1 to 9, where 9 is the best level. Teachers enter the current working level. If the working level is the same or better than target level then ‘‘well done’’ is displayed in the comment cell, otherwise ‘‘needs improvement’’ is displayed. A B C F D E G Name Frances Peter Target Level Working Level Comment Brown Smith Write a formula for cell E2 to automatically display ‘‘needs improvement’’ or ‘‘well done’’. 1 1 The school is going to use the data from the spreadsheet in its reports to parents. The school plans to mail merge the report with the data. Describe four advantages of using mail merge. The teacher needs to check the data source and template before the data is merged. Describe three checks that need to be done. [Turn over 1 1
20. Spreadsheets  →  20.1. Create a data model
18. Databases  →  18.3. Present data
Open
8
A club is setting up a database to store details of its members. Complete the data dictionary of the database, adding the most appropriate data type for each field. Data type Field name Number Membership_number Member_name Boolean Membership_fee_paid Telephone_number Expiry_date_of_membership Membership_fee_amount The club secretary wishes to find all the junior members who have paid their membership fee which would be less than $100. He searches for these members by typing in the following search criteria. Membership_fee_amount 1 1 Discuss the benefits and drawbacks of storing membership details on a computer database.
18. Databases  →  18.1. Create a database structure
7. The systems life cycle  →  7.2. Design
Open
10
Using computers can cause problems for the health and safety of users. Evaluate your own use of computers in terms of health. Include any strategies you have devised. Name three safety issues associated with your use of computers. For each issue describe a way of minimising the risk. 1 1
5. The effects of using IT  →  5.2. Potential health problems related to the prolonged use of IT equipment
10. Communication  →  10.2. Effective use of the internet
8. Safety and security  →  8.1. Physical safety
Open
13
Key-loggers are thought to be security risks but they can be used to monitor and track the use of employees on a computer system. Describe how a key-logger monitors computer usage. A small minority of employees in a company have been using the computers for non-business use, so the company has had to introduce other methods of monitoring their use of ICT. Apart from key-logging list three other ways that employees could be monitored in their use of ICT. 1 1
8. Safety and security  →  8.3. Security of data
10. Communication  →  10.2. Effective use of the internet
Open