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.

Student Feedback Form part of the Evaluation for Learning and Support Mr. N.T

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.

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

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

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):

Class Observation Form

Logic gates

MS Word for Year 8 and 9 Mail Merge practical activities

14.1 Protocols 14.2 Circuit switching, packet switching

10.1 Data Types and Records 10.2 Arrays 10.3 Files 10.4 Introduction to Abstract Data Types (ADT)

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 the Java Programming level 1 basic concepts and skills for creating simple compute programs using java programming language. Students will learn topics related to Java programing syntax and structure, primitive data types and operators. Students will also learn how to define and use conditional statements, loops and array their programs.

A character is any single letter, number, symbol, or punctuation mark. A font is a set of characters that have the same design. Each font has a unique name, such as Arial. Font sizes are measured in points. Point size refers to the height of characters. Another way to change the size of text is to select the text and click the Grow Font button to increase the font size or the Shrink font button to decrease the text. In this exercise, you learn to use Word’s quick styles to apply paragraph styles and character styles to selected text and paragraphs within your document. Please feel free to leave any comments and rate the review . Thank you Mr. N.T

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