Ассоциации

[мдя]

эх когда это было - ностальгия

[BoNik]

ностальгия-амнезия...

[Chainer]

амнезия - откат

[Darkarchangel]

Амнезия --- ПОШЛИ ВЫ ВСЕ НАХУЙ, ЕСЛИ НАХУЙ БАНИТЬ НАХУЙ ХАТИТЕ НАХУЙ ТО БАНТЕ НАХУЙ БЛЯТЬ НАХУЙ А АССОЦИАЦИИ ВАШИ ЗАААААЕЕЕБББААЛЛЛИИИИ ФЛУУУДЕРЫ БЛЯТЬ НАХУЙ ПОШЛИ ВСЕ ВЫ НАХУЙ И СПАКА С СОБОЙ ЗАХВАТИТЕ НАХУЙ!

[Chainer]

ыыыы

[Darkarchangel]

бЛЯ)=весь мат перекрыло)=

[Elvic]

ыыыы ===> ГыыыыыыЪ

[BoNik]

ГыыыыыыЪ-мхахах лол (флуд)

[Darkarchangel]

ЗАТКНИТЕСЬ!! ВСЁ НЕТУ АССОСОСИНАХ УЙ АЦИЙЙ БЛЯТЬ ПОКА МЯ НЕ ЗАБАННЯТ ПОШЛИ НАХЕР СИДЕТЬ БЛЯ!! ЗАЕБАЛ МЯ ЭТОТ ТОП УЖЕ ГОД ЕГО ТЕРПЛЮ БЛЯ ФЛДУДЕРЫ ВАШУ МАТЬ!

[BoNik]

маразм крепчал)))

[Sindaer]

Darkarchangel, - не нравится - чего читаешь?

мхахах лол (флуд) ==> никогда не кончается

[Darkarchangel]

DDDD:

DDDDDDD:

DDDDDDDDDDDDDD:

DDDDDDDDDDDDDDDDDDDDDDD:

DDDDDDDDDDDDDDDDDDDDDDDDDDDDDD:

Specification
I have been asked by a company named “One&one ltd.” to create a database on a spreadsheet for them.

This company sells such goods as digital TVs, Computers, Different parts of computers like memory cards, video cards etc. The company also sells CDs and DVDs. They also want to know what profit they will make over they after they sell all the possible items. They also want to provide a look up system so they can see weather they have a certain product in the stock or not.

The company expects from the new electrical system database of all the stock in the shop how much it costs to buy and sell the stock and how much they have in the stock. They also want invoices and purchase forms with the price of the stock how many they want and what the total comes to, on the invoice they need to know what the price of the stock will come to after Vat and if the customers gets a discount or not.

Plan
The system I have designed consists of the following:

Main Menu
I will create a main page with macros on it which will have control keys which will link them to other pages in the workbook.

Database
The data base will give information on the stock which includes all the services the company providing and the prices. The database will also be used for v-lookup.

Invoices
To show how much each customer owes the company and what they want to buy, this will template and formulae which will be created using the vlookup table and functions which automatically calculate when data is input.

Purchase order
This is to show what the company needs in respects to stock ad how much it will cost to order the sock.

Product lookup
To help find products easily and quickly using a V-lookup of the company’s database.

Main Page

This page will help to give access to the other pages in the system using macros.

Database

Invoices

                   Cash

                   Cheque

                   Debit

                   Credit Card

Purchase order

Product lookup

Stock add system

This information will be shown through the v-lookup() which will be created on this sheet.

The six complex facilities I will use in my excel system will be the following:
1.) List and tables
2.) Drop down boxes to select data for entry
3.) Macro buttons
4.) Validation boxes
5.) Multiple sheets with links between them
6.) Form templates

User Guide
Getting started:

Here I will describe how to open the company system in easy and understandable steps.
First of all
Turn on your computer and wait for the windows screen to load up. When the computer has loaded you will see this screen:

Once you have this screen you will have to double click the excel icon shown below:

Once you have double clicked on the icon the computer will automatically load up excel, wait until you have got this screen on your computer:

Once you have done this your screen will look like this, you then need to open necessary files to open the system.

When you have clicked on the open icon you will have this on your screen:

Once you have this screen you will need to select the ‘Electronic database’ file by clicking on it, then you have to press ‘Open button’.

Once you have opened the electronic database for One&One Ltd. you will see the screen like this:

Now you will be able to learn how to use the function of the system in the next chapter: such as the macro buttons and the V-lookup function.

Now you will learn how to use each of the different pages in the system.

Once you have loaded the system, you are now ready to learn how to use different functions on the different pages.

If the system is loaded properly you should have the main page on the screen:

As you may notice there are six macro buttons on the page, which will take you to the different pages in the system as, shown above.

To open a different page in the system you will have to click on one of the buttons we suggest for tanning purposes you should click on the database button.

Database

Once you have clicked on the database button on the main menu you should now have this screen on your computer:

Here you can change Items’ names, ID code, put your quantity of the items in stock and put cost price.
Warning: do not change information of other columns.

If you accidentally put ID codes in the wrong order just press ‘Sort Data’:

There are also some macros on the bottom of the sheet:

The ‘Print’ button is use to print current sheet. The ‘Save’ button is used to save entire worksheet. The refresh button resets all old values in the database.

Purchase form

When you open Purchase form it should look like this:

The bottom of the sheet contains the purchase form:

This form has everything you need to make the right purchase.

Product lookup

Product lookup is used to check if you have some specific item or not.
When you open the ‘Product lookup’ sheet it has to look like this:

You can choose any ID code and the Item, Amount in stock, Cost price and Sale price of the product will be displayed automatically.

Invoice form

The invoice form is used by the customers to order company’s products. My invoice form has the address of the customer and the company, company’s logo and contact details, it also has today’s date:

I also designed a table for invoice form:

As you have already noticed, the customer will be able to get a 5% discount on everything if he/she bye more then 5 items. I also have to mention that if customer’s city is London the delivery will be just £20.

Total Selling price graph and Total profit graph

I also have two graphs which show the total selling price of the products and the total profit:

I have completed the description and now you are completely ready to work with it alone.

Documentation
Unit 3

In this document I will explain how I created the macro buttons, the v-lookup on both the purchase order form and the invoice form, I will also explain several other formulas I used for this assignment.

Main Menu
I have 6 macro buttons which link to the different pages of the system.
1st one is Purchase form macro;
2nd one is Product lookup macro;
3rd one is Invoice macro;
4th one is Database macro;
5th one is Profit macro;
6th one is Total selling price macro.
I recorded each macro by opening tools tab and choosing Record new macro in macro menu. I opened the correct page for each macro and stopped recording. Afterwards I created 6 buttons and put the right macro in each button.

Database
On the database there are number of a different formulas, which are need on the spreadsheet. I have total price formula which is (Amount * Selling Price), total price formula including VAT (Amount * Selling Price + Amount * Selling Price * 17.5%), formula for selling price which is 10% bigger then Cost price (Cost Price + Cost Price * * 10%), Profit per item (Selling Price – Cost Price), Total Profit (Profit Per Item * Amount).

I also have a lot of macros. 1st returns you to the main page. I recorded it the same way as I recorded the macros in main page. The 2nd one sorts the data; I recorded it by using sort data from the data tab. The function of this macro is to sort numbers if they are in the wrong order. I also have refresh function which resets all the values on the database page to zero. I also have macro which prints page, I recorded it by pressing print button and stopping the recording. I recorded the save macro in the same way as I recorded print macro --- just by pressing save while recording a macro.

Invoice and Purchase forms, Product lookup
For these pages I used very important formula. Vlookup is usually used for electronic databases. Its function is to show products from database when the specific code is selected. Vlookup function in the invoice looks like this: =VLOOKUP(C19,Database!$B$8:$J$17,2)
It means that for specific value of sell C19 Vlookup has to look into the database and copy the right value from Item column.

The macros refresh, print, save, return to main page were recorded in the same way as they were on the Database page.

I also have ‘If’ function on the invoice page on the discount page. It means if the quantity of bought items more then 5 then customer will receive a 5% discount.

I also have two graphs which show total selling price and profit. I have created them by using a chart wizard.

Testing

Macros

Testing ‘Database Macro’ on the main page:

Macro is working and it opens database when we press the ‘Database’ button.

Testing ‘Sort data’ macro on the database page:

This macro doesn’t work because an error has occurred. We will have to fix it. I will delete the current button with macro by pressing on it with right button and pressing delete on the keyboard. To record a new macro I will have to choose ‘Record new macro’ from the tools panel.
Now when recording is in progress we will have to press ‘Sort data’ button in the Data panel. After this we have to choose sort by ID code and set Ascending order. The last thing we have to do is to press ‘Stop recording’ button.
Now we have to create a new ‘Sort data’ button.

Testing new ‘Sort data’ button:

The macro is working and we don’t receive any error reports.

Formulas

Database formulas:

I used a lot of formulas in this assignment. For sale price I had to use this formula: $I$2*E8+E8. Sell I2 is the absolute because it shows how much bigger Sale price from the cost price.
So the formula is ‘Percentage * Cost price + Cost price = Sale price’.

Total selling price = Amount in stock * Selling price.
This is very common formula.

Total selling price with VAT = Total selling price + Total selling price * 17.5%.
This formula means that Total selling price with VAT supposed to be bigger on 17.5% from Total selling price.

Profit shows how much profit you will get from selling one unit of current goods.
The formula is ‘Sale price - Cost price’.

Total profit shows how much profit you will get from selling the whole stock.
Total profit = Profit * Amount in stock.

For this assignment I also used an ‘If’ function. For example:

This function means that if cell G12 equals “London” (we have to put quotation mark to show Microsoft Excel that data is a text data) then the delivery costs only £20.00, but if cell G12 equals to any other value then delivery costs £100.00. Cell G12 is in customer details and it shows customer’s city.

I also used ‘If’ function for discount:

If customer buys more then any 5 items he gets a 5% discount on everything he buys. This formula is a little bit complex then the previous one. It shows that if sum of the quantity column is higher then 5 then discount equals 5% from total. We are going to use this in subtotal. To find the subtotal we have to find the sum of Total, VAT and Delivery and extract the price of discount.

For this assignment I also used a ‘Vlookup’ function:

‘Vlookup’ function shows information from other sheets of the same document using the information it has. For example: under ID code 2 we have Sony Media player which costs £149.99 and the current amount of Sony Vaio Media players in the stock is 50. ‘Vlookup’ function used the information from database.

Evaluation
For this assignment I used a lot of techniques like Macros, different formulas, shading, I used different fonts and combined colors and tables. I tested all of macros and formulas and pleased with their work. At this point everything works properly.

[Elvic]

мхахах лол (флуд)====> спам и флуд все перетрут

[BoNik]

спам и флуд все перетрут-оксиома

[Darkarchangel]

Я вас всё равно перефлужу...

Report Update

Results

I thought this work is going to be very hard because I will have to deal with a lot of people and help them to solve their problems. I was not very confident with this work at the beginning. I had a task to complete at least 60 pieces of support. After the first few weeks I was very confident with my work. I had done a lot of supports and I was able to solve almost all of them immediately. I had few problems I could not solve, that is why I had to use manual. I used manual from the document’s menu in ‘Help’ toolbar. Sometimes I had to read throw a lot of problems to find mine, but sometimes I was not been able to solve the problem even after I read the manual. In this case I consulted technical personnel. I had some users unable to solve some problems in Dreamweaver, Front page, Fireworks, etc. When I was not been able to solve problems with this software, I consulted technical documentation to help them. I manage to make my support very effective.

I had been able to solve almost all the problems immediately and I was doing my best when I could not solve the problem in a short term.

After I finished providing support I realized that I have learned a lot of useful information from using manuals and helping people. I am glad I could help a lot of people effectively and teach them how to solve their everyday problems. I’m also glad I have learned a lot from them.

Index of regular problems

I have noticed that a lot of people have the same problem. It was easy for me to solve them because I solved them sometimes more than ten times, but because a lot of people asked me to help them with the same problem it started getting really annoying. That is why I think it would be better if I will help a lot of students by creating index of regular problems. It supposed to be a sheet with the most common problems and the explanation on how to solve them.

The first thing I have to do is to find the most common problems. I have to check my logs and make a list of all problems and check how many times they had occurred. The point is to find 3 or 4 most common problems which occurred more often then the others. After this I plan to create very simple and friendly support sheet with the good explanations on how to solve the most common problems.

I found the most common problems and I am now ready to create a help sheet for them. As I have already told – the help sheet is probably going to be near almost each computer in the Whitehall Suite, so anyone can find the answers for the most common problems. The second thing is the title. It supposed to be very eye catching, so anyone could notice it and look inside. That is why I used ‘Insert WordArt’ button and typed: Are you stuck? Look here! May be you will find the solution! I also used fireworks to create a nice notices and I also inserted few images from Clip Art.

The next thing I have to take care of is nice layout and presentation of each problem and explanation to it. I tried to use all the space on the page, so the help sheet is going to look very accurate, simple and presentable.

I have managed to create an accurate index of regular problems and their solution that enables efficient and rapid response to such problems.

I hope everyone will find the solution for his/her problem using my support sheet. I also hope college can try to improve support for programs that are used all the time. For example: creating manual for the beginners with the basic description of the program and its functions. However every time you login, Windows asks you if you need help with adjusting to IT.

Dealing with users

I provided most of my support face to face. At first I found it hard to communicate with the people I don’t know, and to help them with the problems, but in one week time I used to it. It is easier for me to provide help face to face because I can see what the problem is and I don’t have to guess. Usually my support was very efficient.

Providing support on telephone was much harder. Sometimes it was very hard to understand a person. So I had to be very patient and calm to solve them. I had to check that everything is fine, so I had sometimes to ask very easy questions like: is the computer turned on? But in general I tried to effectively solve the majority of problems.

Helpsheets

For this assignment I had to create 2 helpsheets that can provide a nice description and help on working with important software. One of the helpsheets had to be created for the beginners with friendly language, and a lot of graphs for explanations. The second one had to be much more professional for the experienced users. It had to include more technical language and it had to have graphs only there where it was necessary.

Simple Helpsheet
One of the documents I had to create for this assignment was Simple Helpsheet. Simple means that it was mostly for beginners. It was not hard for me to create such helpsheet, but I had to keep in my mind that this helpsheet is for beginners and the language must use very clear and friendly language for this helpsheet.

Complex Helpsheet
The second helpsheet had to be for experienced with IT users, that is why I used less graphs, and more explanation in this helpsheet. It also had to be clear, accurate and well presented. I had to use more technical language to explain my point.

I managed to design clear, accurate, well presented and easily understood by users training materials.

Evaluation

From the beginning of my assignment I had to show my IT knowledge a lot. I had to be able to deal with majority of windows software when I had to create forms, graphs, technical documents, etc.

At first I had to prepare suitable forms and documents for providing support. I used Microsoft Word to design two forms which I used to keep the record of my support. I am spending a lot of time every day working with computers. I think this helped me greatly to complete my assignment, because I had to help experienced users as well. Usually their problems were not hard for me, and I managed to deal with them very rapidly and efficiently.

When I was providing telephone support, I had to listen to the problem very carefully to understand it. A lot of times I was capable to guess what the problem was, because when I was inexperienced with this problem I described it the same way as my customer on the telephone. I understood and have been able to solve almost all problems my customers have had.

I had to keep up with my plan, that is why I had to finish providing supports on the specific date. I had to create few important documents after providing the support. I had to use almost all of the windows software to create those documents. They had to include analyzes, graphs, information about the most common problems, some of customers’ details and a lot of information about the support I provided. Forms and different documents I have designed before providing support helped me greatly to design those documents.

I was not very confident in my skills before starting this assignment, but I found myself very useful for a lot of people. I became much more confident in my skills after I managed to complete providing support before the deadline in my plan.

[BoNik]

кончай флудить

[Darkarchangel]

Final

Complex Help sheet

Finally! The complete explanation to the Vlookup function!

1. What is Vlookup.
   Vlookup usually used in electronic databases to have an easy access to all the products. In practice Vlookup shows the specific value from one row of database. You also have to select the row. For example: You need to lookup product No. 3 in database. You select 3 in Code and other sells of the row display the name of the product, amount in stock, price.

2. How to use a Vlookup function.
   For example you have a table like this:

ID code will be the code of the product. For example: Mobile phone is No. 3 in database. The first thing we have to do is to select item sell. Then we have to press an arrow near autosum button and select ‘More functions’ tab. From ‘all functions’ menu we have to select Vlookup. We will get a menu like this:

a.) Lookup_value
We have to put the cell with ID code into the ‘Lookup_value’. ‘Lookup_value’ is the cell which has to show to Vlookup the row where the right data is stored. In our case it has to show ID code of the product.
b.) Table_array
We have to put our entire database into this line. For this we have to press button in the end of Table_array line, choose our sheet with database on it, and select entire database.
It has to look like this:

‘Table_array’ is the cells where all information about products, items or services has to be stored. Vlookup will look to the first column of ‘Table_array’ for values that match ‘Lookup_value’. In our case Vlookup will look to the first column and it will compare it with our ID code.
Important: If you will use auto fill for Vlookup in case if you have to use it in a table, you have to make ‘Table_array’ an absolute. For this press F4 in ‘Function Arguments’

c.) Col_index_num
‘Col_index_num’ is actually the number of the column where Vlookup can find the correct value. We were creating Vlookup for Items, so we can find the name of the item in the second column of the database. The column is 2 so the ‘Col_index_num’ will be 2.
…
Press ‘OK’ button.

3. Testing
   Now you can put any ID code and the right item will appear:

I described here just one purpose of the Vlookup. You can use Vlookup for many purposes.

Example of Vlookup table:

[Elvic]

оксиома ===> теорема
*вколите ктонить транквилизатор Darkarchangel-у...))

[Darkarchangel]

Introduction Report
Unit 18 is going to be about giving the support for people using the Personal Computers. Giving the support means to help them solve different sorts of problems which might occur during the work with different types of software. First of all I’ll need to record all the support I’ve given. If I have a record of support then I’ll be able to spot the most common problem and make additional report which could help people solve this problem. I will also need to have details about customers who have received my support to learn their opinion about the quality of given support. In case if someone requires my help once again I shall easily notice it.
Explanation to ‘Record of Support’ forms

I have to design two forms:
The first one will be ‘Record of Support’ which I’m going to fill by myself.
The second one will be ‘Customer Feedback Form’ and it is going to be filled by the customers who have received support from me.

I have to make these two forms look simple, accurate and presentable.

The ‘Record of Support’ form will have Reference Number; Sex; Experienced Problem; Result; PC number; Date; Time.
• The Reference Number shows me which one of my customers experienced problem with his/her software.
• Sex of the person shows either the person was male or female.
• Column ‘Experienced problem’ allows me to make a record of occurred problem. If someone else among my customers has the same problem I will be able to tell them instantly either I can solve their problem or I cannot.
• Result shows either I had fixed the problem or I hadn’t.
• PC number makes it easy for me to spot if something was wrong with PC.
• Date and Time show when the specific user received support.

The ‘Customer Feedback’ form will have Reference Number; Software; Questions: Either person older or younger then me, What does the customer think about my ICT/Communication skills, Does the person confident with IT; Signature.
• The Reference Number has the same definition here as it had in the ‘Record of Support’ form.
• Software gives an idea about the sort of problem that can occur, for e. g.: if my customer was using ‘Word Document’ when the problem had occurred then I already have an idea about the range of problems he could experience.
• Question either the person older or younger then me gives an idea how many people who had problems were younger or older then me. It also shows how many people was the same age.
• The question about customer’s opinion on my ICT/Communication skills tells either I have to improve my ICT/Communication skills or I don’t.
• The question Does the person confident with IT helps to understand the difficulty of the experienced problem: for e. g. if the person doesn’t confident with IT then it will probably be easy to solve the problem because I’m confident with IT.
• Signature is individual for each customer.
Now I have two forms ready to be filled with record of support.

Check and Revise
I checked my performance and I found out that I have to do at least 2 extra supports to keep up with the plan. I also found out that I have to provide more help to people inexperienced with IT because almost all people who received my help were experienced with IT.

Providing Support
On Tuesday 19th I’m going to work in a team with Ramadan Saiti on providing year 13 students with support they need. I feel myself a little not confident with this task, because year 13 students could be even more experienced then I am, however I’m sure I can help them solve their problems with a lot of Windows XP software and programs. I prepared myself to the fact that they will probably need a serious help, and the problems will be hard to solve. Also, I don’t know how some of Windows XP software works, for example: Microsoft Access, Microsoft Outlook, but I’m sure I will be able to understand it because all Windows XP software work almost the same way. I’m expecting to help as many people as I can and I will try to make my help accurate and simple to understand. I also hope Ramadan will help me if I’m going to have problems with providing support.

Providing 60 pieces of support
I started providing support on 10th of October. It was not as hard as I expected it would be however sometimes I could not solve the problem. Usually I used manual help, but sometimes I had to use help of the technician. A lot of people often had same problems. I knew how to help a lot of people with their problems and manage to finish 60 pieces of support on time.

Tally sheet
I have designed Tally sheet on 14th of October. I had all the necessary criteria on my Tally sheet like: Sex, Age, Experience, and Result.
Result shows how I solved the problem (either I did it by myself or I used a help from manual or technician). Experience shows either person was experienced with IT or not. Age shows the customer’s age (either he was older then me or he was younger, or the same age as me.

Check and Revise
I have checked all my work and I don’t have to do any extra work because I manage to keep up with the plan. I also have to prepare my tally sheet because I’m finishing providing the support very soon and I will need to analyze it.

Helpsheets
I have to make 2 helpsheets: for inexperienced with IT person and for experienced person. In the first one (for inexperienced person I am going to explain how to create a chart in excel. I will have to use many diagrams and easy language. In the second one I’m going to explain how to use Vlookup function in excel. I will have to use more technical language then in the first one and use diagrams only when I need to support my explanation.
I finished my helpsheets on 10th of January. I received feedback on my forms and improved them.

Analyzing work
I have designed 3 graphs. One graph contains information about the most common problems, other two comparing how many customers were Inexperienced with IT and how many customers were experienced. The second one shows how many males and females received my support.

I’m going to submit my work on 10th of February so I have to put everything in order.

[BoNik]

теорема-ушёл доказывать