CPSC30 - Computer Applications

Course Description:  

This course explores computer use in the workplace with emphasis on business situations. Applications including word processing, spreadsheet, database, and presentation managers will be covered. Internet, telecommunications, introductory web page design, and other business software will be included.

Expected Student Outcomes or Objectives:  Upon completion of this course, students will:

  1. Utilize the Operating System to create folders, save and copy files, and multitask in Windows.
  2. Examine Computer Concepts in order to name and describe the typical digital computer components (equipment) and their functions (input and output devices). Describe common computer applications and related social and ethical problems/impact.
  3. Develop Library Literacy, and differentiate between information and knowledge. Examine the links among information centers and their access points through technology and other reference sources. Recognize the different levels, types, and formats of information including but not limited to primary vs. secondary, and popular vs. scholarly.
  4. Experiment with and navigate the Internet using search engines. Determine whether a Web site is accurate, reliable, and scholarly.
  5. Apply Word Processing techniques by creating documents that include: (1) margin changes, (2) center page, (3) headers and/or footers, (4) ClipArt inserted and moved, (5) a page break, (6) landscape orientation, and (7) the insertion of a table.
  6. Design and analyze business Spreadsheets by creating formulas, producing visual representation of data in the form of charts, and editing cells. Solve problems within a spreadsheet by: utilizing statistical functions: max, min, average, pmt function and creating a “what if” statement. Print sheet/s showing and hiding the formulas.
  7. Understand the basic structure of electronic databases and the strategies used to access them. Edit a Database with multiple tables by adding to the table structure, sorting and filtering data, and generating queries. Create forms and reports using the Wizard only.
  8. Create and present an electronic Presentation by: designing slides to include ClipArt/Photo/Movie, WordArt, AutoShape and/or an image from the Internet. Print slide handouts.