This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentThis preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
Unformatted text preview: IE 343 Engineering Economics Lecture 15: Tables, Excel and VBA to Solve Chapter 4 Problems Instructor: Tian Ni Sep.26, 2011 IE 343 Fall 2011 1 • Quiz 4 will be given at the beginning of the class 4:30PM – 4:55PM on Wednesday Sep.28 • Quiz 4 will have 4 problems totally 10 points • You will have 25 minutes to finish quiz 4 • Please bring a CALCULATOR to the quiz • All quiz 4 problems will be selected from the following three sources. You will see the same problems but maybe with numbers changed IE 343 Fall 2011 Tips for Quiz 4 2 • Three sources: 1. Homework 4 Problem 110 (solutions for Homework 4 has be posted on Blackboard Vista) 2. Examples on Lecture Notes (please refer to the full version lecture notes for the example solutions) • Lec 9_Full: Example 4.3 – 4.9 • Lec 10_Full: Example 4.10 – 4.13 • Lec 11_Full: Example 4.14 – 4.19 • Lec 12_Full: Example 4.20 – 4.21 • Lec 13_Full: Example 4.22 3. Examples on Textbook • Chapter 4: Example 4.1 to 435 IE 343 Fall 2011 Tips for Quiz 4 3 4:30PM – 5:20PM (50 Minutes) in class WTHR 172 on Friday Sep.30 Three parts: Part 1  Old Problems (Difficulty: Easy) from Homework, Lecture Notes Examples, Textbook Examples Part 2  New Problems (Difficulty: Median) Part 3 – Bonus Problem (Difficulty: Hard) Exam 1 totally 110 Points: Part 1 – 3 problems, totally 70 Points Part 2 – 2 problems, totally 30 Points Part 3 – 1 problem, totally 10 points Note: Exam 1 takes 20% of the total grade. If you get 100 Points, you get 20%. If you get 110 Points, you get 22%. IE 343 Fall 2011 Exam 1 Info 4 You are suggested to do Part 1 first, and then part 2. Part 3 is optional. Please bring a CALCULATOR to the exam For students who need accommodations: Exam 1 will be 80 minutes from 4:30PM to 5:50PM. You will take the Exam 1 in GRIS 333 Conference Room . Please send me and the TAs an email by Tuesday. For students who have another exam right before our exam: Exam 1 will start at 5:00PM and end at 5:50PM. You will take the Exam 1 in GRIS 333 Conference Room . Please send us an email by Thursday. IE 343 Fall 2011 Exam 1 Info 5 All the materials from Chapter 14, Lecture Notes 113, 15, review 1 Lecture Notes 113, 15 Examples, review 1 Chapter 14 Textbook Examples Homework 14 Quiz 14 Please refer to Tips 1, 2, 3, 4 for Quizzes 1, 2, 3, 4. IE 343 Fall 2011 Tips for Exam 1 6 Excel and VBA IE 343 Fall 2011 7 Excel is a spreadsheet application part of the Microsoft Office Suite VBA stands for “Visual Basic for Applications ” and creates a platform to write code for Excel VBA is a universally popular programming language widely used in business data analysis, accounting companies, and financial firms Excel and VBA should not present much of a challenge from a programming standpoint IE 343 Fall 2011 Excel and VBA 8 Code written for Excel are commonly known as macros...
View
Full
Document
This note was uploaded on 01/28/2012 for the course IE 343 taught by Professor Vincent,g during the Winter '08 term at Purdue.
 Winter '08
 Vincent,G

Click to edit the document details