System Development Cycle

Problems and Plans p.244

System Development Cycle (UMDIT)

1. Understand the problem- Interview participants, survery participants, what are the inputs? what are the outputs? what are the processes? who is involved with the system?
2. Making a decision- what type of solution? an IT solution? online or web-based?
3. Designing a solution- (making it happen), decide what software and hardware are required e.g. make a spreadsheet and put it up on sharepoint for a bus duty roster
4. Implementing the solution- preliminary testing. putting it on sharepoint, e-mailing everyone a set of instructions, installing hardware and software, training
5. Testing & Evaluating-Maintaining a solution- experiment (get someone to try it out), getting feedback, sample data (data that represents the day-to-day; typical data) and test data (checking for pan unusual or unexpected value)

Using Excel

• Formula; b7+c7+d7
• Function; =SUM (b7:d7)