Class 2/17

Today we completed an exercise in Excel reviewing a number of tasks related to modifying workbooks which you were instructed to read before class today. The exercise included the following tasks:

Modifying Workbooks
Insert worksheet
Rename worksheet
Change position of worksheet in a workbook
Hide and unhide worksheet
Copy worksheet
Change worksheet tab color
Delete worksheet

Independent Class Work for 2/17
Modifying Worksheets
Pages 141-143 with statement of importance
Route Volume Exercise page 143

Customizing Excel 2007
Pages 146-149
Route Volume Exercise page 149

Step By Step Excel 2007 Chapter Summaries

In class today we discussed the importance of understanding the concept behind the exercise.
Outside class work to be completed before class tomorrow

Setting Up a Workbook Introduction
Read the chapter introduction found on pages 133-136. Write a summary statement on the important ideas introduced.

Creating Workbooks
Read pages 136-137 and include a paragraph review/statement of importance/summary for each section/paragraph

Modifying Workbooks
Read pages 138-130 and include a paragraph review/statement of importance/summary for each section/paragraph

InfoSource Excel 2007 Level 1 & 2

There will be a total of eight grades issued for the InfoSource Excel 2007 activities completed in class which began last week.
1. Pre Test
2. Prescriptive Lessons Completed
3. Post Test with a score of 80% or higher
4. Completed Need to Review Lessons
Grades will be assigned for both Level 1 and Level 2. The lessons may be completed outside of class but all tests must be taken in class.

Apple's iPad

This week, Apple announced their newest product, the iPad. Using the link below, read about and watch the information Apple released regarding the iPad. As a new posting on your blog, write a review of the new product including the highlight features, the new additions, availability and purchase information. Explain what you feel the possible impact this product will have on technology, society, education, and you personally. Your response must be well structured.

http://news.zdnet.com/2422-19178_22-387489.html

Current News Event Take 2

Over the weekend, take a few minutes to watch or read the news! You will be posting a summary and statement of importance on your blog before class on Monday. The following items are required.
1. Type of media (newspaper, internet, television) - Tell me from where or which media you chose to get your information.
2. Name of source (El Paso Times, KVIA, CNN, MSNBC, The Wall Street Journal) - Which newspaper, what website, which station?
3. When - What day and time did you watch or read the news story?
4. Subject or Title - The title of the news article or news program. Stories should be related to Business, Economy, Politics, Education, Technology
5. Summary - Summarize the details in complete sentences.
6. Importance - How is the story important to you?

Excel Intro 2 Tasks 11-20

Enter Number
Exit Excel
Fill Series - Drag and Drop
Font Size
Fonts
Function - Autosum
Go To
Help - Display Help Contents
Help - Search
Modify Formula

Excel Intro 1 Tasks 1-10

1-10
Apply Style
AutoCorrect
Bold Cell Contents
Cell Formatting - Remove
Center Across Cells
Chart - Create
Clear Cells
Color Text
Copy Cells
Create New Workbook Blank

Current News Event

I look forward to reading your posts regarding the news story you watched last night. Knowing about and understanding the events that are happened within your community, city, state, country and global environment are important to your development as a successful individual.

Semester 2 MCAS Excel 2007 Game Plan

I enjoyed reading your ideas for the next 6 weeks. Since I reviewed your posting at school, I was not able to enter comments directly. Please make sure that if you have not published your post your do so before class.

MCAS Word 2007 Exam Review Final Task List

49. Scale image heights numerically

50. Identify different types of text boxes and insert them in the document

51. Delete breaks such as page breaks

52. Insert table of contents and update table of contents

53. Modify Autocorrect options for example ordinal numbers not formatted as superscript

54. Compare two documents and show changes

55. Protect the document including with and without passwords, and restrict access such as only allowing comments

56. Combine two documents into one new document

MCAS Word 2007 Exam Review

We will begin testing for the Word 2007 MCAS next week. With only 14 class periods until the end of the semester, we will need to be sure and stay on schedule. Each one of you will need to sign up for a testing time. You may only test during 2nd period with prior approval from your 2nd period teacher by email. Class periods will be extremely quiet as there is no talking allowed while other students are testing.

Today you will be allowed to work with each other and with any other resources however you are each required to complete the posting for today with the description of the following processes in Word 2007.

42. Insert special characters such as smiley faces without using the keyboard shortcuts

43. Adjust the height and width of an image to a specific size without using the resizing handles on the image

44. Recognize and apply styles to SmartArt graphics (familiarize your self with the different names of the styles)

45. Recognize and insert SmartArt graphics (familiarize your self with the different names of the SmartArt)

46. Vertically and horizontally flip images

47. Inspect the document

48. Remove personal information from document

11/10 & 11/11 Student Files, Instructions, Solution

Wow, the how to's are posted, thank you!

You and your partner started working on a student file with tasks 1-10 last week. You will be developing the same student file to allow tasks 11-25 to be completed on the same document. The completed document should included the following text in the name: Student File 11-25. In addition to the student file, you will also have Instructions 11-25 and Solutions 11-25. Remember to keep in mind that each task must be independent of the others, meaning that you can do one task without completing any of the other tasks. The process will more much quicker during the next two days than it did last week and your document will continue to develop.

Enjoy the challenge and get creative!

New Task Instructions

With your partners, describe how to complete your assigned tasks in a posting on your blogger website. The posting needs to concentrate on the general task and not the specific action. You should include proper terms and steps to complete the task in any general document. This posting is your and your classmates how to reference for the next tasks you will be working with in class over the next two days.

Plannning your day & the finished product

Those of you that planned for class yesterday seemed to use the time with your partners well with a couple of teams finishing up the project. Today is your final class day to complete the project in which you create the task to be completed in Word 2007 and provide the document file the will be used to complete the task. Please make sure that you create a copy of the file, work through your tasks, and correct any problems that may appear. You will be emailing three items today before the end of class 1. The 10 tasks or the assignment instructions 2. The file to complete the tasks or the student file 3. The completed file or the solution file.

10/6 Team Word Tasks Due

After working in class for two full days on the 17 tasks from chapter 1 and 2, the final product will be presented to the class as a whole on Tuesday. Please be prepared, there will not be time in class provided to complete the project. I look forward to view all the task "how to's" in each teams unique format.

9/30 Annoucing the Quick Reference Guide Project

As a team, you will be creating a Quick Reference guide of "HOW TO's" for the skills you and learned to complete in Word 2007.

The Quick Reference will be a colaborated effort and an on going project to review skills and solidify your ability to complete them accurately and quickly.

Each team will have four members and completed a total of 17 "HOW TO's" which will be added to the other three teams to complete the reference.

This reference will be shared and utilized inside the class and outside the class with other classes, students and staff.

9/30 Revising Text & Paragraphs in a Document

Complete the Revising Text and Paragraphs in a Document activity on page WD133.

12. Document properties Author-First and Last name, Title-Same as file name, Subject-BCIS II
14. DO NOT print, email the completed document with an appropriate subject line
15. & 16. Post your response using the RATS writing process on your blog with an appropriate title for the posting. DO NOT activate the services

Creating & Editing a Word 2007 Document

Word 2007 is full of new features that make it easier to create great looking documents. This week you have looked at the basics of formatting text, images and documents. Describe the skills and processes you have learned. How did you do it? Where did you go? What are the options? Why is the better?

Tuesday, October 22, 2009 - 1st Substitute

Continue working on Word 2007 file which we began in class yesterday starting on page WD22, skip pages WD44-47 (you do not have the file with the picture), continue again on page WD48, and finish on page WD52. Do not print the file, email the completed assignment to Mrs. Goeldner before the end of class.
Formatting Paragraphs and Characters in a Document
Enhancing the Page

Wednesday, September 2, 2009 - Intro to Parallels and Word 2007 Ribbon

Create a new post that discusses the changes in Microsoft Word 2007. Compare and contrast the elements of Office 2003 and those of Office 2007.