1.
Spreadsheet
Create a spreadsheet to calculate the class grade for at least four people. The
spreadsheet must include:
· Calculations for both midterm average and homework average, in hidden columns
· An overall score calculation that uses the hidden calculations for midterm and homework
· A nested-IF statement to assign a letter grade, using 90%-80%-70%-60% cutoffs
· A calculation to determine what score is needed on the final exam to get an A (90%) for the course
·
Appropriate headings to
indicate where information goes
2.
Database
Create an Access database that contains information about a collection of your
choice. It should have one table, with at least twenty records and five fields
(not including an optional ID field) that are relevant to your collection. It
should also include:
· A query which searches for some criterion of your choice (e.g., searching for all songs by a particular artist, if your database contains music). It should not search for just one record.
· A report which lists all items in your collection, categorized by one of the fields, as appropriate (e.g., song list categorized by genre – rock, rap, classical, etc.)