This is one of the most popular lessons I teach to Excel beginners. It is relevant, instantly usable and makes sense from the beginning. Click the images below to enlarge them for viewing.

–from 55 Technology Projects for the Digital Classroom

Copyright ©2023 usna.wordpress.com – All rights reserved.

Learning computers starts in kindergarten with understanding hardware. This lesson plan (#103 in the lesson plan book noted below) includes three pages. Introduce less with K, more each year until by sixth grade, students are good hardware problem solvers because they understand the basics.

Page 2 is an assessment you can either print out and have students fill in or push out to students to be completed online.

(more…)

This project (#70 in the collection of #110) hides a spreadsheet’s power behind a template you create and students fill out at home. If they’re older and more familiar with spreadsheets, involve them in creating the template. If the lesson plans are blurry, click on them for a full size alternative.

Note: The example uses Excel, but it works just as well with Google Spreadsheets.

–from 55 Technology Projects for the Digital Classroom

(more…)

The first time I read about Unschooling, I ignored it. Surely, it was a fad that would go away.

When I read about it a thousand more times, I dug into it.

Inspired by the teachings of John Holt (1923–1985), this free range branch of homeschooling promotes learning through nonstructured, child-led exploration. There’s no set curriculum or schedule; students learn what interests them with guidance from involved adults. There are no worksheets, tests, or structure to provide evidence of learning or templates for teaching. The children pick what to learn, when, at what pace. The result — according to unschoolers, is a love of learning, tenacity to a task, and independent thought that prepares them for college and career better than traditional methods. In fact, if you look at the list of traits valued in popular education programs such as Habits of Mind and Depth of Knowledge, the reasons why parents unschool their children mirror the traits included in these lists.

What is it

According to  Dr. Peter Gray of Freedom to Learn:

“Unschooling parents do not … do at home the kinds of things that are done at school. More specifically, they do not establish a curriculum for their children, do not require their children to do particular assignments for the purpose of education, and do not test their children to measure progress. Instead, they allow their children freedom to pursue their own interests and to learn, in their own ways, what they need to know to follow those interests. They may, in various ways, provide an environmental context and environmental support for the child’s learning. In general, unschoolers see life and learning as one.”

If you use Genius Hour in your classroom, you have a sense of how inspiring, motivating, and addicting learning for the love of learning can be. Another popular example of unschooling is Sugata Mitra’s 1999 Hole in the Wall experiment where a computer was placed in a kiosk in an Indian slum. Children were allowed to use it freely. The experiment successfully proved that children could learn to use computers without any formal training. This was extended to be a method called Minimally Invasive Education (MIE) where students were encouraged to learn what interests them without adult direction —  much as what is expected from unschooling.

(more…)

Every month, we’ll share five themed posters that you can share on your website (with attribution), post on your walls, or simply be inspired.

This month: Mouse Skills

–for the entire collection of 65 posters, click here

(more…)

Every month or so, we share themed posters you can re-share on your website (with attribution), post on your walls, or simply be inspired.

This month: Keyboarding

(more…)

I get a lot of questions from readers about what tech ed resources I use in my classroom so I’m going to take a few days this summer to review them with you. Some are edited and/or written by members of the Ask a Tech Teacher crew. Others, by tech teachers who work with the same publisher I do. All of them, I’ve found well-suited to the task of scaling and differentiating tech skills for age groups, scaffolding learning year-to-year, taking into account the perspectives and norms of all stakeholders, with appropriate metrics to know learning is organic and granular.

Today: Classes

Ask a Tech Teacher offers a variety of classes throughout the year. These can be taught individually (through coaching or mentoring), in small groups (of at least five), or as school PD. Some are for certificates; others for college credit. All are online, hands-on, with an authentic use of tools you’ll want for your class.

Click the course titles for more information.

The Tech-infused Teacher

Certificate

Group enrollment

The 21^st Century teacher blends technology with teaching to build a collaborative, differentiated, and shared learning environment. In this course, you will use a suite of digital tools while addressing overarching concepts like digital citizenship, internet search and research, authentic assessment, digital publishing, and immersive keyboarding. You will actively collaborate, share knowledge, provide constructive feedback to classmates, publish digitally, and differentiate for unique needs. Classmates will become the core of your ongoing Personal Learning Network.

Assessment is project-based so be prepared to be fully-involved and an eager risk-taker.

(more…)

I published this about a year ago and have updated it to reflect our current teaching environment. Let me know if this fits your experiences:

The biggest reason teachers report for NOT liking internet-based cloud accounts has nothing to do with money, security, or privacy. It’s that they aren’t inclusive enough. Students can’t access cloud storage, Google Classroom, or their LMS for a project they’re working on because of the lack of Internet at home or slow internet service–or a teacher can’t get to lesson plan resources  because of dead spot in the school or overload, the excitement of learning melts away like ice cream on a hot day.

That’s why no matter how good webtools sound, I won’t install them if they’re problematic–for example, they are slow to load, the website is unreliable, or saving is an issue. The most dependable method of accessing resources is through programs preloaded onto the local computer or available as PDFs that are easily shared.

I get it. Schools have moved many of their educational resources to the cloud. This might be to save money on maintenance or to make them accessible from anywhere or any number of other great reasons, but the change results in the problems I’ve mentioned. Too often and annoyingly That has spawned a rebirth in the popularity of Portable Document Formatted books and resources, commonly referred to as PDFs. While not perfect for every situation, they are exactly the right answer for many.

Here are ten reasons to consider when evaluating PDF vs. cloud-based resources:

PDFs play well with others

PDFs work on all digital devices, all platforms. No worries about whether they run better in Firefox or Chrome, Macs or PCs (or Chromebooks or iPads), Windows or MacOS (or Linux or iOS). They work on all of these and most others. With a free PDF reader (like Adobe or many others–check this link for ideas), students can open a document and get started right away. Even if they’re school system is a Mac and their home is a PC, the PDF opens fine.

(more…)

Hello! Ask a Tech Teacher is a group of tech ed professionals who work together to offer you tech tips, advice, pedagogic discussion, lesson plans, and anything else we can think of to help you integrate tech into your classroom. Our primary focus is to provide technology-in-education-related information for educators–teachers, administrators, homeschoolers, and parents.

Here’s how to get started on our blog (or click this link):

Read our varied columns

They include:

• Tech tips
• How-to’s–how to use web tools, software, hardware, more
• Dear Otto–questions from educators on tech questions
• Pedagogy that impacts tech in ed
• Reviews of books, apps, web tools, websites, tech ed products used in your classroom
• Subscriber Specials–monthly discounts (or FREE) on tech ed products
• Humorous life of a tech teacher

Read Hall of Fame articles

(more…)

I update these suggestions every few years to remind teachers there are easy ways to techify your lessons even on a tight schedule. I’d love to hear your suggestions in the comments about how you do this in your classes:

***

Because I teach graduate classes for educators, I talk to lots of teachers all over the country. It’s become clear that for most of them, adding technology to their lessons means layering more work on top of their already overburdened lesson plans. Despite the claims of tech gurus that technology makes the job of teaching easier, few educators see it that way. Even the ones who love it put in lots of extra time to do one or more of the following:

• learn tech tools and then teach their students
• learn tech tools only to discover it’s not what they need
• learn a tech tool they love only to have it either disappear or switch to a fee-based program
• rework existing lesson plans in the school’s mandated digital program that too often, changes every year. This means they have to re-enter the lesson plan in a new format for a new LMS
• find a tool they love, but no one else in their teaching team agrees, understands it, or cares
• the tool won’t work on the Big Day of the lesson and nothing will bring it back to life
• the digital devices–computer or Chromebooks or iPads–won’t work on the Big Day

(more…)