ICT Year 7 or 8 Test - Hardware and Software Component

Diploma Programme Computer science guide and curriculum

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

Y11 Practical Exam with answer for Word/Excel and PowerPoint 2010

IB DP Year 12/13-Test 3 - Topic 2 with Question and Answers

IGCSE Computer Science for Year 10 and 11- Term 1-Test 2 from chapter 2 /3 and 4 Questions and Answers

IB DP Year 12/13-Test 4-Topic 2 and 3 with Question and Answers

IB DP Computer Science - Year 12/13 - Test 2- V2 - Topic 2

Binary and Hexadecimal numbers Exam for Year 9 and 10 with answer: You have three different set exams included in this assessment Please make sure you inform your students to revise the following topics: Convert Decimal number to binary Convert Binary to Decimal number Convert Decimal number to Hexadecimal Convert Hexadecimal to Decimal Convert Binary to Hexadecimal Convert Hexadecimal to Binary Add and subtract hexadecimal

3.1 Computers and their components 3.2 Logic Gates and Logic Circuits

5.1 The internet and the world wide web 5.2 Digital currency 5.3 Cyber security

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

14.1 Protocols 14.2 Circuit switching, packet switching

This practical activities using Python programming will teach student how to Encrypt and Decrypt

18.1 Artificial Intelligence

4.1 Types of software and interrupts 4.2 Types of programming language, translators and integrated development environments (IDEs)

8.1 Database Concepts 8.2 Database Management System (DBMS) 8.3 Data Definition Language (DDL) and Data Manipulation Language (DML)

**Paper 1- Chapter 3: Hardware ** **3.1 Computer architecture ** 1- (a): Understand the role of the central processing unit (CPU) in a computer. (b): Understand what is meant by a microprocessor. 2- (a): Understand the purpose of the components in a CPU, in a computer that has a Von Neumann architecture. (b): Describe the process of the fetch–decode–execute cycle including the role of each component in the process. **Paper 2 - Chapter 7: Algorithm design and problem-solving ** **7.4 Algorithm design and problem-solving ** 4 - Understand standard methods of solution. • linear search • bubble sort

Lesson Objectives By the end of this lesson student should be able to identify the various methodologies through which devices can establish connectivity with a network. Furthermore, they will be able to explain and articulate the distinctive characteristics and functionalities associated with each type of connection. Understand the advantages and disadvantages of using Networks. Difference between WWW and internet. Understand Local Area Network (LAN), Wide Area Network (WAN):

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.