You must collect all the images and text you need for your newsletter before
next week’s lesson.

Remember to keep updating your sources log.

M.stephenson

m.stephenson Uncategorized

Half term homework Must be completed before 20/02/2012):

Add data to all your tables so that your queries and reports will show they have worked.  Remember at least one of the reports will need to be over 1 page in length.

You should already have completed the following : (Also complete this if it is not done)

Time Plan                                                                                   (AO 4.2)

Background information                                                              (AO 2.1)

User needs                                                                              (AO 2.2)

Evaluation criteria                                                                  (AO 4.3)

Software to be used                                                                 (AO 2.3)

Data Dictionary                                                                        (AO 4.2)

Creation of tables (data types and field properties)                  (AO 1.1 & 3.7)

Creation of data structure (relationships)                                    (AO 3.6)

You should have started creating the processing: (This will be completed after half term)

- sorting                                                                                      (AO 1.2 & 3.4)

- queries                                                                                      (AO 1.3)

- reports                                                                                       (AO 1.4 & 3.5)

Help file: I:\ICT\Post 16\GCE in Applied ICT\Unit 3\Example Evidence for processing.doc

m.stephenson Yr 12

Evaluation criteria_example

This homework is due for the start of the lesson on Wednesday.

You must produce the evaluation criteria which is used to test if you have met your clients needs.  These should be based on each of your user needs as per the example attached above and the location on the I:\drive is below.

I:\ICT\Post 16\GCE in Applied ICT\Unit 3\Evaluation criteria_example

m.stephenson Yr 12

The Macmillan invoice homework spreadsheet must be finished before the lesson on Tuesday 17th January.

The file is located at:  I:\ICT\Post 16\GCE in Applied ICT\Unit 10\Invoice examples\macmillan_invoice_student_to_complete.xls

Use your other invoice to help you.

m.stephenson Yr 13

You must submit:

Your up todate action plan

Evidence for AO2.1 – Client’s background

Evidence for AO2.2 - Client’s needs

Evidence for AO2.3 – Software required

You must printout and hand in (or tell me where your file is) at the start of the lesson

m.stephenson Yr 12

What is Health and Safety in the workplace?

List 3 things you need to be careful of when using computers in the workplace, how would you make sure these accidents didn’t happen?

Print it off and bring it to next Thursdays lesson

Also

You must ensure you have published your poster as PDF and completed the three evidence files.

m.stephenson Uncategorized

You must printout the attached document and write in the box explaining what each tool does and why you might use it.

 You must hand it in at the start of Thursday’s lesson.

Tools-in-a-Desktop-Publisher-program

m.stephenson Yr 8

 You need to produce the outputs requested by the user.

 To work out what the outputs are, read the user needs file:

 I:\ICT\Post 16\GCE in Applied ICT\Unit 10\GCSE Grade Calculation_User Needs.docx

GCSE Grade Calculation_User Needs

m.stephenson Yr 13 output, Spreadsheet

You must produce detailed annotated screen shots to evidence your:

 Forms

 Queries (Explain the different types)

Reports

Created for the newsagent database.

The deadlines are:

12 B1 – 16/11

12B2 – 14/11

m.stephenson Yr 12 Database, Database Year 12, Year 12

This is the example macro code I demonstrated during the lesson today.

 Save Data to a new sheet Macro

Please remember to comment with your filename and path when you have created it.

m.stephenson Yr 13