LESSONS

• 1 FULL VIEW This page aims to familiarise students with the ways in which a database can be used to store, compare and sort information according to various criteria.
• 3 DOING WELL This page looks at the importance of spreadsheets as a business tool.
• 5 IMAGE COUNTS This pages involves students in considering the range of text options available within WP or DTP software, and the way in which text styles can produce various images, especially for companies and organisations.
• 7 MARKET RESEARCH This page asks students to investigate the facilities within IT for generating questionnaires.
• 9 HIGH STREET TRENDS This page looks at the ways in which IT can be used to analyse and present the results of surveys.
• 11 CHRISTMAS PARTY This page aims to make students aware of the facilities within a range of IT applications for enhancing text and layout. Students use word processing, DTP and appropriate graphics software to design stationery for a Christmas party.
• 13 WISH YOU WERE HERE The aim of this page is to focus on the skills required to import text and graphics from CD-ROM and the Internet into documents created by students.
• 15 MR SMITH'S HOLIDAY This page asks students to create a database of information selected from holiday brochures in response to a customer's enquiry. They gather financial information from the same brochures and construct a spreadsheet to manage it.
• 17 THE EXHIBITION The aim of this page is to show ways in which IT can be used to compute complex rosters and generate information for staff.
• 19 JUST FOR YOU! This page shows the importance of mail merge as a business tool.
• 21 NO THROUGH ROAD This page asks students to use DTP to design an eye-catching and informative campaign handout in response to the proposal to build a road through an ancient market town.
• 23 LOCAL INTEREST This page looks at the use of scanners and OCR software for inputting text, and focuses on the skills needed for editing and manipulating text within strict limits of length and page size.
• 25 DO'S AND DON'TS The aim of this page is to make students consider good practice and safe working conditions in computerised business environments.
• 27 OPENING SOON The aim of this page is to look at the potential for IT within simple advertising applications.
• 29 A NEW START Students investigate the use of CAD software or drawing tools to produce materials for a business relocation plan.
• 31 PETTY CASH This page asks students to create a comprehensive spreadsheet for a fund-raising event and compute total figures.
• 33 BEYOND BASICS This page looks at how CAD packages can be used to draw out a floor plan and lay out a range of features within it.
• 35 UPMARKET MOVE Students investigate the possibilities within WP and DTP software for producing a range of business publicity material, including newspaper copy.
• 37 MORE COSTS LESS Students consider how spreadsheets can be used to compute a complex range of quantity related discounts on an office stationery order.
• 39 GNVQ LEVEL 2 INFORMATION TECHNOLOGY CORE SECTION

Additional Resources: Online Assessment

Preview tests forUse of ICT andBusiness Communication delivered via our Yacapaca assessment system.

These tests are part of a larger assessment resource which can be foundhere.