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.
• 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)
Thanks to our dear colleagues Mr. Yasar Ahmed for his tremendous work for developping reources in ICT and please click the link below where you can find a lot of resources for your ICT subjects from year 7 - 12.
Lesson Objectives
By the end of this lesson student should be able to identify the various methodologies through which devices can establish connectivity with a network. Furthermore, they will be able to explain and articulate the distinctive characteristics and functionalities associated with each type of connection.
Understand the advantages and disadvantages of using Networks.
Difference between WWW and internet.
Understand Local Area Network (LAN), Wide Area Network (WAN):
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
Step by Step database practical activities how to download a csv file and how to do query and report in database and create a relationship between two tables.
NB: Please make sure you download Movie and football excel and convert them to csv file and Football along the practical activities.
Please feel free to leave any comments or review. Thank you
Mr.N.T
Lesson Objectives: 5.1 Operating System
Explain why a computer system requires an Operating System (OS)Explain the key management tasks carried out by the Operating System:Including memory management, file management, security management, hardware management (input / output / peripherals), process management.Show understanding of the need for typical utility software provided with an Operating System:Including disk formatter, virus checker, defragmentation software, disk contents analysis/disk repair software, file compression, back-up software.Show understanding of program libraries: Including: • software under development is often constructed using existing code from program libraries• the benefits to the developer of software constructed using library files, including Dynamic Link Library (DLL) files.
Learning Objective: 5.2 Language Translators
Show understanding of the need for:• assembler software for the translation of an assembly language program• a compiler for the translation of a high-level language program• an interpreter for translation and execution of a high-level language programExplain the benefits and drawbacks of using either a compiler or interpreter and justify the use of each Show awareness that high-level language programs may be partially compiled and partially interpreted,such as JavaDescribe features found in a typical Integrated Development Environment (IDE)Including:• for coding, including context-sensitive prompts• for initial error detection, including dynamic syntax checks• for presentation, including prettyprint, expand and collapse code blocks• for debugging, including single stepping, breakpoints, i.e. variables, expressions, report window
Lesson Objectives:
Lesson 1
All of you will…
Draw simple shapes using the turtle
Understand the use of different commands such as move forward, backward, left, right
Most of you will…
Use computational thinking skills to look for repeating patterns and include them in your programming
Lesson 2
Understand the motion commands with Python turtle module
Understand the use of Variables and how to assign them values.
Understand the use of different commands such as PenUp/PenDown, goto, forward, backward, left, right and t.begin_fill() & t.end_fill(), t.goto(x,y), t.setposition(x,y), t.pensize(value), t.setheading(value), t.color(‘green’)
Lesson 3
What you’re aiming for in this lesson is to:
familiarize yourself with the various code statements
play with the code and learn how to change and adapt it. For example, if you have the code for a small red square, you should be able to change it to make a big yellow square.
be able to use the code we have developed for various shapes to create a picture.
Chapter 7: Ethics and Ownership
7.1 Legal, Moral, Ethical and Cultural implication
7.2 Copyright issues
7.3 Artificial Intelligence
Show understanding of the need for and purpose of ethics as a computing professional
Understand the importance of joining a professional ethical body including BCS (British Computer Society), IEEE (Institute of Electrical and Electronic Engineers).
Show understanding of the need to act ethically and the impact of acting ethically or unethically for a given situation.
Show understanding of the need for copyright legislation
Show understanding of the different types of software licensing and justify the use of a license for a given situation.
Licenses to include free Software Foundation, the Open Source Initiative, shareware and commercial software.Show understanding of Artificial Intelligence (AI)
Understand the impact of AI including social, economic and environmental issues
Understand the applications of AI
Show understanding of the difference between: primary, secondary and off-line storage and provide examples of each, such as:
Primary: Read Only Memory (ROM) and Random Access Memory (RAM)
Secondary: hard disk drive (HDD) and Solid State Drive (SSD); off-line: Digital Versatile Disc (DVD), Compact Disc (CD), Blu-ray disc, USB flash memory and removable HDD
Describe the principles of operation of a range of types of storage device and media including magnetic, optical and solid state.
Describe how these principles are applied to currently available storage solutions, such as SSDs, HDDs, USB flash memory, DVDs, CDs and Blu-ray discs.
Calculate the storage requirement of a file.
introduce students to computer programming and games in a fun and exciting way. The Scratch software used in this transition unit was designed with this goal in mind. Students will be able to write their own programs, animations and stories in a matter of minutes. Students will learn how to plan and design projects. They will learn how to work together on a plan in teams and they will have the opportunity to present their work to their peers and teachers. They will learn how to respond and react to feedback. They will research a project on the Internet and learn how to evaluate information on websites.
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
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
Show understanding of computer ethics, including copyright issues and plagiarism
Distinguish between free software, freeware and shareware
Show understanding of the ethical issues raised by the spread of electronic communication and computer systems, including hacking, cracking and production of malware
Practical activities Software and Hardware (Software Tools for PC Maintenance) and Quiz
ICT – Hardware Part and Software security
Please feel free to leave a review. Thank you
Mr.Noureddine Tadjerout
Show understanding of how data are kept safe when stored and transmitted, including:
use of passwords, both entered at a keyboard and biometric
use of firewalls, both software and hardware, including proxy servers
use of security protocols such as Secure Socket Layer (SSL) and Transport Layer Security (TLS)
use of symmetric encryption (plain text, cypher text and use of a key) showing understanding that
increasing the length of a key increases the strength of the encryption
Show understanding of the need to keep online systems safe from attacks including denial of service attacks, phishing, pharming.
Describe how security can be applied to real-life scenarios including, for example, online banking, shopping or safeguards when carrying out online transactions .