Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Department Schemes of Work - ICT

VIEWS: 36 PAGES: 13

									                                    ICT
                                   Year 7
Brief outline of scheme of work, including topics to be covered:

Unit title                           Software
Using ICT                          - Powerpoint/Dreamweaver
Information and presentation       - Using Internet
Processing text and images         - Desk Top Publishing
Spreadsheet models                 - Excel
Data designing, capturing and      - Access/Word/Excel
presenting
Control – input, process, output
Measuring physical data


Details of any assessments or exams, (including timings):

Goal testing at start and end of 5 week sessions to assess progress made.
Sample homework sheet :-
Logos: Design your own or select a logo from a magazine or paper.
Answer the following questions:
1) Why are you familiar with it?
2) Is it instantly recognisable?
3) Is it a good logo in your opinion?


Details of any coursework or equivalent (including timings):

Technology subject taught on carousel – 10 weeks (2x5 week sessions) 4
lessons per week




                                      63
                                     ICT
                                    Year 8
Brief outline of scheme of work, including topics to be covered:
Unit title                                       Software
Public information systems                       Excel
Web publishing                                   Word/Dreamweaver
Information – reliability, validity and bias     Word
Data – use and misuse                            Excel
ICT systems/applications                         -

Details of any assessments or exams, (including timings):

Goal testing at start and end of 5 week sessions.
Sample question – Displaying Information
Complete at least 4 examples of how information is displayed (e.g. graphs,
text etc)


Details of any coursework or equivalent (including timings)

Technology subject – taught on carousel 10 weeks (2x5 week sessions) 4
lessons per week




                                        64
                                 ICT
                                Year 9
Brief outline of scheme of work, including topics to be covered:

Case study – preparation for Key Stage 4 work
Application of ICT – control systems
                   - global communications
                   - managing a project.


Details of any assessments or exams, (including timings):

Goal testing.


Details of any coursework, or equivalent (including timings)

Technology subject – taught on a carousel – 2x5 week sessions throughout
the year




                                    65
                  ICT Year 9 – Sample resources
Computers and Control
How are computers used to control things?
Think about the ways in which computers might be used to control everyday devices around us.
Try to complete the table below.
Remember that computers can be used anywhere a device works automatically, in response to
a sensor (e.g. smoke, light or movement) or in response to a physical contact being
made/release (e.g. a car alarm being activated when the door is opened).

     Place            Example 1          Example 2         Example 3          Example 4

    At home           Washing
                      machine
                     programme


    At work           Fire alarm




   In the high       Traffic lights
      street



    In school      Lesson changes




                                            66
Pantomime scenario

The school is going to produce a pantomime to be shown to the pupils in Year 6 and their
parents. The aim is to get the Year 6 pupils into school so that they can see what a nice place it
is and how much they will enjoy their time here if they decide to come to the school in Year 7. It
is also aimed at persuading their parent that this would be a very good school for their children
to attend, providing them with a good education and many extra-curricular activities. The Panto
will be performed for one night only.
You need to consider which parts of the process of putting on a production, advertising the
production and selling the tickets can be helped by computerisation.
In the past:
     • There has been no attempt to check if the productions will lose money or make a profit
         – it has been a case of “wait and see” and sometimes the school has had to raise money
         after the event to cover the losses.
     • Tickets have been made by hand and sold in the entrance hall.
     • No records have been kept of how many tickets were sold.
     • When the audience arrived there were no booked seats and those who came first got
         the best seats.
     • Some parent have complained that they would have come to the production, but did
         not find out about it in time – children in Year 6 had been given publicity about the
         show, but some forgot to tell their parents.




                                               67
                              GCSE ICT
                               Year 10
Brief outline of scheme of work, including topics to be covered:

Centre-based assignment – usually four tasks which use word processing,
desk top publishing, web design, spreadsheets and databases.
Theory includes: What is a computer
                  Parts of a computer system
                  Using a computer system
                  Computers and society


Details of any assessments or exams, (including timings):

Year 10 Mock Examination - early summer term


Details of any coursework, or equivalent (including timings)

Year 10 coursework – 30%
Year 11 coursework – 30%
Written exam taken at the end of Year 11 – 40%




                                    68
                                 GCSE ICT
                                  Year 11
Brief outline of scheme of work, including topics to be covered:

Project work – students can choose an area to study. They must show
application of computers e.g. recent projects have included dating agency,
newsagents, leisure centre.
Theory –    measurement control and simulation
            the internet
            computers in the real world


Details of any assessments or exams, (including timings).:

Year 11 coursework – 30%
+ Year 10 coursework – 30%
Written theory paper – 40%


Details of any coursework, or equivalent (including timings):

Project start – end of Year 10
Completion - March of Year 11




                                     69
            GCSE ICT – Sample exam questions

10. The 1998 Data Protection Act was introduced to help to protect people’s
right to privacy. From the list below, write the letter for the answers in the
space given.

   a) Data is obtained for specified and lawful purposes
   b) Data is accurate and up-to-date
   c) Data where national security is concerned
   d) Data is never given to anyone
   e) Data must not be more than six months old
   f) Data held on individuals must be sent to them on request
   g) Data can be prevented from being used for direct marketing
   h) Data that individuals want removed from their record must be
      removed immediately
   i) Data is not to be transferred outside the UK
   j) Data is to be kept secure against loss, damage or unauthorised
      processing.
   k) Data is used for health, education and social work



   (a)   Give three responsibilities placed on data users by the 1998 Data
         Protection Act.
         Responsibility 1 ______________________
         Responsibility 2 ______________________
         Responsibility 3 ______________________
                                                                  (3 marks)
   (b)   Give two rights the 1998 Data Protection Act gives to data subjects.
         Right 1 _____________________________
         Right 1 _____________________________
                                                                  (2 marks)
   (c)   Give two exemptions from the 1998 Data Protection Act
         Exemption 1 _________________________
         Exemption 2 _________________________
                                                                  (2 marks)




                                      70
5. The definitions given below are all related to data logging and control systems.
From the list given, choose the term which best matches the definition in the left-
hand column of the table below. Write your answers in the spaces provided.

Actuator                          Feedback                         Modem
Calibrate                         Graphing                         Period of logging
Data logging                      Logging interval                 Sensor
Encryption                        Multiplexer                      Web browser


Definition                                                   Term which best matches the
                                                             definition
An input device used to measure environmental
conditions
Collecting and storing of data at regular, fixed intervals
over a period of time
The time taken between the first reading being taken
and the last reading being taken
The time between one reading being taken and the next
reading being taken
To correlate the readings of a sensor against those of a
known standard
The modification or control of a process or system by
its results or effects


6. Fill in the blanks in each of the sentences below. Choose the correct words from
the following list.

Analysis                         A mouse
Compression                      OMR
Encryption                       A password
A field                          A transaction file
A key field                      Validation
A keyboard                       Verification
A local area network             A virus
A megabyte


   (i)         ___________________ can be of a fixed or variable length.
   (ii)        ___________________ is used to make a file fit in a smaller space in
                                   backing store.
   (iii)       ___________________ is used to prevent use of stolen data.
   (iv)        ___________________ is used to limit access to data
   (v)         ___________________ infects computer systems and can damage
                                   data.
   (vi)        ___________________ needs to be sorted before merging with a
                                   master file.


                                                 71
                                NC ICT
                                Year 10
Brief outline of scheme of work, including topics to be covered:

Unit 1 (60 points)     Skills for Business (Mandatory unit)
                       Creating documents, presentation, database and
                       spreadsheet
Unit 21 (30 points)    Creating computer graphics, using ‘Dreamweaver’,
                       candidate creates menu bar, navigation button
                       and an advertising banner.

90 points = First Award.


Details of any assessments or exams, (including timings):

Assessment is by course tutor who then asks for OCR moderator in to ‘sign
off’ marked work.
No examinations.


Details of any coursework, or equivalent (including timings):

Timings are determined by candidate’s ability.


Any other details:.

Units are in the form of a report with some notes, captures and completed
document print offs.




                                     72
                                 NC ICT
                                 Year 11
Brief outline of scheme of work, including topics to be covered:

Unit 2 (60 points)      Web page creation. The creation of a veterinary
                        surgery website in ‘Dreamweaver’
Unit 20 (30 points)     Creating animation. A 30 second advert for your
                        Website created in ‘Flash’.

For more able candidates, the possibility of more units:

Unit 4 (60 points)      Multimedia products. An in depth presentation.
Unit 22 (30 points)     Creating Sound. A 30 second advertisement for radio


Details of any assessments or exams, (including timings):

Unit 2 and Unit 20 = 90 points - National Award
Unit 4 and Unit 22 = 90 points – First Certificate
Assessment in Year 10
No examinations


Details of any coursework, or equivalent (including timings):

Timings are determined by candidate’s ability.


Any other details:.

See Year 10




                                      73
               NC ICT – Sample exam questions
Unit 1 (year 10) – Presenting information
  (a) Marianne Frazer visits Rome to buy a new type of sausage for the
        restaurants. She decides to send Alberto Rossi a picture postcard
        from his home city.
        Here is the back of the postcard.


                      Postcard
          Hi Alberto
          Found the sausage you
          wanted!
          Looking forward to               Mr Alberto Rossi
          tasting the dish.                Tuscany House
                                           14-34 Ambrose
          Rome is amazing!!!! –                 Court
          just like you said.
                                               Staines
              Luv Marianne XX                 Middlesex
                                               ST4 5PQ
                                              ENGLAND



  (i)        Describe the writing style.
             ___________________________________________________
             ___________________________________________________
             ___________________________________________________
             __________________________________________ (2 marks)
  (ii)       Explain why this writing style is appropriate.
             ___________________________________________________
             ___________________________________________________
             ___________________________________________________
             __________________________________________ (2 marks)
  (iii)      State two ICT-based documents where this writing style can be
             used.
             1. _________________________________________________
             2. _________________________________________________
                                                                (2 marks)




                                     74
Unit 5 (year 11) – Information resources


Caroline works in the Wax Museum. She wants to use her computer to
research some historical figures using the internet.

  (a)   (i) List four items of equipment she will need.
            1. _____________________________________________
            2. _____________________________________________
            3. _____________________________________________
            4. _____________________________________________
                                                                   (4 marks)
        (ii) State the type of software she will need to view the web pages.
            _______________________________________________
                                                                   (1 mark)
  (b)   Give one advantage and one disadvantage of using the internet to
        find information.
        Advantage:_________________________________________
        __________________________________________________
        __________________________________________________
        Disadvantage:_______________________________________
        __________________________________________________
        __________________________________________________
                                                                   (4 marks)
  (c)   Caroline also uses a CD-ROM encyclopaedia to find additional
        information.
        (i) List the steps she would take to find information on Sir Walter
        Raleigh.
        __________________________________________________
        __________________________________________________
        __________________________________________________
        __________________________________________________
                                                                   (3 marks)
        (ii) Caroline has found this information. List the steps she takes to
        transfer it to a word processing document.
        __________________________________________________
        __________________________________________________
        __________________________________________________
        __________________________________________________
        __________________________________________________
                                                                   (3 marks)


                                     75

								
To top