🏫 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 IT & Spreadsheet Basics

→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
→Spreadsheet fundamentals: cells, rows, columns, and sheets
→Basic formatting: fonts, colors, borders, alignment
→Basic formulas: SUM, AVERAGE, MIN, MAX, COUNT
→Hands-on: Explore tech job portals + Create a personal expense tracker

Google Sheets/Excel – Data Management & Advanced Formulas

→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
→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: Build an inventory/grade tracker + Sales commission calculator

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 to Advanced

→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
→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: Generate content with AI + Build an automated email template or content calendar

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 & Introduction to Git & GitHub

→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
→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: Explore domains with whois/nslookup/ping + Initialize and upload a project 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!