A Level Computer Science 9618 Paper 13, 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/13 · Oct/Nov 2023

Download PDF
1
a

State what is meant by analogue data.

[1]
b

Draw one line from each term to its most appropriate description. Term Description sampling the number of samples taken per second sampling rate taking measurements at regular intervals and storing the values sampling resolution the number of bits used to store each sample

[2]
2
a

Describe the impact of increasing the image resolution on the quality of a bitmap graphic.

[2]
b

Calculate the file size of a bitmap image using the following information: • image resolution of 2048 pixels wide and 1024 pixels high • bit depth of 16 bits. Give your answer in kibibytes. Show your working.

[2]
3

A company sells online Computer Science courses to students in different countries. The courses are stored on a public cloud.

a(i)

Explain why the company uses a public cloud to store these courses.

[2]
a(ii)

Describe two disadvantages of storing data on a public cloud compared to storing data on a server in a Local Area Network (LAN).

[4]
a(iii)

State how the following security measures can be used to protect computer systems. Firewall Encryption Passwords

[3]
b(i)

The company uses a database, COURSES, to store data about the courses and their tutors. Each course starts at different times of the year and may have a different tutor. The database has the following structure: COURSE_INFORMATION(CourseID, Description, Cost) TUTOR(TutorID, TelephoneNumber, EmailAddress, TutorName) COURSE_SCHEDULE(CourseID, DateStarted, TutorID) Complete the entity-relationship (E-R) diagram for the database COURSES.

[1]
b(ii)

Write the Structured Query Language (SQL) script to return the total number of courses that have started after 9 September 2023. The value returned must have an appropriate field name.

[4]
c

An example of a tutor ID is NK16C6. An administrative officer enters the tutor ID into the TUTOR table. Explain how data verification can be used when the tutor ID is entered.

[4]
4
a

Complete the truth table for the logic expression: Y = ((P AND Q) XOR ((NOT Q) OR R)) AND NOT P

[2]
b

Draw a logic circuit for the logic expression: Y = ((P AND Q) XOR ((NOT Q) OR R)) AND NOT P

[2]
5

A programmer uses an Integrated Development Environment (IDE) to develop a program that monitors air quality.

a

Describe the following features of a typical IDE. Context-sensitive prompts Single stepping

[4]
b(i)

The program is distributed by downloading the source code and its library files from a web server. Explain the reasons for compressing the files.

[2]
b(ii)

The program files are stored on a new hard disk after they have been downloaded. Describe the reasons why a hard disk formatter is needed for the new hard disk.

[3]
6
a

State two benefits to a programmer of distributing a program using a shareware licence.

[2]
b

Explain why it is important for a programmer to join a professional ethical body.

[4]
7

A laptop computer has Static RAM (SRAM). A virtual reality headset and a laser printer are connected to the laptop.

a

Explain why Static RAM is used in the laptop instead of Dynamic RAM.

[2]
b

Identify two reasons for using Electrically Erasable Programmable ROM (EEPROM) in a virtual reality headset.

[2]
c

Describe how the laser printer makes use of a buffer.

[4]
d

Identify one port that could be used to connect the virtual reality headset to the laptop. Justify your choice.

[3]
8
a

Data verification is one method of protecting the integrity of data. Describe one other method of protecting the integrity of data.

[2]
b

State one difference and one similarity between pharming and phishing.

[2]
c

Explain how the data security risks of malware can be restricted.

[3]
9

A computer system is designed using the basic Von Neumann model. Registers and buses are components in the Von Neumann model.

a(i)

Identify three other components in the Von Neumann model of a computer system. Do not include registers or buses in your answers.

[3]
a(ii)

Identify two differences between special purpose registers and general purpose registers.

[2]
b

The following incomplete table contains steps of the Fetch-Execute (F-E) cycle and their descriptions. Complete the table by writing the missing steps using register transfer notation and the missing descriptions.

[4]
c

Interrupts can be caused by software programs or hardware devices. State one cause of a software interrupt.

[1]
d

The following statements describe the stages that the CPU performs when an interrupt is detected. There are three missing statements. Write the letter of the missing statements from the table in the correct place to complete the description. 1 At the end of each Fetch-Execute (F-E) cycle, the processor checks if an interrupt flag is set. 2 ...................................................... 3 If the interrupt priority is high enough, the processor saves the current contents of the registers. 4 ...................................................... 5 When servicing of the interrupt is complete, the processor restores the registers. 6 ...................................................... Letter Stage A The address of the Interrupt Service (ISR) handling routine is loaded into the Program Counter (PC). B Lower priority interrupts are re-enabled. C The device causing the interrupt transfers data to the CPU. D The processor identifies the source of the interrupt and checks the priority of the interrupt. E The ISR is incremented.

[3]

Mark scheme

9618/13 · Oct/Nov 2023

Download PDF

1a · 1 mark

  • 1 mark

    data values that are continuously changing // variable // any value

1b · 2 marks

  • 1 mark

    1 correct line connecting term to description

  • 1 mark

    3 correct lines connecting terms to descriptions

2a · 2 marks

  • 1 mark

    more pixels can be stored / are available

  • 1 mark

    the image is sharper / less pixelated

2b · 2 marks

  • 1 mark

    Working: File size = (2048  1024  16) / (8  1024)

  • 1 mark

    Answer: 4096 kibibytes

3a(i) · 2 marks

  • 1 mark

    Courses must be available to anyone who wishes to follow them

  • 1 mark

    Courses must be available on the internet

  • 1 mark

    Company is willing to share infrastructure with other companies (public)

  • 1 mark

    …which is more economic for the company

3a(ii) · 4 marks

  • 1 mark

    There could be a possible loss of control unlike the LAN

  • 1 mark

    …because the data is stored on a remote infrastructure / someone else’s infrastructure // …reliance on external agency to complete tasks, e.g. backups, security

  • 1 mark

    Requires reliable internet connection

  • 1 mark

    …to ensure access to the remote data, more likely with LAN // Increased recurring costs // ...as cloud provider charges must be paid, costs for LAN once only.

3a(iii) · 3 marks

  • 1 mark

    Firewall: Monitors incoming and outgoing traffic and rejects any traffic that does not meet the set rules

  • 1 mark

    Encryption: Ensures that if data is intercepted / obtained it cannot be understood without the decryption key

  • 1 mark

    Passwords: Ensures only users with the correct password can access the resources // prevents unauthorised access

3b(i) · 1 mark

  • 1 mark

    Both 1:M relationships correct (TUTOR 1:M COURSE_SCHEDULE and COURSE_INFORMATION 1:M COURSE_SCHEDULE)

3b(ii) · 4 marks

  • 1 mark

    SELECT Count(CourseID)

  • 1 mark

    AS NumOfCourses

  • 1 mark

    FROM COURSE_SCHEDULE

  • 1 mark

    WHERE DateStarted > "09/09/23";

3c · 4 marks

  • 1 mark

    The administrator completes a visual check / checks by eye

  • 1 mark

    …that the tutor identifier input matches the tutor identifier on the original document

  • 1 mark

    Double entry check // the administrator (or a second person) enters the number a second time

  • 1 mark

    …and the system compares it with the first entry

4a · 2 marks

  • 1 mark

    First 4 rows of truth table: Y = 1, 1, 0, 1

  • 1 mark

    Last 4 rows of truth table: Y = 0, 0, 0, 0

4b · 2 marks

  • 1 mark

    P AND Q and NOT Q OR R

  • 1 mark

    NOT gate and AND gate and XOR gate

5a · 4 marks

  • 1 mark

    Context-sensitive prompts: As the code is being written

  • 1 mark

    Context-sensitive prompts: …the options to complete the statement are shown

  • 1 mark

    Single stepping: allows the programmer to execute the program one line at a time

  • 1 mark

    Single stepping: …so that the effects of each statement can be seen

5b(i) · 2 marks

  • 1 mark

    To reduce the time it takes to download the program files from the web server // to upload them to the server in the first place

  • 1 mark

    To reduce the amount of storage space used on the web server // user’s device

5b(ii) · 3 marks

  • 1 mark

    Disk needs to be prepared for initial use

  • 1 mark

    Disk needs to be checked for errors

  • 1 mark

    A new file system needs to be generated on the disk

  • 1 mark

    The file allocation table needs to be set up

6a · 2 marks

  • 1 mark

    Users are able to trial the program and may offer the programmer constructive feedback

  • 1 mark

    More people might try the program because the trial is free of charge

  • 1 mark

    Allows bugs to be found and corrected on a wide range of computer system configurations improving the programmer’s original program

  • 1 mark

    Users that find the trial useful will buy the program so programmer gets income

  • 1 mark

    Allows the program to be copyrighted and so protects the programmer’s intellectual property rights // no illegal modification allowed

6b · 4 marks

  • 1 mark

    The programmer has ethical guidelines to follow // …so purchasers of programs know the standards being applied // …so programmer does not have to decide what is ethical or not

  • 1 mark

    Clients know programmer is reputable // …recognition of programmer’s skills/knowledge

  • 1 mark

    There may be an entry requirement / exam // … so clients know that the programmer is competent

  • 1 mark

    Professional ethical body provides help and support // Such as legal advice // by appropriate example // Enables programmer to attend the ethical body’s training courses // …to keep skills up to date // to develop skills

7a · 2 marks

  • 1 mark

    Static RAM has faster access time // …because it does not need to be refreshed

  • 1 mark

    …used on the CPU for improvement of CPU cache speed // Static RAM has lower

7b · 2 marks

  • 1 mark

    EEPROM allows frequent / multiple read / write / erase operations

  • 1 mark

    …which means that the contents of the firmware in the headset can be changed easily // …without fully erasing the contents of the firmware in the headset first

7c · 4 marks

  • 1 mark

    The print instructions and data are sent by the laptop to a buffer (at laptop speed)

  • 1 mark

    The data is transferred from the buffer to the printer (at printer speed)

  • 1 mark

    …allowing user to continue using the laptop // and allowing processor to continue processing // …instead of waiting for relatively slower printer

  • 1 mark

    When the buffer is empty an interrupt is sent to the laptop // …requesting more data

7d · 3 marks

  • 1 mark

    naming a correct port (USB / HDMI)

  • 1 mark

    matching justification point 1

  • 1 mark

    matching justification point 2

8a · 2 marks

  • 1 mark

    Validation // a validation method named or described

  • 1 mark

    …protects the data by ensuring that the data is reasonable / sensible and within specified bounds

8b · 2 marks

  • 1 mark

    Difference: Pharming is malicious code that redirects to a fake website. Phishing uses an email to prompt user action. // Pharming is automatic. Phishing requires user action.

  • 1 mark

    Similarity: Both try to obtain financial or personal information // Both are a false representation of an official organisation, e.g. a bank // Both make use of fake websites

8c · 3 marks

  • 1 mark

    Download programs from reputable websites / sources (…as these are less likely to contain malware) // Backup / archive computer systems (…so they can be restored in case of data loss from malware program installation)

  • 1 mark

    Install and run anti-malware program (…so that regular scans can be made for known malware / quarantined / definitions updated)

  • 1 mark

    Using a firewall to block unused ports // Deny administrator privileges to everyday users // Avoid the use of / access to removable devices

9a(i) · 3 marks

  • 1 mark

    Control unit (CU)

  • 1 mark

    Arithmetic and Logic Unit (ALU)

  • 1 mark

    Immediate Access Store (IAS) // (System clock)

9a(ii) · 2 marks

  • 1 mark

    Special purpose registers hold the status of a program whereas general purpose registers hold the temporary data while performing operations.

  • 1 mark

    Special purpose registers are specialised for a specific use, whereas general purpose registers are used for any purpose. // General purpose registers can be used by most instructions, whereas special purpose can only be used by certain instruction

9b · 4 marks

  • 1 mark

    PC ← [PC] + 1

  • 1 mark

    The data in the location pointed to by the MAR is copied to the MDR.

  • 1 mark

    The contents of PC are copied to the MAR.

  • 1 mark

    CIR ← [MDR]

9c · 1 mark

  • 1 mark

    Division by zero // Runtime error // Out of memory bounds // Program requesting an external device / input // Buffer overflow

9d · 3 marks

  • 1 mark

    D in position 2

  • 1 mark

    A in position 4

  • 1 mark

    B in position 6

Questions

  1. 1
    Question 13 marks
    Mark scheme ›
  2. 2
    Question 24 marks
    Mark scheme ›
  3. 3
    Question 318 marks
    Mark scheme ›
  4. 4
    Question 44 marks
    Mark scheme ›
  5. 5
    Question 59 marks
    Mark scheme ›
  6. 6
    Question 66 marks
    Mark scheme ›
  7. 7
    Question 711 marks
    Mark scheme ›
  8. 8
    Question 87 marks
    Mark scheme ›
  9. 9
    Question 913 marks
    Mark scheme ›

More 9618 papers

Other papers from Oct/Nov 2023

Solve it on ExamPalStart