Latest / Ask The Computer Guru / Podcast 5 - Ask The Computer Guru
Transcript
- 0:00Host: Welcome to the Ask The Computer Guru podcast, where we discuss computer issues and their
- 0:01solutions. If you have a question you would like answered, please email me at
- 0:02help@askthecomputerguru.com.au, and I may discuss it on a future show. Thanks for listening.
- 0:03How CPUs Work
- 0:04Right now, as you're listening to this, whether it's on your phone, through a pair of Bluetooth earbuds, or coming
- 0:05out of your laptop speakers, there's a piece of silicon about the size of a postage stamp doing something
- 0:06extraordinary inside your device. It's sitting in total darkness, handling billions of tiny decisions every single
- 0:07second without missing a beat.
- 0:08It's called the CPU, or the central processing unit. Most people just refer to it as the brain of the computer. But
- 0:09calling it a brain almost gives it too much credit, and at the same time, doesn't do justice to the sheer
- 0:10engineering absurdity of what it actually is. So how does a polished piece of melted sand actually calculate
- 0:11universal-level math?
- 0:12Let's start with the brain analogy. A human brain is creative, associative, and great at pattern recognition. A
- 0:13CPU is actually pretty dumb. It can only do three things:
- 0:14•
- 0:15Standard arithmetic, like adding or subtracting numbers;
- 0:16•
- 0:17Simple logic, like checking if A equals B;
- 0:18•
- 0:19And moving data from one memory slot to another.
- 0:20That's it. The genius isn't in what it does; it's in how fast it does it. Think of a CPU as a hyper-efficient air traffic
- 0:21controller sitting at the middle of your motherboard. When you move your mouse, tap a key, or render a video
- 0:22frame, you aren't sending a complex command; you're sending a mountain of microscopic tasks. The CPU
- 0:23takes those tasks line by line and processes them through an endless loop called the instruction cycle.
- 0:24This cycle contains four parts:
- 0:251. Fetch: where it pulls an instruction from the system memory, which is the RAM.
- 0:262. Decode: it figures out what that instruction wants (for instance, add these two numbers together).
- 0:273. Execute: it runs the math.
- 0:284. Store: it writes the result back out so your screen or app can update.
- 0:29A modern processor repeats its fetch-decode-execute cycle billions of times every second. When you see a
- 0:30clock speed rated at 4 GHz, that literally means the CPU's internal clock ticks 4 billion times per second,
- 0:31driving that cycle forward with every tick.
- 0:32So how does a tiny block of metal physically perform those actions? If you were to zoom in with an electron
- 0:33microscope, a CPU chip isn't a solid block. It's a 3D metropolis of billions of microscopic switches called
- 0:34transistor gates. On modern manufacturing nodes, these transistors are only a few nanometers wide. To give
- 0:35you some scale, a single human hair is about 80,000 nanometers thick. You could fit tens of thousands of
- 0:36transistors inside the width of a strand of hair.
- 0:37Inside this city, three main neighborhoods handle the workload:
- 0:38•
- 0:39The Control Unit: The manager. It directs traffic, decodes incoming software commands, and tells the
- 0:40rest of the chip where data needs to go.
- 0:41•
- 0:42The Arithmetic Logic Unit (ALU): The mathematician. This is the raw engine that performs bitwise logic
- 0:43operations (AND, OR, NOT) and binary arithmetic.
- 0:44•
- 0:45Registers and Cache: The high-speed scratchpads. RAM is fast, but to a CPU running at 4 GHz, RAM is
- 0:46painfully far away. The CPU keeps ultra-fast local memory built directly onto its die, called L1, L2, and
- 0:47L3 cache, so it doesn't waste precious clock cycles waiting for data to travel across the motherboard.
- 0:48For decades, chip makers sped up computers simply by cranking up the clock frequency—more megahertz,
- 0:49then more gigahertz. But around the mid-2000s, engineers hit a wall known as the power wall. Running a single
- 0:50core faster produced so much heat and consumed so much power that the chip would literally melt itself.
- 0:51So the industry shifted strategies: instead of building one super-fast worker, let's put multiple workers on the
- 0:52same chip. That's where multi-core processors came from: dual-core, quad-core, eight-core. An eight-core
- 0:53CPU is essentially eight distinct processing engines working simultaneously.
- 0:54Then we have multithreading. This allows a single physical core to split its resources and handle two streams
- 0:55of tasks at once, tricking your operating system into seeing twice as many logical processors.
- 0:56Today, chips go even further with hybrid architectures. Take modern smartphones or desktop CPUs: they
- 0:57combine high-performance cores (P-cores) for heavy workloads like gaming or video editing, with highefficiency cores (E-cores) that handle background syncs and web browsing without draining your battery.
- 0:58So the next time you open a software app, launch a stream, or type a single letter on the screen, take a quick
- 0:59second to think about what just happened. Behind that simple action, billions of transistors opened and
- 1:00closed, millions of binary ones and zeroes flowed through logic gates, and a tiny square of silicon executed
- 1:01billions of instructions in a fraction of a millisecond. It's not magic; it's just humanity's most complex
- 1:02engineering feat hiding right under your keyboard.
- 1:03Musical Interlude
- 1:04My screen is blue
- 1:05Nothing is working right
- 1:06I lost my files
- 1:07Staring into the night
- 1:08Ask the Computer Guru
- 1:09Tell me what to do
- 1:10Ask the Computer Guru
- 1:11I am counting on you
- 1:12Troubleshooting a Dropping Wi-Fi Connection
- 1:13One of my neighbours had an issue where the wireless connection kept dropping out. The modem-router was
- 1:14connected with an Ethernet cable, and two mobile phones and a smart TV were connected via wireless. The
- 1:15signal was strong. When the wireless connection dropped, the computer which was connected with the
- 1:16Ethernet cable stayed connected, so the issue was something to do with the wireless part of the router.
- 1:17I initially tried to reset the modem; this did not fix the issue. I then replaced the modem, as I have seen this
- 1:18issue before where the wireless section of the modem stops working, probably due to a lightning strike during a
- 1:19storm. This time, replacing the modem didn't fix the problem. I was a bit confused, so I decided to call the
- 1:20service provider.
- 1:21Everything was working fine at their end. The technician suggested that I install a network analyzer app on my
- 1:22phone to see what other wireless networks were in the immediate area. There were another five, sometimes
- 1:23overlapping with my neighbour's connection. He asked what bandwidth I was transmitting at, and I told him 2.4
- 1:24GHz. He suggested that I got one that transmits on the 5 GHz frequency and upgrade to Wi-Fi 6. This apparently
- 1:25will stop other wireless networks interfering with my neighbour's connection.
- 1:26I was about to change over the modem, but needed the modem settings, so I decided to contact the internet
- 1:27service provider. I was told that they had detected a fault at the customer's home with the NBN connection.
- 1:28There was no mention of this when I called a few days earlier. As the problem is at the customer's home and
- 1:29not outside of the home, the customer had to contact an electrician to fix it.
- 1:30The fault had showed up a few weeks ago, which is when the customer's Wi-Fi started dropping out. So maybe
- 1:31this is causing the dropouts. So time will tell if this is the actual problem or not. Anyway, I will hang on to the 5
- 1:32GHz modem-router just in case.
- 1:33Musical Stager
- 1:34Ask the Guru
- 1:35We guide you through
- 1:36Google Workspace: Docs, Sheets, and Slides
- 1:37Today, I'm doing a deep dive into the core trio of Google Workspace: Google Docs, Google Sheets, and Google
- 1:38Slides. Individually, they are clean, reliable, cloud-native alternatives to Microsoft Word, Excel, and PowerPoint.
- 1:39But collectively, they've shifted how the modern world works, collaborates, and shares ideas in real time.
- 1:40Today, I want to unpack each tool: what it is, where it shines, a few game-changing features you might be
- 1:41overlooking, and how they connect to make your workflow genuinely effortless.
- 1:42Google Docs
- 1:43Let's start with Google Docs. At its heart, Google Docs is a cloud-based word processor. If you open up a blank
- 1:44document, the interface is refreshingly uncluttered. There isn't a sprawling 20-tab ribbon bar overwhelming
- 1:45your screen; you get a clean page and the tools you need to get thoughts down.
- 1:46Now, what makes Google Docs special isn't just that it runs in a browser tab; it's live multiplayer collaboration.
- 1:47Think back to the old workflow: you write a draft, save it, email it to three colleagues, and then spend Thursday
- 1:48night reconciling three different marked-up files into one master draft. Docs kills that entirely. Multiple people
- 1:49can jump in at the exact same second, type together, and leave targeted comments with @ mentions that
- 1:50assign actionable tasks.
- 1:51Beyond standard writing, there are three features in Docs that totally change how you use it:
- 1:521. Version History: Every single edit is autosaved continuously. If someone accidentally deletes three
- 1:53paragraphs or a whole section at 2:00 a.m. in the morning, you don't panic. You open the version
- 1:54history, look at the timestamp, and restore the exact state from two hours ago with just one click.
- 1:552. Suggesting Mode: Instead of editing a piece directly, switching to Suggesting lets you track changes
- 1:56just like an editor would. The document owner can accept or reject individual edits seamlessly.
- 1:573. Smart Canvas and Building Blocks: If you type the @ symbol in a blank document, Docs brings up a
- 1:58contextual menu. You can insert drop-down status menus, interactive meeting notes that sync directly
- 1:59to Google Calendar, project tracker tables, and person chips. It turns a static text document into a
- 2:00lightweight project management hub.
- 2:01Docs isn't built for hyper-complex desktop publishing or 500-page academic monographs with delicate
- 2:02footnote structures—tools like InDesign or Word still hold that niche. But for team memos, proposals, shared
- 2:03agendas, and fast-moving content, Google Docs is practically unbeatable.
- 2:04Google Sheets
- 2:05Now, let's look at Google Sheets, the grid that runs modern business operations. Google Sheets is a cloudnative spreadsheet platform. If you've ever used Microsoft Excel, the grid of rows, columns, formulas, and
- 2:06charts will look immediately familiar. But where Sheets separates itself is its native web architecture. Because
- 2:07it lives on the web, it talks to the rest of the internet with ridiculous ease.
- 2:08A lot of casual users treat Sheets just as a table to format numbers, but when you look under the hood, it has
- 2:09superpowers built right into the formula bar:
- 2:10•
- 2:11Web-Native Formulas: You have formulas like =GOOGLEFINANCE, which pulls real-time or historical
- 2:12stock and currency data straight into a cell without any external plugins, or IMPORTHTML and
- 2:13IMPORTXML, which can scrape data from a live website table into your spreadsheet in five seconds.
- 2:14•
- 2:15Collaboration Without Lockouts: If you've ever tried opening a shared spreadsheet on an older
- 2:16network drive only to see the dreaded prompt "File in use by Dave, read-only mode," you know the pain.
- 2:17In Sheets, dozens of people can view, filter, and edit data simultaneously.
- 2:18•
- 2:19Filter Views: Speaking of filtering, one of the best features ever built into Sheets is filter views. If you're
- 2:20looking at a sales sheet with 10,000 rows and you only want to see orders from Europe, creating a
- 2:21temporary filter view filters the view only for your screen. You don't mess up what your teammates on
- 2:22the other side of the world are looking at in the same spreadsheet.
- 2:23Whether you're balancing a monthly budget, building an inventory dashboard, or tracking marketing analytics,
- 2:24Sheets delivers real-time visibility without file corruption worries.
- 2:25Google Slides
- 2:26That brings us to Google Slides. Google Slides is a presentation and deck builder. In business, academia, and
- 2:27creative industries, slides are how ideas get approved, pitched, and taught.
- 2:28The biggest strength of Slides is eliminating the presentation version nightmare. When you're putting together a
- 2:2920-slide deck with a team of four people, splitting up the workload in desktop software usually meant someone
- 2:30spent four hours copying and pasting slides together an hour before the pitch. In Google Slides, your designer
- 2:31can be polishing slide layouts on slide 3 while you're writing speaker notes on slide 7 and your finance lead is
- 2:32dropping charts into slide 12.
- 2:33A few notable standout capabilities:
- 2:34•
- 2:35Live Linked Charts: If you build a bar chart in Google Sheets to track quarterly revenue, you can copy
- 2:36that chart and paste it straight away into Google Slides with a "Link to spreadsheet" toggle. When your
- 2:37data updates next month in the spreadsheet, you don't recreate the slide; you just tap an update button
- 2:38in Slides and the visual refreshes automatically.
- 2:39•
- 2:40Audience Q&A: When you present, Slides includes a built-in Q&A tool where you can generate a short
- 2:41web link on the top of the screen. Audience members submit questions and upvote other questions
- 2:42directly from their phones, giving you a curated list to answer at the end.
- 2:43•
- 2:44Clean, Accessible Templates: The layout library makes it straightforward to whip together a clean
- 2:45pitch deck, lecture, or project summary without having to be a professional visual designer.
- 2:46Why They Work Best Together
- 2:47When you zoom out from Docs, Sheets, and Slides individually, you see why Google's ecosystem captured so
- 2:48much ground over the last decade. It all comes down to three shared principles:
- 2:49•
- 2:50Accessibility Anywhere: Everything lives in Google Drive, tethered to your Google account. You can
- 2:51draft an outline in Docs on your laptop, review numbers in Sheets on your phone during your commute,
- 2:52and make a last-second tweak to Slides from a random borrowed computer in a conference room. No
- 2:53flash drives, no local hard drive dependencies.
- 2:54•
- 2:55Granular Permissions: You control access at the atomic level. Need someone to read a file without
- 2:56touching anything? Make them a viewer. Want peer review? Give them commenter rights. Ready for
- 2:57hands-on teamwork? Set them as an editor. You can share via email or generate secure, restricted links
- 2:58with an expiration date.
- 2:59•
- 3:00Interoperability: You don't have to choose between Google Workspace and legacy file formats. Docs
- 3:01opens and exports to .docx and PDF; Sheets reads and converts to .xlsx and CSV; Slides imports to
- 3:02.pptx natively. You're never locked inside a walled garden.
- 3:03At the end of the day, Google Docs, Sheets, and Slides succeeded by not cramming every obscure feature
- 3:04under the sun into their toolbars, but prioritizing speed, reliability, and real-time human collaboration. They
- 3:05turned file editing from a solitary, sequential chore into an open, collaborative canvas.
- 3:06Musical Interlude
- 3:07Screen freeze, blue light shining bright
- 3:08Frustration building in the quiet night
- 3:09Don't stress, don't let it win
- 3:10That's where we're gonna begin
- 3:11Help is just a click away
- 3:12Email the Guru today
- 3:13help@askthecomputerguru.com.au
- 3:14Help is just a click away
- 3:15Email the Guru today
- 3:16help@askthecomputerguru.com.au
- 3:17Listener Question: Wired vs. Wireless Mouse & Keyboard
- 3:18Cheryl from North Queensland asks: "Should I use a wired keyboard and mouse or a wireless one?"
- 3:19Well, whether you're building a clean, minimal desk setup, grinding ranked matches in esports, or typing away
- 3:20on endless spreadsheets, your peripherals are your primary physical connection to a digital world.
- 3:21Latency and Signal Integrity
- 3:22Let's address the biggest concern gamers and power users bring up: latency and signal integrity.
- 3:23Historically, wired peripherals, such as a mouse and keyboard, held a decisive victory. A direct USB cable
- 3:24connection offers near-zero latency, typically reporting a 1,000 Hz polling rate, or even up to 8,000 Hz on
- 3:25competitive, high-end gear. There's no signal interference, no packet drop, and zero delay.
- 3:26However, wireless technology has advanced dramatically. Modern 2.4 GHz USB dongles, like Logitech's
- 3:27Lightspeed or Razer's HyperSpeed protocols, deliver sub-millisecond response times that match or exceed
- 3:28standard wired connections. For 99% of users, including competitive gamers, latency on 2.4 GHz wireless is
- 3:29imperceptible.
- 3:30Where wireless can stumble is Bluetooth. Standard Bluetooth connection introduces higher latency, often 10
- 3:31ms to 20 ms or more, and susceptibility to 2.4 GHz band congestion in dense office environments. So rule of
- 3:32thumb: 2.4 GHz dongles for performance; Bluetooth for multi-device convenience.
- 3:33Desk Aesthetics and Mobility
- 3:34Now let's talk about desk aesthetics and mobility. This is where wireless peripherals shine. A wireless mouse
- 3:35and keyboard instantly clean up cable clutter, creating a sleek, minimalistic aesthetic. If you move between a
- 3:36home desk, coffee shop, or office, toss a compact wireless mouse and keyboard in your bag—no untangling
- 3:37cables required.
- 3:38On the flip side, wired setups demand cable management. Custom coiled cables with aviator connectors have
- 3:39become a stylish trend in the custom mechanical keyboard community, turning wires into aesthetic accents.
- 3:40But for mouse usage specifically, cable drag, even with a lightweight paracord cable or mouse bungee, is a
- 3:41physical drag factor that wireless completely eliminates.
- 3:42Power Management and Daily Ownership
- 3:43Let's discuss the practical reality of daily ownership: power management.
- 3:44Wired devices offer 100% plug-and-play reliability. You plug them into a USB port once, and you never think
- 3:45about power again. There are no dead batteries during a crucial gaming moment or mid-presentation.
- 3:46Wireless devices require maintenance:
- 3:47•
- 3:48Rechargeable built-in batteries are convenient via USB-C, but require periodic plugging in.
- 3:49•
- 3:50AA and AAA batteries can last months, but require replacements.
- 3:51Fortunately, modern wireless mice and keyboards often offer 40 to 100 hours of continuous active use, and
- 3:52keyboards without RGB lighting can last months on a single charge.
- 3:53Which Direction Should You Go?
- 3:54•
- 3:55Go wired if: you're on a strict budget, want maximum performance per dollar, hate managing batteries,
- 3:56or want zero chance of signal interference.
- 3:57•
- 3:58Go wireless if: you value a clean desk aesthetic, travel frequently, want total mouse movement
- 3:59freedom, or switch seamlessly between multiple devices like laptops and tablets.
- 4:00For most modern setups, a hybrid approach works wonders: a wireless gaming mouse for effortless gliding,
- 4:01paired with a wired or wireless hot-swappable mechanical keyboard.
- 4:02Outro
- 4:03Well, thanks for listening! I release my new podcasts every Friday, so keep an eye out wherever you listen to
- 4:04your favorite podcasts. If you enjoyed it, please like and subscribe, and tell your friends, because this will help
- 4:05my podcast grow.