Scribd
Upload
4 views4 pages

IGCSE Computer Science Homework

This document outlines homework activities for IGCSE/GCSE Computer Science, focusing on advanced programming, database design, algorithms, web development, and cybersecurity. It includes specific activities for binary conversions, search algorithms, Python programming, web development structure, sorting algorithms, network functions, and cybersecurity measures. The document emphasizes the importance of ethical computing practices in relation to cybersecurity vulnerabilities.

Uploaded by

Francisco S. DR
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views4 pages

IGCSE Computer Science Homework

This document outlines homework activities for IGCSE/GCSE Computer Science, focusing on advanced programming, database design, algorithms, web development, and cybersecurity. It includes specific activities for binary conversions, search algorithms, Python programming, web development structure, sorting algorithms, network functions, and cybersecurity measures. The document emphasizes the importance of ethical computing practices in relation to cybersecurity vulnerabilities.

Uploaded by

Francisco S. DR
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

IGCSE / GCSE Computer Science Homework

Learning Objectives

This homework consolidates your learning and prepares you for IGCSE/GCSE:

- Advanced programming concepts and problem-solving

- Database design and query writing

- Algorithm analysis and optimization

- Web development fundamentals

- Cybersecurity and ethical computing

Week 1 Activities

Activity 1: Advanced Binary and Hexadecimal

Binary Conversions:

57 = 00111001

128 = 10000000

255 = 11111111

Decimal Conversions:

11010110 = 214

10101010 = 170

Hexadecimal:

175 = AF
3F = 63

11110000 = F0

Two’s Complement:

+25 = 00011001

-25 = 11100111

11010110 = -42

Why hexadecimal is useful:

Hexadecimal shortens binary values and makes them easier to read and debug.

Activity 2: Algorithms

Linear search is used for unsorted lists.

Binary search is used for sorted lists.

Linear Search:

Best O(1), Average O(n), Worst O(n), Sorted: No

Binary Search:

Best O(1), Average O(log n), Worst O(log n), Sorted: Yes

Activity 3: Python Programming

Total of list [3,7,2,9,1] = 22

Average = 4.4

Functions included:
is_even(num)

find_max(numbers)

Activity 4: Databases

Entities:

Books, Students, Loans, Staff

Primary key uniquely identifies records.

Foreign key links tables.

Data validation ensures accuracy.

Week 2 Activities

Activity 5: Web Development

HTML structure includes headings, lists, images, and footer.

CSS styles layout, text, and hover effects.

Activity 6: Sorting Algorithms

Bubble Sort final result:

[12, 22, 25, 34, 64]

Insertion Sort is best for nearly sorted data.

Merge Sort is best for large datasets.

Activity 7: Networks

Router forwards data between networks.


DNS converts domain names to IP addresses.

Activity 8: Cybersecurity

SQL Injection prevented using validation.

DDoS prevented using firewalls.

MITM prevented using encryption.

Social Engineering prevented using training.

Ethics:

Companies must fix vulnerabilities and inform users.

You might also like