In this lesson, students will learn how to interrogate a large data set using sorting, filtering and queries in Microsoft Access. This lesson was developed for use with year 9 ICT students (age 13-14). Students will learn: • how to use ascending and descending sorts to find data in a large data set • how to use filters to narrow down search results • how to construct simple and complex queries in a database Resources included: • Lesson presentation • Data set (Microsoft Access database of 721 Pokemon) • Video tutorial demonstrating how to create a query • Quizlet stack of vocab • Teacher version of lesson presentation (complete with answers) • Teacher version of Access database (complete with queries)

An introductory year 7 PSHCE lesson covering cyberbullying. Students learn about key concepts and design an awareness campaign. By the end of this lesson, students should: • Know what cyberbullying is • Know why cyberbullying is important • Understand the consequences of it • Know how to be responsible online • Know how to deal with cyberbullying Vocabulary • Cyberbullying • Trolling • Anonymity Students will be asked to create an awareness campaign about cyberbullying. This should involve designing a logo, agreeing key ideas in groups and designing badges, t-shirts, wristbands as well as posters to spread the message.

Learn about the fundamentals of social research in this third guide to writing an extended essay in ITGS. Updated to meet the new EE criteria for 2017. Students will learn: • about different approaches to research in the social sciences • about content, internal and external validity and how to improve each in their research • how to undertake a survey or interview effectively Resources included • Printable PDF of the guide (30 pages) • Link to Google Slides version of the guide Intended use • This guide was developed specifically for IB Diploma students studying Information Technology in a Global Society (ITGS), but would be of use to any student undertaking their EE in a group 3 subject (Psychology, Economics, Business & Management, etc)

Learn about the required formal elements in this third guide to writing an extended essay in ITGS. Updated to meet the new EE criteria for 2017. Students will learn: • how to write an effective introduction • how to conclude their essay • effective strategies for referencing • how to construct appendices • how to go about reflecting on the EE process Resources included • Printable PDF of the guide (27 pages) • Link to Google Slides version of the guide Intended use • This guide was developed specifically for IB Diploma students studying Information Technology in a Global Society (ITGS), but would be of use to any student undertaking their EE in a group 3 subject (Psychology, Economics, Business & Management, etc)

Large format printable scan of a hand-drawn revision diagram of the SDLC. Useful for revision or for teaching the principles of systems development.

Learn how to tackle the next stage of writing your extended essay in ITGS by conducting secondary research. Updated to meet the new EE criteria for 2017. Students will learn: • how to find reliable, scholarly sources for use in their EE research • how to record their sources when they find them • about the importance of research databases Resources included • Printable PDF of the guide (24 pages) • Link to Google Slides version of the guide Intended use This guide was developed specifically for IB Diploma students studying Information Technology in a Global Society (ITGS), but would be of use to any student undertaking their EE in a group 3 subject (Psychology, Economics, Business & Management, etc)

Learn how to tackle the first stage of writing your extended essay in ITGS by choosing a solid topic. Updated to meet the new EE criteria for 2017. Students will learn: • what makes a good topic for extended essay research • how to go about choosing their topic • how to formulate a research question Resources included • Printable PDF of the guide (23 pages) • Link to Google Slides version of the guide This guide was developed specifically for IB Diploma students studying Information Technology in a Global Society (ITGS), but would be of use to any student undertaking their EE in a group 3 subject (Psychology, Economics, Business & Management, etc).