# IB Computer Science Year 2 - October 16 2018 Lesson Notes

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

## What are we going to learn today?

Hello Seniors,

2. we will ensure everyone understands sumif()
3. we will ensure everyone understands if()
1. https://exceljet.net/excel-functions/excel-if-function (keep in mind they use comma as a separator, we use a semicolon)
2. https://support.office.com/en-us/article/sumif-function-169b8c99-c05c-4483-a712-1697a653039b (keep in mind they use comma as a separator, we use a semicolon)

Today in class (and for homework) you will develop a model (using excel) which predicts life expectancy. I expect to see "an abstract mathematic representation" of life expectancy. A user will enter in relevant information into your spreadsheet, and the spreadsheet should ballpark about when they could expect to die. It is a bit morbid topic, but it can also help you reflect on your choices.

## How am I being assessed today?

I will assess you formatively today, and make a professional judgement to what extent you understand our learning material. I will use observation, your written work, answers to questions, and contribution to class discussions as data to make my decisions.

I will also ask you to complete a self-assessment which I will use to help me guage how well you think you understand our material in class.

## As a computer scientist, you have:

• Confidence in dealing with complexity
• Persistence in working with difficult problems
• Tolerance for ambiguity
• The ability to deal with open-ended problems
• The ability to communicate and work with others to achieve a common goal or solution

## Credits

Consider the merits or otherwise of an argument or concept. Opinions and conclusions should be presented clearly and supported with appropriate evidence and sound argument.