Wednesday, November 1st

November 1, 2017 12:44 PM

Complete Excel Exercises Part 1 - What If Tables, Vlookup, Excel as a Database - Today is the last day to turn in these assignments.

Discussion of Macros, Money Managers, Mathematical Visualization, Statistics and Data Analysis - Google Trends, gas prices and prius sales, Computer Modeling and Simulation, GIGO
Complete Modeling/Simulations questions

Complete Excel Exercises Part 2

Introduction Chapter 6 - Graphics, Digital Media, and Multimedia
Introduction to Graphics - image size- adjusting, file types, web vs print media and dpi, 8 bit color = ?, Graphics Editors
Lynda.com - What is Fireworks
Disappearing People Exercise
Macromedia Fireworks
Fireworks Part 2

 

Homework

Read pages 208-214
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.

Complete Modeling/Simulations Questions - submit to school loop.

Web Style Guide by Patrick J. Lynch and Sarah Horton - read sections A List of Reminders and The Site Development Process (skim this section pulling out the information that is helpful to you at this stage in your project development).

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.

Criterion C Check Friday - be ready to show me your criterion C with up to date entries.

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, formatting, template, spell check, grammar check, ASCII/unicode, PDF, RTF, text, tutorial software, training software, wizards and assistants, help menu and help features,
“Read Me” files

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
• 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.