IB Computer Science Year 2 - October 16 2018 Lesson Notes

From Computer Science Wiki
Jump to: navigation, search

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

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?

  • Please see google classroom


Target.png How am I being assessed today?

I will assess you formatively today, and make a professional judgement to what extentConsider the merits or otherwise of an argument or concept. Opinions and conclusions should be presented clearly and supported with appropriate evidence and sound argument. 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:

  • 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