IB Computer Science Year 2 - October 10 2018 Lesson Notes: Difference between revisions
Mr. MacKenty (talk | contribs) |
Mr. MacKenty (talk | contribs) |
||
(3 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 27: | Line 28: | ||
*** getting help with excel | *** getting help with excel | ||
*** formatting numbers | *** formatting numbers | ||
*** look at formulas | *** look at formulas | ||
*** 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 sheet | |||
*** Build a simple store | |||
*** if time: sumif() | |||
Latest revision as of 09:24, 10 October 2018
|
|
|
|
|
|
|