Computer Fundamentals
Desktop Computing & Microsoft Office for Healthcare Professionals
5
Weeks
15
Lessons
5
Quizzes
5
Discussions
5
Assignments
1,000
Total Points
View Full Course Syllabus
Before You Begin
Device Setup, Software Readiness & Foundation Skills
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.
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.
1
Week
Computing Foundations & Professional Communication
Software Concepts, Windows, Web Browsers & Outlook
200 pts
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
10 questions covering software concepts, Windows, file management, web browsers, and Outlook.
Discussion
Technology is Everywhere!
How technology impacts your daily life and future healthcare career.
Assignment
Blood Drive Email & Appointment
Compose a professional email and create calendar appointments in Outlook for a clinic blood drive.
2
Week
Document Creation with Microsoft Word
Creating, Formatting & Polishing Healthcare Documents
200 pts
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
10 questions covering document creation, formatting, styles, themes, templates, and professional tools.
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.
3
Week
Presentations with Microsoft PowerPoint
Creating, Enhancing & Delivering Healthcare Presentations
200 pts
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
10 questions covering presentations, SmartArt, animations, CARP design, Slide Master, and delivery.
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.
4
Week
Spreadsheets with Microsoft Excel
Excel Foundations, Formulas & Office Integration
200 pts
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
10 questions covering Excel foundations, formulas, functions, sorting, filtering, and data integration.
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.
5
Week
Advanced Excel & Healthcare Databases
Charts, Data Visualization & Database Concepts
200 pts
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
10 questions covering charts, COUNTIF/SUMIF, databases, EHR, HIPAA, PivotTables, and XLOOKUP.
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.