Class:

Section 1:  Tuesday & Thursday

Click here for the Course Schedule:  Section 1

Course Introduction

This is an introductory micro-computing course; as such, it does not cover the advanced capabilities of the Microsoft Office 2000 applications. The course will focus on the basics and students will receive brief overviews (lectures) and hands-on instructional training (lab exercises) for the following applications: MS-Word 2000, MS-Excel 2000 MS-PowerPoint 2000, MS-Access 2000   Collectively, these are the core applications of Microsoft Office 2000 Professional and they offer a smooth transition from Office 97 applications.

We will spend most of our time in the labs so you can receive hands-on instructional training on the computers. Please note: The amount of time you put into using the computer for this class is not restricted to class time only.

The principle objective of this class is allow students the opportunity to acquire the basic knowledge, skills and abilities necessary to make you capable and comfortable using the Microsoft Office 2000 applications. The Microsoft Office 2000 Professional suite of applications is the standard set of software adopted by the School of Public Health to meet our basic academic and curriculum needs. It is important to remember that you will need to use these applications in order to successfully complete course work in the other classes offered here at SPHTM. Most importantly, that you gain sufficient computing skills so you will have a degree of confidence in performing professional work when you finish your degrees and seek professional careers.

Using Microsoft Office 2000 (Platinum Edition), Que Publishing, ISBN#0-7897-1841-3

Running MS Office 2000 Professional, Microsoft Press, ISBN#1-57231-945-3

These books are  available at most book stores (B. Dalton, Borders, Barnes & Noble) and cost around $50.

You are going to be saving most of your work for this class in directories on a single floppy diskette. Everyone is required to have his or her own personal diskette labeled with your name on it.  Note the disk must be a high-density format media type (i.e., 1.44 megabytes).

Handouts

FTP Instructions

Introduction to Microsoft Windows

Introduction to MS Word 2000

Introduction to MS Excel 2000

Introduction to MS PowerPoint 2000

Introduction to MS Access 2000

Recipe Book

1. Overview of Microsoft Office 2000 Professional ® and Windows.
2. Microsoft Windows - Using the Desktop, using the Windows Explorer ®, setting up shortcuts, understanding file associations and file types and managing files and your disks under Windows
3. Microsoft Word ® 2000- Creating saving and printing word documents; Moving, copying, and changing the appearance of text; editing; designing and formatting the look of a page; saving as HTML documents; working with objects and graphics.
4. Microsoft Excel ® 2000-Working in the Excel environment; setting up a worksheet; working with formulas; formatting worksheets; using filters; basic data analysis tools, creating charts; printing reports, creating links to other objects / files.
5. Microsoft PowerPoint ® 2000-Creating a PowerPoint presentation; Working with the slide master, styles, working with graphics, How to add and modify text; applying and modifying templates; produce a slide show, creating links to other objects / files.
6. Microsoft Access ®2000--Setting up a data base, designing tables, viewing data, creating queries, creating forms for entering and viewing data, and working with external data sources (importing tables); getting answers to questions using your data.
7. Demonstrate ability in the integration of 3 or more of the above applications.

Evaluation and Grading

Class Assignments:  Evaluation of your knowledge, skills and abilities will be based on your work on the computer as well as from the written final exam. All assignments and lab exercises will be open notes, open text, open manuals.  You are expected to work independently on the homework assignments.  All  homework assignments must be FTP to our server for grading.  Assignments will be valued at 100 points each.   Class assignments are worth 50% of the total grade.

Final Exam:  There are two parts to the final exam. The first part of the final exam is a written final. The written portion of the exam is closed book.  The second part of the final will be a in-lab practical in which you will be ask to do several things which you learned from the Office 2000 applications (integration of the four packages that we have learned in class) . For the in-lab final exam, you will be allowed to use your text and notes.  The written part of the exam will be handed in to the instructor. The second second portion of the exam will be FTP to our server on the day of the exam.  The final exam (written & in-lab) is worth 50% of the total grade.

Grades

Grades for assignments will generally be available by the next class period.  Comments from assignments will be sent to the student by e-mail.  Grades are posted by the last 4 digits of your student identification number.  Click the appropriate section below to review your grades.

FINAL GRADE CALCULATION:

Weighted Average = Total Homework Score/Total # of possible homework points x 50% + Final Total/100 x 50%

     CLICK HERE FOR GRADES -->      SECTION 1  SECTION 2

If you would like to make a comment regarding your grade or would like to make additional comments about the course, please click here -->  COMMENTS

Homework must be turned in on time, at the beginning of the class in which they are due! If the homework is turned in late, 5 points will be taken off for each day late. Because current lessons will build on previous ones, it is important to keep up with the assignments and exercises.

Instructions for Homework Assignments:

MS-Word:  Assignment 1          Assignment 2

MS-Excel:  Assignment 3   Assignment 4

MS-PowerPoint:   Assignment 5 and 6

MS-Access Assignment #7

Integration Assignment#8

Example of Assignments:

MS Word:  Assignment 1Part A       Assignment1Part B

MS Excel:  Assignment 3    Assignment 4

MS-PowerPoint: Assignment 5

MS-Access:  Assignment  7

Integration:  Assignment 8 Part 1   Assignment 8Part2

Lab Reservations

The PC Lab on the 12^th floor of the Tidewater building is only reserved during the time of the course.  However, you are free to work on your assignments whenever you want outside of regularly scheduled lab time.

If you are working on a PC that has an Internet browser you can access the SPHTM PC brief. This is a general online brief to help students with basic PC information and PC guidelines. For personal assistance, use the SPHTM help desks on the 12^th floor of the Tidewater building. A lab assistant is generally available during open lab hours.

Copyright 2001 Tulane School of Public Health & Tropical Medicine