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.
Blogger is an online service owned by Google that publishes single or multi-user blogs created entirely by the user. The service has quickly become the preferred choice of many novice bloggers and is one of the easiest methods of creating and publishing a blog for free. If you are unfamiliar with the service, this steps will teach you how to set up an account and create a blog on Blogger.com
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.
•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
4.1 Central Processing Unit (CPU) Architecture:
Show understanding of the basic Von Neumann model for a computer system and the stored program concept
Show understanding of the purpose and role of registers, including the difference between general
purpose and special purpose registers.
Special purpose registers including:
• Program Counter (PC)
• Memory Data Register (MDR)
• Memory Address Register (MAR)
• The Accumulator (ACC) • Index Register (IX)
• Current Instruction Register (CIR)
• Status Register
Show understanding of the purpose and roles of the Arithmetic and Logic Unit (ALU), Control Unit (CU) and system clock, Immediate Access Store (IAS)
Show understanding of how data are transferred between various components of the computer system using the address bus, data bus and control bus
4.2: Assembly Language:
Show understanding of the relationship between assembly language and machine code.
Describe the different stages of the assembly process for a two-pass assembler
Trace a given simple assembly language program
Show understanding that a set of instructions are grouped
Including the following groups:
Data movement
Input and output of data
Arithmetic operations
Unconditional and conditional instructions
Compare instructions
Show understanding of the different modes of addressing
Including Immediate, direct, indirect, indexed, relative
4.3: Bit manipulation:
Show understanding of and perform binary shifts
logical, arithmetic and cyclic
Left shift, right shift
Show understanding of how bit manipulation can be used to monitor / control a device
Carry out bit manipulation operations
Test and set a bit (using bit masking)
Declare and use one-dimensional arrays, for example: A[1:n]
Show understanding of the use of one-dimensional arrays, including the use of a variable as an index in an array
Read or write values in an array using a FOR … TO … NEXT loop
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
This HTML Beginner’s Guide assumes that you have no previous knowledge of HTML.
It should be quite easy to follow if you work through each step, which are all brought together at the end of this lesson.
Show understanding of the need for input, output, primary memory and secondary (including removable) storage.Describe the principal operations of hardware devices Show understanding of the use of buffersExplain the differences between Random Access Memory (RAM) and Read Only Memory (ROM)Explain the differences between Static RAM (SRAM) and Dynamic RAM (DRAM)Explain the difference between Programmable ROM (PROM), Erasable Programmable ROM (EPROM) and Electrically Erasable Programmable ROM (EEPROM)Show an understanding of monitoring and control systems
Candidates should be able to:Use the following logic gate symbols:
Understand and define the functions of: NOT, AND, OR, NAND, NOR and XOR (EOR) gatesConstruct a logic circuitConstruct a truth tableConstruct a logic expression
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 that every computer system is made up of sub-systems, which in turn are made up of further sub-systems
Use top-down design, structure diagrams, flowcharts, pseudocode, library routines and sub-routines
Work out the purpose of a given algorithm
Explain standard methods of solution
Suggest and apply suitable test data
Understand the need for validation and verification checks to be made on input data (validation could include range checks, length checks, type checks and check digits)
Use trace tables to find the value of variables at each step in an algorithm
Identify errors in given algorithms and suggest ways of removing these errors
Produce an algorithm for a given problem (either in the form of pseudocode or flowchart)
Comment on the effectiveness of a given solution