BUS 1112 - Computer Concepts and Applications

1. Understand the basic hardware (input, output, and storage) components and software (operating and application) used in the Windows and Internet environment.
2. Apply efficient use of computer system and operating and application software.
3. Apply the ability to organize files by creating folders and managing (copy, move, rename, and delete) files.
4. Understand computer security and safety, ethics, and privacy concerns related to technology.
5. Understand how to access the Internet for relevant information.
6. Apply proper procedures to create documents, worksheets, databases, and presentations suitable for coursework, personal, and professional purposes.
7. Apply word processing, spreadsheet, database, and presentation software to solve business problems.
8. Apply e-mail software methods for professional, effective communication.
9. Demonstrate the ability to create, design, and maintain databases by creating tables, queries, reports, and forms while following professional design standards.
10. Demonstrate the ability to create, format, save, and print spreadsheets while following professional design standards.
11. Demonstrate the ability to create, format, save, and print word processing documents while following professional design standards.
12. Demonstrate the ability to create, format, save, and print presentations while following professional design standards.

1. Impact of Digital Technology
2. The Web
3. Computer Hardware
4. Operating Systems and File Management
5. Security and Safety
6. Digital Transformation: Cloud, E-Commerce, and AI
7. Digital Ethics and Lifestyle
8. Operating Systems - Microsoft Windows operating system basic procedure.
9. Word Processing - Microsoft Word topics: creating/saving/printing/editing documents, basic-intermediate level document formatting, working with text/images/hyperlinks, research paper structure/sources/notes, business letters, SmartArt, multiple page documents, editing and formatting pages/lists/tables, watermarks, templates, themes, content controls, sharing documents.
10. Spreadsheets - Microsoft Excel topics: creating/saving/printing/editing/formatting workbooks and worksheets, cell styles, fill handle, formulas, basic functions, relative and absolute cell references, IF functions, charts, freezing/unfreezing columns and rows, goal seek, what-if analysis, financial functions, data tables, amortization schedules, protecting and hiding worksheets and workbooks, 3-D references, PivotTables.
11. Database - Microsoft Access topics: creating/designing/maintaining databases, tables (creating/defining/maintaining fields, data types, primary key, adding/editing records, joining tables), forms (creating/editing/formatting, relating to tables), queries (creating/running/saving/editing queries, criteria queries, wildcard queries, parameter queries, AND/OR queries, calculated fields, crosstab queries, exporting data to Excel, sorting and filtering records, validation rules, referential integrity), reports (creating/designing/formatting/editing).
12. Presentation Graphics - Microsoft PowerPoint topics: creating/formatting/editing/saving presentations, using multiple slide types, working with text and graphics within slides, themes, SmartArt graphics, working with shapes, adding charts/tables/animation/media to slides, slide design, oral presentation guidelines.
13. Integration: Use two or more applications to create a professionally formatted document.