Mt. San Jacinto College Computer Information Systems
Minimize header.

CSIS 101 - Introduction to Computers & Data Processing

Assignments

Getting Access to the Microsoft Office Suite of Applications

In order to complete the three skills assignments in CSIS 101, you will need access to Microsoft Word, Microsoft Powerpoint, and Microsoft Excel. If you do not have access to a computer with these applications installed on it, you can access the entire Microsoft office suite of applications on the MSJC Remote Desktop System (RDS).

  1. Click this link or type http://apps.msjc.edu in your Web browser's address bar and press enter.
  2. Once you arrive at the MSJC RDS page, login using the same credentials you use to login to Canvas.
  3. Double click the folder with the most recent version of MS Office, e.g. Office 2016, to open it, then double-click the application icon of the program you want to launch.
  4. A file will be downloaded to your computer's Downloads folder (the file name ends with ".rdp"), double-click that file, then you will see a dialog box asking if you trust the publisher of the program. Click the Connect button in that dialog box (clicking the Don't ask me again checkbox is pointless).
  5. Enter your Canvas password again, and then your application should appear in your browser window, it can take some time, depending on your connection speed, but after 10 to 30 seconds the app should appear in your browser window.

It's like you are running the program locally, the functionality is all the same as if it were installed on your computer.

How To Submit Your Completed Assignment

Review the instructions and assignment criteria (see below) for the assignment you want to complete, compose your assignment, and then submit the completed assignment file to Canvas using the Submit An Assignment link on the Canvas home page.

  1. Once you are on the Submit An Assignment page click on the link for the assignment you wish to submit, and then click on the Submit Assignment button that is located at the top of the assignment page screen (it's a big red button, you can't miss it).
  2. On the File Upload tab under the assignment instructions/criteria, click on the Choose File button.
  3. Navigate to your assignment files using the file explorer window that appears.
  4. Select the file and then click on the Open button; you will be returned to the File Upload tab and you should see the name of your assignment file listed. If not repeat the file upload process again.
  5. Once you see your assignment filename listed on the File Upload tab click the Submit Assignment button.
  6. You will see a confirmation of the submission in the upper-right of the screen displaying a check and the words "Turned In!" followed by the date and time of submission.

Microsoft Word Assignment Instructions/Criteria

Applying the Information Processing Cycle

In chapter 1 you learned how a computer converts data into information using the information processing cycle. In this assignment you will create a report about any information processing cycle you are familiar with or would like to see in the future. In order to receive full credit for your report it must meet all of the criteria listed below.

Primary Objective: Apply the Information Processing Cycle to an information system of your choice.

Required Content Elements:

Create a one to two (no more than 2 pages) page summary that describes an information processing system of your choice in terms of the Information Processing Cycle – Input, Processing, Storage, and Output. Include a paragraph (3 to 5 sentences) that explains the benefits of the system you choose. Also include a couple of sentences stating a benefit analysis, consider factors such as Speed, Reliability, and Accuracy. If relevant, add a couple of sentences which compare your chosen digital processing system against previous manual system approaches to solving the same or similar problem.

Secondary Objective: To utilize Microsoft Word to create a visually appealing report (see required word processing elements below).

Required Word Processing Elements:

Your document File should be named: Last name + First initial Word Assignment; where first name and last name are YOUR first and last name.

  • Two Font Types (ie TimesNewRoman, Arial, etc.)
  • Two Font Sizes (ie 12 pt, 16 pt., etc.) Note: minimum 12, maximum 24
  • Right Justified Page Header (Name, Assignment, Date);
  • Centered Title;
  • Appropriate use of Bold, Underlined, or Italics styles (choose 2);
  • 1/2" margin at the top and bottom, 1" margins at the left and right.
  • Your document should include a Color Element (ie text color, background color, etc.)
  • Your document should include at least one table or one Image or Graphic
  • Your document should be spell-checked for accuracy

Microsoft PowerPoint Assignment Instructions/Criteria

To receive full credit for the Microsoft PowerPoint assignment you must complete the following:

  • Create a 10 slide stack using a theme of your choosing.
  • Your slides must inform and educate the viewer about any topic from your text book that you choose.
  • The key to a good PowerPoint presentation is to organize the subject for the viewer.
  • Use succinct bullet points which highlight, accentuate, or expand upon your topic.
  • Each slide should contain a figure, or a chart, an image, or a video that enhances the understanding of your topic .

After you have produced your assignment, attach the PPT or PPTX file here by using the Browse My Computer button.

Microsoft Excel Assignment Instructions/Criteria

Purpose

The purpose of this assignment is for students to demonstrate proficiency in Microsoft Excel by creating a spreadsheet that will be used to manage their own personal budget. Please note that you do not have to include actual values for your income and expenses; you can make up values, but they should be realistic.

Content Requirements

The Excel workbook you submit for scoring should contain the following information.

Income Worksheet

  1. The first sheet of the workbook should show your income each month of a 12-month period, that comes from all income sources. Be sure to show at least two income sources, even if those are fictitious. An example is shown below:
  1. Include a row at the bottom of your income information, include a row that will display the total income per month. To receive credit for this step, you must use an Excel formula or function to calculate the total, which should automatically recalculate if the values in the cells are modified.
  2. Include a column on the right side of your income information (to the right of the December column), that will display the total income per category. To receive credit for this step, you must use an Excel formula or function to calculate the total, which should automatically recalculate if the values in the cells are modified.
  3. Add a chart to display your income monthly totals. (see image below)

Expense Worksheet

  1. The second sheet of the workbook should show your estimated mandatory expenses each month of a 12-month period. There should be some varying values, so you do not end up with all of the same values for every month, in every category. Mandatory expenses might include rent or house payments, grocery bills, utilities, and car payments, etc. Be sure to include at least 5 mandatory expenses. An example is below:
  1. In a new row at the bottom of your expense information, include a row that displays the total expenses per month. To receive credit for this step, you must use an Excel formula or function to calculate the total, which should automatically recalculate if the values in the cells are modified.
  2. In a new column on the right side of you expense information (to the right of the December column), include a column that will display the total expense per category.  To receive credit for this step, you must use an Excel formula or function to calculate the total, which should automatically recalculate if the values in the cells are modified.
  3. Add a chart to display your monthly expense totals.

Net Income Worksheet

  1. The third sheet of the workbook should show your net income or loss for each month of a 12-month period. The table will consist of two rows: the first row will show the 12-month period (names of months), the second row will later use a formula to calculate, for each month, how much extra money you will have, or how much money you are short. This is your net income after your mandatory expenses.
  1. Be sure to add the row and a colum for totaling each row and column in the worksheet.
  2. Add a chart to display your montly profit/loss totals.