CGS2100c - Office Applications

Course Description:

This course focuses on the concepts and operation of the main components of word processor, electronic spreadsheet, database management, and presentation software programs. Students will gain fundamental knowledge of a major software suite and learn skills that have practical application in real world situations. Lab fee required.

Course Objectives: (Student Learning Outcomes: 1.1, 1.2, 1.4, 2.1, 2.2, 3.2, 3.3, 4.1, 4.5)

Use multiple programs available to manipulate files within the a graphical user interface (GUI). Create a word processing document utilizing enhancements and, graphics. Create a spreadsheet utilizing charts, absolute cell references and enhancements. Create a database utilizing multiple forms, reports and queries to answer questions. Create a presentation utilizing enhancements. Work with OLE (Object Linking and Embedding) to fully integrate all programs.

Course ANGEL Site:

This location will be used for the following: View the course syllabus View the course schedule View class announcements Email the instructor or classmate Find commonly used hyperlinks  View assignments View grades Upload Access assignments for grading

Course Schedule:

Meets Tuesdays Meets Wednesdays Meets Thursdays

Textbook:

Textbooks may be purchased at the Seminole State bookstore or ordered online at http://www.scc.bkstr.com/. The following textbooks are normally sold as a shrink-wrapped package in the Seminole State bookstore using ISBN # 978-0538-76415-5 for the bundle: (*Shelly Cashman Series) Microsoft Office 2007: Introductory Concepts and Techniques, Premium Video Edition, 1st Edition* SAM 2007 Projects/Assessment/Training v4.0 (18-digit key code)

Data Storage:

You will need one USB Jump drive (64 MB or more) to backup the files you create and store in class. Drives may occasionally be collected with assignments so always bring assignment files to class. It may be necessary to download certain student files for the MS Office text from the Shelly Cashman website. Instructions for downloading Student Data Files can be found on the inside back cover of the textbook. Or you can copy the files from Seminole State's network: \\Tardis1\Data\Datalib\CGS2100\... (then pick the appropriate application folder/file).

Software Requirements:

For this course, you must use Microsoft Office 2007.  The software you need will contain Microsoft Word, Excel, Access, and PowerPoint. These applications are available to you in all campus labs and libraries. If you would like to purchase these applications for home use: The Seminole State bookstore sells Microsoft Office software for $100 - $250 depending on the suite. The Ultimate Steal is another "provisional" offer for students. For additional information about the Microsoft Office suites, visit http://office.microsoft.com/en-us/suites/default.aspx. *** Please be aware that the Student/Teacher version does NOT contain Access 2007, which you will need for CGS2100/2108, but you can obtain Access for free through the MSDNAA program. *** Any student using college facilities to create or distribute illegal copies of software will be immediately reported to the Office of Student Activities, Athletics, and Judicial Affairs. Students informing other students of where to obtain illegal copies of software will also be reported to the Office of Student Activities, Athletics, and Judicial Affairs.

Course Requirements:

The following scale will be used to determine your final grade out of a maximum of 300 points (330 with 30 points possible extra credit).

A B C D 90 - 100% 80 - 89% 70 - 79% 60 - 69% 270 – 300 240 – 269 210 – 239 180 - 209

The points to be used in determining your final grade are obtained by adding the points you get on the following:

Your scores on exams for a maximum of 100 points: Word (25 points) Excel (25 points) Access (25 points) PowerPoint (25 points) Your scores on assignments for a maximum of 190 points: Word (45 points) Excel (45 points) Access (45 points) PowerPoint (30 points) Integration Project (25 points) Attendance will be worth the remaining 10 points.

Network, E-mail and Internet Access:

Each semester, when the network administrator inputs network login ID's, they are created as locked or disabled. For your first time logging on an Seminole State computer, EVERY student MUST login using MYID to unlock their account to use campus computers. (Distance Learning students may come to campus to do work, but will not be able to login, as normal, to the network until you've unlocked your personal login ID.)

Username/ID:

Your network login ID will be the same as what you created on MySeminole State (https://my.scc-fl.edu) when registering for classes. The seven digit Seminole State number you may have used in previous terms is no longer valid (unless you created a MySeminole State login name with the same number). You must use your new id beginning with summer term 2004. On-campus students may use a generic log-in for the first week of class (usually MCStudent) and look up their log-in ID in the classroom. If you did not create a MySeminole State login name when registering for classes, you won't have a network login and mailbox.

Password:

Your Password is your first and last initial, followed by the six digits of your birth date in the YYMMDD format, where YY is the two digit year (don't use the 19 in the 19YY format) MM is the two digit month (Jan-Sep months must use a leading 0) DD is the two digit day (1st-9th must use a leading 0). Make sure that there are no spaces between the items and the letters are lowercase. Example: If your name is John Doe and you were born on March 1, 1977 your password would be: jd770301.

Email:

Due to severe penalties for misuse, you are cautioned to review your Student Handbook regarding the ethical use of this resource. It may be necessary sometime during the semester to email assignments to the instructor. You may use an e-mail account that you have at home and/or at work, providing you can e-mail your files as attachments (online students must use ANGEL account when communicating with instructor). WinZip can be used to condense your files if needed. If you don't have your own personal e-mail account, you may use the Seminole State student e-mail system (MyMail). All Seminole State students are issued an e-mail account, which is recommended for large file sizes or multiple file attachments. Seminole State mail can be accessed through: http://mymail.scc-fl.edu/. Your Username and Password should be the same as your Network login.

Internet:

"Lab Rules" and "Lab Hours" can be found online and accessible from any student desktop in any Seminole State lab.

Attendance:

A recommended schedule of activities is provided to help you organize your time and create some structure in the course; it does not provide 'slack' time. You may choose to work at your own pace but it is important that you adhere to the due dates. It is suggested that you post a copy of the calendar where you will see it so you do not miss due dates. Work not submitted by the required date will not be accepted unless prior arrangements have been made. If you miss class, it is your responsibility to make up the time in the Lab or at your home or work computer. I recommend that you attend all classes. Attendance will be taken at the beginning of each class, so be sure to check in after class if you arrive late (for online students your attendance is noted through ANGEL participation). You are responsible for assuring that your presence is noted. A student, who is absent from class 10% of the scheduled class time, is subject to being dropped without warning by the instructor. You may withdraw from class by visiting the registration office or via the MySeminole State link from the Seminole State homepage (http://www.seminolestate.edu). The deadline to withdraw is usually no later than when 70% of the class has been completed. Students who fail to withdraw will be graded with zeroes for the incomplete assignments and exams and the earned grade will be assigned (usually an "F"). Remember, it is your responsibility to withdraw from class if you can no longer attend. A student who has to be absent because of jury duty, a court-mandated appearance or a religious observance that would result in a missed exam, must contact the instructor within 24 hours to schedule a make-up exam before the next class period. Any student who has a disability and is in need of special services should contact Disability Support Services by the second week of class.

Academic Integrity:

You are expected to maintain the highest standards of academic honesty and integrity while in this course and as a student at Seminole State College. If you fail to maintain these standards as a student in this class I will pursue the fullest possible implementation of academic discipline for your offense. If you have any questions about the college's code of academic conduct, please consult the Seminole State catalog or me. In short, lying, cheating, stealing, or deception of any type will not be tolerated in any way, shape, or form. Although students are encouraged to seek assistance from their instructor, fellow students, and lab assistants, each student must submit their own work. This means you may not use another student's work as your own. You may not allow another student to use your work. You may not obtain copies of prior semester's work or exams from previous students for your own use. Students that submit duplicate work will receive a zero for the first infraction and an automatic “F” in the course for their second infraction. (Student Handbook - Section I - Academic Integrity and Classroom Behavior). If you live with someone else that is taking this class, or sharing a computer with someone else taking this class, it is your responsibility to ensure the other person does not have access to your files.

Exams:

You will have four 25-point exams covering the following modules in your book.

Microsoft Word Microsoft Excel Microsoft Access Microsoft PowerPoint

These closed-book exams will consist of different scenarios within each application. It is highly recommended that you complete all assignments and take a few Practice Tests before the exam!

Assignments:

You will be responsible for 5 projects, one for each module covered in the book. For each chapter in a module, you will be responsible for two separate assignments. An in-class assignment (worth 5 points) and a homework assignment to be completed via SAM (worth 10 points).

Word Project Excel Project Access Project PowerPoint Project Integration Project

These assignments are due the day of the exam for the particular module. Late assignments will not be accepted.

Header/Footer Requirements:

A header/footer containing your name and the Chapter # - Case # must be included on all pages of your Assignments. Any pages without the required header/footer will not be accepted.

SAM (Skills Assessment Manager):

All exams and homework assignments will be completed through SAM, with the exception of the Access assignments.

Extra Credit:

You can earn up to 10% (30 points max) extra credit in this class by taking practice tests and doing additional assignments in your book. Please see your instructor for details.

Microsoft Certified Professional Certification Programs:

The Microsoft Certified Application Specialist Program is explained in detail in Appendix G of the textbook. This certification provides a valuable industry credential or proof that you have the Office application skills required by employers. Our textbook is a Microsoft-approved textbook that covers the required objectives for the various exams. The Web page http://www.seminolestate.edu/computers/certifications/ includes links to general information on certification, choosing an application for certification, preparing for the certification exam, and taking and passing the certification exam.

MSDN Academic Alliance Software:

Seminole State is a member of the Microsoft Developer's Network Academic Alliance. As a member, all of the software licensed under the MSDNAA Program is available for download to registered students. Simply go to http://msdn06.e-academy.com/scc-fl_net and click on the Software tab to see a complete listing of software available. Approximately two weeks after classes start, you will receive a "Welcome Letter" in your Seminole State MyMail account (http://mymail.scc-fl.edu) that includes your MSDN username and password.

Emergency Conditions:

To verify that the college is open and classes are being held, please call: 407-328-2290 or 407-328-4722. The Seminole State website homepage features updated announcements at http://www.seminolestate.edu.