Mentored Minds
Virtual Internship in Content Writing
1.) Introduction
Assume that there is a Brand called "Sales Partner" who is looking for a Content Writer to write about their services & Reach their Target Audience
They want an Intern who is creative, who can research on the internet and can write organic content for them.
You will be given tasks by your Mentor at frequent periods of this Virtual Internship & then you will be performing the tasks!
This Role is for Candidates who want to gain Practical Experience of Real-World Problems in Content Writing Field Working to boost their Profile!
You would also be getting access to some Career Boosting Products in this Virtual Internship
2.) Instructions
Watch all Videos (720p Quality & 1 / 1.25 x Speed) in each Chapter, Read the reference Document.
- You have to perform all the Tasks inside your Personal Google Drive Account
- You have to perform all tasks as per requirement & create a Google Document by attaching screenshots & explanation of each task you are doing
- At the End of the Virtual Internship, You will fill the Certificate Request Form & attach the Google Document in PDF Format
3.) Google Forms - Sheets
Context Covered
- Connection of Google Form with Google Sheets
- Query Function from Form Responses to Master Data
- Standard Formatting of a Google Sheet
- What is Control Master?
- Creation of a Control Master to fetch Dropdown values via Form Ranger
Your Mentor :
I Hope you have understood on how to use a Google Form to Capture Data & Use Query Function to create a Master Database.
I am setting up a virtual Call of yours with the Client, the Client owns a Manufacturing Company and the Production Manager will co-ordinate with you to give their Requirements
I will also be there in the call and summarize the requirements of the client to you as a task which you have to perform in your own Google Drive!
Good Luck!
Client Call - 1
Client :
Hi Team, We have a Production Unit which Manufactures all types of Doors,
We have a target of reducing our Production Costs by 10% in the next 6 Months from our Management,
Currently all our Production Data is managed in manual excel sheets with negligible deep reporting being done
We need any easy medium to capture the data so our operators can enter the data easily
And we need to then Dig Down & Deeper to analyze the efficiency of each Machine and our Operators to identify where we can improve our performance & thus reduce our production cost
Also we should be able to easily filter our data in the database so we can have a look at the daily progress report!
Mentor :
Sure we have noted your points and we will get back to you with an easy medium to capture all your data from the production unit, once we start capturing Data then we will look towards reporting!
Task - 1
Mentor :
As you must have heard in the meeting, the Client needs an easy way to capture the data from the Production unit & also it should be user friendly so their operators can input the data,
So Google Forms would be a great medium to capture the data from the Production Unit
Task 1 :
Create a Control Master where the Client will be adding all their Machine Names, Operator Names & Project Names
Data Set - Copy the Data Set for Control Master & Form Responses from this Sheet
Create a Google Form in your own Google Drive with the following Fields :
(D) - Dropdown fetched from Control Master
D
- Project Name (D)
- Machine Name (D)
- Operator Name (D)
- Duration (In Mins)
- Accepted Qty
- Rejected Qty
Connect this Form to a Google Sheet in your Own Drive
Now after you have Migrated (copy pasted) Data from the Data Set to your Form Responses Sheet,
Create a Master Data Using Query with appropriate Filters!
Mentor :
That's It for the first task, now we will show this to the Client & take the feedback and the requirements for the next task! After you have done your task 1 make sure you watch the training of reporting below
6.) Report Dashboarding Using Pivot Tables
Context Covered
- How to use Pivot Tables and its formatting, pivot date group
- Use of Conditional Formatting
- Create Graphical Reports and its Standard Structure
- Numeric % Reports
- Scorecard Charts
- Using Query in Reporting
- Regression Analysis
Your Mentor :
You must have understood how we can use pivot table to create any kind of Report & use any charts to create graphical representation of the Data.
Quick Tip : You can use the Filter function of pivot table to filter data based upon any type of Custom Condition.
Task - 2
Client :
I checked out the Google Form & also I did check that 4 Months of my Data has been Migrated into the Master Data, That's Great!
Now I want some Analysis from this Data,
Report 1 : Give me a Tabular Report of Month Wise - Machine Wise - Sum of Accepted Qty - Rejected Qty & Calculate the % of Rejected Qty against Accepted Qty
- Now Give me a Graph of Month wise % of Rejected Qty Against Accepted Qty
- Also Give me a Bar Graph of Machine vs Sum of Accepted Qty & Sum of Rejected Qty
Report 2 : Month Wise - Machine Wise - Average Duration
Mentor :
Hi I think you are going good and can handle the Client Directly, just make sure whatever report you provide to the Client are Formatted Properly and are Understandable!
Task - 3
Mentor :
Hi, We can also predict the next 3 Months Data and provide it to the Client, It can help him to set certain targets where based upon previous pattern the data has been predicted.
I Hope you were attentive during the Regression Analysis training I gave you before,
So provide the Client next 3 Months Prediction on the Report of : Month Wise - Machine Wise - Rejection Percentage Against Accepted Qty
9.) Code Authentication
Your Mentor :
We know that you have created the Reports, but now the Client needs this Code Authentication Feature added in the Form & Sheet,
Task 4 : Implement the Code authentication feature & add Sample Codes in Control Master and fetch the Data, Now as you add a form field, All columns will change in Report, Google Form Ranger & Master Data
But this is how Real-World problems are, According to Business need we need to rework whatever is needed.
Get the Code Authentication Feature Done ASAP!
Good Job, If you have finished all the tasks till Now !
This is just the beginning of a Real-World experience & if you keep learning like this working on Live Projects, your profile will be very Strong and you would be unstoppable!
10. Premium CV Templates
- Open the Link & Sign Up on Canva Account,
- Edit the CV Template & Download it as PDF,
- You have a Lifetime Free Access to these CVs.
11. Career Boosting Products
You have got Access to the Following Products :
1 . Career Explorer Test - This Test will provide you a Detailed PDF Report on which Sector & Career are suitable for you based upon your Knowledge, Personality & Interests.
2 . Career Hub- Explore all Career Options according to the Sector with their Career Path, Scope of Career & Skills required.
3 . Industry Wise CV Library - With the Premium CV Templates you have earned, you also get an Ideal CV of real Candidates in various Domains which you can refer while creating your own CV.
How to Access?
ID : careermentor@gmail.com
Pass : pass5678
Press the Orange Login Button & Login with the Credentials Given above
Data Analytics Formula Master Program
Your Mentor :
If you want one More Virtual Internship where you would learn real-world use case of Advanced Google Sheets Formulas just like the Video you just watched above,
Then you can Click Here to checkout that Program!
11.) Certificate Request Form
To earn the Certificate, fill the Form Below and you will receive your Certificate on your Email ID soon.
Make Sure you have atleast tried all tasks in the Virtual Internship before requesting for Certificate!
Mentored Minds
Mentoring People Since 2019 ©
www.mentoredminds.com
Headquarted in Pune, Maharashtra India - 411051.
© Mentored Minds Pvt Ltd 2019 All Rights Reserved.
Powered by Mentored Minds