BTEC Level 2 Certificate/Diploma

Unit Title	Tasks, Course Content, and Supporting Materials	Related presentations
Induction	Course Outline 2006 - 2007 Course Calendar 2006 - 2007	Presenting coursework The electronic office
Unit 1: Using ICT to present Information	Tasks Course Content Course Content (Document) Course Content (Presentation) Supporting Materials (N.B. these relate to the specific tasks laid out in Tasks) Example of a memo Example of an email Example of a letter Example of an order form Example of an invoice Example of an agenda Example of meeting minutes Example of a newspaper article Example of a magazine article Example of a newsletter Examples of graphical documents Example of an advertisement Example of a website Example of a leaflet Example of a presentation Example of a text message Example of creative writing Fantastik Records Limited - Headed notepaper
Unit 2: Introduction to Computer Systems	Tasks Course Content Course Content (Document) Course Content (Presentation) Supporting Materials (N.B. these relate to the specific tasks laid out in Tasks) ICT Requirements Computer system comparisons	What is an information system? Describing information systems The components of an information system - Introduction The components of an information system - CPU and types of computer Input and Output Devices - Inputs Input and Output devices - Outputs Storing data - Storing and memory Storing data - Storage devices Computers and the Law Security and backups Computers and your health Output design Software - Operating systems Software - Applications software and programming languages Transferring data Types of computer operation
Unit 3: ICT Project	Tasks Course Content Course Content (Document) Course Content (Presentation) Supporting Materials (N.B. these relate to the specific tasks laid out in Tasks) Project management	Project management Systems analysis
Unit 4: Website Development	Tasks Course Content Course Content (Document) Course Content (Presentation) Supporting Materials (N.B. these relate to the specific tasks laid out in Tasks) Website construction features Basic HTML HTML needed to create a framed website with three pages	HTML Basics
Unit 9: Database Software	Tasks Course Content Course Content (Document) Course Content (Presentation) Supporting Materials (N.B. these relate to the specific tasks laid out in Tasks) Blank memo Blank data table design Examples of database designs Staff telephone list Memo from Donna Wright Exemplar database design	What is a database? How data is stored Data types used in Microsoft Access Creating a database Collecting data Data validation Checking data Creating a data entry form Creating a Query Creating a Report
Unit 10: Spreadsheet Software	Tasks Course Content Course Content (Document) Course Content (Presentation) Supporting Materials (N.B. these relate to the specific tasks laid out in Tasks) Comparison spreadsheets Comparison spreadsheets (showing formulae & functions) Value Added spreadsheet before corrections Value Added spreadsheet before corrections (showing formulae & functions) Value Added data Value Added spreadsheet before corrections and with data added Blank spreadsheet design	What is a spreadsheet? Creating a simple spreadsheet Entering formula Entering text and numerical data Formatting columns and rows
Unit 18: Graphics	Tasks Course Content Course Content (Document) Course Content (Presentation) Supporting Materials (N.B. these relate to the specific tasks laid out in Tasks) Examples of bitmap and vector graphics Sketch plan of the Distribution Department, Woolwich