The final exam will be in different room: Tiernan Hall 106

Homework 14. Team work

This is not a real homework. I want you to complete all the missed homeworks and projects. An email was sent to each student taking this class telling which homeworks were submitted and graded. Please, use it to find out which homeworks you still have to do.

Homework 13. Team work

Due November 20
This tutorial "How to Make and Save a Filter" is here to help you with the first part of the homework. Click Here to download

Please, download the files below to your PC (Right click and select Save target as ...).
You may find useful printing hmw13.doc which contains instructions for this homework.
After completing homework please, print the report including names of team members who actually shared the team work.
Then submit printed report to the instructor for grading

Homework 13 step by step instructions
Database Cars.mdb
Picture for a form and a report ClassicCars.gif

Homework 12. Team work

Due November 13
Download a database file cs103.mdb (right click then Save Taret As ...) to your computer.
Using this database complete the following tasks:

1. Make a new query in design view selecting Contact Name, Address, City, Country and Phone from the table Customers.
Select only those records containing 555 anywhere in the phone number.
Save the query as Contacts555
Hint. Use Like "*555*" as a criterion.

2. Make a new query in design view. Add five tables: Customers, Orders, Employees, Order Details, Products.
Select ContactName from Customers, Title and LastName from Employees, OrderDate from Orders, ProductName from Products, Quantity from OrderDetails. Select only the orders made during 1997.
Save the query as Orders1997
Hint. Use Between #1/1/1997# And #12/31/1997# as a criterion.

3. Open the query created at the previous step (Orders1997) in the design view. Make it sorted by the ContactName in Descending order. Save the query as OrdersDesc.

4. Create a new form by using wizard. Add to the form all the available fields from the query Contacts555.
Use columnar layout, Expedition style. Save the form as Contacts555Form. Close the form. Open this form in the design view.
Change the text in the label "City" to "Town". Save changes. Close the form.

5. Create a new report by using wizard. Add to the report all the fields from the Orders1997 query.
Select option "How do you want to view your data?" by Employees. Group the report data by ProductName.
Sort the report data by ProductName in ascending order. Choose ALign Left 1 layout. Select Casual style.
Make "Orders made in 1997" to be the title of the report.

6. Send the databse to the instructor via email.

Homework 11. Team work

Due November 6
Please, download files containing assignmnents for each team (projects were taken from the second textbook Microsoft Office Access 2003 by S.Haag, J.Perry, M.Wells)
Right click on the file name and choose "Save target as ..."

Assignment for Team 1
Assignment for Team 2
Assignment for Team 3
Assignment for Team 4
Assignment for Team 5
Assignment for Team 6
Assignment for Team 7


After reading assignment for your team you will find out database files you need for completing this assignmnent. Please, look them up in this list and download to your PC (right click the file and choose "Save target as...")
ac04CurbsideRecycling.mdb
ac04IRI.mdb
ac04Lacrosse.mdb
ac04Merrill.mdb
ac04Populations.mdb
ac04Recruiting.mdb
ac04SportsPix.mdb
ac04TnT.mdb
ac04Tnt.tif
ac04USDA.mdb


If you experience any problems contact the instructor by email.

Homework 10. Personal homework

Due October 30
Page 474. Multiple choices. Question 2, 5, 6
Page 476. Excercise 2,3, 10.

Homework 9. Team work

Due October 23

National Construction Project

The National Federation of Home Builders (NFHB), a nationwide association of builders, is interested in studying the relationship between interest rates and the sales of new single-family homes in the United States. They have asked you to become involved in the project to gather and analyze data using Microsoft Excel. In addition, they would like you to graphically represent your findings using Excel charts that will be viewed on the association Web site.

Using your favorite Web portal, conduct an Internet search on economic data. The NFHB proposes using monthly data starting in January 1970. They recommend using New Single-Family Homes sales data from the U.S. Department of Commerce. (Note: Your liaison at NFHB mentioned that the Federal Reserve Board Web site might be a good source for the prime rate of interest data.) You can use this web site http://www.census.gov/const/www/newressalesindex.html or perform a web search using your favorite search engine.

1.      Create a new Excel workbook and save it as Nat_Construction(your_team).xls.
 

2.      Enter an appropriate title in the first row. Include your name and the date of your analysis. In addition, include at least the following categories for your monthly economic data:
 

1. Bank Prime Loan Rate

b.     New Single-Family Home Sales

Document the source, frequency, and unit of measure for both data series. Download both monthly data series into a worksheet entitled Sales & Rate Data. Remember your data should begin on January 1, 1970.

3.      Insert a chart sheet on a new worksheet displaying the correlation between the prime rate and new single-family home sales. Note: A second Y-axis can be useful when charting data series of differing magnitudes. Enter appropriate titles, subtitles, axis labels, and so on. Name the chart sheet Correlation Chart.

 

4.      Create a documentation sheet with the workbook title, your name, and an evaluation section for you to explain your findings. Name this sheet Documentation, and put it at the end of the workbook. Set the print area for the National Construction Project worksheet.
 

5.      The NFHB Webmaster needs the correlation chart saved as a Web page to be used on the association’s Web site. Save your chart sheet as HTML for this purpose.
 

6.      Delete all unused worksheets. Save the file, upload it to your team web site and send an email to your instructor telling the assignment has been done.

Homework 8. Team work

Due October 16
Read chapter 16.

1. Don't forget to save the results of your job after each step to prevent losing results.
2. Download the following file onto your computer: Orders.xls
   (Right-click on this link and select "Save target as" in the pop-up menu)
3. Rename Sheet1 as Orders
4. Delete Sheet2 and Sheet3
5. We wish to apply some formatting to Orders sheet. Insert a row above the row 1. Merge cells A1 through F1. Apply center alignment for this wide cell. Type "Orders October 2007" in this cell. Make this cell contents bold and underlined.
6.  Remove fill color from cells A2 through N2 (cells containing text Order ID through Ship Country). Make the contents of these cells bold.
7. Format cells H3 through H833 as currency type with two decimal spaces.
8. Format column D (Order Date) to be like this: Tuesday, October 9, 2007
9. Format Column E (Required Date) to be like this 10/9/2007
10. Format Column F (Shipped Date) to be like this October 9, 2007
11. Sort the data by the Freight in ascending order
12. Type Total in G833 cell
13. Insert summation formula into H833 cell calculating the sum of all the above cells.
14. Now, we will calculate the number of orders made by an employee King, Robert. Input the following formula into C833 cell:

=COUNTIF(C3:C832,"King, Robert")

15. Now, use the same idea to calculate the number of orders shipped via United Package. Copy the formula created at the previous step to G833 cell and change King, Robert to United Package. The result should be equal to 326. If something goes wrong feel free to use Excel Help by clicking F1 button.
16. Now, we would like to make the table a little better. Select the contents of the table and make all cell borders visible (they should be painted in black color).
17. At last, we would like to manage this cell better. Click B3 cell. Go to Excel main menu, click menu item Window, then click Freeze panes. Now, column A and rows 1 and 2 should be frozen when scrolling.
18. Save the results of your job and close the file.
19. Upload the file to the team web site.
20. Post the link to this file on the main page of the site.
21. Send the hyperlink to the page containing the reference to excel file to the instructor by email.

Homework 7. Team work

Due October 9
Read chapter 15.
To all the teams:
Choose a team name and post in on the team web-site.
Use website pricegrabber.com to create an Excel spreadsheet containing following columns:
1. Product Title
2. Product Vendor
3. Product Price
4. Hyperlink to product webpage

Highlight with yellow background the lowest price and with dark blue background and white font the highest price. Make all borders visible in your table. Calculate the total price (sumation of all prices), average price, minimum price and maximum price using formulas.
Fill the table with information about 25 products.
Team 1: Consumer Electronics
Team 2: Clothing
Team 3: Outdoor Living
Team 4: Jewelry & Watches
Team 5: Cell Phones, Plans, & Accessories
Team 6: Computers
Team 7: Musical Instruments

Homework 6. Team work

Due October 4
Read chapter 14.
Create a website on netfirms (or any other free web-hosting) and post there your team name, names and photos of all the team members.

Homework 5

Due October 2
Read chapter 13.
Page 398. Multiple choices. Question 5, 6, 10, 12
Page 399. Excercise 2
Page 400. Excercise 11

Homework 4

Due September 27
Create a free web hosting account at www.netfirms.com or any other web hosting. Upload the web page you created in the previous assignment to that account. Send the URL to your page to the instructor.
Please, use this step-by-step tutorial (click here)

Homework 3

Due September 25
Create a webpage using Microsoft Word or Microsoft FrontPage. We were discussing how to create a webpage using MS Word in class. MS FrontPage specially designed for web-page creation and it is more advanced. You'll receive extra points for using MS FrontPage. We discussed html tags in class. Knowledge of html tags is helpful for creating a webpage using MS Frontpage.

Requirements:
- insert at least one image;
- insert at least one table;
- insert at least one paragraph (<p>  … </p>);
- insert at least one horizontal line (<hr>)
- insert at least one header (<h2>   </h2>)
- insert at least two hyperlinks, one pointing to the NJIT main page (http://www.njit.edu) and the other one pointing to the course page (http://web.njit.edu/~or3/cs103.html)
Please, add to the page some text (it could be information about your favorite movie, favorite activity or field of study, etc.)

Homework 2

Due September 18
Read chapter 3 from the textbook.
Page 94: multiple choice 8, 10.
Page 95: short answers 10, 15.
Page 96: exercises 2, 4.

Homework 1

Due September 11
Read chapter 2 from the textbook.
Page 63: short answers 2, 7, 10, 11.
Page 64: exercises 1, 6.

• Introduction: what’s in the computer?
  
• Introduction to Computer Science
  
• Bits and Byte: Representing Information
  
• Number Systems
  
• How Computer works
  
• Algorithms
  
• Operating Systems
  
• HTML, MS EXCEL
  
• Databases: Information Storage, MS Access
  
• Network and Communication
  
• Security