If you want a job coding, you have to know how to get around a database, and that means SQL. I know–a geeky, scary three-letter word that makes even math aficionados decide to choose advanced calculus rather than computer programming. One of the Ask a Tech Teacher crew has suggestions on how to test it out and what are the most important elements to learn:

How High School Students Can Try Out SQL and 4 Things They Should Learn About It 

Computers and coding languages are becoming more important in our lives with each passing day, but it can be hard for high school students to choose the best coding languages for their needs. In this article, we’re going to make a case as to why high schoolers should learn SQL.

What is SQL?

SQL is a programming language that you would use to query data in relational databases. You can create, modify, update, delete, and perform other essential operations on tables within a relational database. SQL is classified as a procedural language used to specify data types.

Most SQL programs will teach you how to read data from an analytics or database performance analyzer, such as SolarWinds’ DPA. SQL databases typically come with the following features:

• Creating tables to store written information
• Adding, deleting, and updating rows
• Reclaim database rows
• Modifying the structure of the database
• Filtering database entities

The SQL programming language has become a standardized database technology, so it’s unlikely it’s going anywhere anytime soon. SQL is incredibly popular in several industries, such as finance, music, data analysis, web development, and social media, making it really useful. 

(more…)

As a passionate Economics major in college (which grew into an MBA), I find Econ at the root of much of the world around us. It starts with counting coins in first and second grade and grows up to a peek into NASDAQ and other adult subjects in middle school.

In the US, tax day is April 15th. Here are some good websites to discuss what is probably a popular topic in families:

Taxes

1. BrainPOP | Taxes
2. A history of US taxes
3. Taxes–from Crash Course Economics
4. Where does your money go? — lesson plan from PBS
5. TurboTax Tax Calculator

After April 15th, there are great ways to teach about economics, financial literacy, and prepare students for managing their lives fiscally once they’re launched into the world:

(more…)

Preparing students for college or career is arguably the biggest goal for High School. I like the focus of this particular principal, spotlighted in an article in The 74 Million:

Principal’s View: To Prepare Students to Enter a Tech-Focused Business World, Create Schools With the Workplace in Mind

Consider the world students face when they graduate. For many, their choices lead to college, vocational training or manufacturing careers that rely heavily on advanced technologies — from robotics and 3-D printing to equipment powered by artificial intelligence. Two decades from now, their jobs will be even more tech-focused, as workplaces adopt innovations we’ve yet to even imagine.

Read on…

Check out these Ask a Tech Teacher articles and resources on College and Career:

(more…)

I read an interesting article in the Wall Street Journal discussing the dramatic decline in men applying for and graduating from two and four-year colleges. Here’s the introductory piece of the discussion:

Men are abandoning higher education in such numbers that they now trail female college students by record levels.

At the close of the 2020-21 academic year, women made up 59.5% of college students, an all-time high, and men 40.5%, according to enrollment data from the National Student Clearinghouse, a nonprofit research group. U.S. colleges and universities had 1.5 million fewer students compared with five years ago, and men accounted for 71% of the decline.

While the reasons for the decline are varied and complicated, the solutions mind-numbing, if your high school students are looking for alternatives to traditional four-year college and University environment, run through this simple matrix to see which you’re better suited for:

Then, check out these articles discussing how to prepare for the choice best for you:

College or Career? Check out These

MS Career Planning: Moving in the Right Direction

Clutch Prep: When You Need Help With a Class

What to do when Johnny wants career, not college?

Whether you pick college or career, students need to prepare a resume. Here are resources to create one that’s professional and thorough:

1. Google Docs–go to Docs.Google.com and select Resume template
2. PorfolioGen–A free site that lets you collect all the pieces of your experience into one nicely-formatted digital place. 
3. Resume Builder
4. Resume Generator
5. Student CV Builder
6. Wix–This is free with lots of templates so you can share exactly the right image. Here are examples.
7. WordPress–Use a free WordPress blog, but instead convert the pages to topics discussed below. Here’s an example.

(more…)

Here are a few of the popular resources teachers are using to reinforce Drivers Ed in High School courses:

1. Crash Test Simulator
2. Driver Education and Training Videos
3. Edriving–driving simulations
4. Operation Lifesaver
5. Simulated driving (fee)

Driving and Texting

1. It can wait — video showing simulation of driver distracted by texting
2. Texting etc–Chicken Road YouTube
3. Texting–a game that gauges your distraction while driving and texting
4. Texting and Driving–video on the real-life implications
5. Texting While Walking–from the NYT, a video op-ed
6. The Last Text –video
7. Wait for it — very sad video about texting and driving

Click here for updates to this list.

(more…)

If you’re teaching high school videography, you want your students to use the programs that will be required in the job they end up in after graduation. You don’t want an ‘easy’ program. You want one that demonstrates the student’s expertise at an interview. But what are those programs? Here are some good suggestions:

What is the best video editing software for professionals?

Having your content in video format surely engages more people in your business or project. Nowadays, people are keener to watch videos instead of reading texts. But having average video editing software is one thing, and professional, high-quality software that makes your videos stand out is another thing. Having a low-quality video can decrease the interest of the viewers immediately. And to avoid such inconvenience, it is best to use software that is compatible with the up-to-date video editing trends. 

If you want to keep up with the newest trends of video editing and increase your brand reputation, finding the best video editing software is an important task for you. Either your videos are for entertaining, business, or personal purposes, professional editing will definitely stand out from the crowd. And to find the best video editing software for professional use can sometimes be overwhelming as there are so many options in the market. Moreover, the best video editing software is individual to each user. 

With the constantly developing and quickly advancing video editing technologies, many video editing programs offer similar editing features, including similar user interfaces, special effects, file import formats, etc. And this is where the confusion of the definition “best” starts. 

It depends on your needs and goals for your projects. Moreover, it depends on your video editing skill level. So when you look for the best video editing programs, ask yourself, “What video editors do other professionals in my industry use?”

Studying the market of professional video editors in your specific industry will help you understand better which software will work for you best. And when you find software that is strongly recommended by professionals, do some tests yourself. You will find free trial offers from most of the video editing programs that will help you understand whether it works for you or not. This way, you will not waste your money on software that you’ll give up using after a while. 

Below, you will find some of the most used and most recommended video editing programs that can meet your preferences as well. 

Adobe Premiere Pro

If you are using a PC for video editing, Adobe Premiere Pro is one of the most popular options for professionals. With this program, you will have a chance to have unlimited customizations to your files. Thanks to its nonlinear editing capabilities and extremely powerful and expansive feature set, many users prefer this program for video editing.

Pros 

• It has unlimited multicam angles editing capabilities
• Offers outstanding stabilization tools
• You can import videos of up to 8K resolution
• Straightforward and uncomplicated interface

Cons

• Sound effect samples are not included
• Frequent crashes and bugs during the editing process

(more…)

At a time when coding careers continue to flourish – despite the Covid19 pandemic and its adverse effect on the world economy – it is not surprising to see kids learning programming at an early age. And the coding language of Python has won what can only be described as a growing following over the years. Not just among grownups but kids too.

So what is Python and why should kids learn it? Let’s start by taking a quick look at this programming language. A high-level general-purpose programming language, Python is being hailed today as the best coding language for beginners, including kids and teens.

Below are the top reasons why kids should learn Python:

1. Ease of Learning: Boasting a syntax that is very similar to that of English, Python is easy to learn, especially when compared to most other programming languages. In Python, one can write concepts in fewer lines of code, making it a very useful and fast choice for tasks, especially for beginners, including kids. Moreover, Python affords a great deal of flexibility as a coding language which means kids can experiment easily and more often.
2.  Soaring Popularity: Python is one of the most popular programming languages in the world now. In fact, it is said to have secured the second place in last year’s ranking of programming language popularity as published by the analyst firm Red Monk. This has definitely added to its appeal making more kids want to learn Python.
3.  Good Documentation, Community Support and a Big Network of Python Libraries: There is no dearth of guides and video tutorials for those working with Python. The community support makes it very easy for kids to learn computer science with Python. Plus, Python has several libraries that help minimise one’s time and effort during development. For instance, Matplotlib is used for plotting charts and graphs; SciPy for engineering applications, science, and mathematics; Beautiful Soup for HTML parsing and XML and NumPy for scientific computing.
4. Highly Versatile, driving up its Cross-Industry Appeal: Python is being used in different types of environments such as mobile applications, desktop applications, web development, hardware programming, and many more. This makes it a highly versatile programming language. Today, it is widely used in Big Data Analytics, Internet of Things (IOT), Full Stack Web Development, Computer Vision, Machine Learning and Artificial Intelligence.
5.  Enjoys the Support of Leading Colleges and the Corporate Sector: Typically the first language taught in the computer science curriculum, Python has the backing from most of the top computer science college programs. It also enjoys support from Facebook, Amazon Web Services and Google. Thanks to the above reasons, more kids are learning Python today than ever before. It also helps that there is no shortage of learning resources today – both online and offline. There are many free learning resources one can find today but if you are looking for greater accountability, it is recommended to join a coding class. A leading coding program for kids and teens, YoungWonks provides students individual attention in 1:1 live lessons, fostering an environment where kids feel free to explore their creativity by experimenting and making new programs, apps, websites, games, robots and electronic devices. Not surprisingly, its students have even won first prizes at the RoboRave International 2018, RoboRave California 2018 and RoboRave US National 2017, making it a good choice for a kid looking to learn coding. Students even get a free trial to test the quality of lessons before they join the program.

–thank you to Ask a Tech Teacher contributor for this article (more…)

A logical step for many teachers is to progress from teaching High School to College. But that is more complicated than it sounds. Here’s an good article from an Ask a Tech Teacher contributor on what you should know to make that a successful endeavor:

What to Know Before Moving From High School Teacher to College Professor

Teaching is one of the most fulfilling, albeit challenging, jobs you can do. No matter the location or level, there will be immense feelings of pride, moments of anguish and many tired nights and weekends.

For those who get started as a high school teacher, there comes a time when they think about moving on to teaching at the college level. If you have interest in becoming a college professor, the following questions will help you understand all the benefits, differences, challenges and steps to changing your career path.

High School or College: Which Has a Higher Earning Potential?

As most educators know, there is a salary bump at the college level. The median pay for post-secondary (college) teachers in 2020 was $80,790, according to the Bureau of Labor Statistics (BLS). This is well above the $62,870 median annual salary for high school teachers. In general, education isn’t the field you enter to get rich, but that extra income can be a major incentive to make the transition.

Are There Fewer Jobs Available for College Professors?

Though it may be surprising, there are actually more college professors in the United States than high school teachers. In 2020, there were 1.33 million post-secondary teachers compared to less than 1.05 million high school teachers, according to BLS. The field is also expanding faster in higher education, which BLS forecasts will add another 121,500 workers by 2029, compared to just 40,200 more in high school.

What Are the Requirements to Teach in College?

While the majority of tenure positions at four-year universities will require a doctoral degree — plus at least seven years teaching in the field for an institution — there are a range of opportunities available with a master’s degree as well. Community college teachers, for example, typically only ask for a master’s, and even well-known schools hire professors in some specialities, including the arts, without a Ph.D. 

(more…)

There’s still time this school year to help high school students learn the skills they’ll require to thrive in Higher Education. Here are basics you don’t want them to graduate without–from one of our Ask a Tech Teacher contributors:

4 Ways to Help High School Students Develop the IT Skills They’ll Need for Higher Education

Being able to use technology to its fullest is vital for students as they move from high school into higher education, yet it is not enough to assume that they will pick these skills up on their own.

Teachers can be proactive in their approach to fostering IT abilities in students, and here are just a few sensible strategies that will make this easier to achieve.

Leverage remote learning tools

Remote learning has become a reality for millions of people recently, and a study of higher education IT found that 70% of universities are planning to take a hybrid approach to teaching in the coming year. This means that students need to be familiar with the tools and techniques that are involved in this scenario, so that they do not fall behind their better-prepared peers.

That is not to say that teachers should simply pile in every remote learning tool and app available to them just for the sake of it; think about which tools and resources are actually appropriate for the subject in question, and use these in a way that makes a positive impact to the students’ experience. This will avoid making the process of remote learning overwhelming, while still giving them an understanding of what solutions will be part of their higher education ecosystem going forward.

(more…)

This is such an important topic! Often kids–and parents–see tech as complicated, daunting, all-math-and-science. Kids think they’re not ‘smart’ enough and maybe, parents think that too! Here are great suggestions for encouraging young participation in a field that is probably the top choice for jobs:

4 Ways to Inspire Kids to Pursue a Degree In Information Technology

In this tech-centric day and age, the demand for science, technology, math, and engineering skills has spiked significantly, and it only seems to increase. This is evident in how an increasing number of schools offer information technology degrees. There isn’t a single day that we don’t interact with technology. However, while the vast majority of people understand how to use technology, far too few want to understand how technology works.

It’s intimidating to delve into the finer details on the functionality of tech. Most people know how to use a social media platform, but show no interest in understanding the coding behind it. How then, can we spark such an interest in our children?

Start With Toys

Playtime eventually evolves into work time, and toys have a powerful influence on a child’s interests, thinking, behavior, and creative expression. Educational toy manufacturers such as Sphero, Kiwi Co., and Sparkfun create toys that help children learn about coding, circuitry, engineering, and many other STEM fields.

Celebrate With Tech

Introduce your child into the culture of science by holding their next birthday at a science center or a discovery museum. Sure, many schools organize field trips to these places, but if you want your child to gain a genuine interest in these things, you need to try to introduce it on a more personal level. It’s much easier to pique a child’s interest when an element of fun is introduced.

(more…)