Wednesday, October 18th
October 17, 2017 1:46 PM
The next application we will be working with with be MS Excel. Excel is a powerful spreadsheet application that can be used in a variety of ways in a variety of applications.
You will be watching a series of videos introducing Excel. While you are watching the video have an excel file open and practice the steps that are demonstrated, this will reinforce what you are watching so you will be able to use it in later exercises.
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: - these are the titles listed on the side under Contents.
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 (or your Desktop if you don't have an H: drive) titled Excel and save all excel exercises there.
Begin Spreadsheet Exercises 1-3
Before beginning exercise 2 watch the following tutorial:
PMT: Calculating a loan payment
Homework
News article due Friday - paste to school loop - Focus - the impact on the digital divide. If this focus is not applicable for your article choose a more related focus to write about.
Travis and Jack O will present their news articles this Friday.
Read pages 187-195
Begin work on Criterion B - Analysis - due next week.
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.