Friday, November 3rd
November 2, 2017 8:45 PM
Today is the last day to makeup the Excel Quiz 1.
Jack and Ciara will present today.
Intro to Criterion D - your Project Design - The design process and reiteration
Sample of a Site Map - Overall Structure
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).W3Schools is another great resource.
This is a great resource for your web site project. Also check Lynda.com - Plan and Design a Web Site
If you are creating a video or game then you should be working on creating a storyboard for your project.
Show me your current Criterion C - your timeline
Complete Excel Exercises Part 2 - today is the final day of excel. Scenario Manager, Goal Seek, Macro - keyboard shortcuts, Pivot Tables - looking at data in different ways
Prepare for Excel quiz #2 next week - Monday - this quiz is directly from an IB exam. You will need to identify, describe, define and explain
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).
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
Watch the Rubber Stamp Tool video and then complete the Disappearing People Exercise. When you are done there should be no one on the beach (no dogs either). Show me the image when you are done.
Complete Macromedia Fireworks part 1 - books are at the front of the room and the files needed can be found in the ITGS Assignments folder in the Macromedia Fireworks MX2004 folder and in chapter 1 & 2.
Fireworks Part 2Optimizing Graphics in Fireworks
Complete : Macromedia Fireworks
Fireworks Part 2
Homework
Review pages 208-215
Complete On-line Study Guide for Chapter 5 - due before start of class Monday. Email results to cdodge@seq.org
Continue working on Criterion D and continue to update Criterion CDuncan and Mia will present news articles on Monday.
Prepare for Excel quiz #2 next week - Monday - this quiz is directly from an IB exam. You will need to identify, describe, define and explain
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
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.