ITA

1. ITA The biggest game in town Created by S Walkerden Images and music from Microsoft Clipart

2. ITAA Challenge in five levels • ITAis a secret agent who has gone over to the dark side. • Your mission is to recruitITA to work for you • Under no circumstances whatsoever are you to harm or threatenITA in any way

3. ITAA Challenge in five levels

4. ITAA Challenge in five levels: U3O1 Create a prototype web site for an online community • Analyse a problem • Design a solution • Create the solution • Explain network requirements of solution • Explain how solution meets needs

5. ITAA Challenge in five levels: U3O2 Database • Analyse problem • Design database • Project management plan • Prepare plan • Monitor progress • Evaluate solution

6. ITAA Challenge in five levels: U4O1 Create a spreadsheet • Apply the Problem Solving Methodology • Analyse the nature of the problem • Design the solution and output • Apply of a range of processes, procedures and techniques to solve a problem • Useappropriate file management techniques • Write on-screen user documentation • Word document on problem solving strategy

7. ITAA Challenge in five levels: U4O2 Test • One hour • You will be given a description of an organisation • Evaluate effectiveness of strategies to • Meet legal requirements • manage storage • communicate • dispose of data • Recommend improvements

8. ITAA Challenge in five levels: Quest of Quests • You will have two hours in which to convinceITAto join your side • You will be asked to present the evidence that you have gained in written form • 20 questions to be answered in code (A, B, C, D) • Further questions to be answered in language of ITA

9. ITAA Challenge in five levels: Quest of Quests Example of questions requiring coded response • Which type of website would best suit a group of people interested in reading about the daily progress of a traveller? • A. wiki • B. blog • C. forum • D. chat room

10. ITAA Challenge in five levels: Quest of Quests • Example of question using language ofITA • A company that sells CDs and music online collects and stores data about its customers in a database. The order form requires a mailing address, delivery address and email address. • Explain why the company would collect data relating to customers’ orders/purchases. • Recommend two techniques which could be used to protect the rights of the customers whose data is being collected and stored

11. ITAA Challenge in five levels: Weapons and Ammunition File management·          • Access network folders • Create folders • Copy, move and delete files

12. ITAA Challenge in five levels: Weapons and Ammunition Word processing • Choose appropriate font style and size • Create headers and footers • Format graphics appropriately

13. ITAA Challenge in five levels: Weapons and Ammunition Web design and development • Create storyboards to plan a web page • Create and name a new web • Create dynamic template • Add additional pages to existing web • Position text and graphics • Format graphics appropriately • Create hyperlinks

14. ITAA Challenge in five levels: Weapons and Ammunition Databases • Create a new named database • Create a table with specific field types (e.g. text, number, yes/no) • Create validation rules • Create queries to sort, search and calculate • Create reports

15. ITAA Challenge in five levels: Weapons and Ammunition Spreadsheets • Setup workbook with multiple sheets • Format: font, column width, headers and footers • Conditional format • Develop formulae • Produce charts • If statements • Lookup tables

16. ITAA Challenge in five levels: Strategies • Assign priorities • Walk the walk, talk the talk • Read • Textbook • Revision guide • Newspapers • Computer Age • Green Guide • Computer magazines

17. ITAA Challenge in five levels: Strategies • Bring a memory stick or two to every class • This subject is the most important subject that you will study this year. It must be your highest priority!!