Applications Programming --- Lab 1

Objectives:

• Get familiar with your computer
• Get familiar with applications on your computer
• Get familiar with extracting data from information
• Start to use Excel to store and format data
• Try the simple Excel formula to process the data

References:

• Introduction
• Data

Tasks:

Login using your VIU account.

Find and start a web browser, and open http://csci.viu.ca/~liuh/112/labs/lab1.html

When using lab computer (which runs Windows):

• Understand the difference between C: drive, U: drive and One Drive;
• Understand the security issues when you use computer;
• Find the computer information
  Click the start button at the bottom left corner, then click on the "Settings". Then, in the opened "Settings" window, find and click the "System" icon, then click on the "About" item on the side bar. You should see the basic information about your computer, including Windows (OS) specifications, Device specifications, and Installed memory (RAM), System type (whether you are using 32 bit or 64 bit (more common) operating system, etc.
• Find the file management software
  File Explorer by default. Or go to the Start menu, and click on the "Documents" or "Pictures".
• Get familar with the file system on your computer
  create a new folder to hold your CSCI 112 works in a convenient location, down load the csv file mentioned in the later task item and try to move the file to your newly created folder.
• Find a text editor
  Notepad by default
• Find your Excel information
  Find Excel, open a blank workbook, it should show a start page where you can choose to create a new file or open an existing one. Click the "Account" on the side bar. You should see the Product Information of your Excel.

When you are using your own computer with MacOS, some of the tasks would be performed differently:

• Find the computer information
  Click the apple icon at the top left corner, then click on the menu item "About This Mac". You should see:
  Operating System (such as macOS Catalina, version 10.15.6), Processor and Memory
• Find the file management software
  Finder by default
• Get familar with the file system on your computer
  create a new folder to hold your CSCI 112 works in a convenient location, down load the csv file mentioned in the later task item and try to move the file to your newly created folder.
• Find a text editor
  TextEdit by default
• Find your Excel information
  Find Excel, launch it, click on the "Excel" menu item and then the "About Microsoft Excel". You should see the version and other information of your Excel.

The rest of the tasks for which ever type of OS:

1. Learn to tell the difference between a text file and a binary file
   Text files can be opened and edited by a text editor, on any computer system. And binary files usually need special software to handle them.
2. Learn to read the meta data about a file
   On Windoes: Find the file, right click on the file and click on the "Properties" in the drop down menu.
   On MacOS: Find the file, control-click on the file and click on the "get info" item in the drop down menu.
3. Discussion of computer security issues
4. Learn the connection between file extention names (types) and the applications to open the files
   In both Windows and MacOS file's meta information, there is an item called "Open(s) with", which associate an application with opening the files with the same extention name as this file.
5. Get familiar with a csv file. Download an example csv file that shows rent data of an appartment for the past 16 years.
6. Open the downloaded csv file with your Excel
   yes, both csv file and Excel file can be opened by MS Excel
7. Understand workbook and worksheet, find out the number of rows and columns in a worksheet
8. Format Excel cells so that the data looks as shown in the following table:
   

   	Year	Inflation Rate	Buffer Rate	Monthly Rent	Yearly Rent
   1	2010	1.3%	2.0%	$700.00	$8,400.00
   2	2011	2.4%	2.0%	$723.10	$8,677.20
   3	2012	1.1%	2.0%	$754.92	$9,059.00
   4	2013	-0.1%	2.0%	$778.32	$9,339.83
   5	2014	1.0%	2.0%	$793.11	$9,517.28
   6	2015	1.1%	2.0%	$816.90	$9,802.80
   7	2016	1.8%	2.0%	$842.22	$10,106.69
   8	2017	2.1%	2.0%	$874.23	$10,490.74
   9	2018	2.7%	2.0%	$910.07	$10,920.86
   10	2019	2.3%	0.0%	$952.85	$11,434.14
   11	2020	0.8%	0.0%	$974.76	$11,697.13
   12	2021	2.8%	0.0%	$982.56	$11,790.71
   13	2022	6.9%	0.0%	$1,010.07	$12,120.84
   14	2023	3.9%	0.0%	$1,079.77	$12,957.18
   15	2024	2.6%	0.0%	$1,121.88	$13,462.51
   16	2025	2.1%	0.0%	$1,151.04	$13,812.54

   Select the cells you want to format, right-click (on Windows) or control-click (on MacOS) on these selected cells, and then choose "Format Cells" item from the drop down menu.
   In the opened "Format Cells" window, you can choose Category of data, Number format, Alignment, etc.
9. Although they are shown as literal numbers, the "Yearly Rent" data are actually calculated from the "Monthly Rent" multiplied by 12. In column G, enter the title "Calculated Yearly Rent" as its title, and in row 2 of column G, try to enter an Excel formula to perform the calculation. Compare your calculated yearly rent in column G with the literal values given in column F.
10. Add a new worksheet and rename the worksheet as "HR Data".
11. The following paragraphs show a sample of the information about an organization's members. Extract the data from the information, design and store your data with proper types in the worksheet "HR Data":

    A volunteer organization has the following members in year 2026:
    Oliver is 38 years old and joined the organization on September 9th, 2015. His occupation is elementary teacher. He is given an ID of 1379 with the organization.
    
    Marsha joined the organization on June 12th, 2018 when she was 33 years old. Her current occupation is medical doctor. She is given an ID of 2933.
    
    Robert is 42 years old and works as a constructor. He joined the organization on March 15th, 2012. His organizatin ID is 2733.
    
    Jane has the organization ID of 3282. When she was 25 years old, she joined the organization on May 5th, 2019. She has been working as a theatre technician.
    
    

    You can expect more descriptions containing similar information about the organization's other members.
12. Save the workbook to either your U: drive or One Drive with proper file name and extention name (.xlsx).

There is an assignment, Assignment 1, following this lab.