Grade 11 (NIS Programme 2.0)

Computer Science 11 (advanced)

Short term plan
Lesson topic. Learning objectives
Theory, Questions, Exercises

Unit 11.1A - Computer system

11.1A Software categories: system and application
11.3.1.1 classify software
11.1A Application software classification
11.3.1.3 describe the purpose of applications subcategories: general purpose, special purpose, bespoke
Theory and Tasks 2024 
"Application software classification"

Unit 11.1B - Web design

11.1B Web page design. Identifying HTML tags and their purpose
11.5.3.1 define common elements of the web page structure
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
Theory and Tasks 2024 
"Web page interface"

Unit 11.1C - Project development

11.1C SDLC models. Project development
11.2.1.1 determine the main stages of the system development life cycle
11.2.1.2 distinguish the advantages and disadvantages of waterfall, agile, and spiral models

Theory & Tasks 2022
"SDLC"

Theory & Tasks 2023
"Models of SDLC"

11.1C Data collection methods
11.2.1.3 describe data collection methods 
11.2.1.4 compare qualitative and quantitative data analysis techniques
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
Theory and Tasks 2024 
"Alternative solutions"

Unit 11.2A - Information systems

11.2A Basic database concepts
11.4.1.1 describe the relational database and its purpose
11.4.1.2 use the terms "table", "attribute", "record", "index" when describing database
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 SQL database
Theory and Tasks 2020 
"Data types"
11.2A Data dictionary
11.4.1.5 explain the purpose of the data dictionary
11.4.1.6 create a data dictionary of 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
Theory and Tasks 2021 
"Data validation"
11.2A Entity-Relationship Diagrams
11.4.1.7 describe types of relationships between tables in the database
11.4.1.8 define relationships between tables in a relational database
11.2.2.2 create an entity-relationship diagram (ERD)
11.4.1.3 explain the difference between primary, foreign, and composite keys
Theory and Tasks 2020 
"ERD"
Theory and Tasks 2020 
"Primary and foreign keys"
11.2A Database normalization
11.4.1.9 list the normalization rules for the first, second, and third normal form
11.4.1.10 normalize the database to the 3rd normal form

11.4.1.11 create a multiple tables database for a new system
Theory and Tasks 2024 
"Database normalization"

11.2A SQL query language. DDL
11.4.2.1 compare the data definition language (DDL) and the data manipulation language (DML)
11.4.2.2 create database structure using DDL statements: CREATE, ALTER, and DROP

Theory & Tasks 2022 
"SQL. Data definition language"
11.2A SQL queries. DML
11.4.2.3 create SQL SELECT, UPDATE, INSERT, and DELETE queries to manipulate data in one table
11.4.2.5 use the ORDER BY command to sort the retrieved query data
Theory & Tasks 2022 
"SQL. Data manipulation language"

Unit 11.2B - Project development. Design

11.2B SELECT data from multiple tables
11.4.2.4 use SELECT statement to retrieve 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
11.2.2.1 create the first level data flow diagram (DFD) to input, process, store, and output data for the computing system

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

 
Theory and Tasks 2020 

Theory and Tasks 2020 

11.2B Processing design
11.2.2.3 design flowcharts for processes of computing systems

Theory & Tasks 2020

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 

11.2B Hardware & software requirements
11.3.2.1 determine the minimum hardware requirements for implementing a new system
11.3.1.4 justify the choice of software for implementing a new system

Theory & Tasks 2022 

 

11.2B Topic
LO
Theory & Tasks 2024 
"Topic"

11.2B Topic
LO

Theory & Tasks 2024 
"Topic"

 

in developing

Категория: Input/Ouput devices | Добавил: bzfar77 (17.06.2024)
Просмотров: 467 | Рейтинг: 0.0/0
Всего комментариев: 0
avatar