jump to navigation

10D1 – Period 5: Tuesday 10th November November 9, 2009

Posted by ictatshr in 10D1.
add a comment

Starter: Mr Curtis says…

Task 1

In pairs or threes, how many different data types can you remember and can you suggest any example fields for each data type?

E.g. Data Type: Date/Time, Example field: Date of Birth

Task 2

Multiple choice questions 2

Task 3

Stop/Go

Task 4

Continuing with your portfolios.

I would like you to have at least 3 screenshots of each of your four shops.

  1. a screenshot showing some clothing prices from the shop which you will use
  2. a screenshot showing the logo of the shop (this could include other prices or information as well)
  3. a screenshot showing some information about the shop – the clothes it sells, it’s mission statement, sales information etc.

10D1 – Period 5: Tuesday 20th October October 19, 2009

Posted by ictatshr in 10D1.
add a comment

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?

Task 2 – Multiple choice questions

Task 3 – 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 4 – continuing with your portfolio

10D1 – Period 5: Tuesday 6th October October 5, 2009

Posted by ictatshr in 10D1.
add a comment

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
    • <> not equal to
  • 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.

Task 3

Database multiple choice questions

10D1 – Period 5: Tuesday 22nd September September 21, 2009

Posted by ictatshr in 10D1, cover.
add a comment

Hopefully, since last lesson, you have made a start on collecting some information about clothes shops in Shrewsbury or near where you live.

If you have managed to collect some information then in the box file marked “10D1 Key Skills” find a plastic wallet, write your name on a sticker and put your information inside the wallet and then back in the box file.

Today you need to make a start on your checklists – a reminder of what is required is below.  Use the examples from some current year 12s who completed their key skills last year to help you.

Activity Brief 1: Retail Clothing Outlet Leaflet

Your job is to research different clothes shops in order to provide an outfit for a teenager who is going to attend a formal event.

You will be required to produce a folded information leaflet which provides details of at least four clothes shops in an area of your choice.  You will need to collect information about your chosen clothes shops and this information could be found on the internet, in a printed catalogue provided by the shop, written notes made by you in the shop or any combination of these sources.

Your leaflet should contain; contact details for each shop, a brief description of the type of clothing they provide, pictures which will have been amended and developed by you, maybe a map of the area highlighting the location of the shops, a selection of clothes from each shop which would provide an outfit for a teenager who is going to attend a formal event, the total cost of the outfit from each shop, the average cost of the outfit for the teenager, a total cost ranking for each shop with 1 being the cheapest and 4 being the most expensive.

Tasks you need to complete for activity 1

Task A – Collecting printed information

1. Visit your chosen shops and pick up their catalogues or make some written notes about clothes and how much they cost.  Remember you need at least four shops.  You might decide to focus on one type of outfit e.g. daywear (for a wedding, christening, garden party, fete) or evening wear (for a prom ball, “leavers” dinner or concert) or a selection of both types of clothes. 

Task B – Searching the internet for information and developing your text

1. Using a search engine on the internet, search for retail clothing outlets. This should be a multiple criteria search so, for example, “Clothing” AND “Formal wear” AND “Shrewsbury” should be typed in.  Using the advanced search option may help. 

2. Take a screen shot of the search results page making sure that it includes evidence of your multiple criteria search.  Add this screenshot to a word document.  Name this document Internet Search Evidence for Activity 1, add your NAME, FORM / GROUP and DATE to the header and PAGE NUMBERS to the footer. 

3. You are aiming to find out as much as you can about each shop so you might need to follow some of the links on your search page – take screen shots of various pages that will be useful and add these to your word document.  Useful pages on websites might include; contact details, descriptions of the shop, catalogues

4. Print out your screenshots and along with the printed information from your shop (you may want to scan or photocopy this information), highlight the information that you think will be useful for your leaflet.  You should highlight text, pictures and figures that you might use and write next to them why they will be useful. 

5. Either by coping or pasting from the internet or writing in your own words, in Word write a few short paragraphs about your shops. Call this document Text Information about my Retail Clothing Outlets; add your NAME, FORM / GROUP and DATE to the header and PAGE NUMBERS to the footer.   Write this in plain text; don’t use headings or bullet points at this stage. 

6. Print out your paragraphs and then annotate them to show which words you will change, how you will create headings, formatting you might apply and where you will insert bullet points etc.

10D1 – Period 5: Tuesday 8th September September 7, 2009

Posted by ictatshr in 10D1.
add a comment

Introduction to ICT Key Skills Level 2

During this year, you will work towards achieving your ICT Key Skills Level 2 qualification. There are two parts to your qualification.

1. a multiple choice exam paper

2. a portfolio of work

Today you will take a past paper to give you an idea of the questions you will need to deal with and then we shall look at the requirements of the portfolio. When you complete the exam paper have a look at the requirements of the portfolio.

Portfolio

Activity Brief 1: Retail Clothing Outlet Leaflet

Your job is to research different clothes shops in order to provide an outfit for a teenager who is going to attend a formal event.

You will be required to produce a folded information leaflet which provides details of at least four clothes shops in an area of your choice.  You will need to collect information about your chosen clothes shops and this information could be found on the internet, in a printed catalogue provided by the shop, written notes made by you in the shop or any combination of these sources.

Your leaflet should contain;

  • contact details for each shop,
  • a brief description of the type of clothing they provide,
  • pictures which will have been amended and developed by you,
  • maybe a map of the area highlighting the location of the shops,
  • a selection of clothes from each shop which would provide an outfit for a teenager who is going to attend a formal event,
  • the total cost of the outfit from each shop,
  • the average cost of the outfit for the teenager,
  • a total cost ranking for each shop with 1 being the cheapest and 4 being the most expensive.

Activity 1, Task B

If you finish the exam paper, please make a start on Task B on your checklist.