CS 1200 Final

DUE: Friday 05/12/2017 BEFORE MIDNIGHT - LATE FINALS NOT ACCEPTED

Overview. Your final project consists of a single PowerPoint presentation with six slides. Each slide beyond the opening slide contains data from the other three applications covered in class (Word, Excel, and Access). Your final submission is ONE attachment, the PowerPoint presentation. Save the other documents for backup purposes in case there is a problem with your submission. Name the PowerPoint presentation final.pptx Email final.pptx as an attachment to your instructor with the subject line "CS1200 Final, Last 4 Digits of Your ID, Your Name".

You should be able to complete the final project on your own. The 'Lab Manual' will be very helpful if you get stuck. Remember to use ctrl + f to quickly find the information you are looking for. If you need assistance come to one of the CMPS 1200 classes or come to office hours. The walk-in lab will be open for use 9am-5pm during week 15.



SLIDE 1 PowerPoint (10 Pts)
Open PowerPoint. Create a new presentation. For the opening slide, type "CS 120 Final Exam Term Year" as the title. Term being Fall or Spring. Put your name as the subtitle. Use any formatting or style you wish. You are done with slide 1. The content for the next four slides will created in Word, Excel and Access. The specifications for these slides are provided below. Save your presentation as final.pptx.



Slide 2 Microsoft Excel (10 points)

Open Excel. Create a new spreadsheet named final.xlsx. Enter the following data into the worksheet. Enter numbers exactly as you see them. The first row is a heading that should merge across all six columns.

To complete your worksheet, add the following:

  1. Enter a formula to compute the tax on each order (Price * 0.07). Format the values as 'Currency'.
  2. Use the IF function to find the shipping charge. If the weight is more than 125 pounds the shipping charge is $1.00 per pound (1.00 * pounds). Otherwise it is $0.75 per pound (0.75 * pounds).
  3. Use either a function or a formula to find the total cost of each order.
  4. Display the numbers in the Tax, Shipping, and Total columns with two decimal places.
  5. Make the title bold and increase the font size of it.
  6. Sort the data by descending 'Order No.'.


Return to your PowerPoint presentation. Insert a new slide. Copy and paste your finished Excel table into the slide. You are done with slide 2.



Slide 3 (10 points)

Return to Excel. In the same Excel workbook, rename Sheet 2 as Exercise 2 and enter the following data on the Exercise 2 sheet.



Using the above data, make a Bar Chart. Save it on the same sheet as the data. Resize the chart if necessary to make the legends and titles clearly visible. When finished, it should look like the chart below.




Return to your PowerPoint presentation. Insert a new 'Title Only' slide. For the slide title, enter your name. Copy and paste your Excel Bar Chart into the slide. You are done with slide #3. Save your worksheet in case you need to create your slide again.



Slide 4 Access (10 points)

Import these files into your Access Database
Students
Major
GPA

Open Access. Create a blank database named final.accdb. Import the tables from above and name them Students, GPA, & Major. The data files you downloaded are comma delimited files (CSV) or tab delimited. The three files represent tables for Students, a table for their major, and a table for their GPA.


Create a query that selects all of the history majors and their GPA.

Now create a report with all of the students in the History department with a GPA greater than or equal to 3.50. You will have the following fields in the given order 'Last', 'First', 'Major', & 'GPA'. Hint: put >= in the GPA Criteria field when in the query design view. Order the table from highest to lowest GPA.

Make the report fit on one page and make it look neat. So shorten up the text boxes put a title, remove the time from the header and reformat the date to mm/dd/yyyy.

Return to your PowerPoint presentation. Insert a new slide. Paste your report on this slide. You are done with slide #4.



Slide 5 (10 points)

Create a form for the 'Students' table using the 'Form Wizard' from the ribbon. Update all of the fields using one form. The form should look like the one below and in that order. TITLE YOUR FORM 'Bakersfield Students Data Update'.




Slide 6 (10 points)
Using the above form add five entries where the 'City' is equal to 'Bakersfield'. Leave the first field alone it will populate on its own. Use fictional data for the other fields. Remember the zip has to be numbers. Select only the cities that match 'Bakersfield'. Create a report with only the Bakersfield entries. Make the report look nice and copy it to the PowerPoint presentation as slide #6

You are done with slide #6.
Save your PowerPoint Presentation. You should have 6 slides for the final. You are done with the final.



Addendum:

How to capture a screen picture of your form

This will work on the lab computers and on most other computers. When you have your form finished you will take a 'screen shot'. This takes a picture of everything on your screen. To do this press ctrl + 'Print Screen'; make sure the form is completely visible. On some computers it is ctrl + prtsc. The print screen button is usually in the upper right corner of the keyboard. Next press ctrl + esc and type 'Paint' it will be highlighted and click enter. The paint program will appear. If that does not work go to Start >> all programs >> type 'Paint' in the input box.

Go to the 'Paste' tab drop down menu (upper left) and click 'Paste' you will see a picture of your screen. Next click on the 'Select' button with the dotted rectangle. The cursor will become crosshairs. Drag a rectangle around your form so it looks like the one above but with the different title. Click 'Crop'. Go to the upper left corner of 'Paint' and click the dark blue dropdown menu and save the cropped image. Paste it into the proper PowerPoint slide.

What To Submit To Your TA

In a single email, send your PowerPoint presentation 'final.ppt' as an attachment to your TA. Do not attach any of the other files. Put your name and last 4 digits of your ID in the subject line of the email.