Starter: DTP Codebreaker

Task 1

DTP Multiple Choice Questions

Task 2

Click here for online test papers, scroll down and look for ICT L2 Practice Test – there are 4 to choose from

Task 3

Continuing with portfolio

Starter: portraits

Task 1 – recap from last lesson

In pairs, talk about the answers to these questions;

1. what 2 S’s can you do in a database?
2. what are the two different ways of sorting in a database?
3. what does this mean >=
4. what does this mean <>
5. what is a primary key field and can you give an example?

We will now go over last lesson’s multiple choice questions.

Task 2 – Understanding data types

Data stored in a database needs to be store as a particular type.  Examples of data types are;

• text
• number
• currency
• date/time

• yes/no

Task 3 – Multiple choice questions part 2

Task 4 – continuing with your portfolio

Please check your work for instructions and then continue with your portfolio. Scroll down to previous lessons for examples and help.

Starter: 1-10

Task 1

Understanding database searching and sorting.

• Database records can be sorted by choosing a field or fields and sorting in ascending (a-z, 1-10) or descending (z-a, 10-1) order.
• To search for records operators are used
  • = equal to
  • > greater than
  • < less than
  • >= greater than or equal to
  • <= less that or equal to
  • AND/ OR can be used to connect searches together
• A primary key field has to be unique.  A name or Date of Birth may not be unique so cannot be used.  Primary key fields are usually ID numbers or codes  like PupilID, MemberID, CustomerCode, StockCode,

Task 2

Please check your work for instructions and then continue with your portfolio.

Scroll down to previous lessons for examples and help.

Task 3

Database multiple choice questions

Task 1

Viewing previous portfolio examples

Task 2

Continuing with your portfolio – please use your checklist to remind yourself where you are with your work.

What you are aiming for with your leaflet;

Spreadsheet

Normal view

Formulae view (tools>options>formula)

Here is a reminder of what to do when printing your spreadsheet

1. Before you print you need to put your name in the header or footer.  Watch this video to find out how to do that.
2. When you have finished you need to print out your spreadsheet but make sure it is on one page.  Watch this video for how to print your spreadsheet on one page.  Make sure you check print preview before you print and ensure that it says “page 1 of  1″ in the bottom left hand corner.
3. You also need to print your spreadsheet with your formulas showing, watch this video to show your formulas.

4. Before you print your formulas make sure that you also show your gridlines and row and column headings by watching this video.

Images

This shows the development of the images – before and after

Developing and Saving Images for your Leaflet: Task D – Developing Pictures

1. You need to include pictures in your leaflet and you can find these on the internet and / or scan them from your menus. Before you include them in your leaflet you need to alter or develop them in some way. You will be shown how to do this in Photoshop Elements.

2. You should include before and after printouts showing your original picture, an explanation of what you have done and the developed picture.

Before you launch photoshop take a look at these screencasts.  They start simply and then get a little harder!!!

http://www.screencast.com/t/Y7gTGDxn2lv

http://www.screencast.com/t/y6×8P5QgdKB

http://www.screencast.com/t/VMe5Aa0bEA

Start / All Programs / Adobe Photoshop Elements 6.0

Choose Edit and Enhance Photos