Year 9 ICT Course 2007

1. Tour of School Network

1. Presentation

2. Test

2. AUP features (powerpoint)

3. Presentation

4. Presentation

Answer questions on computers and AUP. Describe the issues that pupils face when using ICT equipment in school.

Video

3. Spreadsheets: Charts

This section introduces major aspects of spreadsheets that should provide transferable skills for use in other subjects such as Maths, Physics and Geography. A range of examples and applications will be studied.

5. Spreadsheets: Charts

6. Spreadsheets: Numbers (integer, real, floating point, currency, dates, times)

7. Spreadsheets: Sequences (1,2,3…, dates, days, etc.)

8. Spreadsheets: Formulae (Fibonacci, population density)

9. Spreadsheets: Functions (SUM, AVERAGE) (Sudoku)

Notes

4. DTP

Either: booklet based on English creative writing

Or: play programme

Or: Boys' guide to the AUP

10. DTP: Publisher Introduce DTP techniques and some GCSE project methods.

11. DTP: Publisher

12. DTP: Publisher

Terminology

1. cables, twisted pair, RJ45 connector, star topology
2. hub, switch, router, wireless access point
3. server, server operating system, nas
4. work station, PC, CPU, processor, Intel/AMD, RAM, hard disk (HDD), graphics card, sound card, LCD monitor, digital projector, laptop, WAP, data logging
5. peripherals, printer, laser printer, ink jet printer, scanner, graphics tablet
6. operating system (Windows, Mac, Linux)
7. IT room/lab, language lab, science lab, library
8. application software, office suite, word processor, spreadsheet, presentation graphics, database, bitmap graphics software, vector graphics software, web design software, desk top publishing, web browser, educational software
9. electronic white board, speakers

Web Resources

Back