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