9618/11 · Oct/Nov 2023
Download PDFDraw one line from each vector graphic term to its most appropriate description. Term: - drawing list - drawing object - property Description: - a component created using a formula - defines one characteristic of a component - data required to create all components in the graphic
State what is meant by the bit depth of a bitmap image and explain how changing the bit depth affects the image. Definition Explanation
Explain why a bitmap image is often compressed before it is attached to an email.
A school has a Local Area Network (LAN).
The LAN connects to the internet using a router. Describe the function of a router in a network.
Complete the following table by writing the purpose of each of these other hardware devices used to support the LAN. Hardware device | Purpose switch | Wireless Access Point (WAP) | bridge |
The students can save their school files on a public cloud. Identify two drawbacks of the students storing their files on the public cloud. 1 2
A new classroom is being set up with 20 computers and a switch. Explain one advantage of implementing a star topology instead of a bus topology in the new classroom.
A shop manager has designed a relational database to store customer orders. The database will have the following tables: CUSTOMER(CustomerID, FirstName, LastName, Town) SHOP_ORDER(OrderNo, CustomerID, OrderDate) SUPPLIER(SupplierID, EmailAddress, TelephoneNumber) ITEM(ItemNumber, SupplierID, Description, Price) ORDER_ITEM(ItemNumber, OrderNo, Quantity)
Complete the entity-relationship (E-R) diagram for the relational database.
Identify three advantages of a relational database compared to a file-based approach. 1 2 3
Write a Structured Query Language (SQL) script to define the database called SHOP.
Write the SQL script to return the total quantity of items that the customer with the ID of HJ231 has ordered.
Complete the truth table for the logic expression: A | B | C | Working space | X 0 | 0 | 0 | | 0 | 0 | 1 | | 0 | 1 | 0 | | 0 | 1 | 1 | | 1 | 0 | 0 | | 1 | 0 | 1 | | 1 | 1 | 0 | | 1 | 1 | 1 | |
Draw a logic circuit for the logic expression:
The Central Processing Unit (CPU) of the basic Von Neumann model for a computer system contains several special purpose registers.
The Memory Data Register (MDR), Index Register (IX) and the Accumulator (ACC) are examples of special purpose registers. Identify two other special purpose registers and state their role in the CPU. Special purpose register 1 Role Special purpose register 2 Role
Describe what is meant by the Immediate Access Store (IAS) in a computer system.
A computer has a single 2.1GHz CPU. Describe how increasing the clock speed to 4GHz can increase the performance of the computer.
A second computer has a CPU with two 2.1GHz cores. Explain why the second computer does not always run twice as fast as the computer with one 2.1GHz CPU.
A programmer uses both a compiler and an interpreter to translate a program written in a high-level language.
Describe the advantages of using the interpreter compared to the compiler to translate the program.
State one reason why some high-level languages are partially compiled and partially interpreted.
Identify two features that support the visual presentation of the code in a typical Integrated Development Environment (IDE). 1 2
Identify two features that support the debugging of the code in a typical IDE. 1 2
Describe the principal operations of a 3D printer.
Describe the purpose of a temperature sensor within the 3D printer.
A 3D printer contains 1 GB of Dynamic RAM (DRAM) to store print data. State two advantages of the printer having Dynamic RAM instead of Static RAM (SRAM). 1 2






Identify the purpose of the first pass of a two-pass assembler.
The following table shows part of the instruction set for a processor. The processor has two registers, the Accumulator (ACC) and the Index Register (IX). Instruction | Explanation Opcode | Operand | LDR | #n | Immediate addressing. Load the number n to IX STO | <address> | Store contents of ACC at the given address ADD | <address> | Add the contents of the given address to the ACC INC | <register> | Add 1 to the contents of the register (ACC or IX) CMP | #n | Compare the contents of ACC with number n JPE | <address> | Following a compare instruction, jump to <address> if the compare was True OUT | | Output to the screen the character whose ASCII value is stored in ACC <address> can be an absolute or symbolic address # denotes a denary number, e.g. #123 Give one example of an instruction that belongs to each of the following instruction groups. Only use the instructions given in the table. Each instruction must have a suitable operand. Data movement Arithmetic operation Conditional instruction
The instruction LDR #2 uses immediate addressing. Give one similarity and one difference between direct addressing and indexed addressing. Similarity Difference
Identify one other mode of addressing.
The following table shows another part of the instruction set for the same processor. Instruction | Explanation Opcode | Operand | AND | Bn | Bitwise AND operation of the contents of ACC with the operand XOR | Bn | Bitwise XOR operation of the contents of ACC with the operand LSR | #n | Bits in ACC are shifted logically n places to the right. Zeros are introduced on the left hand end # denotes a denary number, e.g. #123 B denotes a binary number, e.g. B01001101 The current contents of the ACC are: 0 1 0 0 1 1 1 1 Show the contents of the ACC after the execution of the following instruction. AND B10100101
The current contents of the ACC are: 0 0 0 1 0 1 1 1 Show the contents of the ACC after the execution of the following instruction. LSR #3
The current contents of the ACC are: 1 1 1 1 0 1 1 1 Show the contents of the ACC after the execution of the following instruction. XOR B00100101
Explain the importance of feedback in a control system.
Give one example of an embedded system and explain why it is an example of an embedded system. Example Explanation






