IB Computer Science Year 2 - October 10 2018 Lesson Notes: Difference between revisions
Mr. MacKenty (talk | contribs) |
Mr. MacKenty (talk | contribs) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 14: | Line 14: | ||
* We start with a reflection | * We start with a reflection | ||
* We will discuss our last test | * We will discuss our last test | ||
* We will learn about Microsoft Excel | * We will learn about Microsoft Excel | ||
* Please note people make their entire careers using excel, entire businesses are run using excel. our goal is for you TO BECOME FAMILIAR | |||
** [https://support.office.com/en-us/article/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb This is a good guide from Microsoft] | ** [https://support.office.com/en-us/article/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb This is a good guide from Microsoft] | ||
Line 30: | Line 31: | ||
*** sum | *** sum | ||
*** average | *** average | ||
*** min | |||
*** max | |||
*** count | |||
*** declare a range to sum | *** declare a range to sum | ||
*** understanding which cells a formula references | |||
*** moving formulas around | *** moving formulas around | ||
*** referencing a value in another cell | *** referencing a value in another cell | ||
*** referencing a value in another sheet | *** referencing a value in another sheet | ||
*** Build a simple store | *** Build a simple store | ||
*** if time: sumif() | *** if time: sumif() |
Latest revision as of 09:24, 10 October 2018
|
|
|
|
|
|
|