Computer science
  • Exam boards
    • OCR past papers >
      • Paper1 (Sample)
    • Edexcel past papers >
      • 2020 Current spec (coming soon) >
        • Programming Language Subset (PLS)
      • Old 2016 SPEC >
        • Paper 1 (specimen1)
        • Paper 1 (specimen2)
        • Paper 1 (2018)
        • Paper 1 (2019)
        • Paper 2 (specimen1)
        • Paper 2 (2018)
        • Paper 2 (2019)
      • OLD 2013 SPEC >
        • Sample assessment 1 (old spec)
        • Sample assessment 2 (old spec)
        • June 2017 (old spec)
        • June 2016 (old spec)
        • June 2015 (old spec)
    • Paper 1 (by topic) >
      • Algorithms
      • Application software
      • Ascii
      • Binary
      • Cache
      • Client Server
      • Cloud
      • Compression
      • Computational thinking
      • CPU
      • Cyber security
      • Database
      • Fetch decode execute cycle
      • Embedded system
      • Encryption
      • File size
      • Flow chart
      • Hexadecimal
      • High Level language
      • ISP/Internet
      • Logic
      • Magnetic HDD
      • Networking
      • Open source
      • Operating system
      • Peer to peer
      • Images (Data representation)
      • Protocols
      • RAM
      • ROM
      • Run length encoding
      • Simulation software
      • Solid state HDD
      • Sound
      • Stored program concept
      • Utility software
    • Curriculum >
      • Binary
      • Hex
      • Data Representation
      • Compression
      • Encryption
      • What is a computer
      • How does a computer work
      • Hardware
      • Operating system
      • The CPU
      • Input devices
      • Data storage
      • Networks
      • Microcontrollers
      • Computational models
      • Emerging trends
      • Virtual machine
      • Models and simulators
      • Algorithms
    • Python >
      • Finding python
      • GCSE Python questions
      • Python coding >
        • Comments
        • Data types
        • Variables
        • If Else
        • If Elif Else
        • Functions
        • For loop
        • While loop >
          • While loop challenges
        • Data structures >
          • Looping thru 2D array
        • String slicing/indexing
        • Subprograms
        • Local/global variable
        • Validation and try
        • methods
        • File I/O
        • Pseudocode
        • Modules >
          • Turtle
        • Classes
        • NEA/Projects
  • KS3/Other
    • KS3 >
      • Online Safety >
        • Screen time
        • Online Safety questions
      • IT
      • Hardware >
        • All Hardware
        • Magnetic hard disk drive
        • Optical disk drive
        • Solid state drive
      • Software
      • Binary/Hex/Algorithms >
        • Binary
        • Binary explained
        • Hexadecimal - 1 digit
        • Hexadecimal - 2 digits
        • Algorithms
        • ASCII
        • Tests
      • Networks
      • Protocols/Cyber attacks
      • Logic >
        • CPU
        • AND gate
        • OR gate
        • NOT gate
        • Logical statements
      • Coding >
        • HTML
        • Scratch >
          • Scratch questions
        • Python >
          • Getting started
          • Functions
          • Variables
          • VariablesToo
          • inputs
          • Selection
          • Flowcharts
          • Data types
          • Pseudocode1
          • Pseudocode2
          • Subprogram1
          • Subprogram2
          • Coding challenges
    • BTEC CS
    • OCR GCSE CS >
      • Past paper JUNE 2015
      • Past paper June 2014
      • Past paper MAY 2012
      • Past paper JAN 2011
      • Past paper JUN 2011
    • AQA AS-Level CS >
      • AS Curriculum >
        • Multiple choice questions
    • Business studies >
      • Keywords
      • BS Revision - Multiple choice
      • Paper 1 (9-1)
      • Paper 2 (9-1)
  • Contact/More
    • Code editor
    • Contact us
    • Microbit ideas
    • More
  • Self test
    • 01 Random topics
    • 02 Programming
    • 03 Data
    • 04 Computers
    • 05 Networks
    • 06 Legal/Ethics/Enviro'
    • Coding/Programming

ocr gcse computing

JUNE 2011
Picture

OCR GCSE Computing June 2011  exam paper can be downloaded here.



OCR GCSE Computing June 2011  mark scheme can be downloaded here

Picture
Picture
Picture
1A Answer
Storage: device used to store data (in binary format for processing later)
Input: device used to enter data into the computer
Output: device used to present information/the result of processing to the user

More help here - More here
Picture
1B answer
Handheld device
  • Solid state
  • Quick access (for instant on)/not sensitive to being moved around while used
Main file server
  • Magnetic
  • Very Large capacity/relatively cheap
School production
  • Optical
  • Cheap/Portable/Universally readable by a most computers and dedicated video disc players

Picture
1C answer
Points may include:
Input devices:
  • Puff-suck switch: allows mobility impaired users to control eg clicking a mouse, by sucking or blowing through a tube
  • Simplified/concept keyboards eg for Braille, or larger keys
  • Eye tracking input – Camera is used to follow the users eye movements and use these to control eg movement of mouse on screen.
Output device:
  • Braille printer – print documents on paper in braille as raised bumps. Some braillers have plastic bumps which can be raised or lowered by software, so output does not have to be on paper.
  • Text to speech
  • Screen magnifiers

High Level Response (5/6): A good understanding with detailed descriptions of a range of relevant input as well as output devices; The information will be presented in a structured and coherent form. There will be few if any errors in spelling, grammar and punctuation. Technical terms will be used appropriately and correctly.
Picture
2a answer
  • A Database Management System/Used to manage the database
  • May use SQL/allows database to be queried
  • Provides facilities for creating tables/inserting data/viewing data/reporting
  • Allows data structure to be independent of the program
  • Allows relationships to be created between tables/Maintains integrity
  • Provides security features/levels of access

More help here - DBMS explained1
More help here - DBMS explained2

Picture
2b answer
Form:
  • An input screen
  • Allowing chosen data items to be displayed and edited
  • Uses texboxes/drop down lists/checkboxes etc…
  • When edited, the changes are updated in the database
  • Suitable example from shop eg enter new products
Picture
2b answer
Report:
  • An output of the data in a database
  • A snapshot of the data at a given time/when printed
  • Of specified fields/Laid out in a specified format
  • Aggregates may be calculated and displayed
  • Suitable example from shop eg weekly sales

Up to 2 marks for description and 1 mark for example
Picture
2ci answer
  • Supplier = Killey’s.
  • Answer: 0003, 0006
award 1 mark if both answers present and no others
  • Price > £1.00 OR Supplier = Hill Farm
  • Answer: 0001, 0002, 0004, 0008
Award 1 mark if 0001, 0002, 0004 are all in answer
Award 1 mark if 0002 and 0008 are in answer
Award 1 mark if 0002 is not repeated and there are no extra answers

Picture
2cii answer
  • Discontinued = False
  • AND
  • Quantity Left < Reorder Level

Picture
3Ai answer
  • HyperText Mark-up Language
  • Text file containing the text to be displayed...
  • ... uses tags which indicate how to display it
  • … location of pictures/other elements to include
  • ... and hyperlinks to other locations/URLS

Picture
3aii answer
  •  Web browser used to interpret the file and display the data correctly
  • Because it is an open/accepted standard...
  • ... data will display correctly on all browsers
  • ... which conform to the standard

More help here -  html explained
Picture
3b answer
Picture


More help here -  file formats
Picture
3ci answer
  • It reduces the size of the file which needs to be transmitted
  • Shortens download time
  • Reduces Internet traffic (and hence probability of lost packets)
  • Allows multimedia files to be streamed

More help here -  compression explained
Picture
3cii answer
  • In lossy compression, when the data is uncompressed it is not exactly the same as the original
  • But the difference is so small that it cannot normally be noticed
  • Eg music files(mp3), large resolution images for displaying on small screens.
  • In lossless compression, when the data is uncompressed it is restored completely to the original file
  • Eg compressed text files.
(1 mark per bullet, but maximum of 3 if no examples given).

More help here -  compression explained
Picture
4a answer
Picture


More help here - Use logic gates
Picture
4b answer
Picture
  • A B input into an AND gate
  • Result from AND gate put through a NOT gate (to give P)

More help here - Use logic gates

Picture
5a answer
Antivirus
  • Scans the computer periodically
  • To check if any software has been installed which contains code that may harm the computer
  • Removes/quarantines these programs / notifies the user
  • Prevents these programs from being installed
  • Protects the computer by preventing important files (eg the boot sector or operating system) from being changed

More help here -  Antivirus
Picture
5b answer
Disk defragmenter
  • Moves (parts of) of files around so that all parts of a file are stored together (allowing files to be accessed more quickly)
  • Free space is collected together (allowing large files to be saved easily)

More help here - Disk defrag explained
Picture
6a answer
  • 6 * 16 (= 96) / 10 (for A)
  • 106

More help here -
Picture
6b answer
0110 1010
(1 mark per nibble)


More help here - Hex to Binary
Picture
6c answer
3D
(1 mark per digit)

More help here - Binary to hex
Picture
6d answer
  • Hex numbers are shorter/more memorable than equivalent binary numbers..
  • ... and can easily be converted to and from binary...
  • ... as each hex digit corresponds to 4 binary digits
  • (accept diagram)


More help here - What is hex
Picture
7ai answer
Constant: Pi
Variables: WheelSize, Circumference

More help here -
Picture
7aii answer
  • The value of a constant is set when the constant is declared
  • The value of a variable is set while the program is running
  • The value of a constant cannot be changed once the program is running/can only be set at design time
  • A variable has no value at design time
Marks in pairs

More help here - Variables explained
Picture
7b answer
  • An integer is a whole number
  • A real number can include decimal fractions

More help here - Data types
Picture
8 answer
Points may include:
  • Physical security measures – computers/servers in locked rooms, lock down cables for laptops
  • Firewalls – allow only authorised access to the network / only authorised users/programs to share data out of the network
  • User groups/access levels – different users are given rights to different data according their responsibility/need to protect privacy
  • Passwords enforced. Should be strong and changed regularly. Ensures privacy and protects files being accessed by malicious hackers
  • Encryption of data on network
  • WiFi access security if they use WiFi
  • Get employees to sign an acceptable use policy as part of their contract to ensure they do not put the data at risk of corruption/abide by data protection legislation/do not give the data to third parties etc.

High Level Response (5/6): A good understanding with detailed descriptions of the measures and policies, explaining how they help privacy and security; The information will be presented in a structured and coherent form. There will be few, if any, errors in spelling, grammar and punctuation. Technical terms will be used appropriately and correctly.
Picture
9answer
Example:
          BEGIN
                    Input RealAge
                    IF RealAge <= 2                   
                              DogYears = RealAge * 12
                    ELSE
                              ExtraYears = RealAge – 2
                              DogYears = 24 + ExtraYears * 6
                    END IF
          END
Award marks for an algorithm which:
  • Allows real age to be input
  • If age <=2, multiply real age by 12
If age >2
  • Works out extra years (real age – 2) …
  • … multiply by 6
  • … adds 24 (for the first 2 years)

Home
Contact
Upload
Log in
  • Exam boards
    • OCR past papers >
      • Paper1 (Sample)
    • Edexcel past papers >
      • 2020 Current spec (coming soon) >
        • Programming Language Subset (PLS)
      • Old 2016 SPEC >
        • Paper 1 (specimen1)
        • Paper 1 (specimen2)
        • Paper 1 (2018)
        • Paper 1 (2019)
        • Paper 2 (specimen1)
        • Paper 2 (2018)
        • Paper 2 (2019)
      • OLD 2013 SPEC >
        • Sample assessment 1 (old spec)
        • Sample assessment 2 (old spec)
        • June 2017 (old spec)
        • June 2016 (old spec)
        • June 2015 (old spec)
    • Paper 1 (by topic) >
      • Algorithms
      • Application software
      • Ascii
      • Binary
      • Cache
      • Client Server
      • Cloud
      • Compression
      • Computational thinking
      • CPU
      • Cyber security
      • Database
      • Fetch decode execute cycle
      • Embedded system
      • Encryption
      • File size
      • Flow chart
      • Hexadecimal
      • High Level language
      • ISP/Internet
      • Logic
      • Magnetic HDD
      • Networking
      • Open source
      • Operating system
      • Peer to peer
      • Images (Data representation)
      • Protocols
      • RAM
      • ROM
      • Run length encoding
      • Simulation software
      • Solid state HDD
      • Sound
      • Stored program concept
      • Utility software
    • Curriculum >
      • Binary
      • Hex
      • Data Representation
      • Compression
      • Encryption
      • What is a computer
      • How does a computer work
      • Hardware
      • Operating system
      • The CPU
      • Input devices
      • Data storage
      • Networks
      • Microcontrollers
      • Computational models
      • Emerging trends
      • Virtual machine
      • Models and simulators
      • Algorithms
    • Python >
      • Finding python
      • GCSE Python questions
      • Python coding >
        • Comments
        • Data types
        • Variables
        • If Else
        • If Elif Else
        • Functions
        • For loop
        • While loop >
          • While loop challenges
        • Data structures >
          • Looping thru 2D array
        • String slicing/indexing
        • Subprograms
        • Local/global variable
        • Validation and try
        • methods
        • File I/O
        • Pseudocode
        • Modules >
          • Turtle
        • Classes
        • NEA/Projects
  • KS3/Other
    • KS3 >
      • Online Safety >
        • Screen time
        • Online Safety questions
      • IT
      • Hardware >
        • All Hardware
        • Magnetic hard disk drive
        • Optical disk drive
        • Solid state drive
      • Software
      • Binary/Hex/Algorithms >
        • Binary
        • Binary explained
        • Hexadecimal - 1 digit
        • Hexadecimal - 2 digits
        • Algorithms
        • ASCII
        • Tests
      • Networks
      • Protocols/Cyber attacks
      • Logic >
        • CPU
        • AND gate
        • OR gate
        • NOT gate
        • Logical statements
      • Coding >
        • HTML
        • Scratch >
          • Scratch questions
        • Python >
          • Getting started
          • Functions
          • Variables
          • VariablesToo
          • inputs
          • Selection
          • Flowcharts
          • Data types
          • Pseudocode1
          • Pseudocode2
          • Subprogram1
          • Subprogram2
          • Coding challenges
    • BTEC CS
    • OCR GCSE CS >
      • Past paper JUNE 2015
      • Past paper June 2014
      • Past paper MAY 2012
      • Past paper JAN 2011
      • Past paper JUN 2011
    • AQA AS-Level CS >
      • AS Curriculum >
        • Multiple choice questions
    • Business studies >
      • Keywords
      • BS Revision - Multiple choice
      • Paper 1 (9-1)
      • Paper 2 (9-1)
  • Contact/More
    • Code editor
    • Contact us
    • Microbit ideas
    • More
  • Self test
    • 01 Random topics
    • 02 Programming
    • 03 Data
    • 04 Computers
    • 05 Networks
    • 06 Legal/Ethics/Enviro'
    • Coding/Programming