MIS PROJECTS

Align all numbers to the right with their headings. Make sure decimals are lined up. Use $ where appropriate. The $ looks nicer under format, currency; however, the $ icon will be acceptable. Your grades will be based on the attractiveness of the spreadsheets.  Try to get most of the spread sheets on one page by changing font size, margins, field widths, by splitting the spread sheet and/or using landscape view.   All graphs should be formatted to fit on one page.  Change font size where needed using Print Preview to see if the titles and other words fit the page and are the appropriate size. The first projects are review projects.

The projects become increasingly more difficult; some projects count as two projects. All projects will be graded off the screen except for Projects 1&2, and your resume.

NOTE:  If a project is completed as a group in class and you do not attend that class, you will receive a zero for that project unless you have a school related excuse.  The projects have been altered from previous semesters. If you attempt to get credit for a project copied from previous students' saved work, you will get a 0 and you will be turned into the Dean's office for cheating.  I must see you working on these projects in class in order for you to obtain credit. 

Projects 1 & 2   Excel

This project will take 5 weeks to complete. I am giving you each $10,000 to invest in 10 different stocks on the New York Stock Exchange or NASDAQ  Use the quotes ion Thursdays for 5 weeks in a row during the semester. Jot down the closing price of your chosen stocks every week. You may enter your data weekly, or you may wait till the end of the 5 weeks. The spread sheet should look similar to the following, or you may design your own format. Your numbers will be checked for authenticity. Type in price as 88 1/8; when the currency icon is used, Excel will store your third place figure. Ex 89 3/8 = $89.375 and appears as $89.38. Eyeball the total gain or loss and compare with the total % change. You will not get credit if you make up the data. To keep track of the value of your portfolio, use function SUMPRODUCT for the red number $10,450.00 below.  Use $ for appropriate column reference so you can fill right.  
Hint: $ before alpha for columns that are to stay fixed and $ before # for rows that are to stay fixed.  A good web page with historical stock prices is   http://www.nasdaq.com/ (get all 10 quotes at once and save link below your spreadsheet for the next week) or http://finance.yahoo.com/  or  www.money.com.  You cannot sum the %s in the last column.

% Change=Change/original       In this case= Change in stock price/original stock price

To get credit for this project, print the final numbers and a copy of the equations. (Ctrl~)

REVIEW PROJECT

PROJECT 3 Excel

You are interested in keeping track of your automobile’s gas mileage. (Miles per gallon). Use the numbers on spreadsheet below.  Calculate the miles per gallon each week. Figure an average mpg for the 7 week period using =average(first cell:last cell) where first cell = location such as D5 or click on the down arrow next to the Sum button to find average.  Keep XXX at start date because you haven't traveled yet. Save on Z: or USB drive. 

PROJECT 4  Excel

Enter into a worksheet the following list of students and their grades: Based on the following percentages, calculate the final grade for each student: The Articles are worth 20%, the tests are worth 10% each, the exam is worth 25% and the projects are worth 25%. Next, calculate the class average for each exams given, the articles, the projects, and the final grade. Round the grades to 0 places. Turn the column headings to 45 degrees (not shown). Do that for this project by highlighting column titles, and hit right mouse, format, alignment and drag to 45 degrees. This is not shown below. Save and print one copy after previewing.  This is how your grades will be averaged using a more complex spreadsheet and equation. For some reason this project doesn't cut and paste correctly into Excel. It is easier to just type from scratch or after you cut and paste, highlight all the cells. Go to format, cells, alignment. Next turn off the merge cells box.

MIS Grade Analysis 

Project 6 Excel: Charting

Create the following spreadsheet. Enter the formula to total the sales or use sum icon. Sort the data in descending order so that the largest sellers are on the top using Data....Sort.  Make a 3D pie chart with a title and a subtitle (not shown). Change the slices of the pie to different patterns. Explode the top two slices by clicking and dragging each slice individually. Do not include the total when making the pie graph. Rotate the pie so that the MS Office and MS Windows slices are on the right of the pie graph by clicking in the right, empty corner of the graph and hitting right mouse button, 3-D view. Add a text box, TOP SELLERS, using the draw tools under View. Put a box around the words as shown, and color it with a background color. Draw two arrows as shown pointing to the two top selling software programs. Save. The graph below is only an example, your numbers are different.

Project 7 Excel

Create the following spreadsheet. Type Quarter 1 and click and drag to get the other quarters to appear. Create a column graph for all of the data except totals with the X & Z axis labeled. Make sure a legend shows. Title and subtitle the graph. Subtitle is added by clicking on the title and putting cursor at the end of the title and hitting enter. Show both X and Y major gridlines.  Next go back to the spread sheet and graph the totals for the 4 quarters. To highlight two nonadjacent rows, highlight one and hold down control and click and drag the total. Change patterns of the bars and the background pattern or color. Change the X Axis words to align vertically.  Preview the graph, and save. Hint: When you start to highlight, start with the empty orange cell above Newton.

The graphs should look similar to the two graphs below: Numbers and cities are different.

Project 8  Access:  Queries and Reports

Using Access, set up a data base for the following data.  Query the data to answer the questions that follow the data.  You may make up the data.  Make sure you have one or two patients under 20 involved in a car accident.  Add data for at least 10 people.

 Create a report or series of reports with the following information:

• The average age and total number of emergency report forms. (Use wizard for any counts to get total number)
• A list of reports in January 2007.
• The total number of trauma cases.
• The total number of emergency cases in which patients had no medical insurance coverage.
• A list of all emergency patients under the age of 20 who were involved in a car accident.

Show PW the five reports only.

9  Access: Company Prospects

You are to develop a database of customer prospects for your company Tekkies Inc.  You are to set up an input form so clerks may add new data easily.  You will develop two tables and connect the two using a relationship. 

2. Set up a new database named Tekkies  In the Access, Tekkies database go to File, get external data.  Follow instructions to import the Prospect data.exe file in number 1 above.. Call the new table in Access, Prospects.

Ordered, Highpotential, Avgpotential, Lowpotential

5. Run a query that lists all customers who are high potential from the 28603 zip code. You must add both tables to get the status field. Report this query. Choose the status field off the status table not the prospects table. 
6. Run and report a query that lists all customers from Hickory who have ordered. You must add both tables to get the status data. Choose the status field off the status table not the prospects table. 

7.  Sort Prospects table by Company name. 

8.  Show PW the sorted Prospects table, and the two reports of the queries.

10 Access :  Church Contributions 

You are a church secretary trying to set up an application to keep up with member donations.  You have to set up the following two tables:   

The table data is ready to open below in the blue box.  Designate a relationship between the two tables under relational database.  Enter data for 3 people for four Sundays in October and one special building collection. Make up all of the data.  In reality it would be used for all members for the whole year, 2008.  Run a query to print all the fields in the member contribution table except for autonumber for 2008 only . Print a report for the three members with the addresses and then a subreport for the contributions. Make sure there is one report per page with the heading "2008 Contributions" on the top of each page.  Total all the contributions for the members' tax records.  Other reports could be generated for the church accounting records.

Your final report should look as follows with different dates and numbers. 

Right click on "data" below.  Save to your Z: or zip drive.  Open in your new location.  

Project 11  PowerPoint Review

Recent graduates on their first job are often asked to prepare presentations for customers, corporate headquarters or for board of directors meetings. Design three attractive PowerPoint sheets. Print on landscape or portrait view. Insert your Co. Logo’s and name at the top of all 3 sheets by going to view master....slide master.  What you do on slide master will appear on all slides of your presentation.  Again, design your logo in Powerpoint with clip art or picture and name and address, group everything and save as a picture.  

First sheet- Include a new graph with title and text describing the graph in more detail. You may NOT use a previous graph or the default graph found in PowerPoint. Include background design, Co. Logo and/or name and text.  It is much easier to make a graph in Excel and copy and paste it into PowerPoint. 

Second sheet- Include an organization chart with 3 levels and one assistant to position. Include your company’s name and logo. See example below....

Third sheet- Design an attractive advertisement for your company. Use one or two graphics.  Add a picture off the Web to this sheet.

(The next project uses mail merge in Word under Tools)

Project 12 Word:  Mail Merge

Imagine that you are in charge of collections for a file of customers with 4,000 records. Set up a mail merge with the following fields. Make up the data for three people. (4,000 would require too much paper)

Set up a letterhead with your company’s name, address, phone #, fax #, and company logo or use the one in Project 12.  Write a collection letter using standard business letter format. 

 Import the data fields as you type the letter. Use the Salutation form of (Dear Title Last,) Use appropriate punctuation. Imagine that you are sending 3,000 collection letters. See the example on the next page. Make sure your letter is centered in the middle of the page vertically. Sign the letters.

January 9, 1999

(4 spaces here) 

<<title>> <<firstname>>  <<lastname>>
<<jobtitle>>
<<companyname>>
<<address>>
<<city>>, <<state>>  <<zip>>

Dear <<title>> <<lastname>>:

According to our records, you have been billed «Billed» on {DateBilled}, and you have paid «Paid» on {DatePaid}. Please remit «Owed» or we will have to.................

Note:  Make up your own collection letter.  Do not use the words above.

Sincerely,

leave 4 lines to sign

Your Name
Your Title

 Project 13  Excel

Page 340 of text.   Project 6 assignment.  Tutorial precedes the assignment.  Note:  This project uses an imbedded IF statement because there are three possible states, greater than 1000, between 500 and 1000 and less than 500.   

Projects 14 & 15   Word:  Resume

Read all instructions first. Print a copy of your resume using Word for Windows. Use a search engine on the World Wide Web to find examples of how to write a good resume or use http://owl.english.purdue.edu and click on resume. Use Times Roman, Arial or Tahoma Font. An example follows.  IMPORTANT: Before you type anything, set tabs.  Save yourself a lot of trouble.  Don't use the resume templates available on MS Word.  These are fine; however, if you ever want to change something, it's difficult to get everything lined up.

Keep resume to one page. Fill the page both vertically and horizontally. Beware of skimpy resume. Objective statement is not used as much any more. If you need to fill the page use Career-related Course-work Category, or use Skills and Capabilities Category. Start each descriptive line in your experience category with an action verb. A list of action verbs follows:  An example of a resume follows the action verb list.  Other categories not listed on the example resume are Honors and Awards and Career-related Coursework.

Link to an example resume follows the action verb list.