🏫 Programming & Software Development

Computer Information and Technology

Master Essential IT Skills - Google Sheets, Excel, Programming Logic, Prompt Engineering & Git

Duration

12 Weeks

Weekly Hours

4 Hours

Course Incharge

Muzammil Bilwani

📋 Prerequisites

✓ No prerequisites. Open to beginners who can use phones and computers.

📖 Course Description

This course offers a hands-on introduction to essential IT tools for complete beginners. Learn spreadsheet mastery, logical thinking, AI prompt engineering, networking basics, and version control with Git. Designed to make you tech-confident and ready for further learning.

What You Will Learn

Master Google Sheets/Excel with practical real-world scenarios

Build strong logical thinking and problem-solving skills

Write effective prompts to maximize productivity with ChatGPT and Gemini

Understand networking fundamentals (IP, DNS, domains)

Use Git and GitHub for version control and collaboration

Build a Generative AI project as your final portfolio piece

Course Outline

Introduction to the IT World & Career Paths

→What is Information Technology and why does it matter?
→IT career paths: developer, designer, data analyst, content creator, etc.
→Freelancing vs jobs vs starting your own tech business
→Overview of course structure and learning approach
→Hands-on: Explore tech job portals and join online tech communities

Google Sheets/Excel Basics – Getting Started

→Understanding spreadsheets: cells, rows, columns, and sheets
→Basic formatting: fonts, colors, borders, alignment
→Entering and organizing data effectively
→Basic formulas: SUM, AVERAGE, MIN, MAX, COUNT
→Hands-on: Create a personal expense tracker

Google Sheets/Excel – Practical Data Management

→Sorting and filtering data for better insights
→Using conditional formatting to highlight important data
→Data validation and dropdown lists
→Freezing rows/columns for easier navigation
→Hands-on: Build an inventory management sheet or student grade tracker

Google Sheets/Excel – Advanced Formulas & Functions

→IF statements for decision-making in spreadsheets
→VLOOKUP and XLOOKUP for searching data
→COUNTIF, SUMIF for conditional calculations
→Working with dates and text functions
→Hands-on: Create a sales commission calculator with multiple conditions

Google Sheets/Excel – Data Visualization & Pivot Tables

→Creating charts: bar, line, pie, and combo charts
→Customizing chart colors, labels, and legends
→Introduction to Pivot Tables: summarizing large datasets
→Grouping and analyzing data with Pivot Tables
→Hands-on: Analyze sales data or survey results with visualizations and pivots

Prompt Engineering Basics – Working with AI Tools

→What is Generative AI? Introduction to ChatGPT and Gemini
→How to write clear and effective prompts
→Prompt patterns: question-asking, instruction-giving, role-playing
→Using AI for brainstorming, writing, and problem-solving
→Hands-on: Generate content, summaries, and solutions using AI tools

Advanced Prompt Engineering & Workflow Automation

→Chaining prompts for complex tasks
→Using AI to generate spreadsheet formulas and scripts
→Creating templates and workflows with AI assistance
→Ethical considerations when using AI
→Hands-on: Build an automated email template or content calendar using AI

Logic Building for Programming – Fundamentals

→What is programming and why logic matters
→Variables, data types, and basic expressions
→Understanding conditions (if/else) and decision-making
→Introduction to loops (for, while)
→Hands-on: Solve logic puzzles using flowcharts or block-based coding (Scratch)

Logic Building – Practical Problem Solving

→Writing simple algorithms step-by-step
→Breaking down problems into smaller tasks
→Introduction to pseudocode and basic Python syntax
→Using online coding platforms (Replit, Google Colab)
→Hands-on: Build a simple calculator, age checker, or quiz program

Networking Basics: IP, DNS & Domains

→What is an IP address and how does the internet work?
→Understanding DNS: how domain names connect to websites
→What is a domain name and how to register one
→Basic hosting concepts and web infrastructure
→Hands-on: Use tools like whois, nslookup, and ping to explore domains

Introduction to Git & GitHub

→What is version control and why it's important
→Installing Git and understanding repositories
→Basic Git commands: init, add, commit, push, pull
→Creating a GitHub account and pushing your first project
→Hands-on: Initialize a project folder and upload it to GitHub

Final Project: Generative AI Portfolio Project

→Project Planning: Define your AI project idea
→Build a Generative AI project using ChatGPT or Gemini:
→ - AI-powered chatbot
→ - Content generator for social media
→ - Automated spreadsheet report builder
→Create documentation: CV, project description, and demo
→Upload project to GitHub with README
→Present your project to the class
→Review, reflection, and next steps in your tech journey.

📊 Grading Criteria

Component	Percentage
Quizzes	20%
Class Participation / Attendance	15%
Projects	25%
Final Projects	40%
Total	100%

Ready to Register in This Course?

Join thousands of students who have transformed their careers. Start your journey today!