project

we added to the project a few more things about e-commerce in romania. the last version can be seen here.

Project is done

or at least I hope so :) updated my Google website with the final version of the word document and also the Power Point presentation.

Project update

Yesterday I sent a draft of the project to our teacher. She was very prompt with her answer and gave us helpful input (Thank you!). The project is already split in sections, pages are numbered and the automated table of content has been generated. The updated version is uploaded on my Google Site

Carla, Patricia and I will be working on the other aspects that need to be changed/filled. Hopefully we will be done by tomorrow evening.

Lab no.9

Today we learned to use the function VLOOKUP. It is very usefully especially if there is a significant amount of work cause it is accomplished automatically. In today's example we had to give grades to a number of students according to some percentages.  I've also discovered that the dollar sign "$" makes the range of cells unchangeable.  You can find my work on my website, in the folder titled lab9 https://sites.google.com/site/einfoproj/uploads?pli=1

Project - update

We started researching for our project a while ago. We found useful information in books such as Encyclopedia of Mobile Computing and Commerce, Encyclopedia of E-commerce, E-government and Mobile Commerce, Encyclopedia of Information Technology. Also there were many interesting internet articles regarding the topic chosen by us.

The project is headed to it's final form, we still have to recheck it and finish with the details. We also started working on the PowerPoint presentation.  I hope everything will go according to plan and we will get a good grade.

Lab no. 8 - November 25th

At this lab we had to do an application (on a given table) posted on the professor's site: processing and analyzing a list of training course.

There were 9 requirements and in order to complete them I used comments text box, Date function, text functions (left, right, concatenate), subtotals, logical function (if), and other.

You can find my work at the following link: https://sites.google.com/site/einfoproj/uploads

Project research

I started researching for the project and I found some interesting information on the following websites.

http://www.businesstown.com/internet/ecomm-definition.asp
http://web-design.lovetoknow.com/Develop_eCommerce_Website
http://www.productcart.com/shopping-cart-software-101.asp
http://www.essortment.com/hobbies/historyamazonc_ttas.htm
http://www.seattlepi.com/business/158315_amazon28.html

Lab no. 6 - November 11

Today I have made my Google website... I have uploaded there the files that I worked on in Excel so far...
https://sites.google.com/site/einfoproj/uploads

In our last laboratory we worked with subtotals, min, max, counting.
For the second assignment we had to do the following:

q1: the total sales for each county

q2: the minimum sales value for each type of product

q3: how many records for each type of product that was recorded on that list?

q4: the maximum sales value

Lab no. 5 - November 4th

I should have posted this on Thursday but I got a bit distracted.. so here is what Alexandra and I have worked in Excel.

At the last lab I've learned how to insert comments in Excel, format them and prepare the page for printing. Comments are useful for a bunch of things such as flagging errors, raising questions, making suggestions. By default, Excel displays comments in a yellow box that points to a single cell. You can modify almost everything: the line, the background of the box, the color of the text, etc. This is done by right clicking the comment box and selecting "Format" form the contextual menu.

Lab no.4

Today we are learning about entering different types of data such as time, date, text, formulas.
We can display formulas in worksheet cells instead of the results of formulas by pressing Ctrl+’ or clicking the Show Formulas button on the Formulas tab

So in order to enter a formula we need to do the following steps

•  Click the cell where you want to enter the formula.  
•  Click in the Formula bar.
•  Enter the equals sign (=).
•  Enter the formula. 
•  Press Enter or click the Enter button (the check mark).

Speed Techniques for Entering Formulas
-Instead of typing a cell reference, you can click the cell you want to refer to in a formula. It works even for blocks of cells.

Excel gives you the opportunity to use data from different worksheets in a formula. This is called a 3D reference. It is almost like creating a regular formula.
 

new

I messed something up with the other blog... for some reason it doesn't appear in my dashboard... I hope this one will be ok..