I have to ask, are you suggesting pivot tables and teaching because she’s a girl? Because sheesh, I can (and have) used a pivot table in a spreadsheet, and I’m not mathy. I think you might be mistaking CS for IT (which she has no interest in)
The CS “teacher” in their HS doesn’t have a degree in math or CS.
The programs she’s shown me do some pretty nifty stuff, and her dad says (to me) that her code is elegant and concise, so forgive me for getting a little huffy over the pivot table suggestion.