How to use AI for job planning? Little Raccoon analyzes data from 10,000 graduates to provide the answer.

Graduation anxiety is not a new phenomenon this year.

A few days ago, my cousin chatted with me. She just graduated with a degree in Chinese Language and Literature. During her internship, she did some new media operations work, but she still hasn't found a job. She has sent out dozens of resumes but only received two replies.

She asked me, "Is it because my major and I didn't graduate from a top university that I have virtually no chance? Everyone says there are more opportunities in first-tier cities, so why don't I try my luck in Beijing?"

To be honest, I'm not too keen on giving advice directly, not because I don't want to help, but because too much "experience" is untenable—a path to success that one person describes may not work at all for another.

I have decided:Find the answer with data, not by feeling.!

I found a dataset containing 10,000 recent graduates' employment records to answer my cousin's question with real data, and also to...AII made her a "job search plan".

In this post, I'll share the process, hoping it can provide some reference for everyone.

This survey contains data on the employment destinations of 10,000 recent college, graduate, and doctoral graduates.

Looking at them one by one would be too time-consuming, and it wouldn't necessarily reveal the inherent connections between the data.

We can directly open the Office Raccoon app and select Data Analysis from the left-hand menu.

Official website: Office Raccoon

Click the raccoon icon in the bottom left corner of the chat box.

You can create or use the officialrecommendThe instructions make it provide assistance that is more suitable for the usage scenario.

The official guidelines are comprehensive, covering industries such as education, healthcare, and finance. Our focus here is on examining the impact of various factors on graduate employment; you can add more information here.Attribution analysisexpert.

Click to upload the entire data table.

After the file is successfully uploaded, a real-time preview is available on the right side of the page, and it's very clear. The layout is much more pleasing to the eye than in Excel.

We can clearly see that this data records the graduate's gender, major, education level, post-graduation destination, industry of employment, expected salary, city of work, satisfaction rating, and whether they have internship experience.

Before analyzing the data, let's have the office raccoon check it out.

Prompt wordsPlease check this data for missing values, obvious errors, or inconsistent formatting.

After examining the data step by step, the office raccoon gave me the following conclusion:

Missing values: There are no missing values in the data; all columns contain complete data.

Expected Salary: All data in the "Expected Salary" column are in the correct format, are numeric, and have no outliers.

Satisfaction rating: All "satisfaction ratings" were within a reasonable range (1 to 5), and no outliers were found.

Gender: The values in the gender column are only "male" and "female", and no other outliers were found.

Internship experience: This column only has "Yes" and "No" values, and no other outliers were found.

Duplicate ID: There are no duplicate IDs in the data.

In summary, the data contains no obvious errors or inconsistent formats, and the data quality is good.

The data is of good quality and there's nothing that needs to be modified.

If you encounter situations such as missing or duplicate data, you can directly ask Office Raccoon to help you adjust them to ensure the accuracy and reliability of the analysis results.

Office RaccoonintelligentIts ability to process data, even without being explicitly instructed to examine the data, will...automaticintelligentIdentify, clean, and preprocess the data.

Next, I directly posed my cousin's question to the office raccoon.

Prompt wordsThis is data on the employment choices of this year's graduates. I want to show: what factors influence job satisfaction, and specifically how they influence it. The impact of work city on job satisfaction, and the impact of major and education level on job satisfaction. Are women finding it harder to find jobs?

The office assistant will break down my needs, analyze them one by one, and then give me a concise and clear summary.

• Work cities: Hangzhou, Xi'an and Shenzhen have relatively high job satisfaction, while Chengdu has relatively low job satisfaction.
• Major and Education: Marketing and Clinical Medicine majors have higher job satisfaction, while those with master's degrees have the highest job satisfaction. (Gender and job difficulty are also relevant.)
• There was little difference in the distribution of employment destinations between males and females, and females did not have significantly more difficulty finding jobs.

at the same time,It will also generate some guiding questions below the answer to help us uncover more useful data connections.

For example, what is the average salary for graduates from different majors?

What are the job prospects for Chinese language majors?

These conclusions,We can make the Office Raccoon into a visual chart for direct display.

Can't writePrompt wordsFriends, don't worry. Whether it's data interpretation, trend prediction, data cleaning, or data visualization,The office raccoon has thoughtfully prepared the corresponding...Prompt wordstemplate~

We just need to fill in the words according to the requirements.

Prompt wordsThis is a document on college graduates' employment choices. This data is used to support the analysis of college graduate employment. Please read the data in the document, perform a descriptive analysis, and create a bar chart to observe the impact of academic qualifications on employment quality for Chinese language majors.

It offers both interactive and static charts, and also supports direct download as an image.

We can also enter it directly:

Prompt wordsDistribution of professional needs in different cities.

Office Little Raccoon will adjust its display based on the type of data and purpose of the information you want to present.automaticGenerate the appropriate chart type.

Here, it directly generates a heat map showing the distribution of professional needs in different cities.

Seeing this, my cousin's doubts were all answered.

After understanding the trends, it is even more important to understand yourself.

I've compiled my cousin's information to create a comprehensive job search plan.

Still using the Office Raccoon, let's click on Task Planning. Enter...Prompt words:

Prompt wordsI am a recent graduate with a bachelor's degree in Chinese Language and Literature from a regular university. I have internship experience in new media operations and am located in Wuhan. My desired position is in new media operations, and I am open to any salary. Please create a comprehensive job search plan based on my situation.

The task planning feature of Office Raccoon is quite interesting. It doesn't just give you the task to complete directly. Instead, it encourages you to think deeply first, ask for more details, and then move on to the next step.

The office raccoon continued to ask me what achievements I had made during my internship and whether I needed its help in generating a portfolio.

Next, the office raccoon directly provided a list of goals:

1. Identify and define core competencies and differentiating advantages for content planning.

2. Portfolio optimization and visualization

3. Job search channel development and interview preparation

4. Integrate and output the final solution

We click "Execute".Office Raccoon ClubautomaticPerform the tasks, completing each item on the list one by one.

First, I searched online for major internet companies andMCN AgencyNew Media OperationsJob competency requirementsA comparison was made. Then, based on these requirements, a plan was developed to strengthen the corresponding capabilities.

The second step involved designing the Office Raccoon.Portfolio templateThey even provided the webpage code, which you can just copy and use—how thoughtful!

The page layout is quite good, and the key information that needs to be displayed in the portfolio is clear at a glance.

Next, Office Raccoon searched and compiled recruitment information and referral websites from major local companies and MCN agencies in Wuhan.The recruitment period, referral code, and referral link are all clearly stated.That's amazing!

For these job openings, Office Raccoon has also thoughtfully prepared...Three types of speaking templates and portfolio explanation strategies.

This is perfect for someone like me who gets so nervous during interviews that I don't know what to say.

Everything was ready, and the office assistant even generated a job search roadmap. Following my instructions, a one-month execution calendar was created.

I analyzed my cousin's major, educational background, and employment situation in different cities; I also used...AIThe tool helped her create a practical job search path plan.

But that's not all.

This content shouldn't just exist in my head or in a few chat logs.

If it could be organized into a well-structured document, not only could she use it, but other friends at similar stages could also refer to it.

On the document editing page, we can see that Office Raccoon has these capabilities. Let's first click to let Office Raccoon draft an outline.

We can directly copy and paste the answers and analyses from the previous post by Office Raccoon to improve the document content.

During the sorting process,You can click the "+" sign on the page at any time, select "Summon the Bear," and summon the office raccoon to help you generate content.

In the chat box on the left, we can also upload data and let it analyze or generate content.The generated answer supportsOne-clickIt's very convenient to insert into a document.

Let's take a look at the final generated document together.

Link: https://office.xiaohuanxiong.com/workspace/e8a36c27-9876-46b1-b492-09245b40e841/abbc600c-8d4a-4c9f-bdaf-097b5e1c905d

(Click the link above to view the full document)

To be honest, I didn't expect it to be much better at first.intelligent".

after all,"AIThe term "data analysis" has been overused by countless tools over the past year. They either stop at generating shallow charts or just throw a bunch of code at you, which looks impressive but isn't actually that convenient.

Until this time, when I helped my cousin with her graduation and employment analysis,Reading data, creating charts, extracting insights, and generating documents—the entire process was done using Office Raccoon, and the experience exceeded my expectations.

From data analysis to structured output, it relies not on generative power, but on comprehension.

This isAIA typical direction for product development towards "executability". Generative approach.AIOnly by immersing oneself in the scenario can one become a productive force.

This might be the real reason.AIThe true value to content creators and knowledge workers:

It's not about making you smarter, but about making you more aware of what to do next.

at present,Office Raccoon not only supports a web version, but also can be used on desktop and mini-program platforms, and supports private deployment for enterprises..

Official website: Office Raccoon