Wednesday, October 25th

 

October 25, 2017 8:26 AM

Excel Quiz 1 Friday!

NOTE: New Seating Chart is coming so be sure to copy all of your excel files to your google drive at the end of today so when you move seats you will still have access to your files.

Your ITGS IA will have a major effect on your 2nd semester grade since the project will be between 100-150 points so put in the work now to make it a high quality report and project.

What?

Protection for sheets and workbooks, cell locking

Proofing spreadsheets - always double check calculations

Visualizing Data - Creating charts in Excel - when do you want a pie chart? line chart? bar chart?
Review Spreadsheets - formatting cells, stretching, autosum, autofill, formulas
Autofill with formulas, Absolute References, #########, Tools > Formula Auditing, Ctrl + `
Payment Function - PMT(rate, nper, pv)

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

Continue Spreadsheet Exercises 1-3
Car Payments and Loan Calculations - Get your car loan spreadsheet checked off today.

Text to Columns - just to make life simpler
Better example of absolute references - open the Page 197 excel file (Exercise #1) and add a new column Percent of Total.

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

Review excel exercises to prepare for excel quiz tomorrow.

Text to Columns - just to make life simpler
Working with mutliple sheets
What if analysis - goal seek, scenarios and data tables.

Working with mutliple sheets - formatting cells, stretching, autosum, autofill, formulas - Watch the Lynda.com video - Excel 2013 Essential Training  with Dennis Taylor - Chapter 14 - Data Analysis Tools


Autofill with formulas, Absolute References, Tools > Formula Auditing, Ctrl + `, Payment Function
Alt + Enter to enter a carriage return for multiple lines in one cell
Spreadsheet Exercise 4

 

 

 

Homework

Read pages 200 - 207
News article due Friday - post to school loop - focus this week - explain how the technology works, this will require more research.
Landon and Charles will present news articles Friday

Prepare for Excel Quiz #1

Continue work on Criterion B - Analysis - did you find the speed of your home connection? The specs of your home PC? What will you use for backup of your files? This will be due Monday of next week.

2.2.2 Databases and spreadsheets
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 - pages 35-36

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.

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

Spreadsheets are a common tool found in both research and business and knowing the capabilities of this tool allows one to determine if it is the correct application for the problem at hand.

 

How

By completing the excel practice and excercises