CIS 120 - Computer Applications for Business [SUN# CIS 1120]

1. Demonstrate proficiency with spreadsheet software to solve business problems. 
2. Demonstrate proficiency with using visual presentation software, word processing documents and database management software to organize, present and store business solutions and information.
3. Use the Internet to research and analyze information and data in case studies.
4. Discuss laws and ethics related to computer use.
5. Explain the Internet effect on the globalization of business and social networks from the perspective of business.

1. Business Application Tools -Excel
   1. Create, edit and format spreadsheets
   2. Create and modify formulas using absolute, mixed and relative cell reference
   3. Use Excel functions
   4. Create and modify charts
   5. Name cells and ranges
   6. Table management
      1. Sort
      2. Filter
      3. Import data
   7. Database functions
   8. Create, refresh, and delete
      1. Pivot tables
      2. Pivot charts
   9. Business problem solving
      1. Analysis of problems
      2. Critical thinking
      3. Design of charts, and tables to highlight business information
      4. Analysis of existing data represented in excel
2. Business Application Tools -Access
   1. File management
   2. Create, design, normalize, join tables
   3. Design, manage, filter, sort data
   4. Query using Structured Query Language (SQL)
   5. Report generation
   6. Pivot table
   7. Chart
3. Business Application Tools -Word
   1. Editing and formatting
   2. Importing/Inserting
      1. Pictures
      2. Excel Charts
      3. Tables
   3. Creating and modifying
      1. Styles
      2. Table of content
      3. Index
   4. Labels and mailers for business literature
4. Business Application Tools -PowerPoint
   1. Create
      1. Slideshows
      2. Templates and master slides
      3. Outlines
   2. Modify
      1. Slideshows
      2. Templates
      3. Outlines
   3. Importing/inserting
      1. pictures
      2. graphs
      3. slides
5. Other topics

1. Network Security and data integrity
2. Information systems role in business
3. Research using the Internet
4. Planning and implementing technology solutions  
5. Ethics
6. Social Networking as a business tool
7. Internet Security

1. Viruses and malware
2. Internet fraud
3. Spam
4. Identify theft
5. Intellectual property rights
6. Privacy

1. Internet Case studies
   1. E-Commerce
   2. Principles of e-commerce
   3. Effect on business
   4. Cloud computing
   5. Social and ethical issues