1. Resources Home
2. Whole School
3. Computing
4. Evaluating digital content

#### Computer Science A level assessment part 1

Computer Science A level assessment part 1

#### Computer Science website resource SOW year 7 and 8 - OCR GCSE notes

I have created a website to share my Computer Science resources. Its still in development stages however content is being updated regularly. I would really appreciate if you support the site and leave any feedback. Thank you https://www.cslearning.co.uk/

#### Most Used Excel Functions

Teach your students the most used Excel functions. All explained with details and includes an example each. The presentation can be adapted to your class activities. Functions that include in the presentation: SUM ( ) AVERAGE ( ) MAX ( ) - MIN ( ) COUNT ( ) COUNTA ( ) CONCENATE ( ) IF ( ) COUNTIF ( ) VLOOKUP ( ) SUMIF ( ) Assessment supports learning abilities and gives a chance to practice them in carefully designed examples with instructions for each. (All functions are used). The “Assessment_SOLVED” file gives the answers of each question. Please make sure you leave a review after your use. THANK YOU!!!

#### STEM Accelerators - KS3 Computing Online Safety

Due to the prevalence of technology, cyber security is one of the greatest opportunities and threats humankind knows. Your pupils will already use computers on a daily basis, but probably don’t pay much attention to personal data, or even know what it is! It’s time to change that, and this lesson is a great place to start bringing together elements of both the IT and computing curriculum. It will also teach your class the Army-inspired skills of critical thinking, team work, leadership and perseverance.

#### Karnaugh Maps - 8 Karnaugh Maps - Good starter - With answer booklet - Computer Science A Level

8 page PDF document with a Karnaugh map on each page. Answer booklet included showing groups and final solutions. I have used these sheets after teaching this topic as a starter to ensure over a number of lessons that the students haven’t forgotten how to find boolena expressions from a Karnaugh map representation.

#### Computer Science Research Essay Ideas

Four different activities for researching different areas of Computing. 4 research essays bundled.

#### A comparison of Smart Phones

Directed research activity to compare different brands of smart phones in an ‘Extended Essay’ type format

#### Games Consoles Research Activity

Activity sheet for researching and presenting on the History and development of Games Consoles

#### Computer Science Y8 Extended Essay Research Activity

My activity sheets for Y8 extended essay Included marking rubric and levelling descriptors for this task

#### Wearable Technology Essay Research Tas

This is my handout for a research and extended essay type activity that I do with my Y8 students. Levelling criteria is included

#### [GCSE + IGCSE] The Bigger Picture (Emerging trends, issues and impact)

This is my unit of work to introduce the majority of the Bigger Picture unit. It also is a good research and discussion activity that links to other areas of the course - networking for example and the Internet of Things which has been in several exemplar question papers. It also gives rise to discuss Embedded Systems, discussions covering the whole of Topic 5 and making it relevant to real world examples. I have included in the file my overview of the three lessons that I spend on this. Of the four subsection of Unit 6. It has activities that can be used to introduce, or recover 6.1.1 - 6.1.3 The carousel activity features 5 real world scenarios linked to smart devices, embedded systems which students then record and share their thoughts on the impacts that it has. Class teacher/Students can gather thoughts and lead discussion based on students thoughts - good revision activity, or to assess understanding before progressing in this unit of work.

#### GCSE Computing Revision Flash Cards - Ethics

GCSE Computing Revision Flash Cards for Students. See Full Set of Flashcards for Computing for a Discounted Price! Based off of the OCR Specification (9-1)

#### **Over 50 Slides of content **Unit 1 CamTech 2016 Revision Slides**

The resource covers the different topics as per the unit content in a user friendly way for students.

#### GCSE Computing Paper 1 Exam Style Questions and Answers

GCSE Computing Paper 1 Questions and Answers. Great for tests or student revision. Based off of the OCR Specification (9-1)

#### 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.

#### Spreadsheet A&E - OCR Cambridge Nationals Information Technologies

This is a resource that goes through each of the formulae that students need to know for the course. It has an activity for them to practice each formula and apply it to a working situation. My students come back to this when they build any spreadsheet and can’t remember how to do a certain formula.

#### REVISION FLASHCARDS - COMPONENT 1 - OCR A Level Computer Science - H446

A pack of just under two hundred flash cards across 24 A4 pages, consisting of past paper questions and key terminology for the OCR A Level Computer Science H446 Specification, Component 1 paper. Question is on the one side and the answer on the other, with a mark breakdown. Ideal for use by students as a revision tool! Can be folded in half by students to test themselves with the question on one side and the answer on the other. This resource is a single file PDF of 24 A4 pages. The questions have been taken from all of the sample, specimen and past papers available as of June 2018. Key definitions have been provided for every part of Component 1 in addition to cover those aspects that have yet to be examined in this component.

#### Creative iMedia R082 Literacy Mat

A complete literacy mat for use with the R082 Creating Digital Graphics unit of the L1/2 Cambridge Nationals Creative iMedia course. Featuring: Graphics Terms Learning Objective Terminology File Formats Sentence Types Review Key Words The download is a hi-res PDF, optimised for printing up to A3.

#### Solving the Cyber Security Skills Gap

Cyber criminals pose a risk to organizations large and small, local and across the globe. More and more, these organizations need qualified cyber security analysts and specialists with the skills and experience to mitigate this risk. As you take the first step toward helping meet this need by pursuing an online Bachelor of Science in Cyber Security, read more about what it will take to solve the gap: About Cyber Crime There are several different types of cyber crime. The motives behind them can be anything from money to hactivism or espionage. The most popular types of cyber crime include: Phishing attacks Malware Ransomware Encryption Blind Spots Cloud Threats Lack of cyber security system maintenance and employee training is often to blame for companies being attacked. What Can Be Done Those pursuing their cyber security degree online right now are going to enter a job market ripe with opportunity, as there is more demand than supply right now. The Benefits of a Cyber Security Career Cisco estimates that there are currently one million cyber security job openings worldwide. Demand is predicted to rise to six million, with Symantec predicting that, by 2019, the shortfall will be 1.5 million.

#### KS3 Unit - Innovators in Technology

Yr 7, 8 or 9 unit of work looking at several innovators in technology including Turing, Ive, Musk, and Zuckerberg. Students complete an activity for each innovator Ciphers, Design, AI, and Data Protection respectively. During the final lesson they choose an innovator of their own to research. Each lesson they complete the above activity, research the innovator, and add to a brochure (or other document) which is their final assessed piece of work. Unit includes: Teachers PowerPoints - has answers, videos and timers on each* Student PowerPoints - basic tasks One Homework assignment - assessed using teacher feedback and student response format (separate so they don’t need to take workbooks home with them) - ready to print in A5 two to a page One final assessed brochure (or easily modified for other DTP; website, PPT, etc) with Marks Scheme based on iMedia course Student workbook which could either be held online (Google Classroom, O365) or printed for each student to work through. This unit is particularly good for non-specialists or cover staff to deliver and can be easily scaled up or down depending on your students ability. *Our school uses “silent tasks”, therefore each lesson will have a period of time where students will complete a task in silence. This is denoted by a character motioning for silence. Lessons are not reliant on this occurring.

#### CS Word Mat

A3 word mat used for extended questions to develop planning skills before tackling the question.

#### Primary ICT / Computing report templates and statements of progression

New UK Curriculum for Computing in Prmary assessment and reports statements for year 1-6 at three levels of progression across Digital LIteracy, Digital CItizenship and Computer Science. Use the sentences as a guide for what to include in your reports for the computing segment. While these do not cover the entire spectrum of assessment for computing, they are a good representation of the most notable standards per strand for the age expected ability and represent what should be taught. Could also be used in a backwards planning model to also develop learning objectives, success criteria and lesson plans or an entire vertical curriculum.

#### Robot

aiter Robot video At LAX He ad

#### Computer Science Bundle

All of my Computer Science resources as I am soon to be moving to another subject.

#### IT- Theme park app scheme of work

KS3 IT Scheme of work based around creating an app for a theme park using Appshed.

#### 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.

#### SCRATCH - making a game stage 2

This PowerPoint has video descriptions of how to add features to a simple driving or maze navigation game. I used it with year 3 and made this to help the teachers who were not confident or familiar with SCRATCH themselves. They were able to play the pages and then get the children designing, making, innovating and debugging their games. It is a large file, so allow time for it to download.

#### Website Evaluation (Editable in Google Docs)

This is a checklist to use to check websites for reliability. This can be used for extra practice looking for high quality sites or during the research process. Students must look for certain criteria in their selected website. They then add up the totals to see if the website can be used as a reliable source of information. Included is a printable PDF file as well as an editable Google Doc. This way you can change the website evaluation before printing it out for your students or you can provide them a digital copy.

When it comes to data you want secured, your email accounts are probably close to the top of the list. Strong passwords can help, but to be as secure as possible, you want to enable two-step authentication. This is a great resource to print out and have your students follow. It teaches students about 2 step verification! What You Get: • What is two-step authentication? • Setup your Google account • Alternative second steps

#### Timeline Template (Editable in Google Slides)

Best of all, this resource is available in both printable pdf format as well as a Google Slides editable format. This timeline template allows students to create a timeline with linked information for each event.The timeline page supports 11 events and has the age range of 0 to 17. If you need more events for your timeline, duplicate the slide. Your students are able to click the arrow and point it at the appropriate time. They can also double click the event boxes and write in their description. The template is locked, so your students can’t mistakenly move or delete the background. If you choose to print the PDF, have your students draw the arrows themselves. This resource includes one version with arrows on each event box and one version without any arrows, ready to print.

#### Blank Rubric Template Editable in Google Docs

This package contains 10 different blank rubric templates. You can fill in your own grading criteria by printing them out and writing in all the information for your assignment. Alternatively, you can customize these rubrics by using Google Docs to edit them. Includes: • Google docs editing directions • Categories worth 2 points • Categories worth 3 points • Categories worth 4 points • Categories worth 5 points • Categories worth 10 points • Categories worth 3 points and 5 points (mixed) • Categories worth 3 points, 4 points and 5 points (mixed) • 3 different project based learning rubric templates

#### Presentation: object orientated programming (OOP) (x22 slides)

The presentation introduces the idea of properties and methods belonging to a class, being able to instantiate a class and produce an object and how many objects can be created from the class. The presentation describes the OOP characteristics behind inheritance, encapsulation and polymorphism. It gives six supporting examples using python code to demonstrate the above concepts. At the end of the presentation there is a challenge to create a program to illustrate the new ideas. This is supported by a class diagram that displays the relationship between the classes.

#### PSHE: New PSHE 2018-19 Part 2

10 hours of new PSHE lessons on some of the most pertinent and pressing issues facing students in 2018/19. These topics have been identified by the PSHE Association as essentials for the coming year and so this bundle has been planned following their recommendations. This is part two of a two part pack. PART ONE All 10 lesson packs are complete with at least one hour-long powerpoint, accompanying differentiated worksheets, clip links with questions, plenaries, clear LOs, starters and engaging, varied main task activities.All are well differentiated to three levels throughout to enable clear evidence of progress for all students. These lessons have been selected to be in this bundle as they all focus on relatively new issues or ones which need further awareness amongst young people in an ever-changing world full of mental health issues, new technology, crime and potentially tough futures which lie ahead. These resources have been highly-rated individually by TES users, follow the same consistent format and are easy to follow. There is zero extra work required, although each lesson is still completely editable too. I use all of these myself as a Head of PSHE and Citizenship and I really hope you find them excellent value. I’ve put literally months of time into this to make these lessons top quality for my own school team. I have ‘One Year of PSHE’ Packs for Years 7, 8, 9 and KS4. You can check them out at the shop link below. Please leave me a review and I’ll send you any other resource of your choice for free. Many more inexpensive or free resources at my shop: EC_Resources

#### Unit 02 - Cambridge Technicals - Project LakeSailing - Mock Exam Scenario

Mock exam paper and exam support for the exam.

#### Unit 18 / 19 / 20 Cambridge Technicals Level 3 *Triple Pack*

**Unit 18 / 19 / 20 Cambridge Technicals (2016) Level 3 Triple Pack ** This rescource will provide you with the relevant resoucres to complete the following units on the Cambridge Technicals units: Unit 18 - Hardware Unit 19 - Software Unit 20 - Technical Support Combine these 3 units with the examination units (1 &amp; 2) to achieve 1 A Level for your students! Each unit is available on their own in my shop, the 3 together offered at over 40% off!

#### Technology in the News Activity

**Technology in the News Activity ** The resource includes a word processing and a PowerPoint version. There are links within the resources to a variety of news articles which students can browse and investigate. The activity is applicable to KS3 and KS4 computer studies and links to Legal, Ethical, Cultural and Environmental aspect of GCSE computer studies. Activities can be saved and used as an ongoing activity. The activities can be used as a starter, plenary, homeworks or as part of a class activity leading on to discussions about various aspect of computer science / studies.

#### Cambridge Technicals IT Level 3 Unit 18: Computer Systems - Hardware 2016

An entire collection of my thoughts and ideas on this new unit. After teaching the legacy spec for many years, i have found my students to excel in the subject using resources like these, resulting in positive feedback from external moderators. For this course you cannot offer templates to learners, however the red notes may of use to aid learners in their writing. Feedback is greatly appreciated! TES will only show a preview of the documents, the entire collection of LO’s for the unit are included. Please feel free to provide feedback or comments: eyeteateacher128@gmail.com

#### Computer Science Poster: Impact of Digital Technology on Society

Has technology improved our lives or has it actually made our lives worse? This poster was created to promote debate within the classroom within my year 11 students to prepare them for their computer science exams. I have included a range of topics with positive, negative and thought provoking questions for students to consider. The topics covered are also suitable for GCSE ICT exams. Please leave a review!

#### Unit 20 - Technical Support- Full Unit, Cambridge Technicals Level 3 (2016)

Here you will find the resources to complete Unit 20 in the level 3 Cambridge Technicals. All of the Learning Objectives have been covered within the lessons provided. The assignment which has been used has also been checked using the Assignment Checking service from OCR. (Service is £30 per assignment) Enjoy!

#### SCRATCH 2 - an introduction

This is a PowerPoint introducing the areas of the SCRATCH 2 screen for staff and pupils who are not confident with SCRATCH 2. It is basically the “little talk” I give year 3 pupils before they start a unit to create a driving game. I hope others find it useful…

#### GCSE Computer Science Module Quiz - Ethical, Legal and Environmental - Linked to Knowledge Organiser

This is a module summary quiz on the topic of Ethical, Legal and Environmental Impact. Includes questions on legal issues, environmental impact and some larger scale ethics consideration questions. The assessment features a range of question types and includes full worked solutions and answers. I print these 2 to a page and use them as a low stakes quiz at the end of a module. I will also be reusing them as a revision resource for my year 11s. These module quizzes are linked to the Knowledge Organisers I have also made and are available on TES. Most of the content is featured on the similarly named organiser, but would still be more than suitable without the use of the organisers. Any questions, please feel free to ask. Thanks, Toby Watkins