Cambridge IGCSE And O Level Computer Science 2nd Edition David Watson, Helen Williams - Solutions

The output X will have a value of 1 if any of the following combination of conditions occurs:• either rotation speed >= 1000 rpm and tilt angle • rotation speed = 150mW• tilt angle > - 30 deg and laser power b Draw a logic circuit to monitor the above system. Complete the truth table
A DVD recorder is protected by three sensors (S, T and P). The output from these sensors forms the inputs to a logic circuit. A certain combination of input values produces an output of 1 from the logic circuit. When this occurs a warning message is shown on the DVD display. The following table
A factory manufactures plastic pipes. It uses logic circuits to control the manufacturing process. a Consider the logic gate: Input A :D Input B -Output Complete the truth table for this logic gate. Input Input Output A B 0 0 0 1 1 0 1 1 b Consider the truth table: Input Input A B Output 0 0 0 0 1
a Write a logic expression for the truth table below.b Draw a logic circuit from the above truth table. X Y Z 0 0 1 0 1 0 1 0 1 1 1 0
The output, x will have a value of 1 if any of the following combination of conditions occur:>> either motor speed > 2000 rpm and bearing temperature > 90 deg * C>> or motor speed > or bearing temperature > 90°C and water velocity c = 5m / s a Design a logic circuit for the above scenario.b
A motor driving a water pump has a safety system which uses three inputs to a logic circuit. A certain combination of conditions results in an output, X, from the logic circuit being equal to 1. When the value of X-1 then the motor and pump are shut down. The following table shows which parameters
a Write a logic expression for the following logic circuit:b Draw a logic circuit which represents the following Boolean expression:X-NOT (A AND BORA AND NOT B c Complete the truth table for the following logic circuit: D x
Draw the logic circuits and complete the truth tables for the following logic or Boolean expressions:a XA OR B) OR (NOT A AND BI b Y(NOTA AND NOT BI AND (NOT B OR CI c T-1 if Iswitch Kis ON or switch Lis ONI OR (switch K is ON and switch M is OFF) OR Iswitch M is ONI d X-JA AND NOT BI OR (NOT B AND
a Write down a logic expression corresponding to the following truth table:b Show that the following logic expression produces the same output as your answer to part a above:(NOT A AND NOT B) OR (A AND NOT B) A B C X 0 0 0 1 0 0 1 1 0 1 0 0 0 1 1 0 1 0 0 1 1 0 1 1 1 1 0 0 1 0
A company that sells bicycles keeps records of the items in stock in a table, CYCLE, using a single-table database. For each model of bicycle, the following data is kept:-model number, for example: BY00007-description of model, for example: lady's shopper-colour of frame, for example: gold and
A motor car manufacturer offers various combinations of:>> seat colours>> seat materials>> car paint colours.A table, CAR, was set up as single-table database to help customers choose which seat and paint combinations were possible. (NOTE: N = no, not a possible combination, Y
A database of students is to be set up with the following fields:>> Family name>> Other names>> Student ID>> Date of Birth>> Date of Entry to School>> Current Class>> Current school year/grade>> Email address.a Select a data type for each field.b Which fields should be validated, and which fields
a Set up a cub scout database including appropriate validation checks for each field.Enter data for at least 10 records.b The cub scout leader wants to put each cub into a group called a 'six: each 'six can have up to six cubs in it and is given a name for example red, yellow, blue and green.Add a
Write down the output from this SQL query.SELECT HospitalNumber, FirstName, FamilyName, Consultant PROM PATIENT ORDER BY Consultant, Fanilywane:
1 Using the single table database PATIENT you have created.a Write an SQL query to count the number of patients in ward 7.b Write an SQL query to count the number of patients not in ward 7.
2 Write down the output from this SQL query.SELECT FirstName, FamilyName, BadNumber FROM PATIENT WHERE Wardlumbar 7
1 Using the single table database PATIENT you have created.a Write an SQL query to list all Mr Jones' patients.b Write an SQL query to list all the patients not in ward 6.c Write an SQL query to list all the patients who arrived on 12/11/2022.d Write an SQL query to list all the patients who
Choose suitable words/phrases from the following list to correctly complete the paragraph that follows: Word list: database fields records record table primary key data type validation text char Boolean field You will need to use some words more than once. A single contains one. Each
Write down four database data types. Describe each data type and give an example of a field where it would be a suitable choice.
Using Access for any other suitable database management softwarel, add the HospitalNumber field to the single table database PATIENT.>> Choose "text" as the data type for this field.>> Include validation checks to ensure that 8 characters must be entered starting with HN followed by 6 digits for
State what fields would you expect to find in each record for the doctor's appointments and give each field a suitable name.
Using Access for any other suitable database management softwarel, set up a single table database to store the PATIENT records using the fields given previously: FirstName, FamilyName, DateOfAdmission, Consultant, WardNumber. Bed Number. Choose a suitable data type for each field. Include
13 Use a trace table to test the program you have written in question 12.Data from in Questions 12You can become a member of the town guild if you meet all the following requirements:>>> aged between 18 and 65 >> you have lived in the town for 20 years or you have lived in the town for 5 years and
12 You can become a member of the town guild if you meet all the following requirements:>>> aged between 18 and 65>> you have lived in the town for 20 years or you have lived in the town for 5 years and both your parents still live in the town or one parent has died and the other parent still lives
11 Use a trace table to test the program you have written in question 10. [If you have used a real programming language to write your program then it is also good practice to run the program to test and help find errors.]
10 The one-dimensional array StaffName[] contains the names of the staff in a department. Another one-dimensional array StaffPhone[] contains the phone numbers for the members of staff. A final one-dimensional array Staffoffice[] contains the office location for the members of staff. The position
9 a Describe the purpose of each statement in this algorithm.b Identify, using pseudocode, another loop structure that the algorithm in part a could have used.c Write an algorithm, using pseudocode, to input a number between 0 and 100 inclusive. The algorithm should prompt for the input and output
8 A computer file, "Message.txt", stores a line of text. Write an algorithm in pseudocode to display this line of text.
7 A two-dimensional array stores the first name and family name of ten people.a Write a program in pseudocode to display the first name and family name of the ten people.b Extend your program to sort the ten names in order of family name before displaying the names.
6 Explain why programmers find library routines useful when writing programs. Include in your answer with two examples of library routines that programmers frequently use.
Programs can use both local and global variables.Describe, using examples, the difference between local and global variables.
Write a short pseudocode algorithm to input a password, check that it has exactly 8 characters in it, check that all the letters are upper case, and output the message "Password meets the rules" if both these conditions are true.
Programming concepts include:>> sequence>>> selection>>> iteration>> totalling>> counting.Describe each concept and provide an example of program code to show how it is used.
A programmer is writing a program that stores data about items stored in a warehouse. Suggest suitable meaningful names and data types for:>>> Item name>>> Manufacturer>> Description>>> Number in stock>>> Reorder level>>> Whether the item is on order or not.
1 Variables and constants are used for data storage in computer programs. Discuss the similarities and differences between these data stores.
Using pseudocode write an algorithm to copy a line of text from one text file to another text file.
Use the program written in your chosen programming language to write a line of text to a file and read it back from the file. Use the comments in the pseudocode to help you write comments to explain how the file handling works.
In your chosen programming language, write a program to declare and populate the array MyTable, as shown in Figure 8.11, using a nested FOR loop. MyTable First 27 31 17 element 19 57 48 36 98 29 42 22 95 16 35 61 rows 89 46 47 21 71 28 16 23 13 55 11 77 Last 34 76 21 element colurens Figure 8.11 A
In your chosen programming language write a short program to declare and populate the array MyList, as shown in Figure 8.10, using a FOR loop. Index mylist First 0 27 element 1 19 2 36 3 42 4 16 5 89 6 21 T 16 8 55 Last 72 element A Figure 8.10 A one-dimensional array
Check your last two programs and make sure they could be maintained by another programmer. Swap your program listing with another student and check that they can understand it.
Write and test a short program in your chosen programming language to:>> input two integers a and b and then find a MOD b and a DIV b>> create a random integer between 100 and 300.
Consider your program for Activity 8.13. State the variables that should be declared and used as local variables if procedures are used for>>The calculation of the highest, lowest, and average marks awarded for each subject>>The calculation of the highest, lowest, and average marks awarded for each
Write and test a short program for the sample algorithm in your chasen programming language.
Write an algorithm in pseudocode as a function, with a parameter, to convert a temperature from Celsius to Fahrenheit. Test your algorithm by writing a short program in your chosen programming language to define and use this function.
Extend your short program in your chosen programming language to define and use a procedure that accepts a parameter to write a given number of lines of stars. You will find the following commands useful:>> in Python>> Writeline in Visual Basic>> Printin in Java.
Write a short program in your chosen programming language to define and use a procedure to display three lines of stars.
When the single student program is working, extend your program to complete the task to calculate and output the largest, highest, lowest, and average marks for the whole class of 20 students.
When the single subject program is working, extend it to calculate and output largest, highest, lowest, and average marks for a single student with six subjects studied by a student.
In the high-level programming language that your school has chosen to use, use the pseudocode solution to help you to write and test a short program to calculate and output largest, highest, lowest and average marks for a single subject with five tests taken by a student.
In the high-level programming language that your school has chosen to use, write and test a short program to perform all these comparisons and output the results. Input two numbers, Number1 and Number2 Compare Number1 and Number2: -Output with a suitable message if both numbers are not equal
In the high-level programming language that your school has chosen to use, write and test a short program to perform all these mathematical operations and output the results: Input two numbers, Number1 and Number2 Calculate Number1 Calculate Number1 Calculate Number1 Number2 Number2 Number2
In the high-level programming language that your school has chosen to use, write and run a short program using a condition-controlled loop to allow the user to input the weight of sacks of rice and to count the number of sacks the user has input. When the user types in '-1' this should stop the
In the high-level programming language that your school has chosen to use, write and run two short programs, one using a count-controlled loop and the other a condition-controlled loop. They should each repeat ten times, incrementing the loop counter by three and outputting the value for each
In the high-level programming language that your school has chosen to use, write and run a short program to input a number and check if that number is equal to 1, 2, 3 or 4 using the CASE construct for alternative where appropriate).
In the high-level programming language that your school has chosen to use, write and run a short program to test if a number input is greater than or equal to 100 or less than 100.
In the high-level programming language that your school has chosen to use, write and run your own program that calculates and displays the volume of a cylinder.
In the high-level programming language that your school has chosen to use, write expressions that would store user inputs as the data types represented by the following:>>12>>12.00>> X>>> X marks the spot>>> TRUE.
In pseudocode and the high-level programming language that your school has chosen to use, declare the variables and constants you would use in an algorithm to find the volume of a cylinder.
Write and test the Hello World program in your chosen programming language.
Provide some more erroneous/abnormal data and its expected results.
Provide a more realistic set of test data and its expected result.
Explain why the following input data also needs to be verified:>>Entering a telephone number>> Entering a pupil's name>> Entering a part number in the form XXX999, when X must be a letter and 9 must be a digit.
Write an algorithm using pseudocode to check that the length of a password is between 8 and 12 characters inclusive.
Write an algorithm using pseudocode to check the age and height of a child who wants to go on a fairground ride. The age must be over 7 and under 12, the height must be over 110 centimetres and under 150 centimetres.
State, with reasons, which validation checks you could use for the following inputs.You may decide that more than one validation check is required.Entering a telephone number Entering a pupil's name-Entering a part number in the form XXX999, when X must be a letter and 9 must be a digit.
Have a look at the flowchart and pseudocode below:>> identify the purpose of the algorithm that they both represent>> identify the processes included in the algorithm.What would be output if the numbers 7 and 18 were input? START INPUT Nun1, Num2 INPUT Numl, Num2 IF Numl > Num2 THEN
Use a CASE statement to display the day of the week if the variable DAY has a whole number value between 1 and 7 inclusive and an error message otherwise.
Re-write the algorithm to check for a mark between 0 and 20 and a pass mark of 10.
What values will the following variables have after the assignments have been completed? Amount 100 TotalPrice Amount * 3.5 Discount +0.2 Final Price TotalPrice Total Price Discount - Name "Nikki" Message "Hello Name
Break down the 'Check time' sub-system from the smart phone alarm app into further sub-systems.
Using one of the computer systems that you identified, decompose it into its component parts of inputs, processes, outputs and storage.
Which computer terms are being described below?a Attachment to a robot arm which allows it to carry out a specific task, such as spray painting.b A kind of search engine used in an expert system which examines the knowledge base for information that matches the queries.c General name of any robotic
Six descriptions are shown on the left and six computer terms are shown on the right.By drawing lines, connect each description to its correct computer term. a form of Al which has been developed to mimic human knowledge and expertise a repository of facts and expertise in the form of a collection
a Give three characteristics needed to define a machine as a robot.b Robots can be described as dependent or independent.Explain what is meant by the two types of robot.
The following schematic shows how sensors, actuators and a computer can be used to control the opening and closing of doors in a train.As the train approaches a station and stops, the system automatically opens the doors. Passengers can then get on and off the train.After 30 seconds the computer
A computer has been designed to do a number of different tasks:control a process monitor a process (by taking data samples only)run an expert system.a The table below shows eight tasks which the computer could be carrying out. Tick() the appropriate box to show if the task is an example of control,
robot is being used to deliver the post around the headquarters of a large company, which is housed in a 20-storey building.The robot moves around the corridors picking up the post and delivering the post throughout the building. If a person comes close to the robot, it stops and waits until the
A company is developing a new game for a hand-held console:The console is moved in various directions to control movement and speed of a racing car on a television screen. Gear changes can be done using the LCD screen on the device itself.Name and describe which sensors would need to be used for
A distribution company has decided to automate its packaging and dispensing of items to online customers. The system is totally automated, where each required item is identified using barcodes. Once found, the item is packaged, an address label applied and then placed in a delivery van.a Describe
a Define the term machine learning.b Explain how machine learning and artificial intelligence (Al) differ.c Describe how a search engine might use machine learning to determine the most appropriate results based on a user's search criteria.
John has bought an expert system to help him find faults in computer systems.John has been asked to look at a computer that won't play music through some external speakers, attached to a computer using a USB port.• The music is stored in a file on the solid state drive (SSD).• The computer uses
Use words/phrases from the following list to complete the paragraph below:Word list:
Which computer terms, connected to Al, are being described below?a a repository of facts made up of a collection of objects and their attributes b informs the user of the reasoning behind the expert system's conclusions and recommended actions c made up of user interface and inference engine d a
Autonomous robots are used in space exploration and in undersea exploration.These robots have to either work in the near vacuum of space or the very high-water pressures under the oceans. They need to be equipped with many sensors and cameras to carry out their remote tasks.a Undersea robots are
4 Choose suitable words/phrases from the following list to correctly complete the paragraph that follows: Word list: actuators adaptive controller end-effectors environment intelligence microprocessor physical programs repetitive sensors system Robots can collect data from their surroundings by
3 Choose suitable words/phrases from the following list to correctly complete the paragraph that follows: Word list: activators actuators autonomous cameras lane assist Driverless cars are described as.. lasers light detection and ranging primary vision radar and ultrasonics sensors ; these
2 To be referred to as a robot, it needs to be demonstrated that it has the following three characteristics:ability to sense its surroundings-ability to move in some way a perceived intelligence.For each of these three characteristics, describe two features you could use to demonstrate that a
1 Write down four advantages and four disadvantages of using robots in the manufacturing industry.
Research five robots used as entertainment.a Give the names of these five robots.b Write down the advantages and disadvantages of the five robots you chose.
2 Five statements are shown on the left and five computer terms are shown on the right.By drawing lines, connect each description to its correct computer term. no direct human control and has the ability to carry out human activity totally on its own machine that requires human interface to operate
1 Describe three areas where robots can be used in agriculture to increase efficiency and reduce labour requirements.For each example, write down the advantages and disadvantages of using robots.
Look through all the notes on use of robots in agriculture, and make a table showing all the advantages and disadvantages of using robots.
2 The eight statements on the left-hand side of the table are either true or false. Tick (✔) the appropriate box to indicate which statements are true and which statements are false. Statement automated systems lead to less consistent results or less consistent products automated systems are more
a Name suitable sensors for each of the following automated systems.i Manufacture of a new vaccine that requires the mixing of four liquids in the ratio 1:2:3:4 as a single batch. The four liquids must be totally mixed and the temperature must be maintained at 35°C (+/-1°C) which is a critical
What are the advantages and disadvantages of using these immersive games consoles?Are any other sensors used in games consoles other than accelerometers and proximity sensors?
4 One example of an automated system is the control of entry and exit to a car park. Cameras take a photograph of a car's number plate on entry before opening a barrier. At the exit, another camera captures a car's number plate before raising the barrier. Describe how sensors, cameras, actuators
3 A new car being developed utilises many automated systems. In particular:i the ability to recognise road signs ii the ability to predict when to change to the correct gear for the road condition.Describe how sensors, actuators and an on-board computer allow the car to take the necessary action
2 A large greenhouse is being used to grow tomatoes under controlled conditions.For optimum growth, the tomatoes require the right lighting levels, correct temperature and regular watering. Describe how automated systems could be used to ensure the correct growing conditions are maintained. The
1 Describe how automated weather stations can be used in the fight against climate change.
Find out all of the advantages and disadvantages of using automated weather stations. Gather all the results from the whole class, and put your results into a table as follows: Advantages Disadvantages

Showing 1 - 100 of 1029

Cambridge IGCSE And O Level Computer Science 2nd Edition David Watson, Helen Williams - Solutions

Step by Step Answers