Ocean County College
Professor’s Syllabus
Instructor: Mr. Barry Kolb
CSIT-123: Integrated Office Software
Catalog Description: This course is designed to teach the skills necessary to design, produce and integrate documents, worksheets, databases and professional presentations. The course will emphasize a hands-on project oriented approach to problem solving. The student will be using the microcomputer in a Windows environment with a modern integrated office software package (Microsoft Office). Students may not receive credit for both CSIT123 and CSIT 125. Working knowledge of Microsoftä Windows suggested. Open lab time required.
Semester: Spring 2013
Office: Room 221 Technology Building
Phone: 255-0400 X2165
Email:
Office Hours: Tuesday and Friday: 8:15 – 9:15 AM, Monday, Wednesday and Thursday: 9:30 AM - 10:30 AM.
Other Meeting Times: To arrange a meeting with your instructor in addition to the regularly scheduled office hours, please contact your instructor directly by email.
Required Text and other Materials:
Microsoft Office 2010 Ocean County College, Cengage, 2011.
ISBN: 978-1-133-15388-7
1 gb or larger USB flash drive.
Course Learning Outcomes/Objectives:
The student will be able to
· Describe and illustrate the hardware and software requirements for Integrated Office Software.
· Recognize and use various Windows features (menus, title bars, dialog boxes, cascading menus, dragging and dropping, pop-up menus, icons, taskbar and toolbars).
· Use Windows to save and retrieve files, maintain directories and run Office Software.
· Describe file management, word processing, spreadsheet and charting concepts.
· Identify an application using database, graphics, word processing, spreadsheet and presentation software.
· Create and edit documents.
· Format documents with appropriate use of fonts and type styles to improve the appearance of a document.
· Import graphics and use tables in a document.
· Work with multiple documents transferring data between documents.
· Automate work by use of macros and templates.
· Produce a professional looking document project utilizing the word processing techniques presented.
· Create, edit and format a spreadsheet.
· Use functions in a spreadsheet.
· Work with multiple spreadsheets.
· Use charts and graphs in a spreadsheet.
· Produce a professional looking spreadsheet project utilizing the spreadsheet techniques presented.
· Integrate the document and spreadsheet projects.
· Create, maintain, and query a database management system.
· Create and use database forms.
· Create database reports.
· Produce a database project utilizing the database techniques presented.
· Create compound documents containing text, graphics, database, and spreadsheet data.
· Manage shared data among applications.
· Produce and present a professional slide show, utilizing graphs, clip art, charts and special features.
· Integrate word processing, spreadsheets and database into a computer generated presentation application.
General Education Goals Addressed in the Course:
1. To develop the ability to become an independent thinker through mathematical, scientific and philosophical reasoning.
2. To develop the ability to communicate effectively through reading, listening, speaking and writing.
3. To develop the ability to solve problems by collecting, organizing and evaluating information.
12. To develop an understanding of technology and its impact on society and the environment.
13. To foster the curiosity, creativity and desire to become autonomous learners for life.
Course Standards: Students are expected to attend every class and be on time. If a class is missed the student is still responsible for all material and assignments during that class. Assignments submitted late will receive a lower grade. Some assignments cannot be submitted late and assignments more than a week late will not be accepted. Tests must be taken on the announced day and time. If unusual circumstances prevent you from taking the test with your class you must inform the instructor (by email) before the test. Failure to notify the instructor prior to missing a test will result in a 20% reduction in grade.
Attendance Policy: The College does have a class attendance policy that may be found in both the college catalog and the student handbook. Briefly, a student who misses more than 10% of the class sessions may be dropped from the class for non-attendance. A student may withdraw or be withdrawn from a course for the Spring 2013 semester before April 5, 2013 with the instructor assigning a grade of “W” and providing the last date of attendance. If a student stops attending or is administratively withdrawn after this date, an “F” will be assigned.
Grading Scale:
A = 90% and up.
B+ = 89%
B = 80% - 88%
C+ = 79%
C = 70% - 78%
D = 60% - 69%
F = below 60%
Course Outline
Microsoft Word
Tutorial 1 Documents pages WD1 – WD46
Tutorial 2 Editing/Formatting pages WD53 – WD103
Tutorial 3 Multiple Pages pages WD110 – WD155
Tutorial 4 Desktop Publishing pages WD162 - 214
Microsoft Excel
Tutorial 1Worksheets pages EX1 – EX57
Tutorial 2 Formatting pages EX58 – EX109
Tutorial 3 Functions pages EX116 –EX164
Tutorial 4 Charts pages EX170 – EX229
Linking and Embedding pages INT1 – INT19
Microsoft Access
Tutorial 1 Creating a Database pages AC1 – AC43
Tutorial Relationships pages AC49 – AC99
Tutorial 3 Queries pages AC110 – AC159
Tutorial 4 Forms and Reports pages AC165 –AC213
Linking and Embedding pages INT20 – INT35
Power Point
Tutorial 1 Presentations pages PPT1 – PPT63
Tutorial 2 Text and Graphics pages PPT63 – PPT118
Tutorial 3 Media and Charts pages PPT121 – PPT183
Statement of Plagiarism: Submitting material found on the Internet or another student’s work as your own are examples of plagiarism. Students should refer to the student handbook and review Policy #5180.
Statement about Civility: Ocean County College defines civility primarily as the demonstration of respect for others, basic courtesy, reciprocity (treating others as we wish to be treated), and behaviors that create a positive environment in which to learn and to work. [See www.ocean.edu/civility.htm] Cell phone usage, sleeping, playing games, sending text messages and surfing the Internet are not permitted during class.
Evaluation of Student: The final grade combination of the tests and the grade for tutorials, assignments and quizzes. Therefore, each test is 25% of the final grade and the average of all the assignments and tutorials is 50%.
Two tests. [50% of your final grade]
Lab assignments and tutorials (“Hands-on exercises”). [50% of your final grade]
(Tutorials are intended to be in-class activities. They can be made up; however, full credit will not be earned by students not in class.)
Computer Lab: The computer lab for the Computer Science Department is not in the Technology Building. The lab is located in the ICCT Building (Building #12) across lot from the Technology Building. The lab assistant there is familiar with our courses and can assist with any Ocean Cruiser problems as well. Lab hours will be posted once the semester starts.
Campus resources and services: Tutoring is available [a] in the Writing Center for writing assignments in all subject areas, not just English courses, and [b] in the Mathematics Tutoring Center. Tutoring information for all other subjects can be found on the Tutoring page on the college website. In addition, Study Strategy Seminars are scheduled each week and are posted on the college website under “Academics.” More information on college services can be found by using the A-Z index on the college website (for example, under “T” for Tutoring or under “S” for Study Strategy Seminars).
Statement of Accommodation: If there is any student in this class who has special needs because of learning disabilities, or any other special situation, please feel free to come and discuss this with me or a staff member in the Center for Academic Excellence.
Disclaimer: Individual faculty members may make reasonable changes to this course outline exclusive of course requirements, course calendar, and grading procedures.
All individuals should not assume that anything received, sent, or stored in this course or in any course is private. Students’ written work, assignments, and test results may be used anonymously for college assessment purposes. Course content, support materials, and communications (including chats, discussions, emails, and any other forms of communication) may be used for quality assurance purposes by authorized college administrators.
Important Notes
Ocean Cruiser is the official email communication for students at OCC ()
Failure to pay for this course may result in your being dropped for non-payment.
CSIT-123 Page 1 Spring 2013