Scribd
Upload
16 views2 pages

Year6 Formula Function DataCollection Homework

This document outlines a Year 6 computing homework assignment focused on formulas, functions, and tools for data collection. It includes sections for identifying formulas and functions, understanding spreadsheet operations, matching data collection tools to descriptions, and selecting appropriate tools for specific situations. Additionally, it prompts students to discuss the advantages of spreadsheets and to consider the best tools for storing student information.

Uploaded by

Shereen Lina
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
16 views2 pages

Year6 Formula Function DataCollection Homework

This document outlines a Year 6 computing homework assignment focused on formulas, functions, and tools for data collection. It includes sections for identifying formulas and functions, understanding spreadsheet operations, matching data collection tools to descriptions, and selecting appropriate tools for specific situations. Additionally, it prompts students to discuss the advantages of spreadsheets and to consider the best tools for storing student information.

Uploaded by

Shereen Lina
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Year 6 Computing – Written Homework

Topic: Formula, Function and Tools to Collect Data

Name: _________________________ Class: __________ Date: __________

Instructions: Answer all questions. This is a written homework.

Section A: Formula and Function


1. Tick (✔) whether each example is a Formula or a Function.

Example Formula Function

=A1+B1

=SUM(A1:A5)

=B2*4

=AVERAGE(C1:C3)

2. What symbol must all spreadsheet formulas and functions start with?

________________________________________

3a. What does the SUM function do?

________________________________________

3b. What does the AVERAGE function calculate?

________________________________________

Section B: Tools Used to Collect Data


4. Match the tool to the correct description.

a) Data logger

b) Questionnaire
c) Online form

Descriptions:

1. Collects answers by asking people questions

2. Automatically records data using sensors

3. Collects responses using the internet

5. Choose the best tool for each situation.

a) Recording temperature every hour in a science experiment: ____________________

b) Collecting favourite food choices from students: ____________________

6. State one advantage of using a spreadsheet to collect data.

________________________________________

Challenge Question (Optional)


Which tool is best for storing a large amount of student information and why?

________________________________________

You might also like