Professional Learning And Networking for Computing
Techniques for illustrating the dynamic behaviour of code.
Activity Summary This is a collection of code reading exercises written in Visual Basic. There is a group of printable pupil booklets containing exercises to develop the following skills: code identification code description code explaining debugging tracing answering explaining code exam questions in SQA reference language The...
Activity Summary This is a collection of code reading exercises written in Livecode. There is a group of printable pupil booklets containing exercises to develop the following skills: code identification code description code explaining debugging tracing Suggested Time Required Two to three exercises could be covered in...
Activity Summary This is a set of exercises for Higher pupils using the TRACS technique. There are examples are in Python 3 and the SQA Reference Language. This activity allows the pupils to gain an understanding of how the data in programs are executed. This set of materials...
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...
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...
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...
Summary of Approach The process a computer goes through when executing a section of code is manually stepped through by the learner in order to understand how it will work and what the expected output should be. Keypoints Just showing a visualisation of a piece of...
Summary of Technique Pupils use a paper-based TRACS model to trace the processing of a database query. Pupils annotate the model to indicate the sequence of the operations and the effect of each of the operations on the results of the query. The activity is based...
Summary of Technique Exercise(s) for Teachers Ways of Using the Technique in the Classroom The most important thing about using TRACS is to be flexible in its use. The process captures all the features of a piece of code and allows you to concentrate on...
Summary of Technique Office mix TRACS for expressions is a technique for analysing the expressions in code. This could be as simple as the expression 4+5, to a complex expression such as (INT(RND*23)+1)>ROUND(a,3) OR b<j*r. The approach uses annotation to outline the order of evaluation of...
