Premium Essay

Ict Paper 3

In:

Submitted By khaled96
Words 2408
Pages 10
UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
International General Certificate of Secondary Education
INFORMATION TECHNOLOGY

0418/03

Paper 3: Practical Test
Specimen Paper 2007
2 hours and 30 minutes
Additional Materials: Candidate Source Files

READ THESE INSTRUCTIONS FIRST
Make sure that your name, Centre number and candidate number are printed on each page that you are asked to produce.
Carry out every instruction in each task.
Tasks are numbered on the left hand side of the page, so that you can see what to do, step by step. On the right hand side of the page for each task, you will find a box which you can tick (√) when you have completed the task; this checklist will help you to track your progress through the assignment.
Before each printout you should proof-read the document to make sure that you have followed all instructions carefully.
At the end of the assignment put all your printouts into the Assessment Record Folder.

This document consists of 8 printed pages.
© UCLES 2005

[Turn over

2

You work for a company called Rootrainer Trees. You are going to perform some clerical tasks for this company. All currency values should be in UK pounds (sterling) with the £ sign visible.

1

Using a suitable software package, load the file TREES.CSV

2

In the Species column use a lookup function to show the full species name, use the Code column for the lookup value and the file CODE.CSV for the array.
Replicate this formula so that the complete species name for each tree is shown.

3

Enter the following data into the model
PH
Acid
Alkaline
Neutral

4

Species

Weighting
1.27
0.928
1

Name the cell containing 1.27 acid
Name the cell containing 0.928 alkaline
Name the cell containing 1 neutral

5

Format these three cells to 1 decimal place.

6

Use a Countif function in cell B2, to

Similar Documents

Premium Essay

Computer Industry

...Management Does ICT influence supply chain management and performance?: A review of surveybased research Xuan Zhang Dirk Pieter van Donk Taco van der Vaart Article information: To cite this document: Xuan Zhang Dirk Pieter van Donk Taco van der Vaart, (2011),"Does ICT influence supply chain management and performance?", International Journal of Operations & Production Management, Vol. 31 Iss 11 pp. 1215 - 1247 Permanent link to this document: http://dx.doi.org/10.1108/01443571111178501 Downloaded on: 17 March 2015, At: 16:56 (PT) References: this document contains references to 123 other documents. To copy this document: permissions@emeraldinsight.com The fulltext of this document has been downloaded 3145 times since 2011* Downloaded by AFRICA UNIVERSITY At 16:56 17 March 2015 (PT) Users who downloaded this article also downloaded: Pietro Evangelista, Edward Sweeney, (2006),"Technology usage in the supply chain: the case of small 3PLs", The International Journal of Logistics Management, Vol. 17 Iss 1 pp. 55-74 http:// dx.doi.org/10.1108/09574090610663437 Dirk Pieter van Donk, (2008),"Challenges in relating supply chain management and information and communication technology: An introduction", International Journal of Operations & Production Management, Vol. 28 Iss 4 pp. 308-312 http://dx.doi.org/10.1108/01443570810861534 Benita M. Beamon, (1999),"Measuring supply chain performance", International Journal of Operations & Production Management, Vol. 19 Iss 3 pp. 275-292...

Words: 15971 - Pages: 64

Free Essay

Ict in Service Delievry

...Communication Technology (Ict) Compliant Librarians On Library Services Delivery In Academic Library: The Case Of National Open University Of Nigeria(Noun)Library By Nebeolise, Lucy Ndidiamaka National Open University of Nigeria,Victoria Island , Lagos -----------------------------------------------------ABSTRACT----------------------------------------------------- The study aimed at examining the impact of information and communication Technology (ICT) compliant librarians on library services delivery on NOUN library. The paper traces briefly the history of National Open University Library. The e-resources, staff strengths are highlighted. The study adopted the descriptive survey method. The questionnaire was used as instrument for data collection. A total of fifty (50) questionnaires were distributed and collected back. The data collected were analyzed with the use of tables and simple percentages. From the analysis of the data collected, it was found that the use of ICT compliant librarians on library service delivery aids immensely in the development of NOUN library, quick delivery of information services, access and easy retrieval of information by users. The study shows thatInadequate ICT skilled professional Librarians, Inadequate provision of ICT training programmes, Inadequate Power supply and inadequate ICT infrastructures hinder the effective use of ICTs in NOUN library. Therefore...

Words: 4437 - Pages: 18

Free Essay

A Leader

...56, 7, 1-17 ICT BARRIERS AND CRITICAL SUCCESS FACTORS IN DEVELOPING COUNTRIES Almamy Touray Department of Computer Science and Information Systems, University of Jyväskylä, Mattilanniemi, Agora, 40351 Jyväskylä, Finland almamy.2.touray@jyu.fi Airi Salminen Department of Computer Science and Information Systems, University of Jyväskylä, Mattilanniemi, Agora, 40351 Jyväskylä, Finland airi.salminen@jyu.fi Anja Mursu Salivirta & Partners, Kauppakatu 28, 40100 Jyväskylä, Finland Anja.Mursu@salivirta.fi ABSTRACT Since the early 1990s, Information and Communication Technology (ICT) has been perceived as a catalyst for development. However, the UNICEF State of the World’s Children Report 2011 acknowledges that the poor in many developing countries remain largely excluded from ICT and its benefits. This paper aims to address three issues. Firstly, identify ICT barriers in the literature from 2000 to 2011. Secondly, identify ICT barriers through empirical findings and thirdly, categorize these barriers into critical success factors. These aims are achieved by comparing the findings in the literature to our recent empirical results. Two methodologies are used in this study, namely, a systematic literature review and a case study; the empirical data for our case study was collected from The Gambia in autumn of 2012. The systematic literature review covers 1107 studies (2000-2011) published in the top five ranked ICT4D journals in terms of journal citation ranking. The paper identifies a...

Words: 7224 - Pages: 29

Premium Essay

Effects of Information and Communication Technology (Ict) on Social Science Research Han Ping Fung

...No.1, pp 1-8,October, 2013 AFRICA DEVELOPMENT AND RESOURCES RESEARCH INSTITUTE (ADRRI) JOURNAL ADRRI JOURNAL (www.adrri.org) ISSN: 2343-6662 VOL. I, No.1, pp 1-8,October, 2013 Effects of Information and Communication Technology (ICT) on Social Science Research Han Ping FUNG1,* 1 Technology Consulting, Hewlett-Packard, Kuala Lumpur, Malaysia *Han Ping FUNG (Email: corresponding han-ping.fung@hp.com) Abstract As more and more ICT tools being developed and used in social science research, it is a good idea to reflect how ICT had effects on social science research as a whole as there is a lacking of such study. This study is underpinned on and concurred with DeLone & McLean’s (1992, 2003) Information Systems (IS) Success Model in which ICT had effects on productivity of social science researchers. This study is based on participative observation approach in which ICT had effects on social science research in the following three ICT application areas: a) Pre-data analysis, b) Data analysis, and c) Post-data analysis. These three ICT application areas had improved a researcher’s productivity in terms of speed, quantity, quality, complexity as well as cost perspective is also discussed. Some concerns of using ICT are also included in this paper which encompasses: a) High learning curve, b) Revised expectation on researcher, c) Research by the convenient of big data, and d) Decrease of social skills of researcher. Limitation, recommendation for future works and conclusion are...

Words: 6420 - Pages: 26

Premium Essay

Cloroxbrita

...Cloud Computing Strategy required? .......................... 7 1.2 Objective .............................................................................................................................. 9 1.3 Audience .............................................................................................................................. 9 2. What is Cloud Computing? ...................................................................................................... 10 2.1 Types of Cloud Computing................................................................................................. 12 2.2 Cloud Service Capability .................................................................................................... 13 3. Potential Risks and Issues of Cloud Computing ...................................................................... 14 4. Potential Business Benefits of Cloud Computing for Australian Government Agencies ........ 17 5. Potential Opportunities of Cloud Computing for Australian Government Agencies .............. 19 6. Australian Government Cloud Computing Policy ................................................................... 21 6.1 Policy Statement ................................................................................................................ 21 6.2 Vision ................................................................................................................................. 21 6.3 Key Drivers for Adoption...

Words: 801 - Pages: 4

Premium Essay

Deloen and Maclain

...articles: 1. Examining the critical success factors of Mobile website adoption (Tao Zhou, 2010): Purpose: The purpose of this research is to examine the critical success factors of mobile website adoption. General view: The paper is talking about the information systems success theory proposes the system quality and information quality affect users usage and satisfaction with information systems, further determining organizational performance (D&M) service quality. The new model argues that system quality, information quality and service quality affect usage and user satisfaction, further affecting net benefits such as increased knowledge sharing and lower costs. Also the case is talking about the TAM and the trust concepts. So the system quality here reflects the stability, navigation and layout of mobile sites. Mobile service providers need to rely on a reliable and well designed interface to deliver ubiquitous information and services to users. The Hypothesis that the author has indicated in this research are: 1. H1: system quality, information quality and service quality significantly affect perceived ease of use. 2. H2: system quality, Information quality and Service quality significantly affect perceived usefulness. 3. H3: System quality, Information quality and Service quality significantly affect user trust. 4. H4: perceived ease of use significantly affect perceived usefulness. 5. H5: Trust significantly affect’s perceived usefulness...

Words: 4787 - Pages: 20

Premium Essay

Parental Involvements: This Is a General Term That Denotes the Participation of Parents in Academic Success of Their Children. It Is the Amount of Support That a Student Expects to Get from Parents During the Time When

...relating to ICT and attainment A review of the research literature relating to ICT and attainment A report to the DfES by: Editors: Margaret Cox and Chris Abbott; Authors: Margaret Cox, Chris Abbott, Mary Webb, Barry Blakeley, Tony Beauchamp and Valerie Rhodes; Project Administrator: Montanut Turnbull; Project Consultant: Deryn Watson All members of the project team are based in the Department of Education and Professional Studies at King’s College London. Acknowledgements The project team wishes to acknowledge the support of Becta (the British Educational Communications and Technology Agency) for initiating and funding this project on behalf of the Department for Education and Skills (DfES), and the ongoing advice, encouragement and support which we have received, in particular from Malcolm Hunt, Head of Evidence and Research, Becta, and from Andrew Jones and Michael Harris, Education Officers, Becta. The team would also like to acknowledge the support and advice received from academic and administrative colleagues at King’s College London and at the University of Leeds. Version 1, January 2004 © Becta 2004 http://www.becta.org.uk page 1 of 58 Becta | A review of the research literature relating to ICT and attainment Contents Executive Summary 1 2 3 4 Introduction Evidence of the effects of ICT on attainment Factors affecting attainment Research methods to measure ICT and attainment 4 4 7 8 Main Report 1 2 3 4 4.1 4...

Words: 37424 - Pages: 150

Premium Essay

Ict in Education

...APPLICATION OF ICT IN EDUCATION We are living in a constantly evolving digital world. ICT has an impact on nearly every aspect of our lives - from working to socialising, learning to playing. The digital age has transformed the way young people communicate, network, seek help, access information and learn. We must recognise that young people are now an online population and access is through a variety of means such as computers, TV and mobile phones.  The developments in the use of the electronic media have influenced all walks of life. Education is no exception to this. The use of computers and the internet for enhancing the quality of education by making learning more relevant to life has been seen as an ideal by educational institutions. The citizens of tomorrow who are our students now are going to live in the age of the electronic media. How are we preparing them for the same? Are we giving them technology based Education? Are we giving them exposure to the use of computers and the itnernet? Have we integrated the ICT into classroom processes? What are the efforts made by the department in this direction? What does policy say about ICT in Education? There are several such questions which we need to probe into. An understanding of these issues will enable us to use the ICT more meaningfully in Education. Information and Communication Technologies have recently gained groundswell of interest. It is a significant research area for many scholars around the globe...

Words: 5037 - Pages: 21

Free Essay

Business Intelligence

...ICT IN ADMINISTRATION 1 ICT IN ADMINISTRATION ICT IN ADMINISTRATION AND IMPLICATIONS ANTHONY K MUKUCHE D61/69173/2013 UNIVERSITY OF NAIROBI ICT IN ADMINISTRATION 2 LITERATURE REVIEW Introduction The study reviews relevant literature in the area of ICT in government administration. It will discuss the concept of ICT, in the day to day running of activities in government departments and the advantages of using it. RESEARCH METHODOLOGY Introduction This chapter describes the methods that will be used in the collection of data pertinent in answering the research questions. It is divided into research design, population and sampling design, data collection methods and data analysis methods. Target Population and sample Size The target population will be all the employees of government. Employees in government are quite a number to get feedback from. The sample size will be 50 – 100 employees of government. Data Collection Primary data will be gathered directly from respondents and for this study; the researcher used a questionnaire. The questionnaire will consisting of close and open-ended questions. The questionnaire consisted of two sections. Data Processing and Analysis Data analysis is the whole process, which starts immediately after data collection and ends at the point of interpretation and processing data. The researcher will peruse the completed research instruments and document analysis-recording sheets. ICT IN ADMINISTRATION 3 ...

Words: 2237 - Pages: 9

Premium Essay

The Importance Of ICT

...technology than any previous generation. This shows that younger generations tend to use the ICT since it is almost everywhere. Malaysia implemented the first computer system in 1966 and since then, the Government has introduced various initiatives to facilitate the greater adoption and diffusion of ICT to improve capacities in every field of business, industry, education, and life in general, and the Ministry of Education is attempting to reduce the digital divide that exists in the different parts of the country (Chan, 2002). In order to reduce the digital divide, there are several initiatives taken, including to make the full use of libraries, since it holds the roles of information centers where people come to fulfill their information needs. In order to support the country’s ICT...

Words: 1379 - Pages: 6

Premium Essay

Absolutism and Relativism

...AQA AS Level ICT Course Handbook Contents 1: Introduction. 3 2: Code of Conduct 3 3: Resources 5 4: Homework 5 5: Contact Details 5 6: Course Structure 5 8: Monitoring Your Own Progress 6 9: Coursework Assignments 7 1: Introduction. Welcome to AS Level ICT. Please keep this handbook at the beginning of your ICT folder. What is the aim of this course? Information Technologies are now widely used in all aspects of government, business, education, leisure and the home. In an increasingly technological age, a study of Advanced Information Technology and particularly how computers are used in the solution of a variety of problems, is not only valuable to the students themselves but also essential to the future well being of the country. The course aims to provide students with knowledge and understanding in areas including: • An understanding of the nature of information, its structure, application and implications of its   uses.      • An awareness of the role of IT in the management, manipulation and dissemination of   information.       • An understanding of the role of people, technology and systems in   organisations.                                 • An awareness of the economic, social and ethical implications of the use of IT systems. • An understanding of the range of applications and information systems...

Words: 2055 - Pages: 9

Premium Essay

Business Ethics

...Project Paper The Role of Cultural Values in Business Ethics: the case of ICT companies Muhammad Fikri Bin Ahmad (1022133) (Email:fikriahmad91@gmail.com) Mohamad Amali Bin Maulan (1013901) (Email: aku_amali@yahoo.com) Muhammad Muslim Bin Samsudin(1012545) (Email: aim_messi@yahoo.com) Tengku Muhammad Ihsan bin Tengku Hishamuddin (1027923) (Email: ihsan_libra@hotmail.com) MGT 3020 Business Ethics Section 1 IIUM Gombak 15th June 2011 The Role of Cultural Values in Business Ethics: the case of ICT companies Tengku Muhammad Ihsan Bin Tengku Hishamuddin, Mohamad Amali bin Maulan, Muhammad Muslim Bin Samsudin, Muhammad Fikri Bin Ahmad Kuliyyah of Economics And Management Sciences, International Islamic University Malaysia, Gombak, Malaysia. ABSTRACT Purpose-This paper aims to obtain views in ICT company regarding the role of cultural values in company performance in terms of customer satisfaction, skills in solving problems and capability in adopting new technologies and its influence to people behavior in terms of innovativeness and motivation. This paper also contributes to the discussion of cultural values in business ethics. Methodology-Data are collected through one on one interviewing process with 15 managers. Findings-The two main findings are firstly identified the moderating effects association between cultures in Malaysia with ICT company performance in terms of profit, customer satisfaction and capability in solving problems and adopting...

Words: 6332 - Pages: 26

Free Essay

Women Affair.Pdf

...WOMEN DEVELOPMENT AND NATIONAL POLICY ON WOMEN IN NIGERIA Olubunmi Aderemi Sokefun Abstract This paper discusses the document on women in Nigeria (National Policy on Women). Several past administrations in this country have treated women issues and affairs with calculated levity: Carefully side - tracking or blatantly refusing to accord it the necessary attention. It is now a thing to gladden the hearts of all women of Nigeria that, "after four attempts by four former heads of Nigeria's Government," Chief Obasanjo's administration finally granted government recognition to women's issues in this country. The official document .on Human Rights' issues as it relates to Nigerian women; this document is known as the NATIONAL POLICY ON WOMEN. This paper therefore focuses on the document which promises to bring delight to the heart of every woman in this country. Introduction When late Mrs. Olufunmilayo Ransome Kuti joined the vanguard team as the only nationalist and activist during the early struggle for Nigerian independence, hardly did .anybody realize then that she had a dream, a clear vision of a future Nigerian woman, that vision was crystal clear in her heart, and like a pivot, it stood firmly on three stand posts-known today as women's rights, women emancipation and women empowerment.. . Mrs. Olufunmilayo Ransome-Kuti later joined by some educated women of like minds, fought daringly and relentlessly for these three .pivotal goals of women emergency and relevance in the socio-political...

Words: 71889 - Pages: 288

Free Essay

Ict in Tourism Industry

...and Communication Technologies in Tourism Agenda 1. 1.1 ICT and tourism – introduction Tourism as information business 1.2 2. 2.1 2.2 2.3 2.4 2.5 eTourism – ICT usage in tourism ICT usage in tourism – overview and case studies Tourism stakeholders and interfaces Tourism suppliers and eTourism Intermediaries and eTourism Destination organisations and eTourism Tourism management and eTourism 3. 3.0 3.1 3.2 3.3 3.4 3.5 3.6 3.7 Trends and future applications Social Media & Web 2.0 Website optimisation Interoperability and semantic web Software agents Recommender systems Dynamic packaging Mobile services & ambient intelligence Online auctions in tourism 2 ICT in Tourism © copyright IFITT 1.2 eTourism – ICT usage in tourism Definition and history of eTourism Facts & trends Reasons, advantages and implications of ICT usage ECCA – eTourism Competence Center Austria 3 ICT in Tourism © copyright IFITT 1.2 eTourism – ICT usage in tourism Definition and history of eTourism Facts & trends Reasons, advantages and implications of ICT usage ECCA – eTourism Competence Center Austria 4 ICT in Tourism © copyright IFITT Introduction - ICT ICT - Information and Communication Technologies Umbrella term for technological developments for the Production, analysis, storage, search, distribution and use of information ICT includes a combination of hardware software telecommunications netware groupware humanware ICT enables effective data processing & communication for organisational...

Words: 2278 - Pages: 10

Premium Essay

Role of Ict in Flattening World

...2 ICTs AND GLOBAL WORKING IN A NON-FLAT WORLD Geoff Walsham Judge Business School University of Cambridge Cambridge, U.K. Abstract This paper rejects the hypothesis of Thomas Friedman that ICT-enabled globalization is driving us toward a flat world. Instead, it is argued that the world remains uneven, full of seams, culturally heterogeneous, locally specific, inequitable, not well-integrated and constantly changing. This argument is supported by an analysis of three areas of ICT-enabled global working, namely global software outsourcing, global IS roll-out, and global virtual teams. The paper then builds on these analyses to put forward an agenda for future IS research on ICTs and global working based on three research themes: identity and cross-cultural working; globalization, localization and standardization; and power, knowledge, and control. The paper concludes that the area of ICTs and global working offers the IS field a major research opportunity to make a significant contribution to our understanding of a set of crucial issues in our more globalized world. Flat world, globalization, global software outsourcing, global IS roll-out, global virtual teams, IS research agenda, identity, cross-cultural working, standardization, power, knowledge, control Keywords 1 INTRODUCTION The changes taking place in the global economy, including those in the burgeoning services component, are the subject of much debate by a wide range of commentators including journalists, practitioners...

Words: 6849 - Pages: 28