Vacation Time


 

Home
Site Map and Search
What's New/What's Due?
General Guidelines
Assignments for CIS 100
Calendar- CIS100
CIS 100 Syllabus
Hints for Assignments
Student Learning Outcomes
Word Processing
Internet & Email
Spreadsheets
Access DB
PowerPoint
Portfolio
Up
Budget Spreadsheet
Campus/Major Analysis
Income Statement (P&L)
Store Invoice
Carpet Store Invoice
Simplified Income Tax
Car Loan Payback
Payroll Sheet (Independent)
Hints for Spreadsheets
Vacation Time
Longer Videos
YouTube
Tutorials
Printing Hints
Reference


Search this site or the web powered by FreeFind

Site search Web search

Student Learning Outcomes:

After completing this assignment the student will be able to apply the following important spreadsheet creation skills:

 Procedure

Assessment

 Naming Cells

IF

VLOOKUP

PMT

Procedure:

Assume you are the director of human relations of a large company (over 10,000 employees).  You are trying to calculate the effect of a new vacation policy.  Below is the spreadsheet with which you are working:
 
Revised Vacation is granted as follows:

bullet  none until 1 year of service
bullet  1 weeks for 1 up to 3 years of service
bullet  2 weeks for 3 or more but less than 5 years of service
bullet  3 weeks until 10 years of service
bullet  4 weeks after 10 years of service

The Out-of-County Bonus is 25% of the Revised Vacation

A B C D E F G H
Name  Region Date
of
Hire		 Current
Vacation		 Years of
 Service		 Revised
Vacation		 Out of
County		 New Vacation
Joe Jones U.S.A. 3/3/1987 3    18 4 1 5
Sue Smith Europe 3/4/1998 3      7 3 0 3
Tasha Thompson Far East 3/5/2001 2      4 2 0 2
Total          31 9 1 10
Average          10 3 0 3
bullet

Enter the values in columns A to E, rows 1 to 4.

bulletCalculate Years of Service by subtracting date of Hire for NOW() and dividing by 365.25. (Please Excuse My Aunt Sally)
bulletCreate a table for the Looking up Revised Vacation
bulletWrite the formula in F2 G2 and H2
bulletDrag the  the formulas in E2, F2, G2 and H2 down 10,000 rows for all employees (really only the 2 more rows)
bulletCreate the Sum formula in E5 and the Average in E6.
bulletDrag D5 and E6 to under all the other columns
bulletAdd a page Heading
bulletCheck for good formatting (centering, bolding, number of decimals, etc.
bulletPrint
bulletShow formula, Add Gridlines and Row and Column Headings.  Print again.

Assessment

Advanced
Proficient
Partially Proficient
Non-Proficient
A
B
C
F
Follows all the Cardinal, formatting, naming, printing and charting rules on the Checklist
Sheets is labeled and ordered. Placement of data shows planning and facilitates easy reading & comprehension. 		Follows all the cardinal rules on the Checklist.  Violates 1 or 2 formatting, printing or rules. Follows all the cardinal rules on the Checklist.  Violates 3 or 4 formatting, printing or rules. Chart missing. Only formatted values or formula sheet submitted.  One cardinal spreadsheet rule or 5 or more formatting or charting rules ignored.

[ Home ] [ Up ] [ Budget Spreadsheet ] [ Campus/Major Analysis ] [ Income Statement (P&L) ] [ Store Invoice ] [ Carpet Store Invoice ] [ Simplified Income Tax ] [ Car Loan Payback ] [ Payroll Sheet (Independent) ] [ Hints for Spreadsheets ] [ Vacation Time ][ Site Map and Search ] [ What's  New/What's Due? ] [ General Guidelines ] [ Assignments for CIS 100 ] [ Calendar- CIS100 ] [ CIS 100 Syllabus ] [ Hints for Assignments ] [ Student Learning Outcomes ] [ Word Processing ] [ Internet & Email ] [ Spreadsheets ] [ Access DB ] [ PowerPoint ] [ Portfolio ]

This page was created by   and was last updated on 09/15/07

Page Name: (pagename)
URL:            (url)

Disclaimer:  Information on this site represents the thoughts and opinions expressed by the author and not that of Union County College.  The author takes full responsibility for the information presented.  By using the information contained herein, the user willingly assumes all risks in connection with such use.  Neither the author nor Union County College shall be held liable or responsible for content, errors, and/or omissions in information herein or information contained on any Web Page to which it is linked.  Furthermore, neither the author nor Union County College shall be liable for any special, consequential, or exemplary damages resulting, in whole or in part, from any user's use of, or reliance on, this material or material set forth on any Web Page to which it is linked. 
Copyright:      ã Maureen Greenbaum Sumware in NJ  2001, '02, '03, '04, '05, '06, '07, 08, 2009.  All rights reserved. AddThis Social Bookmark Button