Mr. Arnold, Mrs. Johnson & Mr. Muths Welcome! Check below for your daily assignment and/or data files. March 22, 2010 Unit 2 : Excel Lesson 5 Objective: Students will complete the step by steps beginning on page 315. Access the data files below.
March 5, 2010 Unit 2 : Excel Lesson 3 - Test Objective: Time to test your skills at formatting content. I am being nice today and letting you use the book to find your answers. Don't disappoint me by failing an OPEN BOOK test. Click Here to Access the Lesson 3 Test February 25, 2010 Unit 2: Excel Lesson 3 - House Hunting Part I: Before Lunch Objective: You are a realtor for NTG Properties. Your job is to find three clients a home that is affordable but not at the top of their budget. For each client you will find three home choices and calculate the monthly payment amount for both 15 and 30 year mortgages. Procedure: Create a new Excel file and create a table which includes a picture of the property, the sellers price, the total with interest (based on the buyers pre-approved interest rate) and the monthly payments for both 15 and 30 year mortgages. Client Information:
Students will go to HAR.com and search for properties. Save this assignment as NTG_properties.xlsx
February 23, 2010 Unit 2: Excel Lesson 3 - Practice It Activities Part I: Before Lunch Objective: Students will engage in active practice of formatting data and content conceptual applications by interfacing with the MS Excel program and completing the Practice It Activities beginning on page 275 and ending on page 279. Procedure: Open your text book to page 275 and complete the step by step activities which end at page 279. Students will Print each completed file. Part II: After Lunch Critical Thinking Activities. Objective: Students will engage in active practice of formatting data and content conceptual applications by interfacing with the MS Excel program and completing the Critical Thinking Activities 6 though 11 beginning on page 280 and ending on page 281. Procedure: Open your text book to page 280 and complete the Critical Thinking activities which end at page 281. Assignments: #6 - Create a Directory #7 - Format a Table #8 - Create a Backup Plan #9 - Create a Sales Worksheet #10 - Format a Sales Worksheet #11 - Design a Work Schedule Students will Print each completed file. February 22, 2010 Unit 2: Excel Lesson 3 - Format Data and Content Objective: Students will engage in active practice of formatting data and content conceptual applications by interfacing with the MS Excel program and completing the step by step exercises beginning on page 251 and ending on page 272. Procedure: Open your text book to page 251 and complete the step by step activities which end at page 272. Print the completed assignment and turn it in to Mr. Arnold. Be sure to include your name and date so you will receive credit for the work. Data Files: You will need these. Download them as needed.
February 19, 2010 Unit 2: Excel Project Buying a new car : Stephanie just landed a good job with an Accounting firm in downtown Houston with a starting salary of 46K annually. At the moment she is living with her parent's in Pearland, TX and would like to move closer to downtown houston but does not want to pay more than $1100 for rent per month. She also needs to buy a more dependable vehicle but first she must find a place to live, calculate her monthly expenses, and then buy a vehicle with the remainder of her budget. Stephanie has good credit and is pre-qualified for an interest rate of 6.25% (0.0625) Here is Stephanie's current Vehicle Use the following to help Stephanie solve her problem. Create an Excel Document that outlines Stepanie's annual budget. Salary: $46,000 Desired Rent: $1100 (includes utilities) Grocery Bill: $200 Cell Phone: $90 Student Loans: $150 Gas: $125 Spending Money : $200 Prequalified Interest rate of 6.25% (0.0625) Save the file as car_budget
February 18, 2010 Unit 2: Excel Project Buying a new car : Mr. Arnold's students need to buy themselves a new car to get themselves to work. After shopping around for new vehicles, students will create an Excel Workbook which breaks down the sale price, interest rate, and payment options over an extended period of time. However, due to poor fiscal choices, some students have bad credit and will pay a higher interest rate. Good Credit = 5.25% (.0525) Bad Credit = 11.65% (.1165) Example:
Let's say you're buying this expedition. It retails at $52,815 Extended Warranty costs $3875 Students will purchase 5 vehicles. In an Excel Workbook, calculate the total payments over 36, 48, 60, and 72 months. February 16, 2010 Unit 2: Excel Lesson 2 Test Lesson 2 Test : Students may access the test online and use the Excel program to find the appropriate answers. Students are encouraged to take as much time as necessary to complete the test. Remember to look at the word wall. Click Here for the Test:
February 8, 2010 Unit 2: Excel Lesson 2 How Excel Calculates: Excel Calculates the same way you do calculations in math class. Math follows certain rules to find the correct answer. The Order of Precedence states which part of the formula you calculate first. Some operations, such as multiplication, take precedence over others. Assignment Part 1: Before Lunch Problem: Use excel to calculate the cost for a movie, snacks, and bus fare. Movie Ticket: $8.50 Snacks: Popcorn - $3.50 Candy - $2.50 Soda - $3.75 Bus Fare - $3.50 (One Way) After you have calculated the initial cost of going to the movies, recalculate the cost using a coupon for $3 off the purchase of a movie ticket, and a round trip bus fare ($5.00) to the theater. When you are finished Print and turn in your work to Mr. Arnold. Include your name or it will be counted as a zero. Assignment Part 2: After Lunch Objective: Students will complete the Critical Thinking Activities 6, 7 and 8 on page 247. Language Objective: Students will read, comprehend and implement the directions with or without a partner. Assignment: Complete the Critical Thinking Activities 6, 7 and 8 on page 247. Save your files according to the directions. February 5, 2010 Unit 2: Excel Lesson 2 Objective: Students will complete the step by steps exercises on pages 228 through 240. Assignment: Complete the step by steps exercises on pages 228 through 240. You will need the following data files: February 4, 2010 Unit 2: Excel Lesson 2 Objective: Students will complete the vocabulary list on page 241 of the textbook. Students will also complete the review questions on page 241.Students will print out the vocabulary list and review questions and submit them to Mr. Arnold. Assignment: Complete the vocabulary and review questions on 241. Provide the Questions and Answers for numbers 1 through 10. Skip number six. Save As Lesson 2 Review. Print and turn in to Mr. Arnold. February 2, 2010 Unit 2: Excel Lesson 1 Test Click Here to Access Your Test Thursday, January 28, 2010 Microsoft Excel Lesson 1: Excel Basics Objective: Students will be introduced to the Excel workspace. Students will also utilize formulas to complete basic arithmetic functions as an exercise in retention. Assignment: Part 1: Students will complete the step-by-step exercises to familiarize themselves with the Excel environment. Start at page 205 - End at page 217 Part 2: Students will complete the you practice it exercises. Start at page 219 - End at page 223 Part 3: Download the invoice file and enter the appropriate data and formulas in the highlighted fields. Tuesday, January 26, 2010 Microsoft Excel Lesson 1: Excel Basics Objective: Students will be introduced to the Excel workspace. Students will also utilize formulas to complete basic arithmetic functions as an exercise in retention. Assignment: Students will complete the step-by-step exercises to familiarize themselves with the Excel environment. Start at page 205 End at page 217
Monday, January 25, 2010 Microsoft Excel Lesson 1: Excel Basics Objective: Students will be introduced to the Excel workspace. Students will also utilize formulas to complete basic arithmetic functions as an exercise in retention. Assignment: Students are to download the files below and apply appropriate formulas to solve math problems.
Student Resources Keyboarding Tutorial: Games After you have completed your assignment in class, try your hand at some of these games.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||
