Key Stage 3 Practical Resources

Subject: Information & Communication Technology
Level: Secondary
Age Group: 11 - 14
Order Number: 8065

Learning and Teaching Aids to meet the needs of the ICT National Curriculum

This resource contains a set of 4 KS3 ICT books for practical use, plus CD-ROM with teacher answer books and student working files. The teacher book provides answers to student worksheets, teaching points for discussion and demonstration, including diagrams. Topics covered provide students with the skills to achieve high levels in various strands of the ICT National Curriculum. The student books are: Corwal Computer Systems; Miracle Medical Centre; Flying High Theme Park; and Logo. Each book contains worksheets with step-by-step instructions of how to complete the tasks, with the aims of the lesson stated at the top; differentiated worksheets; sensible file names for saving work; and printing instruction.

Skills students learn include: use of drawing tools; grouping; re-colouring images; rotating; resizing; using tables; formatting; spell checker; alignment facilities; as well as the use of wordart; clipart; borderart; autoshapes; text wrapping; fill effects; formatting a spreadsheet; inserting formulae; using functions; modelling with profit margins; designing a database table; setting appropriate data types; creating queries using single and multiple criteria fields; using header and footer facility; copying and pasting data to other cells; using the chart wizard to produce a graphical representation of data; adding chart labels; fill effects; text boxes; autoshapes; linking a spreadsheet chart so that updates or changes made will automatically be reflected in the program containing the poster; understanding the difference between copy and pasting a chart or linking a chart using the ole facility; designing a database table; setting appropriate data types; using the print screen facility on the keyboard; adding data to a table; using the form wizard; amending forms in design view; entering records into a form; using a date criteria to search for data; using the label wizard in a report; setting up a newsletter or pamphlet; columns; bullets, borders; importing images, align and distribute evenly; grouping; internet research; copy and paste facility; formatting the spreadsheet; merge and centre; alignment of data; renaming worksheets; using header and footers; adding formulae; fill series; inserting columns; printing formula view; modelling with the data; copying worksheets; using the paste facility; using absolute referencing in formulas; currency; decimal places; autosum function; using the auto filter facility; entering criteria for searching; extension scenarios to model and increase income; setting up custom size vouchers; adding borders; titles; inserting a logo; using text boxes; mail merge wizard; linking to another data source; setting up mail merge fields; typing basic commands; copying and pasting graphics and text for printing purposes; using multiple programs; finding angles of shapes; investigating shape and space – (numeracy component); using repeat commands; recognising mathematical patterns and relationships; defining procedures to build shapes; understanding how build procedures are more efficient commands; devising ‘what if’ questions to explore changing variables; and learning to control the pen up and pen down facility.