KS3 ICT UNIT ASSESSMENT

AND EXAMPLES OF STUDENT WORK

 

7.1 | 7.2 | 7.3 | 7.4 | 7.5 | 7.6

8.1 | 8.2 | 8.3 | 8.4 | 8.5

9.1 | 9.2 | 9.3

 

 

é Unit 7.1: Using ICT

Level 3

Level 4

Level 5

I have created a presentation with one slide

I have created a presentation with more than one slide

I have planned what slides I needed for my presentation and created more than one of them

I have added some text to a slide

I have added appropriate text to my slide

I have added appropriate text to my slides and explained why I needed it

I have added an image to my slide

I have added appropriate images to a slide

I have added appropriate images to my slides and explained why have used them

I have used colour on my slide

I have used appropriate colours on my slide

I have used appropriate colours in my slides and explained why have used them

I have used sound on my slide

I have used appropriate sounds on some of my slides

I have used appropriate sounds on some of my slides and explained why have chosen them

I have made some changes to my presentation to make it better

I have evaluated my presentation to make sure it was suitable for other Y7 pupils

I have changed the style and content of my presentation and evaluated it to make sure it was suitable for a different audience (adults or children at link school)

Title

Level

Reason

713mpca.ppt

3.0

Text and background.  More than 3 slides.  Slide transition. No images or animation. No text or box colour.

7134fpca.ppt

3.4

Some appropriate images.  Use of box colour.  Consistent animations

7137mpca.ppt

3.7

Background.  Some consistent use of text colour, but title colour doesn’t stand out.  Some animation but not consistent.

714mpca.ppt

4.0

More info than L3.  Consistent background, text and animations.  Appropriate images. Needs more proof reading.  2 slides incomplete.

7144fpca.ppt

4.4

Good info.  Phrases too long on some slides.  Lots of appropriate images.  Clear, consistent colour design.  Inconsistent use of animation.  Some evidence of phrases for foreign audience, but English phrases hard to understand by foreign children.

7147fpca.ppt

4.7

Consistent background, titles, colour scheme, animations.  Lots of appropriate images to enhance presentation.  Excellent phrases in French for foreign audience and images help explain English.  Some animations very slow and don’t enhance presentation. No automatic animations.  Good evaluation of how presentation adapted for different audience.

715masa.ppt

5

Well planned with storyboard.  Consistent design.  Clever use of group animation for images.  Images help to explain text.  Clever use of lines to create cross to indicate the food he doesn’t like to eat. Excellent French phrases for foreign audience.  Detailed evaluation explaining how adapted presentation for foreign audience and ways presentation could be improved further.

715fasa.ppt

5

Well planned with storyboard.  Consistent, clear design.  Good choice of animations to enhance presentation and use of group animations.  Use of arrow to point to an image.  Excellent French phrases and keyword slide to help foreign audience.  Detailed evaluation explaining how adapted presentation for foreign audience and ways presentation could be improved further.

 

é Unit 7.2: Using Data and Information Sources

Level 3

Level 4

Level 5

I can describe some of the different forms information can come in

I can identify the purpose of information for a task

I can use AND/OR/NOT to refine an internet search

I can navigate around a website to find the information I need

I can phrase questions for a questionnaire to make sure the information collected is relevant to a task

I know how to decide if information on a website is accurate and reliable

 

I can identify the information relevant to a task

 

 

I can use a search engine to find information relevant to a task

 

 

I can interpret information and evaluate its effectiveness using given criteria

 

 

I can explain why the source of any information I use should be acknowledged

 

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 7.3: Making a Leaflet

Level 3

Level 4

Level 5

I have created a subject leaflet

I have planned and created a subject leaflet for Year 6 pupils

I have planned and created subject leaflets for Year 6 pupils and parents

I have added text to my leaflet

I have added appropriate text to my leaflet

I have added appropriate text to my leaflet and gave reasons for my choices

I have added an image to my leaflet

I have added appropriate images to my leaflet

I have added appropriate images to my leaflet and gave reasons for my choices

I have used colour on my leaflet

I have used appropriate colours on my leaflet

I have added appropriate colours on my leaflet s and gave reasons for my choices

 

I have explained the steps I worked through to create my leaflet and suggested how it could be improved

I have described the steps I worked through to create my leaflets and gave reasons for the changes I made for parents

 

I have evaluated my leaflet to make sure it is suitable for Year 6 pupils

I have changed my leaflet and evaluated it to make sure it was suitable for parents

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 7.4: Introduction to Modelling and Presenting Numerical Data

Level 3

Level 4

Level 5

I have entered numbers and text in cells on a spreadsheet model

I have entered numbers and text in cells on a spreadsheet model and used formatting to improve the way they look

I used a model to draw and explain conclusions (e.g. the highest income will be made when)

I can identify the rules in a model

I can identify the rules in a model and explain what they do

I added new variables to a spreadsheet model to make it more realistic

I have entered a formula for a rule on a spreadsheet model with help from my teacher

I have entered a formula for a rule on a spreadsheet model and checked it works without help from the teacher

I have critically evaluated my model and report and suggested possible improvements to the model

I used a spreadsheet model to answer some questions

I have made predictions and changed the values of variables in a spreadsheet model to check them

 

I have created a report to explain what I found out when I used a model

I have created a report that includes a table of data and a suitable chart to explain what I found when out when using the model

 

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 7.5: Data Handling

Level 3

Level 4

Level 5

I have designed and used a questionnaire to collect data to test a hypothesis

I have designed and used a questionnaire to collect relevant data to test a hypothesis

I have designed and created a suitable database file to store and process the data I have collected

I have searched through and sorted data to find answers to questions

I can explain why it is important to check data is accurate

I have made sure that the data in my database is accurate by checking for errors

 

I have used AND/OR searches on data to find answers to questions

 

I have created graphs to test my hypothesis

I have created appropriate graphs to test my hypothesis

I have created appropriate graphs to test my hypothesis and explained why I have chosen them

I have presented my conclusions

I have presented and explained my conclusions

I have presented and explained my conclusions by selecting relevant information to support them

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 7.6: Control and Monitoring

Level 3

Level 4

Level 5

I can describe how computers are used to control things in everyday life

I have planned and created a flowchart to control a simulated situation

I have used decisions to control loops in a flowchart

I have created a flowchart to control a simple sequence of events

I have investigated the effect of changing input values in a flowchart to control a simulated situation

I have changed my flowchart to make it work more efficiently (e.g. turn off more than one output at a time-subroutines)

 

I have tested a flowchart to make sure it controlled a simulated situation

I understand how sensors are used to monitor events and record data

 

I understand that sensors can be used to monitor events and record data

 

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 8.1: Public Information Systems

Level 4

Level 5

Level 6

I can copy data from a table on a website

I can create a web query to automate the collection of live data from a website

I have improved my system to make it suitable for inexperienced user (e.g. drop down menus to choose a town)

I can explain what the data on a website means and choose the relevant data for a task

I can modify a web query to respond to input from a user (e.g. entering the name of a town)

 

I have presented data in a form suitable for the intended audience (e.g. by choosing suitable graphs)

I have explained how my system presents data in a format that is suitable for the intended audience

 

Title

Level

Reason

814masa.xls

4

Copied data from website (not web query).  Paste special to process sheet.  Relevent data selected.  Appropriate chart on Output sheet.  Basic explanation of what the data means.

8144masa.xls

4.4

Web Query.  Chart made clearer with data table.  Needs explanation of how to change the web query.

8147fasa.xls

4.7

Good use of paste special for title on output sheet.  Good explanation of how to amend web query

815mpca.xls

5

Chart titles made clearer.  Good explanation of why use web query and paste special.  Good suggestion on how to make the system more efficient.  Needs to show evidence of refining the system to make it more efficient.

 

é Unit 8.2: Publishing on the Web

Level 4

Level 5

Level 6

I have planned and created pages for a website

I have planned and created web pages suitable for a range of audiences

I have integrated applications on my web page (e.g. included a response form to collect information from users)

I have added appropriate text and images to my web images

I have added appropriate text and images to my web pages and gave reasons for my choices

I have used automated features on my web pages (e.g. rollovers)

I have planned and created hyperlinks to navigate through my web pages

I have evaluated my web pages to make sure they were suitable for a range of audiences

I have used feedback from users to suggest improvements to my web pages

I can describe the steps I worked through to create my web pages and suggest how they could be improved

 

 

I have evaluated my web pages to make sure they were suitable for a wide audience

 

 

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 8.3: Reliability, Validity and Bias

Level 4

Level 5

Level 6

I can identify the purpose of an information source and explain the difference between fact and opinion

I have evaluated the information on a website and explained why it might be biased

I know how to decide if the information on a website is accurate and reliable

I know how to decide if a website is likely to be biased

I have found, used and justified a number of sources of information for a task

 

I have used a search engine to find information which is relevant to a task

I have used synonyms and AND/OR/NOT to refine an internet search

 

I can explain why the source of information I used should be acknowledged

 

 

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 8.4: Models and Presenting Numeric Data

Level 4

Level 5

Level 6

I can identify the rules in a model and explain what they do

I have added new variables to a spreadsheet model to make it more realistic

I have improved the way a spreadsheet model works by changing the formula for at least one of the rules

I have entered numbers and text in cells on a spreadsheet model and used formatting to improve the way they look

I have used a spreadsheet model to draw and explain conclusions (e.g. the best value for money is obtained when)

I have worked out how a spreadsheet model might be improved by changing the variables and rules to make it more realistic

I have entered a formula for a rule on a spreadsheet model and checked it works without help from a teacher

 

I have checked how well a spreadsheet model works by comparing it with information from other sources

I have made predictions and changed the values of variables in a spreadsheet model to check them

 

 

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 8.5: ICT System

Level 4

Level 5

Level 6

I am able to describe the rules that govern the financial model

I used the financial model in order to make conclusions about the costs, break even points and possible profits

I independently created, reviewed and modified the financial model in order to investigate production costs. I then added new variables to extend the investigations

I have created and edited a financial model in order to investigate production costs

I understand how computers can used sensors to monitor the physical environment

I independently designed and then tested a control system to monitor and control conditions in the greenhouse

I understand that computers can be used as a way of monitoring the physical environment

I have designed, tested and altered a control system to monitor and control conditions in the greenhouse

I used sub-routines to make the system more efficient

I have written a sequence of a instructions to monitor and control the conditions in the greenhouse

I have created a report that investigated the feasibility of the project and suggested where improvements could be made

When creating the publicity material I used automated techniques (such as mail merge or an online form)

I have planned and created publicity material, including text and images to suit the customer

 

 

I have created a report that includes my conclusions

 

 

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 9.1: Control

Towards Level 5

Level 5-6

Toward Level 7

I have planned and created a flowchart to control one part of the ride (e.g. operating camera)

I have identified sensors suitable for monitoring the ride and explained how they will be used

I have improved my control system to make it more efficient (e.g. combining flowcharts, creating and using subroutines)

I changed input values to test my flowchart and corrected any parts that didn’t work properly

I have planned and created flowcharts to control every part of the ride

I have explained why the style and content of my presentation is suitable for the them park manager

I have used criteria to make sure my final presentation is suitable for the theme park manager

I selected and used appropriate input values to test all of my flowcharts and corrected any parts that didn’t work properly

 

 

I have devised and used criteria to make sure my presentation is suitable for the theme park manager

 

Title

Level

Reason

 

 

 

 

 

 

 

 

 

 

 

 

 

é Unit 9.2: Handling Data

Towards Level 5

Level 5-6

Toward Level 7

I explain why it is important to check data is accurate

I planned, designed and created a questionnaire that was suitable for collecting relevant data to test hypotheses

I designed and implemented an efficient method of collecting relevant data to test hypotheses (e.g. an on-line data collection form)

I created appropriate hypotheses and questions to prove/disprove them.

I have made sure that the data is accurate by checking for errors (dirty data)

I devised, explained and used appropriate data validation rules to reduce input errors

I used complex queries to test hypotheses

I designed and created a suitable database file to store and process the data I collected

I selected and used appropriate test data to make sure my database file works properly

I created appropriate graphs to test hypotheses

I created appropriate graphs to test hypotheses and explained what they prove.

I have explained why the style and content of my presentation was suitable for the rest of the class

I created a presentation to communicate the results of the survey.

I explained what I learnt from the project and how the survey could be improved.

 

 

I devised and used criteria to make sure my presentation was suitable for the rest of the class

 

Title

Level

Reason

9147masa.doc

4.7

Appropriate hypotheses.  2 Appropriate charts with some analysis to show what they prove.  Report has some structure.  Needs a conclusion

915fasa.doc

5

Some evidence of planning.  No conclusion.

 

 

 

 

 

 

 

é Unit 9.3: An ICT System

Towards Level 5

Level 5-6

Toward Level 7

I entered formulae in the financial model that gave the correct output

I selected the information needed in the financial model and entered formulae that gave the correct output

I developed a financial model without any help from my teacher

I have made predictions and changed the values of variables in the financial model to check them

I changed some of the variables and rules in my financial model to make the output more realistic with some help from my teacher

I added new variables and rules to my financial model to make the output more accurate without any help from my teacher

I have planned and created publicity materials suitable for the target audience

I used appropriate input values to make sure my financial model worked properly and corrected any mistakes

I selected and used appropriate test data to make sure my financial model worked properly and corrected any mistakes

I used criteria to make sure my final presentation was suitable for the user of the system

I have used the financial model to investigate the feasibility of the production and support my conclusions

I have used feedback from the target audience to improve my publicity materials

 

I have evaluated my publicity materials to make sure they are fit for purpose and the target audiences

I have used efficient processes to automate parts of the system (e.g. using mail merge to target customers, on-line booking form)

 

I have designed and created a suitable database file to store customer data

I have explained why the style and content of my presentation was suitable for the users of the system

 

I devised and used criteria to make sure my presentation was suitable for users of the system

 

Title

Level

Reason