Important: Complete these steps before starting Week 1. They ensure your computer, software, and foundational skills are ready for CI2000.
Step 1
Software & Device Readiness
Verify your Windows computer, activate Microsoft Office 365, and confirm your setup is ready for the course.
Step 2
Readiness Self-Check Quiz
15 ungraded questions to identify your starting point. Covers computer basics, file management, screenshots, and email.
Step 3
Foundations Quick Start
A self-paced reference guide covering keyboard shortcuts, screenshots, file management, saving, and email basics.
Lesson 1.1
Computing Foundations & Productivity Software
Software categories, Microsoft 365 overview, and how healthcare organizations rely on technology every day.
Lesson 1.2
Microsoft Windows & File Management
Navigate the Windows desktop, master File Explorer, and learn healthcare file naming conventions.
Lesson 1.3
Web Browsers, Research & Professional Email
Effective search techniques, the CRAAP test for source evaluation, and Outlook email & calendar.
Weekly Assessment
Computing Foundations Quiz
15 questions covering software concepts, Windows, file management, web browsers, and Outlook. Review questions or download QTI for LMS import.
Discussion
Technology is Everywhere!
How technology impacts your daily life and future healthcare career. Share observations about the software and systems around you.
Assignment
Blood Drive Email & Appointment
Compose a professional email and create calendar appointments in Outlook for a clinic blood drive.
Lesson 2.1
Creating Documents in Word
The Word interface, templates, text entry and selection, cut/copy/paste, saving, and printing.
Lesson 2.2
Editing & Formatting Documents
Character & paragraph formatting, tables, graphics, headers/footers, Find & Replace, Format Painter.
Lesson 2.3
Professional Document Tools
Styles, themes, templates, building blocks, and Table of Contents for standardized documents.
Weekly Assessment
Microsoft Word Quiz
15 questions covering document creation, formatting, styles, themes, templates, and professional tools. Review questions or download QTI for LMS import.
Discussion
The Power of Professional Documents
Why professional formatting matters in healthcare communication and how it affects patient outcomes.
Assignment
Advertising the Blood Drive
Design a professional flyer using Word formatting, templates, and graphics to promote the clinic blood drive.
Lesson 3.1
PowerPoint Fundamentals
PPT interface, creating presentations, themes, slide layouts, formatting text, inserting images and shapes.
Lesson 3.2
Multimedia & Visual Communication
Image editing, SmartArt graphics, audio/video clips, transitions, and animation effects.
Lesson 3.3
Presentation Best Practices & Delivery
CARP design principles, Slide Master, Presenter View, rehearse timings, printing, and exporting.
Weekly Assessment
Microsoft PowerPoint Quiz
15 questions covering presentations, SmartArt, animations, CARP design, Slide Master, and delivery. Review questions or download QTI for LMS import.
Discussion
Death by PowerPoint... or Presentation Perfection?
Effective presentation strategies for healthcare. What makes a great slide deck vs. a terrible one?
Assignment
Training the Practice for the Upcoming Drive
Create a staff training presentation demonstrating design principles and multimedia skills.
Lesson 4.1
Excel Foundations
Excel interface, data entry, Auto Fill, number formatting, cell styles, conditional formatting, and freezing panes.
Lesson 4.2
Formulas & Data Analysis
Cell references, SUM/AVERAGE/COUNT, the IF function, sorting, filtering, and data validation.
Lesson 4.3
Office Integration & Data Management
Paste Special, embedding & linking, CSV import/export, data validation rules, and mail merge.
Weekly Assessment
Microsoft Excel Quiz
15 questions covering Excel foundations, formulas, functions, sorting, filtering, and data integration. Review questions or download QTI for LMS import.
Discussion
Data-Driven Healthcare
The importance of accurate data entry and analysis in healthcare and how spreadsheets support patient care.
Assignment
Collecting Data from the Blood Drive
Create a formatted Excel spreadsheet to track blood drive data with formulas and validation.
Lesson 5.1
Charts & Healthcare Data Visualization
Chart types (column, bar, line, pie, scatter), customization, SUMIF/COUNTIF, and sparklines.
Lesson 5.2
Database Concepts in Healthcare
Database terminology, EHR systems, health information exchange, HIPAA, and data integrity.
Lesson 5.3
Excel as a Healthcare Database
Excel Tables, structured references, VLOOKUP/XLOOKUP, subtotals, and PivotTables.
Weekly Assessment
Advanced Excel & Databases Quiz
15 questions covering charts, COUNTIF/SUMIF, databases, EHR, HIPAA, PivotTables, and XLOOKUP. Review questions or download QTI for LMS import.
Discussion
Looking Back, Looking Forward
Reflect on the computer skills learned and how they will support your healthcare career.
Assignment
Sharing the Good News!
Create a comprehensive report with charts, data analysis, and visualizations from the blood drive.