👈 қаріп өлшемі 👉

ОШ_СОР_С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

1

1

1(iii)

calculates possible number of devices;

gives an explanation for the answer;

1

1

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

2

defines the term corresponding to the description;

1

3

4

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;

1

1

1

Describes the purpose of DNS

5

explains the function of DNS.

1

Total marks

10

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

1

2

writes the binary value for decimal integer;

writes the hexadecimal value for decimal integer;

explains the need to use the hexadecimal number system;

1

1

1

Make truth tables for a given logical expression

3

writes a suitable logical expression;

1

4(i)

fills the 3rd column of the table;

fills the 4th column of the table;

fills the 5th column of the table;

1

1

1

5(i)

fills the values in c;

fills the values in d;

1

1

Represent logical expressions in the form of logic circuits

4(ii)

represents 1st logical operation;

represents 2nd logical operation;

represents 3rd logical operation;

1

1

1

Represent logical circuits in the form of logic expressions

5(ii)

represents 1st logical circuit;

represents 2nd logical circuit;

1

1

Compares the representation of information in ASCII and UNICODE tables

6

identifies the coding table;

explains the choice.

1

1

Total marks

15

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 3rd / 4th / 5th 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 1st / 2nd / 3rd 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 1st /

2nd 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 1st pass:[6, 8, 2, 1, 1, 9, 4]

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

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

After the 4th pass: ____________________________________________________________

After the5th pass: ____________________________________________________________

After the 6th pass: ____________________________________________________________

Assessment criteria

Task

Descriptor

A learner

Mark

Write code in a programming language, using functions and procedures

1

writes a condition for the branching algorithm;

specifies the steps in the branching algorithm;

uses a function in the program;

1

1

1

Use procedures and functions for string processing

2

writes string processing function;

writes string processing procedure;

1

1

3

writes the function to determine the length of the string;

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

1

1

Use files to read and write information

4

opens the file to read the string;

read the string from the file;

1

1

5

opens the file to write the string;

writes the string to the file;

1

1

Apply sorting algorithms to solve practical tasks

6

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

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

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

1

1

1

Total marks

14

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 4th / 5th /6th 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).

1

A

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

2

B

<ul style="list-style-type:square;">

<li>Coffee</li>

<li>Tea</li>

<li>Milk</li>

</ul>

3

C

<ul style="list-style-type:circle;">

<li>Coffee</li>

<li>Tea</li>

<li>Milk</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>

<table style="width:100%">

<tr>

<th>Firstname</th>

<th>Lastname</th>

<th>Age</th>

</tr>

<tr>

<td>Jill</td>

<td>Smith</td>

<td>50</td>

</tr>

<tr>

<td>Eve</td>

<td>Jackson</td>

<td>94</td>

</tr>

<tr>

<td>John</td>

<td>Doe</td>

<td>80</td>

</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

1

uses tag for the formatting of the 1st line;

uses tag for the formatting of the 2nd line;

uses tag for the formatting of the 3rd line;

1

1

1

2

writes css to create yellow background;

writes html tag to create a paragraph;

writes css to create a green text;

1

1

1

Use CSS in web-development

3

matches 1-3 with a-c;

1

4

draws a table;

uses css for the borders of the table;

1

1

Use HTML tags to add multimedia into a webpage

5

writes html tag to add image;

1

6

writes html tag to add video;

uses an attribute for control panel;

uses an attribute for showing the path of file.

1

1

1

Total marks

13

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 1st /2nd /3rd 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»

1

give one advantage of using «Bigdata»;

give one disadvantage of using «Bigdata»;

1

1

Define the types of data in an SQL database

2(i)

fills column Data Type;

fills column Field Size;

1

1

use SQL queries to manipulate data

2(ii)

fills in the SELECT field;

fills in the FROM field;

fills in the WHERE field;

1

1

1

3

fills in the UPDATE field;

fills in the SET field;

fills in the WHERE field;

1

1

1

Identify the primary key in a database

4

defines the primary key in a database;

explains the answer;

1

1

Connect a webpage with database

5

gives name of the missing parameter;

explains function of the missing parameter.

1

1

Total marks

14

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 секундтан кейін жүктей аласыз!!!


Кейінірек оқу үшін сақтап қойыңыз:


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



Жаңалықтар:
» NIS-тің мың домбырашысы Гиннесс рекордтар кітабын бағындырды 26.05.2022
» Президенттің баспасөз қызметі Тоқаевтың 30 жыл бұрынғы суреттерін көрсетті (фото) 22.05.2022
» Қазақстандағы жеңілдетілген автокөлік несиелері: Автосалондар қосымша қызмет алуға мәжбүрлейді 20.05.2022

Пікір жазу



Келесі мақала, жүктелуде...
Біз cookie файлдарын пайдаланамыз!
Біздің сайтты пайдалануды жалғастыра отырып, сіз сайттың дұрыс жұмыс істеуін қамтамасыз ететін cookie файлдарын өңдеуге келісім бересіз. Cookie файл деген не?
Жақсы