Assessment Standards – Computer Science

 

KS3 Computer Science – Year 7 Unit 1 – Using Computers Effectively, Safely and Responsibly

KS3 Bands

Key knowledge

Key Skills

Excellence

All of the below bands and:

Students consistently keeps files and folders organised. They recognise key uses of the internet and  consistently apply measures to stay safe online

Able to rename file and folders using sensible naming conventions.

Create strong passwords and understand the importance in this

Recognises what is and isn’t cyberbullying and the process of reporting it

Applies consistently good email etiquette when communicating online

 

Secure

All of the below bands and:

Students are somewhat consistent when applying good practice when using a computer. They can use the internet effectively to find information and know how to stay safe online.

Generally has good housekeeping when saving files and folders

Can suggest good password creating rules

Recognises examples of cyberbullying

Uses good email etiquette in most communications

Developing

All of the below band and:

Students sometime apply good housekeeping to their work. They can use the internet safely and effectively at times

Saves files in correct folders, however this may be inconsistent

Recalls some conventions for a strong password

Identifies what cyberbullying is

Able to send emails with a subject line and appropriate message and attachments

Foundation

Students can recognise good practice when using a computer such as file organisation and using the web safely and effectively

Stores files with some correct names

Understands why a strong password is important

Can define cyberbullying

Able to use emails with a subject line and appropriate message

 

 

KS3 Computer Science – Year 7 Unit 2 – Spreadsheet Modelling

KS3 Bands

Key knowledge

Key Skills

Excellence

All of the below bands and:

Student can apply knowledge of features in a wide range of scenarios, producing a spreadsheet which uses advanced features of the software. Student is comfortable explaining why different tools are used within spreadsheets.

Student:

can state some advantages of using a computer model and explain why it may not give accurate results

has used conditional functions IF and COUNTIF in a spreadsheet to enhance their model

used a spreadsheet model to find and suggest a solution to a problem

has used validation to ensure data is entered correctly

can explain why a particular chart type is suitable for a given situation

can explain what a macro is and why it might be useful in a spreadsheet model

Secure

All of the below bands and:

Student can model different scenarios within a spreadsheet and use advanced spreadsheet features to improve output and efficiency of use.

Student

has used both relative and absolute references in a spreadsheet and can explain the difference

has used a spreadsheet model to explore “what if” scenarios

has used conditional formatting to change the format of cells depending on their value

has selected a suitable chart type and customised it

has recorded a macro to perform a useful task in their model and attached it to a button

Developing

All of the below band and:

Student can develop a spreadsheet to include functions and formulae and can display complex data in an easy to understand manner.

I have entered numbers, text, formulae and functions such as SUM, MAX, MIN in a spreadsheet

I have created a simple chart

I can display the formulae in my spreadsheet

I can state some possible applications of a spreadsheet model

Foundation


Student can identify the uses of a spreadsheet and can produce a simple spreadsheet with basic formatting

Student:

can state examples of different types of computer model

has developed a simple financial model using a spreadsheet

has formatted text and numbers to improve the appearance of their spreadsheet

 

KS3 Computer Science – Year 7 Unit 3 – Computer Crime and Security

KS3 Bands

Key knowledge

 

Excellence

All of the below bands and:

·           Respond effectively and appropriately to emails

·           Describe the effects on individuals and companies of illegally downloading copyright material, e.g. music, images and movies

 

Secure

All of the below bands and:

 

·           Briefly describe the content of the major Acts concerning computer use

·           Find out what data is held about them by companies such as Google

·           Recognise fraudulent emails and protect themselves effectively from unwittingly giving personal information (e.g. account numbers and passwords) or otherwise being defrauded

·           Protect their online identity using Privacy settings and by not uploading personal details

·           Use computers sensibly and safely with regard to physical hazards such as backache, eyestrain, RSI etc.

 

Developing

All of the below band and:

 

·           Name the major Acts concerning computer use

·           Identify some of the signs of fraudulent emails and respond appropriately

·           Adhere to Copyright Law when using written text, downloading music etc.

·           List some of the Health and Safety hazards associated with computer use

·           Describe how to safely dispose of an old computer

 

Foundation

·           Describe briefly some of the dangers of putting personal data on social networking sites

·           Describe briefly ways of protecting online identity and how to report concerns

·           Adhere to Copyright Law when using written text, downloading music etc.

 

 

 

KS3 Computer Science – Year 7 Unit 4- Understanding Computers

KS3 Bands

Key knowledge

 

Excellence

All of the below bands and:

·       Identify input and output devices for more complex scenarios

·       Explain how characters are encoded using the ASCII system

·       Use an ASCII reference chart to convert a character into binary and its decimal equivalent

 

Secure

All of the below bands and:

·       Perform simple binary arithmetic

·       State strengths and weaknesses of different storage devices

·       Describe briefly how data is stored on a CD

 

Developing

All of the below band and:

·           Draw a block diagram showing CPU, input, output and storage devices

·           Name different types of permanent storage device

·           Explain what RAM and ROM are used for

·           Show how numbers and text can be represented in binary

·           Explain the impact of future technologies

 

Foundation

·           Distinguish between hardware and software

·           Give examples of computer hardware and software

·           Suggest appropriate input and output devices for a simple scenario

 

 

 

KS3 Computer Science – Year 7 Unit 5– Games Programming in Scratch

KS3 Bands

Key knowledge

 

Key Skills

Excellence

All of the below bands and:

 

Student has implemented a list within a game. Student has created a range of event handlers to create a complex game. Student has systematically tested their game to make sure it is free from errors. Student has created a sprite that can move whilst shooting.

 

Lists

Event-handling

Testing

 

Secure

All of the below bands and:

 

Student has included code to make a sprite jump. Student has designed, implemented and refined their own algorithms. Student has used randomisation to make sprites move randomly. Student can find and debug errors in a program. Student can make improvements to their project based peer feedback. Student has created a simple shooting game.

 

Flowcharts

Debugging

 

Developing

All of the below band and:

 

Student has created a range of sprites which can be controlled in different ways. Student understands what pseudocode is and has written pseudocode to outline steps in an algorithm prior to coding. Student has effectively used the broadcast function within a game. There is evidence of good use of operators. Student has added sound to a game to increase playability. Student has included scores and lives within their game.

Computer controls (AI)

Pseudocode

Outputs

Operators

Foundation

Student can give a sprite basic movement controls. Student is able to follow or understand a simple algorithm. Student has demonstrated the use of an IF statement within their program. Student understands what a variable is and has used variables within a program. Student understands the importance of using comments in their code and has used them where possible. Student has created an error-free game, although this has been with some teacher intervention.

User controls

Movement

Variables

Selection

Comments

 

 

Assessment Standards – Computer Science Y8

 

KS3 Computer Science – Year 8 Unit 1 – Introduction to Graphics

KS3 Bands

Key Skills

Excellence

All of the below bands and:

·          I have used the advanced features of a graphics package, for example to manipulate or alter images

·          I have created a series of two or more posters in the same style, using layered images and fonts effectively to convey a message

Secure

All of the below bands and:

·          I have used layers in the creation of my poster

·          I have used cut-out tools to remove part of an image

·          I have used white space effectively

·          I have gathered feedback from others and used this to make improvements to my final poster

Developing

All of the below band and:

·          I have changed the saturation, brightness and/or contrast of an image to improve my poster

·          I have used multiple objects in the logo and grouped, edited and resized them

·          I have selected relevant images with a suitable resolution

·          I have selected fonts and styles with care to get a message across

·          I have given useful feedback/assistance to another pupil to help them improve their poster

Foundation

·          I have used a graphics package to create a movie poster

·          I have created a logo for a movie company and included it on my movie poster

·          I have selected multiple images to use in the creation of my poster

·          I have used text on my poster

·          I have saved my final poster in an exportable format (e.g. .jpg or .pdf)

 

 

 

KS3 Computer Science – Year 8 Unit 2 – Computer Networks

KS3 Bands

Key knowledge

 

Excellence

All of the below bands and:

·       Design a network layout for their school, using icons to represent server, hub, switch, router, Internet, workstation, printer

·       Describe the concept of cloud computing and some of the benefits it brings to individuals and organisations

 

Secure

All of the below bands and:

·       Explain the meaning and significance of bandwidth

·       State the advantages and disadvantages of different network topologies

·       Design a simple network layout

·       Compare the uses of peer-to-peer networks and client-server networks

 

Developing

All of the below band and:

·       Explain the basic principle of packet switching

·       Describe what is meant by a client-server network and state some of its advantages

·       Explain what is meant by buffering and why it is used

·       Identify some of the extra hardware components used in a LAN

Foundation

·       State that the Internet is a wide area network and the world wide web is part of the Internet

·       Define the meaning of the terms “domain name”, http protocol

·       Give examples of LANs and WANs

·       State three different network topologies

·       State why some transmissions are encrypted, and use a simple algorithm to encrypt and decrypt a message

 

 

KS3 Computer Science – Year 8 Unit 3 – Database Development

KS3 Bands

Key knowledge and skills

 

Excellence

All of the below bands and:

·          I have added grouping levels and subtotals and/or a grand total to at least one column

·          I have added some simple Visual Basic commands to customise the database

 

Secure

All of the below bands and:

·          I have created two correctly structured and related tables which each hold data about a single entity and which are relevant to my chosen application

·          I have created a fully customised form from two tables and customised the form’s design

·         I have added a calculated field to a query

Developing

All of the below band and:

·          I have used at least three different data types and added at least two validations and tested them by attempting to add invalid data

·          I have created complex queries using criteria on multiple fields, including parameters entered by the user

·          I have created an input form and done some customisation to make the form more user friendly

·          I have fully customised the report with a suitable heading, column widths etc. to fit neatly across a page

Foundation

·          I have designed, created and edited a database table structure to hold data about a single entity and added at least 5 records to the table in datasheet view

·          I have created queries and sorted the query data on one field

·          I  have created a basic input form from a single table or query

·          I have created a basic report from a single table or query

 

 

 

KS3 Computer Science – Year 8 Unit 4- HTML and Web Development

KS3 Bands

Key knowledge and Skills

 

Excellence

All of the below bands and:

·          I have used CSS to control the appearance of DIV sections of HTML

·          I have added a footer section to a web page

Secure

All of the below bands and:

·          I have added DIV tags in order to separate areas of a web page

·          I have added links to external web pages and tested them

Developing

All of the below band and:

·          I have written basic HTML to create a web page of my own

·          I have used basic CSS to control the appearance of my own web page

·          I have changed the width setting to percentages in order to make the page responsive

·          I have created links to my other web pages and tested that they work
I have added a web form to my own web page


Foundation

·          I have edited basic HTML to change the content of a web page

·          I can change basic CSS to alter the appearance of a web page

·          I have specified a width for my web page and images

·          I have created more than one web page

·          I have used the example web form to submit data to a simulated database

 

KS3 Computer Science – Year 8 Unit 5– Introduction to Python

KS3 Bands

Key knowledge and skills

Excellence

All of the below bands and:

·          I have written a binary search program

·          I have included code in my programs to help prevent user input error

·          I have successfully tested and de-bugged a logic error

Secure

All of the below bands and:

·          I have written an error free program involving a while loop without help

·          I can describe how a binary search is carried out

·          I can explain the advantages of a binary search over a linear search

·          I can explain the difference between syntax errors, run-time errors and logic errors

Developing

All of the below band and:

·          I  can distinguish between syntax and logic errors

·          I have used mathematical and Boolean operators such as AND, OR and NOT

·          I have used an Elif statement in a working program

·          I have written an error free program involving a while loop with help

·          I can write pseudocode to outline the steps in an algorithm prior to coding

Foundation

·          I have used Interactive and Script modes to successfully run a program I have written

·          I have written programs using variables of different data types (e.g. string and integer)
I  can find and de-bug syntax errors

·          I have used an If statement in a working program

·          I use comments to document a program