IB Computer Science Year 2 - October 10 2018 Lesson Notes: Difference between revisions
Mr. MacKenty (talk | contribs) (Created page with " __NOTOC__ <table cellspacing="10" style="width:100%;"> <tr> <td style="width:50%; margin:0; margin-top:10px; margin-right:10px; border:1px solid #dfdfdf; padding:0 1em 1em 1...") |
Mr. MacKenty (talk | contribs) |
||
(4 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 | ||
** https://support.office.com/en-us/article/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb | * 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] | ||
** We will learn about: | |||
*** ribbons | |||
*** workbook / worksheets | |||
*** rows | |||
*** columns | |||
*** cells | |||
*** resizing | |||
*** moving around | |||
*** getting help with excel | |||
*** formatting numbers | |||
*** look at formulas | |||
*** sum | |||
*** average | |||
*** min | |||
*** max | |||
*** count | |||
*** declare a range to sum | |||
*** understanding which cells a formula references | |||
*** 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
|
|
|
|
|
|
|