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.
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
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
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
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
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