Free Educational Resources from Mr. Noureddine Tadjerout
Average Rating4.64
(based on 35 reviews)
I am a versatile professional with a diverse skill set and a strong background in education and technology. As an accomplished Author, Teacher Trainer, Examiner, and certified Apple Teacher and VEX Robotics. I have honed my expertise in Computer Science and Mathematics education. Additionally, I hold the role of Curriculum Development Specialist, focusing on Computer Science, Engineering, and Microsoft Office. I am passionate about creating educational resources and assisting fellow educators.
I am a versatile professional with a diverse skill set and a strong background in education and technology. As an accomplished Author, Teacher Trainer, Examiner, and certified Apple Teacher and VEX Robotics. I have honed my expertise in Computer Science and Mathematics education. Additionally, I hold the role of Curriculum Development Specialist, focusing on Computer Science, Engineering, and Microsoft Office. I am passionate about creating educational resources and assisting fellow educators.
Students should be able to:
Roles of the different computers within the network and subnetwork models Benefits and drawbacks of each model Justify the use of a model for a given situation
Understand how packets are transmitted between two hosts for a given topology
Justify the use of a topology for a given situation
Including the use of public and private clouds.
Benefits and drawbacks of cloud computing
Describe the characteristics of copper cable, fibreoptic cable, radio waves (including WiFi), microwaves, satellites Including switch, server, Network Interface Card (NIC), Wireless Network Interface Card (WNIC), Wireless Access Points (WAP), cables, bridge, repeater Including Carrier Sense Multiple Access / Collision Detection (CSMA / CD) Methods of bit streaming, i.e. real-time and
on-demand Importance of bit rates / broadband speed on bit streaming
Including modems, PSTN (Public Switched Telephone Network), dedicated lines, cell phone network
• format of an IP address including IPv4 and IPv6
• use of subnetting in a network
• how an IP address is associated with a device on a network
• difference between a public IP address and a private IP address and the implications for security
• difference between a static IP address and a dynamic IP address
Content overview
Candidates study the following topics:
Computer systems
1 Data representation
2 Data transmission
3 Hardware
4 Software
5 The internet and its uses
6 Automated and emerging technologies
Algorithms, programming and logic
7 Algorithm design and problem-solving
8 Programming
9 Databases
10 Boolean logic
Learning objectives : VLOOKUP and HLookUp
Understand the use of the Vlookup function
Understand the use of absolute cell referencing.
Understand the use of an nested if statement.
Understand the used of the different count functions.
Understand the use of the sumif function.
**Designing Strong Bridges with Popsicle Sticks ** with marking scheme
Introduce the problem statement.
In this project, your challenge is to design and build a bridge using only popsicle sticks and glue. Your goal is to create a bridge that showcases strong structural concepts and makes the most of how much weight it can carry compared to its own weight. The focus is on making a bridge that works really well and can support a lot of weight while using only a few materials. Let’s explore the world of building strong bridges and see how well you can balance making it strong and creative in your design.
•Understand and use pseudocode for assignment, using ←
•understand and use pseudocode, using the following conditional statements:
IF
… THEN … ELSE … ENDIF
CASE
… OF … OTHERWISE … ENDCASE
•U nderstand and use pseudocode, using the following loop structures:
FOR
… TO … NEXT
REPEAT
… UNTIL
WHILE
DO … ENDWHILE
•U nderstand and use pseudocode, using the following commands and statements:
INPUT and OUTPUT (e.g. READ and PRINT)
totalling (e.g. Sum ← Sum +
counting (e.g. Count ← Count +
•U nderstand and use standard flowchart symbols to represent the above statements,
Key Objectives in this unite 2- Pseudocode and flowcharts are to revise:
Pseudocode:
Assignment
Loop structures
Input and output
Standard actions
Flowcharts:
Symbols
Chapter 9- Databases
Candidates should be able to:
1 Define a single-table database from given data storage requirements
2 Suggest suitable basic data types
3 Understand the purpose of a primary key and identify a suitable primary key for a given database table
4 Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table
Notes and guidance
• Including:
– fields
– records
– validation
• Including:
– text/alphanumeric
– character
– Boolean
– integer
– real
– date/time
• Limited to:
– SELECT
– FROM
– WHERE
– ORDER BY
– SUM
– COUNT
• Identifying the output given by an SQL statement that will query the given contents of a database table
Pseudocode Guide for Teacher and Students Cambridge International AS & A Level Computer Science 9618
Please click the link below to follow Pseudocode in examined components:
The following information sets out how pseudocode will appear within the examined components and is provided to allow you to give learners familiarity before the exam.
Also Python vs Pseudocode for IGCSE and AS/A level,. Thanks to the professional teacher Awab Aqib for his Kind contribution
Declare and use variables and constants
Understand and use basic data types: Integer, Real, Char, String and Boolean
Understand and use the concepts of sequence, selection, repetition, totalling and counting
Use predefined procedures/functions