Elementary School computing lesson plans and activities

Resources and ideas for computing, written by teachers to support teaching and learning

Sale
18 ICT/Computing Theory Lessons & Homework Booklets

18 ICT/Computing Theory Lessons & Homework Booklets

When these booklets are printed you have 8 theory lessons primarily based on the BBC Bitesize website.Follow the bitesize online pages and activities and complete the task sheets. Homework can be completed on the homework booklet.They have been designed to be used without computers and there are enough lessons for 1 every 2 weeks.Hope they are useful

By anthellison

While Loops Starter

While Loops Starter

Three tasks in Scratch to introduce students to the while loop. Students must complete the while loop by inserting the correct code blocks in Scratch. Suitable for KS2/KS3 Computing or as a refresher/introduction for KS4.

By bw999

Developing Computer Games Project Template - Based on Unit 25 TLM

Developing Computer Games Project Template - Based on Unit 25 TLM

A Word document with sections relating to:Working out file sizes of images.Using co-ordinates.Looking at an existing game and looking for the decisions that need to be madeMake your own game with 3 decisionsModify a gameLegal issues related to modifying code (Open Source, Copyright and Patents Act)The document is set of tasks that pupils must provide evidence that they have completed. It does not teach students how to create the game.

By moggga

List of programming techniques

List of programming techniques

List of all the programming techniques required for GCSE and A Level Computing; what do the students need to learn or show as part of the evidence in controlled assessments or Computing courseworks

By sekhon1976

iPad Success in Primary Education Workshop - Best Apps

iPad Success in Primary Education Workshop - Best Apps

This resource is presented as a PowerPoint with full notes on each slide. It has been created as a training resource for teachers. It also includes practical exercises and activities that showcase how to use the apps for educational purposes. It is very graphic and covers the following apps that are suitable for primary and below level:Pic Collage (makes collages out of photos and pictures)Book Creator (create stories) iBooks – viewing booksPuppet Pals (animation / recording)Popplet (mind mapping)Showme (Interactive Whiteboard)Most apps are easy to use. It’s Using apps effectively and with purpose that is the crucial step.

By biowriterab

Sale
Creating an Australian Aboriginal style 'Dot' painting in Microsoft Word

Creating an Australian Aboriginal style 'Dot' painting in Microsoft Word

Instructions for creating an Australian Aboriginal style 'Dot' painting using the drawing tools in Microsoft Word. This resource will assist middle school art teachers in fulfilling the mandatory programming requirements in Visual Arts to do with both the study of Indigenous Australian Art and the use of Computing Technologies in Visual Arts (Australian Curriculum). It can be presented as a hand out for self-paced learning or kept by the teacher as a resource for guided instruction. The sample image in pdf format for digital display is also included. Please complete a review of this resource if you have found it useful.

By kellyocs

Database Revision/Homework Question 4

Database Revision/Homework Question 4

A 14 mark database homework/revision question covering:Entity Relationship DiagramsData DictionariesCompound and Surrogate keysUse of Forms and ReportsNote that two versions of the question have been uploaded. One contains a simple ERD (entities and relationship) and the other contains a more complex ERD (also including attributes)Written for the Scottish Higher course but valid for all intermediate level Database units.My students found this very useful.Question 4 of 6.

By snegreid

Database Revision/Homework Question 3

Database Revision/Homework Question 3

An 11 mark database homework/revision question covering:Field TypesInput Validation (including Restricted Choice)Primary and Foreign keysModification ErrorsSorting on Two FieldsWritten for the Scottish National 5 course but valid for all introductory Database units.My students found this very useful.Question 3 of 6.

By snegreid

Database Revision/Homework Question 2

Database Revision/Homework Question 2

A 15 mark database homework/revision question covering:Update ErrorsField TypesPrimary and Foreign Keys to Link TablesPresence CheckSearchingWritten for the Scottish National 5 course but valid for all introductory Database units.My students found this very useful.Question 2 of 6.

By snegreid

Data Types Computing Science Doodle Notes

Data Types Computing Science Doodle Notes

Data Types Computing Science Doodle NotesThese notes will help your students to review the basic definition of the following data types:- integer- real- character- string- booleanStudents color and complete and then add to their own notebook.No prep- just print and go!More computing science resources coming soon!You might also like:Cache Memory Doodle Notes RAM and ROM Doodle Notes/a>

By STEMthinking

Solid State Storage Computing Science Doodle Notes

Solid State Storage Computing Science Doodle Notes

Solid State Storage Computing Science Doodle NotesThese notes will help your students to review the basic properties and advantages of solid state storage devicesStudents colour and complete and then add to their own notebook.No prep- just print and go!More computing science resources coming soon!You might also like:Cache Memory Doodle NotesRAM and ROM Doodle Notes

By STEMthinking

Computing (Year 3) – Simulations (4 lessons plans and presentations)

Computing (Year 3) – Simulations (4 lessons plans and presentations)

4 lessons including lesson plans and presentations to teach Computing/ IT in Year 3. Unit: Simulations.Lesson 1 - understanding that computers can simulate real or imaginary situationsLesson 2- understanding that simulations are guided by hidden rules.Lesson 3 - using an option led text simulation.Lesson 4 - using simulation for an adventure based on an imaginary world.

By BelindaCM

Computing Year 3- Combining text and graphics / Using Microsoft Word (4 lessons)

Computing Year 3- Combining text and graphics / Using Microsoft Word (4 lessons)

4 lessons including a Notebook, Powerpoint presentations, lesson plans and self-evaluation to teach Computing/ IT in Year 3. Unit: Combining text and graphics using Microsoft Word. Link with Literacy (writing magazine articles).Lesson 1 - changing the style of a word/letter.Lesson 2- using the spell/grammar check to help edit a piece of writing.Lesson 3 - combining text and graphics using Microsoft Word.Lesson 4 - combining text and graphics to create and interesting looking article.

By BelindaCM

Computing (Year 3) – Introduction to Databases (6 lessons plans, presentations)

Computing (Year 3) – Introduction to Databases (6 lessons plans, presentations)

6 lessons including a Notebook, Excell resources, lesson plans and self-evaluation to teach Computing/ IT in Year 3. Unit: Introduction to Databases.Lesson 1 - adding information to a database.Lesson 2- adding information to a database.Lesson 3 - using a database to make a column chart.Lesson 4 - searching a database to find answers to questions.Lesson 5 - using a database to make a bar chart.Lesson 6 - using a database to sort ,classify and can present my findings

By BelindaCM

Sale
OCR - AS-Level Computer Science - Bulk Resource Download

OCR - AS-Level Computer Science - Bulk Resource Download

There are a bulk load of computer science resources here including the following topics:* Testing* Operating Systems* Lossy Vs Lossless* Logic Gates / Boolean / Karnaugh Maps* Exam questions and answers* Exam questions and answers V2* Data structures - Tuples / Lists etc.. * Branching and Selection* Computer Science - MethodologiesSome of these presentations link to my YouTube channel where I have included videos to help you deliver the content.

By r_chambers

Arbor Day: An Internet Activity

Arbor Day: An Internet Activity

Learn about the history of Arbor Day and all about trees with this web quest! There are 11 web questions, a Did You Know? section, comprehension questions and a teacher section with keys, additional links and lots(11 extension activities).This could also be something to use with EARTH DAY, when you are studying TREES and, of, course, for ARBOR DAY! Did you know that more than 30 countries in the world have a day to celebrate trees?Other resources that would go well during this time:1. Exploring the Ocean Blue: A Web quest, will introduce students to our oceans. There are nine informative web questions. Fun Facts, comprehension questions,extension activities and links are also provided as is the key. Can be used as part of a unit on oceans, for Earth Day, World Ocean Day or as an activity for a Friday, before a vacation break or as an end of the year activity. This can be a one day class resource or used for a couple of days depending on whether the activities(creative writing/art work/online simulation games, etc.) are used with the students. There are 9informative web questions. Fun Facts, comprehension questions,extension activities,links: Let's Explore the Oceans: A Webquest2. Learn about Jacques Cousteau with this Reader's Theater Script: Oceanographer, photographer,filmmaker, scientist, writer, inventor, Cousteau spent his life studying the oceans and the marine life that lived in the oceans. His books and films on his studies sparked much interest in our oceans and created an awareness about the need for marine conservation. Part of my Ms. Bie Ografee Talk Show Series where Jacques Cousteau is a guest on her talk show and answers questions of her studio audience. There are 10 audience questioners, a Did You Know? section, comprehension questions, a teacher section with extension activities, links and the key.Jacques Cousteau: A Reader's Theater Script3. Learn about the history of Earth Day and, our planet, EARTH, with this informative web quest. There are 15 web questions as well as comprehension questions and a Did You Know? fun fact section. The teacher page includes extension activities, the key, and additional links. EARTH DAY, A Webquest"4. A Biologist and marine zoologist, Carson’s books shared her love of nature, especially the ocean and its inhabitants. Her book, Silent Spring, sparked concern in how chemical pesticides were harming our environment. Carson helped to start the environmental movement in our country, which led to the creation of the U.S. Environmental Protection Agency. This Reader's Theater Script could be used as a STEM biography any time of year or especially during the time of Earth Day.Rachel Carson, A Reader's Theater Script

By gailhennessey

2. Data Casting & IF Statements (KS3 + KS4 Friendly)

2. Data Casting & IF Statements (KS3 + KS4 Friendly)

The second lesson in my Python scheme of work, this is aimed at building upon the introduction lesson and taking the students through the following:- Data Casting-If statements-Elif StatementsStudents will be challenged to complete some tasks alongside these, easy to follow and all set up for you to use! Reduce your planning time!

By msmarwaha

Excel Skills Workbook

Excel Skills Workbook

A number of Excel skills in an Excel workbook that is self-marking including basic formulas, IF, COUNTIF, COUNTBLANK, HLOOKUPS, VLOOKUPS, MACROS, USEFUL FORMULAS, GOAL SEEK, LAYOUT, CASCADING MENUS, CELL PROTECTION. Useful as a skills revision, testing or introduction or as a teaching tool to prepare students for spreadsheet work. Suitable for ECDL - students just won't need to cover all of the workbook to prepare for the exam. I've included an xlsm version and answers plus an .xls version as the instructions are slightly different. Macro helpsheet included for one of the tasks.

By computingMK

ECDL PowerPoint Quiz

ECDL PowerPoint Quiz

A simple crtieria sheet for a PowerPoint quiz. Used with my ECDL students to practice their skills. Sheet used for self-assessment and peer/teacher assessment.

By computingMK

Using Excel - Creating a V-Lookup Table (for teachers) Calculate grades on trackers/class lists auto

Using Excel - Creating a V-Lookup Table (for teachers) Calculate grades on trackers/class lists auto

Instructions for teachers on how to create and use look up tables within Excel to calculate grades from scores automatically. Equally, you might use these instructions when teaching this skill to students.I hope these instructions are fairly straight forward. I used Excel 2013 for the print screens, though the skill is similar in whatever Excel version is being used.Great for staff training. ALL staff should know how to do this to save time when tracking data.Enjoy!

By brad-ashley

MS Excel - Tracking Student Data - IF Statements to Compare target to grades; teacher instructions

MS Excel - Tracking Student Data - IF Statements to Compare target to grades; teacher instructions

Teacher instructions to help with tracking data for departments, school wide or individual class trackers.These instructions show how to insert an IF statement to compare a grade (for a unit/exam/module etc.) to a target, to show whether it's above, below or meeting target grade.Two separate instructions for grades A*-G and numbers 9-1.Ideal for whole staff training. More advanced staff should be adapting the formulae to suit their needs.Enjoy.

By brad-ashley