Week 14


5/8 Microsoft Office Tools 

Agenda:

Review last week (Google tools)

Survey results (below)

Presentation

Hands on practice

Homework:

Choose one Microsoft tool to use and create a file in the program.  Save.  Find it again by going to OneDrive.  Share with someone.  Maybe share so they can edit as well.  This is your chance to learn how to use Microsoft tools!

Check out the videos at the end of the lesson as well.

Recording:

Although Monday's class was a little confusing, I think we got it by Tuesday's.  View the recording here.   Lots of advantages to that student email account!

Results of survey:

Online Dating is a no go, but we do have some clear winners for our 5 topics.  We will remember your preferences for the upcoming fall semester, since some may not be taking the class in the summer.

Five classes which will be taught this summer:

Thanks to everyone who participated in this survey!  I value your responses.

What will we learn? 

Microsoft Office Tools Class Lesson.pdf

Finding your Microsoft 365 apps using your student email

NOTE:  Please ask me if you do not know your student email account.  I have most of them on my roster. 

To find your Microsoft 365 apps and email:

Use your student mail address and portal password to sign in:

Find your 365 account (free) using an Outlook account (not covered in class)

Go to:  outlook.live.com

Sign in with your outlook or live account and password

Click on the 9 squares to see all apps

Download the apps (not covered in class)

(Smartphone and tablets only)

Although you can download a number of apps from the Google Play store or the Apple app store, the only two you will need to get started is OneDrive and Office.   However, if you are looking for inspiration, you may want to download the individual apps (Word, PowerPoint, Excel).  In these cases, you will see more options for creating a document/spreadsheet/presentation.

Review your Microsoft Account

Looking at account

After signing in, click on your profile picture and then "My Microsoft Account".  Review categories

Outlook Email

Microsoft Outlook is an email program for Office 365.  If you have other outlook accounts (live.com, Hotmail.com) you might be familiar with it.  Also, when setting up student email, you may have decided to forward your email to a private address. Things to try with your Outlook Email account

Focused vs Other:  Outlook keeps your important email in the focused folder, and stores others (ads, updates, etc.) in the Other folder. 

Filter:  You can search for specific emails by using the filter tab.


Selecting an email will open it in a window to the right and provide some quick responses.

Clicking on an email will offer options including  delete, move to archive, flag or unflag, pin or unpin, snooze, or click on the 3 dots for more options.

Sweep:  Like filtering in Gmail.  Create a rule around the selected emails.

Rules:  Similar.  Create a rule for messages for this person.

The side menu shows quick links to send items and drafts.  You can also create folders or set up groups.

Create a folder.  Right click on an email and "copy to folder".

OneDrive:

OneDrive is Microsoft’s tool for saving and sharing files online. When you create a document in Word, or a spreadsheet in Excel, it is automatically saved in OneDrive.

To see your files, you need to sign into your Microsoft account. Click on the “sign in” tab in the upper right of the word window.

OneDrive allows you to access your files from any device, back up your files to the cloud and share files.

When using the online version of Office, you will only see the “save as” option. Saving is done automatically. You do have the option of downloading either as a word document, or a PDF or open office (ODT).

To open an existing document, click “open” and then click on the file you want to edit.

Remember: All of your Office online files are saved to your OneDrive by default!


When first logging into OneDrive on your student account, it will require some time (several minutes) to set up.  Be patient!  This is what you will see.

Still waiting...

Ready!

OneDrive in your student account

Using OneDrive:

While in Home, click on “new” and select one of the options. It will then open in that app. When you are done, it will be saved in your OneDrive account.

Click Upload to bring any of the files on your device to your OneDrive account. You can upload a file or a folder. It will be sent to My Files

Everything in your OneDrive is private. In order to make a file or folder public (accessible to anyone), you will use the share icon. Select the file or folder and click on either the box with the arrow (share) or the 3 dots (where you can choose the arrow). See next screen for instructions on sharing

When selecting a file in My files, you will have several different options. Selecting the file will provide some choices such as share, copy link, request files, sort and 3 dots. Clicking on the 3 dots provides more choices.

We will create a work with an online document in OneDrive.

Here is the document we have begun.

As we look at this document,  we will review the tools available in Word Online.

NOTE:  Options may be different if you are using a student account or your own free account.  

Using Word Online:

Overview:

Used to create documents, newsletters, resumes, etc.

Has templates or blank page

Ribbon:  top of screen has tabs (design, insert, home) and components of each tab (font, text)

Help box (Tell me what you want me to do) will do specific things (add page number)

Since you are in Word Online, all work is saved from when you begin.  You do not even have a save feature in file!

Hands on Task: Word 

You can create a new word document from OneDrive or from the Word app. Since we have created the folder in OneDrive, we will be going through OneDrive to add to our folder. 

1.  Go to the Files folder in OneDrive and click on the folder you just created (Gardening)

2.  Click on the plus sign and then Word Document

3.  Let’s name it!  Close the document, then click on the 3 dots next to the document name. Choose Rename and call it “winter gardening”.  Then tap on it to open it.

4.  Lots of options on this page.  From the top, they include: back arrow, undo, change font, view (mobile or print view), search, share.  From the bottom, they include:  bold, italics, underlined, color of font, more (see choices)

5.  When you click on the 3 dots (more), you also can see other option in the far left. Clicking on Home will give you other options, such as insert, draw, layout, review and view.

Hands on practice with Word tools: 

(You will have to agree for Office to access your camera, microphone and files).  Tap on the 3 dots, and then the Home button.  You will see other options.  Here is what they mean:

Insert:

Microphone:  You will see a microphone.  Tapping on it will allow you to speak instead of typing.  You will have to say things like period, exclamation mark, comma.  Try it!

Pictures:  Click on pictures to choose pictures from your device

Camera:  Click on the camera and take a picture.  It will be included on your document.

Others:  Click on them to try them out.

 Draw:

Click on start inking and draw away!

 Layout:

Adjust layout for margins, orientation, size, etc.

 Review:

Word count, comments or read aloud

 View:

Print, Mobile, rulers, etc.

When you have finished your document:

•It is automatically saved to your OneDrive, in the folder that you have created. 

•It can be found in OneDrive or when in Word

•To save on your device, click on File.  Choose Save as or Export.  Try exporting a document to a PowerPoint!


Note that clicking "save as" allows you to download as a Word document or a PDF.

PowerPoint Online:

Overview

PowerPoint is a presentation program that allows you to create dynamic slide presentations.  The presentations can include animation, narration, images, video and more. 

Used in education and the business world, it is helpful in visualizing information. 

Some creative things you can do with PowerPoint include creating a book or comic, creating a presentation for a party honoring someone, create a flyer, or use smart art to create a family tree.

We created a practice PowerPoint which we will work with

Here is a link to the PowerPoint

Things to try while in PowerPoint

Insert: Insert pictures, text, smart art, etc.

Draw:  You can draw on the slide using this tool using your mouse or your finger if you have a touch screen.

Design:  Change design template.  Click on the down arrow to see all options.  

Review:  Collaborators can add comments here. 

View:  Zoom in for a closer view. 

Share:  Either send the link to others to review or send directly to someone.  

Present:  Click to present.  You can also click on slide show and present from there. 

Viewing the presentation: Open in OneDrive but view in PowerPoint and use Slide Show to present.  Swipe left to advance slides and animation. 

 Excel Online:

Overview:

•         Spreadsheet program to store, organize and analyze information

•         Good for budgets, contact lists, household inventory, invoices and more.

•         It performs mathematical formulas (addition, multiplication, averages, etc.)

•         You work in units called “cells”.  These cells can be formatted for text, numbers, dates and more.

•         There are also automated tools as well. 

Additional Microsoft tools and apps

OneNote


OneNote is a digital notebook.  It is a tool that allows you to start on one device and continue on another. 



You can use your camera, your voice, your stylus (drawing by hand) and then store on the cloud under your Microsoft account.

It is used to capture, organize and share.


To Do Lists

As a student, you may have some tasks which need to be done.  To Do coordinates your tasks with your daily planner.  Here are some of the features:

My Day:  You can use My Day to focus on daily tasks.  You can add them directly to My Day or add tasks from other lists (which can be created by clicking on + New list on the left side).  The list resets every night to create a blank slate each day.  Tasks not completed will be saved to tasks list and included in suggestions for next day.  

You can add due dates and reminders, as well as steps, notes, tags and more.

Planner

Work with others by creating a plan.  

You can start with a blank plan or use templates for more sophisticated options. 

Resources

Microsoft Online support:  https://support.microsoft.com/en-us/office

An online tutorial at GCFLearnFree:  https://edu.gcfglobal.org/en/onedrive/


Word Online help

Website:  Support page for Word Online

Microsoft Edge

Website:  Support page for Microsoft Edge

Microsoft Outlook

Website:  Support page for Outlook

Microsoft OneNote

Website:  Support page for OneNote

Skype help

Website:  Support page for Skype

Windows 10

Website:  Support page for Windows 10

Video:

Beginners guide to Microsoft Office Apps

Video:

Beginners guide to Microsoft Word.  Remember  you can access it online for no cost, although not all features in the video will be available.

Video:

Beginners guide to Microsoft Excel

Video:

Beginners guide to Microsoft PowerPoint

Video:

Beginners Guide to OneDrive for Windows

Video:

Beginners guide to Microsoft OneNote