Thanks for being a great group of kids. I also teach Multimedia Technology, sign up, I would love to see you all again. Have a nice break.
Mrs. Gannon
Tuesday, December 15, 2009
Thursday, December 10, 2009
Practice Final Exam Excel
The Microsoft Word questions that you answered on Thursday were very difficult. I will show everyone on Monday how to complete the questions you were having trouble answering. Don't worry, once I demomstrate, you will see how easy the questions really are.
I scheduled the Practice Final Exam for Excel. I went through the entire exam and I got every question right and you should be able to also. Here are a few tips:
Question 1:
This is asking you to make the cell an absolute reference, remember, press f4 to make the cell an absolute reference.
Question 5:
Click the merge and center icon.
Question 7:
Press the delete button
Question 9:
Pick the finacial category and then scroll down to find PMT
Question 11:
Click the cut icon (it is a pair of scissors) that is location on the left of the ribbon.
Question 12:
Right mouse click and pick delete and then click ok to shift cells up.
Question 13:
Right mouse click and pick delete.
Question 20:
Click the format painter icon (it looks like a paint brush) that is located on the left of the ribbon.
Question 21:
Click the Layout Tab (underneath Chart Tools) and then click the down arrow by Data Labels. Choose More Data Labels Options. Place a check mark next to Value and uncheck the category name.
Question 22:
Click the Format Tab (underneath Chart Tools) and then click the more options arrow in the Shape styles group. A galley of all the different styles will appear and then pick the style that is in column 3 row 4.
Question 24:
Click the Autosum icon on the right side of the ribbon
Question 26:
Click the icon that looks like a dollar sign.
Question 29:
Click the icon located in the Alignment group that displays ab and an arrow. (That is the rotate text icon) Then pick Angle Counterclockwise.
Question 32:
Click right above row 1 on the area that looks like a white triangle.
Question 33:
Right underneath the autosum icon, there is an icon that looks like a blue arrow pointing down. (Fill series icon) Click on it and then click on Series, click Month.
Question 35:
Click the merge and center icon.
Question 39
Type =sum(hours)*sum(words)
I scheduled the Practice Final Exam for Excel. I went through the entire exam and I got every question right and you should be able to also. Here are a few tips:
Question 1:
This is asking you to make the cell an absolute reference, remember, press f4 to make the cell an absolute reference.
Question 5:
Click the merge and center icon.
Question 7:
Press the delete button
Question 9:
Pick the finacial category and then scroll down to find PMT
Question 11:
Click the cut icon (it is a pair of scissors) that is location on the left of the ribbon.
Question 12:
Right mouse click and pick delete and then click ok to shift cells up.
Question 13:
Right mouse click and pick delete.
Question 20:
Click the format painter icon (it looks like a paint brush) that is located on the left of the ribbon.
Question 21:
Click the Layout Tab (underneath Chart Tools) and then click the down arrow by Data Labels. Choose More Data Labels Options. Place a check mark next to Value and uncheck the category name.
Question 22:
Click the Format Tab (underneath Chart Tools) and then click the more options arrow in the Shape styles group. A galley of all the different styles will appear and then pick the style that is in column 3 row 4.
Question 24:
Click the Autosum icon on the right side of the ribbon
Question 26:
Click the icon that looks like a dollar sign.
Question 29:
Click the icon located in the Alignment group that displays ab and an arrow. (That is the rotate text icon) Then pick Angle Counterclockwise.
Question 32:
Click right above row 1 on the area that looks like a white triangle.
Question 33:
Right underneath the autosum icon, there is an icon that looks like a blue arrow pointing down. (Fill series icon) Click on it and then click on Series, click Month.
Question 35:
Click the merge and center icon.
Question 39
Type =sum(hours)*sum(words)
Practice Final Exam Word
Hello Computer Applications Students!
Today you will be taking the practice fianal exam for Word. Do the best that you can, you will be getting points for taking the exam. It is very hard, so you can work with the people around you to get all of the questions correct. I gave everyone 5 attempts to get the question right. If you do not finish the questions, you can finish them on Monday. There are also three questions that I will be deleting from the final exam. They are WD 1394, WD 1131, and WD 931.
On Friday, you will be taking a practice final exam for Excel.
Today you will be taking the practice fianal exam for Word. Do the best that you can, you will be getting points for taking the exam. It is very hard, so you can work with the people around you to get all of the questions correct. I gave everyone 5 attempts to get the question right. If you do not finish the questions, you can finish them on Monday. There are also three questions that I will be deleting from the final exam. They are WD 1394, WD 1131, and WD 931.
On Friday, you will be taking a practice final exam for Excel.
Thursday, December 3, 2009
Assignments for Chapter 4 Excel
Hello,
Today we will finish up the chapter so your assignments will be:
Apply your knowledge, page 323-325. There is a data file on the p:drive
Flash cards for Excel chapter 4. Remember type in 30.
Make sure you completed the training for Excel Chapter 4
Today we will finish up the chapter so your assignments will be:
Apply your knowledge, page 323-325. There is a data file on the p:drive
Flash cards for Excel chapter 4. Remember type in 30.
Make sure you completed the training for Excel Chapter 4
Tuesday, November 24, 2009
You will have a test tomorrow!!!!
Make sure you take the practice exam!!!
TaskName
Task Instruction
1.
Absolute Cell Address
With the cursor in the Formula Bar, press the F4 key so that the G3 cell reference becomes absolute $G$3. Then press ENTER.
2.
Add data labels
In the Labels group on the Chart Tools Layout tab on the Ribbon, click the Data Labels button. On the Data Labels menu, click Outside End to add data labels above each column in the chart.
3.
Align Cell Contents
Right align the contents of the range A13:A17 by clicking the Align Text Right button in the Alignment group on the Ribbon.
4.
Chart - Change Type
In the Type group on the Chart Tools Design tab on the Ribbon, click the Change Chart Type button to display the Change Chart Type dialog box. In the Column section of the Change Chart Type dialog box, click the 3-D Cone button. Click the OK button.
5.
Create formulas using the OR function
In the Insert Function dialog box, click the Or select a category: arrow, and click Logical. Then, in the Select a function: list, click OR, and click OK to open the Function Arguments dialog box.
6.
Cut Cells
Click the Cut button in the Clipboard group on the Ribbon to cut the contents of the Total Amount fields that are currently selected.
7.
Delete Cells
Select the range A13:C13, click the Delete arrow on the Ribbon, click Delete Cells, click OK.
8.
Delete Rows
In the Cells group on the Home tab, click the Delete arrow, and then click Delete Sheet Rows to delete the selected row from the worksheet.
9.
Fill Series - Drag and Drop
Fill the range A4:A19 by continuing the series started in the range A2:A3 by positioning the pointer over the fill handle and dragging down to cell A19 before releasing the mouse.
10.
Format - Copy
In the Clipboard group on the Ribbon, click the Format Painter button to copy the formatting of the selected cell.
11.
Format chart data labels
In the Labels group on the Chart Tools Layout tab, click the Data Labels button and then click More Data Label Options. In the Label Options section of the Format Data Labels dialog box, click the Value check box to select it, and click the Percentage check box to deselect it, then click Close.
12.
Format charts
Format the chart area of the New Sales 2010 chart with the Colored Fill - Accent 4 shape style.
13.
Format worksheet tabs
In the Cells group on the Ribbon, click the Format button, point to Tab Color, and click Orange under Standard Colors.
14.
Goal Seek
On the Data tab on the Ribbon, in the Data Tools group, click the What-If Analysis button and use the Goal Seek command to open the Goal Seek dialog box. Use the Goal Seek dialog box to change the value in cell B3 so that the result of the formula in cell H18 is $100,000.00 by typing $100,000.00 in the To value box and B3 in the By changing cell box. Click OK twice to start the analysis.
15.
Indent Cell Contents
In the Alignment group on the Home tab, click the Increase Indent button to increase the text indent of the selected cell.
16.
Insert Cells
Click the Insert arrow in the Cells group on the Ribbon, and then click the Insert Cells command to open the Insert dialog box. In the Insert dialog box, click OK to insert cells in the currently selected Dues Collected 2009 column (H) of the workbook, shifting the existing cells to the right.
17.
Insert Row
In the Cells group on the Ribbon, click the Insert arrow. Click Insert Sheet Rows.
18.
Italicize Cell Contents
In the Font group on the Ribbon, click the Italic button to apply the italic format to the text in cell A2.
19.
Move Cells
To move the contents of cell B9 to cell B10, point to the border of the selected cell B9. When the pointer becomes a move pointer, hold down the left mouse button, drag cell B9 to cell B10, and then release the mouse button.
20.
Number Format - Currency
Apply the Accounting number format to the values in the range E2:E20 by clicking the Accounting Number Format button in the Number group on the Ribbon.
21.
Panes - Freeze
On the View tab on the Ribbon, in the Window group, use the Freeze Panes button to freeze columns A and B in the worksheet so that they will remain visible when the worksheet is scrolled.
22.
Paste Cells
In the Clipboard group on the Ribbon, click the Paste button to paste the last item placed on the Clipboard into the selected range.
23.
Print a chart
To print the New Sales 2010 chart, click the Office button, click Print, and then click OK in the Print dialog box.
24.
Rotate and tilt a 3-D Pie chart
In the Background group on the Chart Tools Layout tab on the Ribbon, click the 3-D Rotation button. Click the up arrow in the X box twice to change the 3-D rotation for the X-axis to 20 degrees, then click the up arrow in the Y box once to set the 3-D rotation for the Y-axis to 40 degrees, and click Close.
25.
Rotate Text
Use the Orientation button in the Alignment group on the Home tab on the Ribbon to change the orientation of the text in the selected cells in the current workbook. Re-orient the text so that it rotates counterclockwise at a 45-degree angle.
26.
Series - Fill Cells
Click the Fill button arrow in the Editing group on the Ribbon and then click Series to open the Series dialog box. In the Series dialog box, click the Month radio button in the Date unit and then click OK to enter the remaining months of the year in the selected cells.
27.
Shading
Click the Fill Color button arrow in the Font group on the Ribbon to display the Fill Color palette. Click the No Fill button on the Fill Color palette to remove the fill from the title cell which is currently selected.
28.
Split a window into panes
Split the window into two horizontal panes so that the top pane's bottom row is row 19 by clicking the View tab, then clicking the Split button in the Window group.
29.
Underline Cell Contents
Click the Underline button in the Font group on the Ribbon to underline the selected cell.
30.
Undo
Click the Undo button on the Quick Access Toolbar to undo the most recent change.
31.
Zoom
Click the Zoom button in the Zoom group on the View tab on the Ribbon to open the Zoom dialog box. In the Zoom dialog box, click the 200% option button and then click OK to change the Zoom setting for the current worksheet to 200%
TaskName
Task Instruction
1.
Absolute Cell Address
With the cursor in the Formula Bar, press the F4 key so that the G3 cell reference becomes absolute $G$3. Then press ENTER.
2.
Add data labels
In the Labels group on the Chart Tools Layout tab on the Ribbon, click the Data Labels button. On the Data Labels menu, click Outside End to add data labels above each column in the chart.
3.
Align Cell Contents
Right align the contents of the range A13:A17 by clicking the Align Text Right button in the Alignment group on the Ribbon.
4.
Chart - Change Type
In the Type group on the Chart Tools Design tab on the Ribbon, click the Change Chart Type button to display the Change Chart Type dialog box. In the Column section of the Change Chart Type dialog box, click the 3-D Cone button. Click the OK button.
5.
Create formulas using the OR function
In the Insert Function dialog box, click the Or select a category: arrow, and click Logical. Then, in the Select a function: list, click OR, and click OK to open the Function Arguments dialog box.
6.
Cut Cells
Click the Cut button in the Clipboard group on the Ribbon to cut the contents of the Total Amount fields that are currently selected.
7.
Delete Cells
Select the range A13:C13, click the Delete arrow on the Ribbon, click Delete Cells, click OK.
8.
Delete Rows
In the Cells group on the Home tab, click the Delete arrow, and then click Delete Sheet Rows to delete the selected row from the worksheet.
9.
Fill Series - Drag and Drop
Fill the range A4:A19 by continuing the series started in the range A2:A3 by positioning the pointer over the fill handle and dragging down to cell A19 before releasing the mouse.
10.
Format - Copy
In the Clipboard group on the Ribbon, click the Format Painter button to copy the formatting of the selected cell.
11.
Format chart data labels
In the Labels group on the Chart Tools Layout tab, click the Data Labels button and then click More Data Label Options. In the Label Options section of the Format Data Labels dialog box, click the Value check box to select it, and click the Percentage check box to deselect it, then click Close.
12.
Format charts
Format the chart area of the New Sales 2010 chart with the Colored Fill - Accent 4 shape style.
13.
Format worksheet tabs
In the Cells group on the Ribbon, click the Format button, point to Tab Color, and click Orange under Standard Colors.
14.
Goal Seek
On the Data tab on the Ribbon, in the Data Tools group, click the What-If Analysis button and use the Goal Seek command to open the Goal Seek dialog box. Use the Goal Seek dialog box to change the value in cell B3 so that the result of the formula in cell H18 is $100,000.00 by typing $100,000.00 in the To value box and B3 in the By changing cell box. Click OK twice to start the analysis.
15.
Indent Cell Contents
In the Alignment group on the Home tab, click the Increase Indent button to increase the text indent of the selected cell.
16.
Insert Cells
Click the Insert arrow in the Cells group on the Ribbon, and then click the Insert Cells command to open the Insert dialog box. In the Insert dialog box, click OK to insert cells in the currently selected Dues Collected 2009 column (H) of the workbook, shifting the existing cells to the right.
17.
Insert Row
In the Cells group on the Ribbon, click the Insert arrow. Click Insert Sheet Rows.
18.
Italicize Cell Contents
In the Font group on the Ribbon, click the Italic button to apply the italic format to the text in cell A2.
19.
Move Cells
To move the contents of cell B9 to cell B10, point to the border of the selected cell B9. When the pointer becomes a move pointer, hold down the left mouse button, drag cell B9 to cell B10, and then release the mouse button.
20.
Number Format - Currency
Apply the Accounting number format to the values in the range E2:E20 by clicking the Accounting Number Format button in the Number group on the Ribbon.
21.
Panes - Freeze
On the View tab on the Ribbon, in the Window group, use the Freeze Panes button to freeze columns A and B in the worksheet so that they will remain visible when the worksheet is scrolled.
22.
Paste Cells
In the Clipboard group on the Ribbon, click the Paste button to paste the last item placed on the Clipboard into the selected range.
23.
Print a chart
To print the New Sales 2010 chart, click the Office button, click Print, and then click OK in the Print dialog box.
24.
Rotate and tilt a 3-D Pie chart
In the Background group on the Chart Tools Layout tab on the Ribbon, click the 3-D Rotation button. Click the up arrow in the X box twice to change the 3-D rotation for the X-axis to 20 degrees, then click the up arrow in the Y box once to set the 3-D rotation for the Y-axis to 40 degrees, and click Close.
25.
Rotate Text
Use the Orientation button in the Alignment group on the Home tab on the Ribbon to change the orientation of the text in the selected cells in the current workbook. Re-orient the text so that it rotates counterclockwise at a 45-degree angle.
26.
Series - Fill Cells
Click the Fill button arrow in the Editing group on the Ribbon and then click Series to open the Series dialog box. In the Series dialog box, click the Month radio button in the Date unit and then click OK to enter the remaining months of the year in the selected cells.
27.
Shading
Click the Fill Color button arrow in the Font group on the Ribbon to display the Fill Color palette. Click the No Fill button on the Fill Color palette to remove the fill from the title cell which is currently selected.
28.
Split a window into panes
Split the window into two horizontal panes so that the top pane's bottom row is row 19 by clicking the View tab, then clicking the Split button in the Window group.
29.
Underline Cell Contents
Click the Underline button in the Font group on the Ribbon to underline the selected cell.
30.
Undo
Click the Undo button on the Quick Access Toolbar to undo the most recent change.
31.
Zoom
Click the Zoom button in the Zoom group on the View tab on the Ribbon to open the Zoom dialog box. In the Zoom dialog box, click the 200% option button and then click OK to change the Zoom setting for the current worksheet to 200%
Monday, November 23, 2009
Points for Excel Chapter 3
You will be graded on the following:
- Training for Excel Chapter 3
- In class project
- Flashcards for Excel Chapter 3, you only have to do 30.
- In the Lab 1 for Excel Chapter 3. This will be completed with Sam.
Monday, November 16, 2009
Test today for Excel Chapter 2
Hello,
Yesterday I showed you what your exam will look like. If you do not finish the exam in class, you may either finish it at home or you will have 15 mins the next day. If you can't get it done in that amout of time, then you don't know the material. You will get 3 attempts to get the answer correct. Make sure you go back and review your training for this chapter.
Do not cheat! Be good for Mr. Saunders. Mr. Saunders will also write down the names of anyone that is talking during the exam, you will receive a zero. If you finish early go on and start the training for Excel Chapter 3. Make sure you use your headphones.
Yesterday I showed you what your exam will look like. If you do not finish the exam in class, you may either finish it at home or you will have 15 mins the next day. If you can't get it done in that amout of time, then you don't know the material. You will get 3 attempts to get the answer correct. Make sure you go back and review your training for this chapter.
Do not cheat! Be good for Mr. Saunders. Mr. Saunders will also write down the names of anyone that is talking during the exam, you will receive a zero. If you finish early go on and start the training for Excel Chapter 3. Make sure you use your headphones.
Friday, November 6, 2009
Calling all tech-savy girls!!!
We’re looking for young women with outstanding achievements and aspirations in computing and technology. Are you the future of technology?
What do winners receive?
Each qualified National winner receives:
» $500 in cash
» a laptop computer, provided by Bank of America
» a trip to attend the Bank of America Technology Showcase and Awards Ceremony, held in Charlotte, North Carolina on March 27, 2010
» an engraved award for both the student and the student’s school
Who is eligible?
» Applicants must be high-school level girls (grades 9-12).
» Applicants must reside in the United States of America.
» Applicants should have a demonstrated outstanding aptitude and interest in IT/computing, and demonstrated leadership ability.
» Applicants should have good academic history, typically a GPA of 3.0 or better.
» Applicants should have post-secondary education plans.
» Students from groups underrepresented in computing and current Juniors/Seniors are strongly encouraged to apply.
» Past applicants including semi-finalists are encouraged to apply, however, previous award-winners are not eligible to reapply or receive any awards.
» Relatives of employees or board members of NCWIT are prohibited from receiving the award.
Howdo Iapply?
Visit www.ncwit.org/award. Applications open on October 7, 2009 for the 2010 National award call. Applicants have until November 15, 2009 to complete their application. Email any questions to aspirations@ncwit.org.
Newthis year – Affiliate awards
There will be Affiliate Award programs in Illinois, Texas and Florida to recognize even more young women. The application period is the same and young women in those states will automatically be entered into both Affiliate and National competitions. Affiliate Award prize packages will vary. The Affiliate Awards are possible through a generous grant from the Motorola Foundation.
What do winners receive?
Each qualified National winner receives:
» $500 in cash
» a laptop computer, provided by Bank of America
» a trip to attend the Bank of America Technology Showcase and Awards Ceremony, held in Charlotte, North Carolina on March 27, 2010
» an engraved award for both the student and the student’s school
Who is eligible?
» Applicants must be high-school level girls (grades 9-12).
» Applicants must reside in the United States of America.
» Applicants should have a demonstrated outstanding aptitude and interest in IT/computing, and demonstrated leadership ability.
» Applicants should have good academic history, typically a GPA of 3.0 or better.
» Applicants should have post-secondary education plans.
» Students from groups underrepresented in computing and current Juniors/Seniors are strongly encouraged to apply.
» Past applicants including semi-finalists are encouraged to apply, however, previous award-winners are not eligible to reapply or receive any awards.
» Relatives of employees or board members of NCWIT are prohibited from receiving the award.
Howdo Iapply?
Visit www.ncwit.org/award. Applications open on October 7, 2009 for the 2010 National award call. Applicants have until November 15, 2009 to complete their application. Email any questions to aspirations@ncwit.org.
Newthis year – Affiliate awards
There will be Affiliate Award programs in Illinois, Texas and Florida to recognize even more young women. The application period is the same and young women in those states will automatically be entered into both Affiliate and National competitions. Affiliate Award prize packages will vary. The Affiliate Awards are possible through a generous grant from the Motorola Foundation.
Wednesday, November 4, 2009
Vouchers!
Even though all of the vouchers have been assigned, there are a number of FREE training resources available including:
Microsoft Digital Literacy (Basic Training)
http://www.microsoft.com/about/corporatecitizenship/citizenship/giving/programs/up/digitalliteracy/default.mspx
Microsoft Office 2003 - 2007 (Intermediate Training)
http://office.microsoft.com/en-us/training/default.aspx
Goodwill Community Foundation (Basic and Intermediate Training)
http://www.gcflearnfree.org/computer/
W3Schools.com (IT Professional Training)
http://www.aboutus.org/W3Schools.com
E-Learning Center (IT Professional Training)
http://www.e-learningcenter.com/free.htm
Illinois WorkNet (Job Search & Career Development)
http://www.illinoisworknet.com
Microsoft Digital Literacy (Basic Training)
http://www.microsoft.com/about/corporatecitizenship/citizenship/giving/programs/up/digitalliteracy/default.mspx
Microsoft Office 2003 - 2007 (Intermediate Training)
http://office.microsoft.com/en-us/training/default.aspx
Goodwill Community Foundation (Basic and Intermediate Training)
http://www.gcflearnfree.org/computer/
W3Schools.com (IT Professional Training)
http://www.aboutus.org/W3Schools.com
E-Learning Center (IT Professional Training)
http://www.e-learningcenter.com/free.htm
Illinois WorkNet (Job Search & Career Development)
http://www.illinoisworknet.com
Monday, November 2, 2009
Starting with Sam Assessment Software
Go to sam2007.course.com and save it in your favorites. Your username is your login name when you sign into the network at OLCHS. When you first sign in use the password, password1 and then you will be asked to change your password. Make sure you remember it!
Click on My Assigments, and then start the training for Excel Chapter 2.
Click on My Assigments, and then start the training for Excel Chapter 2.
Monday, October 26, 2009
Attention all Microsoft Cert. students
YOU MUST MAKE AN APPOINTMENT TO TAKE THE EXAM. THE CLOSEST LOCATION IS RICHARD DAILY COLLEGE. THE PHONE NUMBER TO CALL IS 773-838-7774.
REMEMBER YOU MUST TAKE THE EXAM BY THE 31ST OF THIS MONTH!!! MAKE SURE YOU ASK WHERE YOU NEED TO GO!
Richard J. Daley College
7500 South Pulaski Road,
Chicago Illinois 60652
Voice 773 838 7774
REMEMBER YOU MUST TAKE THE EXAM BY THE 31ST OF THIS MONTH!!! MAKE SURE YOU ASK WHERE YOU NEED TO GO!
Richard J. Daley College
7500 South Pulaski Road,
Chicago Illinois 60652
Voice 773 838 7774
Monday, October 19, 2009
Student Email!
Right now the link isn't working. I'm looking into this.
What are the student email addresses?:
The domain is 'students.olchs.org' and the mailbox names are the students' OLCHS network IDs (i.e. what they use to log into OLCHS computers), e.g., jtw444@students.olchs.org would be a complete email address.
How to access student email:
http://mail.google.com/a/students.olchs.org/
Logging in for the first time:
Student email mailbox names/user names are the students' OLCHS network IDs.
Student email account passwords are set to the students' student IDs. They will be forced to select a new password during their first login.
Your assignment for today is to research three different locations you would like to travel to one day. The reason for this is because you will be working on creating a travel newsletter and planning a 7-day trip. All documents that will be handed in must be in the form of a newsletter. Look back to chapter 6 if you don't remember how.
I need you to reply to this post for this assignment. Tell me about the three locations you picked. Also list at least five fun activites you can do while visiting that location. Remember, you must reply to this post to get credit for this assignment.
What are the student email addresses?:
The domain is 'students.olchs.org' and the mailbox names are the students' OLCHS network IDs (i.e. what they use to log into OLCHS computers), e.g., jtw444@students.olchs.org would be a complete email address.
How to access student email:
http://mail.google.com/a/students.olchs.org/
Logging in for the first time:
Student email mailbox names/user names are the students' OLCHS network IDs.
Student email account passwords are set to the students' student IDs. They will be forced to select a new password during their first login.
Your assignment for today is to research three different locations you would like to travel to one day. The reason for this is because you will be working on creating a travel newsletter and planning a 7-day trip. All documents that will be handed in must be in the form of a newsletter. Look back to chapter 6 if you don't remember how.
I need you to reply to this post for this assignment. Tell me about the three locations you picked. Also list at least five fun activites you can do while visiting that location. Remember, you must reply to this post to get credit for this assignment.
Wednesday, October 14, 2009
Updated Information about Certification Vouchers
EXAMINATION RESOURCESAll certification vouchers must be used by October 31, 2009. Lumity is a Certiport center that will provide FREE examinations through the end of the month. Please advise clients to contact Lumity at elevateamerica@lumity.org or 312-372-4872 x 119 to reserve a testing time within the next three weeks.
IMPORTANT NOTE: Before customers enter Elevate America vouchers, they will need to test their to computer system make sure it meets Microsoft's computer requirements. Computer MUST meet the requirements to take the online courses. Click here to scan your system.INSTRUCTIONS TO ENTER ACCESS CODES AND DOWNLOAD MICROSOFT ONLINE COURSES: Customers Log into their My Illinois workNet account to access vouchers numbers. Click here for step-by-step instructions on entering your online courses.If you find customers need Microsoft customer support, please contact the Microsoft Regional Support Center by phone at (800) 636-7544, or email e-learn@microsoft.com. More support information is available at the following website http://www.microsoft.com/learning/support/northamerica.mspx .
IMPORTANT NOTE: Before customers enter Elevate America vouchers, they will need to test their to computer system make sure it meets Microsoft's computer requirements. Computer MUST meet the requirements to take the online courses. Click here to scan your system.INSTRUCTIONS TO ENTER ACCESS CODES AND DOWNLOAD MICROSOFT ONLINE COURSES: Customers Log into their My Illinois workNet account to access vouchers numbers. Click here for step-by-step instructions on entering your online courses.If you find customers need Microsoft customer support, please contact the Microsoft Regional Support Center by phone at (800) 636-7544, or email e-learn@microsoft.com. More support information is available at the following website http://www.microsoft.com/learning/support/northamerica.mspx .
Tuesday, October 13, 2009
Sam Software!
We will be using a new program to help you learn Microsoft Office in a lot more detail. Click here for a look at the new program you will be using.
Vouchers have been assigned to you, follow these instructions!!!
Make sure you follow these directions!!!!!!!!
How Customers Receive Vouchers and Instructions
•Customers must log into their My Illinois workNet accountto access their vouchers, follow instructions, and link to online courses.
•The customers log into their My Illinois workNet account.
•They see a "Welcome to Microsoft Elevate America" message.
•They click on the message to view their vouchers, which are a series of 16 numbers and letters with dashes that a customer has to enter online to access their free:
•Microsoft online courses(sample voucher number 1234-ESIL1234-1234)
•Microsoft Business Certification Exams(sample voucher number ABCD-1AB2-1234-A1BC)
•They will also see printable instructions.
•They will see a link to their online courses.
the customer can immediately log in and see an Elevate America message on their home page.
•Step 1: Review theOnline Course login Instructions.
•Step 2: Verify that your computer meets minimum technical requirementsand that you havespeakers or headphones available to you (note: the Internet Explorer v. browser is required to access courses).
•Step 3: Click here to enter the access code included on the information sheet, setup an account, andbegin takingcourses.
How Customers Receive Vouchers and Instructions
•Customers must log into their My Illinois workNet accountto access their vouchers, follow instructions, and link to online courses.
•The customers log into their My Illinois workNet account.
•They see a "Welcome to Microsoft Elevate America" message.
•They click on the message to view their vouchers, which are a series of 16 numbers and letters with dashes that a customer has to enter online to access their free:
•Microsoft online courses(sample voucher number 1234-ESIL1234-1234)
•Microsoft Business Certification Exams(sample voucher number ABCD-1AB2-1234-A1BC)
•They will also see printable instructions.
•They will see a link to their online courses.
the customer can immediately log in and see an Elevate America message on their home page.
•Step 1: Review theOnline Course login Instructions.
•Step 2: Verify that your computer meets minimum technical requirementsand that you havespeakers or headphones available to you (note: the Internet Explorer v. browser is required to access courses).
•Step 3: Click here to enter the access code included on the information sheet, setup an account, andbegin takingcourses.
Thursday, October 8, 2009
Chapter 6 Assignments
Assignments for chapter 6
Vocabulary for chapter 6. It is on the p:driveFlashcards for chapter 6. The link is on my blog page. Just find it!
Pg. 452 Apply your knowledge. Name this totally Toned
Pg. 453 Extend your Knowledge. Name this Park Department Newsletter
Wednesday, October 7, 2009
Chapter 6 Announcements
Hello everyone! Some of you have not turned in your chapter 6 flashcards and vocabulary. Make sure this is turned in before the chapter 6 test. It looks like we will take the chapter 6 test on Wednesday.
Unfortunately I haven't been able to redeem the vouchers for the Office Specialist classes and test. I will call during my planning period to get everything straightened out. Luckily, the program where you will do all your training is online. So, you can work on it anytime you are at a computer.
Unfortunately I haven't been able to redeem the vouchers for the Office Specialist classes and test. I will call during my planning period to get everything straightened out. Luckily, the program where you will do all your training is online. So, you can work on it anytime you are at a computer.
Thursday, October 1, 2009
Chapter 6 Creating a Newsletter
Today you will start learning how to create a custom newletter.
You will be learning how to creat a banner for your newsletter.
You will be learning how to creat a banner for your newsletter.
Customing the banner
Adding a top border to the banner
Tuesday, September 22, 2009
Today is Wednesday (I will be at a conference)
Hello class!
Today will complete your assignments for chapter 4. They are:
After you finish the 3 assignments, take the practice test for Word Chapter 4 (it's online). All that you have to do is pick your answers and at the bottom of the page, you type in your name and then you hit submit. Print and hand in when you are done. Here is the link:
http://oc.course.com/practicetest/default.cfm?ISBN=978-1-4188-4338-0&project=4
Have a nice day and see you on Friday!
Today will complete your assignments for chapter 4. They are:
- In the Lab 1
- In the Lab 2
- In the Lab 3 on page WD 300-301
- The picture for the watermark is on the P:drive_fall2009_Gannon_Computer-Apps_Word_Chapter4
- The text file is also on the P:drive so you will not have to type the text in for this assignment!
After you finish the 3 assignments, take the practice test for Word Chapter 4 (it's online). All that you have to do is pick your answers and at the bottom of the page, you type in your name and then you hit submit. Print and hand in when you are done. Here is the link:
http://oc.course.com/practicetest/default.cfm?ISBN=978-1-4188-4338-0&project=4
Have a nice day and see you on Friday!
Friday, September 11, 2009
Practice Test for Chapter 5
This is the link for the chapter 5 practice test. All that you have to do is pick your answers and at the bottom of the page, you type in your name and then you hit submit. Print and hand in when you are done.
http://oc.course.com/practicetest/default.cfm?ISBN=978-1-4188-4338-0&project=5
Your test for this chapter will be on Tuesday. All homework assignments are due by the time you take the test.
I will be grading you on
Arrow Appliances (Make it Right) pg 374
In the lab 1 (Diamond Eye Care) pg 376
In the lab 2 (Athletic Booster Club) pg 378
http://oc.course.com/practicetest/default.cfm?ISBN=978-1-4188-4338-0&project=5
Your test for this chapter will be on Tuesday. All homework assignments are due by the time you take the test.
I will be grading you on
Arrow Appliances (Make it Right) pg 374
In the lab 1 (Diamond Eye Care) pg 376
In the lab 2 (Athletic Booster Club) pg 378
Thursday, September 10, 2009
Your next mail merge assignment
Make it Right!!!
You will be analyzing a document and correcting all the errors and improving the design.
The directions are on page WD 374. The data files that you will need are on the P:drive, Fall 2009, Gannon, Computer Applications, Word. There will be 2 files. You will first open the word doucment and say yes to the Sql command. The data source that you need is in that same folder. So you will have to open that to make the mail merge work.
You will be analyzing a document and correcting all the errors and improving the design.
The directions are on page WD 374. The data files that you will need are on the P:drive, Fall 2009, Gannon, Computer Applications, Word. There will be 2 files. You will first open the word doucment and say yes to the Sql command. The data source that you need is in that same folder. So you will have to open that to make the mail merge work.
Wednesday, September 9, 2009
New Mail Merge Assignment
In the Lab 2, Creating a Form Letter Using a Template, a Data Source, Mailing Labels, and a Directory. The directions are on page WD 378 and the Steps are on 379-380.
Thursday, September 3, 2009
Mail Merge starts on pg. 306
Here are a few videos of what we did yesterday in class. Today, I hope to get through the rest of the chapter.
Video 1
Video 2
Video 3
Your next assignment is, In the Lab 1, Creating a Form Letter Using a Template, a Data Source, Mailing Labels, and a Directory. The directions are on page WD 376 and the Steps are on 377.
Save it as a PDF file and name it Diamond Eye Care. Create an account with scribd
Video 1
Video 2
Video 3
Your next assignment is, In the Lab 1, Creating a Form Letter Using a Template, a Data Source, Mailing Labels, and a Directory. The directions are on page WD 376 and the Steps are on 377.
Save it as a PDF file and name it Diamond Eye Care. Create an account with scribd
Thursday, August 27, 2009
Chapter 5 Microsoft Word Mail Merge
Chapter 5 will be the first chapter we cover and the topic is mail merge. Your next to assignments are:
- Your vocabulary assignment is on the P:drive, Fall 2009, Gannon, Computer Applications, then click on Chapter 5 Vocab. This is due by Wednesday! No late work excepted.
- When you finish the vocabulary for Chapter 5, complete the flashcards on the following website. Bookmark this page because you will use it for every chapter. Make sure you click on Chapter 5 flashcards. Type in the # 30 and your first and last name. Then, click on flip card. Watch this video if you still don't know what to do. You may replay the flashcards as many times as you want to get the grade you want. When you get your grade, file print. Hand in for a grade. These are due by Friday!
The printer in this room does not support double-sided printing. The part to support double sided printing will be ordered today and should be here within 3 days, hopefully!
- Remember you must post a link to your calendar blog post for me to grade your calendar. Please view my previous posts for the directions on how to do this. Or, ask a fellow classmate for help. If you still need to set up a Gmail account, see me!
Wednesday, August 26, 2009
How to submit your calendar for grading
Here is an example of what your blogspot.com account will look when you post your calendar to your blog. You will have to do this for each month. Your title page will be a separate image. Post your images in order. Post your pictures 3 at a time and then save. Go back and edit the post to add 3 more images. Continue this process until all of your pages are posted.
Please watch this video to learn how to do this
How to attach your .jpeg
How to post your link on my blog page
How to attach your .jpeg
How to post your link on my blog page
Sunday, August 23, 2009
Why I want you to get a Gmail account!!!!!!
By Friday, everyone needs to have a Gmail account. Click here for a video demonstrating RSS feeds and Google Reader. Gmail offers numerous free applications. One is blogspot.com. You log into Blogspot.com using the same username and password as your Gmail account. Watch this video for a demonstration. Also with Gmail you get to use googledocs! We will talk about this later.
Friday, August 21, 2009
Everyone needs a Gmail account!
I am requiring everyone to create their own gmail account. I do not want you to use your own personal account, I want you to create a new one for this class. After you have a gmail account, you need to go to blogger.com to set up your own blogging site. You have the option to upload a picture and create a profile.
Thursday, August 20, 2009
Adding a custom look to your calendars
Here are a few ways that you can add a custom look to your calendar. Just remember two simple things:
- right click on an object or a text box so you can format it
- If you want to add pictures behind your dates, use the transparency feature
Wednesday, August 19, 2009
Week 1
Hello and welcome to Computer Applications 1! This week you will start your first project for this class, the beloved calendar project. You will be learning how to:
- Choose a calendar template
- Pick a color scheme
- Pick a font scheme
- Create a 12 month calendar
- Insert blank pages
- Group and rotate objects
Subscribe to:
Posts (Atom)