Computer Science homework help. This module includes the following four projects to be completed on your PC and Uploaded into your
EagleOnline/Canvas course to be graded by your professor:
• Part 1 – PPT Project: This project includes a PPT presentation based on the topic provided to you by
your instructor.
• Part 2 – WORD Project: This project is based on Word modules.
• Part 3 – EXCEL Project: This project is based on Excel modules.
• Part 4 – ACCESS Project: This project is based on Access modules.
Perform the steps in the order listed. Check your work before submitting
(Print this sheet if needed)
NOTE: Make sure to view the (18PR) PPT Sample Solution.pdf link within this module to get some ideas on
how to incorporate the features listed below into a PPT presentation.
Steps Part 1 – PPT Project Instructions Points
1.
Create a new PowerPoint presentation file on your PC (or flash drive) named
18PR_ppt_LastFirst, where LastFirst is your actual Lastname and Firstname (For example, if
your name is Mary Smith, you will name the file 18PR_ppt_SmithMary)
1
2.
TOPIC for PowerPoint Project Check with your Instructor
Some rules to follow in creating your presentation along with some suggestions:
a. Do not use foul language (keep it clean)
b. Do not make sexual innuendoes
c. Keep it “G-rated” (something you could have kids to read)
d. Try to “teach” or “inform”
1
3. Presentation should contain no less than 10 and no more than 20 slides. 1
4.
Use a template or a theme.
For Templates: Click on File/New, and then you can select PowerPoint presentations and slides,
Sample Templates, or you can enter a module in the “Search Office.com for Templates” box to
search for various templates (though that will also give you invitations, and all sorts of other
things)
1
5.
Use at least 3 slide layout choices. You must use at least:
a. 1-Title Slide (this is to be your first slide)
b. 1-Title and Content Slide
c. 1-Two Content Slide (any type of two content slide)
2
6.
Follow the 7 x 7 rule
a. 7 x 7 rule means do not exceed 7 words per line, and 7 lines per slide.
b. Follow the rule for the most part (exceptions here and there are fine).
1
7. Adjust font sizes and colors as appropriate. It should be easy to read. For example, do not use a
yellow font on a white background. 1
Page 2 of 20
Steps Part 1 – PPT Project Instructions Points
8.
Create an Overview slide. That is, after the first slide (title slide), the next slide should be titled
Overview. It should contain a list of all the slides in your presentation. This gives the audience an
overview of the presentation.
1
9.
Add speaker notes to your Overview slide.
Remember, this is why the 7×7 rule works. Use speaker notes when you want to convey more
information than is on the slide. Print using Notes Pages, and then make sure and “talk” about
“your notes” during your presentation!
1
10.
Using Graphics Effectively:
a. Insert at least 1 “Online Picture” and resize (if necessary)
b. Change the Picture Style of the picture!
2
11.
a. Insert a shape into a slide
b. Enhance your shape by adding color and using a shape style.
c. Now add text to your shape by adding a text box on the shape.
3
12. Create a SmartArt on at least 1 slide 2
13. Create a Table in at least 1 slide 2
14.
The last slide of your presentation should be titled: “Contact Information”. This is a slide will give
your audience information on how to get in contact with you at a later time, if necessary. Your
NAME, Your PHONE, and EMAIL must be on this slide (Note: you can put a fake phone number
and email if you like).
2
15. Apply a transition to ALL slides. You can use the same transition on all slides, or a different
transition for each slide. 1
16.
Include (on all slides) a footer that includes:
a. The date
b. A slide number
c. Footer text of: By: Firstname Lastname. Replace the word Lastname with your last name
and replace Firstname with your first name. For example, if your name is Tom Jones, then
your footer text would be: By: Tom Jones.
d. Check the box so that the footer does not show on the title slide!
2
17. Be sure to check the presentation for spelling errors. 1
18.
• Save and Close the PowerPoint presentation.
• You may now proceed to word project instructed below. 0
TOTAL POINTS 25
NOTE: Make sure to view the (18PR) PPT Sample Solution.pdf link within this module to get some ideas on
how to incorporate the features listed above into a PPT presentation.
Page 3 of 20
Steps Part 2 – WORD Project Instructions Points
19.
Create a new Word document on your PC (or flash drive) named 18PR_word_LastFirst, where
LastFirst is your actual Lastname and Firstname (For example, if your name is Mary Smith, you will
name the file 18PR_word_SmithMary)
1
20.
Enter the following text into your empty, newly created Word file:
2
21.
Insert a Footer into the document with Your Name in the left section, today’s date in the center
(choose any style but make sure it is NOT automatically updated) then, tab to the right section and
insert a Page Number in the Current Position, choosing Accent Bar 1 style (see image below).
Note: It is very important to choose Current Position after you select the Page Number drop-down
arrow.
2
22.
Add 4 blank lines into your file as follows (see image below):
a. Move your cursor to the end of the second paragraph, Part 1: PowerPoint, and then press
Enter to add a new blank line.
b. Add three more new blank lines by pressing Enter after the following three paragraphs:
Part 2: Word
Part 3: Excel
Part 4: Access
1
Press [Enter] key here
Page 4 of 20
Steps Part 2 – WORD Project Instructions Points
23.
Add a heading title to your file as follows (see image below):
a. Move your cursor to the top of the document by pressing Ctrl-Home and then Enter to create
a new blank line at the top of the file.
b. Press Ctrl-Home again to move to the top of the file and then enter the following text: BCIS
PROJECT SUMMARY
c. From the Home menu, in the Styles group, change the style of the heading text to the
Heading 1 style.
2
24.
Apply the Heading 2 style to the following four paragraphs (see image below):
Part 1: PowerPoint
Part 2: Word
Part 3: Excel
Part 4: Access
2
Page 5 of 20
Steps Part 2 – WORD Project Instructions Points
25.
Modify the Heading 1 and Heading 2 styles:
a. Modify the Heading 1 style to be bold and centered.
b. Modify the Heading 2 style to the Black, Text 1 color, and underlined.
2
26.
Set the Before and After paragraph spacing:
a. Move your cursor to the first body paragraph of the document, starting with: This document
will contain
b. On the Layout tab, in the Paragraph group, set the Spacing Before and the Spacing After to
12 pt.
At this point, the text in your document should look as follows (Note: You may have one or two blank
lines at the end of the document. Either is fine.).
2
Page 6 of 20
Steps Part 2 – WORD Project Instructions Points
27.
Insert a picture into your word document as follows:
a. Move the cursor to the blank line after: Part 1: PowerPoint
b. Insert Online Pictures of your choice in into your Word document at the current location.
c. Resize the image to have a Shape Height of 2”.
At this point, your document should look similar to the following image (though the image will be
image of your choice):
2
28.
Create tabs as follows:
a. Move the cursor to the blank line below Part 2: Word
b. Enter the following text: The following is a list of all the files in the Project and then press
Enter.
c. With the insertion point (cursor) on the new blank line, set the following tabs:
i) Left Tab at 1″
ii) Center Tab at 3″
iii) Right Tab at 5.5″
iv) Press the Tab key to position cursor at the first tab stop (1″) and start entering the
text shown in the image below making sure to:
2
Page 7 of 20
Steps Part 2 – WORD Project Instructions Points
i. Enter the text at the appropriate tabs
ii. Use the actual filenames, with your name included as part of the file names
29.
Format the text as follows:
a. Select the text: The following is a list of all the files in the Project
i) Center the text
ii) Apply the Cambria font with a 16pt font size
b. Select the next line of text: Application File Extension
i) Underline the text
2
Page 8 of 20
Steps Part 2 – WORD Project Instructions Points
30.
Create a table:
a. Move the cursor to the blank line after Part 3: Excel
b. Insert a 6-row, 3-column (3×6) table
c. Apply any of the Grid Table 4 styles.
d. Set the Table Column Width for the three columns to 2” each.
e. Merge the cells in the first row
i) Enter the following text in the first row: Files in BCIS Project
ii) Center the text in the first row
f. Apply any shading to the second row
g. Add a border to the table
Enter the following data, where the file names are your actual filenames, with your names included
as part of the file names:
2
31.
Create a SmartArt as follows:
a. Move the cursor to the blank line after: Part 4: Access
b. Insert a SmartArt Graphic
i) Select the Accent Process SmartArt, in the Process category
ii) Select the ENTIRE SmartArt (not just one shape), and in the SmartArt Tools Format
tab, in the Size group, change the Height to 1” and the Width to 5”
iii) With the ENTIRE SmartArt still selected, in the SmartArt Tools Design tab, in the
Create Graphic group, Add Shape so there are 4 parts to the SmartArt
iv) Add the following text to the SmartArt (see image below):
2
32.
a. Move the cursor (Insertion Point) to the beginning of the line: Part 3: Excel and insert a Next
Page Section Break
b. Set the orientation of this second page to Landscape
1
Page 9 of 20
Steps Part 2 – WORD Project Instructions Points
33.
When completed your word document should look similar to the following:
34.
• Save and close the word document.
• You may now proceed to the Excel project instructed below. 0
TOTAL POINTS 25
Page 10 of 20
Steps Part 3 – EXCEL Project Instructions Points
35.
Create a new Excel workbook on your PC (or flash drive) named 18PR_excel_LastFirst, where
LastFirst is your actual Lastname and Firstname (For example, if your name is Mary Smith, you will
name the file 18PR_excel_SmithMary)
1
36.
a. Enter the following data into cell range A1:F7 into Sheet1 worksheet of your empty, newly
created Excel file
b. AutoFit the column width for columns A through F
Note: to AutoFit the columns, do not use the AutoFit Column Width menu option under Format.
Instead, select the entire Sheet1 worksheet by clicking the diagonal down arrow 1
(left of column A)
and simply position the mouse over the column line in the column headers, between any two
columns so the cursor becomes a double headed arrow 2
and double-click so all columns will AutoFit
at the same time.
Below is a sample of what your file should look like at this time
2
37.
Rename and Copy the worksheet as follows:
a. Rename the Sheet1 worksheet to: Products
b. Right-click the Products worksheet tab and select Move or Copy from the worksheet menu.
c. The Move or Copy dialog box will appear. Under Before sheet: select (move to end) to
place the worksheet to the right of the existing worksheet.
d. Check the box next to Create a copy, then click OK.
e. Rename the new worksheet to: Updated Products
2
38.
In the Updated Products worksheet, add the following column headings:
a. In cell G1 enter Profit per Unit
b. In cell H1 enter Possible Discount
c. In cell I1 enter Quantity
d. In cell J1 enter Net Income
2
39.
In cell G2, insert a formula to calculate the difference between the UnitPrice and the UnitCost.
a. Use the fill handle to copy this formula down to row 7.
NOTE: Verify formula result with the image in step 48 below
2
40.
In cell H2, insert an IF function that displays a value of “Y” (when true) or “N” (when false) if the
UnitCost (E2) is greater than or equal to 100.
a. Use the fill handle to copy this formula down to row 7.
2
1
2
Page 11 of 20
Steps Part 3 – EXCEL Project Instructions Points
NOTE: Verify function result with the image in step 48 below
41.
Enter the following data:
a. In cell I2 enter 100
b. In cell I3 enter 150
c. In cell I4 enter 200
d. In cell I5 enter 20
e. In cell I6 enter 10
f. In cell I7 enter 1
g. In cell I9 enter Discount:
h. In cell I10 enter Highest Value:
i. In cell I11 enter Lowest Value:
j. In cell I12 enter Sum:
k. In cell I13 enter Average:
l. In cell J9 enter 5
NOTE: Verify data entered with the image in step 48 below
2
42.
Format as follows:
a. Autofit Column Width for column I
b. Format J9 to Currency Number Format with 2 decimal places
c. Select row 1 and Wrap Text which will display column headings in G1, H1 and J1 as multiple
lines within the cell.
d. Select the column headings A1:J1 and apply Cell Style of Heading 3.
NOTE: Verify formatting with the image in step 48 below
2
43.
In cell J2, insert an IF function that calculates the value for Net Income as follows:
a. If the Possible Discount (H2) is equal to “Y”,
i) (true) The gross income is the (Profit per Unit-Discount) multiplied by the Quantity
(G2-$J$9)*I2
ii) (false) Or else, the gross income is the Profit per Unit multiplied by the Quantity.
b. Use the fill handle to copy this formula down to row 7.
c. Format the cells in J2:J7 to Currency Number Format with 2 decimal places
NOTE: Verify function result with the image in step 48 below
2
44.
Use appropriate functions to do the following:
a. In cell J10 enter a function to display the highest value for the range J2:J7
b. In cell J11 enter a function to display the lowest value for the range J2:J7
c. In cell J12 enter a function to sum the cells in the range J2:J7
d. In cell J13 enter a function to average the cells in the range J2:J7
NOTE: Verify function results with the image in step 48 below
2
45.
Insert a 3-D Clustered Column chart (see image in step 48 below) as follows:
a. Simultaneously select the following data: B1:B7, D1:D7, E1:E7, G1:G7, I1:I7
b. Insert a 3-D Clustered Column chart
c. Move and resize the pie chart so that it is located in cells B9:G23
d. Change the Chart Title to Excel Project
e. Change the Chart Style to Style 6.
2
Page 12 of 20
Steps Part 3 – EXCEL Project Instructions Points
f. Remove the data labels as follows:
i) On the Chart Tools Design tab, in the Chart Layouts group, click Add Chart Element,
click Data Labels, and select None.
46.
Change the Page Layout of the Updated Products worksheet so that it (see image in step 48 below):
a. Is set to Landscape orientation and
b. Will FIT to one Page, and
c. Has a Customer Header with Your Name in the left section, Sheet Name in the center
section, and Current Date on the right section, and
d. Will print with Gridlines.
e. Will print with Row and column headings
2
47.
When completed, the Updated Products worksheet should look similar to the following:
Page 13 of 20
Steps Part 3 – EXCEL Project Instructions Points
48.
Creating a new worksheet and using VLOOKUP:
a. Copy the data from the Products worksheet to a new worksheet named: Vlookup
i) Note: See step 38 for information on how to copy data from one worksheet to another
b. Enter the following text
i) In cell G1: Handling Fee
ii) In cell A12: Category
iii) In cell A13: AT
iv) In cell A14: DE
v) In cell A15: MD
vi) In cell A16: WD
vii) In cell B12: Handling Fee in Dollars
viii) In cell B13: 0
ix) In cell B14: 2
x) In cell B15: 5
xi) In cell B16: 10
c. AutoFit the column width for column G
d. In cell G2, insert a VLOOKUP function that determines the correct handling fee as follows:
i) The function will refer to the Lookup_value in C2
ii) The function with use the Table_array A12:B16 (though it will need to be absoluted so
that each row will reference the same table array once it’s copied)
iii) The function will take the value from the table array from column 2
iv) The function must contain a Range_lookup of FALSE so that the categories are identical
matches between the table array and the main data (if not, AT could be matched in
more than one place … ask your instructor to explain this)
e. Use the fill handle to copy this formula down to row 7.
f. Format G2:G7 to Currency Number Format with 2 decimal places
2
49.
• Save and close the excel workbook.
• You may now proceed to access project instructed below. 0
TOTAL POINTS 25
Page 14 of 20
Steps Part 4 – ACCESS Project Instructions Points
50.
Start Access. Create a blank new access database file on your PC (C:\ drive) named
18PR_access_LastFirst.accdb, where LastFirst is your actual Lastname and Firstname (For
example, if your name is Mary Smith, you will name the file 18PR_access_SmithMary)
1
51.
Close the default Table1 that gets created in the above new database file to delete it.
(Hint: You can click here to close the table. This will delete the table. You can also right-click on the
Table1 table name and choose Delete).
1
52.
Create a new table using the Table Design button.
(Hint: On the Create tab, In the Tables group, select Table Design. This will open a new table –
Table1 in Design View)
1
53.
Enter the following six Field Names and corresponding Data Types to the Table1 created above.
1
Page 15 of 20
Steps Part 4 – ACCESS Project Instructions Points
54.
Using the design information below, click on each Field Name, and adjust the Field Properties of
each of the following four Field Names highlighted below.
Field Name Field Properties
Spokesperson Field Size: 3
Required: Yes
Set this field as the PRIMARY KEY
Firstname Field Size: 15
Lastname Field Size: 25
Career
Available
Gender Field Size: 1
Hint:
a. When you click on each of the field names in the upper half of the screen, their respective
Field Properties appear in the bottom half of the screen (see image below).
b. The Primary Key attribute is set in the Ribbon area, or by right-clicking on the Field Name
and selecting Primary Key (see image below).
2
55. Save the table with the name: Spokespeople 1
56.
Switch to Datasheet View of the Spokespeople table and enter the following data/records:
(Hint: To switch to Datasheet View, click the View button in the Views group of the Design tab) 2
a
b
Page 16 of 20
Steps Part 4 – ACCESS Project Instructions Points
Save and Close the Spokespeople table.
57.
Follow step 53. to create another new Table in design view and enter the following Field Names and
Data Types and set the corresponding Field Properties:
Field Name Data Type Field Properties
ProductID Number Field Size: Long Integer
Required: Yes
Set this field as the PRIMARY KEY
ProductName Short Text Field Size: 30
Category Short Text Field Size: 2
UnitPrice Currency Currency with 2 decimal places
UnitCost Currency Currency with 2 decimal places
Spokesperson Short Text Field Size: 3
2
58. Save the table with the name: Products 1
59.
a. Switch to the Datasheet View of the Products table and enter the following data/records:
b. Save and Close the Products table.
1
60. Confirm that the Products and Spokespeople tables are closed. If not, save and close them. 0
61.
a. On the Database Tools tab, in the Relationships group, click Relationships.
b. Create a one-to-many relationship between the Spokesperson field in the Spokespeople table
and the Spokesperson field in the Products table.
c. Enforce referential integrity between the two tables.
Close the Relationships window, saving the changes.
(Refer to the image below for the Relationships created)
1
Page 17 of 20
Steps Part 4 – ACCESS Project Instructions Points
62.
Create a Simple Query Using the Query Wizard:
a. On the Create tab, In the Queries group, select Query Wizard.
b. Create a simple query
c. The query should be based on the Spokespeople table
d. For example, once the Simple Query Wizard dialog box opens, MAKE sure and change the
table under Tables/Queries to: Table: Spokespeople
e. Include the following fields in this order: Firstname, Lastname, Career, Gender
f. Save the title of the query as Music AND Female Query and click Finish.
g. Switch to Design View and set the Criteria to select only those records with whose Career is
in Music AND whose Gender is a F (Female).
h. The Gender field should not appear in the query results (i.e., make sure the Show check box
is not checked for the Gender field).
Run, Save and Close the query.
(Refer to the image below for Music AND Female Query Design View results)
(Refer to the image below for Music AND Female Query Datasheet View results)
2
63.
Using the Query Wizard, create another simple query:
a. The query should be based on the Spokespeople table.
b. Include the following fields in this order: Firstname, Lastname, Career
c. Save the query as Acting OR Music Query.
d. In Design view, set the Criteria to select those records with whose Career is in Acting OR
Music:
2
Page 18 of 20
Steps Part 4 – ACCESS Project Instructions Points
i) Type “Acting on Criteria line under Career, and then
ii) Type “Music” right below it on the or: line.
Run, Save and Close the query.
(Refer to the image below for Acting OR Music Query Datasheet View results)
64.
Create another simple query based on both the Spokespeople table and Products table.
a. Start by basing the query on the Spokespeople table.
i) Include the Career field from the Spokespeople table.
b. In the same window, change the table name under the Tables/Queries field to the Products
table.
i) Include UnitPrice and UnitCost fields from the Products table.
ii) Note: Three fields should now be displayed in the right-most box, under Selected Fields:
Career, UnitPrice and UnitCost
c. Choose Detail query, and then save the title of the query as Totals Query.
d. Switch to Design view of the query and click the Totals button, located on the Design tab, in
the Show/Hide group.
i) Make sure that the Career field is set to Group By in the Total row.
ii) Set the Unit Price field to Sum in the Total row,
iii) and set the Unit Cost field to Avg in the Total row.
e. Run the query.
f. Resize the fields to show all of the contents (headings/data).
Save and Close the query.
(Refer to the image below for Totals Query result)
2
65.
Using the Report Wizard, create a new report based on the Spokespeople table.
a. Include all fields from Spokespeople table.
b. Group by Career.
c. Sort the records by Firstname in ascending order.
d. Use Stepped layout,
1
Page 19 of 20
Steps Part 4 – ACCESS Project Instructions Points
e. Landscape orientation,
f. and check to box to adjust field width so that they fit on one page.
g. Save the title of the report as Spokespeople Report and then click Finish.
66.
Close the Print Preview mode and then switch to Layout View, if so desired (it’s easier than Design
View).
a. Change the title of the report to Your Name Spokespeople Report (Where Your Name is
your actual Firstname Lastname, ex: Mary Smith Spokespeople Report).
b. Also, change the report title’s font to Tahoma,
c. font color to Purple and
d. font size to 28.
Save and Close the report.
(Refer to the image below for Spokespeople Report created)
1
67.
Using the Form Wizard, create a new form based on the Products table. Include all fields from
Products table. Use Columnar layout. Save the title of the form as Products Form and then click
Finish.
1
68.
With the Products Form opened add a new record with the following data (make sure to enter your
actual Fullname for ProductName):
Save and Close the Products Form.
1
Page 20 of 20
Steps Part 4 – ACCESS Project Instructions Points
69.
Open the Products table and Sort it by Category field in ascending (A to Z) order. Save the change.
(Refer to the image below for Products table sorted)
1
70.
You are almost finished!! You have two more steps:
a. In Backstage View, Compact and Repair Database, and then
b. Close the database and exit out of Access.
71.
You may now proceed to your Canvas course to upload/submit the following project solution files
saved on your PC:
o 18PR_ppt_LastFirst.pptx
o 18PR_word_LastFirst.docx
o 18PR_excel_LastFirst.xlsx
o 18PR_access_LastFirst.accdb
TOTAL POINTS 25
