Professional Learning And Networking for Computing
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 These tasks can be used to determine a learner’s understanding of object oriented principles when implemented in the Haggis reference language. Learners are asked to read a short section of code and answer follow-up questions. Explanations require a good understanding of OO principles such...
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 series of practical tasks that focus on the relational database content of the N5 Computing Science course. All of the practical work is completed in MS Access. However, with a updated Help sheet (the current resource is based on VB...
Activity Summary Standard Algorithms in Livecode – This activity takes the learner through the process of creating a program for a holiday company. Pupils will need to know how to import and store the contents of a text file in a program. The learner will...
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 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
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....
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...
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...
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 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....
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...
Activity Summary The attached resources introduces data modelling using entities, attributes and relationships by recreating part of the data model used by social networking sites. The use of entity relationship diagrams as a means of representing a data model is introduced. The resources can also help...
Activity Summary The activity leads on from National 5 SDD and covers the knowledge and methods for using subprograms in True Basic Suggested Time Required Approximately 10 hours Resources Presentation and pupil workbook are available for download here Follow Up Activities Pupils would have the tools to...
