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
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 formatting numbers in Excel.
-- Then we will discuss applying conditional formatting to numbers in Excel, beginning by watching the following video:
-- 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 formatting numbers in Excel.
-- Then we will discuss applying conditional formatting to numbers in Excel, beginning by watching the following video:
Tuesday, February 27, 2018
Tuesday, February 27, 2018
Today in class:
-- We will study vocabulary on Quizlet for the first ten minutes of class.
-- We will discuss midterm exams coming up March 6-8.
-- We will update our Excel stock trackers with current prices for our stocks.
-- We will update our Excel stock trackers using what we have learned so far.
-- Because we have been able to move through the formatting material a little more quickly than expected (Nice job!), we will also view an introductory video on sorting in Excel 2010:
-- Then we will sort the stocks in our stock tracker alphabetically, using what we have learned.
-- We will study vocabulary on Quizlet for the first ten minutes of class.
-- We will discuss midterm exams coming up March 6-8.
-- We will update our Excel stock trackers with current prices for our stocks.
-- We will update our Excel stock trackers using what we have learned so far.
-- Because we have been able to move through the formatting material a little more quickly than expected (Nice job!), we will also view an introductory video on sorting in Excel 2010:
-- Then we will sort the stocks in our stock tracker alphabetically, using what we have learned.
Monday, February 26, 2018
Monday, February 26, 2018
In class, we will:
-- Study vocabulary on Quizlet for the first 10 minutes.
-- Discuss our new vocabulary.
-- Watch the following video on formatting in Excel:
Then we will do some hands-on practice formatting in Excel.
-- Study vocabulary on Quizlet for the first 10 minutes.
-- Discuss our new vocabulary.
-- Watch the following video on formatting in Excel:
Then we will do some hands-on practice formatting in Excel.
Friday, February 23, 2018
Friday, February 23, 2018
Today, in class:
-- We will study vocabulary on Quizlet for the first ten minutes of class.
-- We will take our second vocabulary test on Excel functions.
-- 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."
-- We will study vocabulary on Quizlet for the first ten minutes of class.
-- We will take our second vocabulary test on Excel functions.
-- 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."
Thursday, February 22, 2018
In the meantime . . .
Check out today's free classes on CreativeLive.com: https://www.creativelive.com/onair?via=site-header_0.
Wednesday, February 21, 2018
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/.
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/.
Sunday, February 18, 2018
Tuesday, Friday 20, 2018
In class, we will:
-- Take a vocabulary test on Excel functions. (POSTPONED until Wednesday.)
-- Review our new vocabulary -- Computer Applications I -- Excel Formatting Vocabulary. There are 10 terms. They are to be written and turned in before leaving class today.
-- After turning in your written vocabulary, you may 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 a video on formatting in Excel:
Then we will do some hands-on practice formatting in Excel.
-- Take a vocabulary test on Excel functions. (POSTPONED until Wednesday.)
-- Review our new vocabulary -- Computer Applications I -- Excel Formatting Vocabulary. There are 10 terms. They are to be written and turned in before leaving class today.
-- After turning in your written vocabulary, you may 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 a video 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 took a vocabulary pretest. Those scoring an A grade may take this grade as their test grade and skip the vocabulary test on Tuesday.
-- We discussed MIN, MAX, and COUNT functions and implemented them in our Excel stock tracker spreadsheets.
-- We studied vocabulary on Quizlet for the first ten minutes.
-- We took a vocabulary pretest. Those scoring an A grade may take this grade as their test grade and skip the vocabulary test on Tuesday.
-- We discussed MIN, MAX, and COUNT functions and implemented them in our Excel stock tracker spreadsheets.
Tuesday, February 13, 2018
Wednesday, February 14, 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.
-- 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.
Tuesday, February 13, 2018
Today, in class:
-- We will study vocabulary on Quizlet for the first 10 minutes of class.
-- We will review the use of the SUM and AVERAGE functions.
-- Then we will use the SUM and AVERAGE functions to add calculations for average stock price, total investment, and average number of shares to our excel stock tracker spreadsheets.
-- Tomorrow we will discuss and add use of the MIN and MAX functions.
-- We will study vocabulary on Quizlet for the first 10 minutes of class.
-- We will review the use of the SUM and AVERAGE functions.
-- Then we will use the SUM and AVERAGE functions to add calculations for average stock price, total investment, and average number of shares to our excel stock tracker spreadsheets.
-- Tomorrow we will discuss and add use of the MIN and MAX functions.
Sunday, February 11, 2018
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 10 words in the Microsoft Excel functions, set 1.
-- Then we will go over this week's new vocabulary and what we will be covering in class this week.
-- Then we will discuss and practice using the AVERAGE function in Excel.
-- We will study vocabulary on Quizlet for the first 10 minutes of class.
-- Then we will have the vocabulary test on the 10 words in the Microsoft Excel functions, set 1.
-- Then we will go over this week's new vocabulary and what we will be covering in class this week.
-- Then we will discuss and practice using the AVERAGE function in Excel.
Thursday, February 8, 2018
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 also review portions of the videos on using basic formulas in Excel and using basic functions in Excel.
-- Then we will do a practice vocabulary test and review the results.
-- 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 also review portions of the videos on using basic formulas in Excel and using basic functions in Excel.
-- Then we will do a practice vocabulary test and review the results.
Wednesday, February 7, 2018
Wednesday, February 7, 2018
Today, in class:
-- We will study vocabulary on Quizlet for the first 10 minutes of class.
-- Then we will discuss use of basic and advanced formulas in Excel, reviewing formulas for sum, average, and percentage. We will also discuss order of operations (PEMDAS) and the memory aid "Please Excuse My Dear Aunt Sally."
-- 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.
-- We will study vocabulary on Quizlet for the first 10 minutes of class.
-- Then we will discuss use of basic and advanced formulas in Excel, reviewing formulas for sum, average, and percentage. We will also discuss order of operations (PEMDAS) and the memory aid "Please Excuse My Dear Aunt Sally."
-- 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
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.
-- 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
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 basic formatting and use of simple formulas.
-- 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.
-- 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 basic formatting and use of simple formulas.
-- 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
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
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 the function for SUM.
-- We will discuss using formulas and functions in Excel. The following two videos provide excellent explanations of applying the order of operations rules in formulas and using functions in Excel:
-- 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 the function for SUM.
-- We will discuss using formulas and functions in Excel. The following two videos provide excellent explanations of applying the order of operations rules in formulas and using functions in Excel:
Subscribe to:
Posts (Atom)
-
Today in class: -- Please study Quizlet for the first 10 minutes of class. -- Then we will have a worksheet to complete. Please work qui...
-
Here's a great class to watch online for free today about using Adobe Illustrator to create digital artwork on CreativeLive.com . . . ...
-
Just a few of the incredible technology products you said were your favorites from CES 2017: Motiv Ring Rotex Electronic Tattoo ...