Sample work
https://docs.google.com/document/d/1OudksPZmp0COuQeo3ZcAA87104JaUqmYqLYBETJZTC0/edit?hl=en_GB&authkey=CM-t7YAL
Thursday, 31 March 2011
Monday, 28 March 2011
Thursday, 17 March 2011
marking grid unit 8
Assessment criteria – Unit 8:– strand a)
Mark Band 1 Mark Band 2 Mark Band 3 Mark awarded
An outline project proposal that:
• provides some information, but not
sufficient on its own for senior
management to make an informed
decision
• shows limited awareness of audience
and purpose
Plus, a project definition document that
defines the scope of the project
An well-researched, detailed project
proposal that:
• provides sufficient information for
senior management to make an
informed decision
• considers the impact of the proposal
on others
• is clearly communicated,
demonstrating sound awareness of
audience and purpose.
Plus, a project definition document that
fully defines the scope of the project
A well-researched, comprehensive project
proposal that:
• provides all the information need for
senior management to make an
informed decision
• carefully considers the impact of the
proposal on others
• is well-argued and clearly
communicated, demonstrating sound
awareness of audience and purpose
Plus, a project definition document that
fully defines the scope of the project and
identifies clear and measurable
objectives.
(0 — 3) (4 — 5) (6) 5
Mark Band 1 Mark Band 2 Mark Band 3 Mark awarded
An outline project proposal that:
• provides some information, but not
sufficient on its own for senior
management to make an informed
decision
• shows limited awareness of audience
and purpose
Plus, a project definition document that
defines the scope of the project
An well-researched, detailed project
proposal that:
• provides sufficient information for
senior management to make an
informed decision
• considers the impact of the proposal
on others
• is clearly communicated,
demonstrating sound awareness of
audience and purpose.
Plus, a project definition document that
fully defines the scope of the project
A well-researched, comprehensive project
proposal that:
• provides all the information need for
senior management to make an
informed decision
• carefully considers the impact of the
proposal on others
• is well-argued and clearly
communicated, demonstrating sound
awareness of audience and purpose
Plus, a project definition document that
fully defines the scope of the project and
identifies clear and measurable
objectives.
(0 — 3) (4 — 5) (6) 5
Tuesday, 15 March 2011
Ralph’s Runs Spreadsheet User Requirements
User Requirements
Calculate total perimeter (Width x Length)
Calculate total area of material (Perimeter x Height)
Calculate total cost allowing for separate costs for plywood or boarding.
Allow only data within allowable range to be input.
User should not be able to change formulas or labels.
All digits should display clearly.
( remember these are a joke but you need to transfer to your own project)
Legal requirements
Area per bunny
Nontoxic spray wood preserve
Mesh size not greater than 20 mm2
Mesh underneath to stop foxes
Health and safety
Hutches which weight over 10Kg should have wheels and pull handle for movement
Bunny protection – Ralph must ensure
All data held on bunny must be available to bunny when asked for
Data must not be given to other bunnies
Values given by Ralph
Maximum width 3m
Minimum width 0.5m
Maximum length 10m
Minimum length 2m
Maximum height 1.5m
Minimum height 0.5m
Cost of board £7.12 per m2
Cost of plywood £2.48 per m2
Validation of ranges finished hutch area should not be greater/or smaller than the requirements
Greater than Maximum width 3m X Maximum length 10m X Maximum height 1.5m
Less than Minimum width 0.5m X Minimum length 2m X Minimum height 0.5m
Format £ to 2 decimal places
Protection on all cells which the user does not have to change
Testing for Ralph’s Runs Spreadsheet
Data Range Key
Typical Data Test Extreme (but valid) Data Test Invalid Data Test
Testing Calculations
Num Description Expected Result Actual result Pass? Question
1 Enter following values:
Width 2
Length 6
Height 1.2
Material : Plywood Perimeter: 16
Area:: 19.2
Total materials Cost: 47.62
2 Enter following values:
Width .5
Length 2
Height .5
Material : Plywood
3 Enter following values:
Width 1
Length 6
Height 1
Material : Board
Testing Data Entry Checking (Validation)
Num Description Expected Result Actual result Pass? Question
4 Enter 0.5 and 3 into ‘Width’ box
Enter 2 and 10 into ‘Length’ box
Enter 0.5 & 1.5 into ‘Height’ box All accepted
5 Enter .4 and 3 into ‘Width’ box
Enter 1.9 and 10 into ‘Length’ box
Enter 0.4 & 1.5 into ‘Height’ box All Fail
6 Enter 2.1 and 3 into ‘Width’ box
Enter 10.1 and 10 into ‘Length’ box
Enter 1.6 & 1.5 into ‘Height’ box
Testing Cell Protection
Num Description Expected Result Actual result Pass?
7 Try to change each label cell Blocked
8
9
Testing Number Display
Num Description Expected Result Actual result Pass?
10 Enter following values:
Width 0.5
Length 2
Height 0.5
Material : Plywood £17.80 displayed correctly
11 Format currency to 2 decimal
12 Does the system deal with + £100
Evidence of Testing
User Requirements
Calculate total perimeter (Width x Length)
Calculate total area of material (Perimeter x Height)
Calculate total cost allowing for separate costs for plywood or boarding.
Allow only data within allowable range to be input.
User should not be able to change formulas or labels.
All digits should display clearly.
( remember these are a joke but you need to transfer to your own project)
Legal requirements
Area per bunny
Nontoxic spray wood preserve
Mesh size not greater than 20 mm2
Mesh underneath to stop foxes
Health and safety
Hutches which weight over 10Kg should have wheels and pull handle for movement
Bunny protection – Ralph must ensure
All data held on bunny must be available to bunny when asked for
Data must not be given to other bunnies
Values given by Ralph
Maximum width 3m
Minimum width 0.5m
Maximum length 10m
Minimum length 2m
Maximum height 1.5m
Minimum height 0.5m
Cost of board £7.12 per m2
Cost of plywood £2.48 per m2
Validation of ranges finished hutch area should not be greater/or smaller than the requirements
Greater than Maximum width 3m X Maximum length 10m X Maximum height 1.5m
Less than Minimum width 0.5m X Minimum length 2m X Minimum height 0.5m
Format £ to 2 decimal places
Protection on all cells which the user does not have to change
Testing for Ralph’s Runs Spreadsheet
Data Range Key
Typical Data Test Extreme (but valid) Data Test Invalid Data Test
Testing Calculations
Num Description Expected Result Actual result Pass? Question
1 Enter following values:
Width 2
Length 6
Height 1.2
Material : Plywood Perimeter: 16
Area:: 19.2
Total materials Cost: 47.62
2 Enter following values:
Width .5
Length 2
Height .5
Material : Plywood
3 Enter following values:
Width 1
Length 6
Height 1
Material : Board
Testing Data Entry Checking (Validation)
Num Description Expected Result Actual result Pass? Question
4 Enter 0.5 and 3 into ‘Width’ box
Enter 2 and 10 into ‘Length’ box
Enter 0.5 & 1.5 into ‘Height’ box All accepted
5 Enter .4 and 3 into ‘Width’ box
Enter 1.9 and 10 into ‘Length’ box
Enter 0.4 & 1.5 into ‘Height’ box All Fail
6 Enter 2.1 and 3 into ‘Width’ box
Enter 10.1 and 10 into ‘Length’ box
Enter 1.6 & 1.5 into ‘Height’ box
Testing Cell Protection
Num Description Expected Result Actual result Pass?
7 Try to change each label cell Blocked
8
9
Testing Number Display
Num Description Expected Result Actual result Pass?
10 Enter following values:
Width 0.5
Length 2
Height 0.5
Material : Plywood £17.80 displayed correctly
11 Format currency to 2 decimal
12 Does the system deal with + £100
Evidence of Testing
Tuesday, 8 March 2011
Monday, 7 March 2011
Homework for 31/3/2011-2011 jan extended question
Homework for 31/3/2011
7 Read the advertisement below.
The XYZ College
Senior ICT Support Technician
Required as soon as possible.
Increased demands on the team have led to the need for a Senior ICT technician.
The XYZ College is a 14-18 community college providing traditional education for
young people and a wide range of courses for adults up to 10pm every weekday.
The college has a VLE (Virtual Learning Environment) that provides resources to
its students at home at any time of the day or night. You will be a key member of the ICT team delivering a customer care driven support service to the whole college on a 24/7 basis.
Reporting directly to the Network Manager, you will deputise for her in her
absence.
A proven track record of working in an ICT technical support environment for a
minimum of two years is also required.
Job responsibilities will include:
You are currently working as an ICT support technician at a different college and have decided to apply for this job.
Using the advertisement provided, write a letter of application explaining what makes
you a suitable candidate for the job.
In this question you will be marked on your ability to use good English, to organise
information clearly and to use specialist vocabulary where appropriate.
(20 marks)
This space is available for planning your answer, if you wish to use it.
7 Read the advertisement below.
The XYZ College
Senior ICT Support Technician
Required as soon as possible.
Increased demands on the team have led to the need for a Senior ICT technician.
The XYZ College is a 14-18 community college providing traditional education for
young people and a wide range of courses for adults up to 10pm every weekday.
The college has a VLE (Virtual Learning Environment) that provides resources to
its students at home at any time of the day or night. You will be a key member of the ICT team delivering a customer care driven support service to the whole college on a 24/7 basis.
Reporting directly to the Network Manager, you will deputise for her in her
absence.
A proven track record of working in an ICT technical support environment for a
minimum of two years is also required.
Job responsibilities will include:
- Allocation of jobs to the team
- Staffing the user support desk to resolve queries
- Logging the solution provided
- Developing and documenting procedures
- Diagnosing and fixing network problems
You are currently working as an ICT support technician at a different college and have decided to apply for this job.
Using the advertisement provided, write a letter of application explaining what makes
you a suitable candidate for the job.
In this question you will be marked on your ability to use good English, to organise
information clearly and to use specialist vocabulary where appropriate.
(20 marks)
This space is available for planning your answer, if you wish to use it.
2009 extended question
7 Explain, with the use of examples, how the use of ICT has been influenced by all of the
following factors:
cultural
economic
environmental
ethical
legal
social.
In this question you will be marked on your ability to use good English, to organise
information clearly and to use specialist vocabulary where appropriate.
(20 marks)
This space is available for planning your answer
following factors:
cultural
economic
environmental
ethical
legal
social.
In this question you will be marked on your ability to use good English, to organise
information clearly and to use specialist vocabulary where appropriate.
(20 marks)
This space is available for planning your answer
2010 extended question
8 The rapid development of ICT has enabled more people to work from home.
Discuss the concept of working from home, including in your discussion:
! how ICT has enabled more people to work from home
! the benefits that individuals can gain from working from home
! benefits to society of more people working from home
! any negative aspects of working from home.
In this question you will be marked on your ability to use good English, to organise
information clearly and to use specialist vocabulary where appropriate.
(20 marks)
This space is available for planning your answer, if you wish to use it.
Sunday, 6 March 2011
exam question for 8th March
7 A retired teacher is intending to travel to different parts of the world and requires a computer system to organise his travel, to keep in contact with people while he is away and to make a record of his journeys. He is unsure of what he needs to buy and has asked you to advise him.
Identify the items of hardware and software that he may need to buy, explaining how each would be of use to him.
In this question you will be marked on your ability to use good English, to organise
information clearly and to use specialist vocabulary where appropriate.
(20 marks)
This space is available for planning your answer
Identify the items of hardware and software that he may need to buy, explaining how each would be of use to him.
In this question you will be marked on your ability to use good English, to organise
information clearly and to use specialist vocabulary where appropriate.
(20 marks)
This space is available for planning your answer
long questions
Read the following article about social networking sites and answer the question below.
Social networking sites don’t deepen friendships Social networking sites like Facebook and MySpace do not help you make more genuine close friends, according to a survey by researchers who studied how the websites are changing the nature of friendship networks.
Although social networking on the Internet helps people to collect hundreds or even thousands of acquaintances, the researchers believe that face to face contact is nearly always necessary to form truly close friendships.
“Although the numbers of friends people have on these sites can be massive,
the actual number of close friends is approximately the same in the face to face
real world,” said Will Reader at ShefÞeld Hallam University.
Social networking websites such as Facebook, Bebo and MySpace have taken off rapidly in recent years. Facebook was launched initially in 2004 for Harvard University members but has since expanded to over 34m users worldwide.
MySpace, which was set up in 2003, has over 200m users and was bought by Rupert Murdoch’s News Corporation in 2005 for $580m.
Source: ‘Social Networking sites don’t deepen friendships’ by JAMES RANDERSON.
Copyright Guardian News and Media Limited, 10 September 2007
Question
Social networking sites are used by many students. Discuss the possible effects of using
these sites on individuals and society.
Your discussion should include the following:
! use of the Internet for socialising
! the protection of personal data
! ethical factors
! cultural factors.
In this question you will be marked on your ability to use good English, to organise
information clearly and to use specialist vocabulary where appropriate.
(20 marks)
(08)
M/Jun09/INFO2
This space is available for planning your answer.
........................................................................................................................
........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
........................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
................................................................................................................................................................................................................................................
Thursday, 3 March 2011
Examination tips
For no-nonsense, practical revision help, read these top 10 tips from some of Edexcel's 15,000 examiners:
- If you find that reading over revision notes just before an exam relaxes you, feel free to do so, but be aware that in most cases it could make you more nervous; any new information is not normally absorbed at this stage.
- On the day of the exam, when you are told to turn the paper over, don't start writing until you have read the exam paper from cover to cover.
- Mark the topics you wish to answer and concentrate on them. You should have an idea of how much time you are going to spend on each question, with the ones carrying the most marks being allocated the most time.
- Remember that the exams are not set to trip you up, but are designed to allow you to show your knowledge of the syllabus. Be positive and have confidence in your ability.
- Take time to consider the question. Look at where the marks are to be gained and allocate time appropriately (and stick to it). Many candidates spend too much time earning and re-earning small numbers of marks, thereby losing time for the heavier-tariff tasks. Remember, answering three questions fairly well is better than answering one very well and leaving two badly done. Underlining key words in the question may help to focus your mind and jog your memory.
- Structure your answers by making an answer plan; writing this down will help.
- Don't forget to refer back to the question to help ensure that you answer the question asked. The examiner can't give you marks for your knowledge and understanding of a topic if you don't answer the specific question properly. Make sure you don't answer the question you wish you'd been asked rather than the question in front of you! Try to read your answer through before moving on to the next question.
- Concentrate on your punctuation, spelling and grammar. Remember that, while you will not be marked down for bad handwriting, if the examiner cannot read what you have written, then they can't give you the marks you deserve.
- Try to relax, and keep an eye on the clock without checking it every five minutes. You need to leave time to complete each question and to read through your answers before the end of the exam.
- Once you have finished the exam, don't worry about it and try to avoid comparing your answers with other students. Now the examiners' hard work begins!
Subscribe to:
Posts (Atom)