Читайте также:
|
|
___________________________________________
_________________________________________
__________________________________________
__________________________________________
__________________________________________________________________________________________________________________________________________________________
__________________________________________________________________________
Subject: informatics | Grade:11 Group _____ | Surname ____________________________ Name ____________________ | |||||||||||||
Formative control 1 Term 2 | |||||||||||||||
Unit: Algorithms and programming | |||||||||||||||
Learning objectives: LO1 know the characteristics of low-level languages, and the main concepts and features of popular computer languages LO2solve various problems using the algorithm of a Turing machine | |||||||||||||||
Criteria: А, B, D | |||||||||||||||
Task: 1. Characteristics which language suggested below? · Code can be fast and efficient · Code can make use of specific processor features such as special registers · As it is closer to plain English, it is easier to read and write when compared to machine code
A. machine code B. Assembly code C. third generation code
2. Given A = {1, 0}. Replace the input word all the characters "1" to "0" using the table of a Turing machine. Example: Input - 1011. Result - 0000. The carriage can initially be anywhere on the tape.
Answer:
3. Describe the conditions under which the transition from a state of Q0 in Q1 in the job number three. ______________________________________________________________ ______________________________________________________________ | |||||||||||||||
Learning objectives | Criteria | Descriptors | Achieved | Working to wards | Conclusion | ||||||||||
LO1 | А | know the characteristics of low-level languages, and the main concepts and features of popular computer languages | |||||||||||||
LO2 | B | solve various problems using the algorithm of a Turing machine | |||||||||||||
D,A | explain the algorithm of the Turing machine in depth, using a table diagram of the process | ||||||||||||||
Subject: informatics | Grade:11 Group _____ | Surname ____________________________ Name ____________________ | ||||||
Formative control 11.1.2 Term 1 | ||||||||
Themes: Binary search | ||||||||
Learning objectives: LO3 show understanding of the conditions necessary for the use of a binary search LO2 write a binary search algorithm to solve a particular problem | ||||||||
Criteria: A, B | ||||||||
1. Task: Given the arrays.
Write steps for find element 7 from array. ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________
2. Write a pseudo code for task 1 ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________
| ||||||||
Learning objectives | Criteria | Description | Achieved | Working towards | Conclusion | |||
LO3 | A | Know the steps how find the element | ||||||
LO2 | B | Correct write a pseudo code for binary search | ||||||
Subject: informatics | Grade:11 Group _____ | Surname ____________________________ Name ____________________ | ||||||
Formative control 11.2.5 Term 2 | ||||||||
Themes: Bubble sort | ||||||||
Learning objectives: LO4write an algorithm to implement an insertion and bubble sort LO3 show understanding of the conditions necessary for the use of a binary search | ||||||||
Criteria: A | ||||||||
1. Task: Given the arrays. Write a code for program only where you use Bubble sort on Ascending. _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ _____________________________________________________ 2. Task: Write a name of sorting. __________________________________________ 3. Task: Write a name of searching n.3:__________________________________________ 4. Task: formulates the advantages or disadvantages of bubble sort method against Merge Sort a. ___________________________________________________________ ___________________________________________________________ b. ___________________________________________________________ | ||||||||
Learning objectives | Criteria | Description | Achieved | Working towards | Conclusion | |||
LO4 | A | Correct write bubble sort code for task. | ||||||
LO3 | C | understanding of the method of sort | ||||||
LO4 | C | understanding of the method of search | ||||||
LO3 | D | formulates the advantages and disadvantages of the bubble sorting method | ||||||
Subject: informatics | Grade:11 Group _____ | Surname ____________________________ Name ____________________ | |||||||||
Formative control 11.2.6 Term 2 | |||||||||||
Themes: Database | |||||||||||
Learning objectives: LO5define the terms: attribute, primary key, composite key, foreign key, referential integrity, entity, table, record, tuple, index LO6 know data types in DBMS | |||||||||||
Criteria: A | |||||||||||
3. Define the following terms:
……..……sometimes called a record, a set of attribute values, (a row of a table).
Name of column in a tableis ……………..
……………..a attribute that uniquely identifies a tuple.
Where a collection of attributes uniquely identify a tuple rather than just one this is a ………….…
………….An attribute in one table that is a Primary key in another table, often there to reference to said table later.
4. Give the name data type in DBMS.
| |||||||||||
Learning objectives | Criteria | Description | Achieved | Working towards | Conclusion | ||||||
LO5 | A | Correct write definition of Primary key | |||||||||
Correct write definition of Composite key | |||||||||||
Correct write definition of Foreign key | |||||||||||
Correct write definition of tuple | |||||||||||
Correct write definition of attribute | |||||||||||
LO6 | A | Correct choose the name of data type in DBMS | |||||||||
Subject: informatics | Grade:11 Group _____ | Surname ____________________________ Name ____________________ | ||||||||||
Formative control 11.2.7 Term 2 | ||||||||||||
Themes: Database | ||||||||||||
Learning objectives: D LO2: explain the concept of a relational database | ||||||||||||
Criteria: D | ||||||||||||
Task 1 Give the name of next numbers
Task 2. Define the type of relationship in database draw in scheme and explain your answer.
________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________
|
Learning objectives | Criteria | Description | Achieved | Working towards | Conclusion | |||||||||||
LO2 | D | Correct write term of access | ||||||||||||||
Know the type of relationship | ||||||||||||||||
Correct define the type of relationship | ||||||||||||||||
Correctly explained his answer by choice of the type relationship | ||||||||||||||||
Subject: informatics | Grade:11 Group _____ | Surname ____________________________ Name ____________________ | ||||||||||||||
Formative control 11.1.2 Term 1 | ||||||||||||||||
Themes: Binary search | ||||||||||||||||
Learning objectives: LO3 show understanding of the conditions necessary for the use of a binary search LO2 write a binary search algorithm to solve a particular problem | ||||||||||||||||
Criteria: A, B | ||||||||||||||||
1. Task: Given the arrays.
Write steps for find element 7 from array. ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ 2. Which search method used? __________________________________ Write characteristics of this method ____________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________
3. Write a pseudo code for task 1 ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ ___________________________________________ 4. Draw a flow-chart for task 1
| ||||||||||||||||
Learning objectives | Criteria | Description | Achieved | Working towards | Conclusion | |||||||||||
LO3 | A | Know the steps how find the element | ||||||||||||||
Know the characteristics of search method | ||||||||||||||||
LO2 | B | Correct write a pseudo code for binary search | ||||||||||||||
B | Correct Draw a flow-chart for binary search | |||||||||||||||
Subject: informatics | Grade:11 Group _____ | Surname ____________________________ Name ____________________ | ||||||||||||||||||||||||||||
Formative control 11.2B.1 Term 2 | ||||||||||||||||||||||||||||||
Themes: Database | ||||||||||||||||||||||||||||||
Learning objectives: LO5define the terms: attribute, primary key, composite key, foreign key, referential integrity, entity, table, record, tuple, index LO6 know data types in DBMS | ||||||||||||||||||||||||||||||
Criteria: A | ||||||||||||||||||||||||||||||
1. Define the following terms:
……..……sometimes called a record, a set of attribute values.
Name of column in a table is ……………..
…………….. аn attribute that uniquely identifies a tuple.
Where a collection of attributes uniquely identify a tuple rather than just one this is a ………….…
…………. аn attribute in one table that is a Primary key in another table, often there to reference to said table later.
2. Give the name of types of databases.
| ||||||||||||||||||||||||||||||
Learning objectives | Criteria | Description | Achieved | Working towards | Conclusion | |||||||||||||||||||||||||
LO5 | A | Correct write definition of Primary key | ||||||||||||||||||||||||||||
Correct write definition of Composite key | ||||||||||||||||||||||||||||||
Correct write definition of Foreign key | ||||||||||||||||||||||||||||||
Correct write definition of tuple | ||||||||||||||||||||||||||||||
Correct write definition of attribute | ||||||||||||||||||||||||||||||
LO6 | A | Correct choose the name of types of databases | ||||||||||||||||||||||||||||
Subject: informatics | Grade:11 Group _____ | Surname ___________________________ Name _____________________________ Date ______________________________ | |
Formative control 11.3.5 Term 3 | |||
Themes: Computer Network | |||
Learning objectives:
| |||
Criteria: D |
1. Draw a lebelled diagram for each network topology, in the table below. You need also to think about some advantages and disadvantages for each. Think about things like:
· What would happen if a cable broke?
· How mucah cable do you need?
· Can data collide with each other?
· Which is the fastest?
Bus Network | Advantages |
Disadvantages | |
Ring Network | Advantages |
Disadvantages | |
Star Network | Advantages |
Disadvantages |
2. Describe the characteristics of a local area network (LAN) and a wide area network (WAN)
Characteristics | |
LAN | WAN |
Learning objectives | Criteria | Description | Achieved | Working towards | Conclusion |
LO3 | D | Can describe for each topology correctly | |||
LO4 | Can describe the characteristics of LAN and WAN |
Subject: informatics | Grade:11 Group _____ | Surname ____________________________ Name ____________________ | ||||||||||||||||||||||||||||
Formative control 11.3 B Term 3 | ||||||||||||||||||||||||||||||
Themes: MySQL SELECT | ||||||||||||||||||||||||||||||
Learning objectives: LO1 describe the features of appropriate data sets for specific problems LO2 justify conclusions drawn from data analysis | ||||||||||||||||||||||||||||||
Criteria: A, С | ||||||||||||||||||||||||||||||
1. Which commands is not used in Data Manipulation Language? a. SELECT b. UPDATE c. CREATE TABLE d. INSERT INTO 2. Find out the records of all people who are either men who earn more than 2000 or who are women. a. WHERE (Salary > 2000 and Gender="m") or (Salary > 2000 and Gender="f") b. WHERE (Salary > 2000 and Gender="m") or (Gender="f") c. WHERE (Salary > 2000 and Gender="f") or (Gender="m") d. WHERE (Salary > 2000 and (Gender="m" or Gender="f") 3. Look at the SQL code in this query which uses a parameter. What parameter would give the results in the table shown below? a. Emma b. Bristol c. Bris d. W 4. Answer the questions on the code. How many tables using query?______ Which fields connects them? ____________________ Which fields contains a criteria? ___________________________________ Which field contains a group operation? _______________________________ | ||||||||||||||||||||||||||||||
|
Subject: informatics | Grade:11 Group _____ | Surname ___________________________ Name _____________________________ Date ______________________________ | |
Formative control 11.4.3 Term 4 | |||
Themes: programming | |||
Learning objectives:
| |||
Criteria: B C A |
Learning objectives | Criteria | Description | Achieved | Working towards | Conclusion |
LO1 | A | understand pseudocode | |||
LO1 | B | able to modify the program code | |||
LO1 | C | analyzes algorithms cycle and branching |
Subject: informatics | Grade:11 Group _____ | Surname ___________________________ Name _____________________________ Date ______________________________ | |
Formative control 11.4.2 Term 4 | |||
Themes: | |||
Learning objectives:
| |||
Criteria: D |
1.
(a) What is an Expert System?
.............................................................................................................................................
.............................................................................................................................................
(b) Give one typical application of an expert system.
.............................................................................................................................................
(c) Give the three constituent parts of an expert system.
1..........................................................................................................................................
.............................................................................................................................................
2..........................................................................................................................................
.............................................................................................................................................
3..........................................................................................................................................
.............................................................................................................................................
(d) Users of expert systems claim that they are much more useful than a very large
database. Give two reasons to justify this claim.
1..........................................................................................................................................
.............................................................................................................................................
2..........................................................................................................................................
.............................................................................................................................................
2.
A large builders’ merchant uses the following system for its stock control.
_ The customer chooses the item required
_ The warehouse assistant looks up the Stock ID in a catalogue and checks the quantity
_ The warehouse assistant writes out a ticket with the Stock ID and quantity of the item
_ The customer takes this ticket to the cash desk to pay
_ The cash desk operator uses the Stock ID to look up the unit price from a price list to
Дата добавления: 2015-10-30; просмотров: 184 | Нарушение авторских прав
<== предыдущая страница | | | следующая страница ==> |
Task 2: Draw Boolean gate combinations | | | Technical Documentation |