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.

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

Test 2 - Topic 1—System fundamentals: 1.1 Systems in organizations

2.1 Computer organization Computer architecture Secondary memory Binary representation Simple logic gates

STEAM Project for Year 7/8 and 09 Sustainability City Development Project

ICT-Year 8 and 9 Type of computer components Test

MS Word worksheet for Year 8

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 .

1.1 Systems in organizations 1.2 System design basics

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

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

13.1 User-defined data types 13.2 File organisation and access 13.3 Floating-point numbers, representation and manipulation

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.

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

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

MS Word Worksheet for year 9

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.

Blockly Game block programming Practical Exam with Answer for Year 6 and 7

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

Practical Exam for Year 10 and 11 ( Python programming /JavaScript and MySQL database) with answers