🚀 What is Microsoft SharePoint?

SharePoint is a web-based platform in Microsoft 365 used for:

• Document management
• Team collaboration
• Intranet (internal websites)
• Workflow automation

Think of it as a central hub for files, communication, and teamwork.

🧭 1. Types of SharePoint Sites

🔹 Team Site (for collaboration)

7

Used by departments or teams:

• Upload files
• Share documents
• Work together in real-time

🔹 Communication Site (for announcements)

6

Used for:

• News updates
• Policies
• Institutional information (like intranet)

🛠️ 2. How to Access SharePoint

Step-by-step:

1. Go to office.com
2. Sign in with your institutional email
3. Click the App Launcher (9 dots)
4. Select SharePoint

📂 3. Working with Documents

🔹 Upload Files

• Click Documents
• Click Upload
• Select file or drag & drop

🔹 Create Files

• Click New
• Choose:
  • Word
  • Excel
  • PowerPoint

🔹 Share Files

• Click file → Share
• Enter email → set permission:
  • View
  • Edit

👥 4. Managing Permissions (Very Important)

You can control who sees what:

• Owners → full control
• Members → edit
• Visitors → read only

👉 For your environment, this is critical for data security.

🧱 5. Creating a SharePoint Site

Steps:

1. Go to SharePoint homepage
2. Click Create Site
3. Choose:
   • Team Site OR Communication Site
4. Enter:
   • Site name
   • Description
5. Add members

📰 6. Creating Pages & News

• Click New → Page
• Add:
  • Text
  • Images
  • Videos
• Publish

👉 Useful for:

• Announcements
• Training materials
• Internal memos

🔄 7. Integration with Other Tools

SharePoint works well with:

• Microsoft Teams (files tab)
• OneDrive (personal storage)
• Power Automate (automate approvals)

⚡ 8. Practical Use Cases (For You)

🎓 In Education (Covenant University style)

• Course materials repository
• Staff document sharing
• Departmental intranet

🏢 Admin Work

• Memo sharing
• Meeting documents
• Policy archives

💡 Automation Example

• Upload file → approval workflow → email notification

🎯 9. Quick Hands-on Exercise

Try this now:

1. Create a Team Site
2. Upload:
   • A memo (Word)
   • A dataset (Excel)
3. Share with a colleague
4. Create a simple announcement page

🔥 Pro Tips

• Use folders + metadata instead of dumping files
• Always manage permissions carefully
• Use version history to track changes
• Sync with your PC for offline access

power automate: beginner to pro

 

POWER AUTOMATE BEGINNERS TUTORIAL

 

🚀 12-WEEK FULL-STACK CURRICULUM (React + Node)

 

🧠 Goal

By the end, students will build a complete web app (School Portal / LMS System) with:

• User login
• Dashboard
• Database
• Deployment

📘 WEEK 1–2: Web Foundations (Recap + Alignment)

Focus:

• HTML structure
• CSS styling
• JavaScript basics

What to Teach:

• Tags, forms, tables
• Flexbox & layout
• Variables, functions, arrays
• DOM manipulation

Practical:

👉 Build:

• Student registration form
• Simple result table UI

⚛️ WEEK 3–4: React Fundamentals

Using:

• React

Topics:

• Components
• Props
• State (useState)
• Events
• JSX

Practical:

👉 Build:

• Student Dashboard UI
• Profile Card Component
• Course List UI

🔄 WEEK 5: React Advanced

Topics:

• useEffect
• API calls (Fetch / Axios)
• React Router (Navigation)
• Forms handling

Practical:

👉 Build:

• Multi-page app:
  • Home
  • Dashboard
  • Login page

🌐 WEEK 6: Backend Introduction

Using:

• Node.js
• Express.js

Topics:

• What is backend?
• Creating server
• Routes
• Middleware

Practical:

👉 Build:

• Simple API:
  • /students
  • /courses

🗄️ WEEK 7: Database Integration

Using:

• MongoDB

Topics:

• CRUD operations
• Models (Mongoose)
• Connecting Node to DB

Practical:

👉 Build:

• Save student data
• Fetch and display records

🔐 WEEK 8: Authentication System

Topics:

• Signup / Login
• Password hashing (bcrypt)
• JWT authentication

Practical:

👉 Build:

• Login system
• Protected dashboard

🔗 WEEK 9: Full Stack Integration

Topics:

• Connect React to API
• Axios
• Handling responses

Practical:

👉 Build:

• Frontend form → backend → database
• Display real-time data

🎨 WEEK 10: UI/UX + Styling

Tools:

• Tailwind CSS / Bootstrap

Topics:

• Clean UI design
• Responsive layout

Practical:

👉 Upgrade:

• Dashboard UI
• Cards, tables, navbars

☁️ WEEK 11: Deployment

Platforms:

• Frontend: Vercel / Netlify
• Backend: Render / Railway
• Database: MongoDB Atlas

Practical:

👉 Deploy:

• Live website
• Public URL

🏁 WEEK 12: FINAL PROJECT

Project Options:

Students must choose one:

1. School Management Portal
2. LMS Dashboard
3. E-commerce Store
4. Event Registration Platform
5. Result Checker System

📂 Sample Project Structure

project/
  client/   (React)
  server/   (Node/Express)

APP DEVELOPMENT

 App development isn’t one single path—it’s a whole ecosystem. The “best” technology depends on what kind of app you want to build (mobile, web, desktop, AI-powered, etc.). Let me break it down clearly so you can choose wisely 👇

🚀 1. Mobile App Development Technologies

📱 Native Apps (Best performance)

Built specifically for one platform.

• Android
  • Java
  • Kotlin (modern standard)
• iOS
  • Swift (main language today)
  • Objective-C (older apps)

✅ Best for: High-performance apps like banking, games, heavy systems
❌ Downside: You build separately for Android & iOS

🔁 Cross-Platform Apps (Write once, run everywhere)

• Flutter (Dart)
• React Native (JavaScript)
• Ionic
• Xamarin

✅ Best for: Startups, MVPs, faster development
🔥 Flutter is currently one of the hottest (very smooth UI)

🌐 2. Web App Development (Runs in browser)

Frontend (What users see)

• HTML
• CSS
• JavaScript
• Frameworks:
  • React
  • Vue.js
  • Angular

Backend (Server logic)

• Node.js (JavaScript)
• Python (Django, Flask)
• PHP (Laravel)
• Java (Spring Boot)

Database

• MySQL
• PostgreSQL
• MongoDB

✅ Best for: LMS platforms, portals (like your Moodle projects), dashboards

💻 3. Desktop App Development

• Electron (JavaScript)
• C# (.NET)
• Java
• Python (Tkinter, PyQt)

Example: Apps like VS Code use Electron

🤖 4. AI-Powered Apps (Hot right now 🔥)

• Python (main AI language)
• TensorFlow / PyTorch
• APIs like:
  • OpenAI
  • Google AI

✅ Best for:

• Chatbots
• Smart assistants
• Automated systems (great for your registry AI training!)

⚡ 5. No-Code / Low-Code Platforms (Fastest way)

• FlutterFlow
• Adalo
• Bubble

✅ Best for:

• Beginners
• Rapid prototypes
• Business apps without heavy coding

🧠 6. Backend-as-a-Service (BaaS)

Instead of building backend from scratch:

• Firebase
• Supabase

Features:

• Authentication
• Database
• Hosting
• Push notifications

🎯 For YOU (based on what you do)

Since you:

• Build LMS (Moodle)
• Teach web dev (ENT121)
• Work in EdTech

👉 The best stack for you is:

✅ Web + Mobile combo

• Frontend: React or HTML/CSS/JS
• Backend: Node.js or PHP
• Mobile: Flutter
• Hosting: Firebase or cPanel

🔥 This lets you build:

• School portals
• LMS mobile apps
• Result systems
• EdTech platforms

💡 Simple Recommendation Path

If you're teaching students:

👉 Start with:

1. HTML + CSS + JavaScript
2. Move to React
3. Introduce Flutter for mobile
4. Add Firebase for backend

⚠️ Reality Check

Don’t try to learn everything at once.

👉 Pick ONE path:

• Mobile → Flutter
• Web → React + Node
• Fast business apps → No-code

🚀 COURSE: WEB & APP DEVELOPMENT FOR PRACTICAL IMPACT

 

🎯 DELIVERY MODEL: 2–3 hours per session | 70% practical

🔹 WEEK 1: INTRO TO WEB DEVELOPMENT (FOUNDATION)

📘 LECTURE NOTES (DETAILED)

1. What is Web Development?

Web development is the process of building websites and web applications that run on the internet using browsers.

2. Types of Web Development

• Frontend → what users see
• Backend → server logic & database
• Fullstack → both

3. Real-Life Examples

• School portals
• Online banking
• E-commerce sites

4. Tools Setup

• Visual Studio Code
• Browser (Chrome)

🎤 FACILITATOR SCRIPT (EXPANDED)

“Look around you—everything is becoming digital.
If you can build websites, you can build income.

This course is not theory. You will build real projects.

By the end, you should be able to say:
👉 ‘I can create and deploy a website myself.’”

🧪 CLASS FLOW

1. Install VS Code
2. Create folder: webclass
3. Create file: index.html

💻 FIRST CODE

<!DOCTYPE html>
<html>
<head>
  <title>My First Website</title>
</head>
<body>
  <h1>Welcome to My Website</h1>
  <p>This is my first webpage.</p>
</body>
</html>

🏠 ASSIGNMENT

👉 Create “About Me” page with:

• Name
• Picture
• Short bio

🔹 WEEK 2: HTML (STRUCTURE)

📘 LECTURE NOTES

HTML Elements

• Headings: <h1> - <h6>
• Paragraph: <p>
• Links: <a>
• Images: <img>
• Lists: <ul>, <ol>

🎤 FACILITATOR SCRIPT

“HTML is the backbone of the web.
If HTML is weak, everything is weak.”

💻 PRACTICAL CODE

<h1>My School</h1>

<p>Welcome to our school website</p>

<a href="https://google.com">Visit Google</a>

<img src="image.jpg" width="200">

<ul>
  <li>Home</li>
  <li>About</li>
  <li>Contact</li>
</ul>

🧪 CLASS PROJECT

👉 Build:

• Homepage
• About page
• Contact page

🏠 ASSIGNMENT

👉 Create a 3-page school website

🔹 WEEK 3: CSS (DESIGN)

📘 LECTURE NOTES

CSS Basics

• Colors
• Fonts
• Margins & padding

💻 CODE

body {
  background-color: #f4f4f4;
  font-family: Arial;
}

h1 {
  color: blue;
}

🎤 FACILITATOR SCRIPT

“Without CSS, your site looks like a government form.
CSS brings beauty and professionalism.”

🧪 CLASS PRACTICAL

• Style homepage
• Add colors
• Center content

🏠 ASSIGNMENT

👉 Design a modern landing page

🔹 WEEK 4: JAVASCRIPT (INTERACTION)

📘 LECTURE NOTES

Concepts:

• Variables
• Functions
• Events

💻 CODE

function greet() {
  alert("Welcome to our site!");
}

<button onclick="greet()">Click Me</button>

🎤 FACILITATOR SCRIPT

“JavaScript makes your site smart.
Without it, your site cannot respond.”

🧪 CLASS PRACTICAL

• Button alert
• Form validation

🏠 ASSIGNMENT

👉 Build calculator OR interactive form

🔹 WEEK 5: BUILDING A WEB APP

📘 LECTURE NOTES

What is a Web App?

A system where users interact and data is processed.

💻 CODE (REGISTRATION FORM)

<form>
  <input type="text" placeholder="Name">
  <input type="email" placeholder="Email">
  <button type="submit">Register</button>
</form>

🎤 FACILITATOR SCRIPT

“This is where you move from learning to building solutions.”

🧪 CLASS PRACTICAL

👉 Build event registration form

🏠 ASSIGNMENT

👉 Add:

• Validation
• Success message

🔹 WEEK 6: BACKEND (INTRO)

📘 LECTURE NOTES

Backend Handles:

• Data storage
• Processing

Tools:

• PHP
• OR Node.js

🎤 FACILITATOR SCRIPT

“Frontend collects data, backend keeps it safe.”

🧪 CLASS PRACTICAL

• Connect form to backend

🏠 ASSIGNMENT

👉 Submit form to backend

🔹 WEEK 7: DEPLOYMENT

📘 LECTURE NOTES

Hosting:

• GitHub
• Netlify
• Go54

🎤 FACILITATOR SCRIPT

“If your project is not online, it does not exist.”

🧪 CLASS PRACTICAL

👉 Deploy site live

🏠 ASSIGNMENT

👉 Share live link

🔹 WEEK 8: FINAL PROJECT

📘 PROJECT OPTIONS

• School portal
• Event app
• Online store

🎤 FACILITATOR SCRIPT

“This is your transition from student to developer.”

🧪 FINAL

Students present projects

🔥 BONUS (FOR YOUR BRAND)

🎯 FIRE CONFERENCE APP

• Registration
• Speaker page
• Countdown

🎓 FINAL CHARGE (USE THIS)

“Don’t just learn coding—use it to create value.
Skills open doors. Execution builds empires.”

WEB & APP DEVELOPMENT FOR PRACTICAL IMPACT

 

📚 🎤 COURSE TITLE

WEB & APP DEVELOPMENT FOR PRACTICAL IMPACT

🧩 FORMAT PER WEEK

Each week includes:

• Lecture Notes (what students see)
• Facilitator Script (what YOU say)
• Class Activities
• Assignments

🔹 WEEK 1: INTRO TO WEB DEVELOPMENT

📘 LECTURE NOTES

What is Web Development?

Web development is the process of creating websites and web applications that run in a browser.

Types:

• Frontend (what users see)
• Backend (server & database)
• Fullstack (both)

Tools Needed:

• Visual Studio Code
• Web browser (Chrome)

🎤 FACILITATOR SCRIPT

“Good day everyone. Welcome to a life-changing course.
By the end of this class, you won’t just know web development—you will build real apps.

Now let me ask you—how many of you use websites daily?
From banking apps to school portals… that’s web development.

Frontend is what you see. Backend is what works behind the scenes.

This course is 70% practical. You will build as we go.”

🧪 CLASS ACTIVITY

• Install VS Code
• Create first file: index.html

🏠 ASSIGNMENT

Create a simple “About Me” page

🔹 WEEK 2: HTML

📘 LECTURE NOTES

HTML Structure:

<!DOCTYPE html>
<html>
<head>
  <title>My Page</title>
</head>
<body>
  <h1>Hello World</h1>
</body>
</html>

Elements:

• Headings <h1>
• Paragraph <p>
• Links <a>
• Images <img>
• Lists <ul>, <ol>

🎤 FACILITATOR SCRIPT

“HTML is the skeleton of every website.
Without HTML, there is no structure.

Think of it like building a house:

• HTML = blocks
• CSS = paint
• JavaScript = electricity”

🧪 CLASS ACTIVITY

Build:
👉 A simple homepage with:

• Title
• Image
• Link

🏠 ASSIGNMENT

Create a 3-page school website

🔹 WEEK 3: CSS

📘 LECTURE NOTES

Example:

body {
  background-color: #f4f4f4;
  font-family: Arial;
}

Concepts:

• Colors
• Fonts
• Spacing
• Flexbox

🎤 FACILITATOR SCRIPT

“CSS is what makes a website beautiful.
Without CSS, your website looks like 1990.”

🧪 CLASS ACTIVITY

Style previous project:

• Add colors
• Add spacing

🏠 ASSIGNMENT

Design a modern landing page

🔹 WEEK 4: JAVASCRIPT

📘 LECTURE NOTES

Example:

function greet() {
  alert("Welcome!");
}

Concepts:

• Variables
• Functions
• Events
• DOM

🎤 FACILITATOR SCRIPT

“JavaScript gives life to your website.
Without it, your site is static.

With JavaScript, your site responds.”

🧪 CLASS ACTIVITY

• Create button → show alert
• Validate form

🏠 ASSIGNMENT

Build:
👉 Calculator OR interactive form

🔹 WEEK 5: BUILDING A WEB APP

📘 LECTURE NOTES

What is a Web App?

A website that allows user interaction and data processing.

Example:

• Registration system
• Dashboard

🎤 FACILITATOR SCRIPT

“Now we move from websites to apps.
This is where money is.”

🧪 CLASS ACTIVITY

Build:
👉 Event Registration Form

Fields:

• Name
• Email
• Phone

🏠 ASSIGNMENT

Add:

• Validation
• Success message

🔹 WEEK 6: BACKEND

📘 LECTURE NOTES

Backend Handles:

• Data storage
• Authentication
• Processing

Tools:

• PHP
• OR Node.js

🎤 FACILITATOR SCRIPT

“Frontend collects data.
Backend stores and processes it.

This is where real systems are built.”

🧪 CLASS ACTIVITY

Connect form → backend

🏠 ASSIGNMENT

Submit form data to server

🔹 WEEK 7: DEPLOYMENT

📘 LECTURE NOTES

Hosting Platforms:

• GitHub
• Netlify
• Go54

🎤 FACILITATOR SCRIPT

“If your project is not online, it does not exist.”

🧪 CLASS ACTIVITY

Deploy website

🏠 ASSIGNMENT

Share live link

🔹 WEEK 8: FINAL PROJECT

📘 LECTURE NOTES

Students build:

• School portal
• Event app
• Online store

🎤 FACILITATOR SCRIPT

“This is your moment.
You are no longer learners—you are builders.”

🧪 FINAL PRESENTATION

Students present projects

🔥 BONUS: YOUR SIGNATURE PROJECT

🎯 FIRE CONFERENCE APP

Students build:

• Registration system
• Speaker section
• Countdown timer

🎓 CLOSING SCRIPT

“Skills pay.
Knowledge is not enough—execution is everything.

Don’t just learn—build, publish, and monetize.”

📊 MICROSOFT EXCEL TUTORIAL (BEGINNER → ADVANCED)

 

🟢 1. BEGINNER LEVEL – Getting Started

📌 What is Excel?

Excel is a spreadsheet tool used for:

• Data entry
• Calculations
• Analysis
• Reporting

🧱 Excel Structure

• Workbook → Entire file
• Worksheet → Sheet inside workbook
• Cell → Intersection (e.g., A1)
• Row → Horizontal (1,2,3…)
• Column → Vertical (A,B,C…)

✍️ Entering Data

• Text → Names
• Numbers → Scores
• Dates → 16/04/2026

⚡ AutoFill (VERY IMPORTANT)

Drag the small square to:

• Continue numbers (1,2,3…)
• Copy formulas
• Fill dates

🟡 2. BASIC FORMULAS (FOUNDATION)

➕ Arithmetic

=A1 + B1
=A1 - B1
=A1 * B1
=A1 / B1

📊 Common Functions

=SUM(A1:A10)
=AVERAGE(A1:A10)
=MAX(A1:A10)
=MIN(A1:A10)
=COUNT(A1:A10)

🎯 Example Table

Item	Cost	Selling	Profit
Pen	50	100	=C2-B2

🟠 3. INTERMEDIATE LEVEL

🔀 IF Function (Decision Making)

=IF(A1>=50, "Pass", "Fail")

🔍 VLOOKUP (VERY POWERFUL)

=VLOOKUP(A2, A1:C10, 3, FALSE)

👉 Use it to:

• Find student results
• Retrieve prices
• Match records

🔗 CONCATENATION

=A1 & " " & B1

👉 Combine First Name + Last Name

🎨 Conditional Formatting

Highlight automatically:

• Fail scores (red)
• High scores (green)

🔵 4. DATA MANAGEMENT

🔽 Sorting

• A → Z
• Highest → Lowest

🔍 Filtering

Show only:

• Passed students
• Specific department

📌 Data Validation

Restrict input:

• Only numbers
• Dropdown list

🔴 5. ADVANCED LEVEL

🧮 Pivot Tables (🔥 VERY IMPORTANT)

👉 Used for:

• Summaries
• Reports
• Dashboards

Example:

• Total sales by department
• Student performance summary

📈 Charts

Types:

• Bar Chart
• Pie Chart
• Line Chart

👉 Convert data into visuals

🔁 Advanced Functions

INDEX + MATCH (Better than VLOOKUP)

=INDEX(C1:C10, MATCH(A2, A1:A10, 0))

COUNTIF / SUMIF

=COUNTIF(A1:A10, "Pass")
=SUMIF(A1:A10, "Pen", B1:B10)

⚙️ 6. AUTOMATION (ADVANCED)

🔹 Flash Fill

Auto-completes patterns

🔹 Macros (Intro)

• Record repetitive tasks
• Automate work

🔹 Power Query (Advanced Users)

• Clean large data
• Import data

🧑‍🏫 7. TEACHING FLOW (FOR YOUR CLASS)

🟢 Day 1:

• Excel Interface
• Data Entry
• AutoFill

🟡 Day 2:

• Formulas & Functions

🔵 Day 3:

• IF, VLOOKUP
• Data Validation

🔴 Day 4:

• Pivot Tables
• Charts

🎯 8. PRACTICAL CLASS WORK

✅ Task 1:

Create student result sheet:

• Name
• Score
• Grade (IF)

✅ Task 2:

Create business sheet:

• Cost price
• Selling price
• Profit/Loss

✅ Task 3:

Filter:

• Only students who passed

✅ Task 4:

Create chart for results💡 REAL-LIFE APPLICATION (VERY IMPORTANT)

You can use Excel for:

School results

• Financial records
• Attendance tracking
• Registry operations (very relevant to your training 🔥)

🚀 PRO TEACHING TIP (FOR YOU)

When teaching:
👉 Don’t explain too much
👉 Let them DO more practicals