ОШ_СОР_Сomputer Science__10 ЕМН_Eng

Methodological recommendations for Summative Assessment

on the subject «Computer science»

Grade 10

(natural-mathematical direction)

Nur-Sultan, 2019

Methodological recommendations for Summative Assessment are designed to assist teachers in planning, organizing and carrying out Summative Assessment in “Computer science” for the Grade 10 (Natural-mathematical direction) learners. Methodological recommendations are aligned with the Subject Programme and Course plan.

Summative Assessment Tasks for unit/cross-curricular unit will allow teachers to determine the level of the learning objectives achievement planned for the term. Methodological recommendations comprise tasks, assessment criteria with descriptors and marks for conducting Summative Assessment across the unit/cross curricular unit. Also this document includes possible levels of the learners’ academic achievement (rubrics). Tasks with descriptors and marks can be considered as recommendations.

Methodological recommendations are designed for secondary school teachers, school administrations, educational departments’ seniors, regional and school coordinators in criteria-based assessment and others.

Free access to the Internet resources such as pictures, cartoons, photos, texts, video and audio materials, etc. have been used in designing these Methodological recommendations.

CONTENTS

SUMMATIVE ASSESSMENT TASKS FOR TERM 14

Summative assessment for the unit «10.1A Computer networks and information security»4

Summative assessment for the unit «10.1B Presentation of Data»8

SUMMATIVE ASSESSMENT TASKS FOR TERM 212

Summative assessment for the unit «10.2А Algorithm Development and Programming»12

SUMMATIVE ASSESSMENT TASKS FOR TERM 316

Summative assessment for the unit «10.3А Web-development»16

SUMMATIVE ASSESSMENT TASKS FOR TERM 421

Summative assessment for the unit «10.4А Information Systems»21

SUMMATIVE ASSESSMENT TASKS FOR TERM 1

Summative assessment for the unit «10.1A Computer networks and information security»

Learning objectives	10.6.1.2 Explain the purpose and representation of IP address 10.6.1.3 Explain the purpose of DNS
Assessment criteria	A learner Define suitable IP address for different devices Define the network address of a given IP address using subnet mask Explain the purpose of DNS
Level of thinking skills	Knowledge and comprehension
Duration	20 minutes
Tasks 1. The diagram shows a Local Area Network consisting of two subnets. (i) Define IP addresses of devices A and F, if the network address of subnet L is 192.168.7.0 and the network address of subnet R is 192.168.8.0 A_____________________________________________________________________ F _____________________________________________________________________ (ii) Give a suitable IP address for the desktop PC labelled G. ___________________________________________________________________________ (iii) Calculate the number of different host addresses supported by subnet «L» and justify your answer. ___________________________________________________________________________ ___________________________________________________________________________ 2. Read the description and write appropriate term in the blank. Each computer or device connected to the Internet has an assigned address called ________________ This 32-bit numeric address uniquely identifies the physical computer connected to the Internet.

3. Define the IP addresses for the network nodes B and C.

IP address of the network node B ____________________________________________________

IP address of the network node C ____________________________________________________

4. Define the network address using the given IP address and subnet mask:

IP-address: 217.16.246.2

Subnet mask: 255.255.255.0

_______________________________________________________________________________

5. Describe the purpose of Domain Name Server.

________________________________________________________________________________

_______________________________________________________________________________

Assessment criteria

Task

Descriptor

A learner

Mark

Defines a suitable IP address for different device

1(i)

1(ii)

defines IP address of device A;

defines IP address of device F;

gives a suitable IP address for device G;

1(iii)

calculates possible number of devices;

gives an explanation for the answer;

Defines the network address of a given IP address using subnet mask

defines the term corresponding to the description;

defines IP address of the network node B;

defines IP address of the network node C;

defines the network address using IP and subnet mask;

Describes the purpose of DNS

explains the function of DNS.

Total marks

Rubrics for providing information to parents on the results of Summative Assessment for the unit «10.1A Computer networks and information security»

Learner’s name_______________________________________________________

Assessment criteria

Level of learning achievements

Low

Defines a suitable IP address for different device

Experiences challenges in defining the IP addresses of different devices

Makes mistakes in defining the IP addresses at ports B / D / G; defines number of possible host IDs for subnet L; justifies the answer.

Confidently defines IP addresses of different devices

Defines the network address of a given IP address using subnet mask

Experiences challenges in defining the network address

Makes mistakes in defining the term; in defining of IP address B/C; in defining IP address of the network node B / C; in defining the network address part of the IP address using subnet mask.

Confidently defines the network address

Describes the purpose of DNS and provides a proper example

Experiences challenges in describing the purpose of DNS

and providing the proper example

Makes mistakes in describing the purpose of DNS and providing the proper example

Confidently describe the purpose of DNS and provides the proper example

Summative assessment for the unit «10.1B Presentation of Data»

Learning objectives

10.2.1.1 Convert integers from decimal to binary, octal, hexadecimal and vice versa

10.2.2.2 Construct truth tables for a given logical expression

10.2.2.4 Convert logical expressions into logic circuits and vice versa;

10.2.3.1 Compare the Unicode and ASCII coding tables

Assessment criteria

A learner

Convert decimal numbers to different number systems
Construct truth tables for a given logical expression
Represent logical expressions in the form of logic circuits
Represent logical circuits in the form of logic expressions
Compare coding tables

Level of thinking skills

Application

Duration

30 minutes

Tasks

1. Write the binary, hexadecimal values that the unsigned decimal integer 834 represents. Write down the solution.

Binary _____________________________________________________________________

___________________________________________________________________________

Hexadecimal ________________________________________________________________

___________________________________________________________________________

2. Explain the use of hexadecimal numbers in computer systems

________________________________________________________________________________

3. Identify logical expression in column “C”:

A	B	C
0	0	1
0	1	0
1	0	1
1	1	1

C = ________________________________________________________________________

Given logical expression

(i) Fill truth tables

1	2	3	4	5
A	B	A.B
0	0
0	1
1	0
1	1

ii) Draw logical expression in the form of logic circuit.

5. Using the logic circuit complete the tasks below:

(i) Fill in the truth table.

A	B	C	D
0	0
0	1
1	0
1	1

(ii) Identify logical expression which will be an alternative to the previous circuit.

___________________________________________________________________________

6. Identify the suitable coding table which contains following symbols:

♫

Explain your answer.

________________________________________________________________________________

Assessment criteria

Task

Descriptor

A learner

Mark

Convert decimal numbers to different number systems

writes the binary value for decimal integer;

writes the hexadecimal value for decimal integer;

explains the need to use the hexadecimal number system;

Make truth tables for a given logical expression

writes a suitable logical expression;

4(i)

fills the 3^rd column of the table;

fills the 4^th column of the table;

fills the 5^th column of the table;

5(i)

fills the values in c;

fills the values in d;

Represent logical expressions in the form of logic circuits

4(ii)

represents 1^st logical operation;

represents 2^nd logical operation;

represents 3^rd logical operation;

Represent logical circuits in the form of logic expressions

5(ii)

represents 1^st logical circuit;

represents 2^nd logical circuit;

Compares the representation of information in ASCII and UNICODE tables

identifies the coding table;

explains the choice.

Total marks

Rubrics for providing information to parents on the results of Summative Assessment for the unit «10.1B Presentation of Data»

Learner’s name_______________________________________________________

Assessment criteria

Level of learning achievements

Low

Convert decimal numbers to different number systems

Experiences challenges in converting decimal numbers to different number systems

Makes mistakes in writing the binary value for denary integer number; in writing the hexadecimal value for denary integer number;

In explaining the purpose of the hexadecimal number system.

Confidently converts decimal numbers to different number systems

Construct truth tables for a given logical expression

Experiences challenges in constructing truth tables for a given logical expression

Makes mistakes in writing a suitable logical expression; in filling the 3^rd/ 4^th/ 5^th column of the table; in filling in the values for C / D

Confidently constructs truth tables for a given logical expression

Represent logical expressions in the form of logic circuits

Experiences challenges in representing logical expressions in the form of logic circuits

Makes mistakes in representing 1^st / 2^nd / 3^rd logical operation in the form of logic circuits

Confidently represent logical expressions in the form of logic circuits

Represent logical circuits in the form of logic expressions

Experiences challenges in representing logical circuits in the form of logic expressions

Makes mistakes in representing 1^st /

2^nd logical circuit in the form of logic expressions

Confidently represent logical circuits in the form of logic expressions

Compare coding tables

Experiences challenges in comparing coding tables

Makes mistakes in choosing the coding table; in justification chosen coding table

Confidently compares coding tables

SUMMATIVE ASSESSMENT TASKS FOR TERM 2

Summative assessment for the unit «10.2А Algorithm Development and Programming»

Learning objectives

10.5.1.1 Write code in a programming language using functions and procedures

10.5.1.2 Use procedures and functions for string processing

10.5.1.3 Use files to read and write information

10.5.1.4 Apply sorting algorithms to solve practical tasks

Assessment criteria

A learner

Write code in a programming language, using functions and procedures
Use procedures and functions for string processing
Use files to read and write information
Apply sorting algorithms to solve practical tasks

Level of thinking skills

Application

Duration

20 minutes

Tasks

1. Write the program code for given flowcharts.

2. Write one function and one procedure for string processing. Use programming language.

the function	the procedure

3. Write the functions to determine the length of the string and the first occurrence of the letter "a".

4. Write a fragment of the program code to read a string from the text file.

5. Write a fragment of the program code to record a string to the text file.

6. The list [6, 8, 2, 1, 1, 9, 4] is being sorted using insertion sort. Fill in the blanks to show the list after each pass.

After the 1^st pass:[6, 8, 2, 1, 1, 9, 4]

After the 2^nd pass:[6, 8, 2, 1, 1, 9, 4]

After the 3^rd pass:[2, 6, 8, 1, 1, 9, 4]

After the 4^th pass: ____________________________________________________________

After the5^th pass: ____________________________________________________________

After the 6^th pass: ____________________________________________________________

Assessment criteria

Task

Descriptor

A learner

Mark

Write code in a programming language, using functions and procedures

writes a condition for the branching algorithm;

specifies the steps in the branching algorithm;

uses a function in the program;

Use procedures and functions for string processing

writes string processing function;

writes string processing procedure;

writes the function to determine the length of the string;

writes the function to determine the first occurrence of the letter "a";

Use files to read and write information

opens the file to read the string;

read the string from the file;

opens the file to write the string;

writes the string to the file;

Apply sorting algorithms to solve practical tasks

fills in the blanks to show the list after 4^th pass;

fills in the blanks to show the list after 5^th pass;

fills in the blanks to show the list after 6^th pass.

Total marks

Rubrics for providing information to parents on the results of Summative Assessment for the unit «10.2А Algorithm Development and Programming»

Learner’s name_______________________________________________________

Assessment criteria

Level of learning achievements

Low

Write code in a programming language, using functions and procedures

Experiences challenges in writing code in a programming language, using functions and procedures

Makes mistakes in writing a condition for the branching algorithm; in specifying the steps in the branching algorithm; in using a function in the program

Confidently writes code in a programming language, using functions and procedures

Use procedures and functions for string processing

Experiences challenges in using procedures and functions for string processing

Makes mistakes in writing a function for working with strings;

in writing a procedure for working with strings; in writing the function to determine the length of the string; writing the function to determine the first occurrence of the letter "a"

Confidently uses procedures and functions for string processing

Use files to read and record information

Experiences challenges in using files to read and record information

Makes mistakes in opening the file to read the string; in reading the string from the file; in opening the file to write the string

Confidently use files to read and record information

Apply sorting algorithms to solve applied problems

Experiences challenges in applying sorting algorithms to solve applied problems

Makes mistakes in applying sorting algorithms to solve problems while filling in the blanks to show the list after 4^th / 5^th/6^th pass

Confidently apply sorting algorithms to solve applied problems

SUMMATIVE ASSESSMENT TASKS FOR TERM 3

Summative assessment for the unit «10.3А Web-development»

Learning objectives

10.4.2.1 Use HTML in web-development

10.4.2.2 Use CSS in web-development

10.4.2.4 Use HTML tags to add multimedia objects into a webpage

Assessment criteria

A learner

Use HTML in web-development
Use CSS in web-development
Use HTML tags to add multimedia into a webpage

Level of thinking skills

Application

Duration

20 minutes

Tasks

1. Write HTML code for the following web-side:

2. Write CSS code to create a yellow background and green text in the web-side.

3. Match results(1-3) with appropriate HTML/CSS code (A-C).

<ul style="list-style-type:disc;"> <li>Coffee</li> <li>Tea</li> <li>Milk</li></ul>

<li>Coffee</li>

</ul>

<li>Coffee</li>

</ul>

____________________________________________________________________________

[1]

4. Draw the result of the following HTML/CSS code:

<style>

table, th, td {

border: 1px solid black;

padding: 5px;

}

table {

border-spacing: 15px;

}

</style>

<tr>

<th>Firstname</th>

<th>Lastname</th>

</tr>

<tr>

<td>Smith</td>

</tr>

<tr>

<td>Jackson</td>

</tr>

<tr>

</tr>

</table>

5. Write HTML tags to add 500x500px image.

_____________________________________________________________________________

6. Write HTML tag to add the video with the control panel.

_____________________________________________________________________________

Assessment criteria

Task

Descriptor

A learner

Mark

Use HTML in web-development

uses tag for the formatting of the 1^st line;

uses tag for the formatting of the 2^nd line;

uses tag for the formatting of the 3^rd line;

writes css to create yellow background;

writes html tag to create a paragraph;

writes css to create a green text;

Use CSS in web-development

matches 1-3 with a-c;

draws a table;

uses css for the borders of the table;

Use HTML tags to add multimedia into a webpage

writes html tag to add image;

writes html tag to add video;

uses an attribute for control panel;

uses an attribute for showing the path of file.

Total marks

Rubrics for providing information to parents on the results of Summative Assessment for the unit «10.3А Web-development»

Learner’s name_______________________________________________________

Assessment criteria

Level of learning achievements

Low

Use HTML in web-development

Experiences challenges in using HTML in web-development

Makes mistakes in using tag for the formatting of the 1^st /2^nd/3^rd line; in writing HTML tag to create yellow background / paragraph / green text

Confidently use HTML in web-development

Use CSS in web-development

Experiences challenges in using CSS in web-development

Makes mistakes in using CSS in web-development while matching HTML/CSS with resulting list styles; drawing a table; using CSS for the borders of the table

Confidently use CSS in web-development

Use HTML tags to insert multimedia into a webpage

Experiences challenges in using HTML tags to insert multimedia into a webpage

Makes mistakes in writing HTML tag to add image; in adding video; in using an attribute for control panel or for showing the path of video file

Confidently use HTML tags to insert multimedia into a webpage

SUMMATIVE ASSESSMENT TASKS FOR TERM 4

Summative assessment for the unit «10.4А Information Systems»

Learning objectives

10.3.1.4 Evaluate the pros and cons of using «Bigdata»

10.3.1.3 Identify the primary key in a database

10.3.2.1 Define the types of data in an SQL database

10.3.3.1 Use SQL queries to define and manipulate data

10.3.3.2 Connect a webpage with database

Assessment criteria

A learner

Evaluate the pros and cons of using «Bigdata»
Identifies the primary key in a database
Defines the types of data in an SQL database
Use SQL queries to manipulate data
Connects a webpage with database

Level of thinking skills

Application

Duration

20 minutes

Tasks

1. Give one advantage and one disadvantage of using «Bigdata».

________________________________________________________________________________

2(i). Provide appropriate data types and field sizes for the table structure below.

Field Name	Data Type	Field Size (in bytes)
BikeID
BikeType
BikeModel
SoldDate
NeedsRepair

(ii). Complete the SQL query to show the repaired bikes:

SELECT _______________________________________________________________

FROM ________________________________________________________________

WHERE _______________________________________________________________

3. Using the attributes below complete the SQL query to change all lightweight planes from “not rented” state to “rented”:

planeID
planeModel
planeType
planeRentDate
planeRented

UPDATE ______________________________________________________________

SET __________________________________________________________________

WHERE _______________________________________________________________

4. Data of motocar is stored in the table. The table stores the following data:

car registration number
car model
car type
car rent date
rented or not

Identify the primary key in a database. Explain your answer. _______________________________

________________________________________________________________________________

5. There are four essential parameters to create connection between webpage and database.

Connect(“_________”, “Username”, “Password”, “DatabaseName”)

Name the missing parameter and explain its function

________________________________________________________________________________

Assessment criteria

Task

Descriptor

A learner

Mark

Evaluate the pros and cons of using «Bigdata»

give one advantage of using «Bigdata»;

give one disadvantage of using «Bigdata»;

Define the types of data in an SQL database

2(i)

fills column Data Type;

fills column Field Size;

use SQL queries to manipulate data

2(ii)

fills in the SELECT field;

fills in the FROM field;

fills in the WHERE field;

fills in the UPDATE field;

fills in the SET field;

fills in the WHERE field;

Identify the primary key in a database

defines the primary key in a database;

explains the answer;

Connect a webpage with database

gives name of the missing parameter;

explains function of the missing parameter.

Total marks

Rubrics for providing information to parents on the results of

Summative Assessment for the unit «10.4А Information Systems»

Learner’s name_______________________________________________________

Assessment criteria

Level of learning achievements

Low

Evaluates the pros and cons of using «Bigdata»

Struggles in evaluating the pros and cons of using «Bigdata»

Makes mistakes in giving one advantage/disadvantage of using «Bigdata»

Confidently evaluates the pros and cons of using «Bigdata»

Defines the types of data in an SQL database

Experiences challenges in defining the types of data in an SQL database

Makes mistakes in defining the types of data/field size in an SQL database

Confidently defines the types of data in an SQL database

Identifies the primary key in a database

Experiences challenges in identifying the primary key in a database

Makes mistakes in identifying the primary key in a database; in justification of choice for primary key

Confidently identifies the primary key in a database

uses SQL queries to manipulate data

Experiences challenges in creating select queries, using extracted SQL data

Makes mistakes in creating queries while filling in the SELECT/FROM/WHERE/UPDATE/

SET field

Confidently uses SQL queries to manipulate data

connects a webpage with database

Experiences challenges in connecting a webpage with database

Makes mistakes in connecting a webpage with database while giving name of the missing parameter;

explaining function of the missing parameter

Confidently connects a webpage with database

Толық нұсқасын 30 секундтан кейін жүктей аласыз!!!

Әлеуметтік желілерде бөлісіңіз:
Facebook | VK | WhatsApp | Telegram | Twitter

Қарап көріңіз 👇

kz | Жиынтық бағалау (ТЖБ, БЖБ) (СОЧ, СОР)

24.04.2022

Автор: zhararalikhan
33

Пайдалы сілтемелер:
» Туған күнге 99 тілектер жинағы: өз сөзімен, қысқаша, қарапайым туған күнге тілек
» Абай Құнанбаев барлық өлеңдер жинағын жүктеу, оқу
» Дастархан батасы: дастарханға бата беру, ас қайыру

Соңғы жаңалықтар:
» 2025 жылы Ораза және Рамазан айы қай күні басталады?
» Утиль алым мөлшерлемесі өзгермейтін болды
» Жоғары оқу орындарына құжат қабылдау қашан басталады?