CGS 1000 Fall 98 Homework Notes - Anne Parker's Classes

CGS 1000: Computer Information Systems
Homework Notes Fall 1998
Anne Marshall Parker, Instructor

Microsoft Excel Notes

Tutorial 1 This chapter is an overview of the process of spreadsheeting, so we'll only complete the Main Case. It shouldn't cause any problems and will produce only 1 printout.

Tutorial 2 Main Case:
Page E 2.36 - Be sure to study "Displaying and Printing Worksheet Formulas" carefully. It will be on the test!
Case 3:
Step 2: Be sure to use the appropriate absolute cell reference in the formula in 2(b). This also will be on the test!
Step 7: After printing the worksheet, display and print the worksheet formulas as described in the Tutorial.
Step 8: SKIP this step

Tutorial 3 Main Case: Fine the way it is; no changes
Case 3:
Step 4: Here is what the boss wants: Format all the Tons columns for commas, one decimal place. Format the Dollar Value columns for Currency, 2 decimal places. Add a thick bottom border under the Tons and Dollar Value column headings. Title Lines (State Recycling Project, Material Reclamation 1999): Bold, 14-point font, centered across the worksheet, enclosed in a thick border, shaded. Center the column headings. Shade the Row titles in column A.
Step 7: After printing the worksheet, display and print the worksheet formulas as described in Tutorial 2.
Step 8: SKIP
Step 9: SKIP

Tutorial 4 Main Case:
Page E 4.33: Print the "Sales by Stove" chart after you complete it.
Case 1:
Step 10: Print the entire Units Sold worksheet, not just the chart.

Excel skill set On Practical Test 2 I will ask you to demonstrate the following skills, using a disk and files created by me:
-Create simple formulas similar to those in the text
-Use the following functions: SUM, AVERAGE, MAX, MIN
-Copy formulas to multiple cells, using both Relative and Absolute cell references
-Format a worksheet, including: Inserting/Deleting rows & columns, widening columns, changing fonts and sizes of text, formatting numbers, aligning text, inserting borders
-Display and Print worksheet formulas
-Use the following Page Setup options: Landscape orientation, Fit to 1 page, Custom Header/Footer, Center Horizontally and Vertically, print with and without gridlines, print with and without Row and Column Headings
-Create Column, Bar, Pie and Line charts using the techniques described in Tutorial 4.

Microsoft Access Notes

Tutorial 1 Main Case: No changes; complete as described in the text.
Case 1: No changes; complete as described in the text.

Tutorial 2 Main Case: No changes; complete as described in the text.
Case 1: No changes; complete as described in the text.

Tutorial 3 Main Case: Print query results for the queries below, in addition to those specified in the text:
1) High Invoice Amounts query after step 6 on page 3.24. Print in landscape orientation so everything fits on 1 page.
2) Unpaid January Orders query after step 6 on page 3.25. Print in landscape orientation.
3) Unpaid With Late Charge query after step 8 on page 3.31.
4) Invoice Statistics query after step 13 on page 3.33.
5) Invoice Statistics by Billing Date after step 5 on page 3.34.
Since the text calls for printouts on pages 3.17 and 3.27, you should have 7 printouts when you finish. Please identify each, and order them by Page #.
Case 1: Add two more steps to the assignment.
Step 7: Create a query based on the Store and Job tables. Display the StoreName, Location, Contact, Extension, and Position fields. Display only those records with Location = D1 or Position = Salesclerk. (Your answer should display 4 records). Save the query as OrQuery, then print the datasheet.
Step 8: Create an aggregate query which counts the number of jobs in the Job table grouped by Store. Save the query as Jobcount by Store and print the datasheet.

Access Skill Set These are the skills which will appear on the practical test on Microsoft Access:
-Add records to a table, Modify records in a table, and Delete records from a table.
-Print tables and queries
-Join two tables based on a common field.
-Create a table and assign it a primary key.
-Import data from another database.
-Modify the structure of an access table.
-Create all the types of queries covered in Tutorial 3: Exact Match, Range of Values, And, Or, Calculated, Aggregate, Record Group. Of course, you must be able to select fields, resize columns, and save the query under an appropriate name.

Return to CGS 1000 Main Page
Return to Anne Parker's Home on the Web

CGS 1000: Computer Information Systems Homework Notes Fall 1998 Anne Marshall Parker, Instructor

Microsoft Excel Notes
Tutorial 1	This chapter is an overview of the process of spreadsheeting, so we'll only complete the Main Case. It shouldn't cause any problems and will produce only 1 printout.
Tutorial 2	Main Case: Page E 2.36 - Be sure to study "Displaying and Printing Worksheet Formulas" carefully. It will be on the test! Case 3: Step 2: Be sure to use the appropriate absolute cell reference in the formula in 2(b). This also will be on the test! Step 7: After printing the worksheet, display and print the worksheet formulas as described in the Tutorial. Step 8: SKIP this step
Tutorial 3	Main Case: Fine the way it is; no changes Case 3: Step 4: Here is what the boss wants: Format all the Tons columns for commas, one decimal place. Format the Dollar Value columns for Currency, 2 decimal places. Add a thick bottom border under the Tons and Dollar Value column headings. Title Lines (State Recycling Project, Material Reclamation 1999): Bold, 14-point font, centered across the worksheet, enclosed in a thick border, shaded. Center the column headings. Shade the Row titles in column A. Step 7: After printing the worksheet, display and print the worksheet formulas as described in Tutorial 2. Step 8: SKIP Step 9: SKIP
Tutorial 4	Main Case: Page E 4.33: Print the "Sales by Stove" chart after you complete it. Case 1: Step 10: Print the entire Units Sold worksheet, not just the chart.
Excel skill set	On Practical Test 2 I will ask you to demonstrate the following skills, using a disk and files created by me: -Create simple formulas similar to those in the text -Use the following functions: SUM, AVERAGE, MAX, MIN -Copy formulas to multiple cells, using both Relative and Absolute cell references -Format a worksheet, including: Inserting/Deleting rows & columns, widening columns, changing fonts and sizes of text, formatting numbers, aligning text, inserting borders -Display and Print worksheet formulas -Use the following Page Setup options: Landscape orientation, Fit to 1 page, Custom Header/Footer, Center Horizontally and Vertically, print with and without gridlines, print with and without Row and Column Headings -Create Column, Bar, Pie and Line charts using the techniques described in Tutorial 4.
Microsoft Access Notes
Tutorial 1	Main Case: No changes; complete as described in the text. Case 1: No changes; complete as described in the text.
Tutorial 2	Main Case: No changes; complete as described in the text. Case 1: No changes; complete as described in the text.
Tutorial 3	Main Case: Print query results for the queries below, in addition to those specified in the text: 1) High Invoice Amounts query after step 6 on page 3.24. Print in landscape orientation so everything fits on 1 page. 2) Unpaid January Orders query after step 6 on page 3.25. Print in landscape orientation. 3) Unpaid With Late Charge query after step 8 on page 3.31. 4) Invoice Statistics query after step 13 on page 3.33. 5) Invoice Statistics by Billing Date after step 5 on page 3.34. Since the text calls for printouts on pages 3.17 and 3.27, you should have 7 printouts when you finish. Please identify each, and order them by Page #. Case 1: Add two more steps to the assignment. Step 7: Create a query based on the Store and Job tables. Display the StoreName, Location, Contact, Extension, and Position fields. Display only those records with Location = D1 or Position = Salesclerk. (Your answer should display 4 records). Save the query as OrQuery, then print the datasheet. Step 8: Create an aggregate query which counts the number of jobs in the Job table grouped by Store. Save the query as Jobcount by Store and print the datasheet.
Access Skill Set	These are the skills which will appear on the practical test on Microsoft Access: -Add records to a table, Modify records in a table, and Delete records from a table. -Print tables and queries -Join two tables based on a common field. -Create a table and assign it a primary key. -Import data from another database. -Modify the structure of an access table. -Create all the types of queries covered in Tutorial 3: Exact Match, Range of Values, And, Or, Calculated, Aggregate, Record Group. Of course, you must be able to select fields, resize columns, and save the query under an appropriate name.

Return to CGS 1000 Main Page Return to Anne Parker's Home on the Web