Official trainings from Microsoft https://learn.microsoft.com/en-us/
Microsoft word https://support.microsoft.com/en-au/office/word-for-windows-training-7bcd85e6-2c3d-4c3c-a2a5-5ed8847eae73
Microsoft Powerpoint https://support.microsoft.com/en-au/office/powerpoint-for-windows-training-40e8c930-cb0b-40d8-82c4-bd53d3398787
Microsoft Excel https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb
Keyboard typing https://keybr.com/
Objective: Familiarize students with the physical components of a computer and their functions.
Activities:
Identify and describe the main hardware components: motherboard, CPU, RAM, storage devices, power supply, and peripherals.
Hands-on activity: Disassemble and reassemble a desktop computer.
Demonstrate the connections and ports on a computer cabinet.
Objective: Understand the basics of DOS and its commands.
Activities:
Introduction to DOS: History, importance, and basic concepts.
Execute basic DOS commands: dir, cd, md, rd, copy, del.
Create and navigate directories, and manage files using DOS commands.
Objective: Learn the features and functionalities of the Windows operating system.
Activities:
Introduction to Windows: User interface, file management, and settings.
Explore Control Panel and System Settings.
Install and uninstall software applications.
Objective: Develop skills in creating and formatting documents using MS Word.
Activities:
Introduction to MS Word: Interface and basic functions.
Create a document, apply formatting, and insert images, tables, and charts.
Use advanced features: Styles, templates, mail merge, and macros.
Objective: Learn to create, manage, and analyze data using MS Excel.
Activities:
Introduction to MS Excel: Interface and basic functions.
Create spreadsheets, enter data, and apply formatting.
Use formulas, functions, and create charts for data analysis.
Data Management: Sort, filter, and use pivot tables to analyze data.
Objective: Master the creation and delivery of professional presentations using MS PowerPoint.
Activities:
Introduction to MS PowerPoint: Interface and basic functions.
Create a presentation: Slides, layouts, themes, and transitions.
Insert multimedia elements: Images, audio, video, and charts.
Apply animations and practice delivering a presentation.
Objective: Understand the basics of database management using MS Access.
Activities:
Introduction to MS Access: Interface and basic concepts.
Create a database, design tables, and define relationships.
Enter data, create queries, and generate reports.
Use forms for data entry and navigation.
Objective: Learn about internet services and effective use of the internet for research and communication.
Activities:
Introduction to the internet: Browsers, search engines, and online safety.
Effective web searching techniques.
Use email services: Create, send, receive, and manage emails.
Explore online collaboration tools: Google Drive, Dropbox, and cloud services.
Objective: Combine and utilize different MS Office applications for comprehensive tasks.
Activities:
Import and link data between MS Word, MS Excel, and MS Access.
Create a report in MS Word using data from MS Excel and MS Access.
Develop a presentation in MS PowerPoint using data and charts from MS Excel.
Use mail merge in MS Word with an MS Excel data source.
Objective: Apply the knowledge gained in a comprehensive project and review key concepts.
Activities:
Assign a project that requires using multiple MS Office applications (e.g., create a business report with data analysis and a presentation).
Students work in groups to complete the project, integrating various skills learned.
Present the project and receive feedback.
Review key concepts and address any remaining questions or challenges.