Ankeny Campus

http://www.dmacc.edu

Welcome to BCA212

Intro to Computer Business Applications

Kathleen Zimmerman, Instructor

 

Instructor Information

Name

Kathleen Zimmerman

E-mail address

mkzimmerman@dmacc.edu

Phone number

515 . 965 . 7136

Fax number

515 . 965 . 7135

 

Bldg. 8, Rm. 6, Ankeny

Office hours

M/W 12:15-1:15, and by appt.

 

Course title

Computer Business Applications              

Course number

BCA 212

Credits

3

Days & Time

Location

Building 8, Rm. 1

Course descriptionj0433050[1]

Using computer hardware and software as business productivity tools is the focus of this course. Training includes a hands-on introduction to microcomputer applications vital in today's business and industry. This course introduces the Windows XP operating system as well as e-mail, Internet, word processing, spreadsheet, database, and presentation software applications.

http://www.dmacc.edu/courses/crsrod.asp

 

Prerequisites

Keyboarding recommended as well as familiarity with using the mouse in a Windows environment.  Internet familiarity is also helpful.

 

 

Midterm

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

Final

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

Textbooks & Materials

Required textbooks

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

Required materials

USB flash drive which comes bundled with the textbook

Software applications

Office 2007 Professional 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.”  Note: Software is typically available for purchase at the DMACC bookstore with a substantial educational discount.

 

 

Course Competencies

 

1.        Define what is a computer.

1.1              Discuss the four basic computer operations: input, processing, output, and storage

1.2              Distinguish difference between data and information.

1.3              Explain principal components of the computer.

1.4              Discuss four common types of storage devices: magnetic disk, optical disks, tape, and miniature mobile storage media.

1.5              Explain the difference between system software and application software.

1.6               

2.        Describe what is a network.

2.1              Identify the difference between a local area network and a wide area network.

2.2              Identify what is the Internet and what is the World Wide Web.

2.3              Identify what is e-commerce.

2.4               

3.        Use an operating system.

3.1              Describe an operating system environment.

3.2              Perform basic mouse operations: point, click, right-click, double-click, drag, and right-drag.

3.3              Practice changing features on window: open, minimize, maximize, restore, move, size, scroll, and close.

3.4              Use menus, toolbars, dialog boxes, scroll bars, and on-line help.

3.5               

4.             Explore file management features.

          4.1       Display drive and folder contents.

          4.2       Understand file management.

          4.3       Copy, move, rename, and delete files.

          4.4       Create folders.

 

4.        Use e

5.        lectronic mail.

          5.1       Practice electronic mail messaging features: open, read, print, reply to, and delete.

          5.2       Use file attachments: insert and view.

          5.3       Create and insert an e-mail signature.

          5.4       Practice contract management.

                      5.4.1    Create a personal folder.

                      5.4.2    Print a contact list.

                      5.4.3    Find a contact feature.

                      5.4.4    Organize a contact list.

 

6.             Use features of the Internet.

          6.1         Display World Wide Web pages.

          6.2         Search the Web for information.

          6.3         Save a list of frequently used Web pages.

          6.4          Print text and images found on Web pages

 

 

 

 7.            Use word processing application.

                 7.1            Identify components of word processing application.

                 7.2            Create, edit, save, print, close, and open word processing documents.

                 7.3            Use editing and proofreading tools.

                 7.4            Apply character, paragraph, and document formats.

                 7.5            Create a MLA style report.

                 7.6            View and modify document summary.

                 7.7            Insert picture features in a document: Clip Art, Word Art, and from file items.

                 7.8            Use header and footer features.

                 7.9            Apply auto text features to document.

                 7.10          Create, modify, and format tables.

                 7.11          Format Word document as a Web page.

 

 

 8.            Use spreadsheet application.

                 8.1            Identify components of spreadsheet application.

                 8.2            Build, edit, save, print, close, and open worksheets.

                 8.3            Use formulas, what if analysis, and functions in worksheets.

                 8.4            Apply formats in worksheets.

                 8.5            Create, format and print charts.

                 8.6            Save spreadsheet as a static Web page.

                 8.7            Save chart as a dynamic Web page.                                                     

 

 

 9.            Use database application.

                 9.1            Identify components of database application.

                 9.2            Build, edit, save, print, close, and open database tables.

                 9.3            Complete database queries.

                 9.4            Change database structures.

                 9.5            Convert spreadsheet data to database application.

                 9.6            Copy data from database application to other software applications.

                 9.7            Export Use Extensible markup Language (XML) data.

                 9.8            Import XML data.

 

 

10.           Use presentation application.

                10.1           Identify components of presentation application.

                10.2           Apply principles and techniques of presentation software.

                10.3           Create, edit, save, print, close, and open presentations.

                10.4           Add, edit, and enhance slides.

                10.5           Prepare slide outline, notes page, and audience handouts.

                10.6           View slide show.

                10.7           Save presentation as a Web page.

                10.8           Publish presentation as Web page.

 

 

11.           Identify features of computer applications software.

                11.1           Run applications software using graphical user interface.

                11.2           Explain the types and purposes of application software.

                11.3           Select the application software type appropriate for specific tasks.

                11.4           Use reference materials, such as on-line help, tutorials, and textbook materials.

                11.5           Identify, select, and apply features of application software products.

                11.6           Diagnose and solve applications software problems.

 

 

Course Policies

Attendance

Attendance is expected at each scheduled class meeting.  Students are responsible for information presented during class hours.

Grading criteria

Grades are based on a percentage of total points. Approximately half the points are earned by doing assignments; approximately half are earned by taking tests.  Tests are comprised of both a written segment and an application segment

 

A = 90% to 100%

 

B = 80% to 89%

 

C = 70% to 79%

 

D = 60% to 69%

 

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

Missed exams receive half credit and must be taken at a time as arranged with the instructor.

Late assignments

Late assignments receive half credit and must be received within one week of when the assignment was originally due.

Extra credit

There are no extra credit opportunities in this course. 

Study expectations

You can expect to spend up to five or more hours per week studying and completing assignments.

Academic dishonesty

“See DMACC Educational Services Procedures ES 262 VII. A. and B” for information on plagiarism, cheating, information about appeals procedures or reference publication that addresses this information in detail.” Refer to the DMACC Student Handbook:   Any evidence of cheating will result in an automatic zero for the course.

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

 

Weather policy

Your instructor will attempt to notify you by e-mail if she is unable to make it to class.  This email would be sent prior to 7 a.m.

 

 

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 <