ISMT E-120

1. Desktop Applications for Managers Overview ISMT E-120

2. Desktop Applicationsfor Managers • Objectives • Assignments and Grades • Topics • Administration • Books

3. Objectives • Manager’s Perspective on Desktop Software • Enhance Productivity • Sharing Info and Workgroups • Insight on Current Trends • Web Integration

4. Desktop Applicationsfor Managers • Objectives • Assignments and Grades • Topics • Administration • Books

5. Assignments and Grades • 72% Lab Assignments • 6% Class Participation • 22% Final Presentation • Check Grades On-Line • Late assignment policy

6. Late Assignment Policy

7. Self-Evaluation Foundations Document Templates Macros Office Forms MS Access Mail Merge Integrated Query OLE (Object Linking & Embedding) Document Hyperlinks Web Pages Visio Final Project Assignments Submit Assignments via Drop Box

8. Class Participation • Be Prepared • Share Your Experience • Final Project

9. Final Project • Build a Web Site • Include examples of things learned in class • Present Project to Class

10. Grades • 94 – 100% for As • 82 - 93% for Bs • 71 - 81% for Cs Academic Integrity is important

11. Desktop Applicationsfor Managers • Objectives • Assignments and Grades • Topics • Administration • Books

12. Topics • Standardizing and Automating Work • Introduction to MicroSoft Access • Integrating Applications • Office for the Web • Group Collaboration

13. Standardizing and Automating Work • Custom Document Templates • Macros • Office Forms • Visio (later in the semester)

14. Introduction to MS Access • The Minimum • Relational Databases • Access Database Objects • Creating a Database • Database Design

15. Integrating Applications • Clipboard, Exporting & Importing • Mail Merge – Excel & Access • Integrated Queries • Object Linking and Embedding • Hyperlinks

16. Office for the Web • Your FAS Server Space • HTML Basics, Publishing • Static Web Pages • Dynamic Web Pages • Querying Web Sources • Integration Through Internet Explorer

17. Considerations for Group Collaboration • Group Work Environment • Document Management • Collaborative Tools/Software

18. Desktop Applicationsfor Managers • Objectives • Assignments and Grades • Topics • Administration • Books

19. Administration • Lectures • Lab Section • Web Site • Communications • Office Hours

20. Lectures • Where: 53 Church Street, Room 202 • Start at 5:30 • End about 7:20 • Interact & contribute!

21. Lab Section • Where: 53 Church Street, Room 202 • When: 7:35 – 9:35 p.m. • Attendance optional

22. Web Site • http://courses.fas.harvard.edu/ext/12531

23. Communications • Internet Access Required • Syllabus • Web site • Use E-mail

24. E-Mail • jean_pfeifer@harvard.edu (Instructor Jean Pfeifer) • ismte120@yahoo.com (T.A. Ali Elmoussaoui)

25. Office Hours • By appointment

26. Desktop Applicationsfor Managers • Objectives • Assignments and Grades • Topics • Administration • Books & Software

27. Books & Software • Recommended Textbook • Special Edition, Using Microsoft Office 2007 Publisher: Que • Available at the nearby bookstores & on-line • On reserve at Grossman Library in Sever Hall • Microsoft Office 2007 (Discounted at TPC) • SecureFX and SecureCRT

28. Questions?