|
|
||
|
|
|
|
|
|
|||||||
| Microsoft's Excel
2013 site
http://office.microsoft.com /en-us/support/getting- started-with-excel-2013 -FX102827997.aspx ------------------------------------- YouTube videos introducing Excel 
10 basic things about Excel 2013 10 min
Excel Tutorial 1: Getting Started with Excel Review Assignments
Excel Tutorial 2: Formatting Workbook Text and Data (Session 2.1) Excel Tutorial 2: Formatting Workbook Text and Data (Session 2.2) Review Assignment – (Page EX123 |
Excel Tutorial
3: Calculating Data with Formulas and Functions
the Tutorial file is named
Review Assignment
Case 1 Hernandes.xlsx
emailed Feb 6th the Levitt.xlsx file to all students The homework Review is to do the Market.xlsx file, and show it to the prof Feb 23rd the Market.xlsx file was emailed to all student Feb 6th Case 1 Bertrand.xlsx
|
Excel Tutorial 5: discussed March 9th Working with Excel Tables, (Session 5.1 & 5.2)
Excel Tutorial 6: Managing Multiple Worksheets and Workbooks
Excel Tutorial 8:
|
Group Project
Presentation
discussed March 9th video intro by Prof. Kanitz Group Project
Presentation
Tips
|
|||||||
| Jan
12th no class
Jan 19th intro to the course Jan 26th Prof Kanitz Tutorial 1, 2 |
Feb 9th Tutorial 4 Feb 23rd Test No. 1 Feb 25 - Mar 03 break week |
March 9th Tutorial
5
March 16th Tutorial 6 March 23rd Tutorial 8 |
March
30th Test No. 2
April 6th Presentations April 13th Presentations |
| Mode
of Evaluation
(Grading Structure) |
Two
Excel Tests
Weekly Homework Assignments Weekly In-Class Review Exercises Group Project o Written Report o Presentation to the class |
40%
(20% each) Feb 23, Mar 30
14% over 6 classes 21% over 7 classes 25% - 10% for the Project Report - 15% for the Project Class Presentation |
Learning Outcomes
Upon successful completion of this subject the student will be able to:
1. Design, construct and
use MS Excel spreadsheets that will provide information to support decision
making and problem solving in a business environment.
2. Format workbook text
and data and correctly use number formats, cell styles and conditional
formatting
3. Translate equations into
Excel formulas, understand function syntax and change cell references between
relative and absolute
4. Effectively use the following
functions: SUM, MIN, MAX, AVERAGE, COUNT, COUNTA, TODAY, ROUND, IF, AND,
OR, VLOOKUP, PV, FV, PMT.
5. Perform what-if analysis
using trial and error and goal seek
6. Analyze and chart data
using a variety of chart types
7. Utilize Excel tables
to manage large amounts of data
8. Manage multiple worksheets
and workbooks
9. Apply basic design and
layout principles to produce professional presentation aids, incorporating
text, graphics, and transitions
10. With a team, formulate,
organize and deliver a professional, informative presentation to a specified
audience in a pre-determined period of time.
11. Work effectively as
a team member by demonstrating reliability, effective communications, and
attention to all assigned deadlines.
12. Prepare and present
an effective oral presentation using PowerPoint slides as a visual aid.
13. Prepare a formal business
report using MS Word
14. Demonstrate the ability
to work effectively as a member of a team
15. Use e-mail on a regular
basis, and send spreadsheets and word-processed documents as email attachments.
16. Demonstrate the ability
to submit assignments on time.
|
Week
|
Classroom
Session
|
Self-Study
Session & Homework
|
|
1
|
Introduction
to Course
Managing
Your Files
|
Excel
Tutorial 1: Getting Started with Excel
Review
Assignments – (Page EX59)
|
|
|
|
|
|
2
|
Review
& Case Work - Excel Tutorial 1
|
Excel
Tutorial 2: Formatting Workbook Text and Data (Session
2.1)
Excel
Tutorial 2: Formatting Workbook Text and Data (Session 2.2)
Review
Assignment – (Page EX123)
|
|
3
|
Review
& Case Work - Excel Tutorial 2
|
Excel
Tutorial 3: Calculating Data with Formulas and Functions (Session 3.1)
Excel
Tutorial 3: Calculating Data with Formulas and Functions (Session 3.2)
Review
Assignment – (Page EX248)
|
|
4
|
Review
& Case Work - Excel Tutorial 3
|
Excel
Tutorial 4: Analyzing and Charting Financial Data (Session 4.1)
Excel
Tutorial 4: Analyzing and Charting Financial Data (Session 4.2)
Review
Assignment – (Page EX248)
|
|
5
|
Review
& Case Work - Excel Tutorial 4
|
Study
Effective Oral Presentations
|
|
6
|
Review
Effective Oral Presentations
Oral
Presentations Quiz
Group
Project Assignment
|
Study
for Test #1
|
|
7
|
Excel
Test #1
|
Excel
Tutorial 5: Working with Excel Tables, (Session 5.1 & 5.2)
Submit
Finished Session 5.2 File
|
|
|
Reading
Week
|
Group
Project Work – Outline
|
|
8
|
Review
Excel Tutorial 5.1 & 5.2
|
Excel
Tutorial 6: Managing Multiple Worksheets and Workbooks (Sessions 6.1 &
6.2 only)
Submit
finished Session 6.2 File
|
|
9
|
Review
Excel Tutorial 6.1 & 6.2
|
Excel
Tutorial 8: Working with Advanced Functions (Sessions 8.1 and 8.2 only)
Submit
finished Session 8.2 File
|
|
10
|
Review
Excel Tutorial 8.1 & 8.2
|
|
|
11
|
Group
Project Presentations
|
|
|
12
|
Group
Project Presentations
|
|
|
13
|
Excel
Test #2
|
|
|
|
CONTACT I MAIN PAGE I NEWS GALLERY I E-BIZ SHORTCUTS I INT'L BIZ SHORTCUTS I MKTG&BUSINESS SHORTCUTS I TEACHING SCHEDULE |
| . | |
MISTAKES
ITEXTS
USED I
IMAGES
I RANK
IDISCLAIMER
I STUDENT
CONTRIBUTORS I FORMER
STUDENTS I PUBLICATIONS
I  |
|
| . |
