Cambridge Technicals - IT - Level 03 - Unit 06 - Application Design - M/507/5005 - Materials

Cambridge Technicals - IT - Level 03 - Unit 06 - Application Design - M/507/5005 - Materials

Cambridge Technicals - IT - Level 03 - Unit 06 - Application Design - M/507/5005 - Delivery Materials - First 3 LO’s are easy then making the aplication gets vague. Prototype modelling, do not do unit unless oyu are willing to create an application that eets a specific criteria. Any issues downloading, email me at enderoth@hotmail.com or go to www.freeschoolresources.com after August whennthe website has been redone.
enderoth
Producing Robust Programs 2 - Test Data Part 1

Producing Robust Programs 2 - Test Data Part 1

A year 10 resource I created as part 2 of 3 lessons on Creating Robust Programs. This lesson introduces the outcomes and LOs below using exam-style questions and Quality Assurance based industry experience. Outcomes: • Understand why we Test. • Describe the types of testing: Iterative and Terminal. • Describe the types of errors: Syntax, Logic and Runtime. Learning Objectives: • Pupils to undertake QA testing exercise of a real game, Mac tech permitting. • Pupils to refactor badly factored code. • Pupils to explain reasons for, iterative and terminal testing in their books. • Pupils to answer exam questions on error types (Syntax and logic). PowerPoint, resources and lesson plan template included.
MickeyTheMoo
Excel Chart Types Activity

Excel Chart Types Activity

This resource can be used during a lesson with Excel Charts. It is useful to become familiar with different chart types and their application. The activities can be carried out individually, in pairs or in teams. It is always more fun to team up, as two heads are better than one and lots of discussion can be generated. Files are available in both pdf and docx format for editing if required. Preparation for Mix N Match Activity: Print out the document named ‘Chart Type Activity Answers’ Laminate the sheets (optional) Cut out all the segments Learners now match up all three elements (Chart name, Description, Picture). This activity can be timed and completed in teams to add a competitive edge. Other Activity Options: Print out the document named ‘Chart Type Activity without Chart Type’. Learners will review the description and the pictorial view and name the Chart Type. Print out the document named ‘Chart Type Activity without Description’. Hand out the cut outs of ‘Descriptions’. Learners place them in the appropriate slot. Print out the document names ‘Chart Type Activity without Picture’. Hand out the cut outs of ‘Pictures’. Learners place them in the appropriate slot.
Resource_Creator
GUESS WHO COMPUTATIONAL THINKING CHALLENGE (STEM & DIGITAL TECHNOLOGIES )

GUESS WHO COMPUTATIONAL THINKING CHALLENGE (STEM & DIGITAL TECHNOLOGIES )

☀️ This has got to be one of our most engaging STEM activities yet!!! An absolute cracker of a resource for teaching COMPUTATIONAL THINKING, ALGORITHMS, MATHS and TECHNOLOGY. The challenge is simple… CAN YOU CREATE THE PERFECT FACIAL RECOGNITION ALGORITHM? It draws upon the classic game “GUESS WHO?” to instantly engage students with ease. The learning is incredibly deep and this resource could easily FILL A WEEK of class time or a single 90 minute session depending on how far you wish to go… And it’s completely EDITABLE Whats inside ⭐Computational Thinking resources and activities related to the topic ⭐Teacher Hints and Tips ⭐ Complete lesson plans ⭐ Facial Recognition Lessons and Content ⭐ Removable / Hints and Tips for Beginners ⭐ Lessons on Data and Attributes ⭐ Custom made Graphic Organizers ⭐ Custom made Flowcharting Activities ⭐ Heaps of digital video and interactive content ⭐ Literacy related tasks to the ethics of facial recognition ⭐ Glossary of terms ⭐ Video tutorial explaining the perfect solution ⭐ Assessment and Reflection Tool Compatibility with Google Classroom and NO PREP REQUIRED
Innovativeteachingideas
Microbit- a lazy set of 6 problem-solving lessons

Microbit- a lazy set of 6 problem-solving lessons

This is a great set of lessons for microbit that require NO prep on the teacher, entirely student led, guaranteed to create engagement. Perfect for year 7 but could be extended to year 8 and 9 as well. my students love it! it gives opportunity for discussion,planning, pseudocode,flowchrt, testing. each lesson has a real life problem that the students need to solve using the microbit I used the microbit “let’s create” block editor online software (which will give simulation of the real microbit on days when i am too lazy to even get the microbits off the shelf!),though my higher students are asked to complete it in Python once they have solved the problem successfully in the block editor.
annetortue
Python Random Values Practical Challenges

Python Random Values Practical Challenges

A great 2 page handout for your pupils to practice using random values in Python. Includes example code, a task to read code, a task to correct code and 4 practical challenges for them to practice writing for loops in Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
nwilkin
Scratch UltraBundle - 3 Units

Scratch UltraBundle - 3 Units

This bundle includes the Scratch beginner’s bundle, intermediate bundle and expert bundle all in one. I have used this for Years 5-7, using one unit each year as they move up the school. This could be used for other year groups as they encounter and improve with Scratch. Each unit should take 6-8 lessons, which is why I have spread them out over three year groups. In total there are 18 different resources bundled together here.
MrHawes8
KS2 / KS3 Scratch Expert Bundle

KS2 / KS3 Scratch Expert Bundle

This bundle is the third in a series of Scratch units, intended for KS3 or possibly high ability KS2 students. The first two lessons include looking at flowcharts and creating an algorithm using a flowchart, which then feeds into creating the game in Scratch. The third lesson involves creating a slug trail maze, which draws on what they might have done previously in creating mazes and drawing with the pen tool. The fourth lesson is more in depth with a look at variables and iteration, creating an endless scrolling flying game. The fifth lesson involves debugging and coding a Space Invaders-style game using starter code. This task includes subroutines and is the hardest of the unit. The unit ends with a project (3+ lessons) where the students create their own game based on some loose instructions. They then write about how they have made their game using a template in Powerpoint.
MrHawes8
KS3 Scratch Game Project

KS3 Scratch Game Project

This resource is a set of instructions for KS3 students to create their own game. Ideally they will be at or near to finishing with Scratch before moving on to more complex programming languages. This is intended for the end of my KS3 Scratch Unit of work. Included is the Word document which details what they will need to include in their game (and what they might want to include), as well as an example game evaluation written in Powerpoint to make it easy for them to write about. There is also a skeleton evaluation which describes what they need to include in their evaluation. As the students can create their own game and need to write about how they have made it, this is likely to take a minimum of three lessons.
MrHawes8
KS3 Scratch Space Intruders game tutorial

KS3 Scratch Space Intruders game tutorial

This resource includes a finished Space Invaders-style game made with Scratch, as well as a starter code version of the game and a tutorial/help sheet. This is intended for one lesson to help teach variables and subroutines. The finished version can be shown as a demonstration of how the game should work, then the students can be shown the starter code. This version does not work, and they will need to complete the tasks on the tutorial to get it working correctly. The tutorial includes screenshots of code snippets and explanations of how any why they work to get the game functioning correctly.
MrHawes8
KS3 Endless scrolling game scratch tutorial

KS3 Endless scrolling game scratch tutorial

This resource is a tutorial to help students understand how variables and iteration are used to create a simple scrolling game. The tutorial includes screenshots of code snippets and instructions on how and why the code works to create the finished version of the game. The resource also includes the finished version of the game, which I use to demonstrate the game before showing the first few steps in making it. The tutorial can be used as a help sheet for students who push on further with the game before the rest of the class, or who might need help in getting their game to work as intended.
MrHawes8
KS2/KS3 slug trail maze tutorial

KS2/KS3 slug trail maze tutorial

In this resource is a working version of a ‘slug trail’ maze game, and a Word document tutorial to go with it. The tutorial can be given to students as a help sheet once they have been given an introductory demonstration, or if they are pushing on further than the rest of the class. The tutorial help sheet includes screenshots of code and explains how and why this code is used to create the finished version of the game.
MrHawes8
KS3 Scratch Flowcharts 2-lesson mini project

KS3 Scratch Flowcharts 2-lesson mini project

Included in this resource is a Powerpoint which is helpful in recapping flowcharts and then leads into a programming task involving a number guessing game. The students should be aiming to make a flowchart based on the first two tasks in the project, which will help them move on to programming them in Scratch in the second lesson. There is a card sort which involves writing the instructions onto blank paper symbols to form the flowchart, and examples of each task as a flowchart and scratch game. This has been used with Year 7 following two previous units using Scratch, as a warm up for programming as well as a reminder of flowcharts and their usefulness in planning programs.
MrHawes8
Scratch DIRT SHEET - Assessment

Scratch DIRT SHEET - Assessment

Created this DIRT sheet for my Year 8’s but can be used for any year group. SIMPLE TO FOLLOW Teacher can look through their scratch projects and tick the boxes the pupils have covered in their Project. Pupils can then reflect on their project and suggest improvements they could make.
LUKEB82
Scratch Programming Fractal Tree Activity

Scratch Programming Fractal Tree Activity

One of the areas of the national curriculum that we should be introducing students to is RECURSION. This is an excellent activity to introduce that concept in a visual way with a simple task to create a fractal tree in Scratch programming. This activity I had a learning observation on. I had my students work in small groups to try and complete the main activity together. When they finished this, they were to research other fractal activities on-line and see what they could create. Students really enjoyed this activity at the end of the Scratch topic to introduce a very complex topic that is not part of GCSE, but that appears again at IB level and A level. I expect students to learn that recursion is a complex rule that simplifies programs, but is very difficult to understand and it is a function that uses itself to solve a problem.
PaperAirplane
Scratch Programming Test 2 + Answers

Scratch Programming Test 2 + Answers

End of section test (I use with Y8 students) to assess their comprehension of coding using Scratch (I have uploaded my unit of work which goes with this. This is used a long with the assessment activity uploaded in the other unit of work, to check student progress. This is a problem solving assessment which tests students abilities to read and interpret code, as well as explain it. Checks their logical and computational thinking skills and ability to spot and correct errors.
PaperAirplane
[GCSE + IGCSE] Introduction to Algorithms (Problem Solving)

[GCSE + IGCSE] Introduction to Algorithms (Problem Solving)

This is the unit that I complete before I start programming with my GCSE students. It features a variety of problem solving activities that I use to introduce Flow Charts and Pseudocode. This has massively helped my students understand the concepts and process of planning before progressing onto writing code. This covers a lot of the concepts of Unit 1 and Unit 2 from the curriculum. Introduces the ideas of Abstraction, Decomposition, Algorithms etc
PaperAirplane
[GCSE+IGCSE] Strings, Functions and Procedures Unit

[GCSE+IGCSE] Strings, Functions and Procedures Unit

This is my Strings, Functions and Procedures unit that I use in the lead up to the end of Term 1 at Christmas. It compromises 9 individual tasks. Each of these tasks, I take at least two lessons to deliver with students. I start off each with some starter questions (included file) and a discussion of the task. At this point, I would expect my students to be comfortable with planning in pseudcocode and flow charts. For each activity, I either get them to design it for Scratch, or I create a partially completed plan which they then fill in the blanks (These are usually hand drawn, so I didn’t include them) We then code the solutions which normally takes a full lesson. To support and challenge students, several activities contain challenging scenarios to keep better students engaged allowing me to support weaker students to aim towards completing minimum requirements. After we completely implement them, we spend time discussing test plans, the purpose of testing etc. This covers a lot of the theory in the course of looking at modular testing, why we use predefined functions/procedures, how large groups of programmers work together to decompose a task and implement it simultaneously etc. For each of the 9 activities included, I have included blank student files (when they are required) tested solutions for each activity and the overview of the task with instructions. For this activity, it will require a bit of teacher input to explain task at the beginning. At this point, I show students the completed activity, so they know what they are aiming to produce. For my weaker students, I give them a copy of the completed code (eventually) and get them to add internal commentary, or do testing. In some cases, I make simple syntax errors in it and get them to fix it. This activity booklet takes me around 8-10 weeks off 3 lessons per week. We use the Christmas themed lessons at the end, this introduces/recovers arrays, as well as some challenging problem solving that we all work on in groups to complete.
PaperAirplane
Excel Pivot Table Exercise / Task

Excel Pivot Table Exercise / Task

This resource has been developed as a practice Exercise for learners who have been introduced to Pivot Tables in Excel. It is a practical task that can be undertaken in teams, pairs or individually. It includes a set of data that needs to be analysed. Learners are required to brainstorm questions that a Sales Manager would need to know about the transactional data. They then create pivot tables based on the questions. There is a second spreadsheet that contains 8 sample questions and pivot tables that relate to the questions. This activity has been well received in my classroom of adult learners. They become very engaged in the process and develop a better understanding of the use of pivot tables.
Resource_Creator
[GCSE] Computer Science Python FULL COURSE

[GCSE] Computer Science Python FULL COURSE

I have recently updated my coding activities. This is my introductory unit that I use in the first year of GCSE. It starts of with basics such as inputs and outputs, complex selection (IF) statements, building up to introductory arrays tasks. I have included links to the tutorial videos for the tasks which require them. I have included the student ‘starter’ files for some of the programs that require them I have included solution python files for the majority of tasks. The booklet has about 15 individual tasks. Several of these have extension tasks. Some of the individual tasks are actually a set of 10-15 challenging coding questions. This represents my full first year of introducing Python coding to GCSE level. I have other follow up activity booklets after this one that focus on STRING manipulation, FUNCTIONS, ARRAYS and 2D ARRAYS including FILE READING AND WRITING as well as some exemplar PROJECT PRACTICE tasks which I will be uploading shortly. I have uploaded the booklet in word format, so you can make changes if necessary and taken off the front cover. I have also included a PPT of starter questions which I use at the beginning of the lessons. I have uploaded separately some of the End of Topic quizzes which assess the understanding of this area. I have also included an activity in here which I use as an introduction to the GCSE coursework, but it is scaled down and appropriate to the material covered I haven’t included solutions for the challenges, or for the activities with the video support - if you think that you need these, please email me, but if you are following the scheme of work, they should be good problem solving practice.
PaperAirplane
[GCSE Computer Science] 2D Arrays Introduction [IGCSE also]

[GCSE Computer Science] 2D Arrays Introduction [IGCSE also]

A series of activities to introduce students to 2D arrays. This is an area my students regularly struggled with understanding the concept. This year their test results were much improved compared to my last year groups - I believe this is mainly down to spending more time on getting students to visualise where data is, how it is stored and accessed. We spent a week on this activity - discussing the theory at the beginning of the lesson, tracing the execution, coding the solutions and then practicing writing flow charts for the equivalent pseudocode. I also updated this to work with records, but I will upload as a separate resource,
PaperAirplane
Cluedo murder mystery riddle - adaptation from Einstein's '5 houses' logic puzzle

Cluedo murder mystery riddle - adaptation from Einstein's '5 houses' logic puzzle

**Mr Black has been found dead at Tudor Manor. ** You are the lead investigating detective. You have all six suspects brought to the main hall of the mansion, seated next to each other around a circular table. Every one of them has a motive to murder Mr Black, but only one committed the crime. Can you solve the case and bring the killer to justice? Who killed Mr Black? What weapon was used? Where was the weapon hidden? This activity is an adaptation of mine based off Einstein’s ‘five houses’ logic problem Students extract relevant information from text; create an appropriate data structure to record these facts; and use a process of elimination to solve the problem I have been using it with KS4/5 Computer Science classes to demonstrate computational thinking (abstraction and decomposition)
mailmikejenkins
[GCSE + IGCSE] Computer Science Programming (Visual Basic)

[GCSE + IGCSE] Computer Science Programming (Visual Basic)

Advanced programming resources for teaching IGCSE + GCSE Computer Science and beyond This is also useful for anyone teaching IB Computer Science using Visual Basic 8 individual ‘activities’ with advanced challenges for each. More than 8 lessons work once I build in introduction, designing of the code and plenary reviews at end of lessons. Taking our time to build up skills, do traces on the code etc, each takes (or could take) three lessons to thoroughly cover the knowledge
PaperAirplane
WEBSITE Development Performance Assessment for Assignments > CHECKLIST & RUBRIC

WEBSITE Development Performance Assessment for Assignments > CHECKLIST & RUBRIC

This Checklists is a quick way to assess if a performance task has been completed according to the assignment objectives. Specifically designed for Web Development projects. Appropriate for creating original websites, or for redesigns. This checklist is a quick, accurate way to assess student knowledge. Teachers can evaluate projects using this Rubrics, and it can also be used to set student expectations. Standards Addressed Include: ~ Website Organization ~ Design and Technical Skills ~ Research and Validation ~ Communication and Navigation ~ Project Planning and Management
PattyAnnsPetProject
IGCSE Computer Science Records, Arrays, 2D arrays Tasks

IGCSE Computer Science Records, Arrays, 2D arrays Tasks

Three different activities to introduce the concept of how data is stored in 2D arrays and records. Some complex problem solving to decrypt a short message using the Vigenere Cipher Covers some theory as why arrays are better than individual variables and how records and arrays differ.
PaperAirplane
Presentation:   how to test a system (x11 slides)

Presentation: how to test a system (x11 slides)

The presentation introduces the idea behind testing and covers the ideas behind the idea of creating a test plan, difference between a fault and an error and shows a blue screen error. It describes the importance of reliability, using different test data (typical, erroneous, exaggerated data) and how to formulate a test plan.
Teacher_aesg
KS3 Computing - Cryptography Unit of Work - Lesson Presentations, Worksheets and Assessment

KS3 Computing - Cryptography Unit of Work - Lesson Presentations, Worksheets and Assessment

This is a whole unit of work that this aimed at KS3 - it covers all aspects of Cryptography that the students have absolutely loved doing and this has been uploaded to Google Classroom and made the whole unit very interactive. The work is split into Flight Paths and contains an assessment. All work has stretch and challenge extension tasks too. This is a really enjoyable unit of work for about 6 weeks.
cheekieclaire
Teach yourself the ENTIRE AQA GCSE Computer Science specification

Teach yourself the ENTIRE AQA GCSE Computer Science specification

Looking for a complete solution to help you get to grips with the AQA Computer Science GCSE (9-10)? Need to feel more confident with the subject matter? Not sure how to approach some areas of the curriculum? Want a ready-to-use resource that is ideal for use in the classroom, for homework tasks and self-study? “Nichola thank you. They have saved me a lot of time" Matt - Computing Teacher We have created 7 detailed PDF student workbooks that EXACTLY match the AQA GCE (9-1) Computer Science (8520) specification. Each includes theory, tasks to recap the knowledge and put new skills into practice. they even include the answers! Seperatly these would cost £150 but if you buy them as part of this bundle it only costs £100 saving you a massive £50. “Love these packs - saved me so much work” Laura - Head of Computing Perfect for non-specialist teachers, NQTs or teachers who feel a little unsure about the qualification content and want some ready-to-use tasks to use in class. “Love your revision books. Your resources are such a life saver!” Katie - Non-specialist computing teacher Provided as seven separate PDF documents: • Fundamentals of algorithms • Programming • Fundamentals of data representation • Computer systems • Fundamentals of computer networks • Fundamentals of cyber security • Ethical, legal and environmental impacts of digital technology on wider society, including issues of privacy “Brilliant. These have been fab and my students love them.” Debbie - Computing Teacher These are ideal to use in the classroom, as homework tasks or for independent study as revision for the examinations.
nwilkin
Computer Science: Programming with pseudocode and Python AQA (9-1) GCSE

Computer Science: Programming with pseudocode and Python AQA (9-1) GCSE

Great for AQA (9-1) GCSE Computer Science revision and help with the programming project. This workbook covers the AQA GCSE Computer Science (8520) specification section 3.2 “Programming”. It includes a 116-page PDF document including theory, tasks and includes all the answers. Whenever possible pseudocode is shown alongside the Python code to allow students to compare the similarities and differences between them. Perfect for NQTs, non-specialist teachers or teachers who feel a little unsure about the qualification content and want to improve their subject knowledge. Also ideal as a teaching resource and covers programming in Python from the basics to more advanced techniques including writing to text files, 2D arrays and using subroutines. It also gives help on planning robust programs and testing programs along with the difference between an interpreter, a compiler and an assembler. Table of contents: Data types Variables and constants Iteration Selection Subroutines (procedures and functions Global and local variables Operators One-dimensional arrays Two-dimensional arrays Input and Output Reading from and writing to a text file String handling operations Random number generation Structuring programming Robust and secure programming Data Validation Creating a simple authentication routine Testing your programs Low-level and high-level languages Translators Other workbooks in this series: * Fundamentals of Algorithms GCSE revision student workbook Fundamentals of Data Representation GCSE revision student workbook * Computer Systems GCSE revision student workbook Fundamentals of Computer Networks GCSE revision student workbook Cyber Security GCSE revision student workbook Ethical, legal and environmental impacts
nwilkin
Cosmopolitan Coding - Fun INSET Introduction to Coding

Cosmopolitan Coding - Fun INSET Introduction to Coding

Many teachers were never taught the coding and computer science elements of the new curriculum themselves. This introductory activity helps teachers understand the simplicity of using algorithms as instructions to complete tasks. Teachers will learn: Algorithms and how these are simple instructions Syntax and how this is simply known action in new language Problem solving and debugging code Testing code to see if it works Teachers love this INSET introduction!
EuphoricEd
Testing and Review Sheet

Testing and Review Sheet

A double sided / 2-page document that is used for testing and peer reviewing a product or item. The testing and review is general purpose and can be applied to most items that have been developed or created, including programs / software. Aimed mainly at KS3 students but can also be used with KS4 students and easily adaptable if required.
conxxion
KS3 Computational Thinking Project - Practical Problem Solving (Full Unit of Work)

KS3 Computational Thinking Project - Practical Problem Solving (Full Unit of Work)

**KS3 Computational Thinking Project - Practical Problem Solving (Full Unit of Work) ** This project is designed to either introduce computational thinking skills or to supplement and build on knowledge and skills already acquired. It is suggested that the student booklet is used in conjunction with the associated presentation through all of the lessons. The project has been designed so that is hands-on and practical. The suggested time frame from start to finish of the project is approximately 6-8 lessons, depending on what additional aspects the teacher wishes to introduce during the project. Students are asked to create a stationery holder using everyday objects. The problem has to be approached and solved using computational thinking skills. The project can be approached from a totally ‘unplugged’ pedagogy. No computers required! The resource consists of: a) A student booklet. This can be printed as an A4 or A5 booklet. b) A student booklet containing examplar responses. Also contains extension / homework tasks. c) A PowerPoint presentation for use in lessons to guide students and the teacher. Many of the slides have accompanying ‘speaker notes’ with ideas and suggestions for lessons. The project allows students to be very creative when they move on to the development (making) section of the project. Expect to have lots of fun and engagement!
conxxion
Computing Design/Algorithm pro-formas (PDF and editable Word docx)

Computing Design/Algorithm pro-formas (PDF and editable Word docx)

As described in my “Delve in, for twelve min!” video CPD, these are example pro-formas to give pupils to design their computing projects. These could be Scratch projects; animations, games, quizzes etc. The design process, which is largely missed in computing, forms an essential part of a coding project, and also provides many benefits in terms of AFL. Please use in conjunction with the training video, and also check out the entire “Delve in, for twelve min!” series: https://www.youtube.com/playlist?list=PL3kA-gpaSB2a6Vfdq04rGt5xcKQg8FG8x
PhilWickins
New National 5 Software Design and Development Slides (2017/18 onwards)

New National 5 Software Design and Development Slides (2017/18 onwards)

This resource is a PowerPoint that covers all aspects of the new updated National 5 Computer Systems (2017/18 onwards). It matches to the new arrangements and provides slides on all the content within the following: Development methodologies Analysis Design Implementation (data types and structures) Implementation (computational constructs) Implementation (algorithm specification) Testing Evaluation These slides have worked wonderfully well with my class and have made new parts of National 5 much more accessible to my classes. I have included a PDF version as well. The Fonts I have used are called Fortuna Dot and Abscissa The programming language that I use in some of the slides in Visual Basic
weebrido