Educational Technology

Don Burnett, Microsoft MVP

“It’s All Good!”

I am grateful for the opportunity to work with Don Burnett, Microsoft MVP. Don Burnet enjoyed designing lessons for our Connected Car Advanced Transportation courses.  He shared his knowledge generously with both hands.

The list of programs and architecture that Don mastered in his 20+ years experience is dazzling. I added up all of the lessons I would have to take to learn and calculated that I would need two or three lifetimes to catch up with Don Burnett!

Donald Burnett, you will be missed!

From Don Burnett’s internet profile: https://www.linkedin.com/in/donburnett/

  • Solid understanding of the benefits and limitations of Internet technologies (Silverlight, Flash, XAML, CSS, XHTML, HTML 5) and Windows Managed C++ and ..NET. Experience leading creative teams, managing resources, mentoring designers and developers. Team player with excellent organization, communication and presentation.
  • User Centric Experience Design
  • Real-time Persona Mapping for UX and UI Design (XAML/HTML 5)
  • Social Networking and Social Branding
  • Experience leading the design and development of Flash projects.
  • Sound Design
  • Art Direction for photography and video, and animation (CD/DVD)
  • Programming WPF/Silverlight in C#
  • Designing and programming Silverlight in C# for Windows Phone
  • Designing and programming iPhone and iPad
  • Multi-touch UX Design and Development with WPF 4, and Microsoft Surface
  • Windows Azure Cloud Application Development
  • Xamarin Development (iOS, Android, Linux, Mac, Windows Universal Apps)
  • Unity 3D Development
  • Blend and Visual Studio
  • .NET Bot Framework Programming and Development
  •  Azure and .NET Bot Networking and Azure Cognitive Services


Specialties: Telecom, games development, marketing, brand creation, web development, DVD authoring, UI Design , Fluent in Rich Internet App Design. Experience leading Flash and XAML projects. Sound Design, Art Direction for video and animation. Multi-touch applications with Pixel Sense and WPF/UAP, Silverlight and Windows Azure cloud development. Application creation for iOS, Windows

Phone and Kinect and IoT (including Raspberry PI) Skills

 

Visual Studio, ASP.NET, XHTML, CSS, XML, XAML, HTML, C#, WEB API development, Dreamweaver, Flash, Project, MS-Office , Blend for Visual Studio, NODE.JS

  • Apache Storm and Hadoop
  • MSIL, Managed C++, PowerShell,
  • XSD, XPath, Regular Expression, JSON, XML, XAML
  • SPARQL, RDF, Open Graph
  • Hadoop, Apache Storm, U-SQL

SQL Server, Windows Server (all editions), IIS, .NET, iOS, Windows RT, Azure, Amazon, Photoshop, Illustrator, Flash , Fireworks, Dreamweaver, Maya, Blend For Visual Studio, Expression Encoder, Silverlight, Apple IB

Read more

Certification Training, Educational Technology, Microsoft Office Specialist, PowerPoint

Creating Videos with PowerPoint

Using Built-In Software

Microsoft PowerPoint has several options for sharing presentations including handouts and videos. The Microsoft video has good quality. However, the process is limited. In this process, all of the work must be correct before you click on the Export button.

Where Have We Seen This Before? Clicking PRINT does not make your document better. Keep going…

Camtasia Recording

Using Add-In Software: Camtasia

One of the really useful Add-In products for creating videos is Camtasia, by Tech Smith. It is a good video editor that works well with Microsoft PowerPoint. You can download a free 30-day demo version if you want to try it.  When you install Camtasia, several tools will be added to PowerPoint on the Add-Ins Ribbon.

Here is a video I posted on YouTube:  https://youtu.be/iscfDLCt_AQ Hello Camtasia

Cheers! eBeth

Read more

Certification Training, Microsoft Office Specialist, Outlook

You Are Invited

Microsoft Outlook: Using Tables to Format a Message

The first objective of an email campaign is to create brand awareness: “Who sent this message?” The design tools in Microsoft Outlook can generate effective messages. For example, your message can include pictures of products and Word documents that explain the features and benefits. The second objective is to invite the recipient to act: “Click here to get started! “

This lesson will show how to create an email message that invites someone to take an online course.

Before You Begin: Microsoft Outlook is open

The steps show Microsoft Outlook 2016. The steps are the same in Outlook 2010 and 2013.

1. Try it: Create a New E-mail
Go to Home-> New-> New Email.
Enter your E-mail Address.
Enter the Subject: You Are Invited

Try This, Too: Confirm the Format
Go to Format Text ->Format->HTML.

Keep going…

Insert a Table

Tables are used to organize web page layout and content. It is a basic design concept. In Microsoft Word we have several lessons that demonstrate how to insert and format Tables.

You can use the same Table Tools to create an E-mail in Outlook. Here we go.

2. Try it: Insert a Table
The Email Message is open.
Go to Insert ->Tables->Table.
Select the Cells: 3 Columns by 2 Rows.

Keep going…

Hello, Table Tools

Tables are used to organize web page layout and content. It is a basic design concept. Microsoft Word has a good set of web page design tools. You can use the same Table Tools in Outlook. Here is a simple example.

3. Try it: Edit the Table Layout
Select the first row of the Table.
Go to Table Tools ->Layout->Merge.
Click on Merge Cells.

What Do You See? Cells A1:A3 were merged (combined) into one Cell.
Keep going…

Insert SmartArt
The Table can hold illustrations, text and links. This example will use SmartArt.

4. Try it: Insert SmartArt
The cursor is in Cell A1 of the table.
Go to Insert ->Illustrations->SmartArt.

What Do You See? You will be prompted to choose a SmartArt Graphic. On the left side is a list of categories.

Go to the Picture category.
Select Titled Picture Accent List.
Click OK.

Keep going…

Hello, SmartArt

The SmartArt Graphic will be placed in Cell A1 of the table. There are two SmartArt Tools: Design and Format. There are also two Table Tools: Design and Layout.

5. Try it: Edit the SmartArt
Enter the following text in the SmartArt:
Shape 1: Welcome to Microsoft Excel
Shape 2: Watch Online
Shape 3: Download the Book (PDF)

Keep going…

Add a Picture to the SmartArt

6. Try it: Add a Picture to the SmartArt
Click on Picture Placeholder 1.
Browse to the Documents folder.
Select a picture: phone
Click Insert.
The picture should fill the Shape.

Click on Picture Placeholder 2.
Browse to the Documents folder.
Select a picture: excel_course
Click Insert.
The picture should fill the second Shape.

This is getting interesting. Keep going…

Choose a Message Theme

7. Try it: Choose a Message Theme
Go to Options ->Themes.
Select a Theme: Slice.

What Do You See? The Theme formatted everything in the message including the Colors, Fonts and Effects of the Table and the SmartArt.

Not done, yet. Keep going…

Change the SmartArt Colors

In addition to the message Theme Colors, you can edit the SmartArt Colors as well.

Before You Begin: Find the SmartArt Tools

Select the SmartArt. The SmartArt Tools should be available.
The Design Ribbon has:
Create Graphic
Layouts
SmartArt Styles
Reset

8. Try it: Edit the SmartArt Design
Go to SmartArt Tools ->Design.
Go to SmartArt Styles->Change Colors.
Select: Colorful Range-Accent Colors 5-6

Try This, Too: Edit the SmartArt Style
Go to SmartArt Tools ->Design->SmartArt Styles.
Select a SmartArt Style: Cartoon.

Keep going…

Edit the Table Layout

Please edit the Table layout as follows.

9. Try it: Merge Table Cells
Select Cells B2:C2
Go to Table Tools ->Layout->Merge.
Click on Merge Cells.

What Do You See? The two cells were merged. This “super cell” will hold a picture and our marketing message.

Keep going…

Edit the Table Design

10. Try it: Format the Borders
Select the Table.
Go to Table Tools ->Design->Table Styles.
Go to Borders->No Border.

What Do You See? The Table is still there–holding the pictures, text and graphics–however the Table is hidden.

Add a Hyperlink

Try it: Select the SmartArt
Go to Insert->Links->Hyperlink
Enter the Address: www.thecomputermama.com
Click OK.

So, Did it Work? Send the email to yourself and see.

The email arrived in the Inbox. The message is colorful and inviting. The hyperlink takes someone to your website.

This email can be saved as Template and used as part of a Mail Merge with Microsoft Word. You can also program the Rules in Outlook to send this email automatically based on your key words or criteria.

I hope that I answered your question. I had fun writing this post.

eBeth

Elizabeth Nofs, the Computer Mama

Read more

Certification Training, Microsoft Office Specialist, Word

How Do You Compare Two Documents?

Microsoft Word: Review and Compare Documents

When many people work together, there may be problems with different versions of the same document as it is edited in different offices. How do you compare two documents? How do you combine different versions?

Before You Begin : Create Two Similar Files

This lesson works if you have two versions of the same document: the one you changed and the original report that you started with. In this example, several changes were made to the original report. The version with the changes is open.

Do This, First: Save the Changed File
Go to File-> Save As
Type a new file name: Charlotte Quarterly Report EAN, where EAN are your initials.

Do This: Open a Copy of the Original File
Go to File->Open.
Browse to the Documents folder.
Select: Charlotte Quarterly Report 2013.docx

1. Try it: Compare two documents
Go to Review ->Compare.
Click on Compare.

Keep going…

Compare and Merge

2. Try This: Select Two Documents

The process begins by selecting the two documents that you want to compare. Click on the yellow folder icon to browse and open the similar documents.

The original document is on the left. The revised document is on the right. You can label the changes with the name of the author if you wish.

Comparison Settings: You can Show or Hide the Comparison settings by clicking on the button that says: More or Less.

What Do You See? You have the option to show the changes in the Original document, a Revised document or a New document.

Select New Document.

Click OK. Keep going…

The Reviewer’s Desktop

3. Try This: Review the New Document
There should be a New document. It may have the name Compare Result 1.

What Do You See? On the left side of the screen is a summary of the revisions. There are 18 revisions in this example.

The Revisions Task Pane is similar to the Navigation Pane when you use Styles. You can use the items listed in the Revisions Pane to go to the matching sections in the new Compared Document.

The revisions are also linked to the same material in the Source documents on the right, so that you can see the information in context of the rest of the document.

Keep going…

Show Source Documents

At first, the screen may appear very busy. On the left you should see the Reviewing pane. You should see the original Source documents in little windows on the right side.

4. Try This: Show Source Documents
Go to Review->Compare.
Click on Show Source Documents.

What Do You See? You can Show or Hide the Source Documents as you compare the original and the revisions.

The options include:
Hide Source Document
Show Original
Show Revised
Show Both

Select: Hide Source Documents.

Keep going…

Track Changes

You can Track the changes in the new comparison document, “Compare Results,” if you wish. Here are the steps.

5. Try This: Track Changes
Go to Review-> Tracking.
Click on Track Changes.

What Do You See? In this example, the text has been deleted and new text added.

What Else Do You See? At the top of the Revisions Pane, there is an Update button. When you click on Update Revision Count, Word scans your document and counts the new revisions.

Keep going….

Review the Comments

6. Try This: Review the Comments
Go to Review-> Comments-> Next.

What Do You See? Everyone’s Comments are also listed in the Revisions Pane. You can use the Next and Previous Comments to skip to a specific part of the document.

Keep going…

Save the Revisions

Before You Begin: Accept (or Reject) the sample changes that you Tracked. Review the Comments and delete them.

When the review is done, please save a copy of this revised document.

7. Try This: Save Your Revisions
Go to File->Save.
Location: Documents
Name: Charlotte’s Quarterly Report Revised EAN, where EAN are your initials.

Done and Done. Please Close all documents.

Here is a video on YouTube that shows these steps and more:

https://youtu.be/sMmSLCXMV_A

So, Did it Work? These tools should be very useful as you compare and review your documents. Please let me know if I answered your question.

eBeth

Elizabeth Nofs, the Computer Mama

Buy the books at Amazon: https://thecomputermama.us/books-page/

Read more

Access, Certification Training, Microsoft Office Specialist

Lights, Camera, Action!

Microsoft Access Action Queries

Action Queries can change the data in the Tables. For example, an Update Query can find any movie released before the year 2000 and set the rental price (RentalPriceID). The other Action Queries include Append (add more Records), Delete (subtract Records), and Make Table (Copy the Records from a Query into a new Table.)

Deleting Data: Consider This!

1. Consider This: Should You Delete Data?

Deleting data is not a good idea in a relational database. When you create a Receipt in our database, you need information from five Tables. Consider this scenario.

Say you deleted the Movie, “Brave” from tblMovies. Say the Primary Key, MovieID, for this Movie was 407.

Now, you want to run a Report that looks up all of the Receipts. Any Receipt that had MovieID 407 will be incomplete. There is no data because that Key is missing.

This is not good.

2. The preferred method is to Archive a Record by marking it as Archived, Done or Obsolete.

Create a Make Table Query
The Archived Movies will be selected and copied into a new Table.

Create a Delete Query
The last Action Query deletes the Archived Movies from tblMovies.

Before You Begin: A sample database is open. This “Front Row Video” database has the following eight Tables: tblCustomers, tblGenre, tblMovieRented, tblMovies, tblMovieSearch, tblRating, tblReceipt and tblRentalPrices.

Select the Oldies

Create a Make Table Query that will mark all of the Movies released before 1990 as “Archived.” The best place to start is to make a Select Query and see if it finds the right Movies. When it works we’ll save the Select Query as an Make Table Query.

1. Try it: Create a Select Query

Go to Create ->Queries ->Query Design.
You will be prompted by the Show Table.
Select a Table: tblMovies.
Click Add and Close the Show/Table Window.

Try This, Too: Add Fields
Add these Fields to the QBE Grid:
MovieID, Movie, Year, Archived, Rating, Genre, Stars and RentalPriceID.

And This: Add a Criteria
Select a Field: Year.
Enter a Criteria: <1990

When you Run this Query you should find 73 movies that have our Criteria.

Keep going…

Copy to a New Table
A Make Table Query selects the Records that match the Criteria and copies those Records into a new Table.

4. Try it: Create a Make Table Query
The Query is still open.
Go to Query Tools ->Design->Query Type.
Select a Query Type: Make Table.

What Do You See? You will be prompted to name the new Table.
Enter the Table Name: tblArchiveMovies.
Click OK to Run the Make Table Query.

Do This, Now: Save the Make Table Query
Go to File->Save Object As.
Enter the name: ArchiveMovieMT,
where MT means this is a Make Table Query.
Keep going…

Review the Data
Did all of the Records get copied to the new Table when we ran the Make Table Query?

5. Try it: Review the Data
Go to All Access Objects->Tables.
Open a Table: tblArchivedMovies.

What Do You See? There should be 73 Records in tblArchivedMovies.
OK. Save and Close ArchiveMovieMT.

The Last Action Query

A Delete Query does exactly what the name spells out: It deletes data. As mentioned earlier, deleting data is not the best practice for a database administrator. However, this option may be better than marking bad records as archived.

The following example will use a copy of the Movie Table to test the Delete Query.

1. Try it: Create a New Select Query
Go to Create ->Queries ->Query Design.
You will be prompted by the Show Table.
Select a Table: Copy of tblMovies 04-16-2014.
Click Add and Close the Show/Table Window.

Try This, Too: Add Fields
Add these Fields to the QBE Grid: MovieID, Movie, Year, Rating, Genre, Stars and RentalPriceID.

And Try This: Add a Criteria
Select a Field: Year.
Enter a Criteria: <1990

Do This, Now: Run the Select Query
Did this Select Query select 73 Records?

Create the Delete Query
So the Select Query works. Now, you can change it into a Delete Query.

Before You Begin: Change the View
Go to Home ->Views->View.
Select a View: Design View.

2. Try it: Create a Delete Query
Go to Query Tools ->Design->Query Type.
Select a Query Type: Delete.

Try This, Too: Run the Delete Query
Go to Query Tools ->Design->Results-> Run.

What Do You See? You will be prompted that you are about to delete 73 Rows. You are also reminded that there is no UNDO. This is permanent data heaven.

Click Yes to delete the data from the Copy of tblMovies 4-16-2014, Table.
So, let’s go see what’s left in this Table.

Review the Data
3. Try it: Review the Data
Go to All Access Objects->Tables.
Open a Table:Copy of tblMovies 4-16-2014.

Try This, Too: Sort the Records
Select a Field
: Year.
Go to Home ->Sort & Filter->Ascending.

What Do You See? There were 420 Records in Copy of tblMovies 4-16-2014. The Delete Query deleted 73 movies, leaving 347.

The 73 movies were effectively deleted as promised.
Close the Copy of the Movies Table.

Do This, Now: Save the Delete Query
Go to File->Save.
Enter a name: DeleteArchiveMoviesDQ.
Close the Delete Query.

SUMMARY: We also created several Action Queries to simplify the task of archiving the old movies. The Action Queries included a Make Table Query, ArchiveMovieMT, to copy the Archived Records into a new Table: tblArchiveMovies. We also designed and tested a Delete Query: ArchiveMovieMT

I have a video on YouTube that shows these steps: https://youtu.be/BLwn4IxSoTo

You done good! Go get the cookies!

Please let me know if I answered your question.

eBeth
Elizabeth Nofs, the Computer Mama

Buy the books at Amazon: https://thecomputermama.us/books-page/

Please consider my course on UDEMY, The Beginning Guide to Microsoft Access. This course is free.

The Beginning Guide to Microsoft Access 2013 – Udemy

Read more

Certification Training, Microsoft Office Specialist, Word

Equations in Word

Hello, Equation Tools! At long last, Word has a whole Ribbon of Tools for writing and editing Equations. This post will introduce the new Ribbon.

Before You Begin: A new, blank document is open.

Insert Equations: Creating math symbols as you type is very useful. You can also insert and edit equations in Microsoft Word 2013.

1. Try This: Find the Equations
Go to Insert-> Symbols->Equation. Click on the drop-down arrow on the right.

What Do You See? There should be a list of equations including the Area of a Circle, Binomial Theorem and, yes indeed, it is the Pythagorean Theorem for triangles.

2. Try This, Too: Insert A New Equation
Go to Insert-> Symbols->Equation.
Click on Insert New Equation.
Click OK.

3. What Do You See? There should be a new Equation Block that you can edit.

What Else Do You See?The Equation Tools include: Tools Symbols Structures

4. Try This: Review the Equation Ribbon
Go to Equation Tools-> Design->Structures.

What Do You See? Many of the math and business symbols can be found in the Symbols.  The Structures enable you to document Fractions, Script, Radicals, Integrals, Bracket, Function, Accent, Limit and Log, Operator, and Matrix. Way cool new Ribbon.

Math AutoCorrect Options

Earlier, we reviewed the Math Equations. Many professions use mathematical symbols in reports and documentation. Prior to Microsoft Office 2007, you had to Insert a Symbol and select a letter from a set of Fonts named Dingbats or Symbols.

How Did We Get Here?

The Word Options are open. Proofing is selected. Go to the top of the Proofing page. Click AutoCorrect Options… Try it: Find the Math AutoCorrect Options  When the AutoCorrect window opens, select the Math AutoCorrect Tab.

 

Math AutoCorrect has an extensive list of text for math, chemistry and engineering. This list is adaptable, too. You can add or edit your own entries, same as with AutoCorrect.

Look for the check box to Use Math AutoCorrect outside of the math regions. This is an important option if you wish to type formulas and equations.

Extra Points if you can identify this math calculation tool, above

That’ll work. Good question. Thanks for asking.

eBeth

Elizabeth Nofs, the Computer Mama

Please evaluate my Courses: Visit our school at UDEMY

Buy the books at Amazon: https://thecomputermama.us/books-page/ 

Read more