Computer Science > QUESTION PAPER & MARK SCHEME > OCR A Level Computer Science H446/01 Computer Systems. QUESTION PAPER AND ANSWERS (All)

OCR A Level Computer Science H446/01 Computer Systems. QUESTION PAPER AND ANSWERS

Document Content and Description Below

OCR Insurance uses a computer system to calculate the price that customers pay for car insurance. (a) The computer system contains a CPU, GPU, RAM and ROM. (i) State two factors that affect the pe... rformance of a CPU. 1 ........................................................................................................................................ ........................................................................................................................................... 2 ........................................................................................................................................ ........................................................................................................................................... [2] (ii) Explain the difference between RAM and ROM, including how these are used by the computer system. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [4] (iii) Describe one non-graphical use OCR Insurance may have for a GPU. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [2] 3 © OCR 2021 Turn over (b) The CPU uses pipelining to improve efficiency. Explain what is meant by the term ‘pipelining’. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... .............................................................................................................................................. [3] 4 © OCR 2021 (c)* OCR Insurance’s computer system uses secondary storage across the company in servers, client machines and for backup purposes. For each of these, discuss whether magnetic storage or solid state storage would be most suitable, taking into account the advantages and disadvantages of both. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... .............................................................................................................................................. [9] 5 © OCR 2021 Turn over (d) Customers’ details are stored in the flat file database table Customer. An extract of the table is shown below. CustomerID Surname Title Phone CarReg JJ178 James Mr (0121) 343223 DY51 KKY HG876 Habbick Miss (01782) 659234 PG62 CRG EV343 Elise Mrs (07834) 123998 HN59 GFR PG127 Pleston Mr (07432) 234543 JB67 DSF (i) State what is meant by the term ‘primary key’, identifying the primary key in the table above. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [2] (ii) Write the SQL statement that would show only the CustomerID and Surname fields for customers with the Title “Miss” or “Mrs”. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [4] (iii) Describe one problem that would arise with the flat file database structure if a customer wanted to insure more than one car at the same time. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [2] 6 © OCR 2021 (iv) Describe how the flat file database structure could be altered to efficiently allow each customer to insure multiple cars at the same time. (You may assume each car is insured to only one customer.) ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [5] 7 © OCR 2021 Turn over 2 (a) (i) Convert the denary number 231 to an unsigned 8-bit binary number. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [1] (ii) Convert the hexadecimal number 6F to an unsigned 8-bit binary number. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [1] (b) The floating point number 0011010100 is stored using 6 bits for the mantissa and 4 bits for the exponent, both in two’s complement. This number is not normalised. (i) Give the normalised version of this number, showing your working. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [4] 8 © OCR 2021 (ii) Convert your answer to part (i) to denary, showing your working. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [3] (c) Add together the two numbers below. Both numbers are stored in normalised floating point format, using 6 bits for their mantissa and 4 bits for their exponent which are both in two’s complement. Show the result in the same format and show your working. 0110000110 + 0101000100 ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... .............................................................................................................................................. [5] 9 © OCR 2021 Turn over 3 A website sells tickets for sporting events. The website uses HTML, CSS and JavaScript. (a) Describe the purpose of HTML and CSS within the code of the website. HTML ........................................................................................................................................ ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... CSS .......................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... [4] (b) One page in the website contains a hyperlink on an image. When the image stored as “ticket.png” is clicked, the user is hyperlinked to the page stored as “booking.htm”. Write the HTML code to implement this hyperlink. ................................................................................................................................................... ................................................................................................................................................... .............................................................................................................................................. [3] 10 © OCR 2021 The website charges a booking fee of £2.99 on each ticket sold. In addition, if the tickets are purchased from outside of the UK, £4.99 is added to the booking fee. The booking fee is calculated using a JavaScript function named bookingfee(). (c) Complete the definition of the bookingfee() function below. function bookingfee(numtickets, country) { var nonUKprice = 4.99; var perTicketPrice = ………………………………………; var total = 0; if (country!="UK") { total = total + ………………………………………; } total = total + (……………………………………… * perTicketPrice); ……………………………………… total; } [4] (d) The JavaScript function above is used to show users the booking fee. When users click to buy the tickets, the booking fee is calculated again on the server. (i) Explain why server side processing is used to recalculate the booking fee. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [3] (ii) Explain one advantage of client side processing to either the customer buying the tickets, or to company who own the website. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [2] 11 © OCR 2021 Turn over (e) Users are able to search for and find the ticket website using a search engine. Search engines can use indexing and ranking. (i) Describe how a website is indexed by a search engine. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [4] A search engine can use the PageRank algorithm to determine a website’s ranking. The PageRank algorithm utilises a damping factor. (ii) State what is meant by the term ‘damping factor’. ........................................................................................................................................... ...................................................................................................................................... [1] (iii) Give two other factors that affect the output value given by the PageRank algorithm for a website. 1 ........................................................................................................................................ ........................................................................................................................................... 2 ........................................................................................................................................ ........................................................................................................................................... [2] 12 © OCR 2021 4* “The Computer Misuse Act means that computer users are criminalised for simply trying to learn how systems work.” Discuss whether or not you agree with this statement. .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... .......................................................................................................................................................... ..................................................................................................................................................... [9] 13 © OCR 2021 Turn over 5 All users of a computer system have a unique username and password. The computer system has implemented two-factor authentication so that users must respond to either an email or text message containing a secret code to be able to access the system. Let: A be a Boolean value for if a user enters a valid username B be a Boolean value for if a user enters a password that matches their username C be a Boolean value for if a user is able to respond to an email containing a secret code D be a Boolean value for if a user is able to respond to a text message containing a secret code Q be a Boolean value for if entry to the computer system is allowed (a) Complete the Boolean expression below: Q ≡ .................................................................................................................................... [3] (b) Another Boolean expression for a logic system is shown below: Q ≡ ¬ (¬ A ∧ ¬ B) (i) Simplify this Boolean expression so that it does not include any negation. You must explain which Boolean algebra rule(s) you are using at each step. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [2] 14 © OCR 2021 A B S C (c) The logic circuit above has two inputs (A, B) and two outputs (S, C). (i) Give the Boolean expressions for the outputs S and C. S ≡................................................................................................................................... C ≡................................................................................................................................... [2] (ii) Complete the truth table for this logic circuit. A B S C 0 0 0 1 1 0 1 1 [2] (iii) Describe how this logic circuit can be adapted to add together two 4-bit binary numbers. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [4] 15 © OCR 2021 Turn over BLANK PAGE PLEASE DO NOT WRITE ON THIS PAGE 16 © OCR 2021 6 A program written using the Little Man Computer instruction set is shown in Fig. 1. INP STA numone INP STA numtwo main LDA numone SUB numtwo BRP pos notpos LDA count OUT LDA numone OUT HLT pos STA numone LDA count ADD one STA count BRA main numone DAT numtwo DAT one DAT 1 count DAT 0 Fig. 1 (a) Various registers are used when the program above is executed. (i) State what is meant by the term ‘register’. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [2] (ii) Explain how the accumulator is used when the line BRP pos is executed. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ...................................................................................................................................... [2] 17 © OCR 2021 Turn over (b) Complete the table below to show the output(s) from this program given the inputs. Inputs Output(s) 12, 5 18, 2 16, 4 3, 7 [4] (c) Write an algorithm using pseudocode that has the same functionality as the code in Fig. 1. ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... .............................................................................................................................................. [4] 18 © OCR 2021 (d)* In assembly language, different modes of addressing memory can be used. Discuss the different modes used. You should include: • How the operand value is determined • What an operand of 27 would refer to in that mode • The reasons for requiring multiple modes of addressing [12] ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ............................................................................................... [Show More]

Last updated: 1 year ago

Preview 1 out of 43 pages

Reviews( 0 )

Recommended For You

 Business> QUESTION PAPER & MARK SCHEME > OCR A Level Business H431/01 Operating in a local business environment. QUESTION PAPER AND MARKING SCHEME. Rated A+ (All)

preview
OCR A Level Business H431/01 Operating in a local business environment. QUESTION PAPER AND MARKING SCHEME. Rated A+

Put a tick (✓) in the box next to the one correct answer for each question. 1 A job description should contain: (a) a deadline for applications (b) the characteristics of the successful applicant...

By SupremeDocs , Uploaded: Aug 07, 2022

$9

 Classical Civilisation> QUESTION PAPER & MARK SCHEME > OCR A Level Classical Civilisation H408/33 Politics of the Late Republic. QUESTION PAPER AND MARKING SCHEME. RATED A+ (All)

preview
OCR A Level Classical Civilisation H408/33 Politics of the Late Republic. QUESTION PAPER AND MARKING SCHEME. RATED A+

Answer all the questions in this section. Start your answer to each 10, 20 and 30 mark question on a new page. Source A: Cicero’s letter to Atticus from Formiae, 23rd February 49 BC Att. 8.8 Oh wha...

By SupremeDocs , Uploaded: Aug 07, 2022

$9

 Classical Civilisation> QUESTION PAPER & MARK SCHEME > OCR A Level Classical Civilisation H408/21 Greek Theatre. QUESTION PAPER AND MARKING SCHEME. RATED A+ (All)

preview
OCR A Level Classical Civilisation H408/21 Greek Theatre. QUESTION PAPER AND MARKING SCHEME. RATED A+

Section A Answer all the questions in this section. Start your answer to each 10, 20 and 30 mark question on a new page. Source A: Images of Greek Theatres Image 1: The Theatre at Thorikos Z Y...

By SupremeDocs , Uploaded: Aug 07, 2022

$9

 Classical Civilisation> QUESTION PAPER & MARK SCHEME > OCR A Level Classical Civilisation H408/22 Imperial Image . QUESTION PAPER AND MARKING SCHEME. RATED A+ (All)

preview
OCR A Level Classical Civilisation H408/22 Imperial Image . QUESTION PAPER AND MARKING SCHEME. RATED A+

Answer all the questions in this section. Start your answer to each 10, 20 and 30 mark question on a new page. Source A: Part of a relief from the Kalabsha Gate depicting Octavian 1 Another figure...

By SupremeDocs , Uploaded: Aug 07, 2022

$9

 Classical Civilisation> QUESTION PAPER & MARK SCHEME > OCR A Level Classical Civilisation H408/31 Greek Religion. QUESTION PAPER AND MARKING SCHEME.. GRADED A+ (All)

preview
OCR A Level Classical Civilisation H408/31 Greek Religion. QUESTION PAPER AND MARKING SCHEME.. GRADED A+

Section A Answer all the questions in this section. Start your answer to each 10, 20 and 30 mark question on a new page. Source A: Red-figure amphora by the Nausicaa Painter (c.450BC) 1 (a) Descri...

By SupremeDocs , Uploaded: Aug 07, 2022

$9

 Classical Civilisation> QUESTION PAPER & MARK SCHEME > OCR A Level Classical Civilisation H408/32 Love and Relationships. QUESTION PAPER AND MARKING SCHEME. GRADED A+ (All)

preview
OCR A Level Classical Civilisation H408/32 Love and Relationships. QUESTION PAPER AND MARKING SCHEME. GRADED A+

Answer all the questions in this section. Source A: Sappho Collected fragments (Loeb 22, 47–50, 102) Loeb 22 I call upon you, Abanthis, Take up your lyre and sing of Gongyla While desire again ci...

By SupremeDocs , Uploaded: Aug 07, 2022

$9

 Classical Civilisation> QUESTION PAPER & MARK SCHEME > OCR A Level Classical Civilisation H408/34 Democracy and the Athenians, QUESTION PAPER AND AND ANSWERS. GRADED A+ (All)

preview
OCR A Level Classical Civilisation H408/34 Democracy and the Athenians, QUESTION PAPER AND AND ANSWERS. GRADED A+

Answer all the questions in this section. Start your answer to each 10, 20 and 30 mark question on a new page. Source A: Euripides Suppliants: 429–450 There’s no heavier burden for a city to bear t...

By SupremeDocs , Uploaded: Aug 07, 2022

$9

 Classical Civilisation> QUESTION PAPER & MARK SCHEME > OCR A Level Classical Civilisation H408/23 Invention of the barbarian. QUESTION PAPER AND MARKING SCHEME. 100% GRADED A+ (All)

preview
OCR A Level Classical Civilisation H408/23 Invention of the barbarian. QUESTION PAPER AND MARKING SCHEME. 100% GRADED A+

How can you tell that the figure on the left in Source A represents a Persian? Give two reasons. [2] 2 Which battle does the frieze in Source A commemorate? [1] 3 Describe how typical the portrayal...

By SupremeDocs , Uploaded: Aug 07, 2022

$9

 Classical Civilisation> QUESTION PAPER & MARK SCHEME > OCR A Level Classical Civilisation H408/24 Greek Art. QUESTION PAPER AND ANSWERS. GRADED A+ (All)

preview
OCR A Level Classical Civilisation H408/24 Greek Art. QUESTION PAPER AND ANSWERS. GRADED A+

Answer all the questions in this section. Start your answer to each 10, 20 and 30 mark question on a new page. Source A: A free-standing sculpture 1 Give the date of the statue in Source A. [1] 2...

By SupremeDocs , Uploaded: Aug 07, 2022

$9

 Business> QUESTION PAPER & MARK SCHEME > OCR A Level Business H431/03 The global business environment. QUESTION PAPER AND MARKING SCHEME. RATED A+ LATEST 2022 (All)

preview
OCR A Level Business H431/03 The global business environment. QUESTION PAPER AND MARKING SCHEME. RATED A+ LATEST 2022

Answer all the questions. 1 State two financial objectives that an organisation such as Nike might have for the coming year. 1 ..........................................................................

By SupremeDocs , Uploaded: Aug 07, 2022

$9

$12.00

Add to cart

Instant download

Can't find what you want? Try our AI powered Search

OR

GET ASSIGNMENT HELP
537
0

Document information


Connected school, study & course



About the document


Uploaded On

Jul 16, 2022

Number of pages

43

Written in

Seller


seller-icon
SupremeDocs

Member since 2 years

23 Documents Sold


Additional information

This document has been written for:

Uploaded

Jul 16, 2022

Downloads

 0

Views

 537

Document Keyword Tags

THE BEST STUDY GUIDES

Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students

custom preview

Avoid examination resits

Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.

custom preview

Get the best grades

Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality

custom preview

Earn from your notes

Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.


$12.00

WHAT STUDENTS SAY ABOUT US


What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·