Learning objectives : VLOOKUP and HLookUp Understand the use of the Vlookup function Understand the use of absolute cell referencing. Understand the use of an nested if statement. Understand the used of the different count functions. Understand the use of the sumif function.

ICT Year 7 or 8 Test - Hardware and Software Component

Basic Python programming for Year 7/8/9/10/11 and 12 . I will keep uodating the lessons.

ICT-Year 8 and 9 Type of computer components Test

MIT App Inventor is an intuitive, visual programming environment that allows everyone – even children – to build fully functional apps for smartphones and tablets. Those new to MIT App Inventor can have a simple first app up and running in less than 30 minutes. And what’s more, our blocks-based tool facilitates the creation of complex, high-impact apps in significantly less time than traditional programming environments. The MIT App Inventor project seeks to democratize software development by empowering all people, especially young people, to move from technology consumption to technology creation. Please click the link to access MIT App inventor below : https://appinventor.mit.edu/explore/ai2/tutorials

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

ICT Test for Year 8 and 9 MS Word and MS PowerPoint

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

Revision Python print/input and data type for Year 8 and 9

1- Define hardware as consisting of physical components of a computer system 2- Identify internal hardware devices (e.g. motherboards, random access memory (RAM), read-only memory (ROM), video cards, sound cards and internal hard disk drives) 3- Identify external hardware devices and peripherals (such as monitors, keyboards, mice, printers as input and output device 4- Define software as programs for controlling the operation of a computer or processing of electronic data 5- Identify the two types of software applications software and systems software 6- Define applications software (e.g. word processing, spread sheet, database management systems, control software, measuring software , photo-editing software, video-editing software, graphics manipulation software) 7- Define system software (e.g. compilers, linkers, device A big thanks for Mr Ahmed for his tremendous effort on the IGCSE ICT

E-learning can be defined as the use of computer and Internet technologies to deliver a broad array of solutions to enable learning and improve performance. E-Learningg has become an important part of our educational system and has changed the way we view teaching as a whole. E-Learning in today generation has developed and improve the core aspects of teaching and has made schools perform more efficiently or more productively and quickly.

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.

Practical Scratch Block Programming exams with answer and project activities and more for Year 7

The opening of Amazon Go has flooded the Moments. Customers will shop o n Amazon Go after downloading the Amazon Go App and connecting the ir debit card with the app . During shopping , a product will be shown on the Amazon Go App if chosen from the shelf, and will automatically be canceled if put back on the shelf. When you have selected your items and are ready to leave, the payment of the order will be automatically completed in the app . With benefits brought by the new science and technology of artificial intelligence, users’ behaviors can be accurately identified by a large number of cameras or even microphones, which is a great step for us to enter an intelligent life. Have you though t about the concepts and principles implied in artificial intelligence technology while you are expressing the great convenience that Amazon Go brings to life?

Python challenge exercises with solution for year 8/9/10 Enjoy

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

In Term 1- This course is designed to provide students with fundamental Knowledge related to computer science. It also introduces students to Computational thinking and how computers work. In Term 2 - 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. In Term 3 - 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.

In Term 1- This course is designed to provide students with fundamental Knowledge related to computer science. It also introduces students to Computational thinking and how computers work. In Term 2- This course defines the competency level require to understand and explore the basic programming concepts/ principles while using a friendly mobile app creation environment (Blockly games programming), which mainly designed to create simple animations and fun games. It enables the learner to write scripts on mobile devices and traditional PCs. By going through this course, learners shall be well prepared to move on to HTML5, JavaScript, and more. In Term 3 - This course defines the competency level require to understand and explore the basic programming concepts/ principles while using a friendly mobile app creation environment (Blockly games programming), Blockly Games is a series of educational games that teach programming. It is designed for students who have not had prior experience with computer programming. By the end of these games, players are ready to use conventional text-based languages which mainly designed to create simple animations and fun games. It enables the learner to write scripts on mobile devices and traditional PCs. By going through this course, learners shall be well prepared to move on to HTML5, JavaScript, and more.

In Term 1- This course is designed to provide students with fundamental Knowledge related to computer science. It also introduces students to Computational thinking and how computers work. In Term 2- This course defines the competency level require to understand and explore the basic programming concepts/ principles while using a friendly mobile app creation environment (Blockly games programming), which mainly designed to create simple animations and fun games. It enables the learner to write scripts on mobile devices and traditional PCs. By going through this course, learners shall be well prepared to move on to HTML5, JavaScript, and more. In Term 3- This course defines the competency level require to understand and explore the basic programming concepts/ principles while using a friendly mobile app creation environment (Blockly games programming), Blockly Games is a series of educational games that teach programming. It is designed for students who have not had prior experience with computer programming. By the end of these games, players are ready to use conventional text-based languages which mainly designed to create simple animations and fun games. It enables the learner to write scripts on mobile devices and traditional PCs. By going through this course, learners shall be well prepared to move on to HTML5, JavaScript, and more.

This course adopts a step-by-step, project-based approach to teach students level 2 Java programming and concepts and skills for creating simple compute programs using java programming language. Java’s unique architecture enables programmers to develop a single application that can run across multiple platforms reliably seamlessly. In this hands-on course, students gain extensive experience with Java and its object-oriented features. Students will be able to explore and use classes, use methods and develop syntax to create windows components and change appearance of the components also Students learn to create robust console and GUI applications.