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

When designing your interface, try to be consistent and predictable in your choice of interface elements. Whether they are aware of it or not, users have become familiar with elements acting in a certain way, so choosing to adopt those elements when appropriate will help with task completion, efficiency, and satisfaction. Interface elements include but are not limited to: • Input Controls: checkboxes, radio buttons, dropdown lists, list boxes, buttons, toggles, text fields, date field. • Navigational Components: breadcrumb, slider, search field, pagination, slider, tags, icons • Informational Components: tooltips, icons, progress bar, notifications, message boxes, modal windows • Containers: accordion

IB DP Computer Science Year 12 and 13 Questions and Answers Bank from Topic 1- Topic 4 Prepare your students for the IB DP computer science exams with over 300 questions and answers covering topics 1 to 4.

Content overview Candidates study the following topics: Computer systems 1 Data representation 2 Data transmission 3 Hardware 4 Software 5 The internet and its uses 6 Automated and emerging technologies Algorithms, programming and logic 7 Algorithm design and problem-solving 8 Programming 9 Databases 10 Boolean logic

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 Approved notation for developing pseudocode Pseudocode in Examinations • Standard Data Structures • Examples of Pseudocode

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

Year 7/8/9 Test 1- Excel Spreadsheet

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

Diploma Programme Computer science guide and curriculum

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.

MS Word Test 1 for Year 7/8 and 9

Learning Objectives: 12.1 Program Development Life cycle Show understanding of the purpose of a development life cycle Show understanding of the need for different development life cycles depending on the program being developed (Including, waterfall, iterative, rapid application development (RAD) Describe the principles, benefits and drawbacks of each type of life cycle Show understanding of the analysis, design, coding, testing and maintenance stages in the program development life cycle. 12.2 Program Design Use a structure chart to decompose a problem into sub-tasks and express the parameters passed between the various modules / procedures / functions which are part of the algorithm design Describe the purpose of a structure chart Construct a structure chart for a given problem Derive equivalent pseudocode from a structure chart. Show understanding of the purpose of state-transition diagrams to document an algorithm. 12.3 Program Testing and maintenance Show understanding of ways of exposing and avoiding faults in programs. Locate and identify the different types of errors: syntax errors logic errors run-time errors Correct identified errors Show understanding of the methods of testing available and select appropriate data for a given method (Including dry run, walkthrough, white-box, black-box, integration, alpha, beta, acceptance, stub) Show understanding of the need for a test strategy and test plan and their likely contents. Choose appropriate test data for a test plan (Including normal, abnormal and extreme/boundary) Show understanding of the need for continuing maintenance of a system and the differences between each type of maintenance (Including perfective, adaptive, corrective) Analyze an existing program and make amendments to enhance functionality

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

Lesson Objectives: 5.1 Operating System Explain why a computer system requires an Operating System (OS)Explain the key management tasks carried out by the Operating System:Including memory management, file management, security management, hardware management (input / output / peripherals), process management.Show understanding of the need for typical utility software provided with an Operating System:Including disk formatter, virus checker, defragmentation software, disk contents analysis/disk repair software, file compression, back-up software.Show understanding of program libraries: Including: • software under development is often constructed using existing code from program libraries• the benefits to the developer of software constructed using library files, including Dynamic Link Library (DLL) files. Learning Objective: 5.2 Language Translators Show understanding of the need for:• assembler software for the translation of an assembly language program• a compiler for the translation of a high-level language program• an interpreter for translation and execution of a high-level language programExplain the benefits and drawbacks of using either a compiler or interpreter and justify the use of each Show awareness that high-level language programs may be partially compiled and partially interpreted,such as JavaDescribe features found in a typical Integrated Development Environment (IDE)Including:• for coding, including context-sensitive prompts• for initial error detection, including dynamic syntax checks• for presentation, including prettyprint, expand and collapse code blocks• for debugging, including single stepping, breakpoints, i.e. variables, expressions, report window

IGCSE Cambridge Computer Science Approved Pseudocode and logical gate

Lesson Objectives: Lesson 1 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 Lesson 2 Understand the motion commands with Python turtle module Understand the use of Variables and how to assign them values. Understand the use of different commands such as PenUp/PenDown, goto, forward, backward, left, right and t.begin_fill() & t.end_fill(), t.goto(x,y), t.setposition(x,y), t.pensize(value), t.setheading(value), t.color(‘green’) Lesson 3 What you’re aiming for in this lesson is to: familiarize yourself with the various code statements play with the code and learn how to change and adapt it. For example, if you have the code for a small red square, you should be able to change it to make a big yellow square. be able to use the code we have developed for various shapes to create a picture.

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

**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