Monday, October 30th
Collaboration Day

Conintue 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. You will turn in both an electronic copy and a hard copy on Friday.
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

Office 365 free for students - sign up today!

What - Functions: maths, text, logic, date - Using IF functions and relational operators
Using the COUNTIF family of functions, Working with dates and times

Watch the Lynda.com video - Excel 2013: Essential Training with Dennis Taylor - Chapter 10 - If, VLOOKUP, and Power Functions - Get approximate table data with the VLOOKUP function.
Complete Excel Exercise 4B

Complete Excel Exercises Part 1

Begin work on Excel Exercises Part 2

Homework

Review pages 200 - 207

News article due Friday. Focus -find an article this week that focuses entirely on the impact of technology on society. How is technology affecting the way we learn, work, date, develop.....
Jack Z. and Ciara will present Friday.

Conintue 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. You will turn in both an electronic copy and a hard copy on Friday. Save the document as a PDF and submit to school loop.

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

What

3.8 Spreadsheets, modelling and simulations - page 35
Introduction
The increasing capabilities of computers have allowed individuals and organizations to develop software that can be used to test “what-if” scenarios and create simulations and models of real-world events.
Spreadsheets, through the use of worksheets and graphs, can be used to manage, predict using a series of “what-if” scenarios, and display financial details of businesses.

IT concepts to address in this topic
Theoretical and practical concepts for spreadsheets
• Cell types: for example, text, number, date, currency, hyperlinks
• Formulas: relative and absolute cell references
• Sorting, filtering and replicating data
• Types of charts
• Formatting and presentation: for example, text (fonts), background, paragraphs, pages
Syllabus content
36 Information technology in a global society guide
• Data validation, verification and testing
• Functions: maths, text, logic, date
• Protection for sheets and workbooks, cell locking
• Advanced functions: for example, lookup, pivot tables, macros
• Worksheet modelling: “what-if” analysis (scenarios, goal seek tool)

Why

Understanding when and how to use spreadsheets to solve problems is a valuable skill.

How

By completing the excel exercises 1-5.