A Level Computer Science 9618 Paper 11, Oct/Nov 2023

Question paper and mark scheme75 marks9 questions

Solve it on ExamPal

Practise

Untimed. Write on the paper and check as you go.

Start

Exam

Timed, with a clock you set, like sitting the real paper.

Start

Opens full screen.

Papers open in

Opening the question paper

Read as textThe questions and the mark scheme as plain text. Easier to read on a phone.

Question paper

9618/11 · Oct/Nov 2023

Download PDF
1
a

Draw 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

[2]
b

State what is meant by the bit depth of a bitmap image and explain how changing the bit depth affects the image. Definition Explanation

[3]
c

Explain why a bitmap image is often compressed before it is attached to an email.

[2]
2

A school has a Local Area Network (LAN).

a

The LAN connects to the internet using a router. Describe the function of a router in a network.

[3]
b

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 |

[3]
c

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

[2]
d

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.

[2]
3

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)

a

Complete the entity-relationship (E-R) diagram for the relational database.

[3]
b

Identify three advantages of a relational database compared to a file-based approach. 1 2 3

[3]
c(i)

Write a Structured Query Language (SQL) script to define the database called SHOP.

[1]
c(ii)

Write the SQL script to return the total quantity of items that the customer with the ID of HJ231 has ordered.

[4]
4
a

Complete the truth table for the logic expression: X=NOT (A NAND B) XOR (NOT B AND (B NOR C)) 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 | |

[2]
b

Draw a logic circuit for the logic expression: X=(A AND NOT (B OR C)) AND (B NOR C)

[2]
5

The Central Processing Unit (CPU) of the basic Von Neumann model for a computer system contains several special purpose registers.

a

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

[4]
b

Describe what is meant by the Immediate Access Store (IAS) in a computer system.

[2]
c(i)

A computer has a single 2.1GHz CPU. Describe how increasing the clock speed to 4GHz can increase the performance of the computer.

[1]
c(ii)

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.

[5]
6

A programmer uses both a compiler and an interpreter to translate a program written in a high-level language.

a

Describe the advantages of using the interpreter compared to the compiler to translate the program.

[4]
b

State one reason why some high-level languages are partially compiled and partially interpreted.

[1]
c(i)

Identify two features that support the visual presentation of the code in a typical Integrated Development Environment (IDE). 1 2

[2]
c(ii)

Identify two features that support the debugging of the code in a typical IDE. 1 2

[2]
7
a

Describe the principal operations of a 3D printer.

[3]
b

Describe the purpose of a temperature sensor within the 3D printer.

[2]
c

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

[2]
8
Figure 1 of 6 for question 8
Figure 2 of 6 for question 8
Figure 3 of 6 for question 8
Figure 4 of 6 for question 8
Figure 5 of 6 for question 8
Figure 6 of 6 for question 8
a

Identify the purpose of the first pass of a two-pass assembler.

[1]
b(i)

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

[3]
b(ii)

The instruction LDR #2 uses immediate addressing. Give one similarity and one difference between direct addressing and indexed addressing. Similarity Difference

[2]
b(iii)

Identify one other mode of addressing.

[1]
c(i)

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

[1]
c(ii)

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

[1]
c(iii)

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

[1]
9
a

Explain the importance of feedback in a control system.

[2]
b

Give one example of an embedded system and explain why it is an example of an embedded system. Example Explanation

[3]

Mark scheme

9618/11 · Oct/Nov 2023

Download PDF

1a · 2 marks

  • 2 marks

    drawing list -> data required to create all components in the graphic; drawing object -> a component created using a formula; property -> defines one characteristic of a component (all 3 lines correct for 2 marks, 1 line correct for 1 mark)

1b · 3 marks

  • 1 mark

    The number of bits used to represent each colour

  • 1 mark

    Increase in bit depth means the image has a greater range of colours // Decrease in bit depth means the image has a smaller range of colours

  • 1 mark

    Increase in bit depth makes the image closer to the original / more realistic // Decrease in bit depth makes the image less like the original / less realistic

1c · 2 marks

  • 1 mark

    Reduced bandwidth usage when transmitting the message

  • 1 mark

    Reduced transmission time from email client to email server

2a · 3 marks

  • 1 mark

    Receives packets from internet / external network

  • 1 mark

    Implements a firewall

  • 1 mark

    Analyses the destination IP address of each packet

2b · 3 marks

  • 1 mark

    Switch: To allow two or more devices to communicate with one another // To connect individual devices to each other // To receive transmissions and forward them to their destination (max 1)

  • 1 mark

    Wireless Access Point (WAP): To allow connection of devices (to the central device) using radio signals / Wi-Fi // To allow the central device to send / receive radio signals / Wi-Fi signals // To allow wireless enabled devices to connect to a wired network (max 1)

  • 1 mark

    Bridge: To connect two LANs / segments with the same protocol // To transmit data between two networks with the same protocol (max 1)

2c · 2 marks

  • 1 mark

    The students cannot access their files without a reliable internet connection

  • 1 mark

    The amount of space for no payment may be limited so students will have to purchase more space if needed

2d · 2 marks

  • 1 mark

    1 mark for advantage (e.g. Star topology is more resilient to faults // Higher performance as fewer collisions // Easier to add new nodes // Easier to fault find compared to bus topology)

  • 1 mark

    1 mark for valid corresponding expansion (e.g. …because there is no single cable and leads to less disruption to teaching // ...because each device in the classroom is only connected to the switch // …because each device in the classroom connects directly to the switch)

3a · 3 marks

  • 1 mark

    1:M between CUSTOMER and SHOP_ORDER

  • 1 mark

    1:M between SUPPLIER and ITEM

  • 1 mark

    1:M between SHOP_ORDER and ORDER_ITEM and M:1 between ORDER_ITEM and ITEM

3b · 3 marks

  • 1 mark

    Reduced data redundancy

  • 1 mark

    Improved data integrity / consistency / referential integrity

  • 1 mark

    Allows for views / improved privacy

3c(i) · 1 mark

  • 1 mark

    CREATE DATABASE SHOP;

3c(ii) · 4 marks

  • 1 mark

    SELECT SUM(Quantity)

  • 1 mark

    FROM ORDER_ITEM, SHOP_ORDER // FROM ORDER_ITEM (INNER) JOIN SHOP_ORDER

  • 1 mark

    WHERE ORDER_ITEM.OrderNo = SHOP_ORDER.OrderNo // ON ORDER_ITEM.OrderNo = SHOP_ORDER.OrderNo

  • 1 mark

    AND SHOP_ORDER.CustomerID = 'HJ231'; // WHERE SHOP_ORDER.CustomerID = 'HJ231';

4a · 2 marks

  • 1 mark

    First set of 4 rows (values: 1, 0, 0, 0)

  • 1 mark

    Second set of 4 rows (values: 1, 0, 1, 1)

4b · 2 marks

  • 1 mark

    both AND gates

  • 1 mark

    NOT gate and OR gate and NOR gate

5a · 4 marks

  • 1 mark

    Identification of Register 1

  • 1 mark

    Role of Register 1

  • 1 mark

    Identification of Register 2

  • 1 mark

    Role of Register 2

5b · 2 marks

  • 1 mark

    Immediate Access Store holds all the data / instructions / programs currently in use

  • 1 mark

    Immediate Access Store is volatile memory

5c(i) · 1 mark

  • 1 mark

    The CPU can now perform nearly twice as many F-E cycles per second // Instead of 2.1 billion F-E cycles per second, the CPU can now perform 4 billion FE cycles per second

5c(ii) · 5 marks

  • 1 mark

    Multiple cores introduce additional overheads

  • 1 mark

    …because of the need for communication between cores

  • 1 mark

    Software may not be designed for multiple cores…

  • 1 mark

    …so one of the cores will be left idle

  • 1 mark

    Memory access speed may not match speed of cores… // …so causing delay // The two computers may have more differences than just the cores // …one may have more RAM which allows faster multitasking // ...one may have a GPU // ...etc.

6a · 4 marks

  • 1 mark

    easier to debug the program

  • 1 mark

    … because it translates line-by-line and stops when an error is found whereas the compiler translates all the program at the same time

  • 1 mark

    … only reporting one error at a time // … which allows the error to be corrected in real time whereas the program would need to be corrected and recompiled

  • 1 mark

    ... and the program can restart at same point when error occurred with a compiler the program needs to be re-run // The effect of any changes made by the programmer can be seen immediately with a compiler the effects can only be seen after re-running // A partially completed program can be translated / tested on its own a compiler cannot translate a partial program

6b · 1 mark

  • 1 mark

    Partially compiled programs can be used on different platforms as they are interpreted when run // Code is optimised for the CPU as machine code is generated at run time // Source code does not need recompiling so more efficient to run

6c(i) · 2 marks

  • 1 mark

    Prettyprint

  • 1 mark

    Expand/collapse code blocks

6c(ii) · 2 marks

  • 1 mark

    Single stepping

  • 1 mark

    Breakpoints

7a · 3 marks

  • 1 mark

    Additive manufacturing // Uses a digital 3D model or a Computer Aided Design (CAD) (file) // Builds up the model one layer at a time

  • 1 mark

    ...starting from the bottom // ...using x, y and z co-ordinates // The material is fused / cured together layer by layer

  • 1 mark

    Fused Deposition Modelling (FDM): Material is heated and pushed through nozzle / extruder // Stereolithography (SLA): Photosensitive liquid resin is exposed to a UV-laser beam // Digital Light Processing (DLP): Uses liquid plastic resin melted with arc lamps // Selective Laser Sintering (SLS): Uses a laser to form objects from powdered material

7b · 2 marks

  • 1 mark

    To prevent overheating // ensure material is hot enough

  • 1 mark

    ...by identifying the temperature of the object (being printed) // ...by identifying the temperature of the material being used

7c · 2 marks

  • 1 mark

    Dynamic RAM has lower cost per unit

  • 1 mark

    A fast access speed is not needed // Higher bit density // more data can be stored per chip

8a · 1 mark

  • 1 mark

    To create a symbol table

8b(i) · 3 marks

  • 1 mark

    Data movement: e.g. LDR #50 // STO 201

  • 1 mark

    Arithmetic operation: e.g. ADD 100 // INC IX

  • 1 mark

    Conditional instruction: e.g. JPE 96

8b(ii) · 2 marks

  • 1 mark

    Similarity: both load the contents of an address into the Accumulator

  • 1 mark

    Difference: direct accesses the address given by the operand whereas indexed adds the contents of IX to the operand and accesses the data at that calculated address

8b(iii) · 1 mark

  • 1 mark

    Indirect (addressing) // Relative (addressing)

8c(i) · 1 mark

  • 1 mark

    0000 0101

8c(ii) · 1 mark

  • 1 mark

    0000 0010

8c(iii) · 1 mark

  • 1 mark

    1101 0010

9a · 2 marks

  • 1 mark

    Feedback ensures that a system operates within set criteria / constraints

  • 1 mark

    ...by enabling system output to affect (subsequent) system input // ...thus allowing conditions to be automatically adjusted

9b · 3 marks

  • 1 mark

    Dedicated to one task applied to example // Does not require much processing power applied to example

  • 1 mark

    Built into a larger system applied to example // Contains firmware that cannot be easily updated applied to example

  • 1 mark

    The system does not have its own operating system // An embedded system must contain a processor, memory and an I/O capability // Dedicated hardware

Questions

  1. 1
    Question 17 marks
    Mark scheme ›
  2. 2
    Question 210 marks
    Mark scheme ›
  3. 3
    Question 311 marks
    Mark scheme ›
  4. 4
    Question 44 marks
    Mark scheme ›
  5. 5
    Question 512 marks
    Mark scheme ›
  6. 6
    Question 69 marks
    Mark scheme ›
  7. 7
    Question 77 marks
    Mark scheme ›
  8. 8
    Question 810 marks
    Mark scheme ›
  9. 9
    Question 95 marks
    Mark scheme ›

More 9618 papers

Other papers from Oct/Nov 2023

Solve it on ExamPalStart