First Boot &mdash; CGS1000C Course Hub

Creating documents, formatting text, paragraphs, headers/footers

Word Processing Basics

12 component descriptions — match to the correct part

Hands-On Labs

Hardware Identifier

Word Formatting Challenge

Fix a messy document by selecting correct formatting actions

Quiz 1: Computer Fundamentals

Assessment

15 questions — hardware, software, OS basics

Quiz 2: Word Processing Basics

15 questions — formatting, page layout, spell check

Styles, tables, citations, mail merge, track changes

Advanced Word & Spreadsheet Basics

Styles, tables, citations, Excel formulas & cell references

Obj 3 Obj 4 2 presentations • 2 labs • 2 quizzes • midterm

▼

Week 2 Progress 0 / 7

This Week: Documents & Data

Level up your Word skills with styles, tables, citations, and research paper formatting. Then begin your spreadsheet journey — learn Excel's interface, basic formulas, cell references, and data formatting. The midterm exam covers Weeks 1–2.

Styles & Templates Tables & Lists MLA/APA Citations Excel Interface SUM/AVERAGE/COUNT Cell References

Presentations

Advanced Word Processing

Workbooks, cells, formulas, cell references, formatting

Spreadsheet Fundamentals

Given sources, select correct MLA/APA citation format

Hands-On Labs

Citation Builder

10 scenarios — construct the correct Excel formula

Formula Builder

Quiz 3: Advanced Word Processing

Assessment

15 questions — styles, tables, citations, mail merge

Quiz 4: Spreadsheet Fundamentals

15 questions — formulas, cell references, formatting

25 questions • 45 minutes — Weeks 1–2 comprehensive

Midterm Exam

Exam

Advanced Spreadsheets & Databases

Charts, IF/VLOOKUP, pivot tables, Access database fundamentals

Obj 5 Obj 6 2 presentations • 2 labs • 2 quizzes

▼

Week 3 Progress 0 / 6

This Week: Analysis & Databases

Take your spreadsheet skills to the next level with charts, the IF function, VLOOKUP, conditional formatting, and pivot tables. Then discover databases with Microsoft Access — tables, data types, primary keys, relationships, queries, and reports.

Charts (Bar/Line/Pie) IF Function VLOOKUP Pivot Tables Access Tables Queries & Reports

Presentations

Advanced Spreadsheets

Charts, IF, VLOOKUP, conditional formatting, pivot tables

Tables, data types, primary keys, queries, forms, reports

Database Fundamentals

10 data scenarios — pick the correct chart type

Hands-On Labs

Chart Type Selector

Select data types, primary keys, and relationships

Database Designer

Quiz 5: Advanced Spreadsheets

Assessment

15 questions — charts, functions, pivot tables

Quiz 6: Database Fundamentals

15 questions — tables, queries, relationships

Slide layouts, themes, transitions, animations, presenting

Presentations & Digital Literacy

PowerPoint, app integration, cloud storage, cybersecurity awareness

Obj 7 Obj 8 2 presentations • 2 labs • 2 quizzes • final

▼

Week 4 Progress 0 / 7

This Week: Present & Integrate

Master PowerPoint — slide layouts, themes, animations, and presenting tips. Then learn to integrate Office applications: embedding Excel in Word, linking data, and collaborating in the cloud. The course wraps up with digital literacy, cybersecurity awareness, and career skills.

Slide Layouts Animations Speaker Notes App Integration OneDrive Cybersecurity Basics

Presentations

Presentation Graphics

Integration & Digital Literacy

App integration, cloud storage, collaboration, cybersecurity

Select slide layouts, content order, and design principles

Hands-On Labs

Presentation Planner