Using Spreadsheets (8 Lessons)

Using Spreadsheets (8 Lessons)

Using Spreadsheets This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7). This unit introduces the students to Microsoft Excel. It includes 8 lessons that involves students exploring the software whilst understanding the basics. For example students are asked to: Explain what a spreadsheet is and its uses Edit and format an existing spreadsheet Understand and use basic formula and functions Create and label graphs and charts correctly Produce a report to show evidence of understanding Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.
samoliver368
Researching the Aztecs - KS2

Researching the Aztecs - KS2

This resource includes: PPT Starter Integrated handbook for students to complete all about ‘the Aztecs’ ‘Code breaker’ plenary Lesson plan Support ‘cheat sheet’ for L.A Students This lesson plan is based around using ‘microsoft encarta’ for researching, however the lesson could easily be used alongside other similar software. Enjoy!
HDLouise
Small Basic Text Window (Using For and While Loops)

Small Basic Text Window (Using For and While Loops)

Worksheet for students to assist them in generating Small Basic code to write a times table and list multiples of a number. (Output in the Text Window) This activity will develop understanding of For and While loops (and consoldiate use of a variable e.g. name) Answers for the teacher included. The worksheet is available in** .docx** and **.pdf **formats.
rhyteach2002
Python Basics Help

Python Basics Help

a power point which details some of the different aspects of python programming, covering such topics as variables, debugging, comments and statements
dominicberesford1993
CS Knowledge Organisers - Software

CS Knowledge Organisers - Software

This is part of my Knowledge Organiser set for Computer Science. This part focuses on Software and key CS concerns. The amount of content that students are required to learn within Computing is vast the following document is all of the knowledge organisers I have developed for my students linked to the Computer Systems paper for computing. This document can be used for any specification to support students/teachers through the computing topics. The topics covered within this document are: System Software Computing Concerns and Impact on society This document can be used in many different ways some examples are below: Student led revision Topic summary Lesson activities/resources Teacher resource Homework Thanks for your time.
NextStepComputing
Python Pack

Python Pack

a collection of text files which feature python code including: Creating coloured patterns Guess the Number X’s and O’s
dominicberesford1993
Animation Planning and resources Y5 and Y6

Animation Planning and resources Y5 and Y6

This resources is for a 5 week plan for animation using Ipads for a mixed 5/6 class. It compromises of 6 lessons, differentiated with white board slides to follow and resources; including learning intentions and worksheets to plan. It looks at the world of Morph and dips into shaun the sheep. this resource is easily editable to suit a different key stage 2 age group or adapt to use different apps or resources. Each lesson lesson 1 - looking a apps for animating lesson 2- planning an animation lesson 3 - creating the animation lesson 4 - script writing lesson 5 - evaluating the app
bgjwh06
Programming Using Kodu

Programming Using Kodu

Students will understand the term ‘programming’ whilst using Kodu. Students will use Kodu to create a world and program Kodu to move. Students will then design and create their own game whilst providing evidence. Lesson One-Six Kodu Lesson Seven Revision Lesson Eight Assessment Lesson Nine Feedback and Improvements This unit has a lesson presentation for every lesson that includes a starter activity, main activity and plenary. Resources also include homework, worksheets, helpsheets and an overall assessment sheet that can be used for self, peer and teacher assessment. A full Scheme of Work is also provided. This unit of work is suitable from Years 6-8 depending on ability.
samoliver368
World Cup 2018 : Bingo

World Cup 2018 : Bingo

World Cup 2018 : Bingo Use this in conjunction with our <a title=“World Cup Selector” href=“https://www.tes.com/teaching-resource/world-cup-2018-world-cup-2018-selector-interactive-11911414”>World Cup Selector</a> This is a simple Bingo template for you and your pupils to use during the World Cup Festivities. It includes a blank Bingo template and a sheet with the names of the 32 countries taking part in the World Cup. We hope that you enjoy this resource! We would love your feedback, if you like what you see, please follow us: on Tes <a href=“https://www.tes.com/teaching-resources/shop/TeachElite”>TeachElite’s Shop</a> click the’Follow this Author button’ . We will keep you updated on any sales we throw or FREEBIES we upload. <br /> <br /> You can find us on Twitter: https://twitter.com/TeachEliteRE<br /> and Facebook: https://www.facebook.com/TeachElite/
TeachElite
Adobe Spark Post Guide

Adobe Spark Post Guide

A printable, 4-page A4 Guide to creating graphics using Adobe Spark. Featuring some handy tech tips and a labeled diagram demonstrating all of the key features. Remember, Adobe Spark is free to all students and teachers in the UK. See more here - [https://spark.adobe.com/home/]
tomcorney
Flowol Programming Missing Words Cloze ICT Computing Starter Activity Keywords KS3 GCSE Cover

Flowol Programming Missing Words Cloze ICT Computing Starter Activity Keywords KS3 GCSE Cover

Missing words cloze sheet on the theme of ‘Flowol’. Powerpoint so can be used on the board or printed as a worksheet. Includes space for students to explain the keywords and suggested extension activities. Can take 10 minutes or an hour, depending on which activities the students complete. Ideal for the start of a lesson, a quick filler, a homework, part of a cover lesson or as a plenary on the board with a whiteboard pen. The idea behind these is to get students to become more literate and think independently about the words that could be used to describe the topic being taught. The repetition of the word over and over as they look for the word is useful in remembering the terms. Often the students will pick up on things that you would not normally expect!
mikedean
Basic Computing

Basic Computing

END OF YEAR SALE… Purchase the full set of 5 resources and the supporting files to enable anybody to learn the basics of computing. Start with how ‘Files and Folders’ should be used then learn some practical tips when ‘Using the Internet’. Following this there are 3 practical lessons on ‘Intro to Word’, ‘Intro to PowerPoint’ and ‘Intro to Excel’. There is a starter activity for each lesson and teacher notes are included in the notes section of the PowerPoint lesson presentations. This includes challenge activities and discussion points to raise with the students. For an average group of 13 year old’s, this will take about 6 hour long sessions to complete. If you find the resource useful, please leave a review as it helps other teachers find it. HackDragn
hackdragn
Basic Computing – Using the Internet

Basic Computing – Using the Internet

This lesson focuses on practical use of the Internet rather than e-safety which is covered by many excellent websites. Students will learn about how personal information can be used against them and the need for strong passwords. There is a look at social media and the online dangers associated with using the Internet. The course then introduces how to search for reliable information and two methods for saving images for use in work. The main task involves searching for information on the Internet and allows students to practice saving and using images. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn
hackdragn
Python - Getting Started

Python - Getting Started

4 documents that include example Python code, tasks and programming challenges to complete to help students, NQTs and non-specialist teachers to learn the following Python programming skills: Input and print statements If statements For loops While loops Perfect for classroom activities, homework tasks and self-study. Answers are included.
nwilkin
Python For Loop Practical Challenges

Python For Loop Practical Challenges

A great 2 page handout for your pupils to practice For Loops in Python . Includes example code, a task to work out the output from the range function, 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
Python Basics Practical Challenges

Python Basics Practical Challenges

A great 2 page handout for your pupils to practice Python basics. Includes example code, a tasks to read code, a task to correct code and 4 practical challenges for them to practice writing Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
nwilkin
World Cup 2018 Database Lesson

World Cup 2018 Database Lesson

World cup teams in a database (this won’t attach but I have the PDF of data) - can email the Access database if required. Presentation gives an introduction to databases. Looking at what data is held about students in school (starter). The presentation looks at fields and records and how data is stored. The presentation shows how to sort data and to apply filters. Plenary is a traffic light question on learning objectives. Worksheet gives world cup tasks of sorting and searching for information within the database.
joannehole
Coding Concepts: Concurrency Vs Dependency - Delve in, for twelve min!

Coding Concepts: Concurrency Vs Dependency - Delve in, for twelve min!

UPDATE: The video tutorial has been removed due to essential maintenance! (It needs updating!) In the mean time, please feel free to explore the resources. The video will be up again soon. These resources accompany Part 6 of my online CPD sessions, “Delve in, for twelve min!” In this session, I highlight the issue of pupils using time as the trigger for sprite and background changes (concurrency), rather than making the sprites and backgrounds interact with each other (dependency). Please watch the YouTube tutorial first, and use these Scratch projects as examples to secure your knowledge before you teach. Please see www.rundontwalk.co.uk for more resources, or to book me for your school’s computing CPD needs.
PhilWickins
Basic Computing – Intro to Word

Basic Computing – Intro to Word

Teach the basics of Microsoft Word to beginners. The lesson engages students in following along with the basics of formatting, image insertion, creating tables, lists and useful tips. The lesson easily explains concepts which enable the learner to get to grips with the interface and create effective documents. There is a starter activity along with support materials required for the lesson. The teacher notes are in the comments for each slide, along with key points for demonstration and challenges for students if they complete the work. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn
hackdragn
Basic Computing – Intro to PowerPoint

Basic Computing – Intro to PowerPoint

Teach the basics of Microsoft PowerPoint to beginners. Students will learn how to manage the production of a slide-show and the common errors that people make. There is advice about the use of images and presentation style. The 21 Slide PowerPoint is designed to deliver the whole lesson along with a starter activity. The lesson contains one mini activity and a main challenge. There are teacher notes in the comments for each slide, along with key points for demonstration and challenges for students if they complete the work. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn
hackdragn
Getting your head around while loop - ITERATION for beginners.

Getting your head around while loop - ITERATION for beginners.

Understanding variables and loops are the most significant aspects of coding. It is important for students in early stages to grasp the concept of how loops work if the are to be successful candidates for computer science. This power point presentation is a scaffold building fundamental steps required in understanding and applying loops using python. Students must already know how to use basic input and output functions in python. The language and terminology used is simple enough for a non specialist to use and teach a coder at beginner level. The python idle software is available to download for free at https://www.python.org/downloads/. After students have fully grasp the concept of loops and how they work, they extension task will provide a challenge for them to apply their knowledge, using computational thinking to improve their code.
chris_vidal
Basic Computing – Intro to Excel

Basic Computing – Intro to Excel

Teach the basics of Microsoft Excel to beginners. Students will learn the difference between workbooks and worksheets, cell referencing, simple calculations, auto complete, formatting and functions (SUM, AVERAGE, MAX and MIN). There is a starter activity and 3 tasks to complete in a student spreadsheet which can be distributed. There are teacher notes in the comments for each slide, along with key points for demonstration and challenges for students if they complete the work. As always, if you enjoyed the resource please leave a review so that others can find it. HackDragn
hackdragn
Reconfigurable iOS Apps for Students, Teachers, and Parents

Reconfigurable iOS Apps for Students, Teachers, and Parents

NthLib is a set of Mac and iOS tools that are designed to enable non-professionals to build, configure, and deploy iOS apps for iPad and iPhone. Once the apps are built, they are easily configured, reconfigured and multiconfigured for various user groups. The key feature that sets NthLib apart from the sea of app builders available is multiconfigurability. A single app can be configured and reconfigured for any group or sub-group of users. A single user can install any number of app configurations and can switch between them with a single tap. This is finished turnkey software that I have used for several years to build and distribute my own iOS apps. I’ve recently made the tools available for 3rd-party use. The library is described in detail in the docs linked below. Briefly, K-12 use cases are endless. NthLib configurations provides a virtual venue for displaying work done by students that is suitable for public distribution and viewing. Student created content could range from artwork, photography, and videos, to short stories, poetry, and history papers - there are virtually no limits. See the link below that lists system requirements. The target audience can be other students, faculty, and parents. For schools that are already working with iOS devices, entry into NthLib provides easy access to app development and deployment. NthLib was originally modeled as a subscription service for small and mid-size enterprise. For now, I am offering the service to educators for use free of charge. And for subscribers who take me up on this offer, I will extend the free part indefinitely. In other words, if you start out free, you can continue free as long as you find NthLib of use. In exchange, feedback would help me. Beyond feedback, if your students cook up app configurations they are proud of and that are appropriate for demo distribution, I am always looking for high quality content to distribute as examples of NthLib’s capabilities.
raykraus
Spreadsheet A&E - OCR Cambridge Nationals Information Technologies

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