Thursday, Feburary 28, 2018

Today in class:

-- Please work silently and independently throughout the hour.

-- We will study the new Midterm Exam Study Guide on Quizlet for the first 10 minutes of class. 

-- Today's assignment must be handwritten on paper. Using the material we have studied this semester, please make up and write down 20 of your own fill-in the blank questions.  Number them 1 through 20. Then add 5 bonus questions, based on the research assignments we have done this semester. Number them 21 through 25. Be sure to include both the question and answer for all questions.

-- Today's assignment is due at the end of the hour, before leaving class today. Not turning it in before leaving will result in a grade of zero.

-- Once you have completed and turned in today's assignment, please study the Midterm Exam Study Guide on Quizlet for the remainder of the hour. The midterm exam will cover material from the beginning of this calendar year, and there will be a hands-on portion of the exam.

Wednesday, February 28, 2018

Today in class:

-- We will study vocabulary on Quizlet for the first ten minutes of class.

-- We will discuss the upcoming midterm exams, next Thursday and Friday, March 8-9. Odd hour tests will be on Thursday, and even hour tests will be on Friday. The test will be worth 20% of the nine weeks grade.

-- Then we will discuss sorting in Excel. Third hour did hands-on work with this yesterday. Fourth hour will do hands-on work with this today.

-- Then we will dicuss linking data in Excel, beginning by watching the following video:

Tuesday, February 27, 2018

Today in class:

-- We will study vocabulary on Quizlet for the first ten minutes of class.

-- Then we will discuss midterm exams, coming up March 6-8.

-- Then we will wrap up and turn in our Excel overtime project.

-- Then we will watch a video on sorting in Excel 2010:



-- Then we will do some hands-on work with sorting.

-- If time allows, we will also watch a video on using multiple worksheets in one workbook in Excel 2010. This will provide a helpful base of knowledge, as we moving into linking:

Monday, February 26, 2018

In class, we will:

-- Study vocabulary on Quizlet for the first ten minutes of class.

-- Review our new vocabulary.

-- Complete the Excel exercise on overtime.

-- Then, we will watch the following two videos on formatting in Excel:






Then we will do some hands-on practice formatting in Excel.

Friday, February 23, 2018

Today, in class:

-- We will study vocabulary on Quizlet for the first ten minutes of class.

-- We will take our vocabulary test that was postponed from Tuesday.

-- We will study our new vocabulary for ten minutes.

-- Then we will learn about using Skype for international educational collaboration.

-- Then for today's class assignment, please write down and turn in your top five choice for suggested class projects using Skype. Please be specific, for example, "Skype with a coder for MineCraft."

A Bit About Bitcoin

In the meantime . . .

Check out today's free classes on CreativeLive.com:  https://www.creativelive.com/onair?via=site-header_0.

No School Tomorrow

In the meantime . . .

Here's a great class to watch online for free today about using Adobe Illustrator to create digital artwork on CreativeLive.com . . .

Check here for other free classes online today:

https://www.creativelive.com/.

If you do not have Adobe Illustrator on your computer at home, you can download a free trial here:

https://www.adobe.com/products/illustrator/free-trial-download.html/.

Wednesday, February 21, 2018

No school today, due to incoming weather. 

Stay warm! Stay safe!

Tuesday, February 20, 2018

In class, we will:

-- Take a vocabulary test on Excel functions. (POSTPONED until Wednesday.)

-- Review our new vocabulary. Write the new vocabulary words and turn in for a grade. Written vocabulary must be turned in before leaving class today. There are 25 terms, most relatively brief.

-- After writing and turning in vocabulary, you may use the rest of the hour to study vocabulary on Quizlet silently. If there is talking, there will be an additional assignment. It will be homework to be turned in at the beginning of the hour tomorrow.

-- Tomorrow, we will watch the following two videos on formatting in Excel:





Then we will do some hands-on practice formatting in Excel.

Thursday, February 15, 2018

Today, in class:

-- We studied vocabulary on Quizlet for the first ten minutes.

-- We had a vocabulary pretest. Students scoring an A grade may take this grade and skip the vocabulary test Tuesday.

-- We played Quizlet Live to study vocabulary.

Wednesday, February 14, 2018

Today in class:

-- With many students out for singing Valentines, students in class reviewed, worked on homework, or played cards.

Tuesday, February 13, 2108

Today, in class:

-- We will study vocabulary on Quizlet for the first 10 minutes of class.

-- Then we will review yesterday's video on using the IF function to calculate overtime, this time following along and creating the same spreadsheet to calculate base pay and overtime.

-- Then we will do the individual assignment below using the IF function to calculate overtime. Please omit steps 1, 10, 11, 12, and 13. Please save using the naming convention firstnamelastnameactivityF60304.

Monday, February 12, 2018

Today, in class:

-- We will study vocabulary on Quizlet for the first 10 minutes of class.

-- Then we will have the vocabulary test on the 21 words in the Computer Applications II Microsoft Excel functions set.

-- Then we will go over this week's new vocabulary and what we will be covering in class this week.

-- Then we will discuss how to use the IF function to calculate overtime.

Friday, February 9, 2018

Today, in class:

-- We studied vocabulary on Quizlet for the first 10 minutes of class.

-- Then we researched technology stocks and added 5 to the Excel stock tracker spreadsheet, saved, and emailed in.

Thursday, February 8, 2018

Today, in class:

-- We will study vocabulary on Quizlet for the first 10 minutes of class.

-- We will review Monday's hand-on test results and go over the most commonly missed problems, with visual explanation on the display screen and hands-on practice.

-- We will view a video on using functions in Excel. We will then implement use of at least one function in our Excel stock tracker spreadsheets.

Wednesday, February 7, 2018

Today, in class:

-- We will study vocabulary on Quizlet for the first 10 minutes of class.

-- Then we will review the use of functions in Excel. 

-- Then we will add a new column to our Excel stock tracker worksheets to update them with today's price for each stock. Students who are out today on trips or for the blood drive may make this update tomorrow.

Tuesday, February 6, 2018

Today, in class:

-- We will study vocabulary for the first 10 minutes on Quizlet.

-- Then we will work on our research assignment from yesterday for the remainder of class. Please be sure your summary meets the 100-word minimum and email to me before the end of class (email address on the whiteboard).

-- If time allows, we will discuss your findings during the last 10 minutes of class.

Monday, February 5, 2018

Today, in class:

-- We will study vocabulary on Quizlet for the first 10 minutes.

-- We will have our hands-on skills test on Excel covering data input and formatting and use of basic functions.

-- Then we will do a research assignment on how kids learn code in other countries, especially Japan, China, South Korea, India, Italy, and England. Please write a 100-word minimum summary of your research in a Microsoft Word document to be emailed in tomorrow during class.

Friday, February 2, 2018

Please write and turn in the 35 new vocabulary terms on Excel functions posted this morning. They are due at the end of the hour. After turning those in, study vocabulary on Quizlet. 

If you are out of the room for part of the hour for pictures, turn in the portion you have completed at the end of the hour. Grades will be adjusted accordingly. No allowances will be made for talking instead of working in class.

Thursday, February 1, 2018

Today, in class:

-- We will have a hands-on skill-building exercise and practice test.

-- We will go over the practice test together, covering formatting, formulas, functions, and the formula to use for finding percentages.

-- We will discuss Monday's upcoming hands-on skills test. It will cover formatting and using basic and advanced formulas and the functions for SUM and AVERAGE.

-- We will discuss using formulas and functions in Excel. For review, the following two videos provide excellent explanations of applying the order of operations rules in formulas and using functions in Excel: