Spreadsheet Modelling, Hypothesis, Graphs, Charts and Testing

What is the task?

• Further develop your understanding of spreadsheets
• Be able to select the appropriate chart or graph

Key Words & Definitions:

• Spreadsheet
• Model
• Graph
• Chart
• Row
• Column
• Cell 
• Cell Reference
• Data
• Hypothesis

Study Skills

Produce study materials for the Year 8 Computer Studies Summer exam.

Practise flip learning and testing which is researching a topic before it is taught in class.

What we are looking for:

To be successful in this ELA you should read the following guidance carefully:

There are 3 Tasks you must complete:

Task 1: Creating Revision Resources

The aim of the ELA is to practise studying theory and to create revision resources.

The revision resources you created MUST be useful and clear in order to help you prepare for the Year 8 Computer Studies exam in the summer term.

What you must do:

• Read through the theory task called
• Spreadsheets, Graphs & Charts
• Testing a Spreadsheet Model
• Then you must produce 2 Revision Resources, one for each theory task
• The revision resource you create can be any of the following:
• Mind Map
• Flash Cards
• Notes
• Or your own method
• All Revision Resources you produce should be in your own words.

Task 2: Checking your Knowledge

Using the Revision Resources you created in Task 1,attempt the followingquiz to the best of your ability:

• Spreadsheet Skills Quiz

Reviewing your results:

• Once you have clicked submit for the quiz,view your score
• Look through your responses, to see those which were correct
• Look at the questions you got wrong, consider these are part of your reflection in Task 3.

Task 3: Review & Reflection

Now you need to reflect upon how well you have done in this ELA.

Answer the following questions in full sentences:

• Did my revision resources help me prepare for the quizzes?
• How well did I do in the quizzes?
• Which topics did I get wrong, and therefore need to revise further for the Year 8 exam?
• Did I create effective revision resources? What do I need to do to improve the revision resources in the future to make them clearer or more useful?

Your Review and Reflection must be written either by hand or using a computer. This must be handed in along with your Revision Resources.

The Revision Resources you create must be kept safe to help you revise for your Year 8 Computer Studies exam you will sit in the Summer term.

If you experience any problems or have any questions regarding the Computer Studies ELA please speak to your Computer Studies teacher. Alternatively, you can contact Mr Mawers in M4 or by emailing: m.mawers@brookfield.hants.sch.uk

Should you need paper copies of the ELA please see Mr Mawers in M4 immediately.

Outstanding Home Learning may include:

Detailed Revision Resources on all the Topics that can then be used by another person for Computer Studies revision.

They must be written in your own words.

Your Revision Resource must be well presented and clearly cover all the topics stated in each task.

Here are examples of flash cards and mind maps to help give you some ideas of how you could create your own.

IMPORTANT: keep all your home learning safe once returned, as you will use it to help you revise for your Year 8 Computer Studies Summer exam.