Digital Technologies

Term Project – Summer 2022

(20% of your course grade – 120 points)

• A sports franchise that would be affordable for all age ranges

1. Create an excel workbook and insert numerical data relating to your project (Please make sure you have at least 10 rows in your worksheet to make the calculations you do useful). The excel worksheet should have the following:
   1. Insert your name and date in the Header/Footer region of the workbook – the header/footer should appear in all worksheets in the work book. Please check here https://excel.tips.net/T002600_Putting_Headers_and_Footers_On_Multiple_Worksheets.html(Links to an external site.) for how to do this or refer to Chapter 1 of your custom Pearson book.
   2. Insert numerical data in the workbook to enable you to use at least two of the following functions: sum, min, max and average functions.
   3. Use the if function to format at least one column
   4. Adjust the width and height of columns and rows to allow display of data correctly.
   5. Format the numerical cells so that they display the correct units. For example, if it is a dollar amount you display, it should be formatted accordingly, rounded to 2 decimal places.
   6. Insert a title for your worksheet and center it across your data
   7. Using formatting features such as Bold to highlight title, column headings, totals etc.
   8. Minimize the usage of fonts to only two types and 2 sizes.
   9. Create a 3-D column chart on a new sheet (Here again choose data that will lend itself well to be represented in a 3D chart in addition to being relevant to your project).
   10. Select the appropriate ranges for the chart.
   11. Insert an appropriate title for the chart
   12. Rename this sheet to CHART DISPLAY
   13. Save the workbook with your last name as the name of your file
2. Create an Access database that stores data about your project topic. Include the following in your Access database:
   1. You must have a minimum of 2 tables. The relationships between them should be set up in the relationship window. Please note that you should set the referential integrity and at least the cascade update options between related tables .One table should have at least 10 records and the second table can have between 5 and 10 records.  These numbers are provided as a guide for you taking into account that the tables will have a one-to-many relationship.  This would ensure that you will have some output when you run your queries or your reports. If your project has more records that is fine.
   2. Create at least 2 queries:
      1. A query using the criteria and sort feature.
      2. A join query i.e., a query that gets data from at least 2 tables
   3. Create at least 2 reports based on queries or tables making sure that the report will be useful to you in making decisions.
   4. Create at least two forms for display and data entry based on the tables in your database. The forms should have the same look and feel.
   5. Save the database with your last name.