Mac Day 8: Shifting 130,000 Photos

Digital photography, like many things, is both a blessing and a curse. I love how I can readily create, manipulate, and share digital photos. But the ease of their creation has already allowed me to build up over 130,000 of them on my desktop computer since the year 2000.

My first digital camera was the Nikon Coolpix 990 in 2000

The Nikon Coolpix 990 was my first digital camera. It cost $1,000 and took 3.1-megapixel 2048×1536 images. I bought six more dedicated digital cameras over the next 16 years, culminating in my Canon EOS Rebel T6 which takes 18.7-megapixel 5184×3456 images.

Along the way, I relied more and more on the ever-improving tiny cameras in the seven iPhones I purchased from 2008 to 2022. My iPhone 14 Pro takes 12-megapixel shots with a 48-megapixel sensor. My shot count was high enough before I started carrying a capable camera with me everywhere I went!

OneDrive

I have used Microsoft software for the entire 42 years I have had my own personal computers. My first, a TRS-80 Color Computer, was an 8-bit computer with 32 kilobytes of RAM, and it ran Microsoft Extended Color Basic. Later I used MS-DOS and then Windows from versions 1.03 in 1986 to 10 in 2024. I’ve been using online storage with Microsoft since at least 2008, and I’ve been paying $100/year for Microsoft 365 Family since 2014.

I have one terabyte of OneDrive storage, and for years I’ve used that as a backup for the photos on my desktop computer. My 130,000+ photos consume 340 GB there, organized into the same folders as on my Windows desktop computer, and folders and photo albums are distinct things on OneDrive. Those photos do not fully overlap with the 22,747 photos consuming another 132 GB of space in my iCloud+ account through Apple One Premier, which all came from my iOS devices.

I hope to finally let my Microsoft 365 Family subscription expire in June. However, letting go of OneDrive means I need to ensure my personal photos collection, distinct from the snaps in iCloud that were taken with iOS devices, is up in the cloud as well as backed up at home. Getting them accessible on my Mac was the first priority.

Transferring my photos to the Mac

My Mac SSD was too full of my photos

Since I was only rarely using my Windows desktop computer anymore, I decided to transfer all of the photos on it to my Mac Mini and then figure out how to re-organize them. Since both computers were wired into our home network, I used Apple’s Migration Assistant to copy them over. The files transferred at about 100 MB/s, so it took about an hour.

Back in 2017, I spent $545 for a 2 terabyte Crucial MX300 solid state drive (SSD) for my Windows desktop computer, and it has always worked perfectly. What a contrast to the years of spinning hard drives that would inevitably crash after enough years of use.

However, my 2020 Mac Mini only came with a 500 GB SSD. Apple is notorious for overcharging for things like memory and storage, and I wasn’t willing to pay their premium price back in 2020 for a one or two-terabyte SSD. Copying over all the photos left me with only 22 GB free on the Mac’s internal drive, which was less than 5%. That was unsustainable.

Rather than delete all of the photos and try again later to get them off the PC or download them off OneDrive, I decided to buy an external SSD for my Mac. I already had a 2 TB Seagate drive, but it was my Windows backup drive, and it was a spinning hard disk drive with a maximum transfer rate of 120 MB/s.

I also had a 1 TB Samsung SSD with a maximum transfer rate of 540 MB/s, which I bought for any emergencies knowing that if nothing else, I could use it in a few years when I retire; I currently have about 363 GB of data in my district account and have built up about 70 GB of files in the online district archives. Whenever I retire, I’ll sift out anything that is the property of the district or protected by FERPA, but the rest I plan to copy to ensure decades of work products are protected and available. If I were just going to have a Time Machine backup for the Mac’s SSD, that 1 TB drive would suffice, but I didn’t want to cram a backup and all of my photos on a drive that might get filled up in a few years.

My new external 2 TB SSD is quite small

The Mac Mini has two extremely fast Thunderbolt/USB 4 USB-C ports rated up to 40 GB/s. So I spent $158 for a two-terabyte Crucial X9 Pro SSD with theoretical transfer rates of up to 1050 MB/s. Although I’m used to tiny external SSD units, I was startled when I unboxed the new SSD. It was only 2.56×1.97×0.39 inches (65x50x10 mm). I’m still amazed when I think back to the 10-megabyte hard drive I used at the Oklahoma Department of Tourism in the 1980s that was the size of washing machine…this device is smaller than my palm and has 200,000 times as much storage.

I plugged in the SSD and promptly used Disk Utility to erase its Windows-compatible exFAT format and replace that with Apple’s APFS, which is optimized for SSDs on Macs. That only took seconds, and then I used the Finder to copy all of my photos from the Mac to the external drive. It took 11 minutes and 20 seconds to copy 371 GB, for a transfer rate of 540 MB/s, which was certainly plenty fast. That got me back up to 392 GB of free space on the Mac’s internal SSD.

Backups

My current backup philosophy is that for important files you always want to have accessible, in addition to a copy in the cloud you should have at least one and preferably two local copies. Before cloud storage became affordable and reliable, I insisted on two on-site physical copies and an off-site physical backup, although I’ll admit the off-site ones were sometimes months out of date.

I remember spending hours swapping 5.25″ inch 360 KB or 1.2 MB floppy disks and then 3.5″ 1.44 MB floppies, then Iomega ZIP drive 100 MB disks, and for some years listening to tape drives whir for hours. I used recordable DVD optical discs a few times, and then spinning external hard drives. The diligence paid off, since I seldom lost any data, but it was a pain.

My 2004 and 2009 Windows machines had RAID 1 redundant spinning hard drives for backup, and by 2015 those RAID 1 configurations had allowed me to survive at least four hard drive failures. I finally shifted to solid state drives in 2015, and I have never had one fail, although I do have an old backup of my current Windows machine’s SSD on that 2 TB Seagate spinning external drive.

At this point in the process, I had my 130,000+ photos organized into files folders in three locations: my Windows desktop’s SSD, the external SSD on my Mac, and up in the cloud in OneDrive. An old subset of them should also be in the outdated backup on my Seagate drive. But I had no backup yet of the Mac itself. Granted, there wasn’t much on it yet, and a lot of my data is online in my personal and district Google Drive accounts, but years of experience told me to not wait too long to get the Mac backed up.

I owned a 2010 MacBook Air and for well over a decade I listened to the MacBreak Weekly netcast, which covered iOS and Apple TV as well as Macs. But when the pandemic hit and disrupted all of my routines, I stopped watching Léo Laporte’s TWiT shows. For the past few years, I’ve done my morning exercises watching late-night monologues. Their reliance on political humor isn’t mentally healthy, so I’m re-subscribing to MacBreak Weekly, which I can easily watch on the Mac via its Podcast app along with catching it on my iPad.

All that meant I knew the backup method for Macs is Time Machine. The internet told me I could create an additional APFS volume on my external drive which I could set to be used for Time Machine, or I could partition the drive. If I used an APFS volume, it could grow if needed at the expense of the volume where I stored my Photos. I wasn’t interested in that, so I partitioned the external drive into two one-terabyte APFS partitions and set up Time Machine on the new one.

Before the end of June, I need to get my photos into a different place in the cloud if I’m going to let my OneDrive subscription expire. I’ll probably put them into iCloud, as I have plenty of storage there thanks to my Apple One Premier account. But I already have 270 photo albums built up in iCloud that needed to be organized first…more on that in the next post.

Happy computing!

Posted in technology, photos, Mac | Tagged | Leave a comment

Mac Day 7: Draw with Magnitude & Direction

For 28 years, I taught students about vectors as representations of physical quantities with magnitude and direction, and how adding, subtracting, and multiplying them differed from the “scalar” mathematics they were used to. We covered the vector cousins of common scalar quantities, such as displacement adding direction to distance, velocity adding direction to speed, and so forth.

Vectors are also used in computer graphics, with images created using a sequence of commands or mathematical statements that place lines and shapes in a two-dimensional or three-dimensional space. That contrasts with bitmapped or rasterized graphics of a grid of colored pixels. Photographs are represented with bitmaps, while scalable diagrams are best handled with vectors.

The most famous early use of vector graphics in popular culture was the original Asteroids arcade game released by Atari in 1979, made possible by directly manipulating the electron beam in a cathode ray tube to draw shapes. In a typical television, the beam instead would scan across and down the screen repeatedly in a set pattern to create a raster, rather than a vector, image.

Asteroids used vector graphics

In my previous post, I explored editing bitmapped photographs on my Mac, and I decided to wait and see if the default free Photos app will suffice. If not, I’m prepared to spend $70 on Adobe Photoshop Elements 2024. But what about vector graphics?

Thankfully, the free online Google Draw, which is part of Google Docs, has vector tools which are sufficient for most of my needs.

Should I want something more sophisticated, my go-to in Windows has long been Corel Presentations, which descended from 1990’s DrawPerfect. Professionals might use Adobe Illustrator, but that is too complex for my needs, and I have no interest in paying for a monthly or annual subscription for Adobe Creative Cloud after I retire.

Inkscape is a free open source vector editor that runs on Windows, Mac, and Linux. I was a bit skeptical of it, given that its free open source counterpart in advanced bitmap editing is Gimp, and I wasn’t impressed with Gimp’s interface.

Fidding around with Inkscape

I found Inkscape a mix of familiar and strange. I am used to right-clicking an object and selecting a menu option for a rotation, but in Inkscape you click an object once while in cursor mode to get resizing handles and again to get rotation and skew handles. Once you know the trick, it’s a fine approach.

Inkscape has a more limited set of shapes than some programs, but it can manipulate them in sophisticated ways. If I ever needed to go beyond Google Drawings and used Inkscape, I’d definitely need to use Help > Tutorials to figure out some of the basics. I’m not a fan of surrounding all four sides of the editing area in tiny icons, but I feel pretty confident that between Google Drawings and Inkscape my vector drawing needs will be met.

I have dabbled in Cartesian coordinates, but vector geometry is where I draw the line.

Posted in Mac, technology | Tagged | Leave a comment

Mac Day 6: Healing Arts

I used Windows at home for almost 40 years, but I’m now switching to an Apple Mac Mini. An earlier post explains why. This post is about my search for how to touch up photos on the Mac.

I have about 130,000 digital photos thus far, and that will not only grow as I snap more of them, but also as I slowly digitize my parents’ photo albums and eventually some of my own analog prints. I like to share photos on Facebook and include some in my blog posts, and I’ve learned how to do some basic touch-ups.

Years ago I attended a one-day digital photography workshop with Jerry Poppenhouse, who traveled the world doing photography for Phillips Petroleum for 27 years and then taught at OSU Okmulgee. In addition to giving us pointers on composition, he showed us novices how to use the burn and dodge brushes in bitmap editors along with adjusting highlights and shadows and the like.

My Windows ways

The three programs I used to edit graphics in Windows were quite venerable and the versions of them which I was using dated back six years or more.

For 20 years I have relied on the Thumbsplus Pro program for Windows to view, organize, and edit most of my graphics. It is easy to use for rotating, cropping, resizing, converting, and making basic adjustments to contrast, saturation, and gamma. It also has a few useful filters for sharpening and the like.

ThumbsPlus has been my go-to graphics viewer, organizer, and editor in Windows for over 20 years

But if I needed to burn or dodge a photo, adjust shadows or highlights or lights levels, or use a healing brush, those weren’t available in ThumbsPlus. I had tried Adobe Photoshop, but it was overwhelming for my basic needs, and its later conversion to monthly or annual subscriptions was a turnoff.

So back in 2009 I bought Adobe Photoshop Elements 8, then 10, and most recently Adobe Photoshop Elements 2018 (which was version 16). I used it mostly for adjusting highlights, shadows, and levels, correcting camera distortion, touch-ups with the healing brush, noise and dirt reduction, and the occasional burn or dodge.

I used Adobe Photoshop Elements 2018 for photo touchups beyond the abilities of Thumbsplus

When I wanted to do precise editing of bitmapped graphics or wanted to create vector graphics, I used Corel Presentations X7 software from 2014, which was the descendent of the 1990 MS-DOS application DrawPerfect by WordPerfect.

I used Corel Presentations X7 for fine-detail bitmap editing and for creating vector graphics

Bring out the Gimp

I looked for some recommendations online for powerful but inexpensive photo editing on a Mac. I knew Apple offered Aperture from 2005 to 2015, but the tight integration of Adobe Photoshop and Lightroom (Classic) prevailed. I don’t need the full-blown capabilities of Photoshop or Illustrator, and I have no interest in an Adobe subscription once I retire and no longer have access via a school account.

So I decided to first check out a free open-source graphics editor: Gimp. It has been available for many years and runs on Macs, Windows, and Linux. Its origins are given away by its full name: GNU Image Manipulation Program, named after the GNU version of Linux. (And GNU is itself a recursive acronym for GNU’s Not Unix. Soooo nerdy.)

Speaking of nerdy, take a look at the Gimp interface:

Gimp was a plethora of icons scattered across a dozen different areas on the screen

Oodles of tiny little icons, and a dozen different areas on the screen. That looks even worse than Adobe Photoshop:

Photoshop suffers from a similar outbreak of icons [image source]

Thankfully, you can hover over an icon or an area of the screen and get a brief explanation of what it is about. A bit of noodling around showed that Gimp was no wimp: it has many features this hobbyist associates with Adobe Photoshop, such as layers.

I had Gimp open in a window on the right half of the screen. After hovering over the different areas to see what they did, I thought, “Something is missing here.”

Being a four-decade Windows user, I had to remind myself to look at the top left of the screen, with the Gimp window selected, to see the application’s menu bar. There were the additional controls for…oh, good grief…if I click in my Chrome window to type this blog post, the Mac’s menu bar changes from Gimp to Chrome, so I can’t see the Gimp menu options to type them. In Windows, that wouldn’t be an issue, since its application menus are within each window. I guess I’ll just provide a screenshot of the Gimp menu bar:

Fonts

In messing with Gimp, I used the text tool and that provided my first glimpse into the default fonts of a Mac Mini…or perhaps just Gimp? The Google search engine’s Search Generative Experience, its experimental AI overview in search, stated that the Mac has separate folders for system fonts and for application fonts. In Windows, I just worked with one folder of fonts.

FYI, I only see the Search Generative Experience when I’m logged into a personal Google account at home. At work I use Google Workspace for Education, and Search Generative Experience is not enabled for it yet.

Many of the fonts were familiar, but many were not. I was surprised to see Arial in the list; I kind of expected that Helvetica imitator to be omitted. That prompted me to find out that I could use the Mac’s Font Book app to add fonts, and I diverted to find out my Mac had 470 fonts installed. Marcellus SC, which I picked out long ago for the school district logos, wasn’t included, so I added that. The Bruins logo also uses Blaze Italic, so I popped that in as well.

I’d rather draw than paint

The aftermath of my initial experiments with Gimp; it has many bitmap tools I’m used to, but its ability to draw basic shapes is gimpy

After playing around with a few tools in Gimp, I wondered how to draw simple shapes, since while I do some retouching of bitmapped images, I also often have cause to draw lines, circles, boxes, and the like. Gimp has ways to draw lines, rectangles, and circles, but they are somewhat counterintuitive kludges for a program that is clearly oriented towards bitmap editing.

I tried the healing brush in Gimp, and I wasn’t impressed. With some fine tuning, it could work for me, but I suspect it would exhaust my patience. So I gave up on Gimp, unwilling to navigate its interface on a regular basis for my relatively simple needs.

What to try next?

Those who live in mud houses…

I had already paid $80 back in 2017 for Adobe Photoshop Elements 2018. Could I use that license to get the Mac version for free?

I went to https://account.adobe.com/products and looked at my registered products. I once had a personal Creative Cloud subscription, but this was showing me standalones I purchased and registered over the years:

  • Acrobat 6 for Windows in 2005
  • Acrobat Professional 7 for Windows in 2005
  • Acrobat Professional 8 for Windows in 2008
  • Photoshop Elements 10 for multiple platforms in 2012
  • Dreamweaver 12 for Windows in 2012
  • Photoshop Elements 16 for Windows in 2017

Hmmm…no mention of my purchase of Photoshop Elements 8 back in 2009; I guess I never registered that purchase with Adobe. Anyway, I could download the Windows version of Photoshop Elements 16, but not the Mac version.

I’ve spent $1,463 on the Mac Mini since December 2020. To put a different lens on costs, since I made the decision to switch from my Windows desktop to the Mac Mini as my primary machine, I’ve spent $232 on these items: a new keyboard and wrist rest, an SD card dongle, a book, and an external SSD; a future blog post will be about the SSD. Was I willing to pay $70 for Adobe Photoshop Elements 2024 for the Mac? Sure, given how often I edit photos, but first I wanted to see if a free bundled tool might suffice.

By default by design

By default by design
Time after time
Maybe you’ve earned it
Maybe you’ve spurned it
But you’ve got it
Yes, you’ve got it

-ABC, from Beauty Stab

I recalled that renaissance man and volunteer extraordinaire Michael Wray had sent me a tip that he organizes his photos with the Mac Photos app with different libraries for different events and clients. His focus was on the organization issue, but could the editing capabilities in Photos satisfy my hobbyist needs?

I’m familiar with the Photos app in iOS, having used its various functions for years, and while it can alter shadows and highlights and the like, it lacks a healing brush. To get that capability on iOS, I once used Adobe Photoshop Express, but I now use Snapseed.

I was pleased to find in the Photos User Guide that there is a Retouch brush in the Photos app on a Mac and along with more sophisticated Levels adjustments and the like. I decided to load the same image I had in Gimp, that of a vintage Fisher Price Chatter Phone, and try “healing” parts of it.

Puttering around with Retouch in the Photos app on the Mac; removing the E in Price worked fine, but taking a chunk out of the handset cord would require finer work than a few clicks of the Retouch brush

I also loaded a 1990s scan of a black-and-white film negative to see if the Retouch tool could deal with large specks and the like. Its handling of that was not awful, but it was noticeably inferior to the results I was used to getting in Adobe Photoshop Elements 16 for Windows.

I rechecked some online recommendations at Macworld and PCMag (I know, I know), and I decided to download the free trial version of Adobe Photoshop Elements 2024 for the Mac.

In my element

There was a warning that Adobe Photoshop Elements 2024 for the Mac only supported macOS 12 and 13, but the internet gave some indication it would work on Sonoma, which is version 14. I was a bit worried to see that there were known issues between Elements 2023 and Sonoma; I presume Elements sales for the Mac might be low enough that Adobe doesn’t put much programming resources into updates.

Elements 2024 on the Mac worked pretty much like Photoshop Elements 2018 on Windows after I switched the Mac version to dark mode; the default mode was too bright for my taste. I felt very comfortable in using it, and I appreciated the greater separation and clarity of its sidebar tools compared to the mess in Photoshop and Gimp.

I then edited the same images in Photos and Photoshop Elements 2024 side-by-side. I verified that Retouch in Photos was inferior to the Spot Healing Brush in Elements in retouching old negatives, and Retouch sometimes “hung” for awhile, leaving a dot on the screen where the brush had been applied. I’m guessing it might be using the cloud and experiencing server delays.

However, I didn’t see much difference between Retouch in Photos and the Healing Brush in Elements when editing the color photo of the Fisher Price Chatter Phone.

I’m holding off on purchasing Elements for now. My free trial lasts a month, and I’ve yet to work through my organizational scheme for photos on the Mac. Since it is likely that I’ll follow Mr. Wray’s lead and use Photos, I’d love to just use it for adjustments and avoid depending on Elements. But if Photos doesn’t meet my expectations, I can always plunk down $70 for Elements.

Before I tackle organizing my photos, however, I think my next step will be to look at vector drawing tools on the Mac. That might be the topic for my next Mac post.

Happy computing!

Posted in Mac, technology | Tagged | Leave a comment

Mac Day 5: The Next Keyboard

Three years ago, I spent $27 on a wireless iClever keyboard and mouse combination for my new Mac Mini M1. The mouse was great, and the keyboard was cute and lightweight with scissor keys. I didn’t do anything with the Mac for over three years, but now I’m working to make it my primary machine after relying on Windows computers for almost 40 years.

I have always been fine with wireless mice if they use a dry cell, since that can be quickly replaced and you’re back in business. A wireless keyboard that uses a dry cell would also be fine, but I’ve always been leery of wireless keyboards you have to plug in to recharge. I suffer from recharging fatigue:

Things I have to recharge multiple times per week

  • iPhone (daily)
  • iPad (daily)
  • Apple Watch (daily)
  • SHOKZ OpenRun bone conduction headphones (every few days)

Things I have to recharge on occasion

  • EGO batteries for the lawn mower (or string trimmer or chain saw)
  • Amazon Kindle Voyage (I seldom use my Boox Note Air e-reader or my Kindle Oasis)
  • Philips Norelco razor
  • Philips Sonicare toothbrush
  • Geek Aire outdoor fan

That is more than enough for my taste. Another drawback to the iClever keyboard was that it tries to live in both the Mac and PC worlds, no doubt to boost sales. That means it has some key labels that don’t make sense on a Mac, and if you turn the thing off, you have to remember to hit fn+Q to put it back into Mac mode. I decided to try something different.

I first bought a $120 wireless Logitech keyboard. It was a nice typer, but I outlined my troubles with it in a previous post. I returned it, got a refund, and promptly ordered a Macally Ultra Slim USB ACEKEYA wired keyboard for $43. I received it today.

The Macally Ultra Slim USB ACEKEYA

The new keyboard has the Mac key layout and 20 shortcut keys, all of the quiet scissor switch type. I’m fine with scissor switches or old-style mechanical keyboards, but Wendy’s hearing is far more acute than mine, so I figured the quieter scissor switch keys might be welcome.

One immediate concern with the new keyboard was getting it plugged in. My Mac Mini only has two USB-A ports to go with its two USB-C ports, and the USB-A ports were occupied by the mouse radio dongle and the multifunction printer/scanner. So I decided to replace the mouse dongle with a USB-A to USB-B cable leading to my monitor. That enabled two USB-A ports on the back of the monitor and two more on the side. I put the mouse dongle in one of the backside ports and plugged the keyboard in back there as well.

The ports were almost impossible to see, and since they were USB-A, I inevitably had the dongle and the keyboard cable facing the wrong way to be inserted. I eventually succeeded, although I muttered a few curses for the engineers of USB-A ports and cables. All of the modern serial cables shown above can only be plugged in one way, except for USB-C and Lightning.

USB-A cable are supposed to be plugged in with the USB trident logo facing up
Purchasing a double-sided reversible Micro USB cable saved my sanity when plugging in my Kindle to recharge

I know that in general you can plug a cable in if the USB trident symbol is facing up, but in practice that often fails to help because ports are facing sideways or you can’t get a good view of them. Futzing with the Micro USB charging cable for my Kindle got so annoying that I purchased a cable with a double-sided reversible Micro USB end on it. That makes me smile every time I can insert it on the first try, which is always. Now if I could just change the charging LED. I am among the 5% of males with deuteranomaly, or green-weak, color vision. The Kindle’s LED is yellow when charging and green when fully charged, and I struggle to differentiate the hues it outputs.

One benefit from the recabling was that I have gained two available USB-A ports on the side of the monitor that should be able to handle 5 Gb/s data flows.

Can one be too slim?

If you’ve ever seen a typical supermodel, you know that one can be too slim. Once I could finally type on the new keyboard, I realized that Ultra Slim meant the front of the keyboard was so low to the desk that I couldn’t use even a thin wrist rest. With my wrists resting on the desk, the keyboard felt too low. So I went searching through our Drawers of Requirement (aka junk drawers) and found some adhesive foam strips I could affix to the underside to lift it up.

That helped, allowing me to use the thin wrist rest I had purchased separately for the somewhat svelte, but not slim or emaciated, Logitech keyboard I had returned. The typing action is comfortable and quiet, like the iClever keyboard, although I liked the steeper pitch of the iClever over the low angle of the Macally, so I added some more foam to the back side of the keyboard.

On my keyboard, the PrtScn key is actually a shortcut for Force Quit.

As for the shortcut keys, I don’t expect to use the Cut, Copy, or Paste keys since I’m used to CMD+X/C/V for those. I was hoping I might reprogram the function key shortcuts to do things like open the Calculator app, but the manual was silent on that.

I think this keyboard will be fine, so I’ll close by admitting that the title of this post is an intentional sly reference to the NeXT computer that Apple co-founder Steve Jobs developed after he was ousted from Apple by John Sculley in 1985. The joke is that Jobs had great taste in many things, but his mice were often terrible and I had no use for his minimalism on keyboards.

Steve Jurvetson has shared the story of how when Steve Jobs was in exile at NeXT, Jurvetson had Jobs over at his home to talk with a club of tech nerds. Jurvetson had already had Apple co-founder Steve Wozniak sign an Apple Extended Keyboard:

…I asked my childhood hero if he would sign my Macintosh keyboard.

He looked a little taken aback to see Woz’s signature already there, and then he exclaimed:

“This keyboard represents everything about Apple that I hate. It’s a battleship! Why does it have all these keys? Do you use this F1 key?”

No, I replied. And so, he pried it right off with his car keys. Same for F2 and down the line. He put the keys in his pocket, and then signed his name to the Apple Extended Keyboard that he despised. He then exclaimed, “I’m changing the world, one keyboard at a time.”

The poisoned relationship between Steve Wozniak and Steve Jobs led Wozniak to comment, “You may well have the only Apple device with both our signatures on it.”

That’s a great Steve Jobs story, among many, but I see that Jurvetson’s keyboard had all of its function keys in the picture. So did he scavenge them from another keyboard? Anyway, that keyboard was later auctioned for $74,535.

It looks like a decent keyboard. I would have paid $43 for it.

Posted in Mac, technology | Tagged | Leave a comment

Mac Day 4: Mostly Cloudy

A primary reason I am comfortable shifting to a Mac at home after 40 years of using Windows is that so much of my computing is now done online. The primary exceptions are photo/graphics and video editing. Let’s take a look at how my use of productivity applications has evolved.

Word Processing

My first experiences with word processors were in the 1980s with Scripsit and Telewriter-64 on my primitive TRS-80 Color Computer. Later I used Digital Research GEM on the more advanced Tandy Model 2000, one of the very few personal computers that used the 80186 microprocessor.

The first professional word processor I used was a dedicated Wang terminal when I worked at the Oklahoma State Department of Tourism in the summer of 1985. It was next to a noisy 10-megabyte hard drive that was about the size of a washing machine.

The first professional word processor I used was a dedicated Wang unit

A year later, I started working for Scholars Programs at the University of Oklahoma, where I learned WordPerfect 4.2 for DOS on a personal computer, which was a relief to use compared to the venerable Wang. I had Multimate for my Tandy Model 2000 at home, which was reminiscent of the Wang in its features and interface. I also experimented with WordStar, Microsoft Write, and Lotus Symphony. But learning WordPerfect at work led me to get it for my Tandy 2000, and I would end up using WordPerfect continuously for about 30 years.

After coming to Bartlesville in 1989, I eventually had to learn Word to collaborate with some coworkers, but I never liked Microsoft’s word processor, preferring the tighter and far less confusing control that WordPerfect offered. It used embedded codes for functions that you could make visible for precise control, while Word, particularly in the old days, was far more opaque. But Word gradually overtook and then marginalized the superior product. Thus, back when I sold a physics curriculum, I made sure to include editable versions of the student handouts in the Word format along with their true master versions in WordPerfect. I steadily updated WordPerfect until version X7 in 2014, which was the 13th update of the software I used.

My career shifted in 2017 as I went into administration. I was recruited to lead the district’s technology and communications efforts, and a big focus was on deploying Chromebooks for students and teachers. So I made a point of using Google Docs, Sheets, and Slides instead of WordPerfect, Quattro Pro, or Presentations in the Corel WordPerfect Office suite or Word, Excel, and PowerPoint in the far more popular Microsoft Office suite.

For the past seven years, the only time I’ve used Microsoft Word instead of Google Docs has been when editing a document someone else created or for complex tasks like a mail merge, which is still beyond the capability of the free online version of Word and requires the desktop-based application. So while I have oodles of legacy documents in old formats, Google Docs is all I need at home for word processing. Since Apple Pages is free for Apple users, I could also play around with it, but for convenience I plan to just use Google Docs.

I no longer have much use for Desktop Publishing applications, but back in the day I used CorelDRAW, The Print Shop, and Microsoft Publisher. I also did a few small jobs with Adobe InDesign and QuarkXPress. The only desktop publishing service I’ve used recently was the online Canva, when I was testing it out to decide if we would set up Canva cloud licenses for the school district.

Spreadsheet

Lotus Symphony for the Tandy 2000 was NOT cheap!

My first spreadsheet was Lotus 1-2-3, which we used occasionally when I worked at the University of Oklahoma in the late 1980s. The “1-2-3” in the name referred to how Lotus was originally billed as an integrated product with spreadsheet, database, and graphing functions. I bought Lotus Symphony for my Tandy Model 2000 at home, which added a word processor and a communications program, but the spreadsheet was the main attraction. Symphony cost the equivalent of $2,000 in 2024 dollars…business software was expensive back then.

I gradually started using Microsoft Excel in the 1990s, and I gained the most experience with it once I started doing the numbers for the teachers’ bargaining team. When I became the Chief Negotiator for the team, I also served on the superintendent’s budget committee. I built complicated salary analyses, picking up a few Excel tips from the district’s directors of finance.

I also learned how to load the Analysis ToolPak in Excel to perform various statistical analyses so that I could show students how to test their science fair project data for statistical significance. I learned statistics beyond the basic concepts of mean, median, mode, and standard deviation in graduate school, where we did the various types of t-tests, Chi-Square, z-tests, ANOVA, and non parametric ones like the Mann-Whitney U Test and the Wilcoxon signed rank test.

Excel has a great add-in for statistical analysis

However, most of my spreadsheet work is now in Google Sheets. I used it extensively for tracking data and creating charts throughout the COVID pandemic in my role of chairing the school district’s Pandemic Response Committee. I seldom find I need Excel over Sheets, although since it is installed on my Windows systems at work and at home, spreadsheets automatically open in Excel, so when I use Sheets it is mostly files I created myself; I rely on dozens of them in my job.

Presentations

WordPerfect released the MS-DOS drawing program DrawPerfect in 1990. It became WordPerfect Presentations and added slide functionality. I used Presentations for some detailed graphics work from 1993 to 2020, but I never used its slides capabilities. Nowadays I do most such work in Google Draw. Although I use Adobe Illustrator for some graphics, such as district logos, I know very little of its functionality, and most of my graphics work is vector-based drawings, not bitmapped paint stuff.

A slide from one of the PowerPoints I created for my physics classes

For slides, I of course used Microsoft PowerPoint, although it could really frustrate me when it came to sound. PowerPoint was very bad about allowing one to incorporate a video or music, but then the sound not working when you exported a file to take it on the road. It was so bad that I sometimes would convert a presentation into a video file that I would manually pause to ensure the sound worked.

I enjoyed grumpy Edward R. Tufte’s The Cognitive Style of PowerPoint: Pitching Out Corrupts Within, which was useful in avoiding the worst PowerPoint faux pas, although once you read the book, you’ll truly suffer in many meetings.

Since 2017, I have always used Google Slides instead of PowerPoint, although I have also created online interactive presentations with Prezi and Pear Deck.

Databases

dbase III

The first database I used was dBase III. I was working in Scholars Programs at OU where my boss had paid a student to write a scholarship database for them. That student had graduated, and I got the thankless job of trying to update its programming, having never seen a database before. Thankfully I knew a tiny bit about fields and records from learning the BASIC computer programming language at home and in high school.

We survived the experience, but I was glad when my boss got the funding to pay the university’s COBOL programmers to create a new database on the university mainframe. That was far more powerful, but my boss was angry about the revision costs. He would complain, “If I need to have just one @#$ing letter changed on a screen, I get a bill for hundreds of dollars!”

So when he needed a health fee waiver database which scholarship recipients could access, he paid me to write it in BASIC one summer. I subcontracted my friend Jeff Silver, who was doing database work for a living at company that made trucking logistics software, to help me with the roughest parts. The health fee waiver database was set up and running on a personal computer in the university library for a few years. It was cheaper to pay me to write a database from scratch and buy a computer and monitor to run it on than to pay to build the database on the university mainframe, and that was too long ago to simply have the database on the internet for students to access.

Almost a decade later, the Y2K crisis was in the news because lots of old software used two digits for the year, and the year 2000 meant old programs like that would malfunction. I remember thinking that my health fee waiver database was definitely not ready for the new century. Thankfully, it was of course long gone by then.

I generally found I could handle most of my data storage and manipulation needs using a spreadsheet, although in the 1990s when Bartlesville High School hosted a state Student Council convention, we had to track housing for hundreds of students across dozens of households across town. My former student council co-sponsor roped me into helping by creating a housing database. I either used FileMaker Pro or FoxPro for that, but I can’t readily recall using a desktop database application after that.

Nowadays at work I access multiple online databases on a regular basis, but I have no other need for them.

Getting the Picture

So you can see that I now do most of my work in the cloud. Hence I hope to avoid installing Microsoft Office on my Mac, and if all goes well I plan to not renew my $100 Microsoft 365 Family annual subscription at the end of June.

However, I have 340 GB of photographs on OneDrive, which is the online backup of over 130,000 of my photos that I also have on my Windows PC. There will be more on the photos situation in a coming post.

Meanwhile, happy computing!

Posted in Mac, technology | Tagged | Leave a comment