csis1/README.md

CSIS 1 — Computer Literacy (MS Office)

Course Overview

• Units: 2 (Lecture only)
• Contact Hours: 2/week × 18 weeks = 36 total
• Outside Hours: 72 (2:1 ratio)
• Grading: Letter grade or Pass/No Pass
• Delivery: In-person, hybrid, online sync/async
• Textbook: New Perspectives Collection: Technology for Success (Cengage, 2020)

Student Learning Outcomes

1. Describe the role of technology in personal and professional life; identify appropriate technology to support productivity, learning, and career growth.
2. Describe basic principles of computer safety and security in a networked world. Demonstrate working knowledge of OS functions, software installation, and productivity suites.

Weekly Schedule (from COR)

Week	Hours	Topic
1-2	4	Computer Hardware & Peripheral Devices
3	2	Software, Working with Files, Getting Started with Apps
4-6	6	Word Processing (Creating, Formatting, Finalizing Documents)
7-9	6	Spreadsheets (Creating, Formatting, Finalizing Worksheets)
10-11	4	Presentations (Creating & Finalizing)
12-14	6	Databases (Creating & Finalizing)
15-16	4	Networks, Email, Browsing the Web
17	2	Safety, Privacy, and Security
18	2	Final Exam

Evaluation

• Objective exams: 50%
• Skill demonstrations: 20%
• Writing assignments: 15-20%
• Problem-solving: 15-20%

File Structure

One markdown file per week (or topic block):

• week-01-02-hardware.md — Computer Hardware & Peripherals
• week-03-software.md — Software & Files
• week-04-06-word.md — Word Processing
• week-07-09-spreadsheets.md — Spreadsheets
• week-10-11-presentations.md — Presentations
• week-12-14-databases.md — Databases
• week-15-16-networks.md — Networks, Email, Web
• week-17-security.md — Safety, Privacy, Security
• week-18-final.md — Final Exam Review

6-Week Compressed Schedule (Online Async)

Same content and contact hours (36), compressed into 6 weeks at 6 hours/week. Designed for online asynchronous delivery — each week has a heavier workload but covers complete topic blocks so students finish one subject before moving to the next.

Week	Hours	Topics	Files	Notes
1	6	Hardware, Peripherals, Software & Files	week-01-02, week-03	Foundation week. Concepts only — no Office apps yet. Combine the hardware + software content. Assign "My Computer Inventory" + file organization exercise.
2	6	Word Processing (full unit)	week-04-06	All 3 Word lectures in one week. Works well async — students can pace themselves through creating, formatting, and finalizing. Major deliverable: Professional Letter or Resume.
3	6	Spreadsheets (full unit)	week-07-09	All 3 Excel lectures. Heaviest skill-building week. Assign the Personal Budget project as the capstone. Midterm exam at end of week (covers Weeks 1–3).
4	6	Presentations + Databases (intro)	week-10-11, week-12-14 (Lecture 12 only)	PowerPoint is lighter — 2 lectures fit in ~3 hours, leaving room to introduce database concepts (what/why, tables, data types). Assign the 5-Minute Presentation project.
5	6	Databases (forms, queries, reports) + Networks & Web	week-12-14 (Lectures 13–14), week-15-16	Finish databases with hands-on queries and reports. Transition to networks/email/web — these are conceptual and read well async. Assign the Mini-Database Project.
6	6	Security & Privacy + Final Review + Final Exam	week-17, week-18	Security content (~2 hrs) + cumulative review (~2 hrs) + Final Exam (~2 hrs). Security pairs naturally with the networks material from Week 5.

Compressed Schedule Notes

• Pacing: Each week maps to roughly 3 full-length lectures of content. In async, students replace lecture time with recorded video modules (15–20 min each) + readings + hands-on practice.
• Assessments: Consider a midterm after Week 3 and final after Week 6 instead of one big final. Keeps students accountable in a compressed format.
• Discussion boards: Replace in-class discussions with weekly discussion posts. The discussion questions in each file work well for this.
• Due dates: Set mid-week check-ins (e.g., discussion post due Wednesday, assignment due Sunday) to prevent students from falling behind.
• Office hours: Offer 2–3 live Zoom drop-in sessions per week. Compressed courses need more support touchpoints.
• Late policy: Be explicit up front — 6 weeks leaves zero room for catching up. Consider a "1 free late day" policy rather than open-ended extensions.

Source

• COR PDF (August 2021)
• Gavilan Catalog