Technology for School Leaders:

Final Exam (Complete this final after you have completed all of the regular projects.)

Spreadsheet
Word Processing
Monkey Survey
Website and Images
Database and Letter merge
Powerpoint presentation
 

Final Exam, Part 1, Spreadsheet Problem. (75 points)

1. The following data is the enrollment for a school district for the past five years, 1999 to 2004.

Grade	1999	2000	2001	2002	2003	2004
K	95	92	98	110	129	135
1st	90	97	99	102	113	132
2nd	83	92	95	98	103	120
3rd	75	82	96	87	100	109
4th	80	81	95	100	99	110
5th	60	83	86	95	99	106
6th	55	62	65	90	102	107
7th	50	60	65	68	92	110
8th	49	53	62	79	75	98
9th	45	54	65	72	76	80
10th	44	54	66	75	80	86
11th	40	50	60	72	76	82
12th	38	42	48	60	70	66

2. Construct a spreadsheet, with labels, of the above data. (You can cut and paste this table of data into Excel.

3. Show the total enrollment for each year, 99 thru 04. Formula must be available.

4. Show the enrollment per grade. Formula must be used.

5. Show the the number of teachers per year, if you had to maintain 23 to 1 ratio. Show only whole numbers when calculating the number of teachers. Show formula.

6. With the enrollment data for 2004 (and an average class size of 23), how many teachers would you need for each grade? Show formula

7. Create a chart, with legends, of the enrollment trend for the school district for the last five years (actually data for six years). In your chart, you should have enrollment for the vertical axis and the years, 1999-2004 on the horizontal axis (at the bottom of the chart).

When the spreadsheet and chart are completed, send to Dr. McKay

1. Copy and paste the following article into a MS Word file.  APA formatting required.

2. For the following short article, do the following:

a. Create a title page
b. Create a table of contents-using the MS Word "Table of Contents" feature
c. Include page numbers (not on the first page)

3. Send the revised Word document as an email attachment.

Workaholism: Praised or the Plague of School Administrators?

Dr. Jack McKay, Professor of Educational Administration, University of Nebraska at Omaha

The subject of workaholism is somewhat neglected as an area of serious concern by school administrators and policy makers because it are difficult to define and is even considered an asset rather than a liability. In the health profession, workaholism is the best-dressed mental health problem of the leadership and managerial professions. This article will show that workaholism, the addiction to work, is a disease that can inhibits school leadership efforts, ruins promising professional careers, and can be harmful to colleagues as well as immediate family members.

Workaholism is defined as an obsessive-compulsive disorder that manifests itself through self-imposed demands, a inability to regulate work habits, and an over indulgence in work to the exclusion of normal life activities. The term is similar to alcoholism because the two addictions are believed to have common behavior patterns. The four addictions are:

… Progressive in nature,

… An unconscious attempt to resolve unmet psychological needs,

… Can lead to an unmanageable life,

… Cause family disintegration,

… Result in health problems that can lead to anxiety and depression.

Work highs, like alcoholic euphoria, run a cycle of adrenaline-charged work binges that are followed by exhaustion similar to alcoholic hangovers. Workaholism creates health problems, failed marriages, endangered careers and can result in mental health issues with other family members.

Researchers on workaholism have found that workaholics have greater tendencies toward depression, anxiety and anger. They have feelings of inferiority, fear of failure, an inability to deal with unresolved issues and strong tendencies toward perfection (Haymon, 1993; Machlowitz, 1980).

Workaholism and the Family

The workaholic's impact on there family is also a major problem. Bryan Robinson (1988) found that spouses and children become extensions of the workaholic's ego, usually leading to family conflict. Spouses and children feel unloved, lonely, isolated, and emotionally and physically abandoned. Another study found that the workaholic's children are faced with excessively high demands for achievement. During family conflicts, the workaholic would avoid confrontations by becoming silent.

Workaholics tend to abdicate their role in their children's development. If they do become involved, it usually is only to check on the child's progress towards perfection in whatever has been undertaken. Follow-up studies suggest that children of workaholics carry the legacy of the workaholic parent, such as an external sense of control and approval-seeking behavior to meet other adult expectations. Different from the alcoholic with the bottle to blame, the workaholic's family faces excitement because there is no item to blame.

Send you revised document to Dr. McKay

Monkey Survey

Create a survey with the following ten questions:

1. Gender: Male/Female
2. Age: Less than 25, between 26 and 35, between 36 and 45, between 46 and 55, between 56 and 65, more than 65
3. Rate the political tendencies of your community: progressive, moderate, neutral, conservative, ultra-conservative
4. Satisfaction with career choice: Very satisfied, satisfied, neutral, dissatisfied, very dissatisfied
5. How many computers do you have in your home: none, one, two, three, four, five or more
6. Internet modem: hard wire, wireless
7. Browser preference: Netscape, Explorer, AOL, other
8. Search engine preference: AOL, Lycos, Altavista, Dogpile, Netscape, Google, other
9. My advanced degree aspirations are: Masters Degree, Specialist Degree, Doctorate Degree, other
10. Short answer: The most difficult things about the "Technology for Leaders" course is:

When you are done constructing your survey, click on collect and let me know what the URL is under the "email" option.

5. Save the Survey Monkey (include your name in the title) and attach to an email to Dr. McKay.

1. Create a web page with the following:

a. Create a table with two columns and two rows.
b. Select the two images images below and place them in the top row.  (Shortcut:  Move your cursor on to the image, then with a right click on your mouse, copy the picture, then
c. Title the pictures in the second row.

Sunset looking west from Lund, B.C.
 
Fourth hole on the Timber Course

d. Make sure the images are the same size, e.g. 2x3 inches.
e. Name your webpage "webfinal"
f. Upload the webpage to your folder and send an email to me with your URL.

Send the URL by email. It should look something like this....

http://www.hmleague.org/Heritage/yourname/webfinal.htm

1. Create a data base of the following students with addresses and scores.

a. Tiger Woods, 103 Pine, Omaha, NE 68114, 92
b. Jack Nichols, 204 Oak, Omaha, NE 68234, 95
c. Mag Ryan, 304 Fir, Omaha, NE 68123, 96
d. Sharon Stone, 504 Cedar, Omaha, NE 68101, 94
e. Clint Eastwood, 602 Apple, Omaha, NE 68444, 99

2. Merge with the following letter.

May1, 2003

Insert
Insert address
Insert city, state, zip

Dear Insert,

You are cordially invite to our annual Fourth of July celebration. You score of (insert) qualifies you to bring a salad to the picnic. Please no gifts. Looking forward to seeing you on the 4th in our backyard.

Sincerely,

Bill Gates

Send the database file and letter that indicates the merged data from your data base by email to Dr. Mckay.

1. Convert the "workaholic article" (or some other topic that could be presented to an audience of aspiring educators) to a PowerPoint presentation.
2. Select a template background.
3. Keep the presentation to a maximum of five slides with no more than three ideas per slide.
4. Include transitions between slides and between ideas on the slide.
5. Include appropriate clip art or images that will enhance the presentation.

Send the PowerPoint presentation by email as an attachment to Dr. McKay

Exam Section	Points
Part 1, Spreadsheet with chart	100
Part 2, Word Processing	100
Part 3, Microsoft Project	100
Part 4, Web pages, images, uploading	100
Part 5, Database and merges	100
Part 6, PowerPoint	100
Total	600