UNIT 5 P3, P4, P5, P6, P7,
M2, M3, D2, D3
(Student)
,Contents
Introduction.................................................................................................4
P3................................................................................................................5
task plan...................................................................................................5
The Nature of the problem....................................................................5
Functions the model must perform.......................................................6
Constraints............................................................................................6
Function of user interface.....................................................................7
Success criteria.....................................................................................7
Design 1................................................................................................8
design 2..............................................................................................10
Design 3..............................................................................................13
Design choice......................................................................................16
Navigation map layout.......................................................................17
P4..............................................................................................................17
Feedback for finding changes/improvements.....................................17
Feedback 1 Muhammed Eash mir.......................................................17
Feedback 2 Hadim Hussain.................................................................18
Improvements.....................................................................................18
Timeline/timescale of the project........................................................20
Time schedule of staff meetings.........................................................21
P5..............................................................................................................22
Main design.........................................................................................22
Functions which I used in the spreadsheet..........................................24
Addition...............................................................................................24
Subtraction..........................................................................................25
Multiplication.......................................................................................25
Sum.....................................................................................................25
Averages.............................................................................................25
Data Validation....................................................................................26
Count......................................................................................................26
CountIF................................................................................................26
, MIN and MAX.......................................................................................26
IF.........................................................................................................27
Nesting IF function..............................................................................27
Lookup.................................................................................................27
AND.....................................................................................................27
Index...................................................................................................27
Graphs.................................................................................................28
Data entry...........................................................................................28
Relative and absolute references........................................................28
Macros.................................................................................................28
AutoFill................................................................................................28
Pivot table...........................................................................................30
Import and export...............................................................................30
Conditional formatting........................................................................31
Drop Down Box....................................................................................32
Password lock......................................................................................32
P6..............................................................................................................33
Test plan..............................................................................................33
P7..............................................................................................................36
How dose the spreadsheet align and meet the client requirements...36
Conclusion...........................................................................................41
M2..............................................................................................................41
Justify decisions made, showing how the design will fulfil its purpose
and client requirements......................................................................41
M3 optimizing the spreadsheet.................................................................42
Before improvements..........................................................................43
After improvements.............................................................................44
D2 evaluating the design also optimising data model against the client
requirements.............................................................................................48
Conclusions.........................................................................................50
D3 Demonstrate individual responsibility creativity and effective self-
management in the design development and review of a data model.....50
Gannt chart.........................................................................................52
CONLUSION.........................................................................................52
,
M2, M3, D2, D3
(Student)
,Contents
Introduction.................................................................................................4
P3................................................................................................................5
task plan...................................................................................................5
The Nature of the problem....................................................................5
Functions the model must perform.......................................................6
Constraints............................................................................................6
Function of user interface.....................................................................7
Success criteria.....................................................................................7
Design 1................................................................................................8
design 2..............................................................................................10
Design 3..............................................................................................13
Design choice......................................................................................16
Navigation map layout.......................................................................17
P4..............................................................................................................17
Feedback for finding changes/improvements.....................................17
Feedback 1 Muhammed Eash mir.......................................................17
Feedback 2 Hadim Hussain.................................................................18
Improvements.....................................................................................18
Timeline/timescale of the project........................................................20
Time schedule of staff meetings.........................................................21
P5..............................................................................................................22
Main design.........................................................................................22
Functions which I used in the spreadsheet..........................................24
Addition...............................................................................................24
Subtraction..........................................................................................25
Multiplication.......................................................................................25
Sum.....................................................................................................25
Averages.............................................................................................25
Data Validation....................................................................................26
Count......................................................................................................26
CountIF................................................................................................26
, MIN and MAX.......................................................................................26
IF.........................................................................................................27
Nesting IF function..............................................................................27
Lookup.................................................................................................27
AND.....................................................................................................27
Index...................................................................................................27
Graphs.................................................................................................28
Data entry...........................................................................................28
Relative and absolute references........................................................28
Macros.................................................................................................28
AutoFill................................................................................................28
Pivot table...........................................................................................30
Import and export...............................................................................30
Conditional formatting........................................................................31
Drop Down Box....................................................................................32
Password lock......................................................................................32
P6..............................................................................................................33
Test plan..............................................................................................33
P7..............................................................................................................36
How dose the spreadsheet align and meet the client requirements...36
Conclusion...........................................................................................41
M2..............................................................................................................41
Justify decisions made, showing how the design will fulfil its purpose
and client requirements......................................................................41
M3 optimizing the spreadsheet.................................................................42
Before improvements..........................................................................43
After improvements.............................................................................44
D2 evaluating the design also optimising data model against the client
requirements.............................................................................................48
Conclusions.........................................................................................50
D3 Demonstrate individual responsibility creativity and effective self-
management in the design development and review of a data model.....50
Gannt chart.........................................................................................52
CONLUSION.........................................................................................52
,
