BIT210: Computer Applications in Management, Spring 2007

Lecturer: Mohammad Ali Javaheri Javid

Contact:

Lectures: Mondays 2.30 – 4.00 (LSBM)

Labs: Mondays 4.15 – 5.45 (Gordon Square, Room G11)

Course Syllabus: BIT210.pdf

Required Textbook:

Debra Gross, Frank Akaiwa, Karleen Nordquist (2005) Succeeding in Business with Microsoft Office Excel 2003: A Problem-Solving Approach, Thomson

 Student Download Centre of the Book: http://www.course.com/catalog/product.cfm?isbn=0-619-26740-2

Online Resources:

http://www.usd.edu/trio/tut/excel/

http://www.quasar.ualberta.ca/edit202/tutorial/spreadsheet/ExcelBasics/ExcelBasics.htm in pdf format (ExcelBasics)

http://www.quasar.ualberta.ca/edit202/tutorial/spreadsheet/RDC-exceltips/exceltips.html

(The last is particularly about relative and absolute addresses in formulae)

Lectures Schedule and Course Materials:

Date	Session	Topic	Reading & Practice
16 April 07	1	Introduction to the course Introduction to Problem Solving and Decision Making	Syllabus Introduction
23 April 07	2	Applying Fundamental Skills	Chapter 1 (Excel Tutorial)
30 April 07	3	Solving Problems with Statistical Analysis Tools	Chapter 2
14 May 07	4	Determining Effective Data Display with Charts	Chapter 3
21 May 07	5	Applying Logic in Decision Making	Chapter 4
4 June 07	6	Retrieving Data for Computation, Analysis, and Reference	Chapter5
11 June 07	7	Evaluating the Financial Impact of Loans and Investments	Chapter 6
18 June 07	8	Organizing Data for Effective Analysis	Chapter 7
TBA	9	Using Data Tables and Excel Scenarios for What-If Analysis	Chapter 8
TBA	10	Advanced Excel Tools	Chapter 9 - 10

Assignments

Assignment ONE : Due on 24 May 2007

Answer to Assignment one

Assignment TWO: DUE on 26 June 2007

Last Modified: 11 Jun 2007