Professional Learning And Networking for Computing
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...
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...
Activity Summary Higher/ National 5 pupil exercises providing worked examples for a variety of Data Representation calculations including the uncompressed files sizes of images with dimensions in pixels and inches sound with multiple channels video Suggested Time Required 10 minutes to study each worked example...
Activity Summary This is a set of slides for presenting to a class with TrueBASIC questions. The questions work well when used with Peer Instruction. The TrueBASIC content covers National 5 level concepts for programming. Suggested Number of Lessons Spread over a unit of learning TrueBASIC. Resources TB PIQs—PLAN...
Activity Summary National 5 Pupil Revision Notes covering the programming constructs assignment, selection and repetition. These are linked to worked examples of explaining code questions, written in the SQA Reference Language (also known as ‘Haggis’). Suggested Number of Lessons These will be used throughout the SDD course....
Activity Summary This is a set of slides for presenting to a class with Scratch questions. The questions work well when used with Peer Instruction. The Scratch content covers the majority of National 5 level concepts for programming. Suggested Number of Lessons Spread over a unit of...
Activity Summary A TRACS exercise for database queries. A set of queries suitable for national 4 and national 5. Number of Lessons An introductory lesson with pupils attempting simple examples. A second lesson to present complex sort / search and calculated / derived data. PLAN...
