DJ Dates


PowerPoint 2010 Tutorial 3.1. Animations and Transitions

File can be downloaded from http://djdates.com/2010animations.pptx

In this video:
Animations Ribbon
Animation Effects
Transitions Ribbon
Timings and Rehearsal
Animation Pane
Custom Animations

This video is a remake of a previous video that demonstrated animations and transitions in PowerPoint 2007. If you have PowerPoint 2007, you would be better off watching that previous video, as some of these ribbon options have changed significantly.


Access 2007 Tutorial 5.4. Inserting into multiple fields using a Combo box and NotInList Event

You can work along with this file:

Code can be found at the end of the post.

In this video:

  • On Not In List event
  • Variables & Constants
  • msgbox()
  • if-else statement
  • Arrays
  • Split()
  • DoCMD.RunSQL
  • UBound()
  • Remaining Issues

When I teach my Access course, I often get students who feel that entering information into the database should be easier than it is, even with forms. Well, we can make it easier, but it usually requires some programming to do some work on behalf of the user. The more work we do, the less work the user has to do.

Filed under: Access Continue reading

Moore’s Law as Illustrated using Blowtorches and Calculators

The $100 calculator from 1972 shown in this video would have actually cost the equivalent of $525 in 2010 dollars due to inflation.

This video is licensed under the creative commons BY-NC-SA license. Please feel free to use this video in your classroom.

In 1972, my dad bought this four function calculator for $100.

Today we can buy a little four function calculator with the same capabilities for just $1.

Moore’s Law is the adage that the number of transistors that can be put on a single microchip doubles every two years. Because computers are limited to a fraction of the speed of light, the smaller and denser we can make computer chips, the more powerful and capable computers can become. However, another benefit is that computers and digital devices continually get smaller and cheaper, like our calculator.


A Window into the Hard Drive

This video shows the inside of a hard drive during various operations, such as copying and deleting files, defragmentation, and formatting the drive. This video is licensed under the creative commons BY-NC-SA license. Please feel free to use this video in your classroom.

Before we get started with the hard drive, let’s identify the different parts. The shiny disc in the harddrive is called the platter. Instead of being made out of polycarbonate plastic like a CD or DVD, the hard drive platter is made out of metals such as nickel, cobalt, and chromium. Often, hard drives will have more than one platter, such as in this hard drive which has two platters stacked on top of each other. In the middle of the hard drive platter is the spindle. This hard drive rotates the platter at 5400 revolutions per minute. High performance hard drives may rotate at speeds up to 7200 or 10,000 RPM.


Database Literacy: Why use a database? (papercraft version)

Information is what we know about something.
Data is raw information that can be manipulated by a computer.
So a Database is a structured collection of information.

Files to print your own can be found here.


Database Literacy: Paper Data Models for One to Many and Many to Many relationships

I designed a pair of paper data models, pamphlets basically, to assist with teaching database concepts. The two paper data models use data about books and authors to demonstrate a flat file database, a one to many database relationship, and a many to many database relationship. These pamphlets are then used by students during class to recreate the same data models in Microsoft Access.

Files to print your own can be found here.