Tuesday, March 27, 2018

Welcome back!

The Week 8 vocabulary words are listed on the Vocabulary page. Again this week, you may have some of them defined already. If you do, remember you can copy and past to this weeks list.

We are going over these terms in class, and you will need to define them. There is one word "Clipboard" that you will define and explain how to do the three words associated with it, (cut, copy, paste)

After working on your vocabulary, please go to the address that I sent you on Remind. You type in that address on your computer or use your phone to go straight to the address. Complete!

I have also added the vocabulary for Week 9. The week 9 vocabulary is a bit different. I want you to try to memorize the words, and know what the meaning is,  we will review them in class. You do NOT have to write them all out unless that helps you memorize. 

Again, we will go over the Week 9 list in class. Please try your best to memorize.

Tuesday, March 20, 2018

Happy Spring! March 20-22, 2018

Welcome Spring!

This week we are working on Excel!

The vocabulary words will be posted on the Vocabulary page... you may recognize some of them from previous vocabulary lessons...

Please copy and paste your definitions...making sure they are correct for use with computer and for Excel use.  You do not have to type in twice, but I do want you to have the definitions together this week.

The first lesson in Excel will be to open the program, making sure it is a blank spreadsheet.

This is going to be a  real, working budget. Tuesday, you will start the spreadsheet, having a heading, columns and rows denoting date, bills, and your actual budget.

DO NOT put any information, such as your full name, social security or any credit card numbers on this sheet... DO NOT!

I guard your flash drives, the same as I guard my own, but there is always the possibility of them being lost. NEVER put any critical, identifying information on your flash drive.


You will save your worksheet to the flash drive and turn in at the end of the period. Wednesday, you will have a list of bills that you owe, a list of money you have to use, and an idea of how much you need to save each month. You will add these to the Excel sheet

Wednesday, you will complete the spreadsheet, save it to your flash drive. Turn in.

Remember the tabs are essential in creating the worksheet. Using the Formula Tab, the 'Auto Sum' button is your  best friend!  We will add all of Column D and have the total at the end of the column, then total all of Column H at the end of the column.  Using Auto Sum, choose Sum from the dropdown box. This will automatically show the list of your column, click enter, it will automatically add the amounts. Do this for each of the columns of numbers.

in Column H, Row 10, you will use the formula =H?-D? and enter... in place of the ? you will add the row number.  This will give you the amount of your income minus your monthly bills. In this way, you will see if you have anything left over or if you are "in the red".

Remember we discussed using averaging for bills that vary from month to month. Showing this on the budget is a good idea, also showing the amounts that are static, ie. mortgage, homeowners insurance, car payments, car insurance, etc are a good idea.
You can choose cells that you want to add together, separate from the others and show them by using the formula  sum=(D?,D?) and enter, this will allow those two or three amounts to be added separate from the other rows to show how much you must have to be able to meet payments.



Thursday, we will have a short Quizziz over the vocabulary words that pertain to Excel.


Tuesday, March 6, 2018

March 6-8, 2018

Welcome to Week 5 of Basic Computer Literacy or the pre-MOS class.

This week we have a lot to get done!

First, start out by logging in to Typing.com using your user account and password that you have been given. This will facilitate keeping track of your WPM/Time/Accuracy. No more having to write down your times on paper!


Next,  is to open your PowerPoint2016 document, The one that is YOUR CHOICE.

You will add FOUR (4) new slides!

Slide 5: Add new picture, add caption underneath that describes the picture.  Add Transition to this slide.

Slide 6: Add new picture, add caption, add shapes behind the picture, Add transition.

Slide 7: Add a new picture, add caption, add THREE (3)  shapes behind picture, add ,music or some type of audio to this slide, it can be music or sound or a recording of a description of the picture.  Add animation to all three shapes. Add Transitions.

Slide 8: Closing- Write a paragraph about what you learned about the subject in your presentation, and what you learned making the presentation. Write something about how you could us PowerPoint to teach someone else about the subject of your presentation. Add three (3) shapes behind the text, use animation on all three shapes, add transition to this page.



Wednesday:  Open Your Choice PowerPoint2016 Document. 

Go to Transitions Tab> go to 'Advance Slide'

  • choose Setting:
    • After:
    • Set Timer for 8-10 seconds for pictures, 12 seconds for paragraphs, and 15 seconds for instructions.
    • Click on "On Mouse Click" box to deselect this option. 

Go to Slide Show Tab> Go to Set Up Slide Show.

  • choose Settings:
    • Browse at a Kiosk
    • Loop Continuously until 'Esc'
    • Use Timings if Present
    • Click OK.
    • Click on Tab "From Beginning"

Once everyone has set up the slide shows, move from computer to computer ***read below***, looking at each presentation.

**** When one presentation is finished, click ESC button. This will stop the slide show. 

GO TO Review Tab

  • Choose New Comment- A dialogue box will appear to the right side of slide. 
  • Type YOUR Name, DATE, and a COMMENT about the slide show.
  • Click Enter
  • Click on Slide Show Tab
  • Click on "From Beginning"
Go to next computer and watch that presentation, do the same as before...
You should have commented on every presentation




Next, on Wednesday, we will open the file on Vocabulary that you have been working on, adding Week 5 Vocabulary Words.