Computer Science Projects

Coach Café The Coach Café is a small neighborhood café that serves vegetarian breakfasts and lunches. The owner of the café, Keith Watson, started the café with $50,000 of his own money. Now that he’s up and running, he realizes that he needs additional financing. His parents have offered to loan him an additional $50,000 to be repaid within five years. Keith needs to analyze the loan payments and terms to ensure he can make the payments required. He has started a workbook and asks you to complete a Loan Analysis and Amortization Schedule with data related to the loan. Start Excel and open Tutorial 8_Coach CafeLoan Analysis.xlsx. Save the spreadsheet as Tutorial 8_Last Name_Coach CafeLoan Analysis.xlsx. (Replace “Last Name” with your last name.) In the Loan Analysis worksheet, in the range C7:J10, enter or calculate the loan analysis data you will use as the basis for additional calculations. Kevin wants to borrow $50,000 over a period of 5 years and make 12 payments each year. ...

Analysis of Student Payments Mountainview Language School in Denver, CO, is a small school that provides language training in English, Spanish, and French to students from all over the world. The school keeps track of its student records in Excel. You’ve been asked to work with the current spreadsheet and improve it so that information and issues can be analyzed and tracked. You use advanced IF functions and a VLOOKUP table to calculate data related to student payments, and then you use the COUNTIF, SUMIF, and AVERAGEIF functions to analyze the payment data. Start Excel and open Tutorial 7_StudentAccounting.xlsx. Save the spreadsheet as Tutorial 7_Last Name_StudentAccounting.xlsx. (Replace “Last Name” with your last name.) In cell K4, add a new column called Owing. Note that the new column is formatted the same way as the rest of the table because the data is contained in an Excel table. In cell K5, enter an IF function that enters “Owing” in cell K5 if the value in cell J5 (Ba...

A Technology Budget SecureWorks Inc is a small computer security contractor that provides computer security analysis, design, and software implementation for the U.S. Government and commercial clients. SecureWorks competes for both private and U.S. Government computer security work by submitting detailed bids outlining the work the company will perform if awarded the contracts. Because all of the work involved computer security, a highly sensitive area, almost all of SecureWorks’ tasks require access to classified material or company confidential documents. Consequently, all of the security engineers (simply known as “engineers” within the company), have U.S. government clearances of either Secret or Top Secret. Some have even higher clearances for the 2% of SecureWorks’ work that involves so called black box security work. Most of the employees also hold clearances because they must handle classified documents. Leslie is SecureWorks’ human resources (HR) manager. She maintains all...

A Technology Budget Tally is a start-up website development company located in Seattle, Washington. The company currently has 7 employees and is looking to hire 6 new employees in the next month. You are in charge of purchasing for Tally. Your first task is to purchase computers for the new employees. You want to look into 3 different manufacturers: Dell, HP, and Apple. Your budget is $550,000 to purchase the following: New computers for all employees – for old and new, 2 monitors each. 2 high-end servers  5 color printer/scanner combination Desks for all the new employees (not manufacturer specific, just make sure the desk will hold the computers and monitors. Software: (Not necessarily manufacturer specific, just make sure it is compatible with the brand of computers etc you are purchasing). Operating system for the computers Visual studio professional Virus software MS office SQL Server Database Keep in mind this is for a business and not for home usage. Look ...

ABC company is a small computer security contractor that provides computer security analysis, design, and software implementation for the U.S. Government and commercial clients. ABC company competes for both private and U.S. Government computer security work by submitting detailed bids outlining the work the company will perform if awarded the contracts. Because all of the work involved computer security, a highly sensitive area, almost all of ABC company’ tasks require access to classified material or company confidential documents. Consequently, all of the security engineers (simply known as “engineers” within the company), have U.S. government clearances of either Secret or Top Secret. Some have even higher clearances for the 2% of ABC company’ work that involves so called black box security work. Most of the employees also hold clearances because they must handle classified documents. Leslie is ABC company’ human resources (HR) manager. She maintains all employee records and is r...