|
DEPARTMENT OF BUSINESS AND TECHNOLOGY Syllabus for CGS 1570: Integrated Business Office Applications Software Fall 2009 | CRN 10128 | Room 19-113 | T 7:00-8:20PM |
|||||
|
Professor: |
Email: |
||||
|
Telephone: |
941 752-5488 |
Home/Website: |
|||
|
Check Grades: |
Resources > My Grades |
Office Hours: |
MWF:1:30-4:00, T:4-5:00; R:10-11:30 |
||
|
This is a live, interactive syllabus. Do not print. Below are links to detailed Grading Criteria, directions, keystrokes, page numbers, and specific point values for all assignments: |
|||||
|
Assignments: [ Dropbox] | Hunt | Word | Excel | Access | PowerPoint | Integration | Final |
|||||
|
Course Description: Three hours lecture per week, plus laboratory as assigned by instructor. Suggested prerequisite: CGS 1000 or good computer background. This course will build on the study of integrated business software begun in CGS 1000 with intermediate to advanced work in Word Processing, Spreadsheets, Database management and Presentation software. Integrating these applications to solve complex business problems will be emphasized as the student builds an overall business portfolio with a common theme for each project. Additional special fees are required.
During the entire course you will be doing Word Processing, Spreadsheets, Database and PowerPoint projects to support a particular business. The business can be real or make-believe. But you will work with the same business throughout the entire course, and in the end create a valuable Online Integrated Portfolio Project. |
|||||
|
Course Performance Requirements: Students may access course performance standards by clicking on the “Course Performances Standards” link at the following web address: http://scf.edu/pages/1159.asp. |
|||||
|
Text/Materials Required: Shelley, Cashman, Vermatt. Microsoft Office 2007 Advanced Concepts and Techniques, Thomson Course Technology, Boston, MA 2007. (ISBN: 978-1-4188-4332-8) Click here to access student data files. |
|||||
|
|
|||||
|
Assuming the student meets all the grading criteria, students may submit assignments using Microsoft Office 2000, XP, 2003, 2007 or even Open Office. (You can download OpenOffice.org for free; it is compatible with Office 97-2003.) However the textbooks and most assignments and examples use MS Office 2007 software. If Office 2007 software is not available from a PC at home or work, you may use the Computer Lab at SCF or utilize the free software trial downloads which are available from www.microsoft.com for 60 days. The Microsoft Office 2007 Compatibility Pack is available to allow previous versions of Office to open and convert Office 2007 documents. Work may also be saved from Office 2007 to Office 97-2003 formats.
As an SCF student you can now buy Microsoft Office 2007 Ultimate for only $59.95. |
|||||
|
|
|||||
|
It is strongly suggested that students complete the Learn It Online exercises that complement the text. The practice tests for each unit of study will enhance your quiz preparation. The web address link is accessed through: book resource companion website. Many additional helpful links can be accessed through the text book’s website. |
|||||
|
|
|||||
|
Helpful Links: Department Web Page: http://www.scf.edu/pages/177.asp Virtual Library: http://www.scf.edu/pages/1967.asp Academic Resource Center: http://www.scf.edu/pages/144.asp Student Services: http://www.scf.edu/pages/242.asp End-of-term Course Evaluation: http://www.scf.edu/DLEval/validate.cfm DL Home Page: http://www.scf.edu/pages/108.asp Distance Learning Self Assessment Technical Assistance: helpdesk@scf.edu or call SCF at 941.752.5357 or contact Collegis Online Academic Services Help Desk 24/7 Toll free: 866.506.1188 or http://lt.collegis.com |
|||||
|
|
|||||
|
Student Responsibility: All assignments should be emailed to the instructor through the Angel online learning software platform by the due dates provided in the assignment schedule shown on this syllabus. |
|||||
|
Additional questions and correspondence should be submitted to the instructor through Angel email. Proofread, Spell-check, professionally write, and include a meaningful Subject line for all email. Label all assignment email with the assignment name in the Subject line, such as Word 4 Assignment and your issue. The instructor will answer all correspondence within 48 hours. Students are expected to abide by all Lancer Student Handbook guidelines. |
|||||
|
|
|||||
|
Withdrawal Policy: In accordance with the State College of Florida policy as stated in the college catalog, students may withdraw from any course or all courses without academic penalty of a WF by the withdrawal deadline as listed in the State College of Florida academic calendar. See the online Academic Calendar for important dates. The student must take responsibility for initiating the withdrawal procedure. Students are strongly encouraged to talk with their instructors first before taking any withdrawal action. |
|||||
|
Statement of Plagiarism: Plagiarism is the use of ideas, facts, opinions, illustrative material, data, direct or indirect wording of another scholar and/or writer—professional or student—without giving proper credit. Expulsion, suspension, or any lesser penalty may be imposed for plagiarism. Copying another student's work will result in a zero for both students.
Accommodation Services: The State College of Florida, in accordance with the Americans with Disabilities Act will provide classroom and academic accommodations to students with documented disabilities. If you need to request an accommodation in this class due to a disability, or you suspect that your academic performance is affected by a disability, please see me or contact the Disability Resource Center (DRC). The DRC is located in 300-326 on the Venice campus and in the Student Services Center (01-219) on the Bradenton campus. The phone number is 941-408-1448 Ext # 61448 (TTY 941-480-3420) on the Venice campus and 941-752-5295 Ext # 65295 (TTY 941-751-8179) on the Bradenton campus. |
|||||
|
|
|||||
|
Course Evaluation: The instructor will post weekly grade updates through Angel. Each class assignment is worth 100 points. Grading criteria for each assignment are provided below. For face-to-face classes, the instructor will typically do a pregrade for each assignment during the class just prior to the due date. Additional student resources are available on the instructor’s website. |
|||||
|
Assignments |
100pts each; -5 pts for each day late |
Grade Scale |
|||
|
Attendance |
100pts; -5 pts for absence. -1 for late |
A: 90-100% |
|||
|
Three Quizzes |
100pt ea.; Word & Excel & Access/PPT |
B: 80-89% |
|||
|
Hands-on Final |
200pts 25 minute Word & Excel hands-on |
C: 70-79% |
|||
|
|
No Makeup Exams |
D: 60-69% |
|||
|
Your professor will grade all projects at least once or twice a week. Your professor will often check and answer all Angel emails 5 or 6 days a week. |
|||||
|
Late Assignments Policy: Five points will be deducted for each day an assignment is late for the first 5 days, and 1 point will deducted for each day late thereafter. For instance, if it is 7 days late, the grade will be 73. (5 days x 5 points for the first five days, 2 days x 1 point for the next two days late.) |
|||||
|
|
|||||
|
Microsoft Certification: The Microsoft Office Specialist (MOS) exams may be substituted for the hands-on final exam. For exam information click: Microsoft Specialist Testing. The Exams cost about $60-$90 each. It is very important that each student download the objectives list and master all the terms on the list before taking exams. You may also download sample exams. For exam credit to be received, the student must present passing score credentials for instructor verification by sending your instructor the URL for your online certification record. Travel to approved testing sites in Tampa or Ft. Myers may be necessary if you choose to take the MOS exams as an option to taking the regular in-class exams. Also you may try to call Ms. Griggy from MTI at 751-7900 x 2020. Typically Wednesdays 9:00-5:00 See www.certiport.com and Certiport.com for Test Prep, Objectives and Sample Exams As of 01/07/08: Link to Buy Exams Vouchers through Certiport
|
|||||
|
The student will
develop a business project and theme to be used with every
assignment for this course. ALL Communications for this online course must be through Angel email. ALL Assignments MUST be submitted online with Angel through the Angel [Assignment Dropbox]. I
cannot assign a grade to an empty [Assignment Dropbox] item. |
|||||
|
Due |
Unit/Assign. Page Number |
Requirements |
|||
|
T Aug 25 |
Class starts |
|
|||
|
During the entire course you will be doing Word Processing, Spreadsheets, Database and PowerPoint projects to support a particular business. The business can be real or make-believe. But you will work with the same business throughout the entire course, and in the end create a valuable Portfolio Project. So before you start, carefully think about what business you will adopt. Past examples: Beauty shop, Paint ball park, Computer repair, Custom jewelry, a Tattoo parlor, a lawn service … |
|||||
|
Extra Credit Quiz 10 pts. online: Scavenger Hunt Quiz (Angel > [Lessons] > [Timed Exams]) Extra
Credit 10 pts. online: Photo (Angel > [Lessons]
> [Assignment Dropbox]) |
|||||
|
S Sep 06 |
Word Unit 4 – YOUR customized
proposal For a samples see: |
Word 4 - Your Sales or Business Proposal Click on the link above for specific directions and criteria for the Sales or Business Proposal. Your completed work should resemble the example shown in Figure 4-1, p. WD 227. Develop an overall business theme to use throughout the course. |
|||
|
S Sep 13
|
Word Unit 5, Mail Merge |
Word 5 - Mail Merge for Your Business Your completed work should resemble the example given in Figure 5-1, p. WD 307. Meet the grading criteria, but customize if for YOUR business. |
|||
|
S Sep 20 |
Word Unit 6,
Newsletter For Newsletter samples see: |
Word 6 - Newsletter for Your Business Your completed work should resemble the example given in Figure 6-1, p. WD 387. Add-in for Save
as a PDF. |
|||
|
S Sep 20 |
Extra Credit Quiz 10 pts. online on Microsoft Office & Windows Keystrokes & Shortcuts You can take this early. If you do not take this exam by the deadline you will get a 0. |
||||
|
S Sep 27 |
Resume Assignment For a sample see: |
Use the directions given in the grading criteria to complete your online resume. |
|||
|
S Oct 04 |
Excel 1 - Payroll using Excel Functions Sum Avg Min Max CountA CountIF, If See tutorial: Excel1PayFunctions.pdf |
||||
|
Word Quiz 100 pts, 50 MC questions |
No makeup for
missed quiz. Click for
Review |
||||
|
S Oct 11
|
Excel
Unit 4, Loan Feel free to ask for an alternative but comparable Excel assignment that is related to your business and covers similar objectives. Get approval via Angel first. |
Your completed work should resemble the example given in Figure 4-1, p. EX 267. |
|||
|
S Oct 11 |
Extra Credit Quiz 20 pts. online: on Microsoft Windows You can take this early. If you do not take this exam by the deadline you will get a 0. |
||||
|
S Oct 18 |
Excel
Unit 6, Templates |
Excel 6 - Templates & Multiple Workbook files Your completed work should resemble the example given in Figure 6-1, p. EX 419. |
|||
|
S Oct 25 |
Linking Word and
Excel |
Your completed document should resemble the example in given in Figure 1 (c). |
|||
|
T Oct 27 |
Excel Quiz 100 pts, 50 MC questions |
No makeup for
missed quiz. Click for
Review |
|||
|
S Nov 01
|
Access
Unit 1: Begin setting up your Business database, which eventually will
involve multiple related Tables, Queries, Forms, and Reports. |
Access
1 – Tables, Queries, Forms and Reports |
|||
|
S Nov 08
|
Access Unit 4,
Reports |
Your completed
work should resemble the example given in Figures 4-1 and 4-2, p. AC 235. |
|||
|
S Nov 15
|
Access Unit 5, Forms with Subforms p. AC 298-347 |
Access 5 - MultiTableForm with Subform Your completed work
should resemble the example given in figure 5-1, p. AC 299. |
|||
|
S Nov 22
|
Last Access Assignment Due
Access Using SQL There is no
assignment on SQL but these terms will be on Final: |
Access
6 - Final Access Project in place of SQL |
|||
|
S Nov 29
|
PowerPoint
Unit 3 p. PPT 226-283 SamplesPDF/PPT1-LitaDogBarkery.pdf |
PowerPoint 3/4 A Business Presentation Your completed work should resemble the example given in Figure 3-1, p. PPT 163 and Figure 4-1, p. PPT 227. You will do an in-class presentation of your PowerPoint. Instead of saving as a Web page, it is easier to Save as a PDF and put online. |
|||
|
T Dec 01 |
Access PPT Quiz 100 pts, 50 questions |
No makeup for
missed quiz. Click for
Review |
|||
|
S Dec 06
|
Integration
Case Study 3
For Samples from past Students see: SamplesWordWebSite/0TinasWebSite SamplesWordWebSite/FeliciasWebSite |
Export one of your Access tables to Word and Excel. See p. INT 8 Then build an attractive Home Page (index.htm) file with an image an attractive banner that shows off your portfolio projects with links to 5 of 6: a Your Newsletter.pdf file b Your Online Resume.htm c Your PowerPoint Business Presentation.pdf d Your Exported Word file .htm e Your Exported Excel file .htm d Your Exported .txt or .rtf file |
|||
|
T Dec 8 |
Review |
||||
|
Final Exam: 200 pts, 7:00 Room 19-169 |
|||||
