Webpages Re-design Case Study


About the project

The client has some webpages that need to be redesigned and then coded in html. All the content and instructions are provided, the client also provide a website for reference. They would like the website designer with excellent design skills and make the pages look as good as the referenced site, not be an exact copy but also show some originality, also the quality must meet or exceed the referenced site. He requires to be creative, but just something simple, elegant and not too flashy.

CCJK Solution

CCJK assigned a very skilled and professional designer and programmer to complete this job. To make sure of the high quality, the designer designed two types of the pages drafts for the client’s choice firstly, after getting the feedback from the client, we made the updates accordingly.

Then our website designer coded the design to HTML. We use the font to be more comfortable-looking, and change the color for the buttons displayed in the website.

There’s not any problem for CCJK to update several pages to be consistent with the ones they created. Thus, we didn’t proceed to deal with the pages all in one time, we submitted some questions to the client. After getting the feedback about these pages, we made the changes and deliver the final HTML files on time.

About the client

The client is one of the most comprehensive and innovative mental health directory on the web. They purposely keep them free of clutter–so people in need of help can do so with ease and simplicity. The number of people utilizing the internet is expanding each day and video is the next wave. Studies show that people are more likely to engage a website or make a purchase when they can have video contact with the product or service they need. The client has a website which allows people to learn more about mental health professionals in their area so they can make an informed decision about a helping professional.

About CCJK

Founded in 2000 and born for Internet, CCJK is a highly trusted professional e-Services company supported by more than 2,000 talented linguists, engineers, designers and programmers who work as a super organized team. From language translation, desktop publishing, graphic design, software localization, website development, SEO, user guide to corporate eLearning, we provide one stop solution to help client gain competitive edge. We rely on streamlined and sophisticated process to ensure fast and quality delivery. By trusting CCJK’s one stop solution, you need only focus on your core business, win market share and maximize your profit in simplest and soonest way. For more details about CCJK, please visit www.ccjk.com

Database Accessing and manipulating Language SQL (part 1)


Introduction of SQL

SQL, short for Structured Query Language, which is a programming language to access and manipulate databases, meanwhile, it’s as one of ANSI standard. SQL is not only used to access & query data, but also to update and manage the relational database systems. Obviously, the latter function shows its strong performances of Structured Query Language and it’s what critical to administrators.

Statistics shows that SQL is the most important relational database manipulation language now. The influence of Structured Query Language is beyond the database field; it gets attention & adoption in other fields, such as data retrieval of artificial intelligence. Besides, SQL has be embedded in the fourth generation of software development tools.

Structured Query Language exists independently of database itself, and computer, network, operation system used. The SQL-based DBMS products can run in a wide range, from PC, workstation to a variety of computer operation systems (based on WLAN, Minicomputer, mainframe etc.). You can see its good scalability and portability.

Versions of SQL

Although SQL is an ANSI standard, there are different versions of the SQL language. In the beginning, it passed by the American National Standards Institute in October 1986. Then, the International Organization for Standardization (ISO) has issued a formal international standard SQL. In April 1989, ISO SQL89 standard had been proposed with integrity features. And the SQL92 standard was announced in November of 1992 & it divided database into three levels: base set, standard set and complete set.

There are subtle differences in a variety of databases for its support and standard to SQL. However, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.

SQL language contains four parts:

Part One: SQL DDL, stand for Data Definition Language: it includes statements like CREATE, DROP, ALTER, etc.

Part Two: DML, stand for Data Manipulation Language, for example: INSERT statement, UPDATE statement and DELETE statement.

Part Three: Data Query Language, such as SELECT statement.

The last part: Data Control Language, for instance, GRANT, REVOKE, COMMIT, ROLLBACK and other statements.

What can Structured Query Language do

Structured Query Language can execute queries against a database;

Structured Query Language can not only retrieve, also insert and update records in a database;

Structured Query Language can delete records from a database;

Structured Query Language can create new tables in a database and even create new databases;

Structured Query Language can create stored procedures in a database;

Structured Query Language can create views in a database;

Structured Query Language can set permissions on tables, procedures, and views;

Case Study_Summer Jasmine

Summer Jasmine
In this project, it’s really a tough and long process. I met several problems and get stuck many times. But I still precious this experience as I learned a lot from it. Here I want to share it with all of you.

At the past period of this design project, our client said he not prepared to pay for the hours we spent: I have read the designer’s email to you which states that he spent 4 hours on the last revision which was to change the background colour and text colour of the central panel as I requested. I have some knowledge of Photo Shop and know that this is a simple task and can be done by an experienced designer very quickly; I do not accept the designer’s submission of 4 hours and I am not prepared to pay for this time.

This moment what I need is to critical customer issue management. I temporally cancel the last 4 hours and tell him we will clear this situation for him asap. And the client also did some try to prove there are no need to spend so much time.

I consult our PK team and they give me detailed reasons and listed them one by one:
1. The JPEG file sent to client is not a simple image and is multi layered. A URL for the PSD Sample is provided here
2. Everything in the JPEG is modified and adjusted into the layers specified for the positioning of the material in the images. When the design is made from scratch keeping in mind it is custom design it takes time.
3. Multiple options are tried various colors and hues of the colors are tried by the designer artist to maintain the symmetry and aesthetics of the pages.
4. Many of the items in the design were extracted by artist using the pen tool and the edges were then smoothened by him which cost him time.
5. The designer artist says that when a change is to be made in the PSD file then he has to manage the layers in the PSD however working in the simple JPEG will be easy to manage.
And we also provide the Show cause reply from the designer to convince our client. From what they said in their mail, I can learn a lot professional knowledge of PS, etc.

Finally consider this client has got more work for us to do, we could give some leniency to him. From this project, well communicate with the clients and provide necessary technical support and assistance to them is very important in our daily work!

Copywriting, Content Marketing and SEO Writing

Copywriting is the act of writing for the purpose of advertising or marketing a product and it is often designed to call upon the action of the target audience to make a specific move, mostly making a purchase, subscribe to the newsletter, signing up for a web product and so forth. And so call-to-action is the foremost concern when writing an ad copy, otherwise you will just lose the sight of why you are writing it.

What marketers usually find confusing are the differences between copywriting and content marketing. These two concepts, or marketing acts, are well defined by the content you push to the public eyes, though they are more often than not closely associated and viewed as an integral ingredient of each other. Copywriting is more like hardcore selling pieces that calls for people to make a specific action, whereas content marketing is to provide valuable content that may seem impartial or associated with the product or service you are trying to sell to the public, so that people may like the content provided and be willing to receive further information from you with trust and respect built.

This does not mean content marketing is a higher-level type of marketing than copywriting, because for one thing they have very different roles to play, and for another, they cannot be the best of their kind without the other elevating their marketing performance. Imagine that you have some really good content and have made them into actual articles, and without proper copywriting to make it more attractive to a designated group of people, the great stuff would never be able to fulfill the destiny you assign to it. And that is why we are seeing so much great stuff fail to attract a good number of readers. Of course copywriting without good content is shallow and hollow, playing like lame clowns that merely catch people’s eyes yet have no really good stuff to offer. The best copy comes with great content, and vice versa.

SEO writing is the act of marketing writing that serves particular purposes of optimizing the search engine traffic. Unlike copywriting which mainly serves actual human people, SEO writing is for search engines to capture and push up the target web pages in the search result of certain key words. These contents are usually put in much less prominent places or even hidden from website visitors completely. However, as SEO techniques get consolidated, nearly all search engines evolve at an even quicker pace, cutting down the weight of key words densities and other traditional indicators of the relevancy of the web page to the search input. Instead, with the prevalence of social networks, ranking and voting web pages have become feasible and convenient, and therefore it becomes possible search engines could tell whether a web page has truly great content by the votes the page gets. Despite all the negative, SEO writing still matters today, and with solid efforts and proper strategies deployed, you could easily have your web pages rank among the top first.

How to make eye-catching websites?

Good websites share something in common that nearly all of them can give people a strong impression at the first sight.  Having a fine design website is a direct way to promote the traffic of your website and bring your online business and income. However, if your web design is in a mess and far from people’s acceptance, consider your potential clients as virtually invisible on the web.

Many surveys show that new visitors can only spend an average of 15 seconds on each website. If your website is not good enough to hold their interest to for them stay longer, then they move on and you lose a potential client. Below are some tips for designing an eye catching website.

Creative concept
One of the most important aspects is your concept which make main structure of your website. If you already know clearly what your website will be, you will certainly make your website impressive and attractive. Besides, you should identify your market. What kinds of services would your website offer? Try to do some research or survey to know about your clients. How old are they? What do they do? What are their other interests? All of this information can help you to make a website much more useful.

Catchy layout
Most web surfers can take in a whole website’s impression at a glance. A beautiful website was designed with its customers’ acceptance. In order to catch people’s eyes, you’d better create a simple navigation that reflects your website’s content to your customers in a brief introduction. Simple and smooth navigation adds to the convenience of the visitors

Color and shades also captivate the eye. Due to the display effects of different screens, colors which are not browser safe may become worse on different computers, meaning if a computer can’t display a color 100% it will then display the nearest color to it instead. The result is the bad visual appearance. So make sure that you use browser safe colors throughout your site.

Rich content
Using headings and subheadings can improve the highlight of the contents and it can easily let clients find the certain information which they interested or needed. These make your web page appear more organized and likely to be crawled by search engines.

There is a saying goes that good content sells a product. Enrich the content of your website is another way to make website eye-catching. In the meantime, you should always double check your spelling and grammar for any mistake will bring big disasters to not only the contents but also the sales. The consistency of web pages let visitors stay in the same site, so you should arrange you contents consistent with each other. Having a well-designed website will keep visitors in your site longer and more often. Just be sure to give them a good first impression because, as we all know, first impressions are the ones that last.

Making an eye-catching website is a complex task that requires creativity and skill. Maintaining a site that is visually appealing and attractive is of benefit to sales and marketer to establish and maintain the business with clients over the Internet.

Is Facebook IPO Really Overvalued?

Facebook IPOFacebook renewed its price range for its initial public offering at $35-$40, up from $28 to $35 and this would be a record debut for an American company in history.

However, not everyone is as optimistic. There have been voices stating the Facebook IPO could be overvalued as its user base has seen a slowing growth in the last quarters and it is sort of lagging behind in the mobile sphere. Those are apparent challenges Facebook is facing right now, but would either, or both, of them really dwarf the actual value Facebook is holding to, socially and financially?

What Facebook sees as its core mission is to help build and manage social connections over the Internet in a better way. I mean, this is in no way a simple business endeavor, but a revolutionary challenge on how people interact with each other in the web 2.0 era. Soaring and sustained user growth over the 8 years since its early days in a Harvard dorm is a good testimonial for Facebook’s revolutionary status. It is addictive and well fits the universal humanity inside every one of us that longs for being socially involved.

A prevalent argument is that Facebook has seen a slower user growth, and it is the foremost reason why people get skeptical about the young tech giant’s future. Well, a slower user growth is bad, but as it still much surpasses the birth rate of most countries, it is literally on the good run. Others have been arguing that Facebook’s being blocked outside of China puts it in an unfavorable position in market potential. I on the contrary think it as a perfect example of enormous possible market potential Facebook might achieve in the future. Now that Facebook is the most prevailing social networking site attracting billions of visitors even without access to the largest Internet market in the world, what would the landscape be like if Facebook could successfully put China under its reign some day? And that is what we call potential, literally.

Another good reason why Facebook will not likely fade away from people’s eyes comes that it cannot be recreated. I recall clearly a year ago people generating and spreading Google+ buzz and discussing wildly about Facebook being replaced, and what now? Google+ is now no more than a ghost town of no man’s territory. I am not saying I had the insight or whatsoever, but the minute I started using Google+, I had deemed it no match for Facebook, at all.

Facebook is an ecosystem where extensive businesses rely on. The overall turnover they generate each year is staggering trillions of dollars. And as in the very foreseeable future, they don’t have alternatives to turn to. Zynga’s up and downs well portrays this relationship.

All strengths of Facebook come from its user stickiness. Interactive functionalities and addictive entertainment are seamlessly integrated with the social networking basics Facebook is built on, and those features in turn have enforced the social side of the website. People just can’t help logging onto the site and posting updates. To sum it up, the heat among its users could easily be stirred up on Facebook.

“I grew up with the Internet, when I was in middle school I was using search engines like Google and Yahoo. I thought it was the most amazing thing. Now you have access to all this information. The thing that was missing was just people” said Mark Zuckerberg. This pretty much explains what Facebook aims to function as.

Instead of disputing over whether the Facebook IPO is overvalued, we’d better start a new discussion on if it is under-valued indeed. Exceptional user stickiness, the uniqueness and the affiliate ecosystem all add up to the irreplaceability of Facebook and its IPO sure seems a perfect deal to investors seeking good returns.

Case Study – Jebsen Industrial

About Jebsen Industrial

Jebsen is a 100+ years old family enterprise whose history can be traced back to the end of the 19th century. From a broad spectrum of consumer, industrial, beverage and luxury products, Jebsen is responsible for bringing unparalleled quality to the regional markets, adapting to the rapidly changing business landscape in East Asia.

Jebsen Industrial business unit focus on China market helping clients in the Industrial sector succeed in Greater China.


1. Jebsen Industrial wants a language service provider who is an expert and knows how to translate the 158 product groups from their 144 principals across 21 industries.

2. The client needs to publish their advertising and identity guide etc marketing materials to align with their marketing activities in the Greater China market.

3. They need to translate their news and events also upload them onto their official website in multilingual version on weekly basis


1. CCJK uses only the translators who are really expert in the industries they are translating. CCJK also understands the client need actually a copywriting rather than simple translation for the client’s marketing materials. In other words, CCJK is doing marketing oriented translation which aligns with the client’s marketing needs.

2. CCJK use experienced Desktop Publishing (DTP) operators who work on the very original formats such as InDesign and Framemaker to seamlessly streamline and expedite the translation and publishing process.

3. CCJK’s designers and engineers operate the client’s CMS system to design the layout and upload the client’s news, events, industrial products and product group’s etc. web pages in almost real-time basis.

4. CCJK creates and maintains a complete set of Translation Memory (TM) and glossary for the client’s project.


1. The client has an expert who can take care of their translation needs in a broad spectrum of industries and products well.

2. The translation result is up to the client’s upmost standard of copywriting quality which helps the client’s marketing activity.

3. Update and publishing news, events and other marketing activities is easy and real-time.


Founded in 2000 and born for Internet, CCJK is a highly trusted professional e-Services company supported by more than 2,000 talented linguists, engineers, designers and programmers who work as a super organized team. From language translation, desktop publishing, graphic design, software localization, website development, SEO, user guide to corporate eLearning, we provide one stop solution to help client gain competitive edge. We rely on streamlined and sophisticated process to ensure fast and quality delivery. By trusting CCJK’s one stop solution, you need only focus on your core business, win market share and maximize your profit in simplest and soonest way. For more details about CCJK, please visit www.ccjk.com

6 Easy Steps to Website Localization

To open up new revenue sources of a website, a most effective approach proves to be to enlarge its direct audience, so as to gain extra exposure and eventually lever the website’s profitability through advertising or its premium services provided. It is reported that non-English speakers take up 64% of the overall netizen population and they without exception prefer browsing websites in their own language for both business purposes and private online activities. Ergo, website localization gains its ground in the industry.

Since websites are structured using many different technologies, website localization can be a much more complex process than document translation and may require technical support from web engineers for procedures like separating localizable files from the source code, etc. To localize a website could be as time-consuming as building a new site, and, therefore, building streamlined website localization workflow now seems an inevitable trend.

The following is a systemized website localization process deployed at CCJK and based on its previous experience in various localization projects with discrepant requirements.

1. File Analysis

To seamlessly localize a website, source files of the original website must be provided, so that the localizer can well assess the technical difficulty, workload, lead time and other engineering aspects of a website localization project.

2. Project Preparation

To initiate the website localization project, the localizable resources should be extracted from the source files of the original site, including all the textual contents, user interface, images, etc. A terminologies glossary and other reference files or instructions should be prepared as well.

3. Translation

The resource files for software localization will be subcategorized and sent to professional translators with pertinent specialties for language translation. For some web pages concerning the core functionality of the website, further technical support from the website owner’s engineers might be needed.

4. Review & Editing

After the translation and proofreading by the translators are done, test engineers will run in-context review of the translated contents including the user interface and images and make possible further editing of the translated files to ensure the accuracy and suitability of the translation.

5. Translation Memory Updating

When the language side of the website localization project is finished, the translation memory will be updated using the translated content in the new files.

6. Operational Test & Bug Fixing

The localized version of website will be structured using the translated files, and test engineers will test the website functionality and make possible repairs if necessary.

Twitter is a Soon-to-be Cyber Failure

Twitter is a Soon-to-be Cyber Failure

The first time I have heard of the name of Twitter was in 2008, when Barrack Obama mentioned its name several times in public speeches as part of the presidential campaign to reiterate that American people had retained exceptionally good innovation even under the least favorable economic circumstances. Honestly, I was so intrigued and tried several times to find out what was so great about this website, but unfortunately I could not access this site because the Internet filtering system in China blocked us off such prevailing social websites for unknown reasons.

In the following months I learned that Twitter was a micro-blogging platform where people got to post instantaneous messages to a certain group of people. I was a little disappointed upon learning that and kept wondering what was the magic power that could help inhale hundreds of millions of netizens and even made Obama take it as a good cyber example of American spirit.

I found my skepticism toward Twitter well grounded when I for the first time got to actually use it. The registration was convenient and user interface friendly, and the suggested groups to follow did look interesting to me. But only minutes after I finished all the steps and started to check other people out, I found most of the “twits” nothing spectacular but spammy. Why should I care if a total stranger was at the prom or taking a dump. All did not seem to make much sense to me. Other than the meaningless nagging, there were cheesy advertisement too, all making Twitter as an annoying place as an Asian train station where you would get constantly disturbed by possible swindlers. When I thought following industrial giants might be a good approach to keep up to their latest activities, I chose some respectable names in intelligent terminals, which business sector I was in, only to find chatty dialogues that I absolutely had no clue about.

There are some good features about Twitter though. One major reason that I think Twitter sucks and is useless is probably I do not have circles of friends using it. If I was sharing the twits with some of my closest friends, it might be fun to keep track of what they were up to, either experiencing major life changes or coping with daily trivia. Maybe that is why weibo.com, an imitation of micro-blogging site developed by Sina, can also prevail in China.

Although later I found something worth following, mostly news agencies and television channels, Twitter is far less good than I expected. Since inviting friends to create my very own little circle on Twitter is not likely to happen for two reasons: first, it is still blocked off by the Internet filtering system and, second, people around me are already loyal users of weibo.com, the future of Twitter in China can be extremely bleak. And to be honest, Twitter is far from being anything revolutionary like StumbleUpon, even though it ranks higher on Alexa.

Q & A – Website Re-Design Process

Question: I would like to ask your opinion about a new project I have that has me a little overwhelmed. We are in the process of doing a complete re-design of our website. We are going to try to save the existing copy so we don’t incur too many new translation costs but the copy will be edited down quite a bit. We are going through a new branding process so I am reassessing all of the content and layout of our product, market, service, company and education pages as well as adding some new end user content (best way to exercise on our equipment). I am meeting with designers and a copy writer but they all want a wire frame (schematic) of the website to work with. I don’t have that type of document nor have I ever created one (nor would I have the time to create one!). I was wondering if you had someone that we could contract to create a wire frame of our website if I were to send you the site map. Could you please let me know what you think of this type of project and if it’s feasible, how long it would take and what the cost would be to create?

 Answer: Thank you very much for your trust by offering the good opportunity to participate in your website re-design process. This is actually fitting in well with our expertise area.

After studying your needs and the estimated work scope with our team, I believe the following is what our team can be of help:

  1. Create a website wireframe for your designer and copywriter as requested below. This is actually the first step of designing a website and we did 3 to 4 projects averagely every month. Attached please find one of our recent wireframe (prototype) work. Please feel free to review and let me know if this is what your designer and copywriter want. For similar project, we usually can complete the wireframe work in one week. I believe we need several rounds of talk and feedback based on the understanding of your new branding process, so I believe 2-3 weeks will be needed for this stage. As for the cost, I will let you know after our team assessing all of the content and layout of your product, market, service, company and education pages
  2. Since we have an experienced team of designers and programmers, I would like to take the chance to offer you an one-stop solution by taking up the full service of web design. Means we will study your needs and design a website with both the layout and functionality work well. We can make countless modification until you are fully satisfied. Please let me know if you are interested and I will send you a questionnaire that need your input before working out a cost estimation based on the work scope and specification.
  3. After the re-designed website is ready with the new content is finalized, we can help to translate the new site into multi languages in a cost efficient way. – We use Computer Aided Tool (CAT) to create and maintain a Translation Memory (TM) for your projects. Every translation unit will be saved in TM. One time translated, multi-time used. Thus save your cost while enhancing quality and consistency. Actually for all translation projects you awarded to us during the past, we have already created and maintained a TM for you. We need only run against the TM to pick up the repeated words and sentences and don’t have to translate them from scratch thus minimize your cost. For any materials that were not translated by our team, we can create a TM for you if you can provide both the source English text and the existing translation. We will charge you at hourly rate to create the TM. By doing so we can focus on your new and edited copy while saving the existing copy thus don’t incur too many new translation costs.

In general, with our ten years of experience in website localization, we are able to provide you with one-stop solution from website design to localization by closely working with your team. Please feel free to let me know if you have any questions on above.