Software Tools (IST 203, Sec. 51)

Fall 2007 (Tuesday & Thursday)

4: 00 pm to 5: 15 pm

ClevelandStateUniversity

Instructor: Sanchita Mal-Sarkar

Office Location: BU 345

E-mail:

Web page:

Work phone number: 216 523 7524

Office Time:9:30am – 11:30 am (Mon), 1 pm – 3 pm (Fri), other time by appointment.

Prerequisite:None

Number of Credits: 3

Course Objective:

  • Understand the basic concepts of computer information technology and its terminology.
  • Learn the features of windows operating environment, word processing, spreadsheets, presentation graphics, Internet, electronic mail, and external database searching.
  • As a part of this course, students are expected to use Microsoft Word, Excel, Access, and Power Point, to solve business problems.

Text:The O’Leary Series Microsoft Office 2007 and Microsoft Windows XP, Timothy J. O’Leary and Linda I. O’Leary, Volume 1, McGraw-Hill Irwin, Custom Edition – Cleveland State University.

PHIT Tip - Ethical and Effective Internet Searching, Prentice Hall, 2007

Supplies:Each student is required to have three 3 1/2" floppy disks (1.44 MB). These diskettes are required for assignments. Each student needs to save all of his assignments from jump drive to disks and then turn in the disks and the printouts on the last day of instruction.

Grading Scheme:

Your course grade is based on your overall performance through the entire semester.
The relative weights for the final grade are the following:

Item / Points / Percentage
Assignments / 100 / 20 %
Project / 50 / 10 %
Midterm / 150 / 30 %
Quiz / 50 / 10 %
Final / 150 / 30 %

Grading Scale:

Grading Scale
450 - 500 = A, A-
400 - 449 = B+, B, B-
350 - 399 = C+, C
300 - 349 = D
299 or less = F

Last day to drop: (Without W grade) Friday, Sep 7, 2007 (at 8:00 pm)

Last day to Withdraw: (With W grade) Friday, Nov 2, 2007 (at 8:00 pm)

Examination Policy:

All examinations and quizzes are closed book and closed notes. Dates of the midterm and quiz are provided in Course schedule.

Final Exam Date: Tuesday, Dec 11,2007from 4:00 pm – 6: 00 pm in 17A.

Assignments:

You are not allowed to submit your assignment through e-mail.

All assignments must be individually and independently completed and must represent the effort of the student turning in the assignment. If two or more students submit substantially the same solution, in the judgment of the Instructor, the solution will be considered a group effort. Both or all involved in a group effort will receive a zero for that assignment. A student submitting a group effort assignment more than once will automatically receive a "F" for the course.

All assignments are to be completed by computer - handwritten assignments will not be accepted.All assignments should be turned in on December 6, 2007 at the beginning of the class. There must be a cover page indicating your name, student id, class, section, and a list of all assignments with due dates. You will lose points if you do not include a cover page.

Late Assignments:

An assignment is to be turned in at the beginning of the class period in which it is due. No late assignment will be accepted.

Make-Up Exams:

Make-up exams will be given only in the case of serious need and only when the instructor is notified PRIOR to the exam time. In case of a missed exam, valid reason must be provided along with supporting document (e.g. doctor's note). The doctor's note MUST state that you were unfit to take the exam, not just that you visited the doctor that day. Without proper documentation, no marks will be given for a missed exam.

Student work for Course Portfolio:

The professor reserves the right to retain, for pedagogical reasons, either the original or a copy of your work submitted either individually or as a group project for this class. Students’ names will be deleted from any retained items.

Course Schedule:

The tentative schedule of topics and their order of coverage is given in the table below. Assignments are subject to change.

Date

/

Topic

/

Special Days

8/28/2007 T / Introduction
Windows: Exploring the BasicsWorking with Files
8/30/2007 Th / Windows: Exploring the BasicsWorking with Files
9/4/2007 T / Essential Computer Concepts
9/6/2007 Th / Essential Computer Concepts
9/11/2007 T / MS Office Word – Creating, Editing, Revising & Refining a Document
9/13/2007 Th / MS Office Word – Creating, Editing, Revising & Refining a Document
9/18/2007 T / MS Word –Creating Reports & Tables
9/20/2007 Th / MS Word –Creating Reports & Tables
9/25/2007T / Review for Midterm
9/27/2007 Th / Midterm / Midterm
10/2/2007 T / MS Excel – Creating & Editing a Worksheet, Charting Worksheet Data
10/4/2007 Th / MS Excel – Creating & Editing a Worksheet, Charting Worksheet Data
10/9/2007 T / MS Excel – Managing & Analyzing a Workbook
10/11/2007 Th / MS Excel – Managing & Analyzing a Workbook
10/16/2007 T / Review and Quiz on Excel / Quiz
10/18/2007 Th / MS Access: Creating and maintaining a Database
10/23/2007 T / MS Access: Modifying and Filtering a Table and Creating a Form
10/25/2007 Th / MS Access: Modifying and Filtering a Table and Creating a Form
10/30/2007 T / MS Access: Querying Tables & Creating Reports
11/1/2007 Th / MS Access: Querying Tables & Creating Reports
11/6/2007 T / MS Power Point – Creating a presentation
11/8/2007 Th / MS Power Point – Creating a presentation
11/13/2007 T / MS Power Point – Modifying & Creating Graphic Objects (Animation)
11/15/2007 Th / MS Power Point – Modifying & Creating Graphic Objects (Animation)
11/20/2007 T / MS Power Point – Work on Project Presentation
11/22/2007 Th / No Class / Thanksgiving Recess
11/27/2007 T / MS Power Point – Student Project Presentation
11/29/2007 Th / MS Power Point – Student Project Presentation
12/4/2007 T / MS Power Point – Student Project Presentation
12/6/2007 Th / Review for Final / Turn in all in-class assignments