The new H2 Physics syllabus introduces a digital shift: students must now use spreadsheet software for data analysis in Paper 4.
The Essential Spreadsheet Skills You Need to Master
The official syllabus documentation outlines the following skills, which can be assessed in the Practical Examination (Paper 4):
- Data Entry and Import
- Importing Files: You must be able to open and process external data files in .xlsx format.
- Manual Input: Correctly inputting raw data obtained directly from your experiment.
- Organisation: Creating meaningful headers with quantities and units (e.g., Current/A) and ensuring data matches the required precision.
- https://youtu.be/ebnNy5yEkvc?si=y5RmyONJk0PNxVwu (Importing data file)
- Mathematical Operations and Functions
- Operations: Perform calculations including sines, cosines, tangents (and their inverse) using radian, as well as exponentials and logarithms (lg and ln).
- Scientific Notation: Correctly inputting and displaying values in scientific notation (e.g., 3.00E + 14 for 3.00 x 1014 ).
- Formula Duplication: Writing a formula once and using “fill” features to duplicate it across multiple cells efficiently.
- https://youtu.be/Jh0dgU7yAYo?si=pg2T0s1coeNiCokV (Trigonometry and radians formula)
- Numerical Manipulation and Formatting
- Data Type Adjustment: Adjusting formatting for different data types (e.g., number of decimal places or percentage) and duplicating across different cells.
- Graphing and Trendlines
- Scales and Labels: Plotting labeled line graphs and adjusting the scales of both axes for clarity.
- Linear Trendlines: Using built-in functions to add a best fit line through the data points and displaying the equation of the trendline.
- https://youtu.be/d65jx4BhslA?si=kPXyNkYaKi3QwL_o (Plotting graph and trendline)
- Calculas-Based Analysis
- Determining Gradients: Calculating the gradient at a specific point on a curve using change in Y/ change in X.
- Area Under Curve: Determining the area under a curve using numerical methods like the summation of rectangular or trapezoidal area.
- https://youtu.be/0FV4ZGlU540?si=m1B_XRlBInEtQM2_ (Finding gradient of curve)
- https://youtu.be/9heS8lLLVEQ?si=GNtpkA3qHwd4oc1M (Summation of trapezoidal area)