Data
Out of the data used for your excel practice, which is an example of primary data?
Options: Height of girls, temperature of water, reaction time of drivers
Temperature of water, because we recorded this ourselves.
What is the name of the variable you measure within an investigation?
Dependent variable
What is the definition of a zero error?
When the instrument is not set to zero before the measurements are taken
What must you add to your graph for it to be "complete"?
Trendline/Line of best fit, Axis titles
What type of graph will you be asked to create in the excel test?
A scatter plot
What is the difference between qualitative and quantitative data?
Qualitative: Data that can be observed but not measured.
Quantitative: Measurements that have a unit attached. (QUANT = Numbers)
Ms. Sutherland carried out an investigation to understand the relationship between the time students spent revising and the student tests scores. Which is the independent variable?
The time students revised for the test.
What is the difference between an error and a mistake?
Errors are unavoidable variations that will always occur, where as mistakes can be controlled and avoided.
What is the name of the function that combines cells and aligns the text within those cells?
Merge & Centre
Explain how to calculate the margin of error when you are using an average?
Calculate the difference between the average and the largest obtained result and the difference between the average and the smallest obtained results. The larger of the two is the margin or error.
What is secondary data? Give an example.
Data that someone else has found out
e.g. data and information you find on the internet, in books, in newspapers and interviews.
During our temperature data collection, what were two controlled variables that should have been accounted for?
Amount of water in the cup. If the thermometer was moved around in the water. How long since the kettle boiled before the water was put in the cup.
What is the difference between accuracy and precision?
Accuracy is a measure of how close your values are to the true value.
Precision is a measure of how closely your successive measurements agree with each other.
Explain how to calculate an average in excel.
Type "=avg", select average and highlight the cells that you want to average.
Explain what must be included in your hypothesis for your to receive full marks for this section in your report.
Proposes the pattern or trend that will be found with reference to the DV and IV, including a well explained reason (including scientific reasoning) for expecting this result.