Portland Community College | Portland, Oregon

Upon completion of the course students should be able to:

1. Solve basic information systems problems using MS Office products appropriate for the solution.
2. Communicate in a business environment using the MS Office product appropriate for the communication.
3. Use computing technology ethically, safely, securely, and legally. 
4. Describe and analyze computer hardware, software, and the internet.
5. Use file management techniques for file and directory/folder organization.

Coaching

Individual reading assignments   

Lecture or mini lecture    

Comparisons among MS Office Suite’s software versus Google-docs or Libre Office

Small and large group discussions    

Videos    

Think-Pair-Share Presentations    

Online learning activities   

Hour of Code     

Collaborative groups    

Review of difficult concepts    

Presentation of exemplar works   

Service Learning-optional   

1. Performance tests
2. Objective tests
3. Projects
4. Presentations
5. Assignments
6. Participation

Savvy Computer Technology Consumer:Survival Tips

1. Have trouble-shooting techniques, e.g., screen captures or snipping tools, and why re-boot (re-starting) the computer can help resolve malfunctions, how to research solutions, using “help” function and “Task Manager”
2. Evaluate purchasing considerations when buying a computer, tablet or notebook
3. Distinguish between the operating systems and software application
4. Acquaint students with issues related to Security, Netiquette and Ethics

File & Folder Management

1. Apply integration of the Office Suite and associated file-management
2. Create, edit, save, retrieve, re-name, move, delete, and organize files and folders and apply organizational strategies
3. Create zip-files
4. Assess when a pdf-format is the preferable format

MS Word - Basic Word Processing

1. Create, edit, save, retrieve and print MS Word documents
2. Apply tools to create accessibility
3. Use formatting tools for a single or multiple page(s), a paragraph and fonts and to adjust a document’s appearance to achieve professional quality documents
4. Insert citations, bibliographies, footnotes/end notes, table of contents, headers/footers, and page numbering
5. Make tables
6. Use bulleted lists
7. Insert and manipulate images, clip art, other graphics

MS Excel - Basic Spreadsheet

1. Create, edit, save, retrieve and print MS Excel documents
2. Apply tools to create accessibility
3. Create formulas using absolute and relative references; if and average functions; AutoSum, and grand total
4. Understanding data types (such as strings, numbers, date and time)
5. Develop decision-making skills to do what-if analysis
6. Name sheets and defined ranges, freeze columns and rows, and use formula view
7. Develop skills in managing multiple-sheet worksheets
8. Size and show/hide rows and columns
9. Apply sort and filter features to a list
10. Use importing and exporting functions
11. Generate pie and column charts by using the chart wizard
12. Format readable and printable worksheets and cells
13. Use templates

MS PowerPoint - Basic Presentation

1. Create, edit, save, and retrieve MS PowerPoint documents
2. Apply tools to create accessibility
3. Create multiple slides and manipulate them into one presentation
4. Apply designs, formats, layouts, transitions, and animations
5. Use or print views, such as:   normal, slide master, outline, slide sorter, slide show, handouts and notes
6. Format lists, bullets and fonts
7. Insert and manipulate clip art, other graphics  
8. Assess the presentation for accuracy, readability, appearance, and consistency
9. Identify the audience’s needs and the presentation’s likelihood to achieve its goal

MS Access - Basic Relational Database

1. Edit, save, and retrieve MS Access databases
2. Enter data into tables
3. Create basic queries and reports
4. Use help features