Microsoft Excel Unit 6 Assignment
All assignments are group work for maximum 5 per group. Choose your partner wisely. Thank you
Assignment 1: Choose 1
Microsoft Word
(i) Imagine you are writing a resume for a big company for the job position as the executive engineer. Each person in group must write their own resume. Compile and send them. Write them nicely and convincingly as if you are really applying for the job. (ii) Imagine your company has a magazine. Write a newsletter of any topic. Must be at least 4 pages long and have interesting news with appropriate pictures.
* Assignment must at least be 3 pages long * Include special typographic effects such as indentation, italics and boldface styles and graphics and several fonts of various sizes. * At least TWO(one for resume) images must be …show more content…
Additional features of PowerPoint you can include if wish [optional]:
* Sound effects (you can use the ones that come standard with PowerPoint or find one yourself). * Word Art and Smart Art * Drawn shapes with colored or textured fill.
[10 Marks]
Assignment 3:
Microsoft Excel
This assignment will allow you to think about the capabilities of computers when used as a grade book and it will give you a better understanding of how Excel can assist you in record keeping. * Open a new file in Excel * Type in 30 "Student" names. Make sure they are arranged alphabetically. Feel free to choose your own names! * Row 1 should contain at least the following categories: * Name * Five assignments with each assignment being worth 100 points.
(Quiz, Project, Midterm, Lab and Final exam) * Final score * Assign grades for each assignment to each student. * Average the overall class grade for each assignment. * Find out the highest and lowest mark for each assignment. * Weight the assignments so that: * Quiz =
Assignment 1: Choose 1
Microsoft Word
(i) Imagine you are writing a resume for a big company for the job position as the executive engineer. Each person in group must write their own resume. Compile and send them. Write them nicely and convincingly as if you are really applying for the job. (ii) Imagine your company has a magazine. Write a newsletter of any topic. Must be at least 4 pages long and have interesting news with appropriate pictures.
* Assignment must at least be 3 pages long * Include special typographic effects such as indentation, italics and boldface styles and graphics and several fonts of various sizes. * At least TWO(one for resume) images must be …show more content…
Additional features of PowerPoint you can include if wish [optional]:
* Sound effects (you can use the ones that come standard with PowerPoint or find one yourself). * Word Art and Smart Art * Drawn shapes with colored or textured fill.
[10 Marks]
Assignment 3:
Microsoft Excel
This assignment will allow you to think about the capabilities of computers when used as a grade book and it will give you a better understanding of how Excel can assist you in record keeping. * Open a new file in Excel * Type in 30 "Student" names. Make sure they are arranged alphabetically. Feel free to choose your own names! * Row 1 should contain at least the following categories: * Name * Five assignments with each assignment being worth 100 points.
(Quiz, Project, Midterm, Lab and Final exam) * Final score * Assign grades for each assignment to each student. * Average the overall class grade for each assignment. * Find out the highest and lowest mark for each assignment. * Weight the assignments so that: * Quiz =