ТВОЙ BZFAR
Главная » Статьи » Computer system (Hardware) » Input/Ouput devices
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
Theory and Tasks 2024 
"Software categories: system and application"
11.1A System software classification
11.3.1.2 describe the purpose of OS, utilities, program libraries, translators
Theory and Tasks 2024 
"System software classification"
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"
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 one-task 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 a real-time operating system
11.3.1.9 describe a network operating system
11.3.1.10 describe 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 define the advantages and disadvantages of a graphical user interface (GUI)
11.3.1.12 define the advantages and disadvantages of a command line interface (CLI)
11.3.1.13 compare a graphical user interface (GUI) and a command line interface (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 (NLI) and gesture-recognition (GRI) user interfaces
Theory and Tasks 2024 
"User interfaces: NLI & GRI"
11.1A Classification of programming languages
11.5.1.1 classify programming languages into low-level and high-level
11.5.1.2 compare high-level languages and low-level 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 design

11.1B Web page design. Identifying HTML tags and their purpose
11.5.3.1 define common elements of the 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
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