KS2 Archives - Page 4 of 25 - teachictnt.org.uk

The perfect formula (Google)

Spreadsheet masters – Lesson 2 Objectives Recall features of a spreadsheet Use cell references to complete formulae Use spreadsheets to complete formulae quickly and easily Lesson Resources Teacher’s presentation Student activity sheet Lesson 2 Student worksheet – 1 per child on paper or share via Google Classroom so they have their own digital copy Demonstration…

What is a spreadsheet? (Google)

Spreadsheet masters – Lesson 1 Objectives Explain what a spreadsheet is; Describe how a spreadsheet could be used by someone at work; Label the different areas of a spreadsheet using the correct vocabulary; Create simple formulae in a spreadsheet. Lesson Resources Teacher’s presentation Student activity sheet (Share this link with your class – please see…

All about algorithms

Computational Thinking – Alien Contact! – Lesson 6 Objectives To give precise, unambiguous instructions in an algorithm. To detect and correct errors in algorithms. To recognise and apply computational thinking concepts and approaches to solve problems. Lesson Resources Lesson slides Barrier games worksheet Construction blocks of some kind (LEGO, Multilink etc) Computational Thinking – Alien…

Collaboration with Teams

Communication and Collaboration – Lesson 6 Objectives Understand how to communicate safely and appropriately using video chat tools. Respect the ideas and communications of others they encounter online. Understand the need for certain rules of conduct, particularly when using live forums of communication. Lesson Resources Lesson Slides A ‘teacher’ computer with webcam and microphone suitable…

Collaborative Presentations (Powerpoint)

Communication and Collaboration – Lesson 5 Objectives Understand how to communicate safely using video chat tools. Understand the need for certain rules of conduct, particularly when using live forums of communication. Lesson Resources Lesson Slides Communication and Collaboration Lesson 1 – An Introduction To Email Lesson 2 – Sending and Receiving Attachments Lesson 3 – Collaboration in…

Microsoft Forms

Communication and Collaboration – Lesson 4 Objectives To log into, create and share a collaborative document or application. To work effectively with others on a collaborative document or application. To understand and demonstrate respect for privacy of people’s data. Lesson Resources Lesson Slides Communication and Collaboration Lesson 1 – An Introduction To Email Lesson 2…

Collaboration In The Cloud (OneDrive)

Communication and Collaboration – Lesson 3 Objectives To understand and explain cloud storage To upload a document to cloud storage To log into, create and share a collaborative document or application Understand the need for certain rules of conduct, particularly when using live forums of communication, e.g. chats, forums, live docs Lesson Resources Lesson Slides…

Sending and Receiving Attachments (Outlook)

Communication and Collaboration – Lesson 2 Objectives Log on to an email account, open emails, create and send appropriate replies. Know and apply the school’s rules for keeping safe online and be able to apply these beyond school. Attach different files to emails, e.g. text document, sound file or image. Open and save attachments to…

An Introduction to email (Outlook)

Communication and Collaboration – Lesson 1 Objectives Log on to an email account, open emails, create and send appropriate replies. Recognise the effect that content in their communications may have on others. Understand the need to keep personal information and passwords private in order to protect themselves when communicating online. Know the school’s rules for…

Spreadsheet Masters

About this unit: Hone your spreadsheet skills to become a spreadsheet master! Learn about the basics of spreadsheets with a range of fun tasks. Investigate sorting, using formulas and conditional formatting as you build towards making self-marking quiz games for your classmates. National Curriculum Links – Computing KS2 The content of this plan cover the…