Feb 3 - 7
Monday (2/3) - Guest teacher today is Mr. Leroy. Please treat him well.
1. Complete the bowling warm-up and save to your Excel warm-ups document - I will go over & grade on Tuesday
2. Next, continue to work on and complete Step by Step #2 as well as complete the vocab in Quizlet (also graded Tuesday)
3. If you complete all of the above, then proceed to complete Job #3 (Higgs' Grades) in this document.
Tuesday (2/4) - Although today's lecture wasn't exactly the most exciting, we covered functions by thoroughly examining the bowling warm-up & step by step #2. A lot of information came your way.
In summary:
1. Functions are built-in formulas (words) that Excel uses to perform calculations.
2. You are responsible to know 7 functions and what they do:
Sum - add
Average - adds a range and divides by the number in the range
Max - results in the highest number in a range
Min - results in the lowest number in a range
Count - counts the cells with data (numbers) within a range
If/Then (conditional formatting) - when a condition is met, Excel formats a cell the way you tell it to
Median - returns the middle value of a range
3. You are also responsible for knowing the Order of Operations (Parenthesis, Exponents, Multiplication, Division, Addition, Subtraction) as well as the following operators and how to use them:
Add +
Subtract -
Multiply *
Divide /
Raise to a power ^
Calculate percent %
4. We looked at PIE charts and how to use them. A PIE chart represents "the whole" or 100% and is used when you are trying to show a percentage. To calculate percentage you divide the (PART/WHOLE)*100
5. Our second quiz was announced for FRIDAY February 7.
Wednesday (2/5) - Assignment today was called Test Scores. We went through it in its entirety and saved to the warm-ups file you have created.
Thursday (2/6) - we will work to organize our warm-ups which will be graded Friday. We will review Vocabulary & work on a review assignment of functions. Remember there is a quiz Friday. Assignment today was called Shopping Spree
Friday (2/7) - Excel Quiz 2. Start Battleship Game building.
1. Complete the bowling warm-up and save to your Excel warm-ups document - I will go over & grade on Tuesday
2. Next, continue to work on and complete Step by Step #2 as well as complete the vocab in Quizlet (also graded Tuesday)
3. If you complete all of the above, then proceed to complete Job #3 (Higgs' Grades) in this document.
Tuesday (2/4) - Although today's lecture wasn't exactly the most exciting, we covered functions by thoroughly examining the bowling warm-up & step by step #2. A lot of information came your way.
In summary:
1. Functions are built-in formulas (words) that Excel uses to perform calculations.
2. You are responsible to know 7 functions and what they do:
Sum - add
Average - adds a range and divides by the number in the range
Max - results in the highest number in a range
Min - results in the lowest number in a range
Count - counts the cells with data (numbers) within a range
If/Then (conditional formatting) - when a condition is met, Excel formats a cell the way you tell it to
Median - returns the middle value of a range
3. You are also responsible for knowing the Order of Operations (Parenthesis, Exponents, Multiplication, Division, Addition, Subtraction) as well as the following operators and how to use them:
Add +
Subtract -
Multiply *
Divide /
Raise to a power ^
Calculate percent %
4. We looked at PIE charts and how to use them. A PIE chart represents "the whole" or 100% and is used when you are trying to show a percentage. To calculate percentage you divide the (PART/WHOLE)*100
5. Our second quiz was announced for FRIDAY February 7.
Wednesday (2/5) - Assignment today was called Test Scores. We went through it in its entirety and saved to the warm-ups file you have created.
Thursday (2/6) - we will work to organize our warm-ups which will be graded Friday. We will review Vocabulary & work on a review assignment of functions. Remember there is a quiz Friday. Assignment today was called Shopping Spree
Friday (2/7) - Excel Quiz 2. Start Battleship Game building.
Feb 10 -14
Monday (2/10) - Combined into one workbook & graded all 6 warmups from the unit: CD Sales, Newspaper Route, Simply Shoes, Bowling Scores, Test Scores, Shopping Spree
Finished Battleship Boards
Started Woodbridge Furniture Assignment to refresh functions
Tuesday (2/11) - Played Battleship for Warm-Up
Finished & reviewed Woodbridge Furniture assignment
Started Interactive Crossword using Excel - you must have 10 words across & down
Announced final Excel unit quiz for THURSDAY (Yes this means the unit is OVER!)
Wednesday (2/12) - Mr. Leroy was our guest teacher today. Interactive Crossword Assignment work
Thursday (2/13) - Final Unit Assessment in Excel, worked on finishing Interactive Crossword Puzzle
Finished Battleship Boards
Started Woodbridge Furniture Assignment to refresh functions
Tuesday (2/11) - Played Battleship for Warm-Up
Finished & reviewed Woodbridge Furniture assignment
Started Interactive Crossword using Excel - you must have 10 words across & down
Announced final Excel unit quiz for THURSDAY (Yes this means the unit is OVER!)
Wednesday (2/12) - Mr. Leroy was our guest teacher today. Interactive Crossword Assignment work
Thursday (2/13) - Final Unit Assessment in Excel, worked on finishing Interactive Crossword Puzzle