Computer Information and Technology
Master Essential IT Skills - Google Sheets, Excel, Programming Logic, Prompt Engineering & Git
2 Months
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
Ready to Register in This Course?
Join thousands of students who have transformed their careers. Start your journey today!