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

IB DP Computer Science Past Paper 1 and 2 (Year 2023)

Microsoft word practical activities Please feel free to leave any comments and rate the review . Thank you Mr. N.T

Attached year 8 python programming practical test 1, 2 and end of term exam Please feel free to leave any comments and rate the review . Thank you Mr. N.T

Spread sheet Features Creating and Manipulating Data, Formatting Data and Content, Creating and Modifying Formulas Presenting Data Visually and Collaborating and Securing Data Working with MS Excel 2010 & Formatting Data and Ranges Working with Data and Using Basic & Advanced Formulas and Functions Formatting and Managing Worksheets Creating Charts, PivotTables, and adding Pictures and Shapes

Microsoft PowerPoint Presentation practical basics activities for Year 7 Please feel free to leave any comment of review. Thank you Mr. N.T

Microsoft word worksheet and activities for year 7

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

Lesson Plan and Full Lesson 6: Use two’s complement to represent positive and negative 8-bit binary integers. • Convert a positive binary or denary integer to a two’s complement 8-bit integer and vice versa • Convert a negative binary or denary integer to a two’s complement 8-bit integer and vice versa

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

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?

Computational Thinking Exam V2 with Answer for Y7 and 8

**IB DP Diploma Programme updates 2024-2027 ** Welcome to the Diploma Programme updates, the new name for Coordinator’s notes. The name change has been introduced as a result of feedback from stakeholders and to reflect the fact that this regular publication contains important information for the whole IB community. This more compact publication features content that is brand new or especially relevant for the forthcoming assessment session. The decision to remove older content was made as a result of discussions with stakeholders. All previous editions of the Diploma Programme (DP) Coordinator’s notes and Programme updates are available on the Programme Resource Centre at DP resources > Implementation > Information for coordinators > Diploma Programme updates. Please send any feedback on the new look to support@ibo.org. In addition to contacting schools directly, the International Baccalaureate (IB) will post updates regarding upcoming assessment sessions or curriculum amendments on the IB website, ibo.org. Schools and educators are reminded that official IB information is published through the Programme Resource Centre. Resources shared through social media and other channels are unofficial. For general IB news and information—for example, research news and professional development (PD) opportunities—please refer to the monthly newsletter IB Global News. Coordinators will automatically receive newsletters via email using the email address they have entered into the IB information system (IBIS)

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.

Attached Computational Thinking Exam with solution , Computational Thinking classroom activities and full CT lesson by CS Unplugged for year 6/7/8/9 pupils.

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

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.

Tracing Table Question and Answer Questions 14 with full details Section B – Year May 2019

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

Students should be able to: Roles of the different computers within the network and subnetwork models Benefits and drawbacks of each model Justify the use of a model for a given situation Understand how packets are transmitted between two hosts for a given topology Justify the use of a topology for a given situation Including the use of public and private clouds. Benefits and drawbacks of cloud computing Describe the characteristics of copper cable, fibreoptic cable, radio waves (including WiFi), microwaves, satellites Including switch, server, Network Interface Card (NIC), Wireless Network Interface Card (WNIC), Wireless Access Points (WAP), cables, bridge, repeater Including Carrier Sense Multiple Access / Collision Detection (CSMA / CD) Methods of bit streaming, i.e. real-time and on-demand Importance of bit rates / broadband speed on bit streaming Including modems, PSTN (Public Switched Telephone Network), dedicated lines, cell phone network • format of an IP address including IPv4 and IPv6 • use of subnetting in a network • how an IP address is associated with a device on a network • difference between a public IP address and a private IP address and the implications for security • difference between a static IP address and a dynamic IP address