70 lines
4.8 KiB
Markdown
70 lines
4.8 KiB
Markdown
# 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](https://www.gavilan.edu/committee/curriculum/docs/cor/CSIS/CSIS_1.pdf) (August 2021)
|
||
- [Gavilan Catalog](https://gavilan.cc/catalog/course.php?course=csis1)
|