Friday, October 20th
Rally Schedule 8:30 - 9:55
October 19, 2017 9:22 PM
Travis and Jack O will present their news articles today.
Introduction to Spreadsheets - formatting cells, stretching, autosum, autofill, formulas
Autofill with formulas, Absolute References, Tools > Formula Auditing, Ctrl + `, Payment FunctionCondo for sale - video of the condo - what will my monthly payment be? What would my salary have to be in order to afford this considering that banks do not want your montly payment to exceed 40% of your montly income? What professions would support this?
Login to Lynda.com (in the login page select "Login through your oganization" and enter seq.org then login just like you would for google docs.)
Find the following video series:
Excel 2013 Essential Training with Dennis Taylor
Watch the following videos:
Entering Data with Autofill - an extremely powerful feature that will save you lots of time
Creating Simple Formulas: Totals and Averages
Copying Formulas for adjacent cells.
Working with relative, absolute, and mixed references
Using SUM and AVERAGECreate a new folder on your H: drive titled Excel and save all excel exercises there.
Begin Spreadsheet Exercises 1-3
Working 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
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?
Homework
Begin work on Criterion B - Analysis - due next Friday
Terms: wysiwyg, DTP, Intellectual property, software (application), shareware, public domain, freeware, commercial software, integrated software, user manual, registration card, serial number, warranty, copyright, licence (multi-user, single user, site licence), compression/decompression, back-up, back door (trapdoor), upload/download, wizard, template, GUI, command-line interface, voice recognition.
What
3.8 Software
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 is important that the ITGS student is aware of the benefits of creating accurate spreadsheets, models and simulations as well as the social impacts that could result from simulations being unable to replicate the real world, and the ethical issues that may arise during the development of the model.
Possible scenarios
Students are expected to carry out practical activities using spreadsheets, for example, the development of a spreadsheet that allows a teacher to add marks from a class test so as to generate information such as the grade for the test.
Students are expected to use modelling and simulations to reinforce their theoretical knowledge, and to apply the ITGS triangle to a range of real-life scenarios.
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 what spreadsheets are used for and their particular applications to solve real world problems is a valuable skill.
How
By being able to create a variety of spreadsheet workbooks and scenarios.