Grade 11 (NIS Programme 2.0)
|
Computer Science 11 (advanced) Short term planLesson topic. Learning objectives
Theory, Questions, Exercises
Unit 11.1A - Computer system11.1A Software categories: system and application
11.3.1.1 classify software Theory and Tasks 2024
"Software categories: system and application" 11.1A Application software classification
11.3.1.3 describe the purpose of applications in the following subcategories: general purpose, special purpose, and bespoke Theory and Tasks 2024
"Application software classification" 11.1A System software classification
11.3.1.2 describe the purpose of the OS, utilities, libraries, and translators Theory and Tasks 2026
"System software classification" 11.1A Functions of operating systems
11.3.1.5 describe the main functions of operating systems Theory and Tasks 2024
"Functions of an operating systems" 11.1A Types of operating systems: single-user and multi-user, one-task and multitasking
11.3.1.6 compare single-user and multi-user operating systems 11.3.1.7 compare single-tasking and multitasking operating systems Theory and Tasks 2024
"Types of operating systems: single-user and multi-user, one-task and multitasking" 11.1A Types of operating systems: real-time, network, batch processing
11.3.1.8 describe the features of a real-time operating system 11.3.1.9 describe the features of a network operating system 11.3.1.10 describe the features of a batch processing operating system Theory and Tasks 2024
"Types of operating systems: real-time, network, batch processing" 11.1A User interfaces: GUI vs CLI
11.3.1.11 identify the advantages and disadvantages of graphical user interfaces (GUI) 11.3.1.12 identify the advantages and disadvantages of command line interfaces (CLI) 11.3.1.13 compare graphical user interfaces (GUI) and command line interfaces (CLI) Theory and Tasks 2024
"User interfaces: GUI vs CLI" 11.1A User interfaces: NLI & GRI
11.3.1.14 explain the advantages and disadvantages of Natural Language Interfaces (NLI) and Gesture Recognition Interfaces (GRI) 11.1A Areas of AI application
11.4.3.3 identify the differences between artificial intelligence, machine learning and deep learning 11.4.3.1 identify the advantages and disadvantages of using artificial intelligence in society Theory and Tasks 2026
"AI, ML and DL" "AI in society" 11.1A Virtual and augmented reality
11.4.3.2 explain the purpose of virtual and augmented reality Theory and Tasks 2024
"Virtual and augmented reality" 11.1A Classification of programming languages
11.5.1.1 classify programming languages into low-level and high-level languages 11.5.1.2 compare high-level and low-level programming languages Theory and Tasks 2024
"Classification of programming languages" 11.1A Imperative and declarative programming languages
11.5.1.3 compare imperative and declarative programming languages Theory and Tasks 2024
"Imperative and declarative programming languages" Unit 11.1B - Web design11.1B Web page design. Identifying HTML tags and their purpose
11.5.3.1 identify common elements of a web page structure Theory and Tasks 2024
"Web page design. Identifying HTML tags and their purpose" 11.1B HTML forms
11.5.3.4 create HTML forms for data entry Theory and Tasks 2024
"HTML forms" 11.1B CSS in web design
11.5.3.5 compare CSS implementing types 11.5.3.6 use CSS when designing a website Theory and Tasks 2024
"CSS in web design" 11.1B Web page interface
11.5.3.2 create an interface using HTML and CSS 11.5.3.3 implement site navigation Theory and Tasks 2024
"Web page interface" Unit 11.1C - Project development11.1C SDLC models. Project development
11.2.1.1 define the main stages of the system development lifecycle 11.2.1.2 evaluate the advantages and disadvantages of system development models, including Waterfall, Agile and Spiral Theory & Tasks 2022 Theory & Tasks 2023 11.1C Data collection methods
11.2.1.3 describe data collection methods 11.2.1.4 compare qualitative and quantitative methods of data analysis Theory and Tasks 2024
"Data collection methods" 11.1C Project. Data analysis
11.2.1.5 use data collection methods to develop a new system Theory and Tasks 2024
"Project. Data analysis" 11.1C Software development options
11.2.1.6 compare alternative solutions to a problem 11.2.2.1 create a first-level data flow diagram (DFD) to represent input, processing, storage, and output in computing systems 11.2.2.3 develop flowcharts of processes in computing systems Theory and Tasks 2024
"Alternative solutions" "Data Flow Diagram" "Flowcharts" Unit 11.2A - Information systems11.2A Basic database concepts
11.4.1.1 describe relational databases and their purpose 11.4.1.2 use the terms "table", "attribute", "record", and "index" to describe databases 11.4.1.3 explain the difference between primary, foreign and composite keys Theory and Tasks 2020
"Database table elements" Theory and Tasks 2020 "Differences between primary and composite keys" 11.2A Data types
11.4.1.4 define data types in an SQL database Theory and Tasks 2020
"Data types" 11.2A Data dictionary
11.4.1.5 explain the purpose of a data dictionary 11.4.1.6 create a data dictionary for database tables Theory and Tasks 2020
"Data dictionary" 11.2A Data validation
11.5.4.2 explain the difference between data verification and data validation 11.5.4.3 apply data verification and validation in program code Theory and Tasks 2021
"Data validation" 11.2A Entity-Relationship Diagrams
11.4.1.7 describe the types of relationships between tables in a database 11.4.1.8 define relationships between tables in a relational database 11.2.2.2 create entity-relationship diagrams (ERD) 11.4.1.3 explain the difference between primary, foreign and composite keys Theory and Tasks 2024
"ERD" Theory and Tasks 2023 "Primary and foreign keys" 11.2A Database normalization
11.4.1.9 list the normalisation rules for the first, second and third normal forms 11.4.1.10 normalize a database to the 3rd normal form 11.4.1.11 create a database with multiple tables for a new system Theory and Tasks 2024
"Database normalization" 11.2A SQL query language. DDL Theory & Tasks 2022
"SQL. Data definition language" 11.2A SQL queries. DML
11.4.2.3 use SQL SELECT, UPDATE, INSERT and DELETE queries to manage data in a single table 11.4.2.4 use the SELECT command to extract data from multiple tables 11.4.2.5 use the ORDER BY command to sort the data returned by a query Theory & Tasks 2022
"SQL. Data manipulation language" "SQL. SELECT data from multiple tables" Unit 11.2B - Project development. Design11.2B SELECT data from multiple tables Theory & Tasks 2022
"SQL. SELECT data from multiple tables" 11.2B Designing a new system
SMART objectives Theory & Tasks 2022
"Project work: Design" 11.2B Design a new system. DFD 1-level Theory & Tasks 2022
"Data Flow Diagram" 11.2B Database design
11.2.2.2 create an entity-relationship diagram (ERD) 11.4.1.6 create a data dictionary of database tables 11.2B Processing design Theory & Tasks 2020
"Flowcharts" 11.2B Prototyping
11.2.2.4 explain the advantages and disadvantages of using prototypes when developing solutions 11.2.2.5 develop a prototype of the interface, input, and output forms of the new system Theory & Tasks 2022
"Prototyping" 11.2B Hardware & software requirements Theory & Tasks 2022
"Hardware & software requirements"
11.2B Topic
LO Theory & Tasks 2024
"Topic" 11.2B Topic Theory & Tasks 2024
"Topic"
in development | |
|
| |
| Просмотров: 2543 | |
| Всего комментариев: 0 | |