YEAR 10 ICT TIME: 1h 30min
[Pages:12]DEPARTMENT FOR CURRICULUM, RESEARCH, INNOVATION AND LIFELONG LEARNING Directorate for Learning and Assessment Programmes Educational Assessment Unit
Annual Examinations for Secondary Schools 2018
YEAR 10
ICT
TIME: 1h 30min
Name: _____________________________________
Class: _______________
Answer ALL questions. Questions 1 to 4 are about Computer Essentials 1. Label the following software as Operating System or Application Software
[10 marks] 2. Using some of the above software titles complete the following exercise:
i. A program used to analyse and summarise numerical data:
ii. A program used to send instant messages:
iii.
A program used to organise and manage large quantities of data:
iv.
A program used to create slides to be displayed to a group of people:
v. A program used to create and edit documents:
vi. A program used to send electronic messages:
[6 marks]
ICT ? Year 10 ? 2018
Page 1 of 12
3. When users buy software they are duty bound to use it according to the conditions set out in the EULA.
a. What does the abbreviation EULA stand for?
________________________________________________________________. [1 mark]
b. Match the following types of licences to the descriptions listed below:
Shareware
Propriety
Open Source
Freeware
Trial Version
i.
The rights of the software are owned by an individual or business, usually a software developer.
The programmer creates a program and makes it available for others to use without cost. Other ii. programmers are also free to modify the source code and redistribute the modifications to users and developer community.
iii. Try before you buy software.
A free of charge software on which the author retains iv. the copyright. Usually, the author allows people to use
the software, but not sell it.
A free of charge copyrighted software, but which v. requires users to make a contribution in order to receive
technical help, documentation or upgrades.
[5 marks]
4. A network consists of a group of computers and other peripherals connected to each other.
List two important purposes of a network:
i. ________________________________________________________________
ii. ________________________________________________________________ [2 marks]
ICT ? Year 10 ? 2018
Page 2 of 12
5. Use the following terms to fill in the blanks:
wireless Kbps
data transfer rate
uploading
ISPs Intranet
instant messaging downloading
VoIP VPNs
i. _________________________ is an Internet service that enables you to communicate using voice with another person/s.
ii. An _________________________ is a website accessible only by the organisation's members, employees or other people with authorisation.
iii. A private network that uses the Internet to connect remote sites or users together. Businesses often use it to communicate across multiple locations
iv. The _________________________ is commonly used to measure how fast data is transferred from one location to another.
v. ________________________ are companies that provide Internet service to users and other companies.
vi. _________________________ is an Internet service that enables communication using text with another person/s. The communication is real time using text instead of voice.
vii. The transmission speed of data is calculated in _________________________.
viii. _________________________ refers to the transfer of data from a local computer to a server.
ix. Students can get past-papers and other files from their respective school website. This transfer of data from a server to a local computer is referred to as _________________________.
x. _________________________ networks must be protected using a password.
[10 marks]
ICT ? Year 10 ? 2018
Page 3 of 12
6. Answer the following questions: a. The phone line can be used for broadband connection. List two (2) different
options for connecting to the Internet i. _____________________________ ii. ________________________________
b. Apart from download speed, list two (2) more important considerations when selecting an Internet service/subscription
i. _____________________________ ii. ________________________________
c. It is important that passwords are not shared with friends. List two (2) more good password policies
i. _____________________________ ii. ________________________________
d. Some type of software required frequent updating. List two (2) such software which needs to be updated regularly
i. _____________________________ ii. ________________________________
e. All computer users should be aware of environmental friendly guidelines related to the use of computing facilities. List two (2) energy-saving practices
i. ________________________________________________________________ ii. ________________________________________________________________
f. In terms of computers and printers, list two (2) items that can be recycled i. _____________________________ ii. ________________________________
g. People with special needs make use of specific hardware and software to help them work on a computer. List one (1) option which can help improve accessibility
i. ________________________________________________________________
[1 mark each ? 13 marks]
ICT ? Year 10 ? 2018
Page 4 of 12
The following questions are about spreadsheets 7. Look carefully at the diagram below, and answer the following question:
The manager of a company is working out the wages of his employees. If an employee works for more than 40 hours a week, he/she is entitled to overtime. Write down the function, the manager should use in cell H3, to output "Overtime" or "No overtime" accordingly.
____________________________________________________________________ [5 marks]
8. Write True or False next to the following statements about Microsoft Excel.
i. A filename can include a number as part of the name. ii. A number of workbooks grouped together form a worksheet. iii. To select adjacent cells you should use the SHIFT key. iv. To modify the User Preferences, you must click on File, Options. v. A Microsoft Excel file can only be saved as an Excel file.
True or False [5 marks]
ICT ? Year 10 ? 2018
Page 5 of 12
9. Consider the spreadsheet below. John is using it to keep track of his savings in Euro. He input the data in Euro. He is using currency conversion to US Dollars and Pound Sterling. Before finishing his spreadsheet, John experimented a bit with the formulas used. Underline the correct answer.
a) In cell D5, he used the formula =B5*E1, and he obtained: i. #REF! ii. 149.50 iii. #VALUE!
b) In cell C5, he used the formula: i. =B5 * D2 ii. =B5 x D2 iii. =B5 * B6
c) While working with CHF (Swiss Francs), he used the formula =B5/F2, and he obtained: i. #REF! ii. #DIV/0! iii. #NAME?
d) By mistake, John deleted column E, and all the values in cells D5 to D8, turned to: i. #REF! ii. #DIV/0! iii. #NAME?
e) In cell E5, John typed the following formula =B5*CHF and he obtained: i. #REF! ii. #DIV/0! iii. #NAME?
[5 marks]
ICT ? Year 10 ? 2018
Page 6 of 12
10. Write the correct letter from the diagram below to match the following statements:
Statement
i. Used to write the title at the centre of a number of cells.
ii. Used to change the colour of a cell background.
iii. Used to change the orientation of the text in a cell.
iv. Used to indicate a currency.
v. Used to copy the text formatting from one cell to another.
vi. Used to move the content of a cell to another cell.
vii. Used to change the colour of the text.
viii.
Used to format the text so that it can be displayed on more then one line in a cell if needed.
ix. Used to separate thousands with a symbol.
x. Used to decrease the number of decimal places.
Button Letter
[10 marks]
ICT ? Year 10 ? 2018
Page 7 of 12
11. Consider the following spreadsheet
Write down the formula that should be written in cell:
i. E3 ii. F3 iii. B8 iv. B9 v. G3
[10 marks]
ICT ? Year 10 ? 2018
Page 8 of 12
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- year 10 ict time 1h 30min
- grade 10 november 2018 economics p2 awsum school news
- sample question paper subject information and communication technology
- second term test 2015 grade 10 english language
- provincial north second term test 2018 science i minister of education
- provincial second term test 2018 minister of education
- provincial education north western province third term test 2018
- provincial north western province second term test 2018 mathematics i
- 2nd term test 2018 english literature minister of education
- sabaragamuwa provincial department of education m
Related searches
- 10 year fixed mortgage calculator
- today s 10 year mortgage rates
- best time of year to buy car
- real time 10 year treasury yield
- selective service 1h classification
- part time jobs for 17 year olds
- best time of year for car deals
- best time of year to buy toyota
- best time of year to buy electronics
- time 2020 year in review
- 10 years experience or 10 year experience
- best time of year to cruise alaska