Free lesson resources for teaching Data Science NPA (National Progress Award) Levels 4,5 and 6.
This lesson covers how to create new variables by calculations in Excel, specifically,
- Creating variables by performing calculations
- Using Excel to create new calculated variables
- Introduction to conditional formulas
- Using conditional formulas in Excel
Lesson content,
A PowerPoint/PDF presentation, ‘Creating new variables by calculation in Excel’
Excel Question workbook on ‘Creating new variables by calculation in Excel’’ (for learners)
Excel Answers workbook on ‘Creating new variables by calculation in Excel’’ (for teachers)
Planning document with learning intentions and sucess criteria
For more information on the Data Science NPA, please see teachdata.science
This lesson has been created by effini in partnership with Data Education in Schools, The Data Lab and Data Skills for Work, with funding from the Scottish Government.
© 2021. This work is licensed under a CC BY-NC-SA 4.0 license.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have downloaded this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.