Des Moines Area community College

j0230390[1]http://www.dmacc.edu

BCA 213

Intermediate Computer Business Applications

 

Kathleen Zimmerman, Instructor

 

 

“Be the best you can be.”

-

Welcome to the class!

I am delighted to have you in this class because you’ll get to discover many of the great capabilities of the Microsoft Office Suite….and yourself!!!  The basics are behind you!  This course will make you extremely marketable in the business arena and you will leave the course with a great sense of personal satisfaction.

 

*      Most office employees may use and understand one, possibly two, Office applications.  You will leave with in-depth knowledge of all four.

*      You will become adept at integrating the four applications.  You’ll copy, paste, link, embed, import and export from one application to another.  This makes your skill level even more marketable.

*      The skills and techniques you learn in one application will quickly transfer to other applications.  Your creativity will begin to blossom.  Office will become your partner in productivity. 

The Office software is fun.  It's amazing.  And at times it can be a bit challenging!  If at any time during the semester you begin experiencing difficulty, please let me know right away! 

Good luck, have fun, and get the most out of this course that you possibly can!  Your hard work will pay off in the long run!                                                    Return to top

 

 

 

Instructor Information

Name

Kathleen Zimmerman

E-mail address

mkzimmerman@dmacc.edu

Phone number

515 . 965 . 7136

Fax number

515 . 965 . 7135

Office location

Bldg. 8, Rm. 6, Ankeny

Office hours

M/W 12:15-1:15, or appt.

T/R/F by appointment

 

Course Information

Course title

Intermediate Computer Business Applications

Course number

BCA 213

Credits

3

Days & Time

M/W 8 – 10 a.m.

Location

8-02

 

Course Description


Advanced Computers builds upon previously-learned Office skills.  In this course you will grow in terms of software understanding, in terms of personal marketability, and in terms of developing greater confidence in your ability to manage the software. You will develop a proficiency in decision-making using computer software applications. Producing final documents for real business applications such as file integration, on-line forms, linked spreadsheets, and desktop publishing, and many more are emphasized. 

 

Homework outside of class is required.  For a three-credit class, you can expect to spend an average of 6 hours outside of class studying and completing assignments.  To maximize learning, you need to READ the book, not just perform the steps!

 

http://www.dmacc.edu/courses/descriptions.htm

 

Prerequisites

BCA212 or CSC110

Course Competencies

1.         Customize word processing applications.

                          1.1   Create and edit templates.

                          1.2   Create and edit styles

                         

 2.        Format business documents using word processing software.

                          2.1   Prepare tables using advanced table options.

                          2.2   .Create a mail merge

                          2.3   .Integrate text and graphics from different sources.

 

 3.        Create desktop publishing projects.

                          3.1   Embed graphics.

                          3.2   Apply page layout guidelines.

                          3.3   Make decisions on correct formats.

                          3.4   Integrate text and graphics from various sources.

 

 4.        Create spreadsheets.

                          4.1   Link files.

                          4.2   Use templates.

                          4.4   Design spreadsheets.

                          4.5   Use formulas.

                          4.6   Create and apply ranges

                          4.7   Link files.

                          4.8   Use tables feature

 

 5.        Create database files using database software.

                          5.1   Design the structure of a database table.

                          5.2   Create reports using sorted files or queries.

                          5.3   Create forms.

                          5.4   Integrate database files with other software applications.

                          5.5   Construct PivotTables and PivotCharts

                          5.6   Become acquainted with SQL concepts

 

 6.        Create presentations

                          6.1   Customize a presentation.

                          6.2   Enhance presentations using graphic elements

                          6.3   Integrate other software applications into presentation.

 7.        Utilize the Internet.

                          7.1   Incorporate pictures from the Internet into presentation

                              templates.

                          7.2   Incorporate information from the Internet into other
software applications.

 

 8.        Communicate via e-mail.

                          8.1   Create e-mail distribution lists.

                          8.2   Use folders to organize e-mail messages.

                          8.3   Modify e-mail preferences.

                          8.4   Copy e-mail messages into word processing applica-

                             tion.

                          8.5   Generate e-mail message with attachment.

 9.        Integrate computer and problem-solving skills.

10.        Practice file management.

                          10.1  Create subdirectories to manage files.

                          10.2  Copy files to create backup files.

                          10.3  Compress folders

 

 

Important Dates   Drop Date:  11-3-08

Midterm

http://www.dmacc.edu/academiccal.htm (15-week course dates)

Final

http://www.dmacc.edu/academiccal.htm (15-week course dates)

 

Textbooks & Materials

Required textbooks

Office 2007 Intermediate Concepts and Techniques by Shelly, Cashman, Vermaat, Course Technology.

 

Required materials

The purchase of a memory stick which plugs into the USB port of a computer is highly recommended.

Software applications

Office 2007 including Word, Excel, Access, PowerPoint, Outlook

Software notice

“All the software on computers on campus which is used in this class is copyrighted; therefore, it is not for distribution, copying, or personal use.  This software is the property of Des Moines Area Community College.”  Visit the DMACC bookstore for student discount on the Microsoft Office 2007 Suite, Professional Edition. Check your home computer to see if you are able to use Office 2007 for homework. Return to top

Course Policies

Attendance

Attendance and participation is expected at each scheduled class. 

 

 

Grading criteria

A = 90% to 100%           of all possible points

 

B = 80% to 89%                     “

Incompletes will

C = 70% to 79%                     “

not be given.

D = 60% to 69%                     “

 

Homework

As assigned on the assignment sheet, but includes hands-on exercises assigned from the textbook including projects, Apply Your Knowledge, In the Lab, Cases and Places, and other end-of-chapter learning opportunities.  There are approximately 500 homework points.

Tests

At the end of each application an exam is given.  The exam consists of true/false, multiple choice, and “hands on” questions where tasks are performed with the keyboard and mouse.  There are approximately 200 test points.

Classroom conduct

As a courtesy to classmates:

  • Give undivided attention when anyone in the room is addressing the class
  • No cell phones in class (unless an emergency exists)
  • No gum chewing or refreshments in class
  • No children in class

Missed exams

Late and make-up exams receive half credit.  Schedule a time with the instructor.

Late assignments

Late assignments receive half credit and must be turned in within two weeks of when they were originally due. 

Extra credit

There are no extra-credit opportunities in this course.

Study expectations

Students are expected to be resourceful in solving problems that arise from assignments.  This may include taking the initiative to use reference manuals, internet sites, library resources, consulting with classmates, etc.  Your instructor is also a good resource!

Academic Integrity

It is important that you are aware that engaging in any form of plagiarism is considered academic misconduct by the college and various disciplinary actions may be taken, including expulsion from the college. Plagiarism is defined as the appropriation of and use of another person's writing and passing it off as the product of one's own efforts. If you copy someone's work and submit it as your own, it is plagiarism. (See DMACC's Student Handbook for further information).

 

Academic Integrity, doing one’s own work in course assignments and on tests, is one of the most important values in higher education. Receiving credit for cheating violates that value. It is unacceptable for you to copy or submit another person's work as your own, allow another person to complete your work for you, complete work for another student, or use unauthorized resources for tests. If you participate in cheating or plagiarism you will receive a failing grade for the semester. 

  Return to Top

 

DMACC Webmail

Each student at DMACC has an email account, free of charge.  Any communication from me to you will exclusively be via your DMACC Webmail account.  An easy way to access your DMACC Webmail account is to go to the DMACC Home page at http://www.dmacc.edu/.  Then click the WebMail link located on the right side of the screen. To enter Webmail, you will need your login and password.  Your login is your first initial, middle initial and last name.  Example:  mksmith.   Your password is the last four digits of your student ID number.  If you are unable to get logged in, dial (515) 965-7300.                            Return to top             

 

Weather policy

“Individual circumstances such as health, childcare, rural roads, distance from the College, etc. can vary greatly among students and staff.  It is always DMACC’s goal to provide safe learning conditions, as well as provide the opportunity for students to attend classes when the vast majority is able to safely attend.  The final decision to come to College can only be made by the individual student based on their specific extenuating circumstances that may make it unsafe for them to travel.  During adverse weather, DMACC faculty is considerate of students who are unable to attend classes due to unique extenuating circumstances.  It is the responsibility of each faculty member to notify their students (in addition to their dean or provost) thru some predetermined means if they are must postpone or cancel a specific class due to weather or illness.”

 

If the instructor is unable to be at class, she will attempt to notify everyone by 7 a.m. via WebMail.

Academic dishonesty

Refer to the DMACC Student Handbook:

http://www.dmacc.edu/handbook/welcome.asp

DMACC Information Web Sites

DMACC home page

http://www.dmacc.edu/

Instructor home pages

http://www.dmacc.edu/instructors/welcome.asp

Admissions & registration

http://www.dmacc.edu/potienti.asp

Cellular phone use statement

http://www.dmacc.edu/student_services/cellphone.asp

WebCT

http://webct.dmacc.edu/webct/public/home.pl

Student handbook

http://www.dmacc.edu/handbook/welcome.asp

Add/drop dates

http://www.dmacc.edu/registration/add_drop.asp

Refund policy

http://www.dmacc.edu/refund.asp

Support Services

Accommodations

“It is the policy of DMACC to accommodate students with disabilities.  Any student with a documented disability who requires reasonable accommodation should contact the special needs coordinator at 515-964-6850 voice or 515-964-6810 TTY.”