From Computer Science Wiki
|
|
Line 12: |
Line 12: |
| Hello Seniors, | | Hello Seniors, |
|
| |
|
| # we will debrief excel | | # we will debrief excel (Please download this file: [https://computersciencewiki.org/images/2/2d/SchoolStoreUpdatedVersion.xlsx by clicking on this link] (file should download immediately, check your download folder)) |
| # we will ensure everyone understands sumif() | | # we will ensure everyone understands sumif() |
| # we will ensure everyone understands if() | | # we will ensure everyone understands if() |
Latest revision as of 08:17, 16 October 2018
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]
|