IB Computer Science Year 2 - October 16 2018 Lesson Notes

From Computer Science Wiki

Class plan.png What are we going to learn today?[edit]

Hello Seniors,

  1. we will debrief excel (Please download this file: by clicking on this link (file should download immediately, check your download folder))
  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.

Please use this link as a source of information for factors which might influence life expectancy.


Homework.png What is our home learning?[edit]

  • Please see google classroom


Target.png How am I being assessed today?[edit]

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.

Computer1.png As a computer scientist, you have:[edit]

  • 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

Credit.png Credits[edit]