Materials – Using SQL at AH/higher 0

Materials – Using SQL at AH/higher

Activity Summary Exercises on interrogating databases using SQL.  Database files are included.   Time required 60 to 8 hours Resources Download exercise Follow Up Activities Practical work on databases.  Work on AH project

Materials – CSS 0

Materials – CSS

Activity Summary This activity is for helping pupils practice using CSS styles. The activity uses code comprehension and worked example techniques to show pupils how to build an answer. Suggested Time Required One period. Resources   Follow Up Activities Continue with other forms of CSS activity....

UnderstandingCode 0

Materials – Understanding code at National 5

Activity Summary A series of exercises written in reference language covering the requirements at National 5.  Solutions to exercises are given Suggested Time Required Activity would be used throughout the SDD section of the course.  Alternatively the exercises could be used for revision/self-study purposes Resources  Click...

Materials – Data Structures and external files at Higher 0

Materials – Data Structures and external files at Higher

Activity Summary Explanation of and exercises about implementing the use of external text files and creating and using records in VB.NET Suggested Time Required 3 to 4 hours of class time Resources  Click to download Follow Up Activities Pupils can integrate this with their study of...

Materials – N5 KLA Database Machine 0

Materials – N5 KLA Database Machine

Activity Summary This activity allows students to gain an understanding of how SQL queries are executed. This is an introductory lesson that requires the teacher to demonstrate and explain that underlying all database queries is SQL code. The focus of the lesson is to introduce...

Technique – Database Machine 0

Technique – Database Machine

Summary of Technique [Office mix] This technique uses the kinaesthetic learning approach. By manipulating the records of a paper database machine, pupils can gain an understanding of how SQL queries are executed. This technique serves as an introduction to the SQL clauses that are generated by database management systems that...

Materials – Parameter passing at Higher 0

Materials – Parameter passing at Higher

Activity Summary This activity allows students to gain an understanding of parameters and parameter passing techniques. This is an introductory lesson. The focus of the lesson is to introduce passing parameters; at this stage, topics such as difference between functions and procedures are not considered....

Materials – Structured TRACS in Livecode 0

Materials – Structured TRACS in Livecode

Activity Summary This is a set of exercises for National 4 and 5 pupils using the TRACS technique. The examples are in Livecode. Suggested Time Required These exercises could be used throughout a unit of Livecode programming or as assessments of programming ability. Resources TRACS livecode—PLAN...