OCR GCSE 2017 Computing Unofficial Markscheme
These are rough approximations of the questions, not word for word
Question 1: Sat nav I/O
What is a computer system?
-A system containing electronic devices that have software and hardware working together
-It is an electronic data processing machine that can take inputs and output results
Why does a computer system need input devices?
-To have data to process
Give an example of an input device for the sat nav for a disabled person and explain how it is useful.
-Keyboard. Only sensible one so far.
Why does the satnav need a secondary storage device?
-store maps, previous locations etc.
Why solid state storage?
-Portable-small, light
-withstand movement, no moving parts
Why are the commands stored as binary?
-1 and 0 can easily be represented via on and off siganls. It allows easy simple logic gates. It allows less error as there are only two values
Name a task carried out by the CPU:
-To fetch/execute commands from memory
-To decode commands
-To carry out the fetch, decode, execute cycle
-Perform Logic operations
Question 2: HTML and internet
What else might be in an HTML file other than text for the webpage?
-image references
-cascading style sheets, CSS
-video references
One reason why is it good for HTML to be a standard?
-All webpages are the same (pretty much) so browsers only have to support html
-People can have gaurenteed support for their webpage
-Other languages can be implemented effectively such as php, javascript and xml
Hex
- 58 = 3A, 156 = 9C
Another question ??
How does the DNS connect the user to a webpage from the URL?
The DNS has access to a database and associates the URL with a specific IP address. This can access the files and connect the user to the IP which also allows the DNS to contact the correct website.
3: Algorithm (I think)
Fill in the gaps
-'count' and 'Total / Quantity)
What is a constant and give an example?
-A value stored in a specific memory location represented by a name. The value cannot be changed while the program is running
E.g. Quantity
What data type is the Mean?
Real as it could be a decimal.
What other two types of iteration are there other than For?
-while
-repeat/do until ?
It gives an example of a validation algorithm, Give an example of a boundary value and an invalid value.
-100 or 0 are boundaries
-anything not between 0 and 100 inclusive are invalid values
4: Databases
Why is a database a persistent organised store of data?
-It is a structured object that contains data. It is stored in tables. (Not sure about this one)
What is a suitable data type for the ID?
Text, as it has leading zeros
How many records are there
-four
Which field is the primary key?
-The first field, it is unique and follows the same format. It is a short number.
Name a validation method for TeacherID and Date, they must be different.
-TeacherID, follow format Letter,Letter,ID, or must be length three etc
-Date, follow format DD/MM/YYYY or it must be less than or equal to the current date
Name two features of a DBMS that allow you to make customizable applications.
-Query, ask for records with certain attributes easily, e.g this lets the admin create a query for all outstanding repairs
-Form, create a GUI to make it easier to make a query, e.g. admin enters teachers ID into search box to get their repairs.
Question 5: Cars
Describe the ethical and legal issues surrounding the development of automatic technology such as driverless cars.
-Cars follow the law always and may not cope in an emergency situation and therefore ccause harm.
-Cars and automatic devices collect data perhaps unethically or illegally
-Automation increases unemployment, not right for robots to 'take over'
-Security required and so could break the data protection Act
-Hackability, could break the computers misuse act
Question 6: OCR accounts
Two advantages of a network in the office over standalone PCs:
-Share expensive peripherals. All users can use the peripherals plugged in to any PC. This saves money as only one peripheral is needed and all the computers have access saving time.
-Share data/resources/programs. This allows quicker sharing of data and ideas over methods such as email. It is cheaper as users do not have to use physical storage devices to transfer data. Saves time as users do not have to take so long copying files as they are in a shared folder.
Name a piece of hardware to get an internet connection. Usually OCR accepts:
Router, modem (modulator-demodulator) or ADSL adapter
Name two other pieces of hardware for a network and explain:
-Router/modem/ADSL, internet connection
-Hub, connect the devices for sharing
-NIC, allows connection via Ethernet or wireless
-Server, dedicated machine to supply data to clients etc.
-switches, like a hub but faster
Network policies:
-Acceptable Use: User priviliges, malware protection etc
-Backup
-Failover
-Disaster Recovery
-Archive
Pseudocode:
the criteria were
Use iteration
Have a previously stored number to guess
allow ten guesses
say to guess higher or lower
ask the user to guess
say congratulations and end the game if they guess it
I guess that it is one mark per criteria
approximately
Const Value = random number
count = 0
Ouput 'Guess the number'
Repeat
Output 'enter a number'
Guess = Input
If Guess = Value Then
Output 'Congratulations'
END
If Guess > Value THEN
Output 'guess higher'
if guess < Value then
Output 'Guess lower'
count = count + 1
Repeat until count = 10
output 'Sorry you did not guess the number. It was' + value
END
If anyone else has question answers contribute to help update the full markscheme
Question 1: Sat nav I/O
What is a computer system?
-A system containing electronic devices that have software and hardware working together
-It is an electronic data processing machine that can take inputs and output results
Why does a computer system need input devices?
-To have data to process
Give an example of an input device for the sat nav for a disabled person and explain how it is useful.
-Keyboard. Only sensible one so far.
Why does the satnav need a secondary storage device?
-store maps, previous locations etc.
Why solid state storage?
-Portable-small, light
-withstand movement, no moving parts
Why are the commands stored as binary?
-1 and 0 can easily be represented via on and off siganls. It allows easy simple logic gates. It allows less error as there are only two values
Name a task carried out by the CPU:
-To fetch/execute commands from memory
-To decode commands
-To carry out the fetch, decode, execute cycle
-Perform Logic operations
Question 2: HTML and internet
What else might be in an HTML file other than text for the webpage?
-image references
-cascading style sheets, CSS
-video references
One reason why is it good for HTML to be a standard?
-All webpages are the same (pretty much) so browsers only have to support html
-People can have gaurenteed support for their webpage
-Other languages can be implemented effectively such as php, javascript and xml
Hex
- 58 = 3A, 156 = 9C
Another question ??
How does the DNS connect the user to a webpage from the URL?
The DNS has access to a database and associates the URL with a specific IP address. This can access the files and connect the user to the IP which also allows the DNS to contact the correct website.
3: Algorithm (I think)
Fill in the gaps
-'count' and 'Total / Quantity)
What is a constant and give an example?
-A value stored in a specific memory location represented by a name. The value cannot be changed while the program is running
E.g. Quantity
What data type is the Mean?
Real as it could be a decimal.
What other two types of iteration are there other than For?
-while
-repeat/do until ?
It gives an example of a validation algorithm, Give an example of a boundary value and an invalid value.
-100 or 0 are boundaries
-anything not between 0 and 100 inclusive are invalid values
4: Databases
Why is a database a persistent organised store of data?
-It is a structured object that contains data. It is stored in tables. (Not sure about this one)
What is a suitable data type for the ID?
Text, as it has leading zeros
How many records are there
-four
Which field is the primary key?
-The first field, it is unique and follows the same format. It is a short number.
Name a validation method for TeacherID and Date, they must be different.
-TeacherID, follow format Letter,Letter,ID, or must be length three etc
-Date, follow format DD/MM/YYYY or it must be less than or equal to the current date
Name two features of a DBMS that allow you to make customizable applications.
-Query, ask for records with certain attributes easily, e.g this lets the admin create a query for all outstanding repairs
-Form, create a GUI to make it easier to make a query, e.g. admin enters teachers ID into search box to get their repairs.
Question 5: Cars
Describe the ethical and legal issues surrounding the development of automatic technology such as driverless cars.
-Cars follow the law always and may not cope in an emergency situation and therefore ccause harm.
-Cars and automatic devices collect data perhaps unethically or illegally
-Automation increases unemployment, not right for robots to 'take over'
-Security required and so could break the data protection Act
-Hackability, could break the computers misuse act
Question 6: OCR accounts
Two advantages of a network in the office over standalone PCs:
-Share expensive peripherals. All users can use the peripherals plugged in to any PC. This saves money as only one peripheral is needed and all the computers have access saving time.
-Share data/resources/programs. This allows quicker sharing of data and ideas over methods such as email. It is cheaper as users do not have to use physical storage devices to transfer data. Saves time as users do not have to take so long copying files as they are in a shared folder.
Name a piece of hardware to get an internet connection. Usually OCR accepts:
Router, modem (modulator-demodulator) or ADSL adapter
Name two other pieces of hardware for a network and explain:
-Router/modem/ADSL, internet connection
-Hub, connect the devices for sharing
-NIC, allows connection via Ethernet or wireless
-Server, dedicated machine to supply data to clients etc.
-switches, like a hub but faster
Network policies:
-Acceptable Use: User priviliges, malware protection etc
-Backup
-Failover
-Disaster Recovery
-Archive
Pseudocode:
the criteria were
Use iteration
Have a previously stored number to guess
allow ten guesses
say to guess higher or lower
ask the user to guess
say congratulations and end the game if they guess it
I guess that it is one mark per criteria
approximately
Const Value = random number
count = 0
Ouput 'Guess the number'
Repeat
Output 'enter a number'
Guess = Input
If Guess = Value Then
Output 'Congratulations'
END
If Guess > Value THEN
Output 'guess higher'
if guess < Value then
Output 'Guess lower'
count = count + 1
Repeat until count = 10
output 'Sorry you did not guess the number. It was' + value
END
If anyone else has question answers contribute to help update the full markscheme
(edited 6 years ago)
Scroll to see replies
I can't remember what question number it was but for the hexadecimal one it was 3A and 9C.
Posted from TSR Mobile
Posted from TSR Mobile
Original post by Callum2165
I can't remember what question number it was but for the hexadecimal one it was 3A and 9C.
Posted from TSR Mobile
Posted from TSR Mobile
I can't remember but its added as a question
(edited 6 years ago)
For the official thread:
https://www.thestudentroom.co.uk/showthread.php?t=4764224
https://www.thestudentroom.co.uk/showthread.php?t=4764224
why do computers use binary for data and instruction?
idk what the answer is
idk what the answer is
Original post by SamwiseGaMLGee
why do computers use binary for data and instruction?
idk what the answer is
idk what the answer is
they can only understand and process low level languages
Original post by DarthYoda
These are rough approximations of the questions, not word for word
Question 1: Sat nav I/O
What is a computer system?
-A system containing electronic devices
-It is an electronic data processing machine that can take inputs and output results
Why does a computer system need input devices?
-To have data to process
Give an example of an input device for the sat nav for a disabled person and explain how it is useful.
-Not sure, maybe camera eye tracking, microphone?
Why does the satnav need a secondary storage device?
-store maps, previous locations etc.
Why solid state storage?
-Portable-small, light
-withstand movement, no moving parts
There was another question in question 1..
Question 2
Question 3:
Question 4
Question 5: Driverless cars etc
question 6: OCR accounts
Pseudocode:
approximately
Const Value = random number
count = 0
Ouput 'Guess the number'
Repeat
Output 'enter a number'
Guess = Input
If Guess = Value Then
Output 'Congratulations'
END
If Guess > Value THEN
Output 'guess higher'
if guess < Value then
Output 'Guess lower'
count = count + 1
Repeat until count = 10
output 'Sorry you did not guess the number. It was' + value
END
q 2,3,4
one of them was databases with an IT maintenance
Another was algorithms
another was ???
Here is a selection of questions with answers:
Hex question, 3A and 9C
URL: The DNS has access to a database and associates the URL with a specific IP address. This can access the files and connect the user to the IP which also allows the DNS to contact the correct website.
constant: a value stored in a specific memory location represented by a name. The value cannot be changed while the program is running
If anyone else has question answers contribute to help update the full markscheme
I recommend someone else posts a new markscheme if they have more of the answers
Question 1: Sat nav I/O
What is a computer system?
-A system containing electronic devices
-It is an electronic data processing machine that can take inputs and output results
Why does a computer system need input devices?
-To have data to process
Give an example of an input device for the sat nav for a disabled person and explain how it is useful.
-Not sure, maybe camera eye tracking, microphone?
Why does the satnav need a secondary storage device?
-store maps, previous locations etc.
Why solid state storage?
-Portable-small, light
-withstand movement, no moving parts
There was another question in question 1..
Question 2
Question 3:
Question 4
Question 5: Driverless cars etc
question 6: OCR accounts
Pseudocode:
approximately
Const Value = random number
count = 0
Ouput 'Guess the number'
Repeat
Output 'enter a number'
Guess = Input
If Guess = Value Then
Output 'Congratulations'
END
If Guess > Value THEN
Output 'guess higher'
if guess < Value then
Output 'Guess lower'
count = count + 1
Repeat until count = 10
output 'Sorry you did not guess the number. It was' + value
END
q 2,3,4
one of them was databases with an IT maintenance
Another was algorithms
another was ???
Here is a selection of questions with answers:
Hex question, 3A and 9C
URL: The DNS has access to a database and associates the URL with a specific IP address. This can access the files and connect the user to the IP which also allows the DNS to contact the correct website.
constant: a value stored in a specific memory location represented by a name. The value cannot be changed while the program is running
If anyone else has question answers contribute to help update the full markscheme
I recommend someone else posts a new markscheme if they have more of the answers
well one 6 marker was what policies should the OCR accountants implement?
any idea?
i wrote data protection act and copyright acts but these are not network policies. i know.
another 6 marker was about features of DBMS i believe.
for that i wrote about security and multiple users working at the same time
what do you think? does that make any sense at all
Original post by SamwiseGaMLGee
why do computers use binary for data and instruction?
idk what the answer is
idk what the answer is
they can only understand and process low level languages, and they have high tolerance (a bit can only be a 1 or a 0, whereas stuff like hex can be 1, 2, 3, A, B, C and so on so there's less chance of errors with binary)
Original post by SamwiseGaMLGee
why do computers use binary for data and instruction?
idk what the answer is
idk what the answer is
Your mum!
Original post by Maruf Talukdar
well one 6 marker was what policies should the OCR accountants implement?
any idea?
i wrote data protection act and copyright acts but these are not network policies. i know.
another 6 marker was about features of DBMS i believe.
for that i wrote about security and multiple users working at the same time
what do you think? does that make any sense at all
any idea?
i wrote data protection act and copyright acts but these are not network policies. i know.
another 6 marker was about features of DBMS i believe.
for that i wrote about security and multiple users working at the same time
what do you think? does that make any sense at all
In terms of policies you're looking at:
Acceptable Use
Backup
Failover
Disaster Recovery
Archive
And in the features of a DBMS I explained a form and a query (wait was this the one where you had to name a feature, explain it and give an example?)
Original post by FeelsTerribleMan
Would this be right for last question? https://pastebin.com/gYbj80ZJ
these were the criteria it had to meet
Use iteration
Store number for the user to guess
say congratulations if the user guessed it
ask the user to guess the number
give 10 guesses
Say whether to guess higher or lower
By the looks of your pseudocode you will get at least 4 marks. You don't do python be any chance do you?
(edited 6 years ago)
What did you guys put for the SatNav question?
I found it difficult as we only learned about functions to help people with poor sight or limited mobility, but they would not be driving...
I put touchscreen so deaf people could enter destinations manually rather than via voice command??
I found it difficult as we only learned about functions to help people with poor sight or limited mobility, but they would not be driving...
I put touchscreen so deaf people could enter destinations manually rather than via voice command??
Original post by TemperNovaScript
What did you guys put for the SatNav question?
I found it difficult as we only learned about functions to help people with poor sight or limited mobility, but they would not be driving...
I put touchscreen so deaf people could enter destinations manually rather than via voice command??
I found it difficult as we only learned about functions to help people with poor sight or limited mobility, but they would not be driving...
I put touchscreen so deaf people could enter destinations manually rather than via voice command??
I put braille keyboard as it would mean blind PASSENGERS could use it - drivers can't always operate the system, especially under new crackdown on mobile phones which are where many people have their sat nav
Original post by Becca2000
I put braille keyboard as it would mean blind PASSENGERS could use it - drivers can't always operate the system, especially under new crackdown on mobile phones which are where many people have their sat nav
I put braille as well, but im doubting whether braille is worthy of any marks, after all, how could blind people drive?
Quick Reply
Related discussions
- 2022 ocr as level chemistry papers
- Which gcse option is better to pick and more easier and less stressful???
- Gcse ocr computer science
- A Level Options
- Edexcel A Level Economics A Paper 2 (9ECO 02) Unofficial Markscheme
- Should I get my results remarked?
- Are the 2023 cohort even as smart as the 2019?
- Alevel options
- Edexcel A Level Economics A Paper 1 Unofficial Markscheme
- Gcse biology aqa exam paper 1 2023
- Aqa biology a level paper 3 2023
- Edexcel biology A paper 2
- I chose Computer Science GCSE OCR - help
- IYGB MadAsMaths Special Paper Questions
- struggling with OCR Computer Science paper 2... any advice?
- Should I take A level Biology if I did foundation maths at GCSE
- gcse combined science 2022 papers
- i need help
- What is the best exam board for Computer Science?
- GCSE Computer Science Study Group 2023-2024
Latest
Trending
Last reply 3 days ago
Is MathsFM French Alevels good for a CS degree at top uni (OX, UCL, Durham etc)Last reply 4 days ago
OCR A-level Computer Science Paper 1 (H446/01) - 12th June 2023 [Exam Chat]Last reply 2 weeks ago
OCR A-level Computer Science Paper 2 (H446/02) - 19th June 2023 [Exam Chat]Last reply 3 weeks ago
AQA A-level Computer Science Paper 1 (7517 1A - 1E) - 12th June 2023 [Exam Chat]Last reply 1 month ago
Not receiving any response from University of Birmingham.Last reply 3 months ago
OCR GCSE Computer Science Paper 1 (J277/01) - 19th May 2023 [Exam Chat]Last reply 3 months ago
AQA GCSE Computer Science Paper 2 (8525/2) - 25th May 2023 [Exam Chat]Trending
Last reply 3 days ago
Is MathsFM French Alevels good for a CS degree at top uni (OX, UCL, Durham etc)Last reply 4 days ago
OCR A-level Computer Science Paper 1 (H446/01) - 12th June 2023 [Exam Chat]Last reply 2 weeks ago
OCR A-level Computer Science Paper 2 (H446/02) - 19th June 2023 [Exam Chat]Last reply 3 weeks ago
AQA A-level Computer Science Paper 1 (7517 1A - 1E) - 12th June 2023 [Exam Chat]Last reply 1 month ago
Not receiving any response from University of Birmingham.Last reply 3 months ago
OCR GCSE Computer Science Paper 1 (J277/01) - 19th May 2023 [Exam Chat]Last reply 3 months ago
AQA GCSE Computer Science Paper 2 (8525/2) - 25th May 2023 [Exam Chat]
