Join our RSS feed

Subscribe to our RSS feed for the latest updates to the site.

What's New - September 2007

30/09/07

Added the following video tutorials for Excel (with sound):

Copying a worksheet

Deleting a row

Inserting a footer

Inserting a column

Inserting a row

Showing formulas

Hiding formulas

Using autofill

Absolute Cell Reference

Picking up a value from the same sheet

Picking up a value from another sheet

 

29/09/07

Added the following video tutorials for Excel (with sound):

Average formula

Counta formula

Countif formula

IF formula

Max formula

Min formula

Multiplication formula

SUM formula

SUMIF formula

Drop down list

Protecting cells

Validation range check

 

28/09/07

Added the following video tutorials for Excel (with sound):

Adding borders

Colouring background cells

Changing column widths

Conditional formatting

Currency data type

Merging cells

Row heights

Tabs - renaming

Wrapping text

Deleting a column

Deleting a worksheet

Inserting a worksheet

Moving a worksheet

 

 

27/09/07

Added a PPT on the transformation of data into information for BTEC Level 3, Unit 3. Kindly contributed by Dominique Stainton.

Added a PPT on sources of information for BTEC Level 3, Unit 3. Kindly contributed by Dominique Stainton.

Added a crossword and answer sheet about data and information for BTEC Level 3, Unit 3. Kindly contributed by Dominique Stainton.

26/09/07

Added an alternative assignment for Level 2 BTEC First Unit 3 or 7 on creating a 'who wants to be a millionaire quiz'. Kindly contributed by Dominique Stainton

Added a SoW for Level 2 BTEC First Unit 12. Kindly contributed by Dominique Stainton

Added a two assignments for Level 2 BTEC First Unit 12. Kindly contributed by Dominique Stainton

Added a resources list for Level 2 BTEC First Unit 12. Kindly contributed by Dominique Stainton

Added a PPT for BTEC Level 3, Unit 3 on the source and characteristics of business information. Kindly contributed by Dominique Stainton.

Added the following pages to the glossary:

  • data subject
  • dbms
  • demodulate
  • demo version
  • developer
  • dialogue
  • digital certificate
  • digital signature
  • disaster planning
  • document
  • dongle
  • dreamweaver
  • drill down
  • dynamic address
  • fax
  • handshaking
  • help desk
  • malicious damage
  • modulate
  • open source
  • sensitive data
  • soft copy

 

25/09/07

Added a new interactive Bingo quiz for GCSE DTP

Added a new interactive 'Save Your Team' quiz for GCSE Robotics

Added a new interactive 'Save Your Team' quiz for GCSE SLC

Added a new interactive 'Breakout' quiz for GCSE Types of computer

Added a new interactive 'Breakout' quiz for GCSE Storage devices

Added a new interactive 'Breakout' quiz for GCSE Parts of the computer

Added a new interactive 'Spot the Teacher' quiz for GCSE Storage Devices

Added a new interactive 'Breakout' quiz for KS3 Unit 8.1

Added a new interactive 'Rebuild it' quiz for KS3 Unit 7.5

 

24/09/07

Added the weekly news quiz for w/c 17th September 2007

Added a BTEC National level 3 Student tracker. Kindly contributed by Dominique Stainton

Added 11 sets of lecture notes for BTEC Nationals Level 3, Unit 3 (information systems). Kindly contributed by Dominique Stainton

Added the following pages to the glossary:

  • sitemap
  • source code
  • ssl
  • tape streamer
  • unix
  • web server

 

23/09/07

Re-wrote a mini-website which could be used as an introductory lesson for KS3 Unit 9.1.

Added a workbook to support the mini-website for Unit 9.1 which aims to encourage students to work independently.

Added a new PPT for AS level about capabilities and limitations of ICT. Kindly contributed by Fat Max

Added a new task sheet for AS capabilities and limitations of ICT. Kindly contributed by Fat Max

Added the following pages to the glossary:

  • css
  • data commissioner
  • ddr
  • ebook
  • epaper
  • firefox
  • gigahertz
  • google
  • headphones
  • kilohertz
  • linux
  • logic bomb
  • megahertz
  • normalisation
  • pda
  • plotter

 

22/09/07

Added an idea by Vivien Mercer for a lesson to run just before the Christmas holiday, called 'the twelve days of Christmas'

Added the following pages to the glossary:

  • accent
  • acceptable use
  • access time
  • adaptor
  • adc
  • address
  • algorithm
  • alphanumeric
  • alpha testing
  • anchor
  • annotation
  • antivirus
  • assembly language
  • atm
  • auxillary store
  • beta testing

 

20/09/07

Added a new topic to the 'What is .....?' section about Plasma Displays

Added theory notes and a new workbook for ECDL Module 1 on Internet, Intranets and Extranets

Added the following pages to the glossary:

  • Backing storage
  • Banner advert
  • CD-R
  • Cell Phone
  • Defrag
  • Firewire
  • Leased Line
  • Non Volatile Memory
  • Relative reference
  • Speech recognition
  • Terabyte
  • Volatile memory
  • Wi-Fi

 

19/09/07

Added a new topic to the 'What is .....?' section about Ethernet

Added theory notes and a new workbook for ECDL Module 1 on Computer Networks

18/09/07

Added the weekly news quiz for w/c 10th September 2007

Added theory notes and a new workbook for ECDL Module 1 on Software Development

Added a resource for AS OCR 2512 514b on serial, sequential and hashing file access. Kindly contributed by Julia Stevens.

Added a new PPT for AS level about control of information. Kindly contributed by Fat Max

Added a new task sheet for AS control of information. Kindly contributed by Fat Max

Added the following pages to the glossary:

  • Semantic
  • Table

17/09/07

Added theory notes and a new workbook for ECDL Module 1 on GUI

Added the following pages to the glossary:

  • Cell reference
  • Data type
  • LCD screen
  • Logging
  • Plasma screen
  • Remote control
  • Scanning
  • Touch screen
  • Tracker ball
  • Transaction file

 

16/09/07

Added a new interactive 'Breakout' quiz for KS3 Unit 7.1

Added a new interactive 'Rebuild it' quiz for KS3 Unit 7.1

Added a new interactive 'Breakout' quiz for GCSE Bits and Bytes

Added a new interactive 'Bingo' for GCSE Programming Languages

 

15/09/07

Added a new interactive 'Save Your Team' quiz for GCSE Communication

Added a new interactive 'Save Your Team' quiz for GCSE Work & Employment

Added a new interactive 'Save Your Team' quiz for GCSE Programming Languages

Added a new interactive 'Save Your Team' quiz for GCSE Validation & Verification

Added a new interactive 'Save Your Team' quiz for KS3 Unit 8.4 Spreadsheets

Added a new interactive 'Save Your Team' quiz for DiDA E-portfolio

 

14/09/07

Revamped the mini-website for GCSE Internet

Added a new interactive 'Bingo' starter/plenary for GCSE computer control

Added a new interactive 'Bingo' starter/plenary for GCSE software

Added a new interactive 'Bingo' starter/plenary for GCSE parts of a computer

Added a new interactive 'Bingo' starter/plenary for GCSE storage and memory

Added a new interactive 'Bingo' starter/plenary for GCSE networks

 

13/09/07

Added a new interactive 'Bash the Word' quiz for GCSE Computer Crime

Added a new interactive 'Bash the Word' quiz for GCSE Ecommerce

Added a new interactive 'Bash the Word' quiz for GCSE Banking

Added a new interactive 'Bash the Word' quiz for GCSE Utility Programs

Added a new interactive 'Bash the Word' quiz for GCSE Spreadsheets

Added a new interactive 'Bash the Word' quiz for GCSE Programming

Added a new interactive 'Bash the Word' quiz for GCSE LOGO

Added a new interactive 'Bash the Word' quiz for GCSE Graphics

Added a new interactive 'Bash the Word' quiz for GCSE DTP

Added a new interactive 'Bash the Word' quiz for GCSE Validation & Verification

Added a new interactive 'Breakout' quiz for GCSE Word Processing

Added a new interactive 'Breakout' quiz for GCSE Web Design

Added a new interactive 'Maze' quiz for GCSE Internet and URLs

Added a new interactive 'Build It' quiz for GCSE Health and Safety

 

12/09/07

Added two new teaching resources for BTEC Level 3, Unit 1 about effective commuication. Kindly contributed by Dominique Stainton.

Added a new factsheet for AS level about input, process, output, feedback. Kindly contributed by Fat Max

Added a new interactive revision task for AS data, information and knowledge. Kindly contributed by Fat Max

 

11/09/07

Added the weekly news quiz for w/c 3rd September 2007

10/09/07

Added theory notes and a new workbook for ECDL Module 1 on CPU and computer performance

Added theory notes and a new workbook for ECDL Module 1 on software and operating systems

09/09/07

Added a new interactive game making tool to create a hangman style game based on a football theme. Called 'save your team'.

Added an interactive 'save your team' game for KS3 Unit 7.1

Added an interactive 'save your team' game for KS3 Unit 7.3

Added an interactive 'save your team' game for KS3 Unit 7.4

Added theory notes and a new workbook for ECDL Module 1 on storage devices

08/09/07

Added theory notes and a new workbook for ECDL Module 1 on types of computer

Added theory notes and a new workbook for ECDL Module 1 on input devices

Added theory notes and a new workbook for ECDL Module 1 on output devices

 

07/09/07

Added theory notes and a new workbook for ECDL Module 1 on hardware, software, peripherals and storage sizes

06/09/07

Added a resource for AS/A2 Systems Life Cycle. Kindly contributed by Cathy Brown.

Added the following pages to the glossary:

  • Audience
  • Bus Network
  • Column
  • Fitness for purpose
  • Output Device
  • Power Supply Unit
  • Presentation
  • Ring Network
  • Row
  • Save
  • Star Network
  • User Name

05/09/07

Added a resource for raising awareness of the six strands of unit 1 in the DiDA course. Kindly contributed by Sal Milki.

Added an interactive quiz to GCSE Input Devices (breakout)

Added an interactive 'bash the word' quiz to GCSE Databases

Added an interactive 'bash the word' quiz to GCSE Computer control

Added an interactive 'bash the word' quiz to GCSE software

Added an interactive 'bash the word' quiz to GCSE storage and memory

Added an interactive 'bingo' quiz to GCSE Output Devices

Added an interactive 'maze' quiz to GCSE Health and safety

Added an interactive 'maze' quiz to GCSE Parts of a computer

Added an interactive 'racing' quiz to GCSE Internet

Added an interactive 'racing' quiz to GCSE Output Devices

Added an interactive breakout quiz to GCSE Output Devices

Added an interactive multiple choice quiz to GCSE Output Devices

 

Added the following video tutorials (with sound) for PPT:

Creating a hotspot

Adding animation

Changing animation

Re-ordering animation

Removing animation

Slide Transitions

Autosave function

Adding sound clips

Adding your own sound file

 

04/09/07

Added two new PPT resources for AS data, information and knowledge. Kindly contributed by John Dunthorne.

Revamped the GCSE mini-website for Work, Employment and ICT

Added the weekly news quiz for w/c 27/08/07

Added the following terms to the glossary:

  • Automatic
  • Procedure

03/09/07

Added the following terms to the glossary:

  • Corporate Image
  • Graph
  • Install
  • Instruction
  • Integrity
  • Interrupt
  • IRC
  • Iteration
  • Kerning
  • Keypad
  • Machine Code
  • Natural Language
  • Prototype

 

02/09/07

Added a completely new section to the KS3 area on Internet Safety. Tasks, movies and quizzes included.

Added five further BTEC documents to the administration section. Kindly contributed by Dominique Stainton.

01/09/07

Added a new section to 'what is' entitled 'what is ... packet switching?'

Added a completely new section to the site, BTEC. This section has been made possible by the generosity of Dominique Stainton who has kindly shared all of her resources for the BTEC First and BTEC National.

Added the following terms to the glossary:

  • Cell
  • Deskilling
  • Smart Card
  • Top Down Design

 

 

Copyright © www.teach-ict.com