Starter: Systems Lifecycle wordwall

Writing a test plan

You need to test your travel costs system to make sure it is working correctly.  In order to do this, you need to create a test plan.

1. The test plan will indicate what you are going to test and why.  It will contain specific test data which you will use to test your system and it will indicate what the expected outcomes will be for your test.
2. You will then use your test plan to test your system, record the actual outcomes of your test and then compare them to the expected outcomes.

You should set your plan out as a table in MS Word with appropriate headings for the columns.  Each test should have at least: a test number, description of test, test data, expected outcomes, actual outcomes and comments.  Actual outcomes will be blank – this will be filled in when you complete your testing.

Starter: Mr Cutis says…

Software Justification

A software justification is an explanation of why you are using a certain piece of software to solve the problem outlined in the desired outcomes/performance criteria and detailed in your design plan.

A good software justification will match each of the desired outcomes/performance criteria closely with the features of the software.  Therefore, it is a good idea to copy and paste the desired outcomes/performance criteria into a new document and use them as the basis for your software justification.

You could begin your software justification with “I will be using [piece of software] to complete the [task] because …” and then underneath each desired outcome/performance criteria explain the feature of the software which you will use to solve that particular problem.  Some desired outcomes/performance criteria will be solved by using the same feature so you can group those together and avoid repeating yourself.

An example; “must make the weekly costs stand out”

One of the features of MS Excel is the ability to format individual cells.  It is possible to change the background colour of cell, add a border and choose the colour for the border.  Any text entered into the cell can also be formatted by changing the font style, font size and font colour.  The text can also be made bold, italicised and underlined.  As you can see from my plan, this feature of Excel will be useful to me as I have decided to make by weekly costs stand out in cells C10 and C11 by changing the background colour of the cell to dark blue and making the font colour white as well as bold.

Starter: Countdown

Homework

Please complete the Operating System questions – due next Tuesday

Task 1

Please swap your spreadsheet plan with somebody else then using a post-it note or two jot down any questions you would need to ask your partner about their plan if you were going to implement it.  Use the following list to guide your thoughts;

• the data needed and where it comes from
• the font styles, sizes and colours which you will use
• details of any borders or shading to be used
• alignment of data in cells
• any merged cells and column widths
• formatting of cells (currency, decimal places etc)
• all formulas to be used
• any replication (fill handle) to be used

Continue to work on your hand drawn plans for your spreadsheet taking into consideration any comments made – scroll down to last lesson for help with this.

Task 2

If you complete your hand drawn plans then continue to work on your software justification.

Starter: Wordwall Operating Systems

Task 1

Please grab a piece of paper to make notes on operating systems

Task 2

Continue to work on your hand drawn plans for your spreadsheet – scroll down to last lesson for help with this.  Use post-its to comment on the work of others.

Task 3

If you complete your hand drawn plans then continue to work on your software justification.

Starter: Application Software Quiz

Task 1

Please continue to develop your plans for your spreadsheet, remember to include the following;

• the data needed and where it comes from
• the font styles, sizes and colours which you will use
• details of any borders or shading to be used
• alignment of data in cells
• any merged cells and column widths
• formatting of cells (currency, decimal places etc)
• all formulas to be used
• any replication (fill handle) to be used

When your plan is complete you can move on to your software justification, please see below.

Software Justification

A software justification is an explanation of why you are using a certain piece of software to solve the problem outlined in the desired outcomes/performance criteria and detailed in your design plan.

A good software justification will match each of the desired outcomes/performance criteria closely with the features of the software.  Therefore, it is a good idea to copy and paste the desired outcomes/performance criteria into a new document and use them as the basis for your software justification.

You could begin your software justification with “I will be using [piece of software] to complete the [task] because …” and then underneath each desired outcome/performance criteria explain the feature of the software which you will use to solve that particular problem.  Some desired outcomes/performance criteria will be solved by using the same feature so you can group those together and avoid repeating yourself.

An example; “must make the weekly costs stand out”

One of the features of MS Excel is the ability to format individual cells.  It is possible to change the background colour of cell, add a border and choose the colour for the border.  Any text entered into the cell can also be formatted by changing the font style, font size and font colour.  The text can also be made bold, italicised and underlined.  As you can see from my plan, this feature of Excel will be useful to me as I have decided to make by weekly costs stand out in cells C10 and C11 by changing the background colour of the cell to dark blue and making the font colour white as well as bold.

Starter:

Task 1

Please continue to develop your hand drawn plans for your spreadsheet.

Task 1

Please complete your analysis of task 3.  Ensure that you have your name in the header and then print it out.

Task 2 – Designing your spreadsheet

You need to make a start on designing your spreadsheet.  You will need to complete a hand drawn plan which is detailed enough for somebody else to take your plan and implement it.

You will need two A3 grids as there are two sheets in your spreadsheet.

Using the A3 grids, a pencil, a rubber and writing very lightly to start with, begin to plan out your spreadsheet.

Homework

Please have a go at the spreadsheet questions – these are due the next time I see you.

Starter: ICT Terminology Quiz

Task 1

After a quick recap, please analyse your coursework task 3

Starter: Last few quiz questions…

Task 1

Understanding reports in microsoft access – please open the following file: SHR Pupils (evie).mdb which can be found in Pupils:\Senior Pupils\ICT\Software\Databases.

Task 2

In threes, please analyse the following using the 6 analysis headings.

You need to produce a report on A4 paper which lists all of the girls in your house at school.  This list should be in order of DOB with the youngest girl first.

The report should show the following information; First Name, Surname, Year, Form, DOB and no other fields.

In the report header you should include the title “House List” along with the name and address of the school.  The report header should also include the school logo and the House Name field.  The report should look professional and be clear to read.  All of the information in the header and the field names should stand out.

The data file of pupils, the data file of house names and the school logo can be found in the pupils area.  The school contact details can be found on school headed paper.

The system should allow for any house list to be produced in the future.

A second list is also required.  This list should show all the girls in your house and in your year group. This is very similar to the first but only needs to show the following information First Name, Surname, DOB, Form, Science Group and no other fields.  It should be sorted in the same way as the first list but the title for the report should be “House List by Year Group” and the Year field should be included in the header under the House Name field.

The system should allow for any House/Year group combination list to be produced in the future.