Madras College

Computing - National 4/5

Overview
The Course enables pupils to develop knowledge and understanding of key computing concepts, processes and computing technologies. It also enables pupils to develop a range of computing and computational thinking skills, including skills in analysis and problem-solving, design and modelling, developing, implementing and testing digital solutions, across a range of contemporary contexts.

Course Content

There are three units in this course. The course content outlined here is for National 5. Pupils undertaking National 4 cover much of the same content as National 5 but to a lower level of conceptual understanding.


Software Design and Development

Candidates develop knowledge, understanding and practical problem-solving skills in software design and development, through a range of practical and investigative tasks using appropriate software development environments. This develops their programming and computational-thinking skills by implementing practical solutions and explaining how these programs work. Tasks involve some complex features (in both familiar and new contexts), that require some interpretation by candidates. They are expected to analyse problems, and design, implement, test and evaluate their solutions. In Madras, our main programming language is Python.

Unit Content includes:

Describe and implement the phases of the development process: analysis, design, implementation, testing, documentation, and evaluation, within general programming problem-solving.

Analyse the requirements of a problem in terms of purpose, functionality, inputs, processes and oututs.

Design processes and notation – including pseudocode, flowcharts, structure diagrams and wireframes.

Data types and structures: character, string, numeric (integer and real), Boolean and 1-D arrays.

Computational constructs: variables, arithmetic operations (+, -, *, /, ^), selection (IF), logical operators (AND, OR, NOT), comparitors (=, >, <, ≥, ≤, ≠), fixed and conditional loops and pre-defined functions.

Standard Algorithms: input validation, loop and sum, traverse an array.

Testing: normal, extreme and exceptional test cases.

Error types: syntax, execution and logic errors.

Evaluation: fitness for purpose, efficiency of coding constructs, robustness, readability (internal commentary, meaningful identifiers, indentation, white space)


Computer Systems

Pupils develop an understanding of how data and instructions are stored in binary form and basic computer architecture. They gain an awareness of the environmental impact of the energy use of computing systems and security precautions that can be taken to protect computer systems. Unit Content includes:


Data Representation: binary for positive integers, floating point represenetation, 8-bit ascii, vector graphic (representation of rectangle, ellipse, line, polygon), bit mapped graphics.

Computer Structure: processor (registers, ALU, control unit), memory locations with unique addresses, buses (data and address), interpreters and compilers to translate high-level program code to binary instructions.

Environmental Impact: describe the energy use of computer systems, the implications on the environment and how these could be reduced through settings on monitors, power down settings, leaving computers on standby.

Security Precautions: the role of firewalls and encryption in electronic communications.


Database Design and Development

Pupils will develop knowledge, understanding and practical problem-solving skills in database design and development, through a range of practical and investigative tasks. This allows candidates to apply computational-thinking skills to analyse, design, implement, test, and evaluate practical solutions, using a range of development tools such as SQL. Tasks involve some complex features (in both familiar and new contexts), that require some interpretation by candidates. Unit Content includes:

Analysis: Identify the end-user and functional requirements of a database problem.

Design: Implications for individuals and businesses of the General Data Protection Regulation (GDPR), entity-relationship diagrams with two entities, data dictionaries, relationships (one to many) and design of queries.

Database structure: two linked tables, field types (text, numbers, date, time, graphics, calculated, link, Boolean), field lengths and range, primary and foreign key fields.

Implementation: relational databases with two linked tables, SQL code to access and manipulate database.

Testing: Check SQL operations work correctly.

Evaluating: Evaluate solution in terms of fitness for purpose and accuracy of output.


Web Design and Development

Pupils will develop knowledge, understanding and practical problem-solving skills in web design and development, through a range of practical and investigative tasks. This allows candidates to apply computational-thinking skills to analyse, design, implement, test and evaluate practical solutions to web-based problems, using a range of development tools such as HTML, CSS and Javascript. Tasks involve some complex features (in both familiar and new contexts), that require some interpretation by candidates. Unit Content includes:

Analysis: Identify the end-user and functional requirements of a website problem.

Design: website structure and linkage, user interface design (wireframing), Copyright, Designs and Patents act and its implications for web content, standard file formats for audio and graphics and comparisons of quality and file size, the need for compression in digital media.

Implementation of HTML: <body> <heading> <paragraph> <div> <link> <anchor> <img> <audio> <video> lists <ol> <ul> and <li>.</p> <p>Implementation of CSS: selectors, classes and IDs, properties (font-family, font-size, color, text-align, background-color)</p> <p>Implementation of Javascript: mouse events: Onmouseover(), Onmouseout().</p> <p>Testing: matches user-interface design, links and navigation work, media content displays correctly, consistency.</p> <p>Evaluation: Fitness for purpose.</p> <p><br /><span style="text-decoration: underline;"><strong>Duration</strong></span></p> <p>Pupils have 3 (60 minute) periods of Computing Studies per week.</p> <p> <br /><span style="text-decoration: underline;"><strong>Homework</strong></span></p> <p>Homework is issued regularly - typically once a week. This will be less when pupils are undertaking practical assessments and project work in class. Pupils should expect to set aside 45 minutes for each homework exercise. Most homework will take the form of written exercises to test knowledge and skills and consolidate all learning, including literacy and numeracy.</p> <p> </p> <p><span style="text-decoration: underline;"><strong>Assessment</strong></span></p> <p>Pupils will be assessed in the following ways:</p> <p>Nat 4: There is currently NO external assessment - no final exam. The 4 main units will be assessed internally by a combination of open book tests and practical tasks.</p> <p>Nat 4: The added value unit is assessed on a Pass/Fail basis - no mark/grade is applied.</p> <p><br />Nat 5: A written exam is set by the SQA. The paper will consist of 110 marks (69% of total mark): 25 marks will consist of short answer questions; 85 marks will consist of extended response questions.</p> <p>Nat 5: A practical assignment set by the SQA worth 50 marks (31% of total mark). The assignment is an integrated task covering analysis, design and development as applied to Software Development (25 marks), Database Development (15 marks) and Web Development (15 marks).</p> <p><br /><span style="text-decoration: underline;"><strong>Progression</strong></span></p> <p>Pupils who successfully complete the National 4 course can progress to National 5.</p> <p> </p> <p>Pupils who successfully complete the National 5 course at level A-B can progress to Higher Computing Science.</p> <p><br /><span style="text-decoration: underline;"><strong>Possible career routes</strong></span></p> <p>Games Developer, Digital Photographer, Web Designer, Database Designer, Forensic Analysis, Electrical Engineer Programmer, Computer Technician, Systems Analyst, Social Network Manager, Computer Animator, Microprocessor Designer, AntiVirus/Malware Designer, Computer Security Consultant (Ethical Hacker)</p> </div> </div><!--wrapper-inside--> </div> </div> <!-- ------------------------ Footer ------------------------ --> <footer data-aos="fade-down" data-aos-offset="50" data-aos-delay="100" data-aos-duration="800" data-aos-easing="ease" data-aos-mirror="false" data-aos-once="true" data-aos-anchor-placement="top-bottom"> <div class="wrapper"> <div id="footer-sst"> <p class="footer-name">Madras College</p> <p class="address">Bell Brae, St. Andrews, Fife KY16 9BY<br></p> <p class="telephone">01334 659401</p> <a href="mailto:madrascollege.enquiries@fife.gov.uk?subject=Enquiry%20from%20website">madrascollege.enquiries@fife.gov.uk</a> </div> <!--<div id="footer-kil"> <p class="footer-name">Kilrymont Office</p> <p class="address">Kilrymont Road, St. Andrews FIFE KY16 8DE<br></p> <p class="telephone">01334 659401</p> <a href="mailto:madrascollege.enquiries@fife.gov.uk?subject=Enquiry%20from%20website">madrascollege.enquiries@fife.gov.uk</a> </div>--> <!-- ------------------------ "Sub-Footer" ------------------------ --> <div class="sub-footer"> <p class="copyright">Copyright © 2020 | <a href="/legal">Legal Information</a></p> <p id="credit">Website Design by <a href="https://www.greenhouseschoolwebsites.co.uk" target="_blank">Greenhouse School Websites</a></p> </div> </div> </footer> <section id="awards"> <div class="CMSawards"> <ul> <li> </li> </ul> </div> </section> <!-- Search Form Overlay --> <div id="search"> <form id="FS" method="post" action="/inc/Search/"> <input placeholder="Search site" name="S" type="search" id="search-field" accesskey="4" onfocus="resetsearch()" value="Search site"></form> </div> <!-- AOS LIB JS --> <script type="text/javascript" src="/inc/js/include/AOS/aos.js"></script> <script> AOS.init(); </script> <!-- Translate --> <script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script> <script type="text/javascript"> function googleTranslateElementInit() { new google.translate.TranslateElement({ pageLanguage: 'en' }, 'google_translate_element'); } </script> <script type="text/javascript" src="/inc/js/scripts.min.js"></script> <script type="text/javascript"> // Mobile Navigation $(document).ready(function () { $('nav#navholder .wrapper').meanmenu({ meanMenuContainer: '#wrapper', // Choose where meanmenu will be placed within the HTML meanScreenWidth: "990", // set the screen width you want meanmenu to kick in at meanRevealPosition: "center", // left right or center positions meanRevealPositionDistance: "", // Tweak the position of the menu from the left / right meanShowChildren: true, // true to show children in the menu, false to hide them meanExpandableChildren: true, // true to allow expand/collapse children meanRemoveAttrs: true, // true to remove classes and IDs, false to keep them meanDisplay: "block", // override display method for table cell based layouts e.g. table-cell removeElements: "" // set to hide page elements }); }); // Search Overlay $(document).ready(function () { $('a[href="#search"]').on('click', function (event) { $('#search').addClass('open'); setTimeout(function () { $('input[name="S"]').focus() }, 100); }); $('#search, #search button.close').on('click keyup', function (event) { if (event.target == this || event.target.className == 'close' || event.keyCode == 27) { $(this).removeClass('open'); } }); }); // News pullout tab $(".news-tab").click(function () { $("#SideHeadingNews").toggleClass("news-tab-out", 100); }); // Twitter pullout tab $(".twitter-tab").click(function () { $("#twitter-pullout").toggleClass("twitter-tab-out", 100); }); // Backstretch // $("#slider").backstretch([ $.backstretch([ <!-- imagefolder = D:\Plesk\Vhosts\madras.fife.sch.uk\httpdocs\Computing-National-4-5--> <!-- FolderToUse = --> "/i/photos/Gallery/Home/030.jpg" , ], {duration: 5000, fade: 500} ); <!-- banimgs = 6 banimgsize = 562500 --> // sticky navholder and back to top button $("document").ready(function () { // Nav stick to top $(window).bind('scroll', function () { if ($(window).scrollTop() > 350) { $('.sticky-icky').addClass('fixed'); // $('#slideOut').css({"top": "50px", "position": "fixed"}); } else { $('.sticky-icky').removeClass('fixed'); // $('#slideOut').css({"top": "270px", "position": "absolute"}); } }); }); //Calculate hero height // INSIDE PAGES Calculate hero height $(function () { $(window).bind("resize", function () { var height = $(window).height(); $('#slider').height(height - 800); }).trigger("resize"); }); // Reset site search form on focus function resetsearch() { $("#search-field").val(""); } $(document).ready(function () { // Check to see if there's anything in sidebar var cl = $('.ColumnLeft nav').length; var cr = $('.ColumnRight nav').length; // Finding an li inside the div var awb = $('.CMSawards li img').length; // If nothing added via CMS if (awb == 0) { $('.CMSawards').attr('class', 'hidden'); $('#awards').hide(); } // If sidebars are empty, change Content2Column to Content1Column if (cl == 0 && cr == 0) { $('.Content2Column').attr('class', 'Content1Column'); $('.ColumnLeft, .ColumnRight').hide(); } // Add parent class to 2nd level links with children $("#dmenu li li a").each(function () { if ($(this).next().length > 0) { $(this).addClass("parent"); }; }); // Add doubleTapToGo to navigation links $("#dmenu li:has(ul)").doubleTapToGo(); /* touch device menus */ }); //RESPONSIVE CODE function checkWidth() { var windowSize = $(window).width(); if (windowSize < 770) { // If mobile: Insert sidebar after Content2Column $(".ColumnLeft").insertAfter(".Content2Column"); $(".ColumnRight").insertAfter(".Content2Column"); } else { // Otherwise reposition sidebar before Content2Column $(".ColumnLeft").insertBefore(".Content2Column"); $(".ColumnRight").insertBefore(".Content2Column"); } } checkWidth(); $(window).bind('resize orientationchange', function () { checkWidth(); }); //Close modal $(function () { $(".close-CMSmodal").click(function () { $(".message-CMSmodal").addClass("hide-CMSmodal"); $(".CMSmodal-home").addClass("CMSmodal-bg"); }); }); //prevent # link from having action $('a[href="#"]').click(function (e) { e.preventDefault(); }); </script> <!-- reload on orientation or size change --> <script type="text/javascript"> window.onorientationchange = function() { var orientation = window.orientation; switch(orientation) { case 0: case 90: case -90: window.location.reload(); break; } }; </script> <!--end expanding code--> <script type="text/javascript" charset="UTF-8" src="https://s3-eu-west-1.amazonaws.com/gsopublic/Cookie+Script/CookieScript_1.js"></script> <!-- hide sidebars if empty --> <script type="text/javascript"> var cleft = $.trim($('.ColumnLeft').text()).length; var cright = $.trim($('.ColumnRight').text()).length; // If sidebars are empty, change Content2Column to Content1Column if (cleft < 4 && cright < 4) { $('.Content2Column').attr('class','Content1Column'); $('.ColumnLeft, .ColumnRight').hide(); } if (cleft > 4 && cright < 4) { $('.Content3Column').attr('class','Content2Column'); $('.ColumnRight').hide(); } if (cleft < 4 && cright > 4) { $('.Content3Column').attr('class','Content2Column'); $('.ColumnLeft').hide(); } </script> <!--end sidebar hide --> <script type="text/javascript"> //$("video").css({"height": "110%", "width": "100%"}); </script> <!-- Stats --> <!-- Global site tag (gtag.js) - Google Analytics --> <script async src="https://www.googletagmanager.com/gtag/js?id=UA-178786867-1"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-178786867-1'); </script> </body> </html>