OCR H446/01 – 1.3 Exchanging data

Posted on by Administrator Posted in H446 - Computer Science A Level (OCR)
1.3 Exchanging data - Overview / Checklist
1.3.1 Compression, Encryption and Hashing
(a) Lossy vs Lossless compression.
(b) Run length encoding and dictionary coding for lossless compression.
(c) Symmetric and asymmetric encryption.
(d) Different uses of hashing
1.3.2 Databases
(a) Relational database, flat file, primary key, foreign key, secondary key, entity relationship modelling, normalisation and indexing.
(b) Methods of capturing, selecting, managing and exchanging data.
(c) Normalisation to 3NF.
(d) SQL – Interpret and modify.
(e) Referential integrity.
(f) Transaction processing, ACID (Atomicity, Consistency, Isolation, Durability), record locking and redundancy.
1.3.3 Networks
(a) Characteristics of networks and the importance of protocols and standards.
(b) The internet structure:

    The TCP/IP Stack.
    DNS
    Protocol layering.
    LANs and WANs.
    Packet and circuit switching.

(c) Network security and threats, use of firewalls, proxies and encryption.
(d) Network hardware.
(e) Client-server and peer to peer.

1.3.4 Web Technologies
(a) HTML, CSS and JavaScript.
(b) Search engine indexing.
(c) PageRank algorithm.
(d) Server and client side processing.

Recommended Resources

1.3.1 Compression, Encryption and Hashing
Symmetric and asymmetric encryption

Symmetric vs. Asymmetric Encryption


Cryptography Challenges

Hashing Algorithms

Hashing Algorithms for Integrity Validation

Hashing Algorithms for Storing Sensitive Data

Hashing Algorithms for Memory Addressing


Luhn Algorithm UPC Barcode Check Digit Algorithm

Lossy and Lossless Compress

Lossless Compression: Huffman Coding Algorithm


Lossless Compression Poem Decoding Challenge

1.3.2 Databases
Relational Databases

Relational Databases

Learn SQL


Relation Databases Crossword Relational Databases – Question Time The Stolen Gemstones (SQL Task) The Bike Shop (SQL Task) The Computer Shop (SQL Task) Driving School (ERD Task) Rent-A-Bike (ERD Task) Hair & Beauty Salon (ERD Task) French Cuisine (ERD Task) web2.0 (ERD Task) EasyFlights Database (ERD Task)

Exchanging data (JSON, XML) using an API
Real Time ISS Tracker Weather Forecast API What-3-Words Localisation API Real-time Asteroid Watch Currency Converter using an API

1.3.3 Networks

Network Design

Network Design Tasks


Small Office Network (Network Design Task) The Retro-Gaming Internet Café (Network Design Task) TCP/IP Protocols and Packet Switching The TCP/IP Stack: Layers & Protocols Daily Protocolometer IP Addresses (IPv4, IPv6), MAC addresses and URLs Network Design – Drag and Drop Computer Networks – Quiz Computer Networks – Terminology Computer Networks – Crossword Network Design – Quiz Computer Networks – Acronyms Computer Networks – Noughts and Crosses The Mesh Network Puzzle Wired and Wireless Connection Methods

1.3.4 Web Technologies

Client-Server Technologies in a Web-Based Application

Search Engine Indexing and Page Rank Algorithm


Page Rank Algorithm – Take the Quiz!

HTML, CSS and JavaScript

HTML and CSS Quizzes


CSS Noughts and Crosses Quiz Build your own website from scratch using HTML and CSS Extra HTML, CSS and JavaScript Challenges

Did you like this challenge?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 4

No votes so far! Be the first to rate this post.

As you found this challenge interesting...

Follow us on social media!


Other challenges you may enjoy...