for Secondary Education in the UK.
Publications My Downloads Yacapaca Blog
Select subject

Getting up to Speed in ICT

Price: £25.00
Age Range: KS3 KS4 KS4+

Designed to transform complete beginners into confident and competent ICT users, this resource focuses on using Microsoft Office and takes students to CLAIT level in Word Processing, Spreadsheet and Database technology. Can be used as a KS3 course or as a dip-in resource for older students who may have missed out on a basic ICT grounding. Designed for use with Windows '95, Windows '98 and Windows NT.

Order this publication:

Quantity Format
Choose delivery option (book, CD or download) at checkout.
Size: 63 Pages
ISBN: 978 1 86025 270 9
Author(s): Mark Leighton
Code: GUSI
Popularity rank: 300

Teachers who bought this publication also bought:

Contents List

LESSONS

Introducing the computer and the Windows environment

  • 7 OPENING WINDOWS This page introduces students to the Windows environment and provides them with the skills to navigate the desktop.
  • 9 KEY TO THE KEYBOARD The work on this page familiarises students with the layout and functions of the keyboard.
  • 11 MY COMPUTER Students investigate file storage and access paths, and learn how to navigate the hard drive.
  • 13 ON THE NETWORK This page helps students to understand how and why networks differ from stand-alone computers.

Word processing

  • 15 MY WORD! This page introduces students to the Word screen and teaches the techniques of basic text input.
  • 17 FORMAT TEXT 1 Activities on this page provide students with practice in the techniques of cutting, copying, and pasting. Students also investigate font types and sizes.
  • 19 FORMAT TEXT 2 Students learn different types of formatting and experiment with the effects they can create.
  • 21 SETTING THE TABLE This page shows students how to create tables and insert them into documents, primarily as a formatting exercise to improve presentation.
  • 23 LEARNING YOUR LINES The activities on this page enable students to appreciate how word processors can enhance text for a particular audience.
  • 25 TAKE A FLYER This page enables students to use specific word processor tools to create a document for a particular audience.
  • 27 ON THE MENU This page enables students to practise using word processing tools to create a piece in a particular style.
  • 29 FINDING THE SOURCE This page makes students aware of different information sources and how these might be incorporated into a word-processed document.

Spreadsheets

  • 31 SPREADSHEET FORMAT 1 This page introduces students to the idea of cell references in spreadsheets, and they also start to enter data into spreadsheets.
  • 33 SPREADSHEET FORMAT 2 This lesson introduces students to more advanced spreadsheet tools to enhance presentation.
  • 35 SPREADSHEET FORMULAS This page introduces students to the idea of calculation formulas in spreadsheets to manipulate data quickly and accurately.
  • 37 SAVING FOR A BIKE This page introduces students to the idea of using the mathematical formulas in the spreadsheet to model outcomes.
  • 39 SPREADSHEET FUNCTIONS Students learn more about spreadsheet functions, and how they can be used to further automate the processing of data.
  • 41 BREAKING EVEN This page reinforces the concept of using the mathematical formulas to model outcomes in the spreadsheet.
  • 43 HOTEL MODEL SPREADSHEET This page asks students to produce a business spreadsheet model of their own - and use it to present information clearly and accurately.
  • 45 WEATHER REPORT This page shows students how spreadsheets can process data and present it in graphical form.

Databases

  • 47 YOUR CLASS DATABASE This page introduces students to the idea of database fields and records.
  • 49 DEFINING DATA This page asks student to consider the different types of data, and the various fields that can accommodate them. They also start to consider the practical aspects of creating a database for a specific purpose.
  • 51 THE HOTEL DATABASE This page asks students to put their theoretical knowledge of databases into practice, as they design a working database for the Fellside Hotel.
  • 53 DATA CAPTURE Students consider the issues involved in designing effective data capture forms for a database.
  • 55 YOU HAVE A FRIEND! Students learn how to make database interfaces more user-friendly.
  • 57 SEARCHING A DATABASE The aim of this page is for students to learn how to conduct database searches and save their searches for future use.
  • 59 DATABASE REPORTS This investigative session shows students how reports can be produced from databases.
  • 61 HELP! This page teaches students to access and use online help services in any software package where they are available.
  • 62 GLOSSARY
  • 63 APPENDIX (to accompany KEY TO THE KEYBOARD, page 9)

Reviews

31/05/00

Neil Stanley at Computer Education

The strength of these materials lies in their origins in the classroom - hopefully allowing "many wheels to be not re-invented".
Was this review helpful to you?