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.
Excel Spreadsheets
Full Lesson If Statements and Graph
**Objectives **
• Understand the use of absolute cell referencing.
• Understand the use of simple functions (sum,max,min and average in a spreadsheet.
• Understand the use of If statements including the logical, true and false statements.
• Understand how calculations can be used as True statements
• Understand the use of nested if statements including more than one true statement.
• Understand the use of count and sum if functions.
• Understand the need the need to present data in a graph format.
• Understanding the need to present information in different forms (graphs)
DatabaseStructured Query Language (SQL)
What is SQL?
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
What Can SQL do?
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
Using SQL in Your Web Site
To build a web site that shows data from a database, you will need:
An RDBMS database program (i.e. MS Access, SQL Server, MySQL)
To use a server-side scripting language, like PHP or ASP
To use SQL to get the data you want
To use HTML / CSS to style the page
**What is RDBMS? **
RDBMS stands for Relational Database Management System.
RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.
The data in RDBMS is stored in database objects called tables. A table is a collection of related data entries and it consists of columns and rows.
8.1 Database Concepts
8.2 Database Management System (DBMS)
8.3 Data Definition Language (DDL) and Data Manipulation Language (DML)
Show understanding of the limitations of using a file-based approach for the storage and retrieval of data
Describe the features of a relational database that address the limitations of a file-based approach
Show understanding of and use the terminology associated with a relational database model: Including entity, table, record, field, tuple, attribute, primary key, candidate key, secondary key, foreign key, relationship (one-to-many, one-to-one, many-to-many), referential integrity, indexing
Use an entity-relationship (E-R) diagram to document a database design
Show understanding of the normalization process: First Normal Form(1NF), Second Normal Form (2NF) and Third Normal Form (3NF)
Explain why a given set of database tables are, or are not, in 3NF
Produce a normalized database design for a description of a database, a given set of data, or a given set of tables
Show understanding of the features provided by a Database Management System (DBMS) that address the issues of a file based approach Including:
data management, including maintaining a data dictionary
data modelling
logical schema
data integrity
data security, including backup procedures and the use of access rights to individuals / groups of users
Show understanding of how software tools found within a DBMS are used in practice, Including the use and purpose of:
developer interface
query processor
Show understanding that DBMS carries out all creation / modification of the database structure using its Data Definition Language (DDL)
Show understanding that the DBMS carries out all queries and maintenance of data using its DML
Show understanding that the industry standard for both DDL and DML is Structured Query Language (SQL): Understand a given SQL script
Understand given SQL (DDL) commands and be able to write simple SQL (DDL) commands using a sub-set of commands
Create a database (CREATE DATABASE)
Create a table definition (CREATE TABLE), including the creation of attributes with appropriate data types:
CHARACTER,VARCHAR(n), BOOLEAN,INTEGER,REAL,DATE,TIME
change a table definition (ALTER TABLE)
add a primary key to a table (PRIMARY KEY (field))
add a foreign key to a table (FOREIGN KEY (field) REFERENCES Table (Field))
Write an SQL script to query or modify data (DML) which are stored in (at most two) database tables :
Queries including SELECT… FROM, WHERE, ORDER BY, GROUP BY, INNER JOIN, SUM, COUNT, AVG
Data maintenance including. INSERT INTO, DELETE FROM, UPDATE
Learning Objectives:
12.1 Program Development Life cycle
Show understanding of the purpose of a development life cycle
Show understanding of the need for different development life cycles depending on the program being developed (Including, waterfall, iterative, rapid application development (RAD)
Describe the principles, benefits and drawbacks of each type of life cycle
Show understanding of the analysis, design, coding, testing and maintenance stages in the program development life cycle.
12.2 Program Design
Use a structure chart to decompose a problem into sub-tasks and express the parameters passed between the various modules / procedures / functions which are part of the algorithm design
Describe the purpose of a structure chart
Construct a structure chart for a given problem
Derive equivalent pseudocode from a structure chart.
Show understanding of the purpose of state-transition diagrams to document an algorithm.
12.3 Program Testing and maintenance
Show understanding of ways of exposing and avoiding faults in programs.
Locate and identify the different types of errors:
syntax errors
logic errors
run-time errors
Correct identified errors
Show understanding of the methods of testing available and select appropriate data for a given method (Including dry run, walkthrough, white-box, black-box, integration, alpha, beta, acceptance, stub)
Show understanding of the need for a test strategy and test plan and their likely contents.
Choose appropriate test data for a test plan (Including normal, abnormal and extreme/boundary)
Show understanding of the need for continuing maintenance of a system and the differences between each type of maintenance (Including perfective, adaptive, corrective)
Analyze an existing program and make amendments to enhance functionality
11.1 Programming Basics
11.2 Constructs
11.3 Structured Programming
11.1 Programming Basics
Implement and write pseudocode from a given design presented as either a program flowchart or structured English
Write pseudocode statements for:
• the declaration of variables and constants
• the assignment of values to variables and constants
• expressions involving any of the arithmetic or logical operators input from the keyboard and boutput to the console.
Use built-in functions and library routines
Any functions not given in the pseudocode guide will be provided
String manipulation functions will always be given
11.2 Constructs
Use pseudocode to write:
• an ‘IF’ statement including the ‘ELSE’ clause and nested IF statements
• a ‘CASE’ structure
• a ‘count-controlled’ loop:
• a ‘post-condition’ loop
• a ‘pre-condition’ loop
Justify why one loop structure may be better suited to solve a problem than the others
**11.3 Structured Programming **
Define and use a procedure
Explain where in the construction of an algorithm it would be appropriate to use a procedure.
Use parameters: A procedure may have none, one or more parameters and A parameter can be passed by reference or by value.
Define and use a function
Explain where in the construction of an algorithm it is appropriate to use a function.
A function is used in an expression, e.g. the return value replaces the call.
Use the terminology associated with procedures and functions: including Procedure / function header, procedure / function interface, parameter, argument, return value
Write efficient pseudocode
Python 3 Sheet from KS3/4 and 5 . From Laurent Pointal (License Creative Commons Attribution 4) . thanks to a wonderful resources from Laurent Pointal (License Creative Commons Attribution 4)
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
Attached year 8 python programming practical test 1, 2 and end of term exam
Please feel free to leave any comments and rate the review . Thank you
Mr. N.T
1: Identify and use the standard symbols for logic gates
2: Define and understand the functions of the logic gates
3:Use logic gates to create given logic circuits and Truth Table and write a logic expression