DIT5 Processing data with spreadsheets personal learning checklist

Pearson BTEC Tech Award Digital Information Technology · Component 2 · Internal Pearson-set assignment

Demonstrate skills with your own work and explanations. These practice tasks do not replace the current assessed assignment.

Name ____________________ Class __________ Date __________

Tick one box per statement. Red: need help. Amber: partly confident. Green: can do independently.

I can	Red	Amber	Green
C2.B1 · Preparing and calculating
Import external data and split fields using appropriate text-to-columns methods
Use arithmetic formulae and SUM AVERAGE MIN and MAX accurately
Use relative absolute mixed and named cell references when copying formulae
Sort complete records and filter using numeric and text conditions
Apply IF AND OR and NOT with appropriate boundary tests
Use SUMIF COUNTIF COUNTBLANK and COUNTA for their distinct purposes
Use exact-match VLOOKUP and HLOOKUP and test lookup failures
Build a what-if model and explain its assumptions and limitations
C2.B1 · Preparing and calculating
Group and ungroup detail and choose appropriate subtotal operations
Link worksheets and use comments views and conditional formatting purposefully
Create and test a macro for a repeatable navigation or chart task
Test formulae ranges lookups and linked outputs systematically

Next revision priority: __________________________________________________