Computing
Year | Term 1: Autumn | Term 2: Winter | Term 3: Spring | Term 4: Summer | ||||
7 | Digital Literacy & Safe use of ICT Passwords & Computer Etiquette Mary hare Network /school share & E-mails Understanding targets Online Safety & Cyber bullying Finding, retrieving and validating info All about me PPT task (Baseline assessment)
| Digital Skills in Graphics – (ESafety Campaign) Letter writing Graphics theory Practical use of graphics Logo Creation E-safety Poster | Digital and programming Skills in Scratch – 6 Weeks Intro to scratch (inc mit website) Movement and interaction Loops and selection Broadcasting and scoring Plan and create a game
| The World of Integrated Task (The school show) Simple formulae Formatting Showing Formula & Printing Finding appropriate information on web DTP Financial Modelling Charts Presentations | ||||
8 | The world of work - Using Databases Paper vs. computer (adv. /dis.) Relational (knowledge of) Importing data Filter/Sort Forms Queries Reports | Digital Skills in VLogging What is a Video Log Identify components of a Video & Audio track Plan a VLOGGING competition Create and edit a VLOG Copyright Digital Piracy | Digital Skills and HTML Programming in Web design (design a microsite) Features of websites Evaluating good and bad sites Planning & Storyboard Create hyperlinked web pages Rollovers, slideshows, interactive features
| Modelling Use / formula Functions Goal seek Vlookup Frequency Python Introduction The World of Work Integrated Task (The game) Introduction | ||||
|
|
| Technical Knowledge Control language Control program Flowchart Using Logicator/flowol Stacks and queues -“First In First Out” situations and “First In Last Out” situations. | Systems lifecycle Tools Business Software Graphics/programming Spread sheets (modelling) Database
| ||||
9 | Digital Skills and Advanced HTML/Java Programming in Web design (design a microsite) – 6 Weeks Features of websites Planning & Storyboard Template. Create hyperlinked web pages, Hotspots, thumbnails, video and audio inserts , Calendar, email links, clock hit counters | Algorithms and programming Sorting algorithms on a quicksort and bubble sort. Two simple search methods: - Linear search - start at beginning and go to the end, set found to true if item found Introduction to Visual Basic/python Resources | Modelling Use / formula Functions Goal seek Vlookup Frequency
Visual Basic/Sql Boolean Logic and SQL programming -6 weeks Diagrams for logic gates. Combine gates and apply/relate them to well known Control“ situations link to work covered in Year 8 – Control Language Introduction to Networking and SQL
| The World of Work Integrated Task (The News broadcast Project) Planning – mind map Research/interviews Storyboard Script Filming Video editing Broadcasting Evaluation | ||||
| ||||||||
10 | Computer Systems System architecture Fundamentals of DATA representation.
| Storage Computational logic
Translators & facilities of language | Networks (Wired / Wireless) System security
Producing robust programs | System software Ethical legal & cultural concerns
Data representation | ||||
11 | Computer Systems System architecture Memory Storage
Fundamentals of DATA representation. Algorithms Computational logic
| Networks (Wired/Wireless) System security System software Programming techniques Producing robust programs
| Translators & facilities of language Data representation | Ethical legal & cultural concerns | ||||