Week 1 Unit 1: Information Technology Systems Digital devices, their functions and use Peripheral devices and media Explanatory Week 2 Computer software in an IT system Emerging technologies Choosing IT systems Scenario – choose an appropriate IT system Week 3 Connectivity Networks Online test Explanatory notes Week 4 Issues relating to transmission of data Online systems Explanatory notes Week 5 Online communities Threats to data, information and systems Explanatory notes Assessments Homeworks
Week 6 Protecting data Online services Online test Explanatory notes Week 7 Impact on organisations Using and manipulating data Explanatory notes Week 8 Moral and ethical issues Legal issues Mock exam Scenario – applying appropriate legislation Week 9 Unit 5: Data Modelling Stages in the decision-making process Spreadsheet features used to support data modelling Explanatory notes Week 10 Using data modelling to consider alternatives Evaluating models Documenting and justifying decisions Assignment A: Models and decision making Unit 5 Assignment A Assessments Homework
Week 11 Functional specification Spreadsheet model design Reviewing and refining data model designs Unit 5 Assignment A Week 12 Developing a data solution Testing the data model solution Reviewing and refining the data model solution Skills, knowledge and behaviours Assignment B: Design, create and evaluate a data model Unit 5 Assignment B Week 13 Unit 6: Website Development Purpose and principles of website products Unit 5 Assignment B Week 14 Factors affecting website performance Assignment A: Website evaluation Unit 6 Assignment A Week 15 Website design Common tools and techniques used to produce websites Client-side scripting languages Unit 6 Assignment A Week 16 Website development Website review Website optimisation Skills, knowledge and behaviours Assignment B: Design and develop a website Unit 6 Assignment B
Week 22 Normalisation Relational database design Scenarios – produce fully normalised database structure Assessments Homework Week 23 Design documentation Practical task: Producing design documentation Practical task: design documentation justification Week 24 Producing a database solution Scenario – creating tables in Design View Week 25 Testing and refining the database solution Database design evaluation Practical task: Producing a database solution Practical task: database design evaluation Week 26 Evaluation of database testing Evaluation of the database Practical task: Evaluation of a database solution Practical task: database solution evaluation Week 27 Unit 3: Using Social Media in Business Social websites Explanatory notes
Assessments Homework Week 28 Business uses of social and issues Assignment A: Evaluating the use of social media in business Unit 3 Assignment A Week 29 Social media planning processes Business requirements Unit 3 Assignment A Week 30 Content planning and publishing Developing an online community Developing a social media policy Scenario – developing a social media policy Week 31 Reviewing and refining plans Creating accounts and profiles Content creation and publication Scenario – content creation and publication Week 32 Implementation of online community building Data gathering and analysis Skills, knowledge and behaviours Assignment B: Develop and implement the use of social media in business Unit 3 Assignment B
Assessments Homework Week 33 Unit 9: IT Project Management Project definitions Unit 3 Assignment B Week 34 Characteristics of project management methodologies Project management structures Assignment A: Project Management – an investigation Unit 9 Assignment A Week 35 Project idea generation and solution creation Feasibility study Project requirements Unit 9 Assignment A Week 36 Project phasing Typical project management processes Assignment B: Project Management in action Unit 9 Assignment B Week 37 Lessons learned from implementing an IT project – project management skills Unit 9 Assignment B