DEPARTMENT OF BUSINESS AND TECHNOLOGY

CGS 1570 Integrated Business Apps Software

Fall 2009, CRN 21325, Tues. and Thursday 11:00-12:20, Room 19-112

Adjunct Instructor:

Melanie Montero

Email:

monterm@scf.edu or Angel Email

Dept. Telephone:

941-752-5206

Website: 

www.melaniemontero.com

Home Telephone:

941-383-7091

Office Hours:

By Appt.

 

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 work in word processing, spreadsheeting, database management and an introduction to presentation software. Integrating these applications to solve complex business problems will be emphasized. Additional special fees are required.

 

Text/Materials Required: Shelley, Cashman, Vermatt. Microsoft Office 2007 Advanced Concepts and Techniques, Thomson Course Technology, Boston, MA 2007. Click here to access student data files.

 

All text assignments and examples use MS Office 2007 software.  If this software is not available from a PC at home or work, you will need to use the Computer Lab at SCF. Free software trial downloads are available from this link within the MS website   for 60 days.  Student discounted software is available for purchase from Microsoft. To obtain information about this offer go to http://www.microsoft.com/student/discounts/theultimatesteal-us/default.aspx. As an alternative to using MS Office, students can try Open Office, however directions for using this software are not available in the text or from the instructor.

 

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 the:  book resource companion website. Many additional helpful links can be accessed through the instructor’s website.

 

Keyboard shortcuts offer alternative, and often quicker, ways to complete computer tasks. Click this link to obtain a listing of keyboard shortcuts: Helpful Keyboard Shortcut Commands.  

 

Course Performance Requirements:  Students may access course performance standards by clicking on the “Course Performances Standards” link at the following web address:  http://www.scf.edu/Academ/Academ.cfm.  A hard copy may be obtained from the instructor or from the Department Office.

 

Student Responsibility: The responsibility for obtaining and completing all work rests solely upon the student.   All assignments should be emailed to the instructor through the Angel distance learning software platform by the dates provided in the assignment schedule. Additional questions and correspondence should be emailed to the instruction through Angel email. Be sure to include a clearly stated subject line in all email correspondence.  Chapters should be reviewed by the student before attending class. Students who are unable to take a scheduled quiz/exam must notify the instructor before the exam time period.  If the instructor is not notified, the student will not be able to make-up the exam. Students are expected to abide by all Lancer Student Handbook guidelines.

Attendance/Lateness: 100 total points are given to students that attend all scheduled classes on time.  Points will be deducted for absences and lateness.

 

 

Late Assignments Policy:  All late assignments must be turned in within one week of the assigned due date.  None will be accepted after that time allotted.  All late assignments will be deducted 50% after graded.  Late assignments will not be accepted the week before final exams.

 

Withdrawal Policy:  In accordance with the Manatee Community College 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 Manatee Community College academic calendar. This semester this date is October 27. 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.

 

Course Evaluation: The instructor will post weekly grade updates through Angel. Each class assignment (15) is worth 33.33 points. Grading rubrics outlining specific assignment requirements are available for each assignment (found on instructor’s website). Additional student resources are available on the instructor’s website.

 

Class Assignments

500 pts.

Grading scale

Attendance

100 pts.

A = 90 - 100%

Tests and Final Exam

400 pts.

B = 80 - 89%

 

 

C = 70 - 79%

 

 

D = 60 - 69%

 

 

F = below 60%

 

 

 

Microsoft Certification: The Microsoft Business Certification credential tests can be substituted for the hands-on final exam. Click here for exam information: 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. Travel to approved testing cites in Tampa or Ft. Myers is necessary if you choose to take the certification exams as an option to taking the regular exams at SCF.

See www.certiport.com and Certiport.com for Test Prep, Objectives and Sample Exams 

Link to Buy Exams Vouchers through Certiport

 

 

Assignment Schedule

*Note: Each assignment requires the student to develop a business theme to be used throughout the course. The theme should be integrated appropriately in each assignment submitted. The end product will comprise a student portfolio website of consistent work examples.  Check the Grading Rubrics link on the instructor’s website for assignment specifics. Read chapters and prepare questions before attending class. Check out www.wix.com for free website space and templates.

 

Class 

Topic

Requirements

Due Date

8/25

Introduction to course

·         Syllabus

·         book website

·         Instructor website

·           Angel Site

 

 

·         Angel Photo upload

(15 pts.)

 Navigate instructor’s website where you can find required assignment file downloads, grading rubrics and assignment notes, and supplemental course materials. Access your Angel Course through the SFC site where you will be submitting assignments, taking tests and checking grades. All lab assignments are required to be uploaded through the appropriate drop-box within the Angel course delivery system.

 

 

 

 

 

 

 

9/1

8/27

Prepare for Word 4 Lab

Word Unit 4 p.  WD 226-291

 

9/1

Word 4Lab

Word 4 -Proposal

Your completed work should resemble the example given in Figure 4-1, p. WD 227. Your final copy should reflect changes in the example using your theme for the watermark, appropriate chart and text.

 

Prepare for Word 5 Lab

9/3

9/3

Prepare for Word Unit 5, Mail Merge, p.  WD 306-368

9/10

9/8

Word 5 Lab

Word 5 -Mail Merge

Your completed work should resemble the example given in Figure 5-1, p. WD 307. Change the banner color and text to be consistent with your theme.

 

9/10

Prepare for Word 6 Lab

Word Unit 6 p.  WD 387-450

9/17

9/15

Word 6 Lab

Word 6 -Newsletter

Your completed work should resemble the example given in Figure 6-1, p. WD 387. Change the nameplate and clip art to reflect your business theme.

 

9/17

Prepare for Resume

Assignment

Research online resumes and current trend information before composition.

9/24

9/22

Resume Assignment

Resume

Use the link available in the Links section of the instructor’s website for additional information.

 

9/24

Prepare for Excel

Unit  4 Lab

 

10/1

9/29

Excel Unit 4, Amortization, p. 

EX 266-320

Excel 4 -Financial Functions

Your completed work should resemble the example given in Figure 4-1, p. EX 267. Your final copy should reflect changes in the example using your theme and color choices.

 

10/1

Prepare for Excel Unit 5 Lab

10/8

10/6

Excel Unit 5 p.  EX 338-399

Excel 5 -Sorting

Your completed work should resemble the example given in Figure 5-1, p. EX 339. Change the table data to appropriately reflect your theme. Make color changes as you see fit.

 

10/8

Prepare for Excel Unit 6 Lab

 

10/15

10/13

Excel Unit 6 p.  EX 418-491

 

 

Excel 6 -Templates and Multiple Workbook files

Your completed work should resemble the example given in Figure 6-1, p. EX 419. Your final copy should reflect changes in the business regions and titles provided in the example. Stop after p. 484.

 

Download the test review file from the course handouts link on the instructor’s website.

 

Earn extra credit points on your quiz by completing the  Learn it online practice tests for Word and Excel chapters. A link to these activities can be accessed from the instructor’s website, Links Page link  

 

10/15

Prepare for Linking Assignment

 

Quiz—Word and Excel

See page Sample on Page WD 465. Follow the directions provided in the instructor’s grading rubric. Use the file downloads provided by the instructor. These can be obtained from the grading rubric page on the instructor’s website.

10/22

10/20

Linking Word and Excel

Linking Word and Excel

Your completed document should resemble the example given in Figure 1(c). Change the chart and memo to reflect your overall business theme.

 

10/22

 

Prepare for Access 4 lab

Supplemental Access objects will be needed to complete the Access Units 4 and 5 assignments. Download Access file for Access Unit 4.

 

10/29

10/27 

Access Unit 4 p. AC 234-284

Access  4 – Reports/Form

Your completed work should resemble the example given in Figures 4-1, 4-2 and 4-3, p. AC 235-6. Your final copy should reflect changes in the report and form to reflect your overall business theme.

 

10/29

Prepare for Access

Unit 5

 

11/5

11/3

Access Unit 5

p. AC 298-347

Access 5 – MultiTable Form

Your completed work should resemble the example given in figure 5-1, p. AC 299. Include a record for yourself that includes your photograph.

 

11/5

Prepare for Access 7

Note: Access Chapter 6  is skipped

11/12

11/10

Access Using SQL

(Unit 7)

Access 7 - SQL Queries

Required SQL commands end before the paragraph on Grouping Requirements on p. AC 443. A business theme should be used on the report.

 

11/12

Prepare for PowerPoint Unit 3

 

11/19

11/17

PowerPoint Unit 3

PowerPoint 3--Creating a Presentation

Your completed work should resemble the example given in Figure 3-1, p. PPT 163. Your final copy should reflect changes in background and art to reflect your business theme.

 

11/19

Prepare for PowerPoint Unit 4

Download the test review file from the course handouts link on the instructor’s website.

 

12/1

11/24

PowerPoint Unit 4

PowerPoint 4 -Information Graphics

Your completed work should resemble the example given in Figure 4-1, p. PPT 227. Your final copy should reflect changes in charts and diagrams to reflect your business theme.

 

Quiz review handout can be downloaded from instructor’s website

 

Earn extra credit points on your quiz by completing the Learn it online practice tests for Word and Excel chapters. A link to these activities can be accessed from the instructor’s website, Links Page link  

 

 

12/1

Quiz—Access and PowerPoint

 

 

12/3

Prepare for Integration Case Study 3

 

12/10

12/8

Integration Case Study 3

Integration Case 3

Create an Access table using any field names (example given in Figure 3a, P INT 7).  Submit the four files required in the instructions given for Part 4, p. INT 8. These files are:

·        The Access Web Portfolio file

·        The Access Web Portfolio file converted into a Word table

1.       The Access Web Portfolio file converted into an Excel workbook

The Excel Workbook file exported back to Access with the new high/low value information

 

12/10

Prepare for final

(Portfolio can be submitted for 20 extra credit points on exam. Check the grading rubric for specific requirements)

Exam Worth 200 Points

Skill only—4 problems

Examples of problems can be found on instructor’s site

All Work Due Today

Thursday 12/17 Final Exam 10-12 in Lab—Rm. 158, Bldg 19