Monday, October 23rd
Collaboration Day
October 24, 2017 7:43 PM
Begin work on Criterion B - Analysis - write up your justification for the solution you and your client chose to solve the problem you identified in Criterion A.
Lynda.com - Creating a First Web Site in Dreamweaver CC 2014 with Paul Trani - Chapter 1 Planning and Designing a Web Site - this may help you with your specs
What software is available? The software must be available at school unless you will be bringing a laptop to class.Complexity Requirements for ITGS Project - did you include at least three applications you will use in creating your project?
How to enter multiple lines in the same cell - alt + enter
How to enter vertical text in a cell -Visualizing Data - Creating charts in Excel
Review Spreadsheets - formatting cells, stretching, autosum, autofill, formulas
Autofill with formulas, Absolute References, #########, Tools > Formula Auditing, Ctrl + `, Payment FunctionWorking with mutliple sheets - formatting cells, stretching, autosum, autofill, formulas - Watch the Lynda.com video - Excel 2013: Advanced Formulas and Functions with Dennis Taylor - Chapter 1 - Creating 3D Formulas to gather data from multiple sheets
Continue Spreadsheet Exercises 1-3
Car Payments and Loan Calculations
Homework
Review pages 196 - 203
News article due Friday - post to school loop - focus this week - explain how the technology works, this will require more research.
Landon and Charles will present news articles FridayContinue work on Criterion B.
Key terms—cell, cell format (number, text, value, function, calculation, date, currency), row, column,
label, macro, replicate, template, worksheet, “what if” questions, range, absolute and relative reference, GIGO
What
3.2 Software
System utilities
• Defragmentation/optimization and disk utility software
• Backup, file management, account and accessibility management
• Monitor and keyboard settings, for example, international settings, disability settings
Why
Understanding what your operating system allows you to take full advantage of all of the features it offers. Being able to make use of different interfaces allows greater access to the capabilities or your computer.
How
By being able to install hardware devices and the required drivers for that hardware.