Parent Zone|Latest News|Useful Links|Contact Us|HOME   
   Foundation Stage|Junior School|Senior School

Staff and Trustees FAQ Policies Inspection Report Pandemic Flu Plan Job Vacancies Links Assocation


All girls have a core ICT lesson from Infant through to Year 9. The aim is to give them both practical skills in using a computer and an understanding of the impact of technology on their lives.

ICT lessons are taught in dedicated ICT suites using desktop computers. ICT is also used regularly within the curriculum and class teachers have the opportunity to book out laptops for use in their classrooms. Girls are encouraged to use ICT whenever it is appropriate both at home and in school.

Year 7

In addition to the following, the class will be expected to learn touch typing using BBC Dance Mat.

Presentation Software

Powerpoint Presentation on Global Warming and Pollution.

Presentation will concentrate on threats to our planet and solutions to the problems.

Marks will be awarded for:

  • Content
  • Appropriate images and colours
  • Appropriate language – considering the age of the audience.
  • Appropriate music and sounds (see Music Compilation below)
  • Appropriate video – if required
  • Slide transitions and animations.
  • Appropriate slide timings – depending on the reading age of the audience.
  • Narration – using Audacity and Lame.

    Audacity enables speech to be recorded.
    Lame converts speech to an MP3 format to be inserted into Powerpoint.

    • Assessment.
    Class will be given mark sheets and will award marks to their class members. This mark will be used in conjunction with the teachers mark.

    Music Compilation

  • Use Dance E Jay to use music samples to create “Mood” music for their PowerPoint presentations.
  • Convert and export files to MP3 format to enable them to be embedded into their presentations.

    • Desk Top Publishing

    Year 7 will produce five pieces of work.

  • A newsletter about a topic of their choice.
  • A folded menu from a restaurant of their choice – English, Chinese, Indian, American, Italian, Dungeon, Alien!
  • A poster advertising the restaurant.
  • A basic Web Site on their restaurant, with a minimum of three hyperlinked pages.
  • Certificates of merit and seasonal cards.

    • Spreadsheet

  • Enter text and numbers.
  • Add
  • Subtract
  • Multiply
  • Divide
  • Use Sum function.
  • Copying and pasting.
  • Replicating formulae
  • Inserting Columns
  • Inserting Rows
  • Deleting Columns
  • Deleting Rows
  • Conditional Formating. Changes colours if Negative.
  • Changing Cell Format – Number to currency etc
  • Text Formatting. Text wrapping within a cell etc.
  • Creating Charts
  • Changing legends
  • Changing scale

    • Assessment by CLAIT style worksheets.

    Year 8

    In addition to the following, the class will be expected to learn touch typing using Sense Lang software.

    Word Processing

  • Insert text
  • Change Font type and size
  • Change line spacing
  • Cut/copy and paste text
  • Find and replace.
  • Insert Clipart and pictures
  • Format pictures
  • Change margins – right, left, top, bottom.
  • Insert page numbers
  • Insert headers and footers
  • Insert a table
  • Enter and format text
  • Word count

    • Assessment by CLAIT style worksheet.

    Database

  • Create a simple database using table view
  • Create simple queries (searches) using table view
  • Design and create forms from the main database.
  • Design and create forms from their queries.
  • Using OLE fields to embed images into their forms.
  • Use square-bracket queries to assist in searching records.

    • Assessment by CLAIT style worksheets

    Programming

  • Using Alice 2.2 the class will write a programme to animate one of the scenarios in this program.
  • The class will write a short story and direct the camera which is able to be animated separately.

    • Control Technology

  • Using Flowall

    • Year 9

    In addition to the following, the class will be expected to learn touch typing.

    Spreadsheets

    Revise previous exercises which were basic commands using a spreadsheet.

  • Absolute cell addresses.
  • Using Functions
  • Using averages
  • Finding the minimum value in a range
  • Finding the maximum value in a range
  • Count
  • Vlookup tables
  • IF statements and nested IF statements.
  • Goal Seek
  • Pivot tables
  • Linking work sheets
  • Combo Control box
  • Spinner buttons.
  • Scroll bars

    • ICT in Media

  • Animation shop – creating a short animation sequence using models constructed in Art lessons.
  • Video capture and editing. Class will use Digital Blue cameras and software for practicing and Stop Pro Animation software for editing and final shooting.

    • Database

  • Relational Databases definition.
  • Purpose
  • Advantages and disadvantages over a flat file system.
  • Creating a relational database
  • Creating forms
  • Creating reports
  • Creating macros
  • Creating command buttons and assigning them to macros

    • Assessment by Video shop or cinema booking system.

    Programming

  • Class will use Notepad to create Web pages in HTML.
  • Class will learn to Map pictures to enable hyperlinking to other pages.
  • Class will learn to hyperlink words to other pages.
  • Class will upload web pages to WWW.

    • Years 10 and 11

    GCSE ICT
    Students are required to complete work under the following headings:

    Unit 1 Tools and Applications

  • Communications Software

  • Presentation Software

  • Information Handling

  • Spreadsheets

    • Controlled Assessment (30%)

    Unit 2 Using Multimedia and Games Technology

  • Using Graphics

  • Using Digital Video and Sound

  • Games Technology

  • Using Multimedia Assets (Web Design and Creation)

    • Controlled Assessment (30%)

    Unit 3 Understanding ICT Systems in Everyday Life and Its Implications for Individuals, Organisations, Society and the Wider World

  • Knowledge of ICT Components
  • Hardware
  • Software
  • Digital Communication Methods
  • Applications of ICT

    • Assessment by Terminal Examination (40%)

    Further information regarding this course can be found on the Examination Board website www.ccea.org.uk/ict/

    GCSE BUSINESS STUDIES

    This is available to Year 10 girls and is two year course.

    Unit 1: Business Start Up
  • Business Ownership
  • Public Sector
  • Sources of Finance:
  • Mission Statement/Business Aims:
  • Stakeholders
  • Customers
  • Resources of Business:
  • Entrepreneurs:
  • Types of Production:
  • Methods of Production
  • Quality Assurance:
  • Health and Safety
  • Marketing

    • Unit 2: Business Development

  • Cash Flow Forecasts
  • Ratios
  • Break-Even (BE)
  • Recruitment
  • Selection
  • Training
  • Motivation
  • Appraisal
  • Business Success or Failure
  • Business Growth
  • International Business
  • E-Commerce
  • Business Plan

    • Assessment

    Unit 1 External Written Examination 1 hour 20 minutes (35%)

    Unit 2 External Written Examination 1 hour 40 minutes (40%)

    Controlled Assessment: Research: 12 hours Report: 3 hours (25%).

    Further information about the course can be found on the Examination Board website at http://www.ccea.org.uk/business_studies/

       © 2007 Wykeham House SchoolTelephone: 01329 280178Fax: 01329 823964