PI-BI Ms word File

 

Dawnlod

ষষ্ঠ ও সপ্তম শ্রেণির বিষয়ভিত্তিক ষাষ্মাসিক সামষ্টিক মূল্যায়ন

Hi,

 

How compatible Power BI is with PI data.

 

Is it possible to prepare reports such as monthly production reports, daily reports,..... using the combination of Power BI and PI AF data. Do we have any examples.

CV Templates Free File

 CV Templates Free File 

Frequently Asked Questions for CV Templates

What is the difference between a CV and a resume?

A curriculum vitae is a document that outlines the whole course of your career and doesn’t have length restrictions. It’s used when applying for Academic or Federal positions. In contrast, a resume is a one or two page summary of your skills and professional accomplishments. However, the term “CV” has become synonymous with “resume”, and for the majority of people, they are one and the same thing.

Which template is best for CV?

The best CV template in 2023 has a clean and modern feel. In its classic form, CVs must include projects, authored publications, references, and additional achievements. They typically expand to several pages in length. All of that is supported by our CV builder, and any of our templates can be accustomed to a professional CV.

How should a CV look in 2024?

A CV template must contain the following sections: - Personal information & contact details (in some countries, birthdate and mugshots are also required); - CV personal statement (equivalent to a resume summary); - Professional Experience (for academic and federal CVs, those can expand to a dozen or more bullet points); - Education section (Including honors, GPA, and all titles you’ve gained); - List of your key skills; - Publications, certifications and projects;

How far back should a CV go?

Academic and federal CVs typically span across your whole career, so there’s no limit to that. When a CV is used as a resume, the one or two page-long rule applies.

Should I use a CV example instead?

Having a CV example from your professional niche as a base to build your own is always handy. We’ve compiled an extensive list of over 1000+ professional CVs for any job. They include a pre-made template using the actual words and phrases recruiters look for, and a thorough writing guide. All professionally vetted, so you don’t have to worry about your next application.

Dawnlod link

Creating Strong Passwords

 You’ll need to create a password to do just about everything on the Web, from checking your email to online banking. And while it’s simpler to use a short, easy-to-remember password, this can also pose serious risks to your online security. To protect yourself and your information, you’ll want to use passwords that are long,strong, and difficult for someone else to guess while still keeping them relatively easy for you to remember.

Why do I need a strong password?

At this point, you may be wondering, why do I even need a strong password anyway?The truth is that even though most websites are secure, there’s always a small chance someone may try to access or steal your information. This is commonly known as hacking. A strong password is one of the best ways to defend your accounts and private information from hackers.

Tips for creating strong passwords

A strong password is one that’s easy for you to remember but difficult for others to guess. Let’s take a look at some of the most important things to consider when creating a password.

• Never use personal information such as your name, birthday, user name, or email address. This type of information is often publicly available, which makes it easier for someone to guess your password.
• Use a longer password. Your password should be at least six characters long, although for extra security it should be even longer.
• Don’t use the same password for each account. If someone discovers your password for one account, all of your other accounts will be vulnerable.
• Try to include numbers, symbols, and both uppercase and lowercase letters.
• Avoid using words that can be found in the dictionary. For example, swimming1 would be a weak password.
• Random passwords are the strongest. If you’re having trouble creating one, you can use a password generator instead.

Common password mistakes

Some of the most commonly used passwords are based on family names, hobbies, or just a simple pattern. While these types of passwords are easy to remember, they’re also some of the least secure. Let’s take a look at some of the most common password mistakes and how to fix them.

Problem: This password uses too much personal information, along with common words that could be found in the dictionary.

Solution: A stronger version of this password would use symbols, uppercase letters, and a more random order. And rather than using family names, we could combine a character from a movie with a type of food. For example, Chewbacca and pizza could become chEwbAccAp!ZZa.

Problem: At only five characters, this password is way too short. It also includes part of her address, which is publicly available information.

Solution: A stronger version of this password would be much longer, ideally more than 10 characters. We could also substitute a nearby street name instead of her current address. For example, Pemberly Ave could become p3MberLY%Av.

Problem: While patterns like this are easy to remember, they’re also some of the first things a hacker might guess when attempting to access your account.

Solution: Remember that random passwords are much stronger than simple patterns. If you’re having trouble creating a new password, try using a password generator instead. Here’s an example of a generated password: #eV$pIg&qf.

If you use a password generator, you may also want to create a mnemonic deviceto make the password easier to remember. For example, H=jNp2# could be remembered as HARRY = jessica NORTH paris 2 #. This may still feel pretty random, but with a bit of practice it becomes relatively easy to memorize.

Problem: There’s nothing really wrong with this password, but remember that you should never use the same password with different accounts.

Solution: Create a unique password for each of your online accounts.

Using password managers

Instead of writing your passwords on paper where someone might find them, you can use a password manager to store them securely online. Password managers can remember and enter your password on different websites, which means you won’t have to remember longer passwords. Examples of password managers include LastPass, 1Password, andfinnaly the best of all Google Chrome’s password manager.

This is a great example of a strong password. It’s strong, long, and difficult for someone else to guess. It uses more than 10 characters with letters (both uppercaseand lowercase), numbers, and symbols, and includes no obvious personal information or common words. This password might even be a bit too complicated to remember without a password manager, which underscores why they’re so helpful when creating a strong password.

Remember to use these tips whenever you create a password to keep your online information safe and secure.

School Management System – MS Excel Files

 

tudents Database Management System – MS Access

3,953 times this page has been viewed.

When you first open the database, Access displays the Welcome form. To prevent this form from displaying the next time you open the database, clear the Show Welcome when this database is opened check box.

Close the Welcome form to begin using the database.

• To make sure all the database content is enabled, in the Message Bar, click Enable this content.

The Quick Search box lets you quickly find an student on the Student List form.

• Type the text you want to search for in the Quick Search box, and then press ENTER.Access filters the list to show only those records that contain the text you searched for. To return to the full list, click Clear the current search. (It’s the X inside the search box.)

Filter the Student list

On the Student List form, you can filter the list of students, and save your favorite filters for future use.

• Apply filters by right-clicking the form and selecting the filters you want.
• Click Save Filter.
• On the Filter Details form, enter a filter name and description, and then click Close.
• Use the Filter Favorites box to apply a saved filter, or click (Clear Filter) to remove the filter.

Show or hide columns

On the Student List form, some fields (columns) are hidden by default. To change which fields are displayed:

• Click Show/Hide Fields.
• In the Unhide Columns dialog box, select the check box beside each column that you want to show. Clear the check box to hide the column.

Display student details

The Student Details form lets you view and enter more information about a student, including pictures, guardians, emergency information, and attendance. To display the Student Details form:

• On the Student List form, click Open next to the item that you want to see.

Add a picture

On the Student Details form, you can add pictures and other attachments.

• Under the picture frame, click Edit Picture.
• In the Attachments dialog box, click Add.
• In the Choose File dialog box, browse to the folder that contains the file.
• Select the file you want to add, and then click Open.
• In the Attachments dialog box, click OK.

You can attach multiple files for each item, including different file types such as documents or spreadsheets.

Add students from Microsoft Outlook

If you use Microsoft Outlook, you can add students from that program without having to re-type the information.

• On the Student Listform, click Add From Outlook.
• In the Select Names to Adddialog box, select the names that you want to add to the database.
• Click Add, and then click OK.

Display a map of a student’s address

On the Student Details form, if you have entered a street address for the student, you can display a map of that location:

• Click Click to Map.

Display reports

The Students database includes several reports, including All Students, Allergies and Medications, Emergency Contact Information, Guardian Information, and more. To display a report:

• In the Navigation Pane, under Reports, double-click the report you want to display.

Modify the Students database

You can customize the Students database by adding a new field to the Students table, and then adding that field to the Student List form, the Student Details form, and the All Students report.

Add a field to the Students table

1. Close all open tabs.
2. In the Navigation Pane, double-click the Students
3. Scroll to the right until you see the column named Add New Field. Double-click the column heading, and type in the field name.

The first time you enter data in the column, Access sets the data type for you.

Add a field to a form or report

Once a field has been added to a table, you can then add it to a form or report.

1. Right-click the form or report in the Navigation Pane and then click Layout View.
2. On the Designtab, in the Tools group, click Add Existing Fields.
3. Drag the field you want from the Field List to the form or report.

Download File (Zip Form)

 

School Book Shop Inventory Management System – MS Excel File

5,215 times this page has been viewed.

School Book Shop Inventory Management System

In this article we will discuss Inventory Management System and will cover two things; Quantity and its Price (In and Out). In this version we will cover the following items,

1. Items detail
2. Purchase; Items Received
   
3. Sale: Items Issued
4. Stock
5. Invoice

MS Excel users have greate advantage that they dont need any software or other application to maintaint their account or other records. Now lets start how to construct different types of sheets to maintain School book shop inventory system but before it, Download and install legal copy of Microsoft Office if you dont have before.

Create five sheets with titles as given below in picture.

1. Items

In this sheet we will create 5 columns for Item Code, Items description, parchse price, profit margin and finally sale price. Here we will determine all these things as we will use them in other sheets.

Items – School Book Shop Inventory Management System

Write code of an article in first colums and its descriotion in second column. Please keep code and descrioption wording in a symmetric manner so that we can use them without any error. I have taken Female dress as item but of diffent sizes. You can see their code number are unique and have a symmetry.

In third column, write purchase price of each item.

Now In fourth column we will insert formula to calculate profit margin in cell E4. In this sheet I have taken 15% margin of each prchase price.

=D4*ProfitMargin/100

In above formula, ProfitMargin is the name given to profit value located in cell H3.

For more information about how to give name to any single cell or range, must read this article (Name the Range).

now we have inserted formula in Cell E4. Now see right botton of cell E4, and pick the dot then drage to thw whole column to paste the fomula to the whole column.

Inserting ProfitMargin Formula – School Book Shop Inventory Management System

Now in Fifth colum, we need to insert Addition Formula in cell F4 to calculate Sale Price. See below

=D4+E4

Inserting Sale Formula – School Book Shop Inventory Management System

Sale price formula has been entered and now agains perform same activity; drag the dot to the whole column to paste this formula.

Now scroll down the page and see at the end. you will find the same columns mentioning different sets of books of different classes. Here is a difference, in above mentioned example you need to decide profit margin, but here in book you can find sale price already mentioned on it.

In this case, you can not determind the sale price. The publisher will tell you discount rate as in this case publisher sale man offer me to give a book set at 25% discount. Now we need to calculate purchase price. lets start.

Insertind Discount rate – School Book Shop Inventory Management System

I have given “Discount” name to discount rate (25%). Now in Cell D41 calculate of a purchase price of which 25% profit and total sale price is Rs. 600. On the other hand Saleman will tell you discount margin as well as purchase price but how will you calculate in excel file. Lets construct formulat for this,

If sale price of a product is Rs. 125 then its purchase price is Rs. 100 at 25% rate.

If sale price is Rs. 600, then how much will be purchase price; solution is: 600*100/125. now try to understand the following formula,

=100*F41/(100+Discount)

Now in cell E41 determing the profit on purchase price or discount on sale price offered by publishing company.

=F41-D41

Now Item seheet is almost done. One thing left which is Books table that i have created. See below

Books table – School Book Shop Inventory Management System

See above book table and at the end total price is also mention. pick these value direct to sale price column. you can customise this sheet according to your needs as well as your items.

2. Purchase; Items Received

In this sheet we will create columns to maintain data records of intems purchased. Now we will create Code, description, date and number of items received as shown below.

Purchase – School Book Shop Inventory Management System

Now when we purchase an item from company we insert the code number of that item that fetch description in second colum automatically. In items sheet, Select the whole table ot items and name it as “iTable”  so that can can pick description and purchase price from that table. See below.

Purchase 2 – School Book Shop Inventory Management System

Now in code colum we will insert code and in second colum we will use vlookup formula to fetch description. Use the following formula in cell B5.

=VLOOKUP(A5,’School Book Shop Inventory.xlsx’!iTable,2,FALSE)

Learn more about how to use vlookup formula in MS EXCEL, see Microsoft Excel introduces powerful XLOOKUP function.

In third column,  inserrt receving date manualy, simply press control+; button. in forth column enter number of items you received. See below

Purchase – School Book Shop Inventory Management System 3

Now we have list of items that we received in whole of the month. Name code column range as “rCode” and Units column as “rUnits”. One items could be received multiple time in a month. Now we will accumulate the list item-wise. For this purpose we will create 5 more columns.

Purchase – School Book Shop Inventory Management System 4

See above picture, description detail has been fetched on the basis of Code. Now in cell i5 insert the following formulla to pick accumulate number of unit of 20F (Female dress of sezi 20″) from rUnit column on the basis of code from rCode.

=SUMIF(rCode,G5,rUnits)

This formula will give you whole number units of 20F size purchsed in whole month. Now use the following formula to fetch unit purchase price from iTable located in Items sheets.

=VLOOKUP(G5,’School Book Shop Inventory.xlsx’!iTable,3,FALSE)

And in the last column, une multiplication formula to caculate purchase price of all the items of 20F size purchase in the whole month.

=I5*J5

As done above, revise agains to drag the formula down to the whole colum. Done. Purchase sheet is ready.

Purchased Accumulation – School Book Shop Inventory Management System

3. Sale: Items Issued

In this sheet we will take review about items which have been sold or issued. This is the same as purchase but a little difference in formula.

In previous Purchase sheet we have given name rUnit for units column and rCode for Code columns.

While creating Sale Sheet. now make a little difference in the name of ranges. Create from iUnit for units column and iCode for Code column.

Now its your working to change the formula according to new Range Names.

If Done, Sheet is ready.

4. Stock

Now its time to calculate result and stock left over. In this sheet we have constructed 5 columns; Code, Descrption, Unit purchased, Unit Sold and Stock.

Stock – School Book Shop Inventory Management System

First two column are same as we have created in last two sheets (Prcuase and Sale). Third colum is also near about same. We will pick units received (purchased) from Purchase sheet by inserting the following formula in Cell D5.

=SUMIF(‘School Book Shop Inventory.xlsx’!rCode,Stock!B5,’School Book Shop Inventory.xlsx’!rUnits)

In Fourth colum, We will pick units issued (Sold) from Sale sheet by inserting the following formula in Cell E5.

=SUMIF(‘School Book Shop Inventory.xlsx’!iCode,Stock!B5,’School Book Shop Inventory.xlsx’!iUnits)

In fifth column, calculate the difference of these two and find the stock left in your hand.

=D5-E5

Now drag these formulas down to the required rows.

Done, but now optionally we will also create another column to check which stock item is ready to be placed for oder.

Alert – School Book Shop Inventory Management System

Now design two cells for ALERT heading and its required value. Click on required value (arrow 1) and give it a name (arrow 2). Now in order column, in cell G5 we need to insert IF formula; If Stock value F5 is less thank alert value H4, highlight this by showing “Place an order” text in colum G5 Order. If Stock is greater than alert value, means we have enough stock left in hand, then there will be no text here in G5. see the formula below.

=IF(F5<=Alert,”Place an order”,” “)

After inserting, drag the formula cell down to required rows. Now insert order stock value in alert value. In my case, I am going to insert 10 value that means below this value I will place an order for further purchasing. See below

Order – School Book Shop Inventory Management System

Done. Try this

5. Sale Invoice

Finaly I have created a very simple invoice Excel sheet for customers. Now i am sure that you know how to fetch information and values on the basis of code. write number of unit of items that customer has purchased. See below.

Invoice – School Book Shop Inventory Management System

In Total Price column, Pick the sale price on the basis of code and multiply it with No. of Unit. See the formula below.

=(VLOOKUP(A11,’School Book Shop Inventory.xlsx’!iTable,5,FALSE))*C11

Drage all the formula down to your required rows. Below is the final invoice that I have tested. Date and time is automatic update.

Invoice – School Book Shop Inventory Management System

Done. Do this try at home or download this file.

School Book Shop Inventory Management System