1. Resources Home
  2. Whole School
  3. Computing
  4. Algorithms and programming
  5. Basic
Introduction to programming using Excel VBA

Introduction to programming using Excel VBA

Use this student activity booklet as a guide to introduce basic programming concepts such as algorithms, variables as well as branching and looping control structures. Students work through the activities which are mostly practical but there are a few theory questions as well. Students develop their own algorithm as well as implement in code an algorithm given to them. User forms included as well. Especially useful for ACTDIP029 and ACTDIP030 at year 7 / 8 level.
Zulis
Scratch programming - fireworks

Scratch programming - fireworks

Code a fireworks show using the movement and looks tabs in scratch! This pack includes- Lesson plan ppt for teachers Lesson ppt for students video guides for each stage
winstateach
Lightbot - Hour Of Code - Algorithm - 3 week unit and worksheets.

Lightbot - Hour Of Code - Algorithm - 3 week unit and worksheets.

Included in this pack there is. - Lesson plans for teachers including solutions to all Lightbot Hour of code lessons and links to website and other useful videos. - 3 presentations for use within the classroom. - Worksheets for use for end of two lessons. Lightbot is a brilliant resource for use with year 4 and beyond with a puzzle style game play to help children learn about algorithms, loops and procedures within code. This is for use in partnership with hour of code Lightbot by CODE.org.
winstateach
VAT calculator program in Visual Basic (VB.NET) - Analysis,Design, Implementation, Testing

VAT calculator program in Visual Basic (VB.NET) - Analysis,Design, Implementation, Testing

This aim of this resource is to demonstrate a complete life cycle approach i.e. Analysis, Design , Implementation and Testing for a simple VAT calculator program using VB.NET (Windows and Console Applications). Ideally this can be used on a Level 2 /Level 3 course such as GCSE/A Level Computing, BTEC Computing/ICT courses. Intended target audience age range is 14-19. Could also be used for mature learners who are new to programming or even younger learners. Handout can be given to learners who can then work independently. They may need some assistance with implementation if this is the first time they are using VB.NET. Implementation: The implementation is done in Visual Basic NET using Microsoft Visual Studio 2013 and there are two implementations (Windows and Console applications). The implementation is not a step by step guide showing how to create the program but full code listing is provided as well as the MS VB.NET project /solutions. Implementation demonstrates the following techniques: Sequencing , Iteration (console application), FormatCurrency function, CDec function , Exception handling. Implementation can cover approximately 2 lessons (one lesson for creating a Windows Application and one for console application). Designs: Designs include: Flow chart, pseudocode, Test Plan, Input -Process-Output Table, Screen Designs Files included: Word document showing detailed designs, testing and implementation. VB.NET Solutions ( Windows application and Console application)
abrarhamid
GCSE Bitmap Image File Size Calculator Programming Lesson

GCSE Bitmap Image File Size Calculator Programming Lesson

This lesson is based around programming skills and knowledge, as the students work through the worksheet (on the computers is best a they can copy and paste code snippets into the other document). Once they have answered the questions on the worksheet they should also have the Bitmap Calculator Code document containing the code snippets required to create the program. Then they can go onto Visual Basic to write the program, and test it to see if it is working correctly. There are also a couple of extension tasks at the bottom of the worksheet. I have also included the final code that I used to demonstrate the program working at the start of the lesson, and the PowerPoint which I used to outline the task and give them instructions on how to complete the tasks.
MrHawes8
GCSE Brute Force Malware Programming Lesson

GCSE Brute Force Malware Programming Lesson

A programming lesson designed to help the students improve their programming skills, as well as learning about brute force attacks. The lesson begins with a research task and ends with a step-by-step activity to create a program that will guess a password that the user has entered. Included is the PowerPoint presentation, programming instructions for students, and the final code in a text file for the teacher.
MrHawes8