Wishlist 0 ¥0.00

Unconfuse Me with Bill Gates

Unconfuse Me with Bill Gates

EPISODE 02: Sal Khan

Date aired: August 10, 2023

 

SAL KHAN: I started getting a few goosebumps. And then I said, “Ask ChatGPT why that’s the answer.” 

 

BILL GATES: Hmmm.

 

SAL KHAN: It explained it!

 

BILL GATES: Oh yeah, it’s so good at that!

 

[music]

 

BILL GATES: I had great teachers that I’ve learned from. I had a librarian at my elementary school. I have a great tennis coach. And, you know, the best way to get ‘unconfused’ about something is to find somebody who really, deeply understands it. I call that, ‘getting unconfused.’

 

[music]

 

BILL GATES: Welcome to Unconfuse Me. I’m Bill Gates.

 

[music]

 

BILL GATES: The role of technology in education isn’t always obvious, but the potential and the possibilities are inspiring. When I would talk to people about loving to learn on the internet, and it was just at the point where putting up videos was kind of getting mainstream, in about 2010, people said, "Wow, you’ve got to use Khan Academy." My guest today is a teacher. He’s CEO of Khan Academy, Sal Khan. Khan Academy is an amazing tool. I was so impressed that Sal was able to teach such a broad range of subjects himself in the early days. Khan Academy’s got 140 million users. A lot of students have benefited. I’m excited to have him here today. Welcome, Sal. 

 

SAL KHAN: Thanks for having me.

 

BILL GATES: Well, to start, I found out when you were younger, you were a singer in a heavy metal band and a cartoonist for the school paper. Which is the better skill, drawing or singing?

 

SAL KHAN: Depends what you’re trying to do, but I’ll say drawing.

 

BILL GATES: Yeah, well, in your lectures, you do have to draw stuff.

 

SAL KHAN: Oh, yeah.

 

BILL GATES: You erase a bunch of times if you don’t like what you did.

 

SAL KHAN: Every now and then, if you watch enough of the videos, I try to flex my art a little bit.

Sal can draw a cartoon. Sal can do a little bit of shading and cross stitch, and all of that. When I was a kid, I would just draw for hours. Now I realize it does give you a certain, one, you never get bored. And it does build a certain curiosity and creativity, just drawing all day.

 

BILL GATES: Well, Sal, remind us how you got into all of this. I think you were at a hedge fund at one point.

 

SAL KHAN: You go back to 2004, my original background was in tech, but I go to business school, I go into finance. I was an analyst at a hedge fund in Boston. I had just gotten married, family visiting me from New Orleans, which is where I was born and raised. I just came out of a conversation with my 12-year-old cousin, Nadia, who was having trouble with math. I said, "Hey, Nadia, when you go back to New Orleans, I’m happy to tutor you." She agreed. I started tutoring her after work every day. And long story short, that made a difference. It went from her being a weak math student, or perceiving herself to be a weak math student, to being a very strong one. I started tutoring her brothers. Word spreads in my family, free tutoring is going on. Before I know it, I’m tutoring ten, fifteen cousins. By 2009, there were almost 100,000 folks who were using it back then. That’s when I took the plunge, set it up as a not-for-profit, admission-free, world-class education for anyone, anywhere.

 

BILL GATES: And then it spread.

 

SAL KHAN: A lot of the vision of Khan Academy in the early days, yes, there was an accessibility piece of it. We can make videos! We can share it with everyone. But the pedagogical aspect wasn’t just access. It was that people could finally leverage technology to learn at their own pace. If you only got a 70% or 80% on some concept, the class doesn’t need to move on to the next one and build on that gap. The student should be allowed to work on that. If you just let people have a strong foundation, the next few layers in math come pretty easy. With a weak foundation, no matter how bright or hardworking you are, they’re very, very difficult. So that was the thesis. I think over the last ten years on this journey, we’ve got a ton of efficacy studies in different contexts, different countries. They all kind of say the same story, that if students engage, let’s call it 30 to 60 minutes a

week, even that, what I would call fairly low level of engagement, they’re growing pretty dramatically, 20%, 30% more than expected, or in some cases more. 

 

BILL GATES: Amazing.

 

SAL KHAN: And so I think the question over the next couple of years is: How do we get more students to engage at that level? 

 

BILL GATES: A lot of our conversations have been about how your tools are a miracle for the 1015% most motivated. But then, how do we draw in that other 85%? And I do think in the last year or two, as you’ve engaged with teachers and districts, we’re starting to see that it can be a tool basically for all students.

 

SAL KHAN: That’s the goal. But to your point, I actually think 80, 90% of – hopefully, 100% of students, if they’re able to engage in the right way, especially if you catch them early – they can have that foundation. I think the main issue is just a lot of kids, frankly, just check out by the time they’re in middle school.

 

BILL GATES: In learning, you’ve got the classroom environment, you can use that time in a certain way, and you’ve got whatever time you get with a student where they’re kind of by themselves and assume they have a device. How do you see the time in the classroom? Is the availability of your tools shifting what people do in the classroom? And do they use it real time in the classroom?

 

SAL KHAN: When we were starting ten years ago, twelve years ago, it was only more affluent school districts that would have one-to-one laptops. The rest of them had to share. The good thing is over the last ten years, because of E-Rate, a lot of that’s been addressed. It’s unusual now to see a school where you don’t have one-to-one laptops in, say, a math class. All the students will take out the laptops and do twenty minutes while the teacher walks around. They’ll take ten kids aside, do a focused intervention with them, do a worked example with them. The other twenty keep working, then they’ll take another ten aside. But when they do that consistently, it makes a huge difference. And then for the students who either need gap-filling or the students who are ready to race ahead, they can do so. That’s what they really like about Khan Academy. Not only do you get that practice and feedback in the moment, but the kids who want to race ahead can and the kids who need to do some gap-filling can too.

 

BILL GATES: And the dashboard that helps the teacher see the status of all the students, that’s a

Khan Academy thing that the teacher account gives them a really clear indication of what’s going on.

 

SAL KHAN: Yes. We all remember growing up in a classroom, that the only time of real measurement is at the end of the unit, and then you get the test, the test is graded, you get a 90%. I get an 80%. All right. Let’s move on. No one even attempts to improve that. What we realize is that now with tools like Khan Academy, you can give real-time information. You can give real-time feedback to the student, but you can also give real-time information to the teacher so that they can intervene, and they can do things. I hope in the future that that practice is the assessment, that you don’t even have to take separate assessments. But yes, the idea is ‘let’s give the teachers real-time information; let’s not wait until it’s too late.’

 

BILL GATES: Let’s talk about AI. You and I have both been lucky enough over the last six months or so to have engagement with the mix of both Microsoft and OpenAI and have early access. And I remember some of the best examples of how to get the AI to do fun things, where, when you came up and saw me and we were brainstorming about this, you were the one who said, "Hey, if you tell it to write a speech like various politicians, including Trump and others," that it’s stunning how it captures the voice of different people. Give us how you first were using the AI, and then this is super timely because you’ve just recently come out with the Khanmigo, if I’m saying that right.

 

SAL KHAN: That’s right, very good. The OpenAI folks reached out, and they said, "Hey, we’re a couple of weeks away from having the first training of our model." They wanted to reach out to Khan Academy for two reasons. One was they said we want to make this really good at AP Biology, and I only found out later – I don’t know if this is true – they told me you gave them the challenge.

 

BILL GATES: That’s right. In June, they kept showing me this thing, and I was like, "Yeah, it’s kind of an idiot savant. I don’t think it’s practical. Why don’t you see if it can do the AP Biology exam. And I’m not going to pay any attention until you can get a 5." And I thought, "Okay, that’ll give me three years to work on HIV and malaria." And then it was so bizarre because Sam Altman and Greg Brockman in late August said, "Hey, we want to come show you this thing." It was early September when there were like thirty people at my house. And I’ve said it’s the most stunning demo I’ve ever seen in my life. I mean, right up there with seeing the Xerox PARC graphics user interface that set the agenda for Microsoft for about fifteen years. This demo was so surprising to me, the emergent depth that as they scaled up the training set, its fluency, and you have to say understanding, that computers could not read in the sense humans do, and it couldn’t write in the sense humans do. And now, with lots of footnotes about hallucination and things like that, but I’m still personally in a state of shock at wow, it is so good, and okay, therefore, let’s see where we can put it to good use.

 

SAL KHAN: Yes, 100%. And so thank you for that challenge to them. I think that helped. They came to us because we have a large library of AP Biology questions, etc. They’re like, "Hey, can we use that to either evaluate or train?" And at the time I was like, "Well, what’s in it for Khan Academy?" You know, I’m in it. And they’re like, "Well, maybe you get access to the model." And I, too, was skeptical. I had seen GPT-3 at that point, and it was cool, but I don’t see how we were going to apply it. Two weeks later, they showed us the AP Bio question and said, "So Sal, what’s the answer to this?" And I read it. I was like, "Okay, I think it’s C." And it said, “the answer is C," and I was like, "Oh, that’s interesting." I started getting a few goosebumps. And then I said, "Well, ask it why that’s the answer." It explained it.

 

BILL GATES: Oh, yes, it’s so good at that!

 

SAL KHAN: I think what folks need to realize – because everyone had that moment with ChatGPT, but this was like that, but more, because GPT-4 is even better. 

 

BILL GATES: Way better.

 

SAL KHAN: And I said, "Can you say why the other answers aren’t correct?" Did it. Then I said – I’m almost shaking – I said, "Can you write ten more questions like this?" Bam, bam, bam. The first ten I saw were all pretty good. I’m like, "Yep, yep, yep, yep. That’s all legit." And then the implications for Khan Academy started to go through my mind. And then we did start to get into some of its hallucinations and some of its math errors in those early days. But that weekend, they gave me and our chief learning officer access on Slack, and I couldn’t sleep, I was having these ‘in the rabbit hole’ conversations with it. And then we had a hackathon for our team; we got about 40 people on our team under NDA, and we said “just come up with stuff.” We were having the debates that everyone was having around, well, the information is not 100% airtight. The math isn’t great right now. The costs are not trivial. It can introduce bias. What’s the safety? The use of people’s information, etc.? But then we were starting to get it to work well as something that helps you answer questions while you’re watching a video, to work well as a tutor. Every ten minutes we thought about it like, wait, it could also do this. It could also do that. It can also do that. And so we said, "Well, what if we could make it so you could talk to any historical character? What if you could make it so it gets into a debate with you? What if you could make it so it doesn’t write your paper, but it writes it with you? What if it could do lesson plans for teachers?" It could be the end of static curricula. The imagination kept going. By December, January we had our team in full, rapid prototyping mode. Just recently we launched Khanmigo. So far we’re starting to titrate it out to the world, giving people access to it. But the feedback is very promising. What we’re hearing overwhelmingly from social media and the press is that they’re really happy that we’ve engaged in this and that we’re taking a safe approach where parents and teachers can monitor it. We have a moderation filter. OpenAI has also gone through great pains to make sure that things stay appropriate. You and I have talked extensively about the math issue, and we’ve done some things that I think make it quite robust on top of the things that the model does. And the costs are coming down dramatically.

 

BILL GATES: I mean, that’s really impressive.

 

SAL KHAN: Even ChatGPT isn’t bad, and then GPT-4 is dramatically better. It makes mistakes, to be clear. They both make mistakes. But one of the things we realized is when you do math, especially if I’m tutoring you, let’s say you do some work, I don’t just immediately say, "Correct, incorrect." I say, "Well, let me see this." Okay. Let me see what he did. Okay. Okay. Okay. “Yeah, yeah. Good job.” And one of the hacks – I don’t think it’s actually a hack, I think it’s a principle we’re doing – which is we weren’t getting good results when we just asked it to decide, when it acts as a tutor, whether a student is right or wrong. But as soon as we said, you know what, construct your thought, and these thoughts are private to you, write that down first, and then evaluate the student’s response to your thoughts. And then say something publicly to the student, then the math improved dramatically. So it is funny. As soon as one day you think like, "Oh, this is so not like a human being,” and then the next year it’s like, wow, that’s kind of how we operate. We kind of need that thought before we can talk.

 

BILL GATES: The way I think of it is, it’s like a human that’s not very good with context, that the math context we know is a special context of ‘check your answer.’ It’s also sometimes, even in conversation, if you get it into a mode where it’s telling jokes, with humans, we have kind of a look, or the new question is quite different. It thinks it’s supposed to just keep telling jokes, and you almost have to do a reset to get it out of this “Hey, everything is a joke”-type mode. So it’s like kind of a very naive person in terms of all these different contexts we’re in. My favorite one is where it tries to do Sudoku, which it can’t do. And you point out, "Hey, that’s not a good solution.” And it says, "Oh, I must have mistyped,” because it’s like, where is the typewriter? You have a typewriter? 

 

SAL KHAN: [laughs] I like how it gets defensive.

 

BILL GATES: It sees how humans deal with being accused, “My dog ate my homework,” or something like that. It’s kind of human, but in a naïve, untrained way. So if we think about the next ten years, I’m sort of back to my optimism that I had when the Gates Foundation first got into education, that both the absolute level of learning and the gap with lower-income, minority students, that with these new tools can both close the gap and raise up the overall level of achievement. 

 

SAL KHAN: After the pandemic, tens of billions of dollars came in from the federal government to address learning loss. Everyone looked at these decades-old studies around high-dosage tutoring and said, "Oh, we can kind of afford to do tutoring now." And so they hired a bunch of tutoring companies and this and that. And it’s not the tutoring companies’ fault. But what you’re seeing now is just another example that we often see in the school system like, "Wow, this is a good idea, but we’re not really seeing it move the dial." The retrospective people were saying, "Well, in order for it to really work, it’s got to be connected to what the kids are doing in school, and ideally it should be happening while they’re doing it in school." That’s almost impossible logistically to do and expensive if you wanted to do it with live tutors. But Khanmigo, that is, the tutor that we’re putting in Khan Academy, it, in the moment, can act like a fairly good human tutor. There’s moments with it that I think would pass the Turing test, where you’d think that there’s a good human on the other side of the chat. And I think that has a good chance of driving engagement because not only can it tutor, you can ask it why you need to learn this. It says, “Well, what do you care about?” And you say, "Well, I care about this or that." It’s like, "Well, if you care about this, then you definitely need to learn this, and here’s some other things to think about." It honestly answers it better than most humans would. That is going to drive a whole other level of engagement, a whole other level of, "Hey, a student is stuck in algebra because they have some gaps from seventh grade." That’s very hard for one teacher with 30 kids to diagnose. But now to be able to intelligently, with traditional tutoring interactions, say, "Hey, are you having trouble with the negative number here? Let’s review that a little bit." I think that can drive a ton of engagement. I think honestly, just feeling more connected can drive engagement. I’m actually really excited about the next phase of Khanmigo. It’s going to be Khanmigo facilitating interactions inside of a classroom.

 

BILL GATES: With a group?

 

SAL KHAN: With groups. So imagine a teacher just says, "Hey, Khanmigo, take my class of 30, put them into ten groups of three, and I want every group to do this problem. And then I want the students to talk to each other about it. And you’re the facilitator." We’ve run those types of experiments and they’re surprisingly fun where you can do that. It’s not just in math. You could do that in science, where it pushes the students. How does entropy in chemistry connect to entropy in information theory or computer science? And all of these types of things, and the humanities? I do think all of these are correlated, too. When students get confidence in one part of their academics, it drives all the other ones. But now a teacher can say, "Hey, Khanmigo, ask all my students to give their reflection on this issue." And immediately it can tell the teacher, "Hey" – and this isn’t science fiction. I think this is like six months away – it can say, "This is what everyone did. Here’s some exemplars. Some of your kids tend to be confused here. This student seems a little bit disengaged." I think we’re going to see it next year; while the teacher is lecturing or whatever they’re doing, if you’re confused by something they just said, you just ask the bot in real time. It’s like whispering to your friend without disrupting the classroom, but then Khanmigo will tell the teacher, "Hey, three kids just asked me this question. I answered it for you. They’re good now. But you might want to double click on that a little bit." We have another nonprofit called Schoolhouse.World, which is about peer-to-peer tutoring. We’re already using AI to evaluate the transcripts and give the tutors feedback on what they can do better. I could see it being a little bit of a real time, like, "Hey, you haven’t called on this student, or here’s a worked example for you." It’s going to be a wild couple of years, but hopefully positive.

 

BILL GATES: And one thing I always underestimated is how valuable it is for most students to have kind of a social experience. How do you create a conceptually rich but socially engaging way of talking about these math things? 

 

SAL KHAN: No, 100%. Some of my best memories are sitting with friends and working on a particularly hard problem, and somebody has an epiphany; the more that we can try to replicate those things. The model we use is a tutor for every student, and it could be a teaching assistant or an army of teaching assistants for every teacher. I think every teacher on the planet would love to have one, two, three amazing teaching assistants in that classroom that say, "Hey, let’s facilitate these breakouts. Let’s do focused interventions with different students. Let’s make them explain the math to each other."

 

One challenge we’ve always had is that when we bring new technology into the

classroom, if we don’t do it well, the teacher feels like, "Oh, you’re trying to denigrate my creativity or freedom or you’re suggesting I’m not capable on my own." And yet we all know teachers are heroic, one of the most important, hardest jobs in the world. So do you feel like we’re doing better at drawing both their input and showing that, okay, they are 100% at the center of the best solution?

 

SAL KHAN: Yes. I think not only is this about making sure that everyone understands their critical role, but it’s also one of the reasons why you have such a high attrition in the profession. We can talk about pay and compensation, all of that, but I think the biggest thing is it can be a very lonely and a very tiring job. Most of us with ‘desk jobs,’ we don’t have to be ‘on’ continuously.

 

BILL GATES: Yes. Nobody’s trying to disrupt.

 

SAL KHAN: No one’s trying to disrupt, or chewing gum, or looking at you. Even when we’re presenting, we’re usually presenting to people who at least pretend to be interested, right?

 

BILL GATES: [laughs] They’re told to be. Yes.

 

SAL KHAN: Exactly. They got the memo. Well, in a classroom, the kids aren’t always giving you their most attentive look. And that is so draining, energy-wise. We imagine the classroom of the future, and a lot of teachers are already doing this, is to make the students do most of the things most of the time, and that the teacher is the architect, is the conductor of what’s going on. I don’t think anyone in an orchestra would think that the conductor is not an important role. The conductor is making sure that the orchestra is happening together and that everything is fitting together, that it’s controlled chaos. Then I think everyone benefits. The kids have more fun, they learn more, and the teachers have more fun. Instead of one teacher with 30, you should have two teachers with 60, or three teachers with 90 so that they also feel less lonely, which you can start to do if you take the lecture out of the classroom. 

 

What do you think is going to happen in AI, in education and work?

 

BILL GATES: Well, in the education piece, I actually think reading and writing where the software tools have not been that great. Very few students get feedback on an essay, that this could be clearer, you really skipped this piece and the reasoning. I do think the AI will be like a great high school teacher who really marks your essay and you go back and think, okay, I need to step up there. The hardest question to answer is the job market. Now, we’re not going to ever have too many teachers because in the worst case, we shrink class sizes and give more attention. The demand is pretty infinite there. I do a lot of my work in countries where the shortage of doctors and teachers is so acute that the idea of, okay, the AI is too good, we don’t really run into that. But the job market, I think that one, it’s very hard to predict how it’ll shift things. I don’t think students should feel like,

“Okay, I need to learn less. I don’t need to multiply because computers are so good at multiplication.” The new areas of job demand and how we shape this is going to be fascinating to see.

 

SAL KHAN: If you were to advise a parent or a student who’s, let’s say, a teenager who is figuring out what to do with their life, given everything we talked about AI, job market, what would you tell them?

 

It’s great if you learn enough that you find something that’s particularly fascinating

to you. I have an orientation towards the sciences. I still think helping these AI things be better, we need that. The climate work we need is very, very scientifically intense. Also anything in medicine. I have one child who wants to do political policy, including health care. I have one who’s going to be a doctor. I have one who wants to be the CEO of the hospital. All of them can contribute in very different ways. What they pick kind of matches the differences in what they enjoy, what they’re really good at. I would love it if some really smart people would go into politics. I know that’s not attractive, but I think we need a new generation of science-literate and reaching across the divide we have. God knows, young people better come in and help us out there.

 

SAL KHAN: So, Bill, what teachers really pop out in your mind that really affected you?

 

BILL GATES: Well, early on in math, I was kind of lazy, and a teacher in eighth grade said, "How come you’re so lazy? You could be really good at this." I said, "But we’re not doing anything interesting." He would give me books to read and help really push me quite a bit. It made a huge difference that he thought I was wasting my time. It changed my whole view of education. I kind of had this view that the less effort you put in, the cooler you were.

 

SAL KHAN: [laughs] That’s right, very good.

 

BILL GATES: Do you have a particular teacher that helped motivate you?

 

SAL KHAN: I have several, probably three or four that pop in my mind. There’s second grade, Ms. Krauss and Ms. Roussel. It was kind of this enrichment gifted program. They were the first teachers that really said, "Hey, what are you interested in?" And that was the first time I experienced personalized education. Jefferson Parish School System in Louisiana, I’ve got to give credit. It was a really great experience. Then I remember Ms. Ellis in fifth grade. She ran her fifth grade social studies class like what I now know is a college seminar. She would just peel an orange and just ask us questions. I would look forward to it. Also Dr. Harris Antonia. When I was in high school, I took courses at the University of New Orleans, which was the local college there. He was my differential equations teacher. When he found out that I didn’t have a computer at home, he’s like, "Well, you need a computer." He got me a research job at the University of New Orleans when I was 15 years old. That’s the first time I could program. I really got to work with real computers. If I didn’t have that experience, I don’t know what would have happened after that.

 

BILL GATES: If you had one magic wish to master a subject without any studying, which would you choose?

 

SAL KHAN: I would say it would either be quantum physics or piano. [laughs]

 

BILL GATES: I’m embarrassed that even though I know all these computer languages, and I took Latin and Greek, I don’t speak any real languages other than English. Maybe if it was easy to learn and I could just use my wish on it, I might choose Chinese, because I do think helping China and the US get along is going to be pretty important.

 

[music]

 

So I said, before you came, if you had a record that you wanted to bring, to please

share it with me.

 

SAL KHAN: What we’re going to play is Bob Marley’s “Redemption Song,” which is, as you mentioned, in my high school rock star days, “Redemption Song” was one of the first songs that I learned on guitar. It always spoke to me. It’s about bondage of many kinds, both physical and mental bondage, and kind of breaking free of it. So I’ll play it. 

 

BILL GATES: Cool. 

 

[music –"Redemption Song" by Bob Marley]

 

BILL GATES: So great. This is just a classic. 

 

[music]

 

BILL GATES: So, if you do a web search on Sal Khan, you might get some of this guy. Do you ever get confused with Salman Khan?

 

SAL KHAN: I do. In fact, in the early days of Khan Academy, I got letters from some of his fans saying I’ve always been in love with you, I didn’t know you could do math, and all that. And it’s funny because, you know, us South Asians like a good kind of cheesy thing. So when I went to India in 2015, we had a live, on national television, interview between the two of us.

 

BILL GATES: Oh, you’re kidding.

 

SAL KHAN: Just by virtue of us having the same name. But I do watch more Bollywood movies than folks suspect.

 

BILL GATES: [laughs] Uh-oh.

 

SAL KHAN: My wife grew up in Pakistan, so people think that she made me watch the Bollywood movies, but it’s actually the other way around. I’m the one that made her watch the Bollywood. So I was very aware of him. It was kind of a fun thing to be in the same room and share the same name.

 

BILL GATES: Do you watch them in Hindi or English?

 

SAL KHAN: I can understand Hindi, which I have no business understanding. My family, our mother tongue is Bengali.

 

BILL GATES: Oh, Bengali.

 

SAL KHAN: Yeah.

 

BILL GATES: Oh, wow. And your wife?

 

SAL KHAN: My wife’s mother tongue, they’re originally Gujarati, but she spoke Urdu growing up in Pakistan. I learned Hindi mainly hearing my mom gossip on the phone when I was growing up.

Bollywood movies, that’s my India now. Like a little bit Hindi and Urdu spoken is almost the same thing. So I know enough to get by.

 

BILL GATES: You and I both want education to be a lot better for all types of students. It’s an exciting time, and it seems like you’ve got as much energy for Khan Academy today as you did when it first got started.

 

SAL KHAN: I’ve always run optimistic and I’ve always had reasonable amount of energy. But yes, I’ve told the team, what’s about to happen in the next few years, it feels like we’re in the middle of a science fiction book, and hopefully it’ll be all for good. And I’m pretty hopeful.

 

BILL GATES: Well, thanks for coming down. Thanks for being on a learning journey with me and in a cause that we both believe in.

 

SAL KHAN: Thank you. Hope to have, what is it, "unconfused you” a little bit.

 

BILL GATES: Yes, yes definitely.

 

[music]

 

BILL GATES: Unconfuse Me is a production of the Gates Notes. Special thanks to my guest today, Sal Khan.  

 

[music ends]

 

BILL GATES: No, I’ve never been mistaken for Salman Khan. [laughter]

 

 

 

 

 

 

 
 

 

 

Excel工作簿自动销毁功能,使用时间到期后自动删除文件

想必很多人都使用过付费软件,不同类型的付费软件,软件到期后,对用户使用软件的限制规则也不相同。有些软件试用到期后会限制软件的关键功能,有些软件试用到期后会阻止软件打开。

我们在使用Microsoft Excel时,有时候会花费大量的时间编辑函数,编辑VBA代码,让Excel工作簿变得十分强大。甚至有些人专门开发一些Excel工作簿,供别人付费使用,与此同时版权保护成为难题。

 

 

既想让别人知道你编辑的Excel工作簿是否好用,又想保护自己的劳动成果,鱼与熊掌不可兼得。事实并非如此,我们可以将Excel工作簿设定一个使用期限,试用到期后,Excel工作簿自动销毁。这样设定话,既可以让顾客了解Excel工作簿的功能,也可以保护自己的劳动成果,是不是两全其美呢!来看一下实际效果吧!

 

动图封面

 

步骤一:要实现这么高级的功能,当然离不开VBA啦!首先右键单击示例工作表,然后左键单击【查看代码】选项,最后在Visual Basic编辑器中左键双击工程资源管理器中的【ThisWorkbook】选项,并将以下代码复制粘贴到右侧的代码窗口中。

请注意:代码【If DateDiff("d", DateSerial(2019, 8, 16), Date) >= 30 Then】中,(2019,8,16)指代的是起始日期,Date指代的是系统当前日期,>=30指代的是使用期限为30天。起始日期和使用期限可根据自身情况修改。

 

动图封面

 

代码区域:

Private Sub Workbook_Open()

If DateDiff("d", DateSerial(2019, 8, 16), Date) >= 30 Then

MsgBox "此文件试用期限为30天,目前您的使用期限已到,请联系开发者!", 48, "温馨提醒您:"

Call KillThisWorkbook

Else

Exit Sub

End If

End Sub

步骤二:接下来需要插入一个模块。首先右键单击工程资源管理器窗口,并将鼠标指针移动至插入选项,然后左键单击【模块】选项。最后将以下代码复制粘贴到模块1的代码窗口中。

 

动图封面

 

代码区域:

Option Explicit

Sub KillThisWorkbook()

Application.DisplayAlerts = False

With ThisWorkbook

.Saved = True

.ChangeFileAccess xlReadOnly

Kill .FullName

.Close

End With

Application.DisplayAlerts = True

End Sub

步骤三:这时候我们发现一个问题,VBA代码如果不进行加密操作,任何人都可以通过删除代码来破解Excel工作薄的使用期限,这时候我们需要将VBA代码加密,以阻止他人更改代码。

首先左键单击菜单栏中的工具选项,接着左键单击下拉菜单中的VBAProject属性。然后在VBAProject工程属性对话框中左键单击保护选项卡,并在查看时锁定工程前的方框中打上对勾。最后在查看工程属性的密码中分别输入密码和确认密码,输入完毕后左键单击确定按钮,并关闭Visual Basic编辑器。

 

动图封面

 

步骤四:最最重要的一步,否则你前面的努力就白费了。首先左键单击菜单栏中的文件选项卡,然后左键单击另存为选项,在右侧选择文件的存储路径。最后在另存为对话框中的保存类型,选择Excel启用宏的工作薄(*.xlsm),并点击保存按钮。

 

动图封面

 

至此,Microsoft Excel使用期限到期后文件自动销毁功能已经介绍完毕。是不是觉得很炫酷呢?有没有科幻大片的感觉?觉得好玩的小伙伴们,抓紧时间动手实践操作。Excel高级机能学会了,那么你距离脱单又进了一步,加油吧!

动动手指点击关注和转发,让更多的人告别加班的烦恼,每天掌握一些科技小技巧,相信也会为您的工作和生活带来便捷。

Sony SRS-XB13 无线蓝牙便携旅行音箱-用户指南

索尼

索尼 SRS-XB13 无线蓝牙便携旅行音箱

Sony-SRS-XB13-无线-蓝牙-便携-旅行-扬声器-Imggg

产品参数

  • 产品尺寸 
    3.43x3.43x4.41英寸
  • 产品重量 
    8.9盎司
  • 电池 
    1 锂离子电池
  • 喇叭类型 
    铝合金提手
  • 连接技术 
    版本 4.2
  • 电池寿命(大约) 
    16小时
  • 内置麦克风 
  • 产品品牌
    索尼

介绍

超紧凑的 SRS-XB13 无线扬声器可提供出色的声音,并采用 EXTRA BASTM 升级 IP67 防水和防尘结构。 1、2,电池续航时间长达16小时。 3 XB13 有一个多向带,足够小,可以放入杯架或包中,让您随身携带。

什么是盒子?

  • 喇叭
  • 用户使用手册

零件和控件 

Sony-SRS-XB13-无线-蓝牙-便携式-旅行-扬声器-Fig-1

  1. 带有电源指示的按钮
  2. 收费指标
  3. 带指示的 ST PAIR(立体声配对)按钮和带指示的 (BLUETOOTH) 按钮
  4. (播放)和(通话)按钮
  5. (音量)-/+ 按钮
  6. MIC(麦克风)
  7. 上下绑带孔
  8. USB Type-CDC® 的 IN 5V 端口
  9. 扬声器随附的 USB Type-C 线缆和 USB AC 转换器可用于在连接到交流电源插座(市售)时为其内部电池充电。
  10. 行李带

使用表带

您可以使用连接在扬声器上的带子将扬声器挂在包或背包上。

使用上背带孔来使用背带

  1. 从挂钩上取下皮带。
  2. 将腰带的末端环缠绕在包把手或类似物品上后,将其重新连接到钩子上。

通过上带孔和下带孔使用带子

  1. 从挂钩上取下皮带。
  2. 通过下带孔,插入安全带。
  3. 将腰带缠绕在目标物体上后,将腰带的末端环重新连接到钩子上。

备注 

  • 仅使用随附的表带。 不要使用其他任何东西。
  • 将带子固定到扬声器后,确保带子的末端环牢固地固定在挂钩上。
  • 请勿摆动扬声器或对将其固定在身体上的带子施加过大的力。
  • 扬声器应该是您使用表带的唯一设备。

为扬声器充电

扬声器可以由可充电内置电池或通过 USB 交流适配器的交流电源插座供电,这两种都是市售的。 首次使用扬声器之前,请确保为扬声器的内部电池充电超过一小时。 如果您事先为内置电池充电,您可以仅依靠电池供电使用扬声器。

要为扬声器充电,请将其连接到交流电源插座。
USB Type-C® 电缆的一端应连接到扬声器上的 DC IN 5V 端口,另一端连接到 USB 交流适配器(市售),然后应连接到交流电源插座。 输出电流为 500 mA 或更大的 USB 交流适配器与扬声器兼容。 不保证电池充电适用于任何其他设备。

充电过程中,CHARGE 指示灯变为橙色。 预计充电时间因 USB AC 适配器连接的电源输出容量(市售)而异。 此外,根据 USB AC 适配器和 USB 电缆的类型和规格,充电时间可能会比下述时间长。 根据环境温度或扬声器的使用情况,充电时间可能与以下所示时间有所不同。

之后的时间是为了上下文而提到的。

  • 连接可产生 4 mA 或更高输出电流的市售 USB AC 适配器并且 CHARGE 指示熄灭时,充电完成大约需要 30 小时 500 分钟*。
  • 确保您使用的 USB AC 适配器在使用前可以产生 500 mA 或更大的输出电流。
  • 扬声器关闭后为空的内部电池充满电所需的时间。

开启电源

(电源)按钮,按下它。

  • (电源)指示灯以蓝色缓慢闪烁,而 (BLUETOOTH)指示灯以绿色亮起。
  • 当没有扬声器的配对信息时,例如当您购买后首次使用 BLUETOOTH 功能时, (BLUETOOTH) 指示灯会以蓝色双闪。

备注
如果 CHARGE 指示灯闪烁 XNUMX 次并且扬声器在打开后关闭,则表示内置可充电电池已耗尽。 为内部电池供电。 当 CHARGE 指示开始缓慢闪烁时,需要对内置电池进行充电。

关闭电源

(电源)按钮,按下它。

  • (电源)和 (BLUETOOTH)指示灯均消失。

常见问题解答

我可以让它一直插着电源,否则会损害电池吗?

 是的,将其 24/7 插电是安全的,因为当锂离子电池充满时充电停止。 仅在电池电量充足时才应用顶部充电tage 下降到一定水平。

可以和谷歌助手一起使用吗?

不知如何设置我的 Sonyxb13extra bass 无线蓝牙便携轻巧紧凑型旅行音箱

对海滩有好处吗?

您会很高兴知道 XB13 可以在海滩上使用并且在任何地方都很棒。SRS-XB13 包括出色的声音功能,例如 EXTRA BASS 和声音扩散处理器,可增强节拍和更广泛的声音传播。 凭借多向背带、充满电后 16 小时的电池续航时间以及 IP67 等级的防水防尘外壳,这款扬声器随时准备为您带来震撼的声音。

你如何关闭扬声器? 我一直按住开/关按钮,但它一直亮着

要关闭扬声器,请按电源按钮。 (电源)指示灯和(蓝牙)指示灯熄灭。

它是否带有一根小充电线但没有 C 型适配器?

此扬声器不附带用于交流电源插座的交流适配器。 XB13 随附的附件如下:USB Type-C 数据线(USB-A 转 USB-C)和背带(附在本机上)。扬声器支持输出电流为 500 mA 或更大的 USB AC 适配器。 您可能已经拥有一个可以使用的设备,因为大多数手机/移动设备都带有它们。 如果您没有,则需要购买能够输出 500 mA 及更高电流的 USB AC 适配器(市售),如果您希望将设备充电至 AC 插座。 您还可以通过将与扬声器相连的 USB 电缆连接到配备 USB 充电端口的计算机来为扬声器的内置电池充电。

这个产品是在哪里生产的?

我们深表歉意,但由于供应链因素的变化,制造地点可能会发生变化。 但是,我们可以告诉您,无论在哪里生产 SRSXB13,它的质量标准都与所有索尼产品相同。 请放心,这款无线扬声器会很棒! SRS-XB13 包括出色的声音功能,如 EXTRA BASS 和声音扩散处理器,可增强节拍和更广泛的声音传播。 凭借多向背带、充满电后 16 小时的电池续航时间以及 IP67 等级的防水防尘外壳,这款扬声器随时准备为您带来震撼的声音。

可以换电池吗,在哪?

 不,此扬声器包含不可更换的内置可充电电池。 

有辅助线的连接吗?

 不幸的是,扬声器没有用于辅助连接的 AUDIO IN 插孔。 通过蓝牙支持音乐播放。 如果您需要具有 AUDIO IN 插孔的扬声器,您可能需要考虑 SRSXB43。 SRSXB13 仍然是一个了不起的扬声器。 SRS-XB13 包括出色的声音功能,如 EXTRA BASS 和声音扩散处理器,可增强节拍和更广泛的声音传播。 凭借多向背带、充满电后 16 小时的电池续航时间以及 IP67 等级的防水防尘外壳,这款扬声器随时准备为您带来震撼的声音。

我可以使用这个产品多久?

 如果您询问这款便携式扬声器的电池寿命(充电),它可以持续长达 16 小时(充满电,音量设置为 26)。 如果您指的是设备的预期寿命,索尼或任何其他制造商都很难引用产品的预期寿命。 某些变量,例如产品的使用量(或不使用量)以及使用产品的环境条件,对产品的预期寿命起着一定的作用。

我可以在通话时将麦克风静音吗?

无需将麦克风静音。 索尼扬声器支持蓝牙,因此您可以通过扬声器本身进行通话。

它比JBL好吗?

我一边打字一边听。 这是每个人都应该拥有的设备。 体积虽小,但音质可与全尺寸立体声音响相媲美。

喇叭的瓦数?

你知道它没有在盒子或插页上说吗? 但人们认为它是收音机,而不是小喇叭!

这可以与 XB-12 配对吗?

要使用 2 个扬声器(立体声配对功能)无线聆听音乐,需要 2 个 SRS-XB13 扬声器。 通过 BLUETOOTH 连接连接 2 个扬声器,您可以享受更强劲的声音。

是带遥控器来的吗?

XB13 不带遥控器。

产品质量有保障吗?

是的! SRS-XB13 耐用且便携。 耐用的外部和多向带使这款扬声器几乎可以应对任何事情。 外出晒太阳时,可将其挂在背包或手腕上,甚至是遮阳伞上。

 
 

 

 

国内10个最佳的控制面板,可轻松管理服务器

为什么要用到服务器控制面板?
使用服务器控制面板能使搭建服务器平台简单许多。环境一键部署集成环境,无需东凑西凑环境包,管理面板可视化、简易高效、操作透明、可扩展。控制面板能更好运维服务器,减少些不必要的工作,选择靠谱的云控制面板还能增强服务器的安全性能,让项目运营更无忧!

1.宝塔面板

推荐指数:★★★★

目前互联网受面最广的服务器控制面板,两个版本可兼容Linux与Windows系统。支持LAMP/LNMP/集群/监控/网站/FTP/数据库/JAVA等100多项服务器管理功能。通过Web端轻松管理服务器。宝塔对于新手来说,优点很多,目前有些功能需要收费,但免费版不影响使用。

获取宝塔面板

2.云帮手

推荐指数:★★★★

公益面板,目前无收费行为,对于不想买付费面板的运维人来说是最好的选择,自带远程连接功能,无需再通过其他工具进行远程桌面控制,也是因为这样所以云帮手的安装和服务器的添加相比之下更方便快捷;支持站点环境一键部署(如php、Apache等安装)、资源监控、站点备份管理等等,目前只兼容Windows系统 ,带有IOS与安卓远程控制面板软件。

获取云帮手

3.AppNode

推荐指数:★★★

AppNode是Linux旗下的一款集群部署的要视化面板,前身是VPSMate,之前VPSMate是获得过阿里云设计类大奖的,但是后期被搁置了。终于他也走上了商业化的道路,推出了新版的AppNode这个可视化管理面板。优点其功能较多,对重度用户非常友好,其缺点面版设置比较繁琐没有其他那么简洁,使用运行内存占用较高。目前只兼容Linux系统 。

获取AppNode

4.旗鱼云梯

推荐指数:★★★

旗鱼云梯是2019年新加入linux服务器运维行列的新兵,可以无限制添加自己的服务器,没有数量限制,集群化做的不错,对于SEO网站有大量的优化工具可以使用,但是很多插件和布局不够完善,价格是在所有linux全功能面板里算是比较便宜的。

获取旗鱼云梯

5.WDCP运维面板

推荐指数:★★

WDCP是国内最早linux面板,可是这些年更新缓慢,慢慢脱离大部队,很多功能已现老态,很多新的功能的插件都没有 ,功能比较单一,受攻击后没有任何防护能力,收费版价格很高。目前只兼容Linux系统 。

获取WDCP运维面板

6.AMH运维面板

推荐指数:★

AMH 是国内首个开源的主机面板,新手不建议使用,需要收费,但是不贵,国内目前最强大的管理面板。实现平台化架构设计,高可扩展灵活性,所有功能软件可选择定制下载安装。支持用户自由弹性组建运行环境与切换环境。目前只兼容Linux系统 。

获取AMH运维面板

7.URLOS运维面板

推荐指数:★

URLOS是一个Docker管理面板,它把服务器端软件应用的安装行为简化到极致,堪称服务器端的应用宝,具有集群管理、自动故障转移、自动负载均衡等高级功能。其运用复杂单调,不推荐使用,且功能相对较少,标准版起需要收费。目前只兼容Linux系统 。

获取URLOS运维面板

8.快云小助手

快云小助手网页版景安网络开发的免费的VPS(服务器)管理面板系统,拥有Windows WEB管理面板和Linux WEB管理面板两个版本,无论是Windows操作系统还是Linux操作系统服务器都可以选择快云小助手网页版对应版本来实现一键建站。通过安装快云小助手网页版可以直观的以网页形式来管理服务器系统、网站和数据库。

获取快云小助手

9.护卫神·主机大师

护卫神主机大师是一款安全防护的服务器,一键安装网站运行环境,在线开设主机和SQL数据库,独立前台控制面板,强大的安全机制,永久免费使用。

获取护卫神·主机大师

10.phpstudy(小皮面板)

PhpStudy国内12年老牌公益软件,集安全,高效,功能与一体,已获得全球用户认可安装,运维也高效。
支持一键LAMP,LNMP,集群,监控,网站,FTP,数据库,JAVA等100多项服务器管理功能。

获取phpstudy(小皮面板)

About Us

Since 1996, our company has been focusing on domain name registration, web hosting, server hosting, website construction, e-commerce and other Internet services, and constantly practicing the concept of "providing enterprise-level solutions and providing personalized service support". As a Dell Authorized Solution Provider, we also provide hardware product solutions associated with the company's services.
 

Contact Us

Address: No. 2, Jingwu Road, Zhengzhou City, Henan Province

Phone: 0086-371-63520088 

QQ:76257322

Website: 800188.com

E-mail: This email address is being protected from spambots. You need JavaScript enabled to view it.