Office Tech - Lesson-10
Welcome!
Now lets log-on to http://www.edutyping.com/ and get started.
1--In the upper-right corner of the screen, click on the orange/yellow button that says "STUDENT".
2--Enter the License ID - "lindho500"
3--Enter your Username .
4--Enter your Password
Weekly Progress: By the end of the week, you should be done with the 23rd activity (Z & Colon Keys) - due by end of the day on Friday.
MICROSOFT EXCEL #3 - It's PARTY TIME! (part-1)
For this project, we learn how to throw a party with Microsoft Excel. Check out the info sheet below for more details on what you need to do in order to plan your party.
Party Time - Project Info Sheet
Be sure to SAVE your work when finished. We will use this data in Lesson-10.
MICROSOFT EXCEL #3 - It's PARTY TIME! (part-2)
Now that we typed our list of guests and what treat they are going to bring to the party, it is time to make the invitations. But writing out invitations takes too long....if only there was a way to make just one invitation, personalize it to each guest, and send it automatically to all 10 guests! Wait a minute, there is!!! It's called a MAIL MERGE! Watch the short video below to see how it works.
Now it is time to Open MS Word. Create a new document and title it "Party Invitation--yourFIRSTlastNAME".
Using the techniques you just learned from the Mail merge Video above, create your party invitation. Be sure to use proper formatting, and include all of the merge fields. Please see the example below:
List of Names in MS Excel Invite in MS Word with Merge Fields
Invite in MS Word with Name Record - 1 Invite in MS Word with Name Record - 2
When you finish your invitation, please merge your records and fields into MS Word. Preview through your invitation to make sure that ALL 10 Records showed up correctly. If they did not, go back and make changes. Turn in the finished and merged files to Mr. P, as a SCREENSHOT of the invitation showing both merged and un-merged. (similar to what I did above) If you are not turning in two screen shots, one MS Word file, and one MS Excel file, then you are doing it wrong.
Project DEADLINE = Tuesday April 23, 2019.
ALL FINISHED?
THEN.....Check out these cool typing games to help you practice:
A Friendly Reminder......
About Microsoft Office and SAVING on a PC as opposed to Google Docs/Drive....
Organization and Folders are always a good idea
You have a Home Directory/Drive, known as your H: Drive
Your H: Drive starts with your last name or User ID
Your H: Drive is where we will save all of your work
You must SAVE your work, it will NOT automatically save for you
Microsoft Word is similar to Google Docs, but has many more features and advanced tools
You can upload files from your H: Drive to your Google Drive and you can download files from your Google Drive to your H: Drive. It works both ways
Don't forget to save. If you do forget, no crying or whining, simply re-do the work.
Homework = edutype if you are behind. Enjoy the rest of your day! Stay on-top of your deadlines!