excel assignment

Description:

1. Use a spreadsheet processor to prepare a list of 20 movies from year(s) ending with the same digit as your student ID

1. Student ID ends with 0 - movies released in 2010, 2000, 1990, 1980, 1970 etc.

2. Student ID ends with 1 - movies released in 2011, 2001, 1991, 1981, 1971 etc.

3. Student ID ends with 2 - movies released in 2012, 2002, 1992, 1982, 1972 etc.

4. Student ID ends with 3 - movies released in 2013, 2003, 1993, 1983, 1973 etc.

5. Student ID ends with 4 - movies released in 2014, 2004, 1994, 1984, 1974 etc.

6. Student ID ends with 5 - movies released in 2015, 2005, 1995, 1985, 1975 etc.

7. Student ID ends with 6 - movies released in 2016, 2006, 1996, 1986, 1976 etc.

8. Student ID ends with 7 - movies released in 2007, 1997, 1987, 1977, 1967 etc.

9. Student ID ends with 8 - movies released in 2008, 1998, 1988, 1978, 1968 etc.

10. Student ID ends with 9 - movies released in 2009, 1999, 1989, 1979, 1969 etc.

2. Use a spreadsheet processor to manipulate collected data

1. Include the title, director, release year, rating (0-100), primary genre, budget, and running time of each movie. Use open sources to find the required information and adjust ratings, if necessary.

2. Convert the range of cells to a table with headers and choose an appropriate color scheme for the table.

3. Use a total row formula to calculate average budget and average running time of all movies on your list.

4. Add a new column, Price per Minute, and use a formula to calculate price of one minute of each movie.

5. Change formatting of values in the Budget and Price per Minute columns to Accounting.

6. Sort records in the table by the price of a minute, largest to smallest.

7. Use conditional highlighting to mark movies of the same genre as the movie with the highest price per minute value.

8. Use conditional highlighting to mark top 5 movies (those with the highest value in the Rating column).

9. Build a chart with movie titles as axis labels and budgets as values.

10. Build a chart including movie titles as horizontal axis labels, budgets as a column chart and a primary vertical axis, and rating as a line chart and a secondary vertical axis. Use your name as a title of the chart.

3. Use a text editor to describe your collected data (any 5 movies)

1. The text document must have a title (e.g. Top Movies), an introduction, a separate section for each of the 5 selected movies, an automatically generated table of contents, and an automatically generated bibliography.

2. The main title, section headers, and the main document text must be formatted using proper and consistent styles.

3. Add previously created charts to the document. Inserted charts must be editable objects, rather than pictures.

4. Find short description (plot summary or synopsis) of each of the 5 movies online and add it to its respective section. Added text must not have any formatting of the original web page.

5. Add references (citations) to the original descriptions (web pages) using APA formatting style. Total 5 citations.

6. Add at least two pictures (movie posters) to the document, making sure a picture fits its respective section and does not interfere with the rest of the text and headings.

7. Add automatically generated table of contents.

8. Add automatically generated bibliography. Use APA formatting style.

9. Change the document background (color or border).

10. Add page numbers as a footer of the document and your name as a header.

4. Use presentation software to present your collected data

1. Your presentation must have at least three different layouts (e.g. Title, Title and content, Two Content).

2. The presentation must have a separate slide for each of the 5 selected movies.

3. One of the slides must contain the original table with all 20 movies and their properties.

4. Two slides must contain previously created charts.

5. At least one slide must contain text and an animated list (e.g. cast members).

6. At least one slide must contain text and a picture (e.g. a movie poster).

7. One slide must contain previously generated list of references (bibliography).

8. Add any design theme to the presentation.

9. Add transition effect to the whole presentation.

10. Add page numbers and your name to all slides, except the title slide.