Most used Excel functions - function, syntax, description quick reference sheets

Most used Excel functions - function, syntax, description quick reference sheets

This resource contains a Table of the most used functions in Excel. It is separated by Core functions, Date Functions, Text Functions, and Lookup / Reference Functions. It is set out attractively in a table, the column headings being: Function Name, Syntax and Description. It gives a quick reference to over 35 different functions. It is available in a pdf and word document so that you can make any changes required.
Resource_Creator
Year 7 Computing/ICT Scheme of work & Resources

Year 7 Computing/ICT Scheme of work & Resources

Complete collection of Scheme of work, lesson plans, Power Points and homework for Year 7 introduction to computing and ICT. Includes: Topic 1 - Introduction & using computers safely and effectively • 7 Lessons, Power Points, Assessment, Homework and Pupil Progress Diary Topic 2 - Introduction to coding through Scratch • 5 Lessons (can be stretched depending on pupil progress), Power Points, Assessment, homework and Pupil Progress Diary Topic 3 - Spreadsheet Modelling • 6 Lessons, Power Points, Assessment, homework and Pupil Progress Diary All lessons are ready to teach and require minimal, if any preperation (may need tweaking to work with your school system) - everything is provided! Pack includes a scheme of work with lesson objectives and lesson overview and how these lessons fit into and satisfy the new National Curriculum for Computing. Ideal resource for non-specialists to follow, or for a specialist to pick up and run with. Feel free to adapt the resources as needed. All lessons are ready to teach. Year 8 and Year 9 packs coming soon.
Confusion101
Mobile Application Development Activity

Mobile Application Development Activity

This could be used whilst teaching ‘Appshed’ to KS3 students. It would be a good homework for either the 1st or 2nd week as it begins to questions the features of mobile applications which will support when students begin to draft their own applications. This could either be used as an activity in class or as a homework.
HDLouise
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
App Inventor Alluring Audio - (Lesson 4)

App Inventor Alluring Audio - (Lesson 4)

This is the forth lesson in the ‘App Inventor’ scheme of work. This lesson combines practical and theory to teach the “representing sound” concepts covered in the Computer Science 9-1 GCSE specifications, (including; sample rate, sample resolution & calculating audio file size.) All lessons within the scheme are targetted at KS3/KS4. Each slide includes detailed notes to support teacher understanding and have been based on a lesson plan structure. There is no prior knowledge required from the class teacher as the guides provided are step-by-step & all code is catered for in the documentation provided. For this lesson a video tutorial is available to support learners with the design of their app. The lesson includes a minimum 45 minute assessment (electronic & paper based included) with mark scheme both of which are custom made, this will truly test learner’s understanding. Using the ‘App Inventor’ emulator or a mobile device with the 'MIT App Inventor app’ installed will allow learners to practically use the apps they build. The app can be downloaded freely from the ‘Google Play’ store.
beef_keefe
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
Small Basic Graphics Window (FULL LESSON drawing a polygon)

Small Basic Graphics Window (FULL LESSON drawing a polygon)

FULL LESSON for teaching students how to use Small Basic Graphics Window. **Learning objectives: • Identify mistakes in Small Basic code • Predict what given code will do • Choose code to complete a given outcome Some students will be able to: Comment their code ** Teacher presentation included for large display. Full lesson plan included. 3 levels of worksheets included for use with differentiated groups in your classroom. PowerPoint with further examples of small basic code for optional demonstration to students/further explanation of lesson outcomes.
rhyteach2002
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
CiDA Collection

CiDA Collection

this pack contains a collection of power points and helpsheets which will aid in teaching and completing the CiDA course
dominicberesford1993
Website Research

Website Research

a word document which contains a number of questions and tasks for pupils to attempt if they are currently learning about or creating their own websites, great for an extension task or homework
dominicberesford1993