Software Tools (IST 203, Sec. 3)
Fall 2008 (Monday & Wednesday)
12: 15 pm to 1: 30 pm
Cleveland State University
Instructor: Sanchita Mal-Sarkar
Office Location: BU 345
E-mail:
Web page: http://grail.cba.csuohio.edu/~sanchita/sanchita.html
Work phone number: 216 523 7524
Office Time: 2:00 pm – 4:00 pm (M/W), 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 a flash drive. Each student needs to save all of his assignments in his flash drive. Highly recommended: simnet® online access.
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:
Assignments / 100 / 20 %
Project / 50 / 10 %
Midterm / 150 / 30 %
Quiz / 50 / 10 %
Final / 150 / 30 %
Grading Scale:
Grading Scale450 - 500 = A
400 - 449 = B+, B
350 - 399 = C+, C
300 - 349 = D
299 or less = F
Last day to drop: (Without W grade) Friday, Sep 5, 2008 (at 8:00 pm)
Last day to Withdraw: (With W grade) Friday, Oct 31, 2008 (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: Monday, Dec 8, 2008 from 1:00 pm – 3: 00 pm in 17A.
Assignments:
You are not allowed to submit your assignment through e-mail.
All assignments are due at the beginning of the last day of class (December 3, 2008). 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.Assignment must be submitted in a folder with a cover page. A cover page includes 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:
Assignments will not be accepted after the last day of class (December 3, 2008).
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/25/2008 M / IntroductionWindows: Exploring the Basics & Working with Files
8/27/2008 W / Windows: Exploring the Basics & Working with Files
9/1/2008 M / No Class / Labor Day
9/3/2008 W / Essential Computer Concepts
9/8/2008 M / Essential Computer Concepts
9/10/2008 W / MS Office Word – Creating & Editing a Document
9/15/2008 M / MS Office Word – Revising & Refining a Document
9/17/2008 W / MS Office Word – Revising & Refining a Document
9/22/2008M / MS Word – Creating Reports & Tables
9/24/2008 W / MS Word – Creating Reports & Tables
9/29/2008 M / Review for Midterm
10/1/2008 W / Midterm / Midterm
10/6/2008 M / MS Excel – Creating & Editing a Worksheet / simnet® online will be introduced
10/8/2008 W / MS Excel – Creating & Editing a Worksheet, Charting Worksheet Data
10/13/2008 M / No Class / Columbus Day
10/15/2008 W / MS Excel – Charting Worksheet Data
10/20/2008 M / MS Excel – Managing & Analyzing a Workbook
10/22/2008 W / Review and Quiz on Excel / Quiz
10/27/2008 M / MS Excel – Managing & Analyzing a Workbook
10/29/2008 W / MS Access: Creating and maintaining a Database
11/3/2008 M / MS Access: Modifying and Filtering a Table and Creating a Form
11/5/2008 W / MS Access: Modifying and Filtering a Table and Creating a Form
11/10/2008 M / MS Access: Querying Tables & Creating Reports
11/12/2008 W / MS Access: Querying Tables & Creating Reports
11/17/2008 M / MS Power Point – Creating a presentation
11/19/2008 W / MS Power Point – Modifying & Creating Graphic Objects (Animation)
11/24/2008 M / MS Power Point – Modifying & Creating Graphic Objects (Animation)
11/26/2008 W / MS Power Point – Work on Project Presentation
12/1/2008 M / MS Power Point – Student Project Presentation
12/3/2008 W / MS Power Point – Student Project Presentation / Turn in all in-class assignments