Nguồn ngoài

CPSI10003 Microcomputer Applications I

This book introduces essential computer concepts and file management skills while providing hands-on instruction in Microsoft Word, Excel, PowerPoint, and Access for creating documents, analyzing data, designing presentations, and managing databases.

Workforce

Tác giả: LueCrecy Ragan & Michael Hostetler
Nhà xuất bản: Arkansas State University-Beebe
Nguồn: LibreTexts
Ngôn ngữ: EN
Danh mục: Công nghệ thông tin

Đọc trực tuyến Tải PDF (nguồn mở)

Mục lục· 168 mục

01: Introduction to Microcomputer Applications
1.01: Introduction to Microcomputer Applications Sections
1.1.01: Introduction to Microcomputer Applications
1.1.02: Computing from Inception to Today
1.1.03: Web Browsers and the Internet
1.1.04: Why Microsoft Office
1.1.05: Essentials of Microsoft 365
1.1.06: Communication and Calendar Applications
1.1.07: Collaboration
1.1.08: Trends in Personal Computing
02: Computer Concepts
2.01: Introduction to Computers and Internet
2.1.01: Introduction to Computer Concepts
2.1.02: The Role of Information Systems
2.1.03: The Internet Cloud Computing and the Internet of Things
2.1.04: World Wide Web
2.1.05: Searching the Web
2.1.06: Advanced Searching Techniques
2.02: Personal Computer and Hardware
2.2.01: Safety Security Privacy and the Ethical Use of Technology
2.2.02: Information Systems Ethics
2.2.03: Personal Computer Basics
2.2.04: Creating Screenshots and Useful Keyboard Shortcuts
2.2.05: Hardware Basics
2.2.06: Computer Speed Factors and Data
2.03: Software Security and AI
2.3.01: Software Basics
2.3.02: Operating and Application Software
2.3.03: Mobile Software
2.3.04: Software- Obtaining and Open Source
2.3.05: Information Systems Security
2.3.06: AI Tools in Modern Business Software
2.04: Computer Concepts Terminology
03: File Management
3.01: File Management Sections
3.1.01: File Management Overview
3.1.02: File Path and Save As
3.1.03: Windows File Explorer
3.1.04: Macintosh Finder
3.1.05: Creating Screenshots
04: Microsoft Word- Setting a Foundation
4.01: Microsoft Word- Setting a Foundation Sections
4.1.01: Introduction to Microsoft Word
4.1.02: Creating and Saving a Word Document
4.1.03: Formatting Document Layout in Microsoft Word
4.1.04: Exploring the Home and View Tab of Microsoft Word
4.1.05: Formatting Document Content in Microsoft Word
4.1.06: All About the Text
4.1.07: Bullets Lists and Hyperlinks
4.1.08: Introduction to the Insert Tab
4.1.09: Graphics WordArt and SmartArt
4.1.10: Document Design
05: Microsoft Word - Building Proficiency
5.01: Microsoft Word - Building Proficiency Sections
5.1.01: Microsoft Word - Advanced Formatting Features
5.1.02: Design and Layout Tab
5.1.03: Setting Paragraph Alignment and Hyphenation
5.1.04: Headers Footers Page Orientation and Margins
5.1.05: Using the Reference Tab for Citations and Bibliographies
5.1.06: Working with Graphics and Text Tools in Microsoft Word
5.1.07: Creating and Formatting Tables
5.1.08: Creating Different Document Types in Microsoft Word
5.1.09: Managing Long Documents in Microsoft Word
5.1.10: Printing and Saving Files in Alternative File Formats
06: Microsoft Word Overview and Emerging Features
6.01: Microsoft Word Overview and Emerging Features Sections
6.1.01: Artificial Intelligence and Microsoft Word
6.1.02: Microsoft Word Helpful Tools
6.1.03: Mail Merge in Microsoft Word
6.1.04: Creating Forms in Microsoft Word
6.1.05: Collaborative Editing and Reviewing in Microsoft Word
6.1.06: Versions and Version History
6.1.07: Word and Excel Real World Applications
6.1.08: Microsoft Word Terminology
07: Microsoft Excel- Setting a Foundation
7.01: Microsoft Excel - Setting a Foundation Sections
7.1.01: Introduction to Microsoft Excel
7.1.02: The Excel Ribbon
7.1.03: The Excel Workbook
7.1.04: Text and Numbers in Microsoft Excel
7.1.05: Headers Footers and Page Layout
7.1.06: Renaming and Organizing Worksheets
7.1.07: Formatting and Templates in Microsoft Excel
7.1.08: Entering Selecting Sorting and Formatting Data
7.1.09: Microsoft Excel Calculations and Formulas
7.1.10: Basics- Functions and Formulas
7.1.11: Data Tables and Ranges
7.1.12: More About Formulas
7.1.13: Using Arithmetic Statistical and Logical Functions
08: Microsoft Excel- Building Proficiency
8.01: Microsoft Excel - Building Proficiency Sections
8.1.01: Advanced Formatting Techniques
8.1.02: Inserting Images Shapes and SmartArt
8.1.03: Data Tables and Ranges
8.1.04: Advanced Formulas and Functions
8.1.05: What-If Analysis
8.1.06: Logical and LookUp Functions
8.1.07: More Math Functions
8.1.08: Introduction to Charts and Visualizations
8.1.09: Creating and Customizing Charts
8.1.10: Chart Elements and Design
8.1.11: Pie Charts
8.1.12: Bar and Column Charts
8.1.13: Line Charts
8.1.14: Combining Charts with Formulas
8.1.15: Sparklines
8.1.16: PivotCharts for Dynamic Visualization
09: Microsoft Excel Overview and Emerging Features
9.01: Microsoft Excel Overview and Emerging Features Sections
9.1.01: Artificial Intelligence and Excel
9.1.02: New Tool - Solver
9.1.03: Power Power Power - Oh so much power
9.1.04: 3-D References
9.1.05: Excel Summary and Helpful Tips
9.1.06: Real World Applications
9.1.07: Excel Terminology
9.1.08: Excel Terminology Flashcards
9.1.09: Excel Hands-on Exercises
10: Microsoft PowerPoint - Setting a Foundation
10.01: Microsoft PowerPoint - Setting a Foundation Sections
10.1.01: Introduction to Microsoft PowerPoint
10.1.02: Presentation and Design Essentials
10.1.03: Planning a Presentation in Microsoft PowerPoint
10.1.04: PowerPoint Slide Basics
10.1.05: Formatting Microsoft PowerPoint Slides- Layout and Design Principles
10.1.06: Design Basics
10.1.07: Adding Visuals and Features to Microsoft PowerPoint Slides
10.1.08: Tables Charts Graphics and More.
10.1.09: Presentation Views and Printing
11: Microsoft PowerPoint - Building Proficiency
11.01: Microsoft PowerPoint - Building Proficiency Sections
11.1.01: Chapter Scenario
11.1.02: Adding Slide Transitions
11.1.03: Apply Animations to Slide Content
11.1.04: Adding and Modifying Media
11.1.05: Proofing Tools Templates and Slide Masters
11.1.06: Finalizing a Slide Collection
11.1.07: Preparing a Microsoft PowerPoint Collection for Presentation
12: Microsoft PowerPoint - Overview and Emerging Features
12.01: Microsoft PowerPoint Overview and Emerging Features Sections
12.1.01: PowerPoint New Features
12.1.02: Creating a Photo Album
12.1.03: Choosing the Best Presentation Tools and Visual Aids
12.1.04: Effective Presentation Skills
12.1.05: PowerPoint Terminology
13: Microsoft Access - Setting a Foundation
13.01: Microsoft Access - Setting a Foundation Sections
13.1.01: Introduction to Microsoft Access
13.1.02: Microsoft Access- Main Features and Navigation
13.1.03: Database Design and Four Main Objects
13.1.04: Creating a Table
13.1.05: Primary Keys and Table Relationships
13.1.06: Maintaining Records in a Database
13.1.07: Entering and Editing Records
13.1.08: Querying a Database
13.1.09: All About Queries
14: Microsoft Access - Building Proficiency
14.01: Microsoft Access - Building Proficiency Sections
14.1.01: Microsoft Access and Data
14.1.02: Advanced Queries in Microsoft Access
14.1.03: Creating Forms in Microsoft Access
14.1.04: Form Basics
14.1.05: Customizing Forms
14.1.06: Multiple Table Forms
14.1.07: Creating Reports in Microsoft Access
14.1.08: Customizing Reports
14.1.09: Using Macros
14.1.10: Microsoft Access Terminology