So many of our students only have a Chromebook to use at home. With this in mind, this is the first in a series where I walk students through using a Chromebook (or even the Chrome web browser on any supported computer) to design web pages using the Caret Chrome extension.
In this lesson, I’ll show you how to create 3D formulas in Excel. A 3D formula is one that uses cells from multiple sheets in its calculation.
Click here to download the project file used in this lesson.
In this video, you’ll learn how to remove duplicates from a list in Excel. Then, using the list of unique items, you will learn how to use COUNTIF() to count the number of times each item in the original list occurred.
Own Your Own: Click here to download a list of World Series Champions that you can use to practice using COUNTIF() independently. You can try to count how many times each team has won (or lost) the series or how many times a certain manager has won (or lost) the series using the same skills that were demonstrated in the walkthrough.
Here’s an old file management tutorial I made years ago. It is geared toward Windows Vista, but there is a glossary and exercises that still apply to any operating system. One day, I hope to get around to modernizing it.
This Excel Quickie assignment provides a good opportunity to learn about or practice using the COUNTIF() function in Excel. For information about the COUNTIF() function, you may want to visit Microsoft’s COUNTIF information page.
This is the first of my quickie assignments, which are meant to be short but very useful for teaching and reviewing valuable Excel skills. These assignments do not include step-by-step instructions. They are meant to be used as formative assessment or possibly as material for walking students through how to complete tasks.
Click here to download Smitty’s Restaurant Item Sales Summary. Student instructions are listed in the textbox contained in the sheet. Remember that there are other, much more advanced skills that could be taught with this simple dataset, so think about ways you can rework the instructions to better target whatever skill you are trying to teach.
In this video, you’ll learn how to easily create zip files in all versions of Windows since XP. Zip files are great for sending several files and/or folders as a single attachment. If that weren’t cool enough, zip files are smaller on the storage device than the sum of the files and folders they contain (through the magic of compression)!
In this video, you’ll be learning how to setup a paper in MLA format using Microsoft Word 2013. The spacing guidelines presented should conform to MLA 7th Edition, but you should always set things up how your professor wants (as some prefer older versions or variations of the standard).
The file used throughout this video can be found here: Sample MLA Paper (that’s formatted WRONG)
If you teach Desktop Publishing, you may find these projects useful. This material was some of the first I ever posted and shared with the world at large! I love teaching Desktop Publishing and my students love it too!
Formatting spreadsheets in Excel 2013 is easy! This video will show you some basic formatting techniques, including formatting dates with custom codes, Formatting as a Table, color fill, Merge and Center, and chart color themes.