From Computer Science Wiki
What are we going to learn today?[edit]
Hello Seniors,
- we will debrief excel (Please download this file: by clicking on this link (file should download immediately, check your download folder))
- we will ensure everyone understands sumif()
- we will ensure everyone understands if()
- https://exceljet.net/excel-functions/excel-if-function (keep in mind they use comma as a separator, we use a semicolon)
- 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.
|
What is our home learning?[edit]
- Please see google classroom
|
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.
|
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
|
Credits[edit]
|