3/29 thru 4/1/10

Technology Career Week

This week we will be meeting in the auditorium to hear presentations from:
Monday: Texas State Technical College
Tuesday: Central Texas College
Wednesday: Army, Navy, Marines, and Air Force
Thursday: The Art Institute of Austin

You will have a daily participation grade for attending, and paying polite attention to the presenters. If you are unable to attend on a particular day, please research the presenting college or service, and write a one-half page essay over what types of technology programs they offer, and which careers would benefit from these programs. Print and turn in on my laptop.

3/26/10

Objective: The student applies spreadsheet technology (120.23.4)

Notice: All graded papers, which are not picked up today, will be trashed. Have a Happy Easter! :) He Lives!!!

Warm-up: Open Warm-up 3-4-10. Print and turn in on the laptop.

Lecture: Seating for Technology Career Week:

• Must be seated in assigned area, or you will counted absent.
• There will be some type of quiz.

Assignment:
1. Do Art Institutes flyer for Technology Career Week.
2. Take Spreadsheet unit test.
3. Do Star Dot-to-Dot.

3/25/10

Objective: The student applies spreadsheet technology (120.23.4)

Notices:

• Spreadsheet Test tomorrow
• Check your Grade Speed account for missing work
• No tutorials Friday
• Pick up all graded papers

Lecture: review cursors, charts/graphs, IF Function, absolute/relative references

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. Which chart/graph shows parts of the whole?
2. Which chart/graph shows changes over time?
3. Which chart/graph shows a comparison between data?

Assignment:
1. Do Assignment 9, Exercises 36, 37, & 38. Save into your network folder, but do not print.

3/24/10

Objective: The student applies spreadsheet technology (120.23.4)

Lecture: sort, advanced, auto_______, charts/graphs, printing charts, no black backgrounds, changing colors

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. Why do you have to select all the data when you are sorting?

Assignment:
1. Use this link to vote on your preferred days for Technology Career Week. Hopefully, it will work today!
2. Do Assignments M&M1 & M&M2. Be sure to put your name in the header. Format each assignment to print on one page, do print preview making sure all data shows, and, when perfect, print in color if you like. Turn in on my laptop.

3/23/10

Objective: The student applies spreadsheet technology (120.23.4)

Lecture: sorting, hide/show gridlines and row/column headings, hide/unhide, reordering columns & rows, Help, autosum

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. ________ in a spreadsheet are vertical (up & down).
2. ________ in a spreadsheet are horizontal (side to side).
3. What is a program that has rows and columns and allows users to store and calculate data?

Assignment:
1. Use this link to vote on your preferred days for Technology Career Week.
2. Open the Copying Formulas spreadsheet from the Assignments folder. Save it into your network folder. Follow the instructions on the spreadsheet. Raise your hand when finished.
3. Do Assignment 7, Exercises 27(28). Save correctly into network folder, but do not print.

3/22/10

Objective: The student applies spreadsheet technology (120.23.4)

Notice: Spreadsheet unit test on Friday.

Lecture: hide/show gridlines and row/column headings, hide/unhide, Help

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. The cell that has the bold outline around it is the __________ cell.
2. What allows the user to copy formulas across to other cells?
3. The ________ cursor and the cell handle allows you to copy a formula from one cell to those beside it.
4. What is the range?
5. Which cursor allows you to move the contents of the cell?

Assignment: Do Assignment 6, Exercises 22, 24, & 25. Save correctly into network folder, but do not print.

3/12/10

Objective: The student applies spreadsheet technology (120.23.4)

Notice: Have a Safe Spring Break!

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. You are looking for the total of cells A1 thru B18, what does the function look like?
2. What does the four-headed arrow cursor do?

Assignment: Ketchup Day!
1. From your desktop, open your student network folder. Check to see that all spreadsheet assignments 6, 7, 9, 10, 11, 12, 13, 15, 16, 18, 19 & 20 are located in your folder; if you save it anywhere else, I won't be able to see it/grade it. I have already graded 1-10; I won't be going back into the folder to look at these unless you request it (on paper slip, please).

3/11/10

Objective: The student applies spreadsheet technology (120.23.4)

Notice: Six days, including today, until end of grading period. Two days until Spring Break!

Lecture: Folders are graded only once per grading. If you were absent or attend tutorials to make up missing work, be sure to fill out the slip of paper that tells me to go back to your folder to grade the assignments; printing posters

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. In the function =SUM(A1:B8), what is the range?
2. If you were looking for the largest value in cells A3 thru Z1000, what would your function look like?
3. If you were looking for the smallest value in cells A3 thru Z1000, what would your function look like?
4. If you were looking for the average value in cells A3 thru Z1000, what would your function look like?

Assignment:
1. Do Assignment 6, Ex. 20. Print this one as directed (DO PRINT PREVIEW and make sure it fits only on ONE PAGE!)
2. Ketchup Day tomorrow; BYOFF!

3/10/10

Objective: The student applies spreadsheet technology (120.23.4)

Notice: Seven days, including today, until end of grading period. Three days until Spring Break!

Lecture: functions, range of cells, text wrapping, grading Ex. 1-5 instructions

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. What is the Order of Operations?

Assignment:
1. Open all 1 - 5 Exercises. Wait for grading instructions.
2. Do Assignment 5, Ex. 16, 18, 19.
3. Finish all previously assigned work.

3/9/10

Objective: The student applies spreadsheet technology (120.23.4)

Notice: Eight days, including today, until end of grading period. Four days until Spring Break!

Lecture: reviewing formulas, cell alignment, format for decimal places/dollar signs, percentages, Order of Operations

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. Check grade sheet printout. In a complete sentence with a complete idea, list all your missing assignments.

Assignment:
1. Open all 1 - 5 Exercises. Wait for grading instructions.
2. Do Assignment 4, Ex. 11, 12, 13, & 15. The instruction packets are located in the Assignment folder on your desktop. Do not print.

3/8/10

Objective: The student applies spreadsheet technology (120.23.4)

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. How is the active cell identified?
2. What is the intersection of a row and a column called?
3. When would ###### show up in a cell?

Assignment:
1. Do Assignment 3, Ex. 9 & 10. The instruction packets are located in the Assignment folder on your desktop. Do not print.

3/5/10

Objective: improve the touch-system skill using the keyboard and keypad to input data (120.23.3.b) ; The student applies spreadsheet technology (120.23.4)

Lecture: Adding & Deleting Rows & Columns; opening windows simultaneously;

Warm-up: Open Warm-up 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. When entering data in a spreadsheet, which key moves the active cell/cursor down into the next row?
2. When entering data in a spreadsheet, which key moves the active cell/cursor into the next column to the right?
3. What do all spreadsheet formulas start with?
4. What is the key combination that allows you to view all the formulas in your spreadsheet?

Assignment:
1. Finish Assignment 2, Docs 1-5. Due today. Do not print.
2. Do Assignment 3, Ex. 6 & 7. The instruction packets are located in the Assignment folder on your desktop. Do not print.

3/4/10

Objective: improve the touch-system skill using the keyboard and keypad to input data (120.23.3.b) ; The student applies spreadsheet technology (120.23.4)

Lecture: grade SSGP, formulas, show all formulas

Warmup: Open Warmup 2-19-10. Proofread, print, and turn in on my laptop.

Create a NEW Word document, name it Warmup 3-4-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. In a spreadsheet, what goes up and down, and is identified by letters?
2. In a spreadsheet, what goes across, and is identified by numbers?
3. Which cursor allows you to copy formulas across to adjacent cells?
4. What does a cell address consist of?
5. V____________ are numbers which can be added or subtracted.
6. L_____________ are, generally, words in a spreadsheet.
7. Which cursor allows you to select/highlight cells in a spreadsheet?

Assignment:
1. Self-check SSGP, print and turn in on laptop.
2. Do Assignment 2, Docs 1-5. Do not print.

3/3/10

Notice: TAKS Day!

Warmup: none today

Assignment:
1. Do 10 min. of your choice of Keypad drills.
2. Ketchup Day!

3/2/10

Objective: improve the touch-system skill using the keyboard and keypad to input data (120.23.3.b) ; The student applies spreadsheet technology (120.23.4)

Notice: TAKS testing tomorrow. There is no make-up for these tests; please be sure to attend! You may bring snacks which will be eaten at the designated time- as well as Water to drink. Seniors will report to school at 11:54.

Warmup: Open Warmup 2-19-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
1. What is the name of the new unit?
2. Which program will we be using to do spreadsheets?

Keypad Drills Assignment:
Go to www.freetypinggame.net, do your choice of Tests or Games for #25, Ten Key Lesson. Do not look at the keypad; key by touch! Continue to work on increasing speed and accuracy for 10- 15 min. Assessment will be based on following instructions and effort, not speed.

Lecture: Spreadsheet intro/Guided Practice (Do not Print, yet)

Assignment:
1. Finish SSGP

3/1/10

Objective: improve the touch-system skill using the keyboard and keypad to input data (120.23.3.b) ; The student applies spreadsheet technology (120.23.4)

Notice: new unit -- Spreadsheets

Warmup: Open Warmup 2-19-10. Using only complete sentences with complete ideas, answer the following questions. Delete the questions.
Answer any three of the following six questions; your choice.
1. What was the most interesting thing you learned during the Word Processing unit?
2. In terms of high school, what was the most useful thing you learned or did during the Word Processing unit?
3. In terms of preparation for college, what was the most useful thing you learned or did during the Word Processing unit?
4. In terms of preparation for a future career, what was the most useful thing you learned or did during the Word Processing unit?
5. What was your least favorite thing to do during the Word Processing unit?
6. What was the hardest thing to do during the Word Processing unit?
7. What did you feel the most/least successful doing in this unit?


Keypad Drills Assignment:

Do Keypad drills, Lessons 2-8. We will work on increasing speed and accuracy for 10- 15 min.

Lecture: Organizing Folders, Spreadsheet intro/Guided Practice (Do not Print, yet)