| Intermediate & Advanced Excel Is Fun! BTECH 109 & Busn 214 | |||||||||||
| Spring 2009 | |||||||||||
| Buying Requirements: | |||||||||||
| Custom BTECH 109 book at College Bookstore
Only $43 at college bookstore |
|||||||||||
| Succeeding in Business with MS Excel 2007,
ISBN 978-1-4239-0605-6, Authors: Gross, Akaiwa, Nordquist $73.91 at Amazon |
|||||||||||
| Special Edition Using Microsoft Office Excel
2007, ISBN , Author: Bill Jelen $26.39 at Amazon |
|||||||||||
| USB drive | |||||||||||
| Reasonableness Requirements: | |||||||||||
| When you send an e-mail, put BUSN 214 in Subject line, have a salutation and closing and spell and grammar check it | |||||||||||
| Do your homework and practice a lot because this class will be great fun, hard, and will help you get a job | |||||||||||
| Remember to take the Blackboard Quizzes. They are in the Class Content section of Blackboard | |||||||||||
| Make sure that Blackboard has your current e-mail address | |||||||||||
| The schedule will list the dates when your Test will be e-mailed to you. All test are take-home. | |||||||||||
| After you are done with the test, upload it to Blackboard in the Class Content section | |||||||||||
| Student Outcomes | |||||||||||
| Have Fun with Excel while greatly improving employment possibilities | |||||||||||
| Understand that Excel does two things: Calculations and Data Analysis | |||||||||||
| Understand and apply formatting as façade | |||||||||||
| Understand and
apply formula creation for calculations and data anaylsis, and be able to
create formulas for number calculations, text creation and logical analysis |
|||||||||||
| Understand and apply forumla elemets such as; equal sign, ampersand, built-in functions, arithmetic operators, comparative operators | |||||||||||
| Understand the basics of array formulas | |||||||||||
| Understand and apply efficient spreadhseet construction, including proper data analysis setup, formula setup, and formula input setup | |||||||||||
| Understand and apply keyboard shortcuts to facilitate quick spreadsheet creation | |||||||||||
| Understand Excel data analysis tools such as: Pivot Tables, Sorting, Filtering, Subtotals, and formulas for data analysis | |||||||||||
| Solve business problems by applying Excel knowhow in creative ways | |||||||||||
| Schedule | |||||||||||
| Date | Class Fun and Vblog | Video | Pages from Excel Is Fun book | Do HW | Test Take Home | Blackboard Quiz - take at Blackboard | |||||
| Week1 | Mon,3/30/09 | Basics Reviewed | Highline Excel Class 01: Back To Basic | ||||||||
| Tue,3/31/09 | Basics Reviewed | Highline Excel Class 02: Formulas | pages 1 - 41 | Do any homework on pages 1 - 41 | |||||||
| Wed,4/1/09 | Basics Reviewed | Highline Excel Class 03: Names, Cell References, Assumption | pages 42 - 71 | Do any homework on pages 42 - 71 | |||||||
| Thu,4/2/09 | Basics Reviewed | Highline Excel Class 04: Style & Number Format & ROUND | pages 72 - 104 | Do any homework on pages 72 - 104 | |||||||
| Fri,4/3/09 | Basics Reviewed | Highline Excel Class 05: Charts, Page Setup, Data Analysis | Pages 104 - 143 | Do any homework on Pages 104 - 143 | |||||||
| Date | Class Fun and Vblog | Video | Chapter for Custom BETECH book | Reading pages for Custom BETECH book | Do HW | Test Take Home | Blackboard Quiz - take at Blackboard | ||||
| Week2 | Mon,4/6/09 | Worksheet & Workbook References, SUMIF, VLOOKUP | Highline Excel Class 06: Worksheet & Workbook
References Highline Excel Class 07: VLOOKUP function formula 7 Examples Highline Excel Class 08: 3-D Cell References Add Across Sheets |
p 5 - 20 | Skills Exam on page 57-58 | ||||||
| Tue,4/7/09 | Working with Dates, Text formulas, Concatenate, IS functions | Highline Excel Class 09: SUMIF Function Formula 3 Examples Highline Excel Class 10: VLOOKUP SUMIF & Percentage Increase |
|||||||||
| Wed,4/8/09 | Highline Excel Class 11: Logical formulas, IS & IF functions | p 61 - 108 | Skills Exam on page 111 | ||||||||
| Thu,4/9/09 | Highline Excel Class 12: DATE functions & Formulas | ||||||||||
| Fri,4/10/09 | Highline Excel Class 13: Text functions & AMPERSAND | Test1 points = 60 | |||||||||
| Week3 | Mon,4/13/09 | Pivot Tables, Sort, Filter, Subtotal, List Box | Highline Excel Class 14: How To Setup Data in Excel Highline Excel Class 15: Excel 2007 Tables 7 Examples |
P 113 - 159 | Skills Exam on page 164-165 | ||||||
| Tue,4/14/09 | Highline Excel Class 16: Sort, Sorting 10 Examples Highline Excel Class 17: Filter, Filtering 8 Examples Highline Excel Class 18: Subtotals |
||||||||||
| Wed,4/15/09 | Highline Excel Class 19: Advanced Filter Extract Data 9 Examples | ||||||||||
| Thu,4/16/09 | Highline Excel Class 20: Pivot Tables 20 Examples | ||||||||||
| Fri,4/17/09 | Test2 points = 60 | ||||||||||
| Week4 | Mon,4/20/09 | Conditional Formatting | Highline Excel Class 21: Conditional Formatting 12 Examples | ||||||||
| Tue,4/21/09 | Data Tables, Goal Seek, Scenario Manager | Highline Excel Class 22: Scenarios & Scenarios Report YTLE#103: Excel Goal Seek |
P 167 - 193 | Assignment on page 220 |
|||||||
| Wed,4/22/09 | Importing Data: Delimited, Fixed Width, Access, Web, Text | Highline Excel Class 23: Import Different Types of Data | P 227 - 266 | Skills Exam on page 270 | |||||||
| Thu,4/23/09 | |||||||||||
| Fri,4/24/09 | Test3 points = 60 | ||||||||||
| Date | Class Fun and Vblog | Video | Chapter for Succeeding in Business with MS Excel 2007 | Reading pages for Succeeding in Business with MS Excel 2007 | Do HW | Test Take Home | Blackboard Quiz - take at Blackboard | ||||
| Week5 | Mon,4/27/09 | Order of Precedents, Average Function, Text and numbers, SUM function and the plus sign, 0 in cell, Copy, Paste Special, Operations Add; will convert "numbers as text" to numbers | Highline Excel Class 24: Order Of Precedents Highline Excel Class 25: Fix Problems & Errors In Spreadsheets |
Chapter 01 | Pages 2-53 | Labor Cost HW P 52-53, Labor Comparison HW P 62-64. | |||||
| Tue,4/28/09 | Error Messages, Building Spreadsheets, Fix Other peoples Spreadsheets | Highline Excel Class 26: Fixing Other Peoples Spreadsheets | Chapter 01 | Pages 54-87 | Textured Budget HW P 77-79, Computer Purchase HW P 82-83, Position Analysis HW P 84-85. | ||||||
| Wed,4/29/09 | Custom Number Formatting (CNF), CNF and TEXT function, CNF and Assumption Tables (place to store formula inputs and labels for formula inputs) | Highline Excel Class 27: Custom Number Format & TEXT function | Chapter 01 | Auto Sales HW P 85-87 | |||||||
| Thu,4/30/09 | |||||||||||
| Fri,5/1/09 | Statistics: AVEARGE, MEDIAN, MODE, STDEV, SKEW, COUNTIF, SUMIF functions | Chapter 02 | Pages 88-131 | QC Binding Data Analysis HW P 111-112, Crème Current Sales Analysis P153-155, QC Binding Data Analysis 2 HW P 130-131, La Rosa Demographic Analysis P155-156 | |||||||
| Week6 | Mon,5/4/09 | Statistics: AVEARGE, MEDIAN, MODE, STDEV, SKEW, COUNTIF, SUMIF, RANK, LARGE, SMALL, Charts | Highline Excel Class 28: More Excel Basics Review Highline Excel Class 29: Basic Statistics: Numerical Measures |
Chapter 02 | Pages 131-153 | QC Binding Data Analysis 3 HW P 1149-151 | |||||
| Tue,5/5/09 | More stats | Highline Excel Class 30: SUMIF, RANK & Bonuses Highline Excel Class 31: Histogram & LARGE SMALL functions |
|||||||||
| Wed,5/6/09 | Charts | Highline Excel Class 32: More Charts & SUMIFS & AVERAGEIFS | |||||||||
| Thu,5/7/09 | |||||||||||
| Fri,5/8/09 | Test4 points = 40 | Quiz1 points = 20 | |||||||||
| Week7 | Mon,5/11/09 | AR and IF, AND, OR, NOT, and logic | Highline Excel Class 33: IF AND OR Customer Credit
Analysis Highline Excel Class 34: IF function Formula Payroll Formula |
Chapter 04 | Pages 214-242 | PO527 Credit Analysis HW P242-243 | |||||
| Tue,5/12/09 | AR and IF, AND, OR, NOT, and logic | Highline Excel Class 35: IF Function Vs. VLOOKUP Function |
Chapter 04 | WWC Hiring Analysis HW P276-278 | |||||||
| Wed,5/13/09 | Array Formulas | Highline Excel Class 36: Array Formulas Basics Highline Excel Class 37: SUMPRODUCT function |
Chapter 04 | Pages 243-257 | Unpaid Invoice Penalties P257-259, Painting Job Estimator P 278-280 | ||||||
| Thu,5/14/09 | Highline Excel Class 38: Array Functions TRANSPOSE FREQUENCY | Chapter 04 | . | ||||||||
| Fri,5/15/09 | Chapter 05 | All HW for Level 1 | |||||||||
| Date | Class Fun and Vblog | Video | Chapter for Succeeding in Business with MS Excel 2007 | Reading pages for Succeeding in Business with MS Excel 2007 | Do HW | Test Take Home | Blackboard Quiz - take at Blackboard | ||||
| Week8 | Mon,5/18/09 | Lookup In Excel | Look Series Videos 1 - 15 | Chapter 05 | All HW for Level 2 | ||||||
| Tue,5/19/09 | Lookup In Excel | Look Series Videos 1 - 15 | Chapter 05 | ||||||||
| Wed,5/20/09 | Lookup In Excel | Look Series Videos 1 - 15 | Chapter 05 | ||||||||
| Thu,5/21/09 | Look Series Videos 1 - 15 | ||||||||||
| Fri,5/22/09 | Finance Series Videos All except 7, 9, 10, 11 | Chapter 06 | All HW for Level 1 | Test5 points = 40 | Quiz2 points = 20 | ||||||
| Week9 | Mon,5/25/09 | Finance | Finance Series Videos All except 7, 9, 10, 11 | Chapter 06 | All HW for Level 2 | ||||||
| Tue,5/26/09 | Finance | Finance Series Videos All except 7, 9, 10, 11 | |||||||||
| Wed,5/27/09 | Finance | Finance Series Videos All except 7, 9, 10, 11 | |||||||||
| Thu,5/28/09 | Finance Series Videos All except 7, 9, 10, 11 | ||||||||||
| Fri,5/29/09 | Finance Series Videos All except 7, 9, 10, 11 | Test6 points = 40 | Quiz3 points = 20 | ||||||||
| Week10 | Mon,6/1/09 | Array Formulas | |||||||||
| Tue,6/2/09 | Array Formulas | ||||||||||
| Wed,6/3/09 | Macros | ||||||||||
| Thu,6/4/09 | Macros | ||||||||||
| Fri,6/5/09 | |||||||||||
| Week11 | Mon,6/8/09 | Test7 points = 40 | Quiz4 points = 20 | ||||||||
| Tue,6/9/09 | Total Points possible | 340 | 80 | ||||||||
| Wed, Jun 10 | |||||||||||
| Mon, Jun 15 | |||||||||||
| Tue, Jun 16 | |||||||||||
| Wed, Jun 17 | |||||||||||
| Tue, Jun 10 | |||||||||||
| Percent Grade | Grade | Percent Grade | Grade | ||||||||
| 94.048% | 4 | 74.048% | 1.9 | ||||||||
| 93.095% | 3.9 | 73.095% | 1.8 | ||||||||
| 92.143% | 3.8 | 72.143% | 1.7 | ||||||||
| 91.190% | 3.7 | 71.190% | 1.6 | ||||||||
| 90.238% | 3.6 | 70.238% | 1.5 | ||||||||
| 89.286% | 3.5 | 69.286% | 1.4 | ||||||||
| 88.333% | 3.4 | 68.333% | 1.3 | ||||||||
| 87.381% | 3.3 | 67.381% | 1.2 | ||||||||
| 86.429% | 3.2 | 66.429% | 1.1 | ||||||||
| 85.476% | 3.1 | 65.476% | 1 | ||||||||
| 84.524% | 3 | 64.524% | 0.9 | ||||||||
| 83.571% | 2.9 | 63.571% | 0.8 | ||||||||
| 82.619% | 2.8 | 62.619% | 0.7 | ||||||||
| 81.667% | 2.7 | 61.667% | 0.6 | ||||||||
| 80.714% | 2.6 | 60.714% | 0 | ||||||||
| 79.762% | 2.5 | ||||||||||
| 78.810% | 2.4 | ||||||||||
| 77.857% | 2.3 | ||||||||||
| 76.905% | 2.2 | ||||||||||
| 75.952% | 2.1 | ||||||||||
| 75.000% | 2 | ||||||||||