3: We bought a zoo! Unit focus: Spreadsheet skills, image editing, data handling, web page editing Lesson 1 Spreadsheet Model – Lesson aims: Students can create simple formulas Students can adjust a model to answer If?” questions ‘What Lesson outline: Explain the scenario (your Aunt bought a zoo on a whim and needs some IT help) Students download the spreadsheet file from the VLE First 4 sheets are about creating simple formulae. Next sheet needs completing to calculate costs for the zoo animals Students adjust the values in the spreadsheet to answer the questions If time allows screengrab and annotate a report for Aunt on how to – use / edit / adapt the spreadsheet model Lesson 2 Gift Voucher – Lesson aims: Students can add text and images in a graphics package Students can rotate and scale images Lesson outline: Explain the idea that Aunt Mabel wants a gift voucher to sell Demonstrate some real examples prompt for what works well – Demonstrate a few skills importing images, drawing shapes, resizing – and rotating Students created a gift voucher Extension: Students create a similar-but-different voucher for different denominations (£5, £10, etc…) Lesson 3 Database – Lesson aims: Students can add, edit and remove records Students are of some key terminology Students can create simple queries Lesson outline: Explain that some people buy annual memberships to the zoo Students download and edit the database file using the worksheet: Edit / delete and add some records Perform some simple queries
3: We bought a zoo! Unit focus: Spreadsheet skills, image editing, data handling, web page editing Lesson 1 – Spreadsheet Model Lesson aims: Students can create simple formulas Students can adjust a model to answer ‘What If?” questions Lesson outline: Explain the scenario (your Aunt bought a zoo on a whim and needs some IT help) Students download the spreadsheet file from the VLE First 4 sheets are about creating simple formulae. Next sheet needs completing to calculate costs for the zoo animals Students adjust the values in the spreadsheet to answer the questions If time allows – screengrab and annotate a report for Aunt on how to use / edit / adapt the spreadsheet model Lesson 2 – Gift Voucher Lesson aims: Students can add text and images in a graphics package Students can rotate and scale images Lesson outline: Explain the idea that Aunt Mabel wants a gift voucher to sell Demonstrate some real examples – prompt for what works well Demonstrate a few skills – importing images, drawing shapes, resizing and rotating Students created a gift voucher Extension: Students create a similar-but-different voucher for different denominations (£5, £10, etc…) Lesson 3 – Database Lesson aims: Students can add, edit and remove records Students are of some key terminology Students can create simple queries Lesson outline: Explain that some people buy annual memberships to the zoo Students download and edit the database file using the worksheet: Edit / delete and add some records Perform some simple queries
Computing%20KS3%20Schemes%20of%20Work.docx