The objective of this course is to equip college students with essential digital skills needed for academic, professional, and collaborative work environments. Through hands-on training in Microsoft Office (Word & PowerPoint) and Google Workspace tools (Docs, Slides, Drive, Forms, and Sheets), students will learn to:

• Create and format professional documents and presentations

• Collaborate effectively using cloud-based tools

• Organize digital files securely and efficiently

• Collect, manage, and visualize data for academic and project use

• Apply digital tools to enhance productivity in educational and workplace settings

All 2nd Semester students from the discipline of Commerce, Education and Sociology who want to gain practical knowledge, skills to confidently comprehend and learners with basic computer literacy who want to advance their skills in document creation, presentation, cloud storage, and data handling. 

Higher Secondary and Basic Computer Aptitude. 

🗓️ 09th to 26th June, 2025

💸 Course Fee Nil

📢Open for all

This course provides hands-on training in key digital tools used for academic, professional, and collaborative tasks. The course covers:

📄 Module 1: Digital Collaboration with Google Workspace 1

• Introduction to Digital Productivity Tools:
  
  

  • Overview of digital tools and work culture
    
    

  • Introduction to Google Workspace & Microsoft Office
    
    

  • Setting up Google Accounts, navigating the dashboard
    
    

• Google Drive & Gmail for Efficient Communication:

• File organization, sharing, and access levels
  
  

• Gmail features: labels, filters, signatures
  
  

• Integration of Drive with Docs/Sheets/Slides

• Google Sheets:

• Entering and formatting data
  
  

• Basic formulas (SUM, AVERAGE, IF)
  
  

• Charts and data visualization
  
  

• Sharing and collaboration

• Google Docs:

• Creating and editing documents
  
  

• Collaboration tools: comments, suggestions, and sharing
  
  

• Version history and add-ons

🤝 Module 2: Microsoft Office Essentials 1:

• Microsoft Word:

• Formatting tools, styles, and templates
  
  

• Inserting tables, pictures, page breaks, headers/footers
  
  

• Referencing tools (table of contents, citations)

• Microsoft Excel:

• Basic formatting, formulas and functions
  
  

• Sorting, filtering, and conditional formatting

• Charts, pivot tables, and data analysis tools

• Website Development for Beginners:

• What is a website, types of websites
  
  

• Basic structure of a webpage

• Hands-on: Creating and publishing a site
  
  

• Adding text, images, links, and videos
  
  

• Creating multiple pages and navigation menus

☁️ Module 3: Digital Collaboration with Google Workspace 2 &  Microsoft Office Essentials 2

• Google Forms & Google Keep:

• Creating quizzes, surveys, feedback forms
  
  

• Viewing and analyzing responses
  
  

• Using Google Keep for notes and reminders

• Microsoft PowerPoint:

• Creating visually appealing slides
  
  

• Using animations and transitions
  
  

• SmartArt and multimedia integration

• Google Slides:

• Creating presentations from scratch or templates

• Inserting images, videos, and charts
  
  

• Sharing, commenting, and presenter view

ADD ON COURSE “Collaborate, Create, Present: A Hands-on Guide to Digital Productivity” - Google Docs 

📘 Books & Guides

1. "Office 365 All-in-One For Dummies" by Peter Weverka
   – A comprehensive guide covering Word, PowerPoint, and collaboration features in MS Office tools.
   
   

2. "Google Workspace User Guide" by Mike Smith
   – A practical handbook for beginners to understand Google Docs, Sheets, Slides, and Drive.
   
   

3. "Effective Data Storytelling" by Brent Dykes
   – For students interested in going deeper into data visualization and presentation skills.
   
   

🌐 Online Resources

4. Google Workspace Learning Center (by Google)
   – https://support.google.com/a/users
   – Official tutorials and tips for Google Docs, Slides, Sheets, Drive, and Forms.
   
   

5. Microsoft Support – Office Training Center
   – https://support.microsoft.com/en-us/training
   – Step-by-step guidance and videos for MS Word and PowerPoint.
   
   

6. GCF Global Free Tutorials
   – https://edu.gcfglobal.org/en/
   – Beginner-friendly tutorials on MS Office and Google tools.
   
   

7. YouTube Channels:
   
   

   • Technology for Teachers and Students
     
     

   • Leila Gharani (for MS Office tutorials)
     
     

   • Learn Google Spreadsheets

By the end of this course, students will be able to:

1. Create and Format Professional Documents
   Use MS Word and Google Docs to draft, format, and finalize academic and professional documents, including lesson plans, resumes, and reports.

2. Design and Deliver Engaging Presentations
   Develop effective slide decks using MS PowerPoint and Google Slides with themes, animations, and multimedia for impactful teaching or project delivery.

3. Collaborate in Real-Time using Google Workspace
   Apply real-time collaboration techniques through Google Docs and Slides, using shared access, comments, and version control for group assignments and projects.

4. Organize and Share Files Using Cloud Storage
   Efficiently manage and share files through Google Drive, using folders, permissions, and shared drives for organized and secure digital storage.

5. Collect and Visualize Data
   Create Google Forms to collect data and use Google Sheets to analyze and visualize responses through charts and tables for academic or project-based research.

6. Develop Practical Tech Skills for the Classroom and Workplace
   Apply digital tools to improve productivity, enhance communication, and support academic or teaching-related tasks effectively.

1. Assignment - 40

2. Attendance - 10 (90% Attendance Compulsory)

3. Final Exam & Presentation - 50

On passing Final Exam and 90% in attendance, a student will be eligible to receive his/ her certificate.

 https://forms.gle/yBRqaXBw7pbjQNZH8 

Will be uploaded after course completion