Back

Computer Science OII

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Welcome to Computer Science 2210 for Olevel 2

This year we will learn additional topics of:

PAPER 1:

3. Hardware

6. Automated and emerging technologies

 

PAPER 2

7. Algorithm design and problem-solving (continued)

8. Programming (continued)

9. Databases

Additionally we will revise the following topics

PAPER 1:

1. Data Representation 

2. Data Transmission 

5. The Internet and its uses

 

PAPER 2

7. Algorithm design and problem-solving

8. Programming

10. Boolean logic

 

By the end of this course Students will complete 80% of their Cambridge International Examination Syllabus for Computer Science 2210

What Will You Learn?

  • Paper 1 (Topic 1,2,5) and Paper 2 (Topic 7,8,10) for Cambridge International Examinations of Computer Science 2210

Course Content

Chapter 9: Databases

  • Introduction to a single table database
    00:00
  • Basic Data Types of Fields
    00:00
  • Primary Key- Purpose and Identification
    00:00
  • Structured Query Language (SQL) scripts
    00:00
  • Chapter 9: WB Assignment
  • Chapter 9: Cambridge WB Assignment

Chapter 3: Hardware

Chapter 6: Automated and emerging technologies

Chapter 1: Data representation – Revision
In this chapter you will learn about: ★ number systems – how and why computers use binary to represent data – the denary, binary and hexadecimal number systems – converting numbers between denary, binary and hexadecimal – how and why hexadecimal is used for data representation – how to add two positive 8-bit numbers – overflow when performing binary addition – logical binary shifts on positive 8-bit integers – two’s complement notation to represent positive and negative binary numbers ★ text, sound and images – how and why a computer represents text – the use of character sets including ASCII and Unicode – how and why a computer represents sound – sound sample rate and sample resolution – how and why a computer represents an image – the effects of the resolution and colour depth on images ★ data storage and compression – how data storage is measured – calculating the file size of an image and sound file – the purpose of and need for data compression – lossy and lossless compression.

Chapter 2: Data transmission – Revision
In this chapter you will learn about: ★ types and methods of data transmission – how data is broken up into data packets before transmission – the structure of data packets (header, payload and trailer) – packet switching (including the role of the router in the process) – methods of data transmission (serial, parallel, simplex, half-duplex and full-duplex) – the Universal Serial Bus (USB) ★ methods of error detection – why error checking methods are needed – error checking methods following data transmission: – parity checks – checksum – echo check – use of check digits to detect data entry errors – use of automatic repeat requests (ARQs) to detect errors ★ encryption – the need for and the purpose of encryption – symmetric and asymmetric encryption – use of public and private keys.

Chapter 5: The Internet and its uses – Revision
In this chapter you will learn about: 5.1★ the internet and the World Wide Web 1. the differences between the internet and the World Wide Web 2. what is meant by a uniform resource locator (URL) 3. the purpose and operation of hypertext transfer protocols (HTTP and HTTPS) 4. the purpose and function of a web browser 5. how web pages are located, retrieved and displayed 6. cookies (including session and persistent cookies) 5.2 ★ digital currency 1. digital currencies and how they are used 2. the process of blockchaining and how it is used to track digital currency transactions 5.3 ★ cyber security 1. cyber security threats 2. solutions to keep data safe from security threats.

Chapter 7: Algorithm design and problem solving – Revision
In this chapter, you will learn about: ★ the stages in the program development cycle: – analysis – design – coding – testing ★ computer systems and sub-systems ★ problem decomposition into component parts ★ methods used to design and construct solutions to problems ★ the purpose of an algorithm and the processes involved in it ★ standard methods of solution: – linear search – bubble sort – totalling – counting – finding average, maximum, minimum ★ validation checks when data is input ★ verification checks when data is input ★ use of different types of test data including: – documentation of a dry run using a trace table ★ writing, amending, identifying, and correcting errors in: – flowcharts – programs – pseudocode.

Chapter 8: Programming
In this chapter, you will learn about: ★ programming concepts: – use of variables and constants – input and output – sequence – selection including nesting – iteration – totalling and counting – string handling – operators – arithmetic, logical and Boolean – procedures and functions including the use of: – parameters – local and global variables – library routines – creating a maintainable program ★ arrays: including one- and two-dimensional arrays, use of indexes, use of iteration for reading from and writing to arrays ★ file handling: including opening, closing, reading from and writing to data and text files.

Chapter 10: Boolean Logic- Revision
In this chapter, you will learn about: ★ the identification, definition, symbols and functions of the standard logic gates: NOT, AND, OR, NAND, NOR and XOR ★ how to use logic gates to create logic circuits from: – a given problem – a logic expression – a truth table ★ how to complete truth tables from: – a given problem – a logic expression – a logic circuit ★ how to write a logic expression from: – a given problem – a logic circuit – a truth table.

Resources for Students OII
Syllabus

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕