Boston High School Computing Department



Year 11 Dated SOW for GCSE Computing 2017 – 2018LessonWeekDateObjectivesGCSE StrandLesson ContentAssessmentHomeworkStretch & Challenge11070917Introduction to year 11 in context of work done during year 10. Theory content recap, theory requirements for year 11Recap on progress made in year 10, highlighting the good quality work done during the year. Key pointers to Pthn progress and relevance with upcoming NEAN/AN/AN/A21080917Introduction to NEA component including exam board requirements. NEA rules and online guidance.3.1What is the NEA ?What does it involve?Where are the resources and what do they look llke?NEA quiz sheetStart recapping Python work from last year.Python extensions.32120917Basic data input and output (Python)Data representation, calculations on screenReading data in from the keyboardOutputting data to the screenPython data manipulation tasksComplete task sheetPython extension tasks42140917Computer fundamentalsWhat is a computer system ?What is reliability ?How do we make them more reliable ?What are the component parts of a computer system ?What are the component parts of the computer itself ?Identify the parts taskLabel the function sheetWhats in your PCactivity ?Onine Videos53190917Python good programming practise. Stickers distributed and referenced in context of NEA ments in Python Meaningful variable namesMeaningful file namesClear documentationGood programming practise exerciseFinalise classworkOnline videos to revise work from year 10 (see bhscomputing website)63210917Python data conversion lesson changing from on data type to anotherConverting between different data types when reading in data from the keyboard (string ad it)Conversion workbookFinalise workbookOnline videos to revise work from year 10 (see bhscomputing website73220917Python string manipulation How to concatenate strings (text)String SheetsPython TasksString manipulation homework tasksWatch youtube string manipulation video84260917Python string manipulation.How to concatenate strings (integer) Lengthof, Sub strings,Change to upper / lowerConcatenation worksheetHomework task sheetWatch youtube string manipulation video94280917Systems Architcture1.1Purpose of CPUPerformance of CPUFactors affecting performanceClock speedCache memoryCoresCPU performance taskDefintions and role of each of the factorsComplete CPU homework sheetCPU extension research task - registers105031017Von Neumann Architecture1.1What is it ?Registers and their rolesFetch Decode ExecuteName hat register taskFDE Powerpoint taskComplete FDE sheet FDE Q&A sheet115051017File handlingCreating and adding to text files in PythonWriting to and reading from text files.Different data types in files and how to access themPython text file exercises including text editor entry and conversion between Microsoft Office and pure text.Python file handling workbook tocompleteFile extension task.1250610172D Arrays in PythonCreating and accessing 2D arrays.Array indexingWriting to and editing array contents.Deleting and modifying array with different data types.Array workbookNEA practice flesNEA practise files to complete for next lessonNA136101117Embedded SystemsThe role of embedded systems in the modern world. Applications of outside of the home.Embedded systems activity booklet with videoWhat is ? sheetExplore further embedded systems outside of school environment146121117Hexadecimal numberingHex conversion – change from binaryTwo techniquesApplications in programming and colour selectionTeach-ict activitiesNichola WilkinPython programming taskExercise sheetsYoutube hex conversion series157171017Shift ChecksWhat is a shift check ?Logical Shift left Logical Shift rightShift task sheetComplete exercise sheetsAS task sheet16719101750 mns NEA workPupils working on NEA in controlled environment.NANANA177201017Binary conversion and addition.Recap binary conversionConversion toConversion fromBinary Sheet 1 (to binary)Binary Sheet 2 (from binary)Binary Sheet 3binaryYoutube links from dept websiteHALF TERM BREAK18831101750 mins NEA workPupils working on NEA in controlled environment.NANANA198021017NEA Question – class based discussion regarding approaches to dealing with the NEA. Clear instructions relating to level of understanding ad requirements of NEA question.Pupils exploring the question in pairs and highlighting possible paths to explore furtherNEA 209031017NEA class based work session. (group)Pupils discussing ways to approach a problem and correct way to document progressNEA folder explorationN/AN/A21907101750 mins NEA workNANANA22909101750 mins NEA workNANANA2310141017Algorithms and Data StructuresLinear SearchingWhat is it ?Binary SearhingWhat is it ?Pseudoocde and dry runningPseudocode planningWalk throughAlgorithm a day tasksCorrect the error in the algorithmYoutube animations (dancing)Program plan2410161017Sorting DataBubble SortMerge SortInsertion SortWhat is ?How does it workSorting workbookSearching workbookYoutube animations (dancing)Program plan2511171017Algorithms and Data StructuresBubble SortMerge SortInsertion SortProgramming of bubble, insertion, merge sortIdentify the algorithmSorting workbookSearching workbookProgram planning tasks2611191017Sorting DataPseudocode and FlowchartsINPUTOUTPUT/PRINTSELECTIONIF ELSEITERATIONFOR LOOPCASTINGAlgorithm workbook finalise2711201017Translators and facilities of languagesAssemblers and CompilersTranslationHow do they work ?teach-OCR textbook exercisesComplete separate task sheetYoutube links from dept website2812311017Computer LegislaionThe Data Protection ACT (& GDPR)8 rulesExpectationsChanges with GDPR coming inDP Revision poster taskDP questions from teach-Complete outstanding workBBC News article on GDPR2912021117Computer LegislaionComputer Misuse ActCopyright, Designs and PatentsResearch and produce Prezi or Powerpoint with key exam revision texts from specificationComplete Prezi for next lessonBBC News article on Computer Misuse Act3013031117Computer LegislaionCreative Commons LicensingCCL Work bookletFinalise CCL bookletBBC News article on CCL3113071117Computer LegislaionFreedom of Information ActNews article exerciseApplicability to ComputingFinalise news exerciseBBC News article on Freedom of Infromation Act321309111750 mins NEA workNANANA3314141117Memory, RAM and ROMPurpose of and advantages of each type.Flash and virtual memory.Memory Workbook and question sheetPoster to revse this topic rom.Pupils to complet the high level detail tasks on realmemory applications341416111750 mins NEA workNANANA3515171117Calculating storage requirementsBits, bytes, kilobytes, megabytes, gigabytes. Calculating (estimating file size)Capacity workbookStorage device comparison activityTask sheetYoutube link from dept website3615211117Calculating storage requirementsCalculating amount of storage for a given record type in a text file. Storage Device comparisionsWhat is a record ?Fieldnames and datatypesASCII and counting of bytesFile sizing worksheetYoutube link from dept website3715231117NetworkingTypes of networksAdvantages and disadvantages of particular topologies.What is a network ?Topology task sheetComparison of networksComplete sheet from homework task bookletOnline tasks from dept website3816281117WANS and LANSAdvantges and applications of each type. How to identify work workbooksHomework task sheetsOnlne Cisco emulator and tasks3916301117Network hardwareNetwork hardware. What do you need and why ?Identify the hardwareTable taskCheck connectionsCraig n Dave bookletAS task4017011217Client Server and peer to peerWhat is a client ?What is a server ?How do they relate to one another ?Name the serviceLinking hardware taskCraig n Dave bookletAS task4117051217Network performanceFactors which affect the performance of a network. BandwidthUsersWired or wirelessTopologesOnline network tester activityHow to check your home connectionMobile phone data taskExam questionsCraig n Dave bookletAS task4217071217The InternetWhat is it ?How does it work ?Key terms including hardware.World science festival taskSpeedcheckTeach-ict activityYoutube video task(flipped learning)4318121217DNS & Virtual NetworksBenefits of using a DNSWhat is a virtual network and why use it ?Craig n Dav e-resourceCraig n Dav e-bookletYoutube video task(flipped learning)4418141217What is WIFI ?WIFI including frequency and channels, encryption, WEP and WPA.Craig n Dav e-resourceCraig n Dav e-bookletYoutube video task(flipped learning)4518151217TopologiesStar and Mesh TopologiesCraig n Dav e-resourceCraig n Dav e-bookletYoutube video task(flipped learning)4619191217Storage DevicesMagnetic, Optical and flash memory types.Applications of each and suitable uses in the school.Craig n Dav e-resourceExam questionsCraig n Dav e-bookletYoutube video task(flipped learning)48040118Recap of work to date49090118NEA AnnouncemnetMoving forward with the NEARevisit legislationData protection legislationYoutube video watchYoutube video watch50110118Packet switching ad EthernetWhat is packet switching ?What is Ethernet ?Youtube video showing packet switching (world science Network task bookletYoutube video task(flipped learning)51120118Circuit switchingWhat is circuit switching?School network visitWorkbook from Craig n DaveOnline taskYoutube video task(flipped learning)52160118Systems SecurityThreats to a networkInternal threats in a companyPrevention of threatsUsing software and hardware.Craig n Dave video taskCraig n Dave workbookOnline taskYoutube video task(flipped learning)53180118Systems Security -VulnerabilitiesVirusPhishingBrute Force AttacksDenial of serviceData interceptionSQL injectionPoor network policy.Prezi task on network threatsWorkbook taskExam questionsTasks from teach-Extension tasks from teach-ict54230118Systems Security -VulnerabilitiesPenetration testingNetwork forensicsNetwork policiesAnti-Malware softwareFirewallsUser account levelsPasswordsEncryptionAdd to Prezi from previous lessonExam questionsFinalise PreziExtension tasks from teach-ict55250118Network Progress TestNetwork concepts testNetworks concept testCreate a revision wheel for networkingExam question practise56260118Software types revision from year 10Systems software and application software.Operating systemsUtility programsProprietary softwareOpen Source softwareSoftware workbook and tasksRevsion wheel on this topicRead relevant sections in each of the text books you have.57300118Characteristics of OSUser InterfaceMemory ManagementPeripheral driversUser managementFile managementCraig n Dave Video Craig n Dave workbookExam questionsRevsion wheel on this topicRead relevant sections in each of the text books you have.58010218Utility SoftwareEncryptionDefragmentationCompressionBackupsRevision wheel taskResearch in real world taskWhat I is sheet ?Read relevant sections in each of the text books you have.59060218Open source v propietaryWhat is open source ?What is proprietary ?Exam questionsRevision Poster taskRead relevant sections in each of the text books you have.6008021850 mins NEA workNANANA61090218Ethical, Legal and CulturalEthical, Legal and Cultural aspects of ComputingPowerpoint choice task with pupils moving around the work area.Ethical Research TaskComplete ERT6220021850 mins NEA workNANANA63220218Computationl LogicLogic GatesANDOR NOTTruth Table TaskExam questionsHomework Booklet on logic gatesCraig n Dave Videos from dept website6427021850 mins NEA workNANANA65010318What is a database ?What is a databaseApplications and uses ofPhonebookiTunesWebsitesSIMsDatabase Concept s activityTeach-ict website taskExam questionsDatabase workbookDatabase extension task66020318Creating and filling in a databaseUsing Access to create a student databaseDesign and addingDataMS Access bookletMS Access quiz sheetDatabase workbookDatabase extension task67060318Relational Tables andSQLLinking tables task Primary key defined1 to many1 to 1Many to manyTeach-Ict activityDatabase workbookYoutube video on RDBMS6808031850 mins NEA workData protection revisitData protectionExam questionsNANA6913031850 mins NEA workNetworking revisionNetworking revisionExam questionsNANA7015031850 mins NEA workNumber conversion revisionNumber conversion revisionExam questionsNANA7116031850 mins NEA workOSI layer revisionOSI layer revisionExam questionsNANA200318Defensive DesignCheck digitFormat checkLength check Lookup tablePresence checkRange checkImplementation in MS AccessUse in PythonExam questionsDefensive design task sheetYoutube links from dept website220318Producing Robust programsContingency planningAuthanticationUse of techniques in program designUse of techniques in database designRobust program workbookYoutube links from Craig n Dave27031850 mins NEA workDatabase revision sheetExam questionsNANA290318MaintainabilityIndentationCommentsPPTExam questionsPython program booklet tasksPython program booklet tasks300318ErrorsError typesSolving errorsFeatures of an IDESyntaxlogicruntimeError task sheetCraig n Dave worksheetExam revisionExam revision17041850 mins NEA workCompiler and InterpretersExam questionsExam revisionExam revision19041850 mins NEA workStorage DevicesExam questionsExam revisionExam revision24041850 mins NEA workInput DevicesExam questionsExam revisionExam revision26041850 mins NEA workOutput DevicesExam questionsExam revisionExam revision270418TestingTesting techniquesRange testingTesting workbookExam revisionExam revision01051850 mins NEA workExam questionsExam questionsExam revisionExam revision03051850 mins NEA workExam questionsExam questionsExam revisionExam revision08051850 mins NEA workExam questionsExam questionsExam revisionExam revision10051850 mins NEA workLong answer question revision and techniqueExam questionsExam revisionExam revision110518NEA finalise WorkExam questionsExam questionsExam questionsExam questions150518Final NEA Admin. Pupils to ensure that they have signed candidate authentication sheets. Pupils to ensure that they have cross referenced all wrk which is from external sources in the bibliography.170518NEAs to be posted to OCR ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download