Weekly
Schedule - Topics |
Lecture Notes
|
Tasks |
 Week 1 - induction to unit /
Spreadsheet Skills Audit
|
Tutor led discussion / * In class demonstration
|
Practice Spreadsheets Audit
http://avceict03.ttsonline.net/unit3/a5/excelbas.htm
You must complete these in class, save
each excel file, you will need to provide screendumps
to show you have completed the exercises. Submit
by Friday 26th September!
*You must fill in your Unit
3 handbook with the activity and deadline dates -
Consult section 3
|
| Week 2 - Advanced Techniques
1: Designing a Spreadsheet System / System lifecycle |
System
Lifecycle (powerpoint slides) |
Consult the following case study located at http://avceict03.ttsonline.net/unit3/a5/despec.htm
You need to create a detailed design specification,
this will be a mock exercise to help you with your assignment. |
| Week 3 - Shoeshock SPreadsheet
system |
|
Consult your AVCE units 1-3 book (P.M. Heathcote) You
will be implementing the case study 'Shoeshock system'
Read pages 128 -142 and follow theinstructions
in building the system. You may want to keep a skills
log as to what functions you have learnt. |
| Week 4 - Rent a car system -
Requirements specification |
|
Consult the assignment specification which has been
given to you. You need to complete deliverable 1 - deadline
= Friday 17th October |
| Week 5 - Rent a car system -
Requirements specification / design |
|
Consult the assignment specification which has been
given to you. You need to complete deliverable 1 - deadline
= Friday 17th October |
| Week 6 - Rent a car system -
design / implementation |
|
Consult the assignment specification which has been
given to you. You need to complete deliverable 2 - deadline
= Friday 14th November |
| Week 7 - Rent a car system -
implementation |
|
Consult the assignment specification which has been
given to you. You need to complete deliverable 2 - deadline
= Friday 14th November |
| Week 8 - Rent a car system -
testing |
* Week commencing 17th
November |
Your implementation must be complete by this stage.
You MUST now test your spreadsheet. Use the following
document as a guide
Test Plan Document |
**WARNING** Deadlines
are strictly enforced if you fail to meet a deadline you will
not meet C criteria (consult marking scheme). If you feel you
cannot meet the deadline you must see your tutor.
| ASSIGNMENT CHECKPOINT |
Deadline |
assignment
Checkpoint A - Requirements Specification and design
Write a specification describing the system you will
design and create screen designs for the proposed system.
Consult the rent a car assignment brief for further
details. |
-=Friday 17th October=-
|
| assignment
Checkpoint b - Implementation |
-=Friday 14th November=- |
| assignment
Checkpoint c - testing |
-=Friday 28th November=- |
|
