ICT+ASSIGNMENTS

EXCEL Assignments

So far we have completed the following assignments: 1.2invoice on page 356 & 357 13.payroll on page 358 2.9invoice on page 365 & 366


 * Monday, Nov. 21, 2011**

Assignments: 1.4sales on page 359 1.5income on page 360 1.6fixit on page 361

1.7exam on page 362 1.8team on page 363 2.11sales on page 369 & 370 2.12payroll on page 371 & 372
 * Tuesday, Nov. 22, 2011**

2.10income on page 367 - 368 2.13 on page 373 - 375 2.14sales on page 376 & 377
 * Wednesday, Nov. 23, 2011**

Open the following spreadsheet. Save it on your H drive in the Custom Folder as Lemonade Stand. Go to the website listed on the top of the spreadsheet. Play the game for 14 days. Make sure you are keeping track of all the items that are listed on the spreadsheet. You can speed up the process of the game by clicking on fast forward. Put your name in a header on the spreadsheet and print it off. Make sure you save it as well.
 * Thursday, Nov. 24, 2011**

We are going to finish the Lemonade Stand exercise. Then do the following assignments: 2.15fixit on page 378 & 379 2.16income on page 380 & 381
 * Monday, Nov. 28, 2011**

I would like you to finish the two assignments from Monday.
 * Tuesday, Nov. 29, 2011**

3.19exam on page 387 & 388 3.24payroll on page 399 - 401
 * Wednesday, Nov. 30, 2011**

I will give you today's class to finish all Excel assignments. **DON'T WASTE TIME:)**
 * Thursday, Dec. 1, 2011**

**Monday, Dec. 5, 2011** Textbook - **Learning Microsoft Office Excel 2007** 06MAAC Invoice page 45 OXL12 page 75 open the following attachment for this assignment. OXL013 page 82 open the assignment that you just finished. (OXL12 from your H drive)

With it being December, people are starting to think about Christmas. I think this is the time of year when people should put aside their differences and think of others that are not as fortunate as you may be. Your assignment for the next couple of days has to do with thinkiong of others and the spirit of giving.
 * Tuesday, Dec 6, 2011**

Sample sheet for Charity Assignment

Yesterday was the last day for finishing your Charity Assignment. Textbook - Learning Microsoft Office Excel 2001 07 Bakery Schedule 7-21 page 52&53 08 MAAC Invoice Page 60&61 09 Balance Sheet page 65
 * Tuesday, Dec 12, 2011**

12 Inventory Page 74 13 Inventory page 80 & 81 OXL 16 Page 97 Follow the directions on Page 97 but use the hours and rates shown on the handout I have given you. This is due on Thursday. Be aware there is a __test in Excel next Wednesday.__ __I will be marking your Charity assignment today and will let you know your mark asap.__
 * Wednesday, Dec 13, 2011**

Yesterday you worked on OXL16. I hope you have this finished. Today you will look on the Internet and find 10 different jobs in Canada that require you to know Excel. While researching make sure you have different jobs for different places. For example, if you find a job in a bank then you can only use one bank. In Excel create a spreadsheet listing the 10 jobs, the company, where the job is located, what the job is about, how much does it pay, and 4 different qualifications where I should see that Excel is required. I will give you an example of what your document should look like. Do not use the same jobs as I have used in the sample.
 * Thursday, Dec 14, 2011**

Catch up on all Excel assignments. Everything up to and including the work given yesterday is due on Monday. The teachers need to mark all of your assignments asap.
 * Friday, Dec 16, 2011**

Begin custom assignment for the $5000 shopping spree. Save as SHOPPING SPREE. You will spend all of the money at one store of your choice. Follow all of the directions on the handout. Remember all of your assignments are due today and you have a test on Wednesday. The test will include multiple choice questions and an exercise assignment from your Excel book. You need to study the procedures given in each chapter.
 * Monday, Dec 19, 2011**

Pg 134 22 Daily Bread Sales - Try you hand at following the directions from the book to create a chart. Pg 135 On Your Own OXL 21 Test tomorrow.
 * Tuesday, Dec 20, 2011**

Test in Excel
 * Wednesday, Dec 21, 2011**

Final class before Christmas. After the holiday we will begin the section on Digital Citizenship Merry Christmas and Happy New Year!!
 * Thursday, Dec 22, 2011**

Happy New Year!! I hope everyone had a wonderful holiday!
 * Monday, Jan 9, 2012**

Today we are starting to look at Digital Citizenship. I would like you to research what Digital Citizenship means. In a one page report you will define Digital Citizenship and then you will explain each of the 9 themes using your own words. This assignment can be done in WORD and saved in your Digital Citizenship folder as //9 Themes//.

On Monday you took a look at the 9 themes of Digital Citizenship. Of the nine themes that you looked at I would like you to choose one theme and research the theme. I would like you to find items that support the theme so you may present this to the class. Your presentation should last 2-5 minutes at the most. You must tell the class what the theme is and show examples. If there is something for us to learn from this theme then you must let us know the lesson. For example, Digital Commerce, what should we know about with buying online. How do we know that it is a secure line? You can use any form to present. This assignment is due this week. Here is a list of the groups and what their topic is:
 * Tuesday, Jan 10, 2012**

1. Joanne and Claude - Digital Health and Wellness 2. Justin and Devin - Digital Security 3. Kurinchi and Gabe - Digital Communication 4. Connor and Alex - Digital Laws 5. Neal and Noah - Digital Etiquette 6. John and Matthew - Digital Rights and Responsibilities 7. Skylar and Ranston - Digital Access 8. Kayleigh and Daryl - Digital Literacy 9. Nick and Louis - Digital Commerce

You will have today to work on your presentation.
 * Wednesday, Jan 11, 2012**

You should have your presentation finished. I have printed a rubric for you to use to check your assignment for the criteria needed.
 * Thursday, Jan 12, 2012**

We will start presenting today.
 * Friday, Jan 13, 2012**

Research an online addiction. In 1 to 2 pages double spaced, address the following: 1. Describe the addiction 2. What are the symptoms? 3. What demographic is typically affected by the addiction? 4. Is there any treatment? 5. Include the websites that you got your information from. Save on your h drive as digital addiction. 30 marks Print
 * Monday, Jan 16, 2012**

Finish your assignment on digital addiction.
 * Tuesday, Jan 17, 2012**

[] Research cyber bullying in the above link. In Publisher, create a flyer to inform people about cyber bullying and how it should be prevented or acknowledged so people are aware that it is happening. Save it as cyber bullying in your digital citizenship folder on the h drive. 30 marks Print
 * Wednesday, Jan 18, 2012**

1. Facebook Etiquette. [|www.pcworld.com/businesscenter/article/154374/​**facebook**_etiquette_five_​**dos**_and_​**donts**.html ·]
 * Thursday, Jan 19, 2012**

Read and summarize the do's and don'ts of facebook and create a slide show to display the info effectively. Save it on your h drive as facebook etiquette (10 marks) This will be presented in class Friday.

2. List 10 web sites where you can buy something from. Tell me what you can buy and whether or not it is secure. Also indicate what attributes the web site has that makes it secure. Save it as online shopping on your h drive. Print

Catch Up
 * Friday, Jan 20, 2012**

https://digiteen.wikispaces.com/Digital+Access Read through the above web page on digital access. Create prezi and answer the following: Discuss what the digital divide is Discuss whether the digital divide is shrinking or getting larger What can we do to shrink the digital divide? Be sure to add pictures to demonstrate your concepts. Present to class 20 marks Test in Digital Citizenship Thursday, Jan 26
 * Monday, Jan 23, 2012**

Present prezi on digital divide
 * Tuesday, Jan 24, 2012**

Answer the questions on the following link. Save as digi questions on your h drive and print. 20 marks http://ohstechtalk.wikispaces.com/Online+Safety

1. First create a gmail account using Google 2. Then go to blogger.com 3. Set up a blog account 4. Give your blog address to me. 4. To post click on your home page 5. Then click on new post 6. I can see the posts in my reader in gmail 7. They have to follow my blog which is [] //Blog post// - Does texting make you smarter? Explain. Respond to two other blogs in class. (You are getting marks for these. Keep appropriate content and language. I can view your blogs)
 * Wednesday, Jan 25, 2012**

//Blog post// - Does technology help you learn? Explain. Respond to 2 others in the class.
 * Thursday, Jan 26, 2012**

Test Digital Citizenship

//Glogster// is a digital version of publisher. Create a gloster flyer about yourself. You can add your favorite video, pics of yourself, one word describing you and at least 4 acts of kindness that you have done today or can do today.
 * Friday, Jan 27, 2012**

Catch up
 * Monday, Jan 30, 2012**

Catch up
 * Tuesday, Jan 31, 2012**