0417_s21_qp_12
A paper of Information and Communication Technology, 0417
Questions:
12
Year:
2021
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
11
Dwarf 0.401 N Haumea When Petr was designing his database, he had to set the data types for each field. Complete the design table below by filling in the data types for each named field. Use the most appropriate data type. Each data type must be different. For any numeric field, specify the type of number. Data type Field name Number_of_moons Orbital_period Rings Name_of_planet 1 2 Operators such as AND, OR, NOT, LIKE, >, >=, can be used to search Petr’s planet database. The search criteria for all the gas giant planets with more than 20 moons would look like this: Type_of_planet = ''Gas Giant'' AND Number_of_moons > 20 Write down the search criteria that will produce a list of planets that are not gas giants but have at least one moon and were first observed after 1800. Write down the names of the planets that are not gas giants but have at least one moon and were first observed after 1800. Petr has copied the data from the Orbital_period field into a spreadsheet. The data for the orbital period for Mars, 1.88, is stored in cell A2. In cell B2 he has entered a function of: ROUND(A2,0) Explain in detail the function used in cell B2. [Turn over 1 2
7. The systems life cycle  →  7.2. Design
Open
6
Humans can send unmanned aircraft into storms to collect wind speeds and temperature data. The unmanned aircraft have sensors attached to them which send the data back to computers at the weather station. The computers analyse the data. Previously the aircraft was manned and all the data was collected and flown back to the weather station. Discuss the advantages and disadvantages of using the unmanned aircraft rather than using the manned aircraft. 1 2 The owner of Tawara Hotels is planning a new computerised booking system. There are ten Tawara Hotels throughout the world. The current booking system allows people to book rooms in any of the Tawara Hotels. He has employed a systems analyst to research the current system and then install the new system. When analysing the current booking system, the systems analyst must identify the user requirements. Explain why it is important for the systems analyst to do this. Tick (✓) the relevant stage of the systems life cycle for each of the following activities. Evaluation (✓) Development and testing (✓) Analysis (✓) Activity Identifying the problems with the current system Comparing the solution with the original task requirements Create the file structure Identify limitations to the new system and improvements to be made [Turn over 1 2 Before the new booking system is installed, the systems analyst has to decide on a method of implementation. One method of implementation is pilot running. Name two other methods of implementation and describe two benefits of each. Name Benefit 1 Benefit 2 Name Benefit 1 Benefit 2 1 2
7. The systems life cycle  →  7.1. Analysis
7. The systems life cycle  →  7.6. Evaluation
Open
8
Students often use IT equipment; therefore it is important to have a good physical safety strategy. Evaluate your own use of IT equipment, in terms of physical safety, and describe the strategies you will need to minimise the potential physical safety risks. Describe two uses of a company intranet. [Turn over 1 2 Social networking is used to communicate with friends; this is one use of the internet. Describe four other uses of the internet. 1 2 A major part of the everyday use of the internet is social networking. Currently some social networks are not policed. The owners of a website have full discretion on what material is removed and what is allowed to be kept. Discuss the benefits and drawbacks of policing social networking sites. [Turn over 1 2
10. Communication  →  10.2. Effective use of the internet
8. Safety and security  →  8.2. eSafety
Open
12
A search engine can be used to find information on the internet. Describe the disadvantages of using a search engine to find information rather than typing in a web address. A student is writing a project on rare animals. He uses a search engine to find information about the animals from the internet. He is concerned about the reliability of some of the information he has found. Explain how he would evaluate the reliability of this information. [Turn over 1 2 The student plans to create a table, using word processing software, to display the information he has found out about the animal. The completed table will look like this: Tiger quoll Name of animal Dasyurus maculatus Scientific name No Pouched Australia Habitat Threatened Conservation status Explain how the student can create a table to enter this data. The student has saved a picture from the internet of a tiger quoll. Explain how he could create a new row above the Pouched row and place the picture into the right-hand cell of this new row. 1 2
10. Communication  →  10.2. Effective use of the internet
Open