Home / Computing KS3 Curriculum Spring

 

What will students study this term?

Year 7

This term students will be working on spreadsheets using Excel.
Students will gain an understanding of the difference between data and information before practising their skills in formatting, use of formulae and functions, data validation, charts, graphs and conditional formatting. 

Year 8

This term students will be creating a website using HTML and a web-based package.

Students will gain an understanding of LAN and WAN, networks and internet protocols before practising their skills in HTML. Students will use basic HTML tags to create a primarily text based webpage and some may include elements of CSS to style it.  To provide contrast, they will then use their design skills to create a website of their choosing using web-based software.

Year 9

In the second term, students will begin to create a digital animation using a piece of software called Adobe Flash Animation.  This unit enables students to develop their creativity whilst at the same time, using Action script to enhance their programming further.  They will learn to create a product for an end user by fulfilling a brief and meeting the needs of their target audience.  In the latter half of the term, students will re-visit spreadsheets, however, this time they will learn about spreadsheet modelling and how this is used to budget for projects.

What assessment will students do this term?

Year 7

Students will be assessed on their spreadsheet skills by completing two 30 minute tests.  The first test assesses their ability to perform calculations using formulae and functions.  The second test assesses their ability to improve the appearance and functionality of a spreadsheet using a variety of formatting techniques. 

Year 8

Students will be assessed on their HTML skills and design techniques by creating two websites. The elements being assessed within the text based website is the students’ ability to use appropriate HTML tags and to troubleshoot programming issues. The assessment of their web-based website will primarily be in their ability to design a stylish and professional looking site with appropriate functionality.

Year 9

Self, peer and teacher assessments will all be carried out at the end of the Flash animation unit.  Students will be assessed, not only in their creativity and ability to manipulate the software but also in being able to follow a brief and meet the needs of a target audience.  Assessment of the spreadsheet unit will take place throughout the entire half-term as students work towards a spreadsheet model to plan a large-scale event.  Skills assessed include use of formulae, functions and formatting. 

What homelearning will be set this term?

Year 7

There is no requirement for students to have access to Excel at home. Students are instructed to practise their spreadsheet skills using Google Sheets which is readily available on their Chromebooks.  Students consolidate their learning in class by demonstrating their new found skills to parents or carers using a range of tasks and activities available via Google Classroom.

Year 8

The homelearning for this term is project based and will be assessed at the end of the term.  Students can access their website on their Chromebooks and should do so regularly to make improvements.  During their computing lessons students will learn how to incorporate new features into their site and this should then be consolidate at home.

Year 9

The homelearning for this term will be in planning and design and will support students in preparing for the final assessment.  Students are not expected to buy Adobe software and will therefore not be expected to work on their project from home, instead they will create plans, storyboards and testing sheets to support their work in class. 

What can we do at home to help with this term’s learning?

Year 7

Ask your child to show you what skills they have learnt using Excel or Google Sheets.  Perhaps they could help you set up some household accounts or practise budgeting for an event.  If you are a parent who uses spreadsheets on a regular basis then talk to your child about how invaluable they are to businesses.  

Year 8

Ask your child to show you what skills they have learnt using the web based software.  Encourage your child to check the spelling of all written content within their website.  Continue to discuss with your child the need to protect their personal information when online.   

Year 9

Discuss the ways in which animation has developed over the years thanks to the advances in technology. Consider the popularity of animation based films and TV programmes and help support your child’s ideas and plans. During the latter half of the term, discuss the need for financial budgets and how these can secure your child’s financial stability. Let them create you a spreadsheet!

What extension project can students complete at home on this topic?

Year 7

Students can use a spreadsheet to budget and plan for an event.  This could be an upcoming birthday party, celebration or holiday.  They should work out the overall expenditure and then calculate the cost per head.

Year 8

Students can use the software to create their very own website.  There are some excellent web-based packages that create professional looking websites. Perhaps they could set up a website for someone they know who runs a business, or for their local sport’s team. 

Year 9

Students can use Excel or Google Sheets to create a spreadsheet for your household shopping budget or in planning a forthcoming event.  Let them teach you how useful spreadsheets can be, not only for calculations, but as data storage software.

What are some great websites that can help with this term’s studies?

www.bbcbitesize.co.uk

www.codeacademy.com

www.code.org

www.khanacademy.org

 

 

Share This