COMPUTER STUDIES COURSE OUTLINE
A. MICROSOFT PACKAGES
1. Microsoft Word
• Basics of Word: Document creation, editing.
• Formatting and Layout: Text, paragraph formatting.
• Working with Graphics: Images, tables.
• Advanced Features: Mail merge, track changes.
2. Microsoft Excel
• Basics of Excel: Worksheets, data entry.
• Formulas and Functions: Calculations, data manipulation.
• Data Analysis: PivotTables, charts.
• Advanced Techniques: Macros, data tools.
3. Microsoft Access
• Database Basics: Creating databases, tables.
• Queries and Reports: Data retrieval, reporting.
• Forms and Relationships: Data entry, table relationships.
• Advanced Database Management: Security, optimization.
4. Microsoft PowerPoint
• Creating Presentations: Slides, layouts.
• Adding Content: Text, images, animations.
• Design and Layout: Themes, transitions.
• Presenting: Slide shows, speaker tools.
5. Microsoft Publisher
• Basics of Publisher: Creating publications.
• Designing Publications: Layouts, graphics.
• Working with Text and Images: Text boxes, image handling.
• Finalizing Publications: Printing, sharing.
6. Data Analysis using Excel
• Data Preparation: Cleaning, organizing.
• PivotTables and Charts: Data summarization, visualization.
• Descriptive Statistics: Using Excel for stats.
• Advanced Analysis: Regression, ANOVA using ToolPak.
[Link] AND DESIGNING AND DATA PREPARATION
1. Graphics and Design
• Principles of Design: Balance, contrast, alignment.
• Graphic Design Tools: Using software like Adobe Illustrator, Photoshop.
• Creating Visuals: Logos, brochures, digital graphics.
• Typography and Color: Using typography, color theory.
• Design for Digital Media: Web, social media graphics.
2. Data Preparation
• Importance of Data Prep: Clean data for analysis.
• Data Cleaning Techniques: Handling missing values, outliers.
• Data Transformation: Formatting, normalization.
• Data Validation: Ensuring accuracy, consistency.
• Tools for Data Prep: Using Excel, Python, etc.
[Link] MEETING AND MS TEAMS APP
1. Zoom Meetings
• Setting Up Zoom Meetings: Scheduling, invitations.
• Joining and Hosting Meetings: Audio/video settings, controls.
• Meeting Features: Screen sharing, chat, reactions.
• Security and Settings: Passwords, waiting rooms.
2. Microsoft Teams
• Introduction to Teams: Overview, setup.
• Channels and Conversations: Organizing discussions.
• Meetings and Calls: Scheduling, joining meetings.
• Collaboration Tools: Files, integrations.
• Managing Teams: Settings, permissions.