Free Educational Resources from Mr. Noureddine Tadjerout
Average Rating4.62
(based on 33 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.
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
Objective:
•Understand the use of the different operators in Python.
•Explain What is an algorithm, Pseudocode and Flowchart?
•Understand the following terms, (IF , ELSE & ELIF)
Outcomes:
Explain the use of an IF and Else statement
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 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
9.1 Computational Thinking Skills:
Show an understanding of abstraction
Need for and benefits of using abstraction
Describe the purpose of abstraction
Produce an abstract model of a system by only including essential details
Describe and use decomposition
Break down problems into sub-problems leading to the concept of a program module (procedure / function)
9.2 Algorithms:
Show understanding that an algorithm is a solution to a problem expressed as a sequence of defined steps.
Use suitable identifier names for the representation of data used by a problem and represent these using an identifier table
Write pseudocode that contains input, process and output
Write pseudocode using the three basic constructs of sequence, selection and iteration (repetition)
Document a simple algorithm using pseudocode
Write pseudocode from:
a structured English description
a flowchart
Describe and use the process of stepwise refinement to express an algorithm to a level of detail from which the task may be programmed
Use logic statements to define parts of an algorithm solution
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