Thursday, 26 May 2011

Wednesday, 25 May 2011

Thursday, 19 May 2011

Tuesday, 10 May 2011

Monday, 2 May 2011

ecdl workbook

http://www.teach-ict.com/ecdl/module_1/module_1.htm

Monday, 11 April 2011

requirement for good spreadsheet sample work

Spreadsheet Modelling Unit 1
Questions in Section B of the unit 1 examination will relate to a spreadsheet modelling task carried out by the candidate. The questions will focus on the following areas.
USER REQUIREMENTS
What the purpose of the spreadsheet is?
What are the detailed outcomes?
User interface, sheets, features to be used,
Processes including searches sort validations automated processes
Outline calculations and results required
Reports to be printed.
DESIGN and IMPLEMENTATION
Identify and explain the purpose of; 1. Labels, data, 2. Formulas Any two from Group A and two from Group B Group A
SUM
COUNT
MAX
MIN
AVERAGE
RAND
Group B
SINGLE IF
MULTIPLE IF
DATE
ROUND
3. Multiple sheets and 3D links (Sheets!) 4. Simplification of data entry
drop down list boxes
Lists
Spinners
logical True or False or Tick Boxes or Option boxes
lookup or vlookup or hlookup tables
5. Ease of use and professionalism
startup user interface
data entry forms
Control buttons should be used to initiate macros. e.g. navigation / print / data transfer
6. Error trapping e.g. validation techniques and error messages produced NOT spinners or lists 7. Processing
sorting techniques
Search for specific criteria e.g. single and multiple criteria
8. Appropriate use of graphs such as bar or column graphs, line graphs, pie charts, scatter graphs, pictographs. Must relate to own spreadsheet not general descriptions and must be clearly evidenced in the submitted spreadsheet.

Thursday, 7 April 2011

validation

Tuesday, 5 April 2011

revision

revision link

Monday, 4 April 2011

info1 overview

info1

Thursday, 31 March 2011

sample

Sample work

https://docs.google.com/document/d/1OudksPZmp0COuQeo3ZcAA87104JaUqmYqLYBETJZTC0/edit?hl=en_GB&authkey=CM-t7YAL

Monday, 28 March 2011

standard business letter

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

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

Tuesday, 8 March 2011

social network question

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:

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

Send your letter of application to Ms Smith at XYZ College, New Lane, New Town, NT1 1AB no later than Friday 21 January 2011.

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

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

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.

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!

Thursday, 17 February 2011

Audio Chapter descriptions - INFO 2

chapter 2.1

chapter 2.2

chapter 2.3

chapter 2.4

chapter 2.5

chapter 2.6

chapter 2.7

chapter 2.8

chapter 2.9

Audio Chapter descriptions - INFO 1

Audio Chapter 1

Audio Chapter2

Audio Chapter3

Audio Chapter4

Audio Chapter5

Audio Chapter6

Audio Chapter7

Audio Chapter8 and 9

Audio Chapter10

Tuesday, 15 February 2011

What AQA say - about TESTING

9. Testing of ICT-related solutions

Construct test plans that include a range of suitable test data, identify expected outcomes and test that the client’s requirements have been met.

A test plan that shows the design of representative examples of tests to ensure:

• Validity of data input

• Accuracy of output

• Presentation of output

• That the solution meets the requirements of the client

• That the solution is usable by the end user(s) and/or intended audience

• That it incorporates the data to be used for testing the solution and the expected results of each test.

Follow test plan in a systematic way.

Testing evidence - that is cross-referenced to the test plan.

Testing evidence that is clearly annotated to show an understanding of the testing process.

Interpret the results of tests and take appropriate action.

The results of testing evidence are used in the evaluation of the solution.

Monday, 14 February 2011

homework INFO2 hand in by 1/3/2011

1.1 Knowledge , Information & Data

January 2001

1. Three components of an Information Processing System are input, processing and output. State what is meant by:

input
processing
output

and give an example of each one. (6 marks)

2. When incorrect bills are sent to customers, an organisation often gives the reason as “The computer got it wrong”. Using an example, give a more likely explanation. (4 marks)

May 2001

1. Explain what is meant by Information and Communication Technology. (3 marks)

2 The expression “Garbage in, garbage out”, or “GIGO”, is often used in connection with information processing systems. Explain, using an example, what is meant by this expression. (4 marks)

January 2002

1. Explain, using examples, the following terms as they are applied within ICT:

(a) Data; (2 marks)

(b ) Information; (2 marks)

---oOo---

1.2 Value and Importance of Information

January 2001

4. State three factors that affect the value and importance of information. Give an example that shows clearly how each factor affects the information’s value. (6 marks)

May 2001

3. A travel firm arranging package holidays in Spain for the 2001 season uses data obtained from a survey of their customers’ favourite holiday resorts in 1997. Explain

(a) why the data from 1997 might not be suitable for use to predict the requirements for 2001,

(b) what the effect on the company might be if it used the 1997 data. (4 marks)

---oOo---

1.3 Control of Information

January 2001

5. When buying a new house through a large estate agency, customers are asked if they object to the data they are giving to the estate agent being passed on to other companies.

(a) Explain why the estate agent must ask this question. (2 marks)

(b) State, with an example, what the estate agent could do with the customers’ details if they give permission for them to be passed on. (2 marks)

---oOo---

1.4 Capabilities and Limitations of ICT

May 2001

5 A supermarket chain operates an automatic ordering system between the stores and a central warehouse.

(a) State two advantages for the store of using an automatic system. (2 marks)

(b) Explain one advantage for the supermarket’s customers of the store using an automatic stock

control system. (2 marks)

January 2002

3. When ordering goods by telephone many companies ask the purchaser for his or her postcode. They then use this to confirm the address of the purchaser by looking up the postcode in a database of codes.

Explain two reasons why companies prefer to buy a database of postcodes rather than to collect the data from the purchasers. (4 marks)

nnnn

.5 Social impact of ICT

January 2001

10. The use of Information and Communication Technology (ICT) has brought benefits to a number of areas.

For each of the following, state a use of ICT, and describe the benefit that can be gained. Your examples must be different in each case.

(a) Education

(b) Health

(d) Offices

(e) Manufacturing companies

(f) Police

(12 marks)

1.6 Communication Systems

January 2001

6. The use of e-mail has increased dramatically over the last five years. This has improved communications both internally within a company, and externally between companies and their suppliers and customers.

Describe the facilities of an e-mail software package that you would use to carry out the following tasks efficiently.

(a) Pass on an e-mail message that you have received, in error, from a customer to the sales manager. (2 marks)

(b) Inform a group of staff about the time and date of a meeting. (2 marks)

(d) Send an important and urgent message to a supplier. (2 marks)

May 2001

6 (a) Browsers and search engines are two items that are associated with the use of the Internet Explain what is meant by:

(i) a browser (2 marks)

(ii) a search engine. (2 marks)

(b) In order to use the Internet, the owner of a PC at home normally needs to register with an Internet Service Provider (ISP). State two services, in addition to e-mail, that an ISP could provide.

(2 marks)

(c) Changes in technology now mean that it is no longer necessary to have a PC to be able to use some Internet services. Give two devices that can be used instead. (2 marks)

(d) Explain why it is possible to send e-mail successfully to someone who has not got his or her PC switched on. (2 mark)

May 2001

4 Mrs Jones has bought a book on gardening from a book company on the World Wide Web. She has now started to receive e-mails about garden furniture, and plant catalogues through the post.

(a) Explain why Mrs Jones has started to receive the e-mails and the catalogues. (2 marks)

(b) Some people are worried about ordering goods using credit cards over the Internet. Explain what can be done by the book company to prevent credit card details being misused. (2 marks)

12. A firm of engineers in the United Kingdom has been given the task of designing a new building in Australia. As one of their methods of communicating with their clients, it has been suggested that the company uses videoconferencing.

(a) Explain what is meant by the term videoconferencing. (4 marks)

(b) Give two advantages and two disadvantages to a company of using this approach as compared with non-ICT methods. (4 marks)

January 2002

6. What do the following features, available with most email software, allow the user to do?

(a) Forward (2 marks)

(b) Reply (2 marks)

(d) Attach (2 marks)

(e ) Prioritise (2 marks)

January 2002

9.A large clothing retailer has decided to set up an on-line store.

(a) Explain two advantages to the retailer of using this method of selling as opposed to selling from a high street shop. (4 marks)

(b ) Explain one advantage to the customer of using the on-line store rather than a high street shop. (2 marks)

(c ) State one disadvantage to the customer of using the on-line store rather than a high street shop. (1 mark)

(d ) Describe two ways in which the retailer could make use of the Internet to publicise its new service. (4 marks)

1.7 Information and the professional

January 2001

3 A company is recruiting a new member of staff for their IT support desk. The head of personnel asks the manager of the support desk what personal qualities the new employee must have in order to carry out the job effectively. State, with reasons, four personal qualities that the manager would want a new employee to have. (8 marks)

May 2001

8 An advertisement for an IT support worker to join the PC support team in a company specifies that the applicant must be “willing to work flexible hours, be able to communicate well orally, have good written skills and get on well with a wide variety of people”.

Explain, giving examples, why each of these characteristics is important for someone working in such a role. (8 marks)

January 2002

2. Professionals involved with ICT systems often have to work with people who have little, or no, understanding of the ICT systems that they are using.

State two personal qualities that IT professionals should have that will enable them to help such people effectively. and give an example of when each quality would be needed. (4 marks)

1.8 Malpractice and Crime

January 2001

7 A school wishes to allow its students unrestricted access to the Internet for research work during their lunchtimes. The headteacher is concerned that this might cause problems.

State two problems that the headteacher might be concerned about, and for each one explain a measure that could be taken to prevent the problem. (6 marks)

May 2001

11 Explain, with reasons, two levels of access that could be given to different categories of users of an on-line stock control system. (4 marks)

January 2002

4. Explain, using examples, four different ways in which the Internet is being used to support illegal activities. (8 marks)

5. Information Systems need to be protected from both internal and external threats

(a) Explain: using examples, the differences between an internal and an external threat to an

Information System. (4 marks)

(b) For each of the following, describe a measure that a company can take to protect their Information System from:

(i) Internal threats; (2 marks)

(ii) External threats. (2 marks)

1.9.1 Legal Frame Work - Copyright etc.

May 2001

7 (a) Describe what is meant by a software licensing agreement. (2 marks)

(b) Mr Patel has a single user software licensing agreement for a word processing package which

specifies that there must only be one copy in use at any one time.

Would he be guilty of breaking the agreement if he installed the package on his laptop PC, as well

as on his stand-alone PC at work. Explain your answer. (2 marks)

for a word processing package that may be used at the same time on all 20 stations? (2 marks)

(d) Breaking the licensing agreement is one type of offence that a computer user can commit. Some other offences are covered by the Computer Misuse Act.

Explain, using examples, level 1, 2 and 3 offences under the Computer Misuse Act. (9 marks)

1.9.2 Legal Framework - Data Protection Act

January 2001

8 (a) State five of the principles of the 1998 Data Protection Act. (5 marks)

(b) Describe two exemptions to the 1998 Data Protection Act. (4 marks)

May 2001

10 (a) State why an organisation must apply for entry on to the Data Protection Register. (I mark)

(b) State three items of information that must be provided by the data user about the data that is to be stored. (3 marks)

January 2002

7 Data protection legislation was introduced into the UK in 1984; it has since been superseded by the 1998 Act.

(a) State why the legislation was originally introduced. (I mark)

(b) State what type of data is the subject of the Data Protection Act 1998. (2 marks)

(c ) A company wishes to collect data from order forms submitted by its customers to sell to other

companies.

State two actions that the company must take so that it can legally collect and sell that data.

(2 marks)

(d) The Data Protection Act gives individuals the right to see what data is being held about them.

(i) State how an individual must ask to do this. (1 mark)

(ii) Could an individual have to pay to receive a copy of his or her data? (1 mark)

1.9.3 Legal Framework - Health & Safety

January 2001

9 Describe three features of poorly designed software that can cause stress or other health problems to a user. (6 marks)

May 2001

7. Poorly designed computer workstations can lead to health problems. State three features of a well-designed workstation, and for each one state the health hazard that will be prevented. (6 marks)

January 2002

8. A clerk working at the offices of a mail order company spends all day entering order data into the company’s sales order processing system. The clerk uses a workstation linked to the company’s main computer.

To ensure the health and safety of the clerk, state, with reasons:

(a) two work practice procedures that the company could introduce; (4 marks)

(b) two design features that the hardware the clerk uses should have; (4 marks)

2009 mark scheme

Mark Scheme

try

testing examples

Testing examples

info1 - blog

info1 blog

link to Wordpress info

http://jonhoo.wordpress.com/2010/05/19/using-wordpress-as-a-website-backend/

link to Wordpress info

Monday, 7 February 2011

e-commerce question - what the examiner said

Question 5(a)

This question required candidates to apply their knowledge of backup and recovery to a

continuous e-commerce operation. Few candidates related their answers to the context of the question.

Most candidates were able to collect some marks on this question by discussing backup

strategies including: the type of backup, the frequency of backup, the timing of backup (e.g. at midnight), the choice of medium, the location of the backup and the personnel responsible for backups. Credit was awarded for discussing techniques such as disk mirroring and RAID.

Rarely did answers include the recovery of data and the need to complete recovery quickly to ensure continuity of service.

Information and Communication Technology - AQA GCE Report on the Examination 2009 June series

Question 5(b)

Three types of processing were acceptable (Transaction (or pseudo real-time), Interactive and Batch) and the best answers discussed how these types of processing could be useful in ecommerce.

Batch Processing was acceptable, because an e-commerce organisation would

still have a payroll run or the need to print out address labels for mail-shots.

Weaker candidates did not answer in the context of e-commerce and merely explained what

was meant by each of the processing types and couldn’t gain good marks for their answers.

Question 5(c)

E-commerce covers a wide spectrum of business on-line, such as on-line booking and banking.

The meaning of society was taken in its widest sense when awarding credit.

Implications of e-commerce such as: reduced travel costs, reduced pollution, loss of social

interaction, a sedentary life-style, increased opportunity for crimes such as credit card fraud or identity theft, all gained credit.

e-commerce

Sunday, 6 February 2011

homework INFO2 hand in by 14/02/2011

Homework

or

https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0BwLfsq9Sg7EbZGQ1YmQ0NTctOTI3Yi00MGQ4LThiN2EtYzE4OTUzYzY5Yzk5&hl=en_GB&authkey=CJSRs-ME

Tuesday, 1 February 2011

another list of INFO1 requirements

another college blog

http://mwoo.co.uk/ks5/2011/01/aqa-info-1-coursework-write-up-requirements/

Powerpoint analysis

PowerPoint analysis and testing

Monday, 31 January 2011

Exam questions - Sample work

Analysis Exam Questions

Make sure that you have your sample work in front of you when you answer these questions.

Specimen Paper 1

1. (i)Give the page number where you have stated your client questions in your sample work?

Page.........

[in your sample work, write ‘1(b)(i)’ next to your evidence in the margin of that page]

(ii) Give two examples of questions that you asked your client when you investigated a problem that they wanted solving.
Explain why the questions were important to ask.
[6 marks]

__________________________________________________________________

2. What are client requirements and why are they important?
[2 marks]

Specimen Paper 1

_______________________________________________________________

3. (i)Give the page number where you have stated your client requirements in your sample work?

Page.........

[in your sample work, write ‘3(b)(i)’ next to your evidence in the margin of that page]

(ii) Select three of your client requirements and explain
how you would aim to solve each requirement.
[9 marks]

© tcowling based on Specimen Paper 1
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________

4. Explain who your Client, User and Audience are.

[3 marks]

Specimen Paper 1
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________

[Total: 20 marks]

Analysis template

Analysis

Software to use

State what software you are going to use for each of your ‘problems’.
what type you could use and why you have made your recommendations

Hardware to use

Identifying the problem

Who is the client - what information you ask for

Who is the user - explain the user in terms of training / health and safety/ protection of system

Who are the audience - the customer

Description of the problem

EG: the client is Steve Clein. He runs a small stationery company in Bexleyheath. The company, Pens R Us, employs 10 other people in the office in the High Street. Steve would like a spreadsheet to:

1. Record daily sales records

2. Include statements if item needs to be re-ordered or not

Interviewing the client

Give proof of your communication with your client through an interview, questionnaire, email or telephone conversation.

NOTE THIS RECORD YOUR COMMUNICATION EVEN IF YOU MAKE IT UP.

Client Requirements

State what the client wants you to do.

Pens R Us-problem description

Problem: Steve Clein requires a spreadsheet to order more stationery.

Client: Steve Clein

User: Steve Clein

Audience: Stationery Supply companies.

1. Perform quick calculations

2. Record any profit

3. Easy to operate

4. Reduces time spent on calculations
5. If you are asked to look at how the solution deals with health and safety.
6. Secure systems
7. confidentiality

Inputs, Processes and Outputs

Input

The type of paper

The quantity required

Is it folded or not

Process

Looking up prices

Calculating totals

Adding on VAT

Output

The company name and address

The total price

The date

Error messages

Sunday, 30 January 2011

INFO1- aqa information

web.aqa.org.uk/qual/gce/pdf/AQA-2520-W-TRB-U01ICINFO1.PDF

Wednesday, 26 January 2011

Bespoke software

Define Bespoke software give an example

Home | Design | Contact

Education & Training Software

We design and engineer professional, high-quality, custom-built software for desktops, servers, websites and portables. Our flexible design philosophy enables us to produce versions of the same software for PC, Mac and Linux as well as mobile platforms such as iPhone, Blackberry, Android, iPad etc.

We are specialists at integrating large and complex databases to be shared across a network or securely over the internet. We can design custom software to use encrypted databases on users' systems to prevent unforeseen data loss through lost laptops and missing memory sticks. Using encrypted data also prevents competitors accessing your data should they find it in their hands.

Bespoke software can dramatically reduce deployment costs as there are no ongoing licence fees and installation options can be tailored to suit specific requirements during the initial design phase.

Whether you wish to install our custom software on one computer or 1000, the cost is the same and you can deploy the software on as many systems as necessary - as your business expands, your software costs won't.

If you would like to talk to us about a project, then please phone 0121 240 7532 or email info@perrins.com with your enquiry.