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.
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 .
MOS 2010 Study Guide for Microsoft Word Expert, Excel Expert, Access , and SharePoint Exams
Taking a Microsoft Office Specialist Exam
Desktop computing proficiency is increasingly important in today’s business world. As
a result, when screening, hiring, and training employees, employers can feel reassured
by relying on the objectivity and consistency of technology certification to ensure the
competence of their workforce. As an employee or job seeker, you can use technology
certification to prove that you already have the skills you need to succeed, saving current
and future employers the trouble and expense of training you.
MOS 2010 Study Guide is from Microsoft
Enjoy and good luck if you are taking the MOS exams
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.
In this chapter you will learn about:
1.3.3 Input devices
•• describe the principles of operation (how each device works) of these input devices: 2D and 3D scanners, barcode readers, Quick Response (QR) code readers, digital cameras, keyboards, mice, touch screens, interactive whiteboards, microphones.
•• describe how these principles are applied to real-life scenarios, for example: scanning of passports at airports, barcode readers at supermarket checkouts, and touch screens on mobile devices.
•• describe how a range of sensors can be used to input data into a computer system, including light, temperature, magnetic field, gas, pressure, moisture, humidity, pH and motion
•• describe how these sensors are used in real-life scenarios, for example: street lights, security devices, pollution control, games, and household and industrial applications.
1.3.4 Output device
•• describe the principles of operation of the following output devices: inkjet, laser and 3D printers; 2D and 3D cutters; speakers and headphones; actuators; flat-panel display screens, such as Liquid Crystal Display (LCD) and Light-Emitting Diodes (LED) display; LCD projectors and Digital Light Projectors (DLP).
•• describe how these principles are applied to real-life scenarios, for example: printing single items on demand or in large volumes; use of small screens on mobile devices.
Upon completion of this chapter, you should be able to answer the following questions:
Define hardware, giving examples
Define software, giving examples
Describe the difference between hardware and software
Identify the main components of a general-purpose computer: central processing unit, main/internal memory (including ROM and RAM), input devices, output devices and secondary/backing storage
Identify operating systems, including those which contain a graphical user interface, a command line interface
Identify different types of computer including Personal Computer or desktop, mainframe, laptop, palmtop and Personal Digital Assistant
Describe recent developments in ICT
How do I open the case?
What is the process to install the power supply?
How do I attach the components to the motherboard and install the motherboard?
How do I install internal drives?
How do I install drives in external bays?
How do I install adapter cards?
What is the process to connect all internal cables?
How do I reattach the side panels and connect external cables to the computer?
What happens when I boot the computer for the first time
Study Guide for Microsoft Word Expert, Excel Expert, Access , and more
Taking a Microsoft Office Specialist Exam
Desktop computing proficiency is increasingly important in today’s business world. As
a result, when screening, hiring, and training employees, employers can feel reassured
by relying on the objectivity and consistency of technology certification to ensure the
competence of their workforce. As an employee or job seeker, you can use technology
certification to prove that you already have the skills you need to succeed, saving current
and future employers the trouble and expense of training you.
Microsoft Office Specialist (MOS 2013) Study Guide is from Microsoft
Enjoy and good luck if you are taking the MOS exams