Project #87407 - General Education Project

Objective: The purpose of this assignment is to verify that you can perform basic tasks using a general purpose programmable device (also known as a computer). Use a computer to input data, manipulate data using word processing, spreadsheet, database and presentation software, and create appropriate information output for a defined problem.

  1. You will create a small slide presentation, the formatting to include slide layout, font styles and sizing, line spacing and header/footer; insert appropriate clip art as directed and animate slide content. 
  2. You will create a small and well formatted Word document consisting of a header, body, footer and references.
  3. You will create a spreadsheet and link it to the Word document.
  4. You will import data from the spreadsheet into the Access database and create queries to extract meaningful information.

Description:

  1. Prepare a list of your 20 favorite movies in a spreadsheet processor. Include the title, director, release year, rating (0-100), primary genre, budget and runtime of the movie. Build a chart with movie titles as an X axis and budget as a Y axis. Save this file as CS102_Project_YourUserName.xlsx
  2. Create a text document with a short description of your favorite movie. Insert (link or embed) a previously created table and a chart into your document. If necessary, change page orientation to Landscape Add your name to the header of the document. Save this file as CS102_Project_YourUserName.docx
  3. Create a presentation about the cast of your favorite movie. Your presentation must have at least three slides with different layouts (Title, Title and content, Two-content layout). Add slide numbers and your name to all slides, except title slide. Insert a previously created table into the content section of the “Title and content” slide. Add a clip art or an image to one panel of a two-content slide and a list of actors to another. Add animation effect to items of your list and transition effect(s) to the whole presentation. Apply a theme of your choice to the whole presentation. Save this file as CS102_Project_YourUserName.pptx
  4. Create a database with one table and add fields Title, Director, Year, Rating, Genre, Budget and Runtime to it. Change data types of the fields in the following way: Title, Director, and Genre must be of type Text; Year, Rating, and Runtime must be of type Number; Budget is Accounting. Import data from the previously created spreadsheet and append records to the table. Add another field (calculated Yes/No), and name it Classic. The value in this field must become true (yes), if a movie was released prior to the year of your birth. Create a simple query that returns a title, genre, and runtime of all movies shorter than 140 minutes. Save this file as CS102_Project_YourUserName.accdb

Subject Computer
Due By (Pacific Time) 10/16/2015 12:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy