Lesson Objectives All of you will… Draw simple shapes using the turtle Understand the use of different commands such as move forward, backward, left, right Most of you will… Use computational thinking skills to look for repeating patterns and include them in your programming Table of Contents: Lesson 1: Motion Commands with Python turtle module Lesson 2: Main Colour Commands Lesson 3: Main Circle Commands Lesson 4: More Color Examples Lesson 5: Turtle Shapes Lesson 6: Loopy loops in Python Lesson 7: Numbers, Variables, functions print and input Lesson 8: Logical Operators, Conditional Statements Lesson 9: Strings, Lists Lesson 10: Random Numbers Lesson 11: Functions

10.1 Data Types and Records: Select and use appropriate data types for a problem solution including integer, real, char, string, Boolean, date (pseudocode will use the following data types: INTEGER, REAL, CHAR, STRING, BOOLEAN, DATE, ARRAY, FILE) Show understanding of the purpose of a record structure to hold a set of data of different data types under one identifier Write pseudocode to define a record structure. Write pseudocode to read data from a record structure and save data to a record structure 10.2 Arrays: Use the technical terms associated with arrays (Including index, upper and lower bound) Select a suitable data structure (1D or 2D array) to use for a given task Write pseudocode for 1D and 2D arrays Write pseudocode to process array data Sort using a bubble sort Search using a linear search 10.3 Files: Show understanding of why files are needed Write pseudocode to handle text files that consist of one or more lines 10.4 Introduction to Abstract Data Types (ADT): Show understanding that an ADT is a collection of data and a set of operations on those data. Show understanding that a stack, queue and linked list are examples of ADTs Describe the key features of a stack, queue and linked list and justify their use for a given situation Use a stack, queue and linked list to store data (You will not be required to write pseudocode for these structures, but they should be able to add, edit and delete data from these structures) Describe how a queue, stack and linked list can be implemented using arrays

Year 7/8/9 Project 2- Computer Shop - Excel Spreadsheet

Diploma Programme Computer science guide and curriculum

Typing Formal Letter using Microsoft Word Please feel free to leave any comments and rate the review . Thank you Mr. N.T

MS EXCEL Practical Test for Year 7/8 and 9

Year 7/8/9 Test 1- Excel Spreadsheet

Year 7/8/9 Project 1- Party- Excel Spreadsheet

IGCSE Cambridge Computer Science Approved Pseudocode and logical gate

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

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

Paper 2: Algorithms, programming and logic Chapter 8: Programming 8.1 Programming concepts 8.2 Arrays 8.3 File handling

Core syllabus content SL core The topics that must be studied, including some practical work are: • Topic 1: System fundamentals (20 hours) • Topic 2: Computer organization (6 hours) • Topic 3: Networks (9 hours) • Topic 4: Computational thinking, problem-solving and programming (45 hours)

This HTML Beginner’s Guide assumes that you have no previous knowledge of HTML. It should be quite easy to follow if you work through each step, which are all brought together at the end of this lesson.

IB DP Computer Science -Y12/13- Internal Assessment (IA) The Internal Assessment for Computer Science is an opportunity for you to showcase your algorithmic and technical prowess at developing software intended to solve a legitimate, real world problem for someone.

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

**Designing Strong Bridges with Popsicle Sticks ** with marking scheme Introduce the problem statement. In this project, your challenge is to design and build a bridge using only popsicle sticks and glue. Your goal is to create a bridge that showcases strong structural concepts and makes the most of how much weight it can carry compared to its own weight. The focus is on making a bridge that works really well and can support a lot of weight while using only a few materials. Let’s explore the world of building strong bridges and see how well you can balance making it strong and creative in your design.

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

Step by Step database practical activities how to download a csv file and how to do query and report in database and create a relationship between two tables. NB: Please make sure you download Movie and football excel and convert them to csv file and Football along the practical activities. Please feel free to leave any comments or review. Thank you Mr.N.T

• Understand the use of absolute cell referencing. • Understand the use of simple functions (sum,max,min and average) in a spreadsheet. • Understand the use of If statements including the logical, true and false statements. • Understand how calculations can be used as True statements • Understand the use of nested if statements including more than one true statement. • Understand the use of count and sum if functions. • Understand the need the need to present data in a graph format. • Understanding the need to present information in different forms (graphs) Thanks to our dear colleagues Mr. Yasar Ahmed for his tremendous work for developping reources in ICT and please click the link below where you can find a lot of resources for your ICT subjects from year 7 - 12.