36days since
End of semester

MM 126‎ > ‎Assignments‎ > ‎

MS Office



DUE DATES:

UPDATE::  NEW DUE DATE... is MIDNIGHT, the day you have the LAB in MM 126 - see Lab for why extended.


week of:  Oct 24  - Oct 24 is a MONDAY... so whenever your Lab is,  that is the Due Date.


How to hand in?

  1. UPLOAD to your Google Docs  <--- BUT NOT converted to Google Doc Format
  2. have an extra copy on cc-media in folder MM 126
Weight:
UPDATED 
20% of your mark  - 10% for PowerPoint


OLD  >>> 15% of your grade, 5% each



Microsoft Excel


Create this basic Budget in Excel

Required
  1. Print a copy so you can make sure it fits on one page, and examine it for errors
  2. Upload a copy to Google Docs - what did you notice? Did you lose some formatting?

Check list:
  1. All bolded number must be formula
  2. Dates must be EXCEL dates - just ask Mr. M. if you are stuck
  3. Make the budget realistic
  4. Check it carefully for accuracy by putting in small numbers first
  5. must fit on one page
  6. Add what you learned to your What I learned in MM 126 document
  7. Save as HTML and look at in Firefox... just so you know
  8. Save as .xls  NOT the newer format!


Marking Matrix:
  • 5/10 good basic job and complete job, followed instructions -  min time spent
  • 7/10 well done, added slides, engaging - learned a FEATURE of Excel, on YOUR own, without Mr. M.
  • 8/10 excellent - well done - hours spent , learned stuff, dressed up,
  • >8/10 really exceeded requirements, like a whole year - 12 months and nicer formatting, more formula 



CLICK TO ENLARGE IMAGE
Note to Mr. M. -- xls is uploaded to _______ do not show.





Microsoft PowerPoint




Creative Brief:
- Concentrate on ONE Aspect of Photography and make a PowerPoint to convey clearly this point
- can be anything...
- Depth of field, composition, rules of thirds, black and white, how to photograph flowers, landscapes, portraits, making interesting photos


For Your Consideration:
Try sketching some ideas/layouts etc. in your Sketch Book, not for marks.


DEMO:
Sing-a-long with Mr.M. he will create 3 slides
MR. M.
  • MIN. 8 slides
Check list:
  1. Must use one thing something in Slide Master (logo, text, slide no)
  2. Not concerned with copyright, although if you use creative commons - do give credit somehow
  3. Must have INTRO and EXTRO slide
  4. Make it 100% CLEAR what your slideshow is about on INTRO slide
  5. Keep it simple
  6. Must TEACH something about photography
  7. When done, upload to Google Docs - share with Mr. M. in folder,
  8. Also, upload the PPT to Google Docs, and don't have it converted
  9. Also, put on cc-media please in MM 126 folder
  10. and to http://slideshare.net   <-- sign up required.

ON YOUR OWN...
  1.  Try making a HTML version, just so you can see it, it takes a minute that is all... this is NOT for marks
  2. Show it to the person NEXT to you, then the NEXT week, ask them to recall ONE thing... if they can't, your slideshow may not be effective, or it could be them ;)

Marking Matrix:  - NOW 10%
  • 3/5 very basic, min time spent
  • 3.5/5 well done, added slides, engaging - learned a FEATURE of PowerPoint, on YOUR own, without Mr. M.
  • 4/5 excellent - well done - hours spent
  • >4/5  - stunning, gorgeous, reserved for extremely professional presentations, with a lot of thought, research and creativity

Deductions
0.5 if not shared on Google Docs - as a FILE - not a converted
0.5 if not uploaded to slideshare
0.5 for typos - please get it proofread
0.5 if your presentation looked like "How Not to PowerPoint" on youtube  (too much text, bullets, animations, boring choices etc.)

Deduct: 10% per working day, based on Google Doc DATE.




Microsoft Word


This assignment is meant to show you some moderately advanced MS Word Features.

Challenge
Make a boring report look very professional, using MS Word Features.


Download the attachment at bottom.

Mr. M. to write check list here.
  1. add headings
  2. add Table of Contents
  3. add page numbering
  4. Make the bullets - Word bullets
  5. Format up nicely, maybe larger left  
  6. UNDERSTAND how powerful Styles are - make your main heading blue
  7. Add 5 images to make the report better - crop, wrap etc.
  8. on your own, use a FOUR Word features. - Drop Cap maybe?
  9. Save as HTML  <- all programs do this now...

Add some images that are relevant to the report.

On a SEPARATE DOCUMENT - Design a simple cover sheet.
Call it
NewMediaCoverSheet.doc   NOT .docx important


When DONE, upload the Word Documents to your Google Document,
but DO NOT CONVERT IT to Google Docs?  <VERY IMPORTANT.
Marking Matrix:
  • 3/5 very basic, min time spent
  • 3.5/5 well done, .
  • 4/5 excellent - well done - hours spent
  • >4/5  - stunning, gorgeous, reserved for extremely professional report, with a lot of thought, research and creativity

Deductions
0.5 if not shared on Google Docs - as a FILE - not a converted
0.5 for typos - please get it proofread
0.5 if really boring appearance

Deduct: 10% per working day, based on Google Doc DATE.





Č
ċ
ď
2011MarknigMatrixMM126MSOfficeAssignment.doc
(180k)
Rob McCormack,
Nov 8, 2011 3:55 PM
ĉ
ď
Rob McCormack,
Oct 4, 2010 6:38 PM